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-19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
49791 | 49791 | 2022-08-19 | Alabama | 1 | 1463933 | 20041 |
49792 | 49792 | 2022-08-19 | Alaska | 2 | 289203 | 1290 |
49793 | 49793 | 2022-08-19 | American Samoa | 60 | 7471 | 33 |
49794 | 49794 | 2022-08-19 | Arizona | 4 | 2237208 | 30982 |
49795 | 49795 | 2022-08-19 | Arkansas | 5 | 921796 | 11851 |
49796 | 49796 | 2022-08-19 | California | 6 | 10979626 | 94547 |
49797 | 49797 | 2022-08-19 | Colorado | 8 | 1627284 | 13304 |
49798 | 49798 | 2022-08-19 | Connecticut | 9 | 868194 | 11180 |
49799 | 49799 | 2022-08-19 | Delaware | 10 | 300245 | 3039 |
49800 | 49800 | 2022-08-19 | District of Columbia | 11 | 165055 | 1377 |
49801 | 49801 | 2022-08-19 | Florida | 12 | 6954834 | 79017 |
49802 | 49802 | 2022-08-19 | Georgia | 13 | 2748195 | 37923 |
49803 | 49803 | 2022-08-19 | Guam | 66 | 58175 | 390 |
49804 | 49804 | 2022-08-19 | Hawaii | 15 | 327175 | 1616 |
49805 | 49805 | 2022-08-19 | Idaho | 16 | 486209 | 5092 |
49806 | 49806 | 2022-08-19 | Illinois | 17 | 3652375 | 39180 |
49807 | 49807 | 2022-08-19 | Indiana | 18 | 1873396 | 24312 |
49808 | 49808 | 2022-08-19 | Iowa | 19 | 833187 | 9882 |
49809 | 49809 | 2022-08-19 | Kansas | 20 | 854160 | 8967 |
49810 | 49810 | 2022-08-19 | Kentucky | 21 | 1522407 | 16540 |
49811 | 49811 | 2022-08-19 | Louisiana | 22 | 1410817 | 17777 |
49812 | 49812 | 2022-08-19 | Maine | 23 | 280205 | 2499 |
49813 | 49813 | 2022-08-19 | Maryland | 24 | 1210586 | 15107 |
49814 | 49814 | 2022-08-19 | Massachusetts | 25 | 1996454 | 21342 |
49815 | 49815 | 2022-08-19 | Michigan | 26 | 2731787 | 37774 |
49816 | 49816 | 2022-08-19 | Minnesota | 27 | 1621194 | 13393 |
49817 | 49817 | 2022-08-19 | Mississippi | 28 | 900888 | 12758 |
49818 | 49818 | 2022-08-19 | Missouri | 29 | 1616284 | 21325 |
49819 | 49819 | 2022-08-19 | Montana | 30 | 302694 | 3492 |
49820 | 49820 | 2022-08-19 | Nebraska | 31 | 525171 | 4445 |
49821 | 49821 | 2022-08-19 | Nevada | 32 | 837461 | 11357 |
49822 | 49822 | 2022-08-19 | New Hampshire | 33 | 342460 | 2647 |
49823 | 49823 | 2022-08-19 | New Jersey | 34 | 2651571 | 34447 |
49824 | 49824 | 2022-08-19 | New Mexico | 35 | 605490 | 8349 |
49825 | 49825 | 2022-08-19 | New York | 36 | 5923462 | 70130 |
49826 | 49826 | 2022-08-19 | North Carolina | 37 | 3074964 | 25770 |
49827 | 49827 | 2022-08-19 | North Dakota | 38 | 262554 | 2376 |
49828 | 49828 | 2022-08-19 | Northern Mariana Islands | 69 | 12953 | 39 |
49829 | 49829 | 2022-08-19 | Ohio | 39 | 3026110 | 39310 |
49830 | 49830 | 2022-08-19 | Oklahoma | 40 | 1153471 | 14643 |
49831 | 49831 | 2022-08-19 | Oregon | 41 | 870690 | 8342 |
49832 | 49832 | 2022-08-19 | Pennsylvania | 42 | 3147474 | 46494 |
49833 | 49833 | 2022-08-19 | Puerto Rico | 72 | 934830 | 4899 |
49834 | 49834 | 2022-08-19 | Rhode Island | 44 | 414931 | 3636 |
49835 | 49835 | 2022-08-19 | South Carolina | 45 | 1650748 | 18227 |
49836 | 49836 | 2022-08-19 | South Dakota | 46 | 254670 | 2979 |
49837 | 49837 | 2022-08-19 | Tennessee | 47 | 2198364 | 27040 |
49838 | 49838 | 2022-08-19 | Texas | 48 | 7647335 | 90074 |
49839 | 49839 | 2022-08-19 | Utah | 49 | 1023940 | 4953 |
49840 | 49840 | 2022-08-19 | Vermont | 50 | 139226 | 702 |
49841 | 49841 | 2022-08-19 | Virgin Islands | 78 | 22300 | 122 |
49842 | 49842 | 2022-08-19 | Virginia | 51 | 2011057 | 21249 |
49843 | 49843 | 2022-08-19 | Washington | 53 | 1771143 | 13960 |
49844 | 49844 | 2022-08-19 | West Virginia | 54 | 572854 | 7234 |
49845 | 49845 | 2022-08-19 | Wisconsin | 55 | 1814426 | 15008 |
49846 | 49846 | 2022-08-19 | 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 );