ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where "date" is on date 2020-03-10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Arizona 1
- California 1
- Colorado 1
- Connecticut 1
- District of Columbia 1
- Florida 1
- Georgia 1
- Hawaii 1
- Illinois 1
- Indiana 1
- Iowa 1
- Kansas 1
- Kentucky 1
- Louisiana 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- Missouri 1
- Nebraska 1
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New York 1
- North Carolina 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Rhode Island 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
456 | 456 | 2020-03-10 | Arizona | 4 | 6 | 0 |
457 | 457 | 2020-03-10 | California | 6 | 179 | 3 |
458 | 458 | 2020-03-10 | Colorado | 8 | 17 | 0 |
459 | 459 | 2020-03-10 | Connecticut | 9 | 2 | 0 |
460 | 460 | 2020-03-10 | District of Columbia | 11 | 4 | 0 |
461 | 461 | 2020-03-10 | Florida | 12 | 23 | 2 |
462 | 462 | 2020-03-10 | Georgia | 13 | 22 | 0 |
463 | 463 | 2020-03-10 | Hawaii | 15 | 2 | 0 |
464 | 464 | 2020-03-10 | Illinois | 17 | 19 | 0 |
465 | 465 | 2020-03-10 | Indiana | 18 | 6 | 0 |
466 | 466 | 2020-03-10 | Iowa | 19 | 13 | 0 |
467 | 467 | 2020-03-10 | Kansas | 20 | 1 | 0 |
468 | 468 | 2020-03-10 | Kentucky | 21 | 7 | 0 |
469 | 469 | 2020-03-10 | Louisiana | 22 | 6 | 0 |
470 | 470 | 2020-03-10 | Maryland | 24 | 9 | 0 |
471 | 471 | 2020-03-10 | Massachusetts | 25 | 92 | 0 |
472 | 472 | 2020-03-10 | Michigan | 26 | 2 | 0 |
473 | 473 | 2020-03-10 | Minnesota | 27 | 3 | 0 |
474 | 474 | 2020-03-10 | Missouri | 29 | 1 | 0 |
475 | 475 | 2020-03-10 | Nebraska | 31 | 17 | 0 |
476 | 476 | 2020-03-10 | Nevada | 32 | 4 | 0 |
477 | 477 | 2020-03-10 | New Hampshire | 33 | 5 | 0 |
478 | 478 | 2020-03-10 | New Jersey | 34 | 15 | 1 |
479 | 479 | 2020-03-10 | New York | 36 | 173 | 0 |
480 | 480 | 2020-03-10 | North Carolina | 37 | 7 | 0 |
481 | 481 | 2020-03-10 | Ohio | 39 | 3 | 0 |
482 | 482 | 2020-03-10 | Oklahoma | 40 | 2 | 0 |
483 | 483 | 2020-03-10 | Oregon | 41 | 14 | 0 |
484 | 484 | 2020-03-10 | Pennsylvania | 42 | 12 | 0 |
485 | 485 | 2020-03-10 | Rhode Island | 44 | 5 | 0 |
486 | 486 | 2020-03-10 | South Carolina | 45 | 9 | 0 |
487 | 487 | 2020-03-10 | South Dakota | 46 | 5 | 1 |
488 | 488 | 2020-03-10 | Tennessee | 47 | 7 | 0 |
489 | 489 | 2020-03-10 | Texas | 48 | 31 | 0 |
490 | 490 | 2020-03-10 | Utah | 49 | 4 | 0 |
491 | 491 | 2020-03-10 | Vermont | 50 | 1 | 0 |
492 | 492 | 2020-03-10 | Virginia | 51 | 8 | 0 |
493 | 493 | 2020-03-10 | Washington | 53 | 279 | 24 |
494 | 494 | 2020-03-10 | Wisconsin | 55 | 3 | 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 );