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-12-03 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 |
---|---|---|---|---|---|---|
55727 | 55727 | 2022-12-03 | Alabama | 1 | 1549285 | 21129 |
55728 | 55728 | 2022-12-03 | Alaska | 2 | 300238 | 1390 |
55729 | 55729 | 2022-12-03 | American Samoa | 60 | 8263 | 34 |
55730 | 55730 | 2022-12-03 | Arizona | 4 | 2337547 | 31751 |
55731 | 55731 | 2022-12-03 | Arkansas | 5 | 970857 | 12594 |
55732 | 55732 | 2022-12-03 | California | 6 | 11540816 | 99932 |
55733 | 55733 | 2022-12-03 | Colorado | 8 | 1711236 | 13651 |
55734 | 55734 | 2022-12-03 | Connecticut | 9 | 928712 | 11587 |
55735 | 55735 | 2022-12-03 | Delaware | 10 | 317405 | 3172 |
55736 | 55736 | 2022-12-03 | District of Columbia | 11 | 171608 | 1407 |
55737 | 55737 | 2022-12-03 | Florida | 12 | 7226875 | 83100 |
55738 | 55738 | 2022-12-03 | Georgia | 13 | 2857433 | 39637 |
55739 | 55739 | 2022-12-03 | Guam | 66 | 60299 | 410 |
55740 | 55740 | 2022-12-03 | Hawaii | 15 | 358458 | 1734 |
55741 | 55741 | 2022-12-03 | Idaho | 16 | 506417 | 5281 |
55742 | 55742 | 2022-12-03 | Illinois | 17 | 3892217 | 40339 |
55743 | 55743 | 2022-12-03 | Indiana | 18 | 1965757 | 25164 |
55744 | 55744 | 2022-12-03 | Iowa | 19 | 873597 | 10296 |
55745 | 55745 | 2022-12-03 | Kansas | 20 | 902143 | 9819 |
55746 | 55746 | 2022-12-03 | Kentucky | 21 | 1639218 | 17591 |
55747 | 55747 | 2022-12-03 | Louisiana | 22 | 1473092 | 18274 |
55748 | 55748 | 2022-12-03 | Maine | 23 | 302065 | 2756 |
55749 | 55749 | 2022-12-03 | Maryland | 24 | 1291132 | 15831 |
55750 | 55750 | 2022-12-03 | Massachusetts | 25 | 2115549 | 22488 |
55751 | 55751 | 2022-12-03 | Michigan | 26 | 2938443 | 40085 |
55752 | 55752 | 2022-12-03 | Minnesota | 27 | 1713190 | 14094 |
55753 | 55753 | 2022-12-03 | Mississippi | 28 | 940023 | 13065 |
55754 | 55754 | 2022-12-03 | Missouri | 29 | 1711983 | 23074 |
55755 | 55755 | 2022-12-03 | Montana | 30 | 319194 | 3617 |
55756 | 55756 | 2022-12-03 | Nebraska | 31 | 544705 | 4809 |
55757 | 55757 | 2022-12-03 | Nevada | 32 | 864406 | 11755 |
55758 | 55758 | 2022-12-03 | New Hampshire | 33 | 361890 | 2823 |
55759 | 55759 | 2022-12-03 | New Jersey | 34 | 2854044 | 35178 |
55760 | 55760 | 2022-12-03 | New Mexico | 35 | 647984 | 8721 |
55761 | 55761 | 2022-12-03 | New York | 36 | 6390906 | 76783 |
55762 | 55762 | 2022-12-03 | North Carolina | 37 | 3275343 | 28559 |
55763 | 55763 | 2022-12-03 | North Dakota | 38 | 277366 | 2434 |
55764 | 55764 | 2022-12-03 | Northern Mariana Islands | 69 | 13212 | 41 |
55765 | 55765 | 2022-12-03 | Ohio | 39 | 3243850 | 40659 |
55766 | 55766 | 2022-12-03 | Oklahoma | 40 | 1225997 | 15986 |
55767 | 55767 | 2022-12-03 | Oregon | 41 | 924632 | 8870 |
55768 | 55768 | 2022-12-03 | Pennsylvania | 42 | 3360797 | 48467 |
55769 | 55769 | 2022-12-03 | Puerto Rico | 72 | 1050134 | 5391 |
55770 | 55770 | 2022-12-03 | Rhode Island | 44 | 437972 | 3774 |
55771 | 55771 | 2022-12-03 | South Carolina | 45 | 1738379 | 19274 |
55772 | 55772 | 2022-12-03 | South Dakota | 46 | 268797 | 3117 |
55773 | 55773 | 2022-12-03 | Tennessee | 47 | 2329549 | 28023 |
55774 | 55774 | 2022-12-03 | Texas | 48 | 7989576 | 92327 |
55775 | 55775 | 2022-12-03 | Utah | 49 | 1063566 | 5127 |
55776 | 55776 | 2022-12-03 | Vermont | 50 | 146777 | 770 |
55777 | 55777 | 2022-12-03 | Virgin Islands | 78 | 23445 | 124 |
55778 | 55778 | 2022-12-03 | Virginia | 51 | 2153223 | 22582 |
55779 | 55779 | 2022-12-03 | Washington | 53 | 1858440 | 14739 |
55780 | 55780 | 2022-12-03 | West Virginia | 54 | 615332 | 7740 |
55781 | 55781 | 2022-12-03 | Wisconsin | 55 | 1929331 | 15684 |
55782 | 55782 | 2022-12-03 | Wyoming | 56 | 180925 | 1938 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );