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-06-07 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
45703 | 45703 | 2022-06-07 | Alabama | 1 | 1321892 | 19676 |
45704 | 45704 | 2022-06-07 | Alaska | 2 | 260440 | 1246 |
45705 | 45705 | 2022-06-07 | American Samoa | 60 | 6192 | 31 |
45706 | 45706 | 2022-06-07 | Arizona | 4 | 2062669 | 30332 |
45707 | 45707 | 2022-06-07 | Arkansas | 5 | 846924 | 11508 |
45708 | 45708 | 2022-06-07 | California | 6 | 9728951 | 91740 |
45709 | 45709 | 2022-06-07 | Colorado | 8 | 1470688 | 12788 |
45710 | 45710 | 2022-06-07 | Connecticut | 9 | 814328 | 10998 |
45711 | 45711 | 2022-06-07 | Delaware | 10 | 278877 | 2962 |
45712 | 45712 | 2022-06-07 | District of Columbia | 11 | 151652 | 1347 |
45713 | 45713 | 2022-06-07 | Florida | 12 | 6235311 | 74719 |
45714 | 45714 | 2022-06-07 | Georgia | 13 | 2499718 | 36758 |
45715 | 45715 | 2022-06-07 | Guam | 66 | 50537 | 367 |
45716 | 45716 | 2022-06-07 | Hawaii | 15 | 275631 | 1454 |
45717 | 45717 | 2022-06-07 | Idaho | 16 | 453683 | 4945 |
45718 | 45718 | 2022-06-07 | Illinois | 17 | 3343479 | 38252 |
45719 | 45719 | 2022-06-07 | Indiana | 18 | 1742261 | 23746 |
45720 | 45720 | 2022-06-07 | Iowa | 19 | 783259 | 9603 |
45721 | 45721 | 2022-06-07 | Kansas | 20 | 789963 | 8963 |
45722 | 45722 | 2022-06-07 | Kentucky | 21 | 1377610 | 16004 |
45723 | 45723 | 2022-06-07 | Louisiana | 22 | 1269501 | 17350 |
45724 | 45724 | 2022-06-07 | Maine | 23 | 264923 | 2400 |
45725 | 45725 | 2022-06-07 | Maryland | 24 | 1102992 | 14651 |
45726 | 45726 | 2022-06-07 | Massachusetts | 25 | 1887424 | 20692 |
45727 | 45727 | 2022-06-07 | Michigan | 26 | 2547366 | 36407 |
45728 | 45728 | 2022-06-07 | Minnesota | 27 | 1522243 | 12992 |
45729 | 45729 | 2022-06-07 | Mississippi | 28 | 812502 | 12477 |
45730 | 45730 | 2022-06-07 | Missouri | 29 | 1481457 | 20797 |
45731 | 45731 | 2022-06-07 | Montana | 30 | 279600 | 3423 |
45732 | 45732 | 2022-06-07 | Nebraska | 31 | 489990 | 4306 |
45733 | 45733 | 2022-06-07 | Nevada | 32 | 744192 | 10909 |
45734 | 45734 | 2022-06-07 | New Hampshire | 33 | 327592 | 2555 |
45735 | 45735 | 2022-06-07 | New Jersey | 34 | 2421092 | 33793 |
45736 | 45736 | 2022-06-07 | New Mexico | 35 | 541646 | 7851 |
45737 | 45737 | 2022-06-07 | New York | 36 | 5471652 | 68526 |
45738 | 45738 | 2022-06-07 | North Carolina | 37 | 2775038 | 24663 |
45739 | 45739 | 2022-06-07 | North Dakota | 38 | 245954 | 2331 |
45740 | 45740 | 2022-06-07 | Northern Mariana Islands | 69 | 11403 | 34 |
45741 | 45741 | 2022-06-07 | Ohio | 39 | 2780653 | 38657 |
45742 | 45742 | 2022-06-07 | Oklahoma | 40 | 1054966 | 14437 |
45743 | 45743 | 2022-06-07 | Oregon | 41 | 776239 | 7679 |
45744 | 45744 | 2022-06-07 | Pennsylvania | 42 | 2947243 | 45336 |
45745 | 45745 | 2022-06-07 | Puerto Rico | 72 | 728958 | 4408 |
45746 | 45746 | 2022-06-07 | Rhode Island | 44 | 395945 | 3584 |
45747 | 45747 | 2022-06-07 | South Carolina | 45 | 1514423 | 17970 |
45748 | 45748 | 2022-06-07 | South Dakota | 46 | 240357 | 2928 |
45749 | 45749 | 2022-06-07 | Tennessee | 47 | 2024934 | 26225 |
45750 | 45750 | 2022-06-07 | Texas | 48 | 6912227 | 88615 |
45751 | 45751 | 2022-06-07 | Utah | 49 | 954938 | 4781 |
45752 | 45752 | 2022-06-07 | Vermont | 50 | 132676 | 670 |
45753 | 45753 | 2022-06-07 | Virgin Islands | 78 | 20258 | 114 |
45754 | 45754 | 2022-06-07 | Virginia | 51 | 1808408 | 20435 |
45755 | 45755 | 2022-06-07 | Washington | 53 | 1600769 | 13031 |
45756 | 45756 | 2022-06-07 | West Virginia | 54 | 520264 | 6993 |
45757 | 45757 | 2022-06-07 | Wisconsin | 55 | 1690053 | 14660 |
45758 | 45758 | 2022-06-07 | Wyoming | 56 | 159707 | 1824 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );