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 BPSI = 4
This data as json, copyable, CSV (advanced)
Suggested facets: ACS, CAU, DEP, DOF, DOHMH, DPR, HRA, MOSE, NYCEM, NYCSERVICE, NYPD
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28 | 28 | 11/18/12 | 0 | 0 | 4 | 38 | 91 | 0 | 30 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 4 | 0 | 0 | 0 | 0 | 0 | 207 |
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 |
39 | 39 | 11/29/12 | 0 | 5 | 4 | 27 | 283 | 0 | 65 | 6 | 32 | 3 | 42 | 0 | 0 | 0 | 0 | 0 | 12 | 7 | 11 | 5 | 233 | 12 | 0 | 747 |
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 |
57 | 57 | 12/17/12 | 0 | 1 | 4 | 15 | 101 | 3 | 31 | 2 | 68 | 9 | 0 | 0 | 0 | 331 | 0 | 3 | 5 | 1 | 8 | 3 | 81 | 6 | 0 | 672 |
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 );