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-01-24 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 |
---|---|---|---|---|---|---|
18000 | 18000 | 2021-01-24 | Alabama | 1 | 441170 | 6660 |
18001 | 18001 | 2021-01-24 | Alaska | 2 | 52982 | 250 |
18002 | 18002 | 2021-01-24 | Arizona | 4 | 722574 | 12238 |
18003 | 18003 | 2021-01-24 | Arkansas | 5 | 284066 | 4606 |
18004 | 18004 | 2021-01-24 | California | 6 | 3186036 | 37118 |
18005 | 18005 | 2021-01-24 | Colorado | 8 | 387960 | 5588 |
18006 | 18006 | 2021-01-24 | Connecticut | 9 | 237815 | 6819 |
18007 | 18007 | 2021-01-24 | Delaware | 10 | 74575 | 1041 |
18008 | 18008 | 2021-01-24 | District of Columbia | 11 | 35301 | 872 |
18009 | 18009 | 2021-01-24 | Florida | 12 | 1649441 | 25292 |
18010 | 18010 | 2021-01-24 | Georgia | 13 | 842798 | 12838 |
18011 | 18011 | 2021-01-24 | Guam | 66 | 8516 | 129 |
18012 | 18012 | 2021-01-24 | Hawaii | 15 | 25093 | 339 |
18013 | 18013 | 2021-01-24 | Idaho | 16 | 159581 | 1671 |
18014 | 18014 | 2021-01-24 | Illinois | 17 | 1104206 | 20680 |
18015 | 18015 | 2021-01-24 | Indiana | 18 | 614120 | 9716 |
18016 | 18016 | 2021-01-24 | Iowa | 19 | 313140 | 4487 |
18017 | 18017 | 2021-01-24 | Kansas | 20 | 269611 | 3598 |
18018 | 18018 | 2021-01-24 | Kentucky | 21 | 349194 | 3687 |
18019 | 18019 | 2021-01-24 | Louisiana | 22 | 383862 | 8565 |
18020 | 18020 | 2021-01-24 | Maine | 23 | 36598 | 544 |
18021 | 18021 | 2021-01-24 | Maryland | 24 | 341666 | 6865 |
18022 | 18022 | 2021-01-24 | Massachusetts | 25 | 500037 | 14133 |
18023 | 18023 | 2021-01-24 | Michigan | 26 | 594700 | 15170 |
18024 | 18024 | 2021-01-24 | Minnesota | 27 | 455057 | 6163 |
18025 | 18025 | 2021-01-24 | Mississippi | 28 | 264219 | 5772 |
18026 | 18026 | 2021-01-24 | Missouri | 29 | 487640 | 6956 |
18027 | 18027 | 2021-01-24 | Montana | 30 | 91662 | 1152 |
18028 | 18028 | 2021-01-24 | Nebraska | 31 | 188241 | 1966 |
18029 | 18029 | 2021-01-24 | Nevada | 32 | 271029 | 4027 |
18030 | 18030 | 2021-01-24 | New Hampshire | 33 | 62337 | 987 |
18031 | 18031 | 2021-01-24 | New Jersey | 34 | 662808 | 20951 |
18032 | 18032 | 2021-01-24 | New Mexico | 35 | 169205 | 3147 |
18033 | 18033 | 2021-01-24 | New York | 36 | 1335952 | 41889 |
18034 | 18034 | 2021-01-24 | North Carolina | 37 | 718955 | 8739 |
18035 | 18035 | 2021-01-24 | North Dakota | 38 | 96842 | 1436 |
18036 | 18036 | 2021-01-24 | Northern Mariana Islands | 69 | 129 | 2 |
18037 | 18037 | 2021-01-24 | Ohio | 39 | 864322 | 10711 |
18038 | 18038 | 2021-01-24 | Oklahoma | 40 | 373090 | 3279 |
18039 | 18039 | 2021-01-24 | Oregon | 41 | 138168 | 1885 |
18040 | 18040 | 2021-01-24 | Pennsylvania | 42 | 808951 | 20609 |
18041 | 18041 | 2021-01-24 | Puerto Rico | 72 | 124643 | 1773 |
18042 | 18042 | 2021-01-24 | Rhode Island | 44 | 109735 | 2083 |
18043 | 18043 | 2021-01-24 | South Carolina | 45 | 418325 | 6547 |
18044 | 18044 | 2021-01-24 | South Dakota | 46 | 107148 | 1705 |
18045 | 18045 | 2021-01-24 | Tennessee | 47 | 694381 | 8776 |
18046 | 18046 | 2021-01-24 | Texas | 48 | 2247849 | 35050 |
18047 | 18047 | 2021-01-24 | Utah | 49 | 336405 | 1595 |
18048 | 18048 | 2021-01-24 | Vermont | 50 | 11033 | 170 |
18049 | 18049 | 2021-01-24 | Virgin Islands | 78 | 2341 | 24 |
18050 | 18050 | 2021-01-24 | Virginia | 51 | 472447 | 6078 |
18051 | 18051 | 2021-01-24 | Washington | 53 | 304523 | 4182 |
18052 | 18052 | 2021-01-24 | West Virginia | 54 | 115307 | 1895 |
18053 | 18053 | 2021-01-24 | Wisconsin | 55 | 581377 | 6193 |
18054 | 18054 | 2021-01-24 | Wyoming | 56 | 50898 | 571 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );