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
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
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 );