us-states
Data source: Big Local News · About: big-local-datasette
11,399 rows sorted by cases
This data as json, copyable, CSV (advanced)
Link | rowid | date | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|
161 | 161 | 2020-02-20 | Wisconsin | 55 | 1 | 0 |
162 | 162 | 2020-02-21 | Arizona | 4 | 1 | 0 |
165 | 165 | 2020-02-21 | Massachusetts | 25 | 1 | 0 |
168 | 168 | 2020-02-21 | Washington | 53 | 1 | 0 |
169 | 169 | 2020-02-21 | Wisconsin | 55 | 1 | 0 |
170 | 170 | 2020-02-22 | Arizona | 4 | 1 | 0 |
173 | 173 | 2020-02-22 | Massachusetts | 25 | 1 | 0 |
176 | 176 | 2020-02-22 | Washington | 53 | 1 | 0 |
177 | 177 | 2020-02-22 | Wisconsin | 55 | 1 | 0 |
178 | 178 | 2020-02-23 | Arizona | 4 | 1 | 0 |
181 | 181 | 2020-02-23 | Massachusetts | 25 | 1 | 0 |
184 | 184 | 2020-02-23 | Washington | 53 | 1 | 0 |
185 | 185 | 2020-02-23 | Wisconsin | 55 | 1 | 0 |
186 | 186 | 2020-02-24 | Arizona | 4 | 1 | 0 |
189 | 189 | 2020-02-24 | Massachusetts | 25 | 1 | 0 |
193 | 193 | 2020-02-24 | Wisconsin | 55 | 1 | 0 |
194 | 194 | 2020-02-25 | Arizona | 4 | 1 | 0 |
197 | 197 | 2020-02-25 | Massachusetts | 25 | 1 | 0 |
200 | 200 | 2020-02-25 | Utah | 49 | 1 | 0 |
202 | 202 | 2020-02-25 | Wisconsin | 55 | 1 | 0 |
203 | 203 | 2020-02-26 | Arizona | 4 | 1 | 0 |
206 | 206 | 2020-02-26 | Massachusetts | 25 | 1 | 0 |
209 | 209 | 2020-02-26 | Utah | 49 | 1 | 0 |
211 | 211 | 2020-02-26 | Wisconsin | 55 | 1 | 0 |
212 | 212 | 2020-02-27 | Arizona | 4 | 1 | 0 |
215 | 215 | 2020-02-27 | Massachusetts | 25 | 1 | 0 |
218 | 218 | 2020-02-27 | Utah | 49 | 1 | 0 |
220 | 220 | 2020-02-27 | Wisconsin | 55 | 1 | 0 |
221 | 221 | 2020-02-28 | Arizona | 4 | 1 | 0 |
224 | 224 | 2020-02-28 | Massachusetts | 25 | 1 | 0 |
226 | 226 | 2020-02-28 | Oregon | 41 | 1 | 0 |
228 | 228 | 2020-02-28 | Utah | 49 | 1 | 0 |
230 | 230 | 2020-02-28 | Wisconsin | 55 | 1 | 0 |
231 | 231 | 2020-02-29 | Arizona | 4 | 1 | 0 |
234 | 234 | 2020-02-29 | Massachusetts | 25 | 1 | 0 |
236 | 236 | 2020-02-29 | Oregon | 41 | 1 | 0 |
238 | 238 | 2020-02-29 | Utah | 49 | 1 | 0 |
240 | 240 | 2020-02-29 | Wisconsin | 55 | 1 | 0 |
241 | 241 | 2020-03-01 | Arizona | 4 | 1 | 0 |
245 | 245 | 2020-03-01 | Massachusetts | 25 | 1 | 0 |
247 | 247 | 2020-03-01 | New York | 36 | 1 | 0 |
251 | 251 | 2020-03-01 | Utah | 49 | 1 | 0 |
253 | 253 | 2020-03-01 | Wisconsin | 55 | 1 | 0 |
254 | 254 | 2020-03-02 | Arizona | 4 | 1 | 0 |
261 | 261 | 2020-03-02 | New Hampshire | 33 | 1 | 0 |
262 | 262 | 2020-03-02 | New York | 36 | 1 | 0 |
266 | 266 | 2020-03-02 | Utah | 49 | 1 | 0 |
268 | 268 | 2020-03-02 | Wisconsin | 55 | 1 | 0 |
278 | 278 | 2020-03-03 | North Carolina | 37 | 1 | 0 |
282 | 282 | 2020-03-03 | Utah | 49 | 1 | 0 |
284 | 284 | 2020-03-03 | Wisconsin | 55 | 1 | 0 |
293 | 293 | 2020-03-04 | New Jersey | 34 | 1 | 0 |
295 | 295 | 2020-03-04 | North Carolina | 37 | 1 | 0 |
299 | 299 | 2020-03-04 | Utah | 49 | 1 | 0 |
301 | 301 | 2020-03-04 | Wisconsin | 55 | 1 | 0 |
315 | 315 | 2020-03-05 | North Carolina | 37 | 1 | 0 |
318 | 318 | 2020-03-05 | Tennessee | 47 | 1 | 0 |
320 | 320 | 2020-03-05 | Utah | 49 | 1 | 0 |
322 | 322 | 2020-03-05 | Wisconsin | 55 | 1 | 0 |
328 | 328 | 2020-03-06 | Hawaii | 15 | 1 | 0 |
330 | 330 | 2020-03-06 | Indiana | 18 | 1 | 0 |
331 | 331 | 2020-03-06 | Kentucky | 21 | 1 | 0 |
334 | 334 | 2020-03-06 | Minnesota | 27 | 1 | 0 |
341 | 341 | 2020-03-06 | Oklahoma | 40 | 1 | 0 |
346 | 346 | 2020-03-06 | Tennessee | 47 | 1 | 0 |
350 | 350 | 2020-03-06 | Wisconsin | 55 | 1 | 0 |
354 | 354 | 2020-03-07 | District of Columbia | 11 | 1 | 0 |
357 | 357 | 2020-03-07 | Hawaii | 15 | 1 | 0 |
359 | 359 | 2020-03-07 | Indiana | 18 | 1 | 0 |
360 | 360 | 2020-03-07 | Kansas | 20 | 1 | 0 |
361 | 361 | 2020-03-07 | Kentucky | 21 | 1 | 0 |
364 | 364 | 2020-03-07 | Minnesota | 27 | 1 | 0 |
365 | 365 | 2020-03-07 | Missouri | 29 | 1 | 0 |
372 | 372 | 2020-03-07 | Oklahoma | 40 | 1 | 0 |
377 | 377 | 2020-03-07 | Tennessee | 47 | 1 | 0 |
380 | 380 | 2020-03-07 | Vermont | 50 | 1 | 0 |
381 | 381 | 2020-03-07 | Virginia | 51 | 1 | 0 |
383 | 383 | 2020-03-07 | Wisconsin | 55 | 1 | 0 |
387 | 387 | 2020-03-08 | Connecticut | 9 | 1 | 0 |
388 | 388 | 2020-03-08 | District of Columbia | 11 | 1 | 0 |
395 | 395 | 2020-03-08 | Kansas | 20 | 1 | 0 |
400 | 400 | 2020-03-08 | Missouri | 29 | 1 | 0 |
407 | 407 | 2020-03-08 | Oklahoma | 40 | 1 | 0 |
415 | 415 | 2020-03-08 | Vermont | 50 | 1 | 0 |
418 | 418 | 2020-03-08 | Wisconsin | 55 | 1 | 0 |
430 | 430 | 2020-03-09 | Kansas | 20 | 1 | 0 |
432 | 432 | 2020-03-09 | Louisiana | 22 | 1 | 0 |
436 | 436 | 2020-03-09 | Missouri | 29 | 1 | 0 |
444 | 444 | 2020-03-09 | Oklahoma | 40 | 1 | 0 |
452 | 452 | 2020-03-09 | Vermont | 50 | 1 | 0 |
467 | 467 | 2020-03-10 | Kansas | 20 | 1 | 0 |
474 | 474 | 2020-03-10 | Missouri | 29 | 1 | 0 |
491 | 491 | 2020-03-10 | Vermont | 50 | 1 | 0 |
496 | 496 | 2020-03-11 | Arkansas | 5 | 1 | 0 |
500 | 500 | 2020-03-11 | Delaware | 10 | 1 | 0 |
508 | 508 | 2020-03-11 | Kansas | 20 | 1 | 0 |
515 | 515 | 2020-03-11 | Mississippi | 28 | 1 | 0 |
516 | 516 | 2020-03-11 | Missouri | 29 | 1 | 0 |
524 | 524 | 2020-03-11 | North Dakota | 38 | 1 | 0 |
539 | 539 | 2020-03-11 | Wyoming | 56 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );