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

1,783 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
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
102 102 1/31/13 0 2 0 1 46 0 11 1 86 0 0 0 21 0 0 0 2 0 13 1 11 5 0 200
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
104 104 2/2/13 0 0 0 1 26 0 4 0 12 1 0 0 8 0 0 0 0 0 4 0 3 1 0 60
105 105 2/3/13 0 0 0 0 9 1 1 0 6 0 0 0 3 0 0 0 0 0 3 0 2 0 0 25
106 106 2/4/13 0 0 0 1 40 0 10 0 50 1 0 0 22 0 0 1 1 0 9 0 14 8 0 157
107 107 2/5/13 0 0 0 0 36 2 6 0 30 0 0 0 17 0 0 0 2 0 7 0 10 7 0 117
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
109 109 2/7/13 0 2 0 4 32 1 7 0 28 3 0 0 26 0 0 0 0 0 5 3 7 6 0 124
110 110 2/8/13 0 0 0 0 30 1 0 0 19 0 0 0 21 0 0 1 0 0 3 1 5 0 0 81
111 111 2/9/13 0 0 0 0 5 1 3 0 6 2 0 0 8 0 0 0 0 0 0 0 2 1 0 28
112 112 2/10/13 0 0 0 1 14 0 0 0 4 0 0 0 7 0 0 0 0 0 3 1 1 1 0 32
113 113 2/11/13 0 0 0 0 33 2 5 0 27 2 0 0 27 0 0 0 1 0 7 1 5 11 0 121
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
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
116 116 2/14/13 0 0 0 0 13 1 8 0 26 4 0 0 6 0 0 4 0 0 17 0 3 8 0 90
117 117 2/15/13 0 0 0 2 29 2 5 0 11 1 0 0 12 0 0 1 2 0 21 3 7 6 0 102
118 118 2/16/13 0 0 0 0 12 0 1 0 2 1 0 0 7 0 0 1 1 0 10 1 0 2 0 38
119 119 2/17/13 0 0 0 0 10 0 1 0 1 3 0 0 2 0 0 0 0 0 11 1 0 0 0 29
120 120 2/18/13 0 0 0 0 10 0 2 0 2 0 0 0 14 0 0 0 1 0 12 1 4 0 0 46
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
122 122 2/20/13 0 0 0 3 24 0 6 1 18 3 0 0 25 0 0 2 0 1 18 1 7 5 0 114
123 123 2/21/13 0 0 0 2 37 1 7 1 13 3 0 0 22 0 0 2 2 0 12 0 0 2 0 104
124 124 2/22/13 0 0 0 0 31 1 9 0 9 4 0 0 11 0 0 0 1 0 8 1 4 2 0 81
125 125 2/23/13 0 1 0 0 9 0 1 0 0 3 0 0 7 0 0 0 0 0 4 0 1 0 0 26
126 126 2/24/13 0 0 0 0 6 0 3 0 3 1 0 0 5 0 0 1 0 0 4 0 2 0 0 25
127 127 2/25/13 0 0 0 0 16 1 6 0 18 2 0 0 27 0 0 1 1 0 5 1 4 7 0 89
128 128 2/26/13 0 0 0 0 17 0 10 0 14 1 0 0 29 0 0 0 1 0 10 1 4 7 0 94
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
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
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
132 132 3/2/13 0 0 0 0 7 2 0 0 1 2 0 0 6 0 0 0 1 0 3 0 0 0 0 22
133 133 3/3/13 0 0 0 0 2 0 1 0 0 2 0 0 7 0 0 1 1 0 5 0 2 0 0 21
134 134 3/4/13 0 0 0 0 8 0 15 1 20 2 0 0 18 0 0 0 0 0 6 0 1 4 0 75
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
136 136 3/6/13 0 0 0 0 4 0 4 0 22 3 0 0 16 0 0 2 1 0 2 0 1 3 0 58
137 137 3/7/13 0 0 0 0 3 1 6 0 15 0 0 0 6 0 0 2 1 0 5 2 3 6 0 50
138 138 3/8/13 0 0 0 0 4 0 3 0 18 3 0 0 10 0 0 1 0 1 2 2 2 3 0 49
139 139 3/9/13 0 0 0 0 2 1 5 0 0 0 0 0 2 0 0 0 0 0 3 0 2 0 0 15
140 140 3/10/13 0 0 0 0 2 0 2 0 4 0 0 0 3 0 0 0 0 0 8 0 0 0 0 19
141 141 3/11/13 0 0 0 0 4 0 4 0 14 1 0 0 10 0 0 1 1 0 10 1 1 6 0 53
142 142 3/12/13 0 0 0 0 7 1 6 0 16 4 0 0 9 0 0 0 1 1 6 0 2 7 0 60
143 143 3/13/13 0 0 0 0 6 0 9 0 28 1 0 0 7 0 0 2 1 0 7 0 4 5 0 70
144 144 3/14/13 0 0 0 0 9 0 15 0 17 0 0 0 7 0 0 0 1 0 4 0 1 1 0 55
145 145 3/15/13 0 0 0 0 3 0 10 0 13 2 0 0 13 0 0 0 1 0 8 0 2 2 0 54
146 146 3/16/13 0 0 0 0 2 0 3 0 2 0 0 0 4 0 0 0 1 0 5 0 0 1 0 18
147 147 3/17/13 0 0 0 0 0 0 5 0 1 0 0 0 5 0 0 0 1 0 8 0 0 0 0 20
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
149 149 3/19/13 0 0 0 0 2 0 4 0 12 2 0 0 10 0 0 1 1 0 4 1 1 1 0 39
150 150 3/20/13 0 0 0 0 6 1 5 0 7 2 0 0 12 0 0 0 1 1 11 0 2 1 0 49
151 151 3/21/13 0 0 0 0 5 0 2 0 0 1 0 0 11 0 0 1 1 1 12 0 1 3 0 38
152 152 3/22/13 0 0 0 0 27 1 7 0 12 0 0 0 11 0 0 0 1 0 3 0 1 1 0 64
153 153 3/23/13 0 0 0 0 8 0 2 0 3 0 0 0 2 0 0 0 0 0 6 0 1 0 0 22
154 154 3/24/13 0 0 0 0 6 1 0 0 1 0 0 0 0 0 0 0 0 0 4 0 0 1 0 13
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
156 156 3/26/13 0 0 0 0 6 0 11 0 8 1 0 0 12 0 0 0 1 0 12 0 6 2 0 59
157 157 3/27/13 0 0 0 0 16 0 5 0 13 0 0 0 15 0 0 0 0 0 9 2 1 6 0 67
158 158 3/28/13 0 0 0 0 8 0 11 0 6 2 0 0 11 0 0 0 0 0 16 0 2 2 0 58
159 159 3/29/13 0 0 0 0 5 1 5 0 2 4 0 0 2 0 0 0 1 0 9 1 2 1 0 33
160 160 3/30/13 0 0 0 0 3 0 0 0 0 0 0 0 3 0 0 0 0 0 6 1 0 0 0 13
161 161 3/31/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 1 0 5
162 162 4/1/13 0 0 0 0 8 1 3 0 11 0 0 0 12 0 0 0 1 1 9 2 2 3 0 53
163 163 4/2/13 0 0 0 0 4 1 4 0 6 0 0 0 9 0 0 1 0 1 6 0 2 0 0 34
164 164 4/3/13 0 0 0 0 10 1 3 0 5 1 0 0 13 0 0 0 0 1 4 1 0 2 0 41
165 165 4/4/13 0 0 0 0 4 2 4 0 1 3 0 0 4 0 0 0 0 0 7 0 1 1 0 27
166 166 4/5/13 0 0 0 0 2 0 1 0 5 5 0 0 5 0 0 0 0 0 2 0 0 1 0 21
167 167 4/6/13 0 1 0 0 1 1 1 0 1 0 0 0 3 0 0 0 0 0 4 0 2 1 0 15
168 168 4/7/13 0 0 0 0 1 0 0 0 0 0 0 0 2 0 0 0 1 0 2 0 0 0 0 6
169 169 4/8/13 0 0 0 0 3 2 3 0 6 2 0 0 9 0 0 0 1 0 2 0 0 3 0 31
170 170 4/9/13 0 0 0 0 5 1 7 0 5 3 0 0 7 0 0 0 0 0 6 0 0 1 0 35
171 171 4/10/13 0 0 0 0 7 0 1 0 3 0 0 0 8 0 0 2 0 0 7 0 1 4 0 33
172 172 4/11/13 0 0 0 0 3 0 2 0 6 0 0 0 7 0 0 1 1 0 2 0 2 2 0 26
173 173 4/12/13 0 0 0 0 2 1 4 0 4 2 0 0 4 0 0 0 0 1 4 0 1 1 0 24
174 174 4/13/13 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 1 0 4 0 0 0 0 7
175 175 4/14/13 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 3 1 1 0 0 10
176 176 4/15/13 0 0 0 0 3 0 4 0 0 0 0 0 5 0 0 0 1 0 1 1 0 2 0 17
177 177 4/16/13 0 0 0 0 4 0 3 0 7 1 0 0 7 0 0 0 0 0 8 0 0 3 0 33
178 178 4/17/13 0 0 0 0 6 1 4 0 8 1 0 0 7 0 0 2 0 0 4 1 1 4 0 39
179 179 4/18/13 0 0 0 0 3 0 5 0 5 0 0 0 3 0 0 1 0 0 2 0 0 0 6 25
180 180 4/19/13 0 0 0 0 5 0 1 0 0 6 0 0 3 0 0 0 1 0 7 1 0 1 9 34
181 181 4/20/13 0 0 0 0 3 0 0 0 0 0 0 0 3 0 0 0 1 0 2 0 0 0 8 17
182 182 4/21/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 2
183 183 4/22/13 0 0 0 0 6 0 2 0 8 3 0 0 5 0 0 0 0 0 6 0 2 0 15 47
184 184 4/23/13 0 0 0 0 4 1 3 0 8 1 0 0 7 0 0 1 0 0 2 1 0 1 20 49
185 185 4/24/13 0 0 0 0 2 1 6 0 4 0 0 0 8 0 0 1 1 0 0 1 2 2 23 51
186 186 4/25/13 0 0 0 0 3 0 1 0 5 0 0 0 7 0 0 0 0 0 2 0 0 1 31 50
187 187 4/26/13 0 0 0 0 6 0 2 0 2 0 0 0 5 0 0 0 1 0 1 1 0 1 12 31
188 188 4/27/13 0 0 0 0 0 0 2 0 1 0 0 0 3 0 0 1 0 0 3 0 0 0 6 16
189 189 4/28/13 0 0 0 0 2 1 1 0 0 0 0 0 2 0 0 0 1 0 3 0 0 0 5 15
190 190 4/29/13 0 0 0 0 10 1 3 0 5 3 0 0 13 0 0 2 0 0 4 1 1 4 31 78
191 191 4/30/13 0 0 0 0 5 2 2 0 2 2 0 0 9 0 0 1 0 0 4 0 0 1 20 48
192 192 5/1/13 0 0 0 0 5 0 3 0 7 4 0 0 13 0 0 2 1 0 2 0 2 0 25 64
193 193 5/2/13 0 0 0 0 4 0 2 0 1 1 0 0 9 0 0 1 0 0 8 0 0 1 16 43
194 194 5/3/13 0 0 0 0 2 2 0 0 1 0 0 0 2 0 0 0 0 0 6 0 2 0 14 29
195 195 5/4/13 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 3 6
196 196 5/5/13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 5
197 197 5/6/13 0 0 0 0 3 2 2 0 0 0 0 0 10 0 0 0 1 0 3 0 2 0 19 42
198 198 5/7/13 0 0 0 0 3 0 2 0 3 1 0 0 9 0 0 0 2 0 9 1 0 2 14 46
199 199 5/8/13 0 0 0 0 1 1 1 0 4 1 0 0 4 0 0 0 0 0 2 0 0 1 8 23
200 200 5/9/13 0 0 0 0 3 0 3 0 2 3 0 0 13 0 0 1 0 0 1 0 1 2 14 43

Next page

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