sandy-311-calls/sandy-311-calls-by-day

Table actions

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

31 rows where BPSI = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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
41 41 12/1/12 0 0 1 14 131 2 20 6 11 7 21 0 0 0 0 0 10 5 6 1 68 1 0 304
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
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
46 46 12/6/12 0 0 1 36 206 4 28 5 51 1 42 0 0 0 0 7 3 8 12 9 153 9 0 575
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
51 51 12/11/12 0 0 1 17 132 1 15 2 61 9 0 0 0 48 0 1 9 1 4 2 109 11 0 423
53 53 12/13/12 0 1 1 20 111 3 11 7 48 11 0 0 0 65 0 2 2 1 8 3 96 5 0 395
54 54 12/14/12 0 2 1 15 111 3 31 4 40 10 0 0 0 81 0 6 3 5 12 3 65 4 0 396
60 60 12/20/12 0 0 1 0 59 1 9 4 38 7 0 0 0 0 0 1 3 0 3 3 32 2 0 163
62 62 12/22/12 0 0 1 1 71 0 2 0 5 3 0 0 0 0 0 0 3 0 1 0 13 0 0 100
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
69 69 12/29/12 0 0 1 1 81 1 2 1 6 0 0 0 3 0 0 2 1 1 0 0 8 0 0 108
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
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
80 80 1/9/13 0 0 1 0 79 1 14 2 21 4 0 0 8 0 0 2 2 0 4 0 11 3 0 152
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
89 89 1/18/13 0 0 1 1 59 0 9 1 10 1 0 0 22 0 0 1 0 1 3 1 13 2 0 125
93 93 1/22/13 0 0 1 0 69 1 9 2 18 2 0 0 21 0 0 1 4 1 3 1 22 1 0 156
99 99 1/28/13 0 1 1 0 44 0 12 1 34 4 0 0 12 0 0 4 1 1 3 0 10 20 0 148
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
101 101 1/30/13 0 2 1 1 34 1 13 0 57 1 0 0 18 0 0 1 4 0 8 2 4 12 0 159
103 103 2/1/13 0 0 1 2 35 0 13 0 71 2 0 0 16 0 0 0 1 0 11 0 6 2 0 160
108 108 2/6/13 0 0 1 1 31 2 4 0 38 0 0 0 25 0 0 1 0 1 7 0 8 6 0 125
115 115 2/13/13 0 0 1 2 26 1 3 1 26 1 0 0 18 0 0 0 0 1 11 1 8 2 0 102
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
129 129 2/27/13 0 0 1 0 20 1 11 0 24 3 0 0 22 0 0 1 0 0 7 2 5 6 0 103
131 131 3/1/13 0 0 1 0 14 0 4 0 20 4 0 0 14 0 0 0 0 1 6 0 2 1 0 67
135 135 3/5/13 0 1 1 0 7 0 8 0 4 2 0 0 10 0 0 0 0 0 5 2 4 1 0 45
148 148 3/18/13 0 0 1 0 5 0 2 0 5 0 0 0 8 0 0 0 1 0 6 1 3 1 0 33
155 155 3/25/13 0 0 1 0 7 2 3 0 6 0 0 0 11 0 0 0 0 0 8 0 3 1 0 42

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
);