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
5 rows where NYPD = 4
This data as json, copyable, CSV (advanced)
Suggested facets: ACS, BPSI, CAU, DEP, DOE, DOHMH, DPR, HPD, HRA, MOSE, NYCEM
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36 | 36 | 11/26/12 | 0 | 0 | 4 | 38 | 578 | 2 | 47 | 30 | 0 | 0 | 54 | 0 | 0 | 0 | 0 | 0 | 18 | 6 | 93 | 4 | 1254 | 52 | 0 | 2180 |
| 42 | 42 | 12/2/12 | 0 | 0 | 1 | 7 | 120 | 0 | 12 | 7 | 4 | 4 | 15 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 9 | 4 | 49 | 1 | 0 | 234 |
| 44 | 44 | 12/4/12 | 0 | 3 | 4 | 11 | 167 | 5 | 42 | 7 | 92 | 4 | 37 | 0 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | 4 | 122 | 4 | 0 | 518 |
| 59 | 59 | 12/19/12 | 0 | 0 | 0 | 7 | 80 | 2 | 18 | 1 | 20 | 14 | 0 | 0 | 0 | 41 | 0 | 8 | 2 | 2 | 6 | 4 | 57 | 5 | 0 | 267 |
| 100 | 100 | 1/29/13 | 0 | 2 | 1 | 0 | 52 | 0 | 9 | 0 | 31 | 6 | 0 | 0 | 28 | 0 | 0 | 0 | 1 | 1 | 1 | 4 | 13 | 19 | 0 | 168 |
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 );