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-12-31 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 |
---|---|---|---|---|---|---|
36855 | 36855 | 2021-12-31 | Alabama | 1 | 896614 | 16455 |
36856 | 36856 | 2021-12-31 | Alaska | 2 | 156130 | 954 |
36857 | 36857 | 2021-12-31 | American Samoa | 60 | 11 | 0 |
36858 | 36858 | 2021-12-31 | Arizona | 4 | 1381488 | 24229 |
36859 | 36859 | 2021-12-31 | Arkansas | 5 | 566486 | 9148 |
36860 | 36860 | 2021-12-31 | California | 6 | 5515613 | 76709 |
36861 | 36861 | 2021-12-31 | Colorado | 8 | 933257 | 10480 |
36862 | 36862 | 2021-12-31 | Connecticut | 9 | 510188 | 9160 |
36863 | 36863 | 2021-12-31 | Delaware | 10 | 180366 | 2286 |
36864 | 36864 | 2021-12-31 | District of Columbia | 11 | 94286 | 1211 |
36865 | 36865 | 2021-12-31 | Florida | 12 | 4166392 | 62504 |
36866 | 36866 | 2021-12-31 | Georgia | 13 | 1798497 | 30283 |
36867 | 36867 | 2021-12-31 | Guam | 66 | 20576 | 271 |
36868 | 36868 | 2021-12-31 | Hawaii | 15 | 109576 | 1087 |
36869 | 36869 | 2021-12-31 | Idaho | 16 | 319442 | 4163 |
36870 | 36870 | 2021-12-31 | Illinois | 17 | 2154058 | 31017 |
36871 | 36871 | 2021-12-31 | Indiana | 18 | 1250565 | 19037 |
36872 | 36872 | 2021-12-31 | Iowa | 19 | 575501 | 7858 |
36873 | 36873 | 2021-12-31 | Kansas | 20 | 520500 | 7030 |
36874 | 36874 | 2021-12-31 | Kentucky | 21 | 864599 | 12149 |
36875 | 36875 | 2021-12-31 | Louisiana | 22 | 828695 | 14986 |
36876 | 36876 | 2021-12-31 | Maine | 23 | 146736 | 1531 |
36877 | 36877 | 2021-12-31 | Maryland | 24 | 700789 | 11758 |
36878 | 36878 | 2021-12-31 | Massachusetts | 25 | 1140614 | 20273 |
36879 | 36879 | 2021-12-31 | Michigan | 26 | 1706355 | 28984 |
36880 | 36880 | 2021-12-31 | Minnesota | 27 | 1022352 | 10656 |
36881 | 36881 | 2021-12-31 | Mississippi | 28 | 543737 | 10450 |
36882 | 36882 | 2021-12-31 | Missouri | 29 | 1023310 | 16223 |
36883 | 36883 | 2021-12-31 | Montana | 30 | 197784 | 2907 |
36884 | 36884 | 2021-12-31 | Nebraska | 31 | 338257 | 3336 |
36885 | 36885 | 2021-12-31 | Nevada | 32 | 501181 | 8420 |
36886 | 36886 | 2021-12-31 | New Hampshire | 33 | 198667 | 1961 |
36887 | 36887 | 2021-12-31 | New Jersey | 34 | 1564253 | 29037 |
36888 | 36888 | 2021-12-31 | New Mexico | 35 | 350043 | 5857 |
36889 | 36889 | 2021-12-31 | New York | 36 | 3473970 | 58993 |
36890 | 36890 | 2021-12-31 | North Carolina | 37 | 1685504 | 19436 |
36891 | 36891 | 2021-12-31 | North Dakota | 38 | 174220 | 2057 |
36892 | 36892 | 2021-12-31 | Northern Mariana Islands | 69 | 3255 | 13 |
36893 | 36893 | 2021-12-31 | Ohio | 39 | 2016095 | 29447 |
36894 | 36894 | 2021-12-31 | Oklahoma | 40 | 708938 | 11552 |
36895 | 36895 | 2021-12-31 | Oregon | 41 | 421263 | 5655 |
36896 | 36896 | 2021-12-31 | Pennsylvania | 42 | 2036424 | 36705 |
36897 | 36897 | 2021-12-31 | Puerto Rico | 72 | 305905 | 3305 |
36898 | 36898 | 2021-12-31 | Rhode Island | 44 | 231096 | 3066 |
36899 | 36899 | 2021-12-31 | South Carolina | 45 | 975320 | 14636 |
36900 | 36900 | 2021-12-31 | South Dakota | 46 | 179204 | 2486 |
36901 | 36901 | 2021-12-31 | Tennessee | 47 | 1379917 | 20640 |
36902 | 36902 | 2021-12-31 | Texas | 48 | 4574881 | 76062 |
36903 | 36903 | 2021-12-31 | Utah | 49 | 637144 | 3787 |
36904 | 36904 | 2021-12-31 | Vermont | 50 | 64447 | 471 |
36905 | 36905 | 2021-12-31 | Virgin Islands | 78 | 9055 | 89 |
36906 | 36906 | 2021-12-31 | Virginia | 51 | 1118518 | 15587 |
36907 | 36907 | 2021-12-31 | Washington | 53 | 852824 | 9904 |
36908 | 36908 | 2021-12-31 | West Virginia | 54 | 328162 | 5336 |
36909 | 36909 | 2021-12-31 | Wisconsin | 55 | 1120669 | 11173 |
36910 | 36910 | 2021-12-31 | Wyoming | 56 | 115638 | 1526 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );