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-06-13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
46039 | 46039 | 2022-06-13 | Alabama | 1 | 1328321 | 19695 |
46040 | 46040 | 2022-06-13 | Alaska | 2 | 262901 | 1246 |
46041 | 46041 | 2022-06-13 | American Samoa | 60 | 6192 | 31 |
46042 | 46042 | 2022-06-13 | Arizona | 4 | 2077346 | 30372 |
46043 | 46043 | 2022-06-13 | Arkansas | 5 | 850535 | 11526 |
46044 | 46044 | 2022-06-13 | California | 6 | 9802778 | 91881 |
46045 | 46045 | 2022-06-13 | Colorado | 8 | 1495617 | 12834 |
46046 | 46046 | 2022-06-13 | Connecticut | 9 | 817973 | 11000 |
46047 | 46047 | 2022-06-13 | Delaware | 10 | 280252 | 2970 |
46048 | 46048 | 2022-06-13 | District of Columbia | 11 | 152799 | 1348 |
46049 | 46049 | 2022-06-13 | Florida | 12 | 6297767 | 74948 |
46050 | 46050 | 2022-06-13 | Georgia | 13 | 2517135 | 36803 |
46051 | 46051 | 2022-06-13 | Guam | 66 | 51089 | 370 |
46052 | 46052 | 2022-06-13 | Hawaii | 15 | 283574 | 1462 |
46053 | 46053 | 2022-06-13 | Idaho | 16 | 456232 | 4953 |
46054 | 46054 | 2022-06-13 | Illinois | 17 | 3367572 | 38320 |
46055 | 46055 | 2022-06-13 | Indiana | 18 | 1750973 | 23778 |
46056 | 46056 | 2022-06-13 | Iowa | 19 | 785918 | 9615 |
46057 | 46057 | 2022-06-13 | Kansas | 20 | 794584 | 8967 |
46058 | 46058 | 2022-06-13 | Kentucky | 21 | 1390472 | 16063 |
46059 | 46059 | 2022-06-13 | Louisiana | 22 | 1277101 | 17361 |
46060 | 46060 | 2022-06-13 | Maine | 23 | 266105 | 2403 |
46061 | 46061 | 2022-06-13 | Maryland | 24 | 1109546 | 14678 |
46062 | 46062 | 2022-06-13 | Massachusetts | 25 | 1898495 | 20763 |
46063 | 46063 | 2022-06-13 | Michigan | 26 | 2565819 | 36538 |
46064 | 46064 | 2022-06-13 | Minnesota | 27 | 1529010 | 13034 |
46065 | 46065 | 2022-06-13 | Mississippi | 28 | 816572 | 12481 |
46066 | 46066 | 2022-06-13 | Missouri | 29 | 1491318 | 20811 |
46067 | 46067 | 2022-06-13 | Montana | 30 | 281363 | 3434 |
46068 | 46068 | 2022-06-13 | Nebraska | 31 | 491350 | 4323 |
46069 | 46069 | 2022-06-13 | Nevada | 32 | 752790 | 10944 |
46070 | 46070 | 2022-06-13 | New Hampshire | 33 | 328834 | 2564 |
46071 | 46071 | 2022-06-13 | New Jersey | 34 | 2438510 | 33860 |
46072 | 46072 | 2022-06-13 | New Mexico | 35 | 547351 | 7865 |
46073 | 46073 | 2022-06-13 | New York | 36 | 5506904 | 68624 |
46074 | 46074 | 2022-06-13 | North Carolina | 37 | 2801365 | 25104 |
46075 | 46075 | 2022-06-13 | North Dakota | 38 | 246544 | 2332 |
46076 | 46076 | 2022-06-13 | Northern Mariana Islands | 69 | 11403 | 34 |
46077 | 46077 | 2022-06-13 | Ohio | 39 | 2798900 | 38657 |
46078 | 46078 | 2022-06-13 | Oklahoma | 40 | 1058297 | 14458 |
46079 | 46079 | 2022-06-13 | Oregon | 41 | 785032 | 7707 |
46080 | 46080 | 2022-06-13 | Pennsylvania | 42 | 2960677 | 45465 |
46081 | 46081 | 2022-06-13 | Puerto Rico | 72 | 752190 | 4440 |
46082 | 46082 | 2022-06-13 | Rhode Island | 44 | 397758 | 3591 |
46083 | 46083 | 2022-06-13 | South Carolina | 45 | 1514423 | 17970 |
46084 | 46084 | 2022-06-13 | South Dakota | 46 | 241326 | 2928 |
46085 | 46085 | 2022-06-13 | Tennessee | 47 | 2030680 | 26241 |
46086 | 46086 | 2022-06-13 | Texas | 48 | 6954222 | 88684 |
46087 | 46087 | 2022-06-13 | Utah | 49 | 962441 | 4793 |
46088 | 46088 | 2022-06-13 | Vermont | 50 | 133669 | 673 |
46089 | 46089 | 2022-06-13 | Virgin Islands | 78 | 20472 | 115 |
46090 | 46090 | 2022-06-13 | Virginia | 51 | 1824660 | 20441 |
46091 | 46091 | 2022-06-13 | Washington | 53 | 1617271 | 13103 |
46092 | 46092 | 2022-06-13 | West Virginia | 54 | 523367 | 7001 |
46093 | 46093 | 2022-06-13 | Wisconsin | 55 | 1699875 | 14690 |
46094 | 46094 | 2022-06-13 | Wyoming | 56 | 159707 | 1824 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );