ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2022-01-29 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 1
- American Samoa 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
38479 | 38479 | 2022-01-29 | Alabama | 1 | 1206308 | 17086 |
38480 | 38480 | 2022-01-29 | Alaska | 2 | 211117 | 1057 |
38481 | 38481 | 2022-01-29 | American Samoa | 60 | 18 | 0 |
38482 | 38482 | 2022-01-29 | Arizona | 4 | 1844912 | 26183 |
38483 | 38483 | 2022-01-29 | Arkansas | 5 | 768061 | 9622 |
38484 | 38484 | 2022-01-29 | California | 6 | 8270373 | 80004 |
38485 | 38485 | 2022-01-29 | Colorado | 8 | 1240714 | 11218 |
38486 | 38486 | 2022-01-29 | Connecticut | 9 | 696070 | 9985 |
38487 | 38487 | 2022-01-29 | Delaware | 10 | 246959 | 2531 |
38488 | 38488 | 2022-01-29 | District of Columbia | 11 | 129817 | 1284 |
38489 | 38489 | 2022-01-29 | Florida | 12 | 5501599 | 64955 |
38490 | 38490 | 2022-01-29 | Georgia | 13 | 2281370 | 31595 |
38491 | 38491 | 2022-01-29 | Guam | 66 | 32007 | 286 |
38492 | 38492 | 2022-01-29 | Hawaii | 15 | 210085 | 1170 |
38493 | 38493 | 2022-01-29 | Idaho | 16 | 377804 | 4407 |
38494 | 38494 | 2022-01-29 | Illinois | 17 | 2901790 | 34439 |
38495 | 38495 | 2022-01-29 | Indiana | 18 | 1607951 | 21301 |
38496 | 38496 | 2022-01-29 | Iowa | 19 | 712288 | 8501 |
38497 | 38497 | 2022-01-29 | Kansas | 20 | 723285 | 7550 |
38498 | 38498 | 2022-01-29 | Kentucky | 21 | 1154036 | 12905 |
38499 | 38499 | 2022-01-29 | Louisiana | 22 | 1160130 | 15631 |
38500 | 38500 | 2022-01-29 | Maine | 23 | 174225 | 1738 |
38501 | 38501 | 2022-01-29 | Maryland | 24 | 952528 | 13432 |
38502 | 38502 | 2022-01-29 | Massachusetts | 25 | 1598451 | 21909 |
38503 | 38503 | 2022-01-29 | Michigan | 26 | 2229405 | 32159 |
38504 | 38504 | 2022-01-29 | Minnesota | 27 | 1309815 | 11532 |
38505 | 38505 | 2022-01-29 | Mississippi | 28 | 717666 | 10831 |
38506 | 38506 | 2022-01-29 | Missouri | 29 | 1337639 | 17403 |
38507 | 38507 | 2022-01-29 | Montana | 30 | 239559 | 2997 |
38508 | 38508 | 2022-01-29 | Nebraska | 31 | 435358 | 3666 |
38509 | 38509 | 2022-01-29 | Nevada | 32 | 648088 | 8914 |
38510 | 38510 | 2022-01-29 | New Hampshire | 33 | 272492 | 2205 |
38511 | 38511 | 2022-01-29 | New Jersey | 34 | 2107606 | 31391 |
38512 | 38512 | 2022-01-29 | New Mexico | 35 | 470513 | 6419 |
38513 | 38513 | 2022-01-29 | New York | 36 | 4774123 | 64113 |
38514 | 38514 | 2022-01-29 | North Carolina | 37 | 2373587 | 20605 |
38515 | 38515 | 2022-01-29 | North Dakota | 38 | 222695 | 2140 |
38516 | 38516 | 2022-01-29 | Northern Mariana Islands | 69 | 4772 | 23 |
38517 | 38517 | 2022-01-29 | Ohio | 39 | 2571021 | 33071 |
38518 | 38518 | 2022-01-29 | Oklahoma | 40 | 953116 | 12044 |
38519 | 38519 | 2022-01-29 | Oregon | 41 | 620653 | 6086 |
38520 | 38520 | 2022-01-29 | Pennsylvania | 42 | 2649247 | 40548 |
38521 | 38521 | 2022-01-29 | Puerto Rico | 72 | 488623 | 3837 |
38522 | 38522 | 2022-01-29 | Rhode Island | 44 | 341407 | 3302 |
38523 | 38523 | 2022-01-29 | South Carolina | 45 | 1355116 | 15266 |
38524 | 38524 | 2022-01-29 | South Dakota | 46 | 225383 | 2637 |
38525 | 38525 | 2022-01-29 | Tennessee | 47 | 1802927 | 22231 |
38526 | 38526 | 2022-01-29 | Texas | 48 | 6166582 | 79519 |
38527 | 38527 | 2022-01-29 | Utah | 49 | 875414 | 4107 |
38528 | 38528 | 2022-01-29 | Vermont | 50 | 103549 | 533 |
38529 | 38529 | 2022-01-29 | Virgin Islands | 78 | 14802 | 99 |
38530 | 38530 | 2022-01-29 | Virginia | 51 | 1525603 | 16127 |
38531 | 38531 | 2022-01-29 | Washington | 53 | 1294536 | 10756 |
38532 | 38532 | 2022-01-29 | West Virginia | 54 | 442206 | 5743 |
38533 | 38533 | 2022-01-29 | Wisconsin | 55 | 1503538 | 12291 |
38534 | 38534 | 2022-01-29 | Wyoming | 56 | 144526 | 1625 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );