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

12 rows where NYCHA = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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
35 35 11/25/12 0 0 1 13 134 2 17 11 0 0 18 0 0 0 0 0 6 2 71 5 0 18 0 298
45 45 12/5/12 0 3 2 19 158 3 37 5 87 6 37 0 0 0 0 4 16 2 7 3 113 6 0 508
47 47 12/7/12 0 1 1 12 148 1 25 1 48 4 21 0 0 1 0 7 7 2 6 3 117 11 0 416
49 49 12/9/12 0 0 3 5 72 1 10 0 6 1 0 0 0 16 0 0 4 2 4 0 42 0 0 166
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
71 71 12/31/12 0 0 1 1 61 1 8 0 21 5 0 0 6 0 0 4 0 2 0 0 14 8 0 132
74 74 1/3/13 0 2 0 0 84 1 6 2 18 6 0 0 10 0 0 1 6 2 4 1 22 3 0 168
78 78 1/7/13 0 0 2 0 98 2 8 3 15 12 0 0 9 0 0 2 2 2 1 0 24 4 0 184
82 82 1/11/13 0 0 1 0 138 1 12 2 8 3 0 0 9 0 0 0 1 2 4 0 5 2 0 188
96 96 1/25/13 0 0 0 2 47 0 9 0 17 1 0 0 14 0 0 1 0 2 3 0 10 18 0 124
213 213 5/22/13 0 0 0 0 10 1 0 0 0 0 0 0 6 0 0 2 1 2 1 0 0 1 22 46
236 236 6/14/13 0 0 0 0 5 1 4 0 3 0 0 0 0 0 0 0 0 2 3 0 0 2 14 34

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