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-06-17 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 |
---|---|---|---|---|---|---|
25920 | 25920 | 2021-06-17 | Alabama | 1 | 548323 | 11288 |
25921 | 25921 | 2021-06-17 | Alaska | 2 | 70183 | 356 |
25922 | 25922 | 2021-06-17 | Arizona | 4 | 888337 | 17809 |
25923 | 25923 | 2021-06-17 | Arkansas | 5 | 344945 | 5869 |
25924 | 25924 | 2021-06-17 | California | 6 | 3806400 | 63254 |
25925 | 25925 | 2021-06-17 | Colorado | 8 | 555819 | 6856 |
25926 | 25926 | 2021-06-17 | Connecticut | 9 | 348595 | 8266 |
25927 | 25927 | 2021-06-17 | Delaware | 10 | 109470 | 1679 |
25928 | 25928 | 2021-06-17 | District of Columbia | 11 | 49232 | 1140 |
25929 | 25929 | 2021-06-17 | Florida | 12 | 2309254 | 37448 |
25930 | 25930 | 2021-06-17 | Georgia | 13 | 1105638 | 20572 |
25931 | 25931 | 2021-06-17 | Guam | 66 | 9235 | 140 |
25932 | 25932 | 2021-06-17 | Hawaii | 15 | 35862 | 504 |
25933 | 25933 | 2021-06-17 | Idaho | 16 | 194084 | 2125 |
25934 | 25934 | 2021-06-17 | Illinois | 17 | 1392635 | 25552 |
25935 | 25935 | 2021-06-17 | Indiana | 18 | 753773 | 13764 |
25936 | 25936 | 2021-06-17 | Iowa | 19 | 372909 | 6109 |
25937 | 25937 | 2021-06-17 | Kansas | 20 | 317950 | 5161 |
25938 | 25938 | 2021-06-17 | Kentucky | 21 | 464100 | 7224 |
25939 | 25939 | 2021-06-17 | Louisiana | 22 | 477127 | 10677 |
25940 | 25940 | 2021-06-17 | Maine | 23 | 68717 | 854 |
25941 | 25941 | 2021-06-17 | Maryland | 24 | 461766 | 9698 |
25942 | 25942 | 2021-06-17 | Massachusetts | 25 | 709187 | 17957 |
25943 | 25943 | 2021-06-17 | Michigan | 26 | 996454 | 20835 |
25944 | 25944 | 2021-06-17 | Minnesota | 27 | 604277 | 7620 |
25945 | 25945 | 2021-06-17 | Mississippi | 28 | 319704 | 7369 |
25946 | 25946 | 2021-06-17 | Missouri | 29 | 624399 | 9833 |
25947 | 25947 | 2021-06-17 | Montana | 30 | 113200 | 1651 |
25948 | 25948 | 2021-06-17 | Nebraska | 31 | 224313 | 2517 |
25949 | 25949 | 2021-06-17 | Nevada | 32 | 328490 | 5642 |
25950 | 25950 | 2021-06-17 | New Hampshire | 33 | 99225 | 1366 |
25951 | 25951 | 2021-06-17 | New Jersey | 34 | 1020564 | 26364 |
25952 | 25952 | 2021-06-17 | New Mexico | 35 | 204577 | 4312 |
25953 | 25953 | 2021-06-17 | New York | 36 | 2108978 | 53009 |
25954 | 25954 | 2021-06-17 | North Carolina | 37 | 1010698 | 13339 |
25955 | 25955 | 2021-06-17 | North Dakota | 38 | 110551 | 1554 |
25956 | 25956 | 2021-06-17 | Northern Mariana Islands | 69 | 183 | 2 |
25957 | 25957 | 2021-06-17 | Ohio | 39 | 1108146 | 20122 |
25958 | 25958 | 2021-06-17 | Oklahoma | 40 | 455354 | 7354 |
25959 | 25959 | 2021-06-17 | Oregon | 41 | 206038 | 2776 |
25960 | 25960 | 2021-06-17 | Pennsylvania | 42 | 1214395 | 27597 |
25961 | 25961 | 2021-06-17 | Puerto Rico | 72 | 173109 | 2539 |
25962 | 25962 | 2021-06-17 | Rhode Island | 44 | 152359 | 2724 |
25963 | 25963 | 2021-06-17 | South Carolina | 45 | 595361 | 9790 |
25964 | 25964 | 2021-06-17 | South Dakota | 46 | 124393 | 2027 |
25965 | 25965 | 2021-06-17 | Tennessee | 47 | 853042 | 12412 |
25966 | 25966 | 2021-06-17 | Texas | 48 | 2976499 | 52219 |
25967 | 25967 | 2021-06-17 | Utah | 49 | 410816 | 2324 |
25968 | 25968 | 2021-06-17 | Vermont | 50 | 24357 | 256 |
25969 | 25969 | 2021-06-17 | Virgin Islands | 78 | 3747 | 30 |
25970 | 25970 | 2021-06-17 | Virginia | 51 | 678392 | 11336 |
25971 | 25971 | 2021-06-17 | Washington | 53 | 448263 | 5852 |
25972 | 25972 | 2021-06-17 | West Virginia | 54 | 163382 | 2863 |
25973 | 25973 | 2021-06-17 | Wisconsin | 55 | 676763 | 8046 |
25974 | 25974 | 2021-06-17 | Wyoming | 56 | 61425 | 734 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );