ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-08-31 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
30045 | 30045 | 2021-08-31 | Alabama | 1 | 699729 | 12283 |
30046 | 30046 | 2021-08-31 | Alaska | 2 | 87842 | 427 |
30047 | 30047 | 2021-08-31 | Arizona | 4 | 1011923 | 18786 |
30048 | 30048 | 2021-08-31 | Arkansas | 5 | 452891 | 6934 |
30049 | 30049 | 2021-08-31 | California | 6 | 4449186 | 65863 |
30050 | 30050 | 2021-08-31 | Colorado | 8 | 619083 | 7319 |
30051 | 30051 | 2021-08-31 | Connecticut | 9 | 373072 | 8358 |
30052 | 30052 | 2021-08-31 | Delaware | 10 | 119852 | 1880 |
30053 | 30053 | 2021-08-31 | District of Columbia | 11 | 55431 | 1160 |
30054 | 30054 | 2021-08-31 | Florida | 12 | 3250454 | 44561 |
30055 | 30055 | 2021-08-31 | Georgia | 13 | 1372605 | 22007 |
30056 | 30056 | 2021-08-31 | Guam | 66 | 11528 | 150 |
30057 | 30057 | 2021-08-31 | Hawaii | 15 | 61353 | 586 |
30058 | 30058 | 2021-08-31 | Idaho | 16 | 221463 | 2364 |
30059 | 30059 | 2021-08-31 | Illinois | 17 | 1527348 | 26500 |
30060 | 30060 | 2021-08-31 | Indiana | 18 | 861937 | 14491 |
30061 | 30061 | 2021-08-31 | Iowa | 19 | 404747 | 6268 |
30062 | 30062 | 2021-08-31 | Kansas | 20 | 370128 | 5589 |
30063 | 30063 | 2021-08-31 | Kentucky | 21 | 579693 | 7826 |
30064 | 30064 | 2021-08-31 | Louisiana | 22 | 679796 | 12359 |
30065 | 30065 | 2021-08-31 | Maine | 23 | 75856 | 932 |
30066 | 30066 | 2021-08-31 | Maryland | 24 | 497225 | 10014 |
30067 | 30067 | 2021-08-31 | Massachusetts | 25 | 759869 | 18246 |
30068 | 30068 | 2021-08-31 | Michigan | 26 | 1058765 | 21535 |
30069 | 30069 | 2021-08-31 | Minnesota | 27 | 650057 | 7904 |
30070 | 30070 | 2021-08-31 | Mississippi | 28 | 436722 | 8409 |
30071 | 30071 | 2021-08-31 | Missouri | 29 | 774864 | 11271 |
30072 | 30072 | 2021-08-31 | Montana | 30 | 127248 | 1800 |
30073 | 30073 | 2021-08-31 | Nebraska | 31 | 244254 | 2590 |
30074 | 30074 | 2021-08-31 | Nevada | 32 | 390600 | 6510 |
30075 | 30075 | 2021-08-31 | New Hampshire | 33 | 107689 | 1417 |
30076 | 30076 | 2021-08-31 | New Jersey | 34 | 1091966 | 26882 |
30077 | 30077 | 2021-08-31 | New Mexico | 35 | 232614 | 4520 |
30078 | 30078 | 2021-08-31 | New York | 36 | 2276228 | 53847 |
30079 | 30079 | 2021-08-31 | North Carolina | 37 | 1215455 | 14485 |
30080 | 30080 | 2021-08-31 | North Dakota | 38 | 117529 | 1592 |
30081 | 30081 | 2021-08-31 | Northern Mariana Islands | 69 | 241 | 2 |
30082 | 30082 | 2021-08-31 | Ohio | 39 | 1220900 | 20866 |
30083 | 30083 | 2021-08-31 | Oklahoma | 40 | 551958 | 7812 |
30084 | 30084 | 2021-08-31 | Oregon | 41 | 276287 | 3211 |
30085 | 30085 | 2021-08-31 | Pennsylvania | 42 | 1300368 | 28235 |
30086 | 30086 | 2021-08-31 | Puerto Rico | 72 | 204067 | 2860 |
30087 | 30087 | 2021-08-31 | Rhode Island | 44 | 162617 | 2770 |
30088 | 30088 | 2021-08-31 | South Carolina | 45 | 735287 | 10598 |
30089 | 30089 | 2021-08-31 | South Dakota | 46 | 132259 | 2069 |
30090 | 30090 | 2021-08-31 | Tennessee | 47 | 1032434 | 13378 |
30091 | 30091 | 2021-08-31 | Texas | 48 | 3604438 | 57205 |
30092 | 30092 | 2021-08-31 | Utah | 49 | 464502 | 2634 |
30093 | 30093 | 2021-08-31 | Vermont | 50 | 28200 | 276 |
30094 | 30094 | 2021-08-31 | Virgin Islands | 78 | 5864 | 54 |
30095 | 30095 | 2021-08-31 | Virginia | 51 | 766435 | 11842 |
30096 | 30096 | 2021-08-31 | Washington | 53 | 564787 | 6638 |
30097 | 30097 | 2021-08-31 | West Virginia | 54 | 189690 | 3084 |
30098 | 30098 | 2021-08-31 | Wisconsin | 55 | 734157 | 8462 |
30099 | 30099 | 2021-08-31 | Wyoming | 56 | 75136 | 858 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );