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 MOSE = 3

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: ACS, BPSI, CAU, DEP, DOB, DOE, DOHMH, HRA, NYCEM, NYCHA, NYCSERVICE, NYPD, 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
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
66 66 12/26/12 0 0 1 1 88 1 11 0 34 4 0 0 18 0 0 3 2 0 4 0 29 3 0 199
79 79 1/8/13 0 0 1 0 66 0 7 0 7 5 0 0 12 0 0 3 1 1 1 0 22 5 0 131
81 81 1/10/13 0 0 0 1 115 2 11 0 6 4 0 0 8 0 0 3 2 1 1 0 20 2 0 176
114 114 2/12/13 0 0 0 0 25 2 11 0 37 2 0 0 21 0 0 3 0 0 10 0 7 7 0 125
121 121 2/19/13 0 0 1 0 24 1 10 1 13 2 0 0 23 0 0 3 0 0 24 0 4 8 0 114
130 130 2/28/13 0 1 0 0 20 1 10 0 24 1 0 0 16 0 0 3 0 0 6 1 5 5 0 93

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