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

7 rows where NYCHA = 3

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: ACS, BPSI, CAU, DEP, DOB, DOE, DOF, DOHMH, DPR, HPD, MOSE, NYCEM, NYCSERVICE, NYPD, NYSDOL, SBS

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
31 31 11/21/12 0 0 5 23 191 0 42 14 0 0 3 0 0 0 0 0 8 3 0 8 0 4 0 301
33 33 11/23/12 0 0 7 27 189 0 43 1 0 0 52 0 0 0 0 0 4 3 42 3 0 4 0 375
43 43 12/3/12 0 1 1 23 221 3 53 8 90 4 45 0 0 0 0 0 7 3 11 0 129 8 0 607
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
64 64 12/24/12 0 0 0 1 49 0 9 0 12 1 0 0 9 0 0 2 2 3 8 1 17 1 0 115
73 73 1/2/13 0 0 0 1 107 2 10 9 14 6 0 0 15 0 0 2 1 3 3 1 35 4 0 213
75 75 1/4/13 0 0 0 4 94 0 7 0 24 6 0 0 9 0 0 0 2 3 3 0 21 1 0 174

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 463.869ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette