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-11-19 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 |
---|---|---|---|---|---|---|
54943 | 54943 | 2022-11-19 | Alabama | 1 | 1542227 | 21100 |
54944 | 54944 | 2022-11-19 | Alaska | 2 | 299411 | 1390 |
54945 | 54945 | 2022-11-19 | American Samoa | 60 | 8262 | 34 |
54946 | 54946 | 2022-11-19 | Arizona | 4 | 2311150 | 31648 |
54947 | 54947 | 2022-11-19 | Arkansas | 5 | 965367 | 12544 |
54948 | 54948 | 2022-11-19 | California | 6 | 11448703 | 99637 |
54949 | 54949 | 2022-11-19 | Colorado | 8 | 1695257 | 13546 |
54950 | 54950 | 2022-11-19 | Connecticut | 9 | 921038 | 11559 |
54951 | 54951 | 2022-11-19 | Delaware | 10 | 315555 | 3163 |
54952 | 54952 | 2022-11-19 | District of Columbia | 11 | 170750 | 1403 |
54953 | 54953 | 2022-11-19 | Florida | 12 | 7195943 | 82875 |
54954 | 54954 | 2022-11-19 | Georgia | 13 | 2847567 | 39498 |
54955 | 54955 | 2022-11-19 | Guam | 66 | 60008 | 407 |
54956 | 54956 | 2022-11-19 | Hawaii | 15 | 356312 | 1719 |
54957 | 54957 | 2022-11-19 | Idaho | 16 | 503483 | 5259 |
54958 | 54958 | 2022-11-19 | Illinois | 17 | 3857371 | 40198 |
54959 | 54959 | 2022-11-19 | Indiana | 18 | 1953497 | 25079 |
54960 | 54960 | 2022-11-19 | Iowa | 19 | 868595 | 10255 |
54961 | 54961 | 2022-11-19 | Kansas | 20 | 895788 | 9793 |
54962 | 54962 | 2022-11-19 | Kentucky | 21 | 1628396 | 17507 |
54963 | 54963 | 2022-11-19 | Louisiana | 22 | 1467573 | 18234 |
54964 | 54964 | 2022-11-19 | Maine | 23 | 300355 | 2747 |
54965 | 54965 | 2022-11-19 | Maryland | 24 | 1281632 | 15765 |
54966 | 54966 | 2022-11-19 | Massachusetts | 25 | 2104453 | 22303 |
54967 | 54967 | 2022-11-19 | Michigan | 26 | 2920679 | 39697 |
54968 | 54968 | 2022-11-19 | Minnesota | 27 | 1701401 | 13982 |
54969 | 54969 | 2022-11-19 | Mississippi | 28 | 936814 | 13047 |
54970 | 54970 | 2022-11-19 | Missouri | 29 | 1700293 | 23007 |
54971 | 54971 | 2022-11-19 | Montana | 30 | 317299 | 3605 |
54972 | 54972 | 2022-11-19 | Nebraska | 31 | 540443 | 4774 |
54973 | 54973 | 2022-11-19 | Nevada | 32 | 859537 | 11725 |
54974 | 54974 | 2022-11-19 | New Hampshire | 33 | 359898 | 2799 |
54975 | 54975 | 2022-11-19 | New Jersey | 34 | 2828391 | 35056 |
54976 | 54976 | 2022-11-19 | New Mexico | 35 | 639727 | 8714 |
54977 | 54977 | 2022-11-19 | New York | 36 | 6322200 | 76525 |
54978 | 54978 | 2022-11-19 | North Carolina | 37 | 3262335 | 28519 |
54979 | 54979 | 2022-11-19 | North Dakota | 38 | 275510 | 2434 |
54980 | 54980 | 2022-11-19 | Northern Mariana Islands | 69 | 13212 | 41 |
54981 | 54981 | 2022-11-19 | Ohio | 39 | 3218335 | 40533 |
54982 | 54982 | 2022-11-19 | Oklahoma | 40 | 1217825 | 15778 |
54983 | 54983 | 2022-11-19 | Oregon | 41 | 917164 | 8794 |
54984 | 54984 | 2022-11-19 | Pennsylvania | 42 | 3340015 | 48212 |
54985 | 54985 | 2022-11-19 | Puerto Rico | 72 | 1034576 | 5320 |
54986 | 54986 | 2022-11-19 | Rhode Island | 44 | 435778 | 3757 |
54987 | 54987 | 2022-11-19 | South Carolina | 45 | 1732287 | 19250 |
54988 | 54988 | 2022-11-19 | South Dakota | 46 | 266843 | 3106 |
54989 | 54989 | 2022-11-19 | Tennessee | 47 | 2318836 | 27952 |
54990 | 54990 | 2022-11-19 | Texas | 48 | 7959755 | 92261 |
54991 | 54991 | 2022-11-19 | Utah | 49 | 1054340 | 5089 |
54992 | 54992 | 2022-11-19 | Vermont | 50 | 146143 | 763 |
54993 | 54993 | 2022-11-19 | Virgin Islands | 78 | 23445 | 124 |
54994 | 54994 | 2022-11-19 | Virginia | 51 | 2137759 | 22419 |
54995 | 54995 | 2022-11-19 | Washington | 53 | 1848786 | 14742 |
54996 | 54996 | 2022-11-19 | West Virginia | 54 | 612262 | 7703 |
54997 | 54997 | 2022-11-19 | Wisconsin | 55 | 1915298 | 15627 |
54998 | 54998 | 2022-11-19 | Wyoming | 56 | 179838 | 1924 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );