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-21 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 |
---|---|---|---|---|---|---|
49903 | 49903 | 2022-08-21 | Alabama | 1 | 1463933 | 20041 |
49904 | 49904 | 2022-08-21 | Alaska | 2 | 289203 | 1290 |
49905 | 49905 | 2022-08-21 | American Samoa | 60 | 7471 | 33 |
49906 | 49906 | 2022-08-21 | Arizona | 4 | 2237208 | 30982 |
49907 | 49907 | 2022-08-21 | Arkansas | 5 | 922679 | 11861 |
49908 | 49908 | 2022-08-21 | California | 6 | 10979626 | 94547 |
49909 | 49909 | 2022-08-21 | Colorado | 8 | 1627284 | 13304 |
49910 | 49910 | 2022-08-21 | Connecticut | 9 | 869106 | 11180 |
49911 | 49911 | 2022-08-21 | Delaware | 10 | 300245 | 3039 |
49912 | 49912 | 2022-08-21 | District of Columbia | 11 | 165055 | 1377 |
49913 | 49913 | 2022-08-21 | Florida | 12 | 6954834 | 79017 |
49914 | 49914 | 2022-08-21 | Georgia | 13 | 2748195 | 37923 |
49915 | 49915 | 2022-08-21 | Guam | 66 | 58175 | 390 |
49916 | 49916 | 2022-08-21 | Hawaii | 15 | 327175 | 1616 |
49917 | 49917 | 2022-08-21 | Idaho | 16 | 486209 | 5092 |
49918 | 49918 | 2022-08-21 | Illinois | 17 | 3652375 | 39180 |
49919 | 49919 | 2022-08-21 | Indiana | 18 | 1873396 | 24312 |
49920 | 49920 | 2022-08-21 | Iowa | 19 | 833187 | 9882 |
49921 | 49921 | 2022-08-21 | Kansas | 20 | 854160 | 8967 |
49922 | 49922 | 2022-08-21 | Kentucky | 21 | 1523205 | 16540 |
49923 | 49923 | 2022-08-21 | Louisiana | 22 | 1410817 | 17777 |
49924 | 49924 | 2022-08-21 | Maine | 23 | 280403 | 2499 |
49925 | 49925 | 2022-08-21 | Maryland | 24 | 1210586 | 15107 |
49926 | 49926 | 2022-08-21 | Massachusetts | 25 | 1996454 | 21342 |
49927 | 49927 | 2022-08-21 | Michigan | 26 | 2731787 | 37774 |
49928 | 49928 | 2022-08-21 | Minnesota | 27 | 1621194 | 13393 |
49929 | 49929 | 2022-08-21 | Mississippi | 28 | 900888 | 12758 |
49930 | 49930 | 2022-08-21 | Missouri | 29 | 1616283 | 21325 |
49931 | 49931 | 2022-08-21 | Montana | 30 | 302694 | 3492 |
49932 | 49932 | 2022-08-21 | Nebraska | 31 | 525171 | 4445 |
49933 | 49933 | 2022-08-21 | Nevada | 32 | 837461 | 11357 |
49934 | 49934 | 2022-08-21 | New Hampshire | 33 | 342460 | 2647 |
49935 | 49935 | 2022-08-21 | New Jersey | 34 | 2656123 | 34462 |
49936 | 49936 | 2022-08-21 | New Mexico | 35 | 605490 | 8349 |
49937 | 49937 | 2022-08-21 | New York | 36 | 5928033 | 70130 |
49938 | 49938 | 2022-08-21 | North Carolina | 37 | 3074964 | 25770 |
49939 | 49939 | 2022-08-21 | North Dakota | 38 | 262554 | 2376 |
49940 | 49940 | 2022-08-21 | Northern Mariana Islands | 69 | 12953 | 39 |
49941 | 49941 | 2022-08-21 | Ohio | 39 | 3026110 | 39310 |
49942 | 49942 | 2022-08-21 | Oklahoma | 40 | 1153471 | 14643 |
49943 | 49943 | 2022-08-21 | Oregon | 41 | 870690 | 8342 |
49944 | 49944 | 2022-08-21 | Pennsylvania | 42 | 3147474 | 46494 |
49945 | 49945 | 2022-08-21 | Puerto Rico | 72 | 939366 | 4909 |
49946 | 49946 | 2022-08-21 | Rhode Island | 44 | 414931 | 3636 |
49947 | 49947 | 2022-08-21 | South Carolina | 45 | 1650748 | 18227 |
49948 | 49948 | 2022-08-21 | South Dakota | 46 | 254670 | 2979 |
49949 | 49949 | 2022-08-21 | Tennessee | 47 | 2198364 | 27040 |
49950 | 49950 | 2022-08-21 | Texas | 48 | 7647335 | 90074 |
49951 | 49951 | 2022-08-21 | Utah | 49 | 1023940 | 4953 |
49952 | 49952 | 2022-08-21 | Vermont | 50 | 139226 | 702 |
49953 | 49953 | 2022-08-21 | Virgin Islands | 78 | 22300 | 122 |
49954 | 49954 | 2022-08-21 | Virginia | 51 | 2011057 | 21249 |
49955 | 49955 | 2022-08-21 | Washington | 53 | 1771143 | 13960 |
49956 | 49956 | 2022-08-21 | West Virginia | 54 | 572854 | 7234 |
49957 | 49957 | 2022-08-21 | Wisconsin | 55 | 1814426 | 15008 |
49958 | 49958 | 2022-08-21 | 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 );