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-05-26 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 |
---|---|---|---|---|---|---|
24710 | 24710 | 2021-05-26 | Alabama | 1 | 542831 | 11138 |
24711 | 24711 | 2021-05-26 | Alaska | 2 | 69542 | 352 |
24712 | 24712 | 2021-05-26 | Arizona | 4 | 878338 | 17576 |
24713 | 24713 | 2021-05-26 | Arkansas | 5 | 340698 | 5827 |
24714 | 24714 | 2021-05-26 | California | 6 | 3781388 | 63014 |
24715 | 24715 | 2021-05-26 | Colorado | 8 | 543060 | 6675 |
24716 | 24716 | 2021-05-26 | Connecticut | 9 | 346980 | 8227 |
24717 | 24717 | 2021-05-26 | Delaware | 10 | 108532 | 1660 |
24718 | 24718 | 2021-05-26 | District of Columbia | 11 | 48822 | 1131 |
24719 | 24719 | 2021-05-26 | Florida | 12 | 2316134 | 36646 |
24720 | 24720 | 2021-05-26 | Georgia | 13 | 1096882 | 20083 |
24721 | 24721 | 2021-05-26 | Guam | 66 | 9112 | 140 |
24722 | 24722 | 2021-05-26 | Hawaii | 15 | 34754 | 493 |
24723 | 24723 | 2021-05-26 | Idaho | 16 | 191810 | 2090 |
24724 | 24724 | 2021-05-26 | Illinois | 17 | 1382318 | 25057 |
24725 | 24725 | 2021-05-26 | Indiana | 18 | 745032 | 13571 |
24726 | 24726 | 2021-05-26 | Iowa | 19 | 371036 | 6044 |
24727 | 24727 | 2021-05-26 | Kansas | 20 | 315642 | 5099 |
24728 | 24728 | 2021-05-26 | Kentucky | 21 | 459068 | 6907 |
24729 | 24729 | 2021-05-26 | Louisiana | 22 | 469864 | 10562 |
24730 | 24730 | 2021-05-26 | Maine | 23 | 67294 | 825 |
24731 | 24731 | 2021-05-26 | Maryland | 24 | 459069 | 9037 |
24732 | 24732 | 2021-05-26 | Massachusetts | 25 | 706027 | 17841 |
24733 | 24733 | 2021-05-26 | Michigan | 26 | 988008 | 20224 |
24734 | 24734 | 2021-05-26 | Minnesota | 27 | 600002 | 7486 |
24735 | 24735 | 2021-05-26 | Mississippi | 28 | 317065 | 7302 |
24736 | 24736 | 2021-05-26 | Missouri | 29 | 613366 | 9652 |
24737 | 24737 | 2021-05-26 | Montana | 30 | 111557 | 1607 |
24738 | 24738 | 2021-05-26 | Nebraska | 31 | 223206 | 2377 |
24739 | 24739 | 2021-05-26 | Nevada | 32 | 323249 | 5570 |
24740 | 24740 | 2021-05-26 | New Hampshire | 33 | 98470 | 1346 |
24741 | 24741 | 2021-05-26 | New Jersey | 34 | 1014974 | 26137 |
24742 | 24742 | 2021-05-26 | New Mexico | 35 | 202573 | 4256 |
24743 | 24743 | 2021-05-26 | New York | 36 | 2096320 | 52664 |
24744 | 24744 | 2021-05-26 | North Carolina | 37 | 1000144 | 13054 |
24745 | 24745 | 2021-05-26 | North Dakota | 38 | 109810 | 1539 |
24746 | 24746 | 2021-05-26 | Northern Mariana Islands | 69 | 181 | 2 |
24747 | 24747 | 2021-05-26 | Ohio | 39 | 1099580 | 19753 |
24748 | 24748 | 2021-05-26 | Oklahoma | 40 | 452496 | 7291 |
24749 | 24749 | 2021-05-26 | Oregon | 41 | 199858 | 2667 |
24750 | 24750 | 2021-05-26 | Pennsylvania | 42 | 1203130 | 27180 |
24751 | 24751 | 2021-05-26 | Puerto Rico | 72 | 171709 | 2483 |
24752 | 24752 | 2021-05-26 | Rhode Island | 44 | 151580 | 2708 |
24753 | 24753 | 2021-05-26 | South Carolina | 45 | 591862 | 9708 |
24754 | 24754 | 2021-05-26 | South Dakota | 46 | 124071 | 2004 |
24755 | 24755 | 2021-05-26 | Tennessee | 47 | 847348 | 12306 |
24756 | 24756 | 2021-05-26 | Texas | 48 | 2943560 | 51516 |
24757 | 24757 | 2021-05-26 | Utah | 49 | 405148 | 2292 |
24758 | 24758 | 2021-05-26 | Vermont | 50 | 24162 | 255 |
24759 | 24759 | 2021-05-26 | Virgin Islands | 78 | 3399 | 27 |
24760 | 24760 | 2021-05-26 | Virginia | 51 | 674082 | 11143 |
24761 | 24761 | 2021-05-26 | Washington | 53 | 434154 | 5785 |
24762 | 24762 | 2021-05-26 | West Virginia | 54 | 160777 | 2788 |
24763 | 24763 | 2021-05-26 | Wisconsin | 55 | 673601 | 7765 |
24764 | 24764 | 2021-05-26 | Wyoming | 56 | 59961 | 719 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );