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 2021-11-08 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|
33887 | 33887 | 2021-11-08 | Alabama | 1 | 836255 | 15834 |
33888 | 33888 | 2021-11-08 | Alaska | 2 | 142521 | 774 |
33889 | 33889 | 2021-11-08 | American Samoa | 60 | 4 | 0 |
33890 | 33890 | 2021-11-08 | Arizona | 4 | 1192365 | 21409 |
33891 | 33891 | 2021-11-08 | Arkansas | 5 | 516386 | 8508 |
33892 | 33892 | 2021-11-08 | California | 6 | 4978363 | 72811 |
33893 | 33893 | 2021-11-08 | Colorado | 8 | 773082 | 8691 |
33894 | 33894 | 2021-11-08 | Connecticut | 9 | 405910 | 8790 |
33895 | 33895 | 2021-11-08 | Delaware | 10 | 146139 | 2119 |
33896 | 33896 | 2021-11-08 | District of Columbia | 11 | 65050 | 1193 |
33897 | 33897 | 2021-11-08 | Florida | 12 | 3661182 | 60418 |
33898 | 33898 | 2021-11-08 | Georgia | 13 | 1605859 | 28430 |
33899 | 33899 | 2021-11-08 | Guam | 66 | 19657 | 250 |
33900 | 33900 | 2021-11-08 | Hawaii | 15 | 82379 | 959 |
33901 | 33901 | 2021-11-08 | Idaho | 16 | 297189 | 3679 |
33902 | 33902 | 2021-11-08 | Illinois | 17 | 1725686 | 28877 |
33903 | 33903 | 2021-11-08 | Indiana | 18 | 1038714 | 16916 |
33904 | 33904 | 2021-11-08 | Iowa | 19 | 494407 | 7069 |
33905 | 33905 | 2021-11-08 | Kansas | 20 | 443100 | 6561 |
33906 | 33906 | 2021-11-08 | Kentucky | 21 | 758824 | 10095 |
33907 | 33907 | 2021-11-08 | Louisiana | 22 | 762659 | 14622 |
33908 | 33908 | 2021-11-08 | Maine | 23 | 107772 | 1207 |
33909 | 33909 | 2021-11-08 | Maryland | 24 | 566868 | 10988 |
33910 | 33910 | 2021-11-08 | Massachusetts | 25 | 865806 | 19093 |
33911 | 33911 | 2021-11-08 | Michigan | 26 | 1317252 | 24003 |
33912 | 33912 | 2021-11-08 | Minnesota | 27 | 819363 | 8986 |
33913 | 33913 | 2021-11-08 | Mississippi | 28 | 507116 | 10153 |
33914 | 33914 | 2021-11-08 | Missouri | 29 | 880652 | 12932 |
33915 | 33915 | 2021-11-08 | Montana | 30 | 181548 | 2424 |
33916 | 33916 | 2021-11-08 | Nebraska | 31 | 290794 | 3001 |
33917 | 33917 | 2021-11-08 | Nevada | 32 | 457039 | 7759 |
33918 | 33918 | 2021-11-08 | New Hampshire | 33 | 141317 | 1599 |
33919 | 33919 | 2021-11-08 | New Jersey | 34 | 1208321 | 28092 |
33920 | 33920 | 2021-11-08 | New Mexico | 35 | 286086 | 5126 |
33921 | 33921 | 2021-11-08 | New York | 36 | 2593360 | 56280 |
33922 | 33922 | 2021-11-08 | North Carolina | 37 | 1495295 | 18329 |
33923 | 33923 | 2021-11-08 | North Dakota | 38 | 152036 | 1827 |
33924 | 33924 | 2021-11-08 | Northern Mariana Islands | 69 | 343 | 3 |
33925 | 33925 | 2021-11-08 | Ohio | 39 | 1575319 | 25067 |
33926 | 33926 | 2021-11-08 | Oklahoma | 40 | 650004 | 10879 |
33927 | 33927 | 2021-11-08 | Oregon | 41 | 374253 | 4620 |
33928 | 33928 | 2021-11-08 | Pennsylvania | 42 | 1597065 | 31915 |
33929 | 33929 | 2021-11-08 | Puerto Rico | 72 | 219289 | 3246 |
33930 | 33930 | 2021-11-08 | Rhode Island | 44 | 181835 | 2882 |
33931 | 33931 | 2021-11-08 | South Carolina | 45 | 904293 | 13896 |
33932 | 33932 | 2021-11-08 | South Dakota | 46 | 157396 | 2267 |
33933 | 33933 | 2021-11-08 | Tennessee | 47 | 1257642 | 16372 |
33934 | 33934 | 2021-11-08 | Texas | 48 | 4255308 | 72337 |
33935 | 33935 | 2021-11-08 | Utah | 49 | 564689 | 3300 |
33936 | 33936 | 2021-11-08 | Vermont | 50 | 42547 | 384 |
33937 | 33937 | 2021-11-08 | Virgin Islands | 78 | 7303 | 83 |
33938 | 33938 | 2021-11-08 | Virginia | 51 | 936928 | 14190 |
33939 | 33939 | 2021-11-08 | Washington | 53 | 745324 | 8877 |
33940 | 33940 | 2021-11-08 | West Virginia | 54 | 278578 | 4548 |
33941 | 33941 | 2021-11-08 | Wisconsin | 55 | 905333 | 9576 |
33942 | 33942 | 2021-11-08 | Wyoming | 56 | 105990 | 1243 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );