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-08-18 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 |
---|---|---|---|---|---|---|
49735 | 49735 | 2022-08-18 | Alabama | 1 | 1463933 | 20041 |
49736 | 49736 | 2022-08-18 | Alaska | 2 | 289203 | 1290 |
49737 | 49737 | 2022-08-18 | American Samoa | 60 | 7471 | 33 |
49738 | 49738 | 2022-08-18 | Arizona | 4 | 2237208 | 30982 |
49739 | 49739 | 2022-08-18 | Arkansas | 5 | 920830 | 11841 |
49740 | 49740 | 2022-08-18 | California | 6 | 10947473 | 94448 |
49741 | 49741 | 2022-08-18 | Colorado | 8 | 1626032 | 13301 |
49742 | 49742 | 2022-08-18 | Connecticut | 9 | 866984 | 11180 |
49743 | 49743 | 2022-08-18 | Delaware | 10 | 299822 | 3036 |
49744 | 49744 | 2022-08-18 | District of Columbia | 11 | 164815 | 1374 |
49745 | 49745 | 2022-08-18 | Florida | 12 | 6945453 | 78939 |
49746 | 49746 | 2022-08-18 | Georgia | 13 | 2748195 | 37923 |
49747 | 49747 | 2022-08-18 | Guam | 66 | 58073 | 390 |
49748 | 49748 | 2022-08-18 | Hawaii | 15 | 327175 | 1616 |
49749 | 49749 | 2022-08-18 | Idaho | 16 | 485618 | 5085 |
49750 | 49750 | 2022-08-18 | Illinois | 17 | 3647504 | 39160 |
49751 | 49751 | 2022-08-18 | Indiana | 18 | 1867509 | 24312 |
49752 | 49752 | 2022-08-18 | Iowa | 19 | 833187 | 9882 |
49753 | 49753 | 2022-08-18 | Kansas | 20 | 854160 | 8961 |
49754 | 49754 | 2022-08-18 | Kentucky | 21 | 1521581 | 16540 |
49755 | 49755 | 2022-08-18 | Louisiana | 22 | 1408809 | 17765 |
49756 | 49756 | 2022-08-18 | Maine | 23 | 279931 | 2497 |
49757 | 49757 | 2022-08-18 | Maryland | 24 | 1209060 | 15101 |
49758 | 49758 | 2022-08-18 | Massachusetts | 25 | 1996454 | 21342 |
49759 | 49759 | 2022-08-18 | Michigan | 26 | 2731787 | 37774 |
49760 | 49760 | 2022-08-18 | Minnesota | 27 | 1621194 | 13393 |
49761 | 49761 | 2022-08-18 | Mississippi | 28 | 899354 | 12751 |
49762 | 49762 | 2022-08-18 | Missouri | 29 | 1608673 | 21280 |
49763 | 49763 | 2022-08-18 | Montana | 30 | 300976 | 3481 |
49764 | 49764 | 2022-08-18 | Nebraska | 31 | 524339 | 4432 |
49765 | 49765 | 2022-08-18 | Nevada | 32 | 837104 | 11353 |
49766 | 49766 | 2022-08-18 | New Hampshire | 33 | 342243 | 2646 |
49767 | 49767 | 2022-08-18 | New Jersey | 34 | 2648876 | 34440 |
49768 | 49768 | 2022-08-18 | New Mexico | 35 | 604812 | 8344 |
49769 | 49769 | 2022-08-18 | New York | 36 | 5917733 | 70102 |
49770 | 49770 | 2022-08-18 | North Carolina | 37 | 3074964 | 25770 |
49771 | 49771 | 2022-08-18 | North Dakota | 38 | 262056 | 2376 |
49772 | 49772 | 2022-08-18 | Northern Mariana Islands | 69 | 12953 | 39 |
49773 | 49773 | 2022-08-18 | Ohio | 39 | 3026110 | 39310 |
49774 | 49774 | 2022-08-18 | Oklahoma | 40 | 1153471 | 14643 |
49775 | 49775 | 2022-08-18 | Oregon | 41 | 869782 | 8334 |
49776 | 49776 | 2022-08-18 | Pennsylvania | 42 | 3147474 | 46494 |
49777 | 49777 | 2022-08-18 | Puerto Rico | 72 | 932465 | 4889 |
49778 | 49778 | 2022-08-18 | Rhode Island | 44 | 414931 | 3636 |
49779 | 49779 | 2022-08-18 | South Carolina | 45 | 1650748 | 18227 |
49780 | 49780 | 2022-08-18 | South Dakota | 46 | 254670 | 2979 |
49781 | 49781 | 2022-08-18 | Tennessee | 47 | 2195147 | 27009 |
49782 | 49782 | 2022-08-18 | Texas | 48 | 7638144 | 90023 |
49783 | 49783 | 2022-08-18 | Utah | 49 | 1023940 | 4953 |
49784 | 49784 | 2022-08-18 | Vermont | 50 | 139226 | 702 |
49785 | 49785 | 2022-08-18 | Virgin Islands | 78 | 22300 | 122 |
49786 | 49786 | 2022-08-18 | Virginia | 51 | 2008336 | 21222 |
49787 | 49787 | 2022-08-18 | Washington | 53 | 1767339 | 13933 |
49788 | 49788 | 2022-08-18 | West Virginia | 54 | 571993 | 7230 |
49789 | 49789 | 2022-08-18 | Wisconsin | 55 | 1812581 | 15005 |
49790 | 49790 | 2022-08-18 | Wyoming | 56 | 173487 | 1871 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );