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-04 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 |
---|---|---|---|---|---|---|
55783 | 55783 | 2022-12-04 | Alabama | 1 | 1549285 | 21129 |
55784 | 55784 | 2022-12-04 | Alaska | 2 | 300238 | 1390 |
55785 | 55785 | 2022-12-04 | American Samoa | 60 | 8263 | 34 |
55786 | 55786 | 2022-12-04 | Arizona | 4 | 2337547 | 31751 |
55787 | 55787 | 2022-12-04 | Arkansas | 5 | 971020 | 12594 |
55788 | 55788 | 2022-12-04 | California | 6 | 11540816 | 99932 |
55789 | 55789 | 2022-12-04 | Colorado | 8 | 1711236 | 13651 |
55790 | 55790 | 2022-12-04 | Connecticut | 9 | 929619 | 11587 |
55791 | 55791 | 2022-12-04 | Delaware | 10 | 317405 | 3172 |
55792 | 55792 | 2022-12-04 | District of Columbia | 11 | 171608 | 1407 |
55793 | 55793 | 2022-12-04 | Florida | 12 | 7226875 | 83100 |
55794 | 55794 | 2022-12-04 | Georgia | 13 | 2857433 | 39637 |
55795 | 55795 | 2022-12-04 | Guam | 66 | 60299 | 410 |
55796 | 55796 | 2022-12-04 | Hawaii | 15 | 358458 | 1734 |
55797 | 55797 | 2022-12-04 | Idaho | 16 | 506417 | 5281 |
55798 | 55798 | 2022-12-04 | Illinois | 17 | 3892217 | 40339 |
55799 | 55799 | 2022-12-04 | Indiana | 18 | 1965757 | 25164 |
55800 | 55800 | 2022-12-04 | Iowa | 19 | 873597 | 10296 |
55801 | 55801 | 2022-12-04 | Kansas | 20 | 902143 | 9819 |
55802 | 55802 | 2022-12-04 | Kentucky | 21 | 1639218 | 17591 |
55803 | 55803 | 2022-12-04 | Louisiana | 22 | 1473092 | 18274 |
55804 | 55804 | 2022-12-04 | Maine | 23 | 302065 | 2756 |
55805 | 55805 | 2022-12-04 | Maryland | 24 | 1291132 | 15831 |
55806 | 55806 | 2022-12-04 | Massachusetts | 25 | 2115549 | 22488 |
55807 | 55807 | 2022-12-04 | Michigan | 26 | 2938443 | 40085 |
55808 | 55808 | 2022-12-04 | Minnesota | 27 | 1713190 | 14094 |
55809 | 55809 | 2022-12-04 | Mississippi | 28 | 940023 | 13065 |
55810 | 55810 | 2022-12-04 | Missouri | 29 | 1711983 | 23074 |
55811 | 55811 | 2022-12-04 | Montana | 30 | 319194 | 3617 |
55812 | 55812 | 2022-12-04 | Nebraska | 31 | 544705 | 4809 |
55813 | 55813 | 2022-12-04 | Nevada | 32 | 864406 | 11755 |
55814 | 55814 | 2022-12-04 | New Hampshire | 33 | 361890 | 2823 |
55815 | 55815 | 2022-12-04 | New Jersey | 34 | 2854044 | 35178 |
55816 | 55816 | 2022-12-04 | New Mexico | 35 | 647984 | 8721 |
55817 | 55817 | 2022-12-04 | New York | 36 | 6392764 | 76783 |
55818 | 55818 | 2022-12-04 | North Carolina | 37 | 3275343 | 28559 |
55819 | 55819 | 2022-12-04 | North Dakota | 38 | 277366 | 2434 |
55820 | 55820 | 2022-12-04 | Northern Mariana Islands | 69 | 13212 | 41 |
55821 | 55821 | 2022-12-04 | Ohio | 39 | 3243850 | 40659 |
55822 | 55822 | 2022-12-04 | Oklahoma | 40 | 1225997 | 15986 |
55823 | 55823 | 2022-12-04 | Oregon | 41 | 924632 | 8870 |
55824 | 55824 | 2022-12-04 | Pennsylvania | 42 | 3360797 | 48467 |
55825 | 55825 | 2022-12-04 | Puerto Rico | 72 | 1051812 | 5391 |
55826 | 55826 | 2022-12-04 | Rhode Island | 44 | 437972 | 3774 |
55827 | 55827 | 2022-12-04 | South Carolina | 45 | 1738379 | 19274 |
55828 | 55828 | 2022-12-04 | South Dakota | 46 | 268797 | 3117 |
55829 | 55829 | 2022-12-04 | Tennessee | 47 | 2329549 | 28023 |
55830 | 55830 | 2022-12-04 | Texas | 48 | 7989576 | 92327 |
55831 | 55831 | 2022-12-04 | Utah | 49 | 1063566 | 5127 |
55832 | 55832 | 2022-12-04 | Vermont | 50 | 146777 | 770 |
55833 | 55833 | 2022-12-04 | Virgin Islands | 78 | 23445 | 124 |
55834 | 55834 | 2022-12-04 | Virginia | 51 | 2153223 | 22582 |
55835 | 55835 | 2022-12-04 | Washington | 53 | 1858440 | 14739 |
55836 | 55836 | 2022-12-04 | West Virginia | 54 | 615332 | 7740 |
55837 | 55837 | 2022-12-04 | Wisconsin | 55 | 1929331 | 15684 |
55838 | 55838 | 2022-12-04 | 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 );