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-09-04 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
state 56
- 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
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
50687 | 50687 | 2022-09-04 | Alabama | 1 | 1496295 | 20202 |
50688 | 50688 | 2022-09-04 | Alaska | 2 | 292817 | 1297 |
50689 | 50689 | 2022-09-04 | American Samoa | 60 | 8168 | 34 |
50690 | 50690 | 2022-09-04 | Arizona | 4 | 2254374 | 31114 |
50691 | 50691 | 2022-09-04 | Arkansas | 5 | 936411 | 11933 |
50692 | 50692 | 2022-09-04 | California | 6 | 11117372 | 95097 |
50693 | 50693 | 2022-09-04 | Colorado | 8 | 1641270 | 13378 |
50694 | 50694 | 2022-09-04 | Connecticut | 9 | 876956 | 11269 |
50695 | 50695 | 2022-09-04 | Delaware | 10 | 303196 | 3070 |
50696 | 50696 | 2022-09-04 | District of Columbia | 11 | 166381 | 1382 |
50697 | 50697 | 2022-09-04 | Florida | 12 | 7037431 | 80027 |
50698 | 50698 | 2022-09-04 | Georgia | 13 | 2788282 | 38218 |
50699 | 50699 | 2022-09-04 | Guam | 66 | 59004 | 391 |
50700 | 50700 | 2022-09-04 | Hawaii | 15 | 331095 | 1641 |
50701 | 50701 | 2022-09-04 | Idaho | 16 | 490114 | 5121 |
50702 | 50702 | 2022-09-04 | Illinois | 17 | 3702948 | 39370 |
50703 | 50703 | 2022-09-04 | Indiana | 18 | 1899553 | 24454 |
50704 | 50704 | 2022-09-04 | Iowa | 19 | 843034 | 9940 |
50705 | 50705 | 2022-09-04 | Kansas | 20 | 864985 | 9020 |
50706 | 50706 | 2022-09-04 | Kentucky | 21 | 1552593 | 16679 |
50707 | 50707 | 2022-09-04 | Louisiana | 22 | 1435368 | 17885 |
50708 | 50708 | 2022-09-04 | Maine | 23 | 283611 | 2513 |
50709 | 50709 | 2022-09-04 | Maryland | 24 | 1225805 | 15199 |
50710 | 50710 | 2022-09-04 | Massachusetts | 25 | 2013992 | 21463 |
50711 | 50711 | 2022-09-04 | Michigan | 26 | 2770359 | 38038 |
50712 | 50712 | 2022-09-04 | Minnesota | 27 | 1639213 | 13471 |
50713 | 50713 | 2022-09-04 | Mississippi | 28 | 913049 | 12794 |
50714 | 50714 | 2022-09-04 | Missouri | 29 | 1636248 | 21502 |
50715 | 50715 | 2022-09-04 | Montana | 30 | 305814 | 3502 |
50716 | 50716 | 2022-09-04 | Nebraska | 31 | 530925 | 4455 |
50717 | 50717 | 2022-09-04 | Nevada | 32 | 842187 | 11408 |
50718 | 50718 | 2022-09-04 | New Hampshire | 33 | 344823 | 2662 |
50719 | 50719 | 2022-09-04 | New Jersey | 34 | 2685083 | 34583 |
50720 | 50720 | 2022-09-04 | New Mexico | 35 | 612146 | 8471 |
50721 | 50721 | 2022-09-04 | New York | 36 | 5989830 | 70458 |
50722 | 50722 | 2022-09-04 | North Carolina | 37 | 3120821 | 26345 |
50723 | 50723 | 2022-09-04 | North Dakota | 38 | 265310 | 2395 |
50724 | 50724 | 2022-09-04 | Northern Mariana Islands | 69 | 13120 | 40 |
50725 | 50725 | 2022-09-04 | Ohio | 39 | 3074826 | 39490 |
50726 | 50726 | 2022-09-04 | Oklahoma | 40 | 1174015 | 14744 |
50727 | 50727 | 2022-09-04 | Oregon | 41 | 879640 | 8427 |
50728 | 50728 | 2022-09-04 | Pennsylvania | 42 | 3185902 | 46716 |
50729 | 50729 | 2022-09-04 | Puerto Rico | 72 | 965740 | 4996 |
50730 | 50730 | 2022-09-04 | Rhode Island | 44 | 418635 | 3645 |
50731 | 50731 | 2022-09-04 | South Carolina | 45 | 1674281 | 18263 |
50732 | 50732 | 2022-09-04 | South Dakota | 46 | 257547 | 2993 |
50733 | 50733 | 2022-09-04 | Tennessee | 47 | 2245641 | 27209 |
50734 | 50734 | 2022-09-04 | Texas | 48 | 7758066 | 90450 |
50735 | 50735 | 2022-09-04 | Utah | 49 | 1030031 | 4981 |
50736 | 50736 | 2022-09-04 | Vermont | 50 | 140308 | 707 |
50737 | 50737 | 2022-09-04 | Virgin Islands | 78 | 22771 | 122 |
50738 | 50738 | 2022-09-04 | Virginia | 51 | 2045387 | 21463 |
50739 | 50739 | 2022-09-04 | Washington | 53 | 1787487 | 14109 |
50740 | 50740 | 2022-09-04 | West Virginia | 54 | 584771 | 7294 |
50741 | 50741 | 2022-09-04 | Wisconsin | 55 | 1835422 | 15091 |
50742 | 50742 | 2022-09-04 | Wyoming | 56 | 174828 | 1881 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );