home / fivethirtyeight

Menu
  • GraphQL API

sandy-311-calls/sandy-311-calls-by-day

Table actions
  • GraphQL API for sandy-311-calls/sandy-311-calls-by-day

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

28 rows where NYPD = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: ACS, BPSI, CAU, CHALL, DEP, DOB, DOE, DOF, DOHMH, DPR, HPD, HRA, MOSE, NYCEM, NYCHA, NYCSERVICE, NYSDOL, SBS, NYSEMERGENCYMG, total

Link rowid ▼ date NYC-3-1-1 ACS BPSI CAU CHALL DEP DOB DOE DOF DOHMH DPR FEMA HPD HRA MFANYC MOSE NYCEM NYCHA NYCSERVICE NYPD NYSDOL SBS NYSEMERGENCYMG total
34 34 11/24/12 0 0 3 25 164 4 25 2 0 0 31 0 0 0 0 0 9 4 25 2 0 17 0 311
38 38 11/28/12 0 5 2 31 337 0 58 9 0 0 46 0 0 0 0 0 4 6 16 2 361 22 0 899
51 51 12/11/12 0 0 1 17 132 1 15 2 61 9 0 0 0 48 0 1 9 1 4 2 109 11 0 423
61 61 12/21/12 0 0 0 2 83 2 15 86 25 7 0 0 6 0 0 2 2 4 3 2 26 3 0 268
67 67 12/27/12 0 0 0 2 93 1 16 1 25 4 0 0 15 0 0 0 2 1 4 2 25 7 0 198
68 68 12/28/12 0 1 0 0 72 1 21 0 28 11 0 0 13 0 0 2 1 4 5 2 10 6 0 177
94 94 1/23/13 0 0 0 1 27 0 10 2 4 5 0 0 8 0 0 0 2 0 5 2 8 1 0 75
101 101 1/30/13 0 2 1 1 34 1 13 0 57 1 0 0 18 0 0 1 4 0 8 2 4 12 0 159
129 129 2/27/13 0 0 1 0 20 1 11 0 24 3 0 0 22 0 0 1 0 0 7 2 5 6 0 103
135 135 3/5/13 0 1 1 0 7 0 8 0 4 2 0 0 10 0 0 0 0 0 5 2 4 1 0 45
137 137 3/7/13 0 0 0 0 3 1 6 0 15 0 0 0 6 0 0 2 1 0 5 2 3 6 0 50
138 138 3/8/13 0 0 0 0 4 0 3 0 18 3 0 0 10 0 0 1 0 1 2 2 2 3 0 49
157 157 3/27/13 0 0 0 0 16 0 5 0 13 0 0 0 15 0 0 0 0 0 9 2 1 6 0 67
162 162 4/1/13 0 0 0 0 8 1 3 0 11 0 0 0 12 0 0 0 1 1 9 2 2 3 0 53
269 269 7/17/13 0 0 0 0 4 1 0 0 1 1 0 0 0 0 0 1 0 0 4 2 0 5 11 30
293 293 8/10/13 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 1 4
324 324 9/10/13 0 0 0 0 2 0 0 0 2 0 0 0 0 0 0 1 0 0 2 2 0 1 10 20
352 352 10/8/13 0 0 0 0 1 0 3 0 0 0 0 0 0 0 0 2 0 0 1 2 0 3 4 16
359 359 10/15/13 0 0 0 0 4 1 2 0 4 0 0 0 0 0 0 2 0 0 2 2 1 0 7 25
401 401 11/26/13 0 0 0 0 7 0 1 0 1 0 0 0 0 0 0 0 0 0 0 2 0 0 7 18
461 461 1/25/14 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 2 0 0 1 5
560 560 5/4/14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 2
612 612 6/25/14 0 0 0 0 2 0 0 0 16 0 0 0 0 0 0 0 0 0 0 2 0 2 3 25
709 709 9/30/14 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 2 0 0 3 7
922 922 5/1/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 2
960 960 6/8/15 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 2 0 0 1 4
977 977 6/25/15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 3 5
1361 1361 7/13/16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 2 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "sandy-311-calls/sandy-311-calls-by-day" (
"date" TEXT,
  "NYC-3-1-1" INTEGER,
  "ACS" INTEGER,
  "BPSI" INTEGER,
  "CAU" INTEGER,
  "CHALL" INTEGER,
  "DEP" INTEGER,
  "DOB" INTEGER,
  "DOE" INTEGER,
  "DOF" INTEGER,
  "DOHMH" INTEGER,
  "DPR" INTEGER,
  "FEMA" INTEGER,
  "HPD" INTEGER,
  "HRA" INTEGER,
  "MFANYC" INTEGER,
  "MOSE" INTEGER,
  "NYCEM" INTEGER,
  "NYCHA" INTEGER,
  "NYCSERVICE" INTEGER,
  "NYPD" INTEGER,
  "NYSDOL" INTEGER,
  "SBS" INTEGER,
  "NYSEMERGENCYMG" INTEGER,
  "total" INTEGER
);
Powered by Datasette · Queries took 23.536ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette