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 2021-12-16 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 |
---|---|---|---|---|---|---|
36015 | 36015 | 2021-12-16 | Alabama | 1 | 855692 | 16320 |
36016 | 36016 | 2021-12-16 | Alaska | 2 | 153222 | 865 |
36017 | 36017 | 2021-12-16 | American Samoa | 60 | 10 | 0 |
36018 | 36018 | 2021-12-16 | Arizona | 4 | 1326908 | 23344 |
36019 | 36019 | 2021-12-16 | Arkansas | 5 | 541315 | 8913 |
36020 | 36020 | 2021-12-16 | California | 6 | 5192915 | 75792 |
36021 | 36021 | 2021-12-16 | Colorado | 8 | 869105 | 10024 |
36022 | 36022 | 2021-12-16 | Connecticut | 9 | 454123 | 9002 |
36023 | 36023 | 2021-12-16 | Delaware | 10 | 163021 | 2231 |
36024 | 36024 | 2021-12-16 | District of Columbia | 11 | 70375 | 1204 |
36025 | 36025 | 2021-12-16 | Florida | 12 | 3730654 | 62191 |
36026 | 36026 | 2021-12-16 | Georgia | 13 | 1654618 | 29783 |
36027 | 36027 | 2021-12-16 | Guam | 66 | 20326 | 271 |
36028 | 36028 | 2021-12-16 | Hawaii | 15 | 87241 | 1062 |
36029 | 36029 | 2021-12-16 | Idaho | 16 | 313450 | 4063 |
36030 | 36030 | 2021-12-16 | Illinois | 17 | 1938824 | 30135 |
36031 | 36031 | 2021-12-16 | Indiana | 18 | 1180081 | 18332 |
36032 | 36032 | 2021-12-16 | Iowa | 19 | 553407 | 7680 |
36033 | 36033 | 2021-12-16 | Kansas | 20 | 494555 | 6924 |
36034 | 36034 | 2021-12-16 | Kentucky | 21 | 827522 | 11766 |
36035 | 36035 | 2021-12-16 | Louisiana | 22 | 779567 | 14918 |
36036 | 36036 | 2021-12-16 | Maine | 23 | 134170 | 1405 |
36037 | 36037 | 2021-12-16 | Maryland | 24 | 592912 | 11255 |
36038 | 36038 | 2021-12-16 | Massachusetts | 25 | 998400 | 19783 |
36039 | 36039 | 2021-12-16 | Michigan | 26 | 1596654 | 27425 |
36040 | 36040 | 2021-12-16 | Minnesota | 27 | 975571 | 10181 |
36041 | 36041 | 2021-12-16 | Mississippi | 28 | 521544 | 10351 |
36042 | 36042 | 2021-12-16 | Missouri | 29 | 968296 | 15853 |
36043 | 36043 | 2021-12-16 | Montana | 30 | 194769 | 2875 |
36044 | 36044 | 2021-12-16 | Nebraska | 31 | 325655 | 3282 |
36045 | 36045 | 2021-12-16 | Nevada | 32 | 482138 | 8263 |
36046 | 36046 | 2021-12-16 | New Hampshire | 33 | 181660 | 1828 |
36047 | 36047 | 2021-12-16 | New Jersey | 34 | 1323331 | 28659 |
36048 | 36048 | 2021-12-16 | New Mexico | 35 | 335617 | 5551 |
36049 | 36049 | 2021-12-16 | New York | 36 | 2897347 | 57911 |
36050 | 36050 | 2021-12-16 | North Carolina | 37 | 1585363 | 19109 |
36051 | 36051 | 2021-12-16 | North Dakota | 38 | 168711 | 2016 |
36052 | 36052 | 2021-12-16 | Northern Mariana Islands | 69 | 2205 | 6 |
36053 | 36053 | 2021-12-16 | Ohio | 39 | 1819342 | 27594 |
36054 | 36054 | 2021-12-16 | Oklahoma | 40 | 684579 | 11435 |
36055 | 36055 | 2021-12-16 | Oregon | 41 | 404229 | 5527 |
36056 | 36056 | 2021-12-16 | Pennsylvania | 42 | 1865568 | 35095 |
36057 | 36057 | 2021-12-16 | Puerto Rico | 72 | 223921 | 3278 |
36058 | 36058 | 2021-12-16 | Rhode Island | 44 | 207556 | 2985 |
36059 | 36059 | 2021-12-16 | South Carolina | 45 | 934880 | 14445 |
36060 | 36060 | 2021-12-16 | South Dakota | 46 | 173257 | 2430 |
36061 | 36061 | 2021-12-16 | Tennessee | 47 | 1315999 | 17782 |
36062 | 36062 | 2021-12-16 | Texas | 48 | 4404958 | 75212 |
36063 | 36063 | 2021-12-16 | Utah | 49 | 616824 | 3697 |
36064 | 36064 | 2021-12-16 | Vermont | 50 | 57333 | 448 |
36065 | 36065 | 2021-12-16 | Virgin Islands | 78 | 7612 | 88 |
36066 | 36066 | 2021-12-16 | Virginia | 51 | 1009933 | 15055 |
36067 | 36067 | 2021-12-16 | Washington | 53 | 801122 | 9702 |
36068 | 36068 | 2021-12-16 | West Virginia | 54 | 311524 | 5142 |
36069 | 36069 | 2021-12-16 | Wisconsin | 55 | 1049488 | 10611 |
36070 | 36070 | 2021-12-16 | Wyoming | 56 | 113478 | 1502 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );