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-01-02 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 |
---|---|---|---|---|---|---|
36967 | 36967 | 2022-01-02 | Alabama | 1 | 909541 | 16455 |
36968 | 36968 | 2022-01-02 | Alaska | 2 | 156130 | 954 |
36969 | 36969 | 2022-01-02 | American Samoa | 60 | 11 | 0 |
36970 | 36970 | 2022-01-02 | Arizona | 4 | 1390409 | 24355 |
36971 | 36971 | 2022-01-02 | Arkansas | 5 | 572822 | 9196 |
36972 | 36972 | 2022-01-02 | California | 6 | 5560323 | 76712 |
36973 | 36973 | 2022-01-02 | Colorado | 8 | 936422 | 10485 |
36974 | 36974 | 2022-01-02 | Connecticut | 9 | 510188 | 9160 |
36975 | 36975 | 2022-01-02 | Delaware | 10 | 186996 | 2286 |
36976 | 36976 | 2022-01-02 | District of Columbia | 11 | 94286 | 1211 |
36977 | 36977 | 2022-01-02 | Florida | 12 | 4166392 | 62504 |
36978 | 36978 | 2022-01-02 | Georgia | 13 | 1798497 | 30283 |
36979 | 36979 | 2022-01-02 | Guam | 66 | 20576 | 271 |
36980 | 36980 | 2022-01-02 | Hawaii | 15 | 115400 | 1091 |
36981 | 36981 | 2022-01-02 | Idaho | 16 | 319442 | 4163 |
36982 | 36982 | 2022-01-02 | Illinois | 17 | 2154058 | 31017 |
36983 | 36983 | 2022-01-02 | Indiana | 18 | 1250565 | 19037 |
36984 | 36984 | 2022-01-02 | Iowa | 19 | 575501 | 7858 |
36985 | 36985 | 2022-01-02 | Kansas | 20 | 520500 | 7030 |
36986 | 36986 | 2022-01-02 | Kentucky | 21 | 866894 | 12149 |
36987 | 36987 | 2022-01-02 | Louisiana | 22 | 828695 | 14986 |
36988 | 36988 | 2022-01-02 | Maine | 23 | 146736 | 1531 |
36989 | 36989 | 2022-01-02 | Maryland | 24 | 737437 | 11870 |
36990 | 36990 | 2022-01-02 | Massachusetts | 25 | 1140614 | 20273 |
36991 | 36991 | 2022-01-02 | Michigan | 26 | 1706355 | 28984 |
36992 | 36992 | 2022-01-02 | Minnesota | 27 | 1022352 | 10656 |
36993 | 36993 | 2022-01-02 | Mississippi | 28 | 543737 | 10450 |
36994 | 36994 | 2022-01-02 | Missouri | 29 | 1029231 | 16233 |
36995 | 36995 | 2022-01-02 | Montana | 30 | 197784 | 2907 |
36996 | 36996 | 2022-01-02 | Nebraska | 31 | 338257 | 3336 |
36997 | 36997 | 2022-01-02 | Nevada | 32 | 501181 | 8420 |
36998 | 36998 | 2022-01-02 | New Hampshire | 33 | 198667 | 1961 |
36999 | 36999 | 2022-01-02 | New Jersey | 34 | 1623096 | 29056 |
37000 | 37000 | 2022-01-02 | New Mexico | 35 | 350043 | 5857 |
37001 | 37001 | 2022-01-02 | New York | 36 | 3617589 | 59152 |
37002 | 37002 | 2022-01-02 | North Carolina | 37 | 1685504 | 19436 |
37003 | 37003 | 2022-01-02 | North Dakota | 38 | 174787 | 2057 |
37004 | 37004 | 2022-01-02 | Northern Mariana Islands | 69 | 3297 | 17 |
37005 | 37005 | 2022-01-02 | Ohio | 39 | 2053721 | 29447 |
37006 | 37006 | 2022-01-02 | Oklahoma | 40 | 708938 | 11552 |
37007 | 37007 | 2022-01-02 | Oregon | 41 | 421263 | 5655 |
37008 | 37008 | 2022-01-02 | Pennsylvania | 42 | 2077224 | 36715 |
37009 | 37009 | 2022-01-02 | Puerto Rico | 72 | 332003 | 3310 |
37010 | 37010 | 2022-01-02 | Rhode Island | 44 | 231096 | 3066 |
37011 | 37011 | 2022-01-02 | South Carolina | 45 | 975320 | 14636 |
37012 | 37012 | 2022-01-02 | South Dakota | 46 | 179204 | 2486 |
37013 | 37013 | 2022-01-02 | Tennessee | 47 | 1379917 | 20640 |
37014 | 37014 | 2022-01-02 | Texas | 48 | 4581606 | 76062 |
37015 | 37015 | 2022-01-02 | Utah | 49 | 637144 | 3787 |
37016 | 37016 | 2022-01-02 | Vermont | 50 | 64447 | 471 |
37017 | 37017 | 2022-01-02 | Virgin Islands | 78 | 9055 | 89 |
37018 | 37018 | 2022-01-02 | Virginia | 51 | 1118518 | 15587 |
37019 | 37019 | 2022-01-02 | Washington | 53 | 852824 | 9904 |
37020 | 37020 | 2022-01-02 | West Virginia | 54 | 328162 | 5336 |
37021 | 37021 | 2022-01-02 | Wisconsin | 55 | 1120669 | 11173 |
37022 | 37022 | 2022-01-02 | 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 );