ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where "date" is on date 2020-03-06 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 28
- Arizona 1
- California 1
- Colorado 1
- Florida 1
- Georgia 1
- Hawaii 1
- Illinois 1
- Indiana 1
- Kentucky 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- Nebraska 1
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New York 1
- North Carolina 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Rhode Island 1
- South Carolina 1
- Tennessee 1
- Texas 1
- Utah 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
323 | 323 | 2020-03-06 | Arizona | 4 | 3 | 0 |
324 | 324 | 2020-03-06 | California | 6 | 81 | 1 |
325 | 325 | 2020-03-06 | Colorado | 8 | 8 | 0 |
326 | 326 | 2020-03-06 | Florida | 12 | 7 | 2 |
327 | 327 | 2020-03-06 | Georgia | 13 | 3 | 0 |
328 | 328 | 2020-03-06 | Hawaii | 15 | 1 | 0 |
329 | 329 | 2020-03-06 | Illinois | 17 | 6 | 0 |
330 | 330 | 2020-03-06 | Indiana | 18 | 1 | 0 |
331 | 331 | 2020-03-06 | Kentucky | 21 | 1 | 0 |
332 | 332 | 2020-03-06 | Maryland | 24 | 3 | 0 |
333 | 333 | 2020-03-06 | Massachusetts | 25 | 8 | 0 |
334 | 334 | 2020-03-06 | Minnesota | 27 | 1 | 0 |
335 | 335 | 2020-03-06 | Nebraska | 31 | 14 | 0 |
336 | 336 | 2020-03-06 | Nevada | 32 | 2 | 0 |
337 | 337 | 2020-03-06 | New Hampshire | 33 | 2 | 0 |
338 | 338 | 2020-03-06 | New Jersey | 34 | 4 | 0 |
339 | 339 | 2020-03-06 | New York | 36 | 44 | 0 |
340 | 340 | 2020-03-06 | North Carolina | 37 | 2 | 0 |
341 | 341 | 2020-03-06 | Oklahoma | 40 | 1 | 0 |
342 | 342 | 2020-03-06 | Oregon | 41 | 2 | 0 |
343 | 343 | 2020-03-06 | Pennsylvania | 42 | 2 | 0 |
344 | 344 | 2020-03-06 | Rhode Island | 44 | 3 | 0 |
345 | 345 | 2020-03-06 | South Carolina | 45 | 2 | 0 |
346 | 346 | 2020-03-06 | Tennessee | 47 | 1 | 0 |
347 | 347 | 2020-03-06 | Texas | 48 | 19 | 0 |
348 | 348 | 2020-03-06 | Utah | 49 | 3 | 0 |
349 | 349 | 2020-03-06 | Washington | 53 | 86 | 12 |
350 | 350 | 2020-03-06 | Wisconsin | 55 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );