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-05 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 |
---|---|---|---|---|---|---|
38871 | 38871 | 2022-02-05 | Alabama | 1 | 1242420 | 17371 |
38872 | 38872 | 2022-02-05 | Alaska | 2 | 223573 | 1064 |
38873 | 38873 | 2022-02-05 | American Samoa | 60 | 18 | 0 |
38874 | 38874 | 2022-02-05 | Arizona | 4 | 1911655 | 26628 |
38875 | 38875 | 2022-02-05 | Arkansas | 5 | 793361 | 9793 |
38876 | 38876 | 2022-02-05 | California | 6 | 8614417 | 81267 |
38877 | 38877 | 2022-02-05 | Colorado | 8 | 1276189 | 11423 |
38878 | 38878 | 2022-02-05 | Connecticut | 9 | 706140 | 10159 |
38879 | 38879 | 2022-02-05 | Delaware | 10 | 250756 | 2576 |
38880 | 38880 | 2022-02-05 | District of Columbia | 11 | 131543 | 1293 |
38881 | 38881 | 2022-02-05 | Florida | 12 | 5629602 | 66279 |
38882 | 38882 | 2022-02-05 | Georgia | 13 | 2334292 | 32109 |
38883 | 38883 | 2022-02-05 | Guam | 66 | 34757 | 297 |
38884 | 38884 | 2022-02-05 | Hawaii | 15 | 220275 | 1219 |
38885 | 38885 | 2022-02-05 | Idaho | 16 | 391151 | 4481 |
38886 | 38886 | 2022-02-05 | Illinois | 17 | 2962497 | 35157 |
38887 | 38887 | 2022-02-05 | Indiana | 18 | 1650853 | 21712 |
38888 | 38888 | 2022-02-05 | Iowa | 19 | 729700 | 8657 |
38889 | 38889 | 2022-02-05 | Kansas | 20 | 744965 | 7743 |
38890 | 38890 | 2022-02-05 | Kentucky | 21 | 1204762 | 13090 |
38891 | 38891 | 2022-02-05 | Louisiana | 22 | 1192375 | 15905 |
38892 | 38892 | 2022-02-05 | Maine | 23 | 181010 | 1804 |
38893 | 38893 | 2022-02-05 | Maryland | 24 | 963691 | 13691 |
38894 | 38894 | 2022-02-05 | Massachusetts | 25 | 1630462 | 22379 |
38895 | 38895 | 2022-02-05 | Michigan | 26 | 2289269 | 32835 |
38896 | 38896 | 2022-02-05 | Minnesota | 27 | 1359208 | 11749 |
38897 | 38897 | 2022-02-05 | Mississippi | 28 | 751862 | 11250 |
38898 | 38898 | 2022-02-05 | Missouri | 29 | 1370297 | 17859 |
38899 | 38899 | 2022-02-05 | Montana | 30 | 250718 | 3035 |
38900 | 38900 | 2022-02-05 | Nebraska | 31 | 445793 | 3755 |
38901 | 38901 | 2022-02-05 | Nevada | 32 | 665211 | 9144 |
38902 | 38902 | 2022-02-05 | New Hampshire | 33 | 281300 | 2246 |
38903 | 38903 | 2022-02-05 | New Jersey | 34 | 2129191 | 31948 |
38904 | 38904 | 2022-02-05 | New Mexico | 35 | 489701 | 6536 |
38905 | 38905 | 2022-02-05 | New York | 36 | 4827018 | 65013 |
38906 | 38906 | 2022-02-05 | North Carolina | 37 | 2470404 | 21107 |
38907 | 38907 | 2022-02-05 | North Dakota | 38 | 230163 | 2177 |
38908 | 38908 | 2022-02-05 | Northern Mariana Islands | 69 | 5891 | 23 |
38909 | 38909 | 2022-02-05 | Ohio | 39 | 2608055 | 34217 |
38910 | 38910 | 2022-02-05 | Oklahoma | 40 | 995546 | 12193 |
38911 | 38911 | 2022-02-05 | Oregon | 41 | 654343 | 6214 |
38912 | 38912 | 2022-02-05 | Pennsylvania | 42 | 2697242 | 41524 |
38913 | 38913 | 2022-02-05 | Puerto Rico | 72 | 496903 | 3939 |
38914 | 38914 | 2022-02-05 | Rhode Island | 44 | 347901 | 3354 |
38915 | 38915 | 2022-02-05 | South Carolina | 45 | 1406933 | 15791 |
38916 | 38916 | 2022-02-05 | South Dakota | 46 | 230240 | 2687 |
38917 | 38917 | 2022-02-05 | Tennessee | 47 | 1880559 | 22762 |
38918 | 38918 | 2022-02-05 | Texas | 48 | 6351228 | 80872 |
38919 | 38919 | 2022-02-05 | Utah | 49 | 898432 | 4173 |
38920 | 38920 | 2022-02-05 | Vermont | 50 | 106690 | 553 |
38921 | 38921 | 2022-02-05 | Virgin Islands | 78 | 14988 | 102 |
38922 | 38922 | 2022-02-05 | Virginia | 51 | 1572022 | 16703 |
38923 | 38923 | 2022-02-05 | Washington | 53 | 1365175 | 11068 |
38924 | 38924 | 2022-02-05 | West Virginia | 54 | 461846 | 5846 |
38925 | 38925 | 2022-02-05 | Wisconsin | 55 | 1535483 | 12600 |
38926 | 38926 | 2022-02-05 | 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 );