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-12-09 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 |
---|---|---|---|---|---|---|
56063 | 56063 | 2022-12-09 | Alabama | 1 | 1555092 | 21164 |
56064 | 56064 | 2022-12-09 | Alaska | 2 | 300732 | 1390 |
56065 | 56065 | 2022-12-09 | American Samoa | 60 | 8264 | 34 |
56066 | 56066 | 2022-12-09 | Arizona | 4 | 2353530 | 31824 |
56067 | 56067 | 2022-12-09 | Arkansas | 5 | 973879 | 12632 |
56068 | 56068 | 2022-12-09 | California | 6 | 11620250 | 100197 |
56069 | 56069 | 2022-12-09 | Colorado | 8 | 1718247 | 13724 |
56070 | 56070 | 2022-12-09 | Connecticut | 9 | 932781 | 11603 |
56071 | 56071 | 2022-12-09 | Delaware | 10 | 318567 | 3184 |
56072 | 56072 | 2022-12-09 | District of Columbia | 11 | 172044 | 1407 |
56073 | 56073 | 2022-12-09 | Florida | 12 | 7226875 | 83200 |
56074 | 56074 | 2022-12-09 | Georgia | 13 | 2867072 | 39748 |
56075 | 56075 | 2022-12-09 | Guam | 66 | 60429 | 410 |
56076 | 56076 | 2022-12-09 | Hawaii | 15 | 359809 | 1741 |
56077 | 56077 | 2022-12-09 | Idaho | 16 | 508022 | 5293 |
56078 | 56078 | 2022-12-09 | Illinois | 17 | 3913707 | 40406 |
56079 | 56079 | 2022-12-09 | Indiana | 18 | 1977292 | 25230 |
56080 | 56080 | 2022-12-09 | Iowa | 19 | 877068 | 10318 |
56081 | 56081 | 2022-12-09 | Kansas | 20 | 906301 | 9834 |
56082 | 56082 | 2022-12-09 | Kentucky | 21 | 1644975 | 17624 |
56083 | 56083 | 2022-12-09 | Louisiana | 22 | 1477545 | 18296 |
56084 | 56084 | 2022-12-09 | Maine | 23 | 303058 | 2801 |
56085 | 56085 | 2022-12-09 | Maryland | 24 | 1297366 | 15900 |
56086 | 56086 | 2022-12-09 | Massachusetts | 25 | 2124243 | 22574 |
56087 | 56087 | 2022-12-09 | Michigan | 26 | 2950361 | 40327 |
56088 | 56088 | 2022-12-09 | Minnesota | 27 | 1719549 | 14155 |
56089 | 56089 | 2022-12-09 | Mississippi | 28 | 943402 | 13082 |
56090 | 56090 | 2022-12-09 | Missouri | 29 | 1719890 | 23145 |
56091 | 56091 | 2022-12-09 | Montana | 30 | 320323 | 3628 |
56092 | 56092 | 2022-12-09 | Nebraska | 31 | 548352 | 4830 |
56093 | 56093 | 2022-12-09 | Nevada | 32 | 868630 | 11791 |
56094 | 56094 | 2022-12-09 | New Hampshire | 33 | 363029 | 2832 |
56095 | 56095 | 2022-12-09 | New Jersey | 34 | 2870860 | 35254 |
56096 | 56096 | 2022-12-09 | New Mexico | 35 | 652223 | 8760 |
56097 | 56097 | 2022-12-09 | New York | 36 | 6431394 | 77194 |
56098 | 56098 | 2022-12-09 | North Carolina | 37 | 3286948 | 28735 |
56099 | 56099 | 2022-12-09 | North Dakota | 38 | 278399 | 2457 |
56100 | 56100 | 2022-12-09 | Northern Mariana Islands | 69 | 13227 | 41 |
56101 | 56101 | 2022-12-09 | Ohio | 39 | 3259911 | 40810 |
56102 | 56102 | 2022-12-09 | Oklahoma | 40 | 1232202 | 16014 |
56103 | 56103 | 2022-12-09 | Oregon | 41 | 929127 | 8898 |
56104 | 56104 | 2022-12-09 | Pennsylvania | 42 | 3374733 | 48613 |
56105 | 56105 | 2022-12-09 | Puerto Rico | 72 | 1058197 | 5433 |
56106 | 56106 | 2022-12-09 | Rhode Island | 44 | 439773 | 3793 |
56107 | 56107 | 2022-12-09 | South Carolina | 45 | 1745166 | 19328 |
56108 | 56108 | 2022-12-09 | South Dakota | 46 | 269886 | 3126 |
56109 | 56109 | 2022-12-09 | Tennessee | 47 | 2339184 | 28124 |
56110 | 56110 | 2022-12-09 | Texas | 48 | 8019415 | 92456 |
56111 | 56111 | 2022-12-09 | Utah | 49 | 1066753 | 5138 |
56112 | 56112 | 2022-12-09 | Vermont | 50 | 147221 | 781 |
56113 | 56113 | 2022-12-09 | Virgin Islands | 78 | 23633 | 126 |
56114 | 56114 | 2022-12-09 | Virginia | 51 | 2163370 | 22672 |
56115 | 56115 | 2022-12-09 | Washington | 53 | 1865176 | 14862 |
56116 | 56116 | 2022-12-09 | West Virginia | 54 | 617094 | 7766 |
56117 | 56117 | 2022-12-09 | Wisconsin | 55 | 1937605 | 15749 |
56118 | 56118 | 2022-12-09 | Wyoming | 56 | 181695 | 1939 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );