ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-08-02 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 1
- Arizona 1
- Arkansas 1
- California 1
- Colorado 1
- Connecticut 1
- Delaware 1
- District of Columbia 1
- Florida 1
- Georgia 1
- Guam 1
- Hawaii 1
- Idaho 1
- Illinois 1
- Indiana 1
- Iowa 1
- Kansas 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Montana 1
- Nebraska 1
- Nevada 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
28450 | 28450 | 2021-08-02 | Alabama | 1 | 589110 | 11536 |
28451 | 28451 | 2021-08-02 | Alaska | 2 | 75599 | 372 |
28452 | 28452 | 2021-08-02 | Arizona | 4 | 931387 | 18252 |
28453 | 28453 | 2021-08-02 | Arkansas | 5 | 389280 | 6199 |
28454 | 28454 | 2021-08-02 | California | 6 | 4066259 | 64538 |
28455 | 28455 | 2021-08-02 | Colorado | 8 | 580481 | 7112 |
28456 | 28456 | 2021-08-02 | Connecticut | 9 | 355580 | 8293 |
28457 | 28457 | 2021-08-02 | Delaware | 10 | 111681 | 1833 |
28458 | 28458 | 2021-08-02 | District of Columbia | 11 | 50716 | 1149 |
28459 | 28459 | 2021-08-02 | Florida | 12 | 2590699 | 39079 |
28460 | 28460 | 2021-08-02 | Georgia | 13 | 1159390 | 20998 |
28461 | 28461 | 2021-08-02 | Guam | 66 | 9533 | 144 |
28462 | 28462 | 2021-08-02 | Hawaii | 15 | 41446 | 534 |
28463 | 28463 | 2021-08-02 | Idaho | 16 | 201471 | 2204 |
28464 | 28464 | 2021-08-02 | Illinois | 17 | 1428923 | 25930 |
28465 | 28465 | 2021-08-02 | Indiana | 18 | 777459 | 14012 |
28466 | 28466 | 2021-08-02 | Iowa | 19 | 379797 | 6183 |
28467 | 28467 | 2021-08-02 | Kansas | 20 | 335840 | 5301 |
28468 | 28468 | 2021-08-02 | Kentucky | 21 | 487221 | 7393 |
28469 | 28469 | 2021-08-02 | Louisiana | 22 | 552787 | 11026 |
28470 | 28470 | 2021-08-02 | Maine | 23 | 70463 | 900 |
28471 | 28471 | 2021-08-02 | Maryland | 24 | 469762 | 9829 |
28472 | 28472 | 2021-08-02 | Massachusetts | 25 | 721885 | 18084 |
28473 | 28473 | 2021-08-02 | Michigan | 26 | 1009779 | 21174 |
28474 | 28474 | 2021-08-02 | Minnesota | 27 | 613418 | 7767 |
28475 | 28475 | 2021-08-02 | Mississippi | 28 | 348496 | 7556 |
28476 | 28476 | 2021-08-02 | Missouri | 29 | 699242 | 10320 |
28477 | 28477 | 2021-08-02 | Montana | 30 | 116746 | 1708 |
28478 | 28478 | 2021-08-02 | Nebraska | 31 | 228995 | 2550 |
28479 | 28479 | 2021-08-02 | Nevada | 32 | 358932 | 5918 |
28480 | 28480 | 2021-08-02 | New Hampshire | 33 | 100986 | 1387 |
28481 | 28481 | 2021-08-02 | New Jersey | 34 | 1041159 | 26606 |
28482 | 28482 | 2021-08-02 | New Mexico | 35 | 211492 | 4416 |
28483 | 28483 | 2021-08-02 | New York | 36 | 2153243 | 53281 |
28484 | 28484 | 2021-08-02 | North Carolina | 37 | 1057204 | 13681 |
28485 | 28485 | 2021-08-02 | North Dakota | 38 | 111730 | 1570 |
28486 | 28486 | 2021-08-02 | Northern Mariana Islands | 69 | 198 | 2 |
28487 | 28487 | 2021-08-02 | Ohio | 39 | 1131029 | 20492 |
28488 | 28488 | 2021-08-02 | Oklahoma | 40 | 486232 | 7485 |
28489 | 28489 | 2021-08-02 | Oregon | 41 | 221799 | 2890 |
28490 | 28490 | 2021-08-02 | Pennsylvania | 42 | 1232238 | 27857 |
28491 | 28491 | 2021-08-02 | Puerto Rico | 72 | 181266 | 2581 |
28492 | 28492 | 2021-08-02 | Rhode Island | 44 | 154790 | 2740 |
28493 | 28493 | 2021-08-02 | South Carolina | 45 | 623947 | 9915 |
28494 | 28494 | 2021-08-02 | South Dakota | 46 | 125216 | 2043 |
28495 | 28495 | 2021-08-02 | Tennessee | 47 | 886436 | 12664 |
28496 | 28496 | 2021-08-02 | Texas | 48 | 3143940 | 53450 |
28497 | 28497 | 2021-08-02 | Utah | 49 | 434783 | 2466 |
28498 | 28498 | 2021-08-02 | Vermont | 50 | 25038 | 260 |
28499 | 28499 | 2021-08-02 | Virgin Islands | 78 | 4629 | 37 |
28500 | 28500 | 2021-08-02 | Virginia | 51 | 697939 | 11534 |
28501 | 28501 | 2021-08-02 | Washington | 53 | 477352 | 6169 |
28502 | 28502 | 2021-08-02 | West Virginia | 54 | 167681 | 2949 |
28503 | 28503 | 2021-08-02 | Wisconsin | 55 | 689457 | 8295 |
28504 | 28504 | 2021-08-02 | Wyoming | 56 | 65467 | 776 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );