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-02-06 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 |
---|---|---|---|---|---|---|
38927 | 38927 | 2022-02-06 | Alabama | 1 | 1242420 | 17371 |
38928 | 38928 | 2022-02-06 | Alaska | 2 | 223573 | 1064 |
38929 | 38929 | 2022-02-06 | American Samoa | 60 | 18 | 0 |
38930 | 38930 | 2022-02-06 | Arizona | 4 | 1918034 | 26639 |
38931 | 38931 | 2022-02-06 | Arkansas | 5 | 794342 | 9831 |
38932 | 38932 | 2022-02-06 | California | 6 | 8621360 | 81334 |
38933 | 38933 | 2022-02-06 | Colorado | 8 | 1276837 | 11427 |
38934 | 38934 | 2022-02-06 | Connecticut | 9 | 706140 | 10159 |
38935 | 38935 | 2022-02-06 | Delaware | 10 | 251192 | 2576 |
38936 | 38936 | 2022-02-06 | District of Columbia | 11 | 131543 | 1293 |
38937 | 38937 | 2022-02-06 | Florida | 12 | 5629602 | 66279 |
38938 | 38938 | 2022-02-06 | Georgia | 13 | 2334292 | 32109 |
38939 | 38939 | 2022-02-06 | Guam | 66 | 37082 | 297 |
38940 | 38940 | 2022-02-06 | Hawaii | 15 | 221173 | 1223 |
38941 | 38941 | 2022-02-06 | Idaho | 16 | 391151 | 4481 |
38942 | 38942 | 2022-02-06 | Illinois | 17 | 2962497 | 35157 |
38943 | 38943 | 2022-02-06 | Indiana | 18 | 1650853 | 21712 |
38944 | 38944 | 2022-02-06 | Iowa | 19 | 729700 | 8657 |
38945 | 38945 | 2022-02-06 | Kansas | 20 | 744965 | 7743 |
38946 | 38946 | 2022-02-06 | Kentucky | 21 | 1205118 | 13091 |
38947 | 38947 | 2022-02-06 | Louisiana | 22 | 1192375 | 15905 |
38948 | 38948 | 2022-02-06 | Maine | 23 | 181010 | 1804 |
38949 | 38949 | 2022-02-06 | Maryland | 24 | 964815 | 13724 |
38950 | 38950 | 2022-02-06 | Massachusetts | 25 | 1630462 | 22379 |
38951 | 38951 | 2022-02-06 | Michigan | 26 | 2289269 | 32835 |
38952 | 38952 | 2022-02-06 | Minnesota | 27 | 1359208 | 11749 |
38953 | 38953 | 2022-02-06 | Mississippi | 28 | 751862 | 11250 |
38954 | 38954 | 2022-02-06 | Missouri | 29 | 1371988 | 17869 |
38955 | 38955 | 2022-02-06 | Montana | 30 | 250718 | 3035 |
38956 | 38956 | 2022-02-06 | Nebraska | 31 | 445793 | 3755 |
38957 | 38957 | 2022-02-06 | Nevada | 32 | 665211 | 9144 |
38958 | 38958 | 2022-02-06 | New Hampshire | 33 | 281300 | 2246 |
38959 | 38959 | 2022-02-06 | New Jersey | 34 | 2131015 | 31966 |
38960 | 38960 | 2022-02-06 | New Mexico | 35 | 489701 | 6537 |
38961 | 38961 | 2022-02-06 | New York | 36 | 4835502 | 65148 |
38962 | 38962 | 2022-02-06 | North Carolina | 37 | 2470404 | 21107 |
38963 | 38963 | 2022-02-06 | North Dakota | 38 | 230166 | 2177 |
38964 | 38964 | 2022-02-06 | Northern Mariana Islands | 69 | 6102 | 23 |
38965 | 38965 | 2022-02-06 | Ohio | 39 | 2610125 | 34217 |
38966 | 38966 | 2022-02-06 | Oklahoma | 40 | 995546 | 12193 |
38967 | 38967 | 2022-02-06 | Oregon | 41 | 654343 | 6214 |
38968 | 38968 | 2022-02-06 | Pennsylvania | 42 | 2700036 | 41538 |
38969 | 38969 | 2022-02-06 | Puerto Rico | 72 | 498636 | 3944 |
38970 | 38970 | 2022-02-06 | Rhode Island | 44 | 347901 | 3354 |
38971 | 38971 | 2022-02-06 | South Carolina | 45 | 1406933 | 15791 |
38972 | 38972 | 2022-02-06 | South Dakota | 46 | 230240 | 2687 |
38973 | 38973 | 2022-02-06 | Tennessee | 47 | 1880559 | 22762 |
38974 | 38974 | 2022-02-06 | Texas | 48 | 6369286 | 80909 |
38975 | 38975 | 2022-02-06 | Utah | 49 | 898432 | 4173 |
38976 | 38976 | 2022-02-06 | Vermont | 50 | 106690 | 553 |
38977 | 38977 | 2022-02-06 | Virgin Islands | 78 | 14988 | 102 |
38978 | 38978 | 2022-02-06 | Virginia | 51 | 1572022 | 16703 |
38979 | 38979 | 2022-02-06 | Washington | 53 | 1365183 | 11068 |
38980 | 38980 | 2022-02-06 | West Virginia | 54 | 463357 | 5846 |
38981 | 38981 | 2022-02-06 | Wisconsin | 55 | 1535483 | 12600 |
38982 | 38982 | 2022-02-06 | Wyoming | 56 | 149842 | 1650 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );