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-30 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 |
---|---|---|---|---|---|---|
38535 | 38535 | 2022-01-30 | Alabama | 1 | 1212798 | 17086 |
38536 | 38536 | 2022-01-30 | Alaska | 2 | 211117 | 1057 |
38537 | 38537 | 2022-01-30 | American Samoa | 60 | 18 | 0 |
38538 | 38538 | 2022-01-30 | Arizona | 4 | 1858385 | 26206 |
38539 | 38539 | 2022-01-30 | Arkansas | 5 | 768061 | 9622 |
38540 | 38540 | 2022-01-30 | California | 6 | 8287535 | 80038 |
38541 | 38541 | 2022-01-30 | Colorado | 8 | 1245392 | 11263 |
38542 | 38542 | 2022-01-30 | Connecticut | 9 | 696070 | 9985 |
38543 | 38543 | 2022-01-30 | Delaware | 10 | 247638 | 2531 |
38544 | 38544 | 2022-01-30 | District of Columbia | 11 | 129817 | 1284 |
38545 | 38545 | 2022-01-30 | Florida | 12 | 5501599 | 64955 |
38546 | 38546 | 2022-01-30 | Georgia | 13 | 2281370 | 31595 |
38547 | 38547 | 2022-01-30 | Guam | 66 | 32773 | 286 |
38548 | 38548 | 2022-01-30 | Hawaii | 15 | 212768 | 1177 |
38549 | 38549 | 2022-01-30 | Idaho | 16 | 377804 | 4407 |
38550 | 38550 | 2022-01-30 | Illinois | 17 | 2901790 | 34439 |
38551 | 38551 | 2022-01-30 | Indiana | 18 | 1607951 | 21301 |
38552 | 38552 | 2022-01-30 | Iowa | 19 | 712288 | 8501 |
38553 | 38553 | 2022-01-30 | Kansas | 20 | 723285 | 7550 |
38554 | 38554 | 2022-01-30 | Kentucky | 21 | 1155055 | 12905 |
38555 | 38555 | 2022-01-30 | Louisiana | 22 | 1160130 | 15631 |
38556 | 38556 | 2022-01-30 | Maine | 23 | 174225 | 1738 |
38557 | 38557 | 2022-01-30 | Maryland | 24 | 954469 | 13465 |
38558 | 38558 | 2022-01-30 | Massachusetts | 25 | 1598451 | 21909 |
38559 | 38559 | 2022-01-30 | Michigan | 26 | 2229405 | 32159 |
38560 | 38560 | 2022-01-30 | Minnesota | 27 | 1309815 | 11532 |
38561 | 38561 | 2022-01-30 | Mississippi | 28 | 717666 | 10831 |
38562 | 38562 | 2022-01-30 | Missouri | 29 | 1340281 | 17404 |
38563 | 38563 | 2022-01-30 | Montana | 30 | 239559 | 2997 |
38564 | 38564 | 2022-01-30 | Nebraska | 31 | 435358 | 3666 |
38565 | 38565 | 2022-01-30 | Nevada | 32 | 648088 | 8914 |
38566 | 38566 | 2022-01-30 | New Hampshire | 33 | 272492 | 2205 |
38567 | 38567 | 2022-01-30 | New Jersey | 34 | 2109783 | 31412 |
38568 | 38568 | 2022-01-30 | New Mexico | 35 | 470513 | 6419 |
38569 | 38569 | 2022-01-30 | New York | 36 | 4779854 | 64176 |
38570 | 38570 | 2022-01-30 | North Carolina | 37 | 2373587 | 20605 |
38571 | 38571 | 2022-01-30 | North Dakota | 38 | 223409 | 2140 |
38572 | 38572 | 2022-01-30 | Northern Mariana Islands | 69 | 4795 | 23 |
38573 | 38573 | 2022-01-30 | Ohio | 39 | 2576245 | 33071 |
38574 | 38574 | 2022-01-30 | Oklahoma | 40 | 953116 | 12044 |
38575 | 38575 | 2022-01-30 | Oregon | 41 | 620653 | 6086 |
38576 | 38576 | 2022-01-30 | Pennsylvania | 42 | 2656587 | 40563 |
38577 | 38577 | 2022-01-30 | Puerto Rico | 72 | 490238 | 3854 |
38578 | 38578 | 2022-01-30 | Rhode Island | 44 | 341407 | 3302 |
38579 | 38579 | 2022-01-30 | South Carolina | 45 | 1355116 | 15266 |
38580 | 38580 | 2022-01-30 | South Dakota | 46 | 225383 | 2637 |
38581 | 38581 | 2022-01-30 | Tennessee | 47 | 1802927 | 22231 |
38582 | 38582 | 2022-01-30 | Texas | 48 | 6192817 | 79621 |
38583 | 38583 | 2022-01-30 | Utah | 49 | 875414 | 4107 |
38584 | 38584 | 2022-01-30 | Vermont | 50 | 104160 | 533 |
38585 | 38585 | 2022-01-30 | Virgin Islands | 78 | 14802 | 99 |
38586 | 38586 | 2022-01-30 | Virginia | 51 | 1525603 | 16127 |
38587 | 38587 | 2022-01-30 | Washington | 53 | 1294536 | 10756 |
38588 | 38588 | 2022-01-30 | West Virginia | 54 | 445061 | 5743 |
38589 | 38589 | 2022-01-30 | Wisconsin | 55 | 1503538 | 12291 |
38590 | 38590 | 2022-01-30 | 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 );