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-03 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 |
---|---|---|---|---|---|---|
48895 | 48895 | 2022-08-03 | Alabama | 1 | 1424411 | 19891 |
48896 | 48896 | 2022-08-03 | Alaska | 2 | 285126 | 1270 |
48897 | 48897 | 2022-08-03 | American Samoa | 60 | 7766 | 33 |
48898 | 48898 | 2022-08-03 | Arizona | 4 | 2211463 | 30842 |
48899 | 48899 | 2022-08-03 | Arkansas | 5 | 906952 | 11736 |
48900 | 48900 | 2022-08-03 | California | 6 | 10764622 | 93782 |
48901 | 48901 | 2022-08-03 | Colorado | 8 | 1609289 | 13220 |
48902 | 48902 | 2022-08-03 | Connecticut | 9 | 857105 | 11130 |
48903 | 48903 | 2022-08-03 | Delaware | 10 | 295460 | 3026 |
48904 | 48904 | 2022-08-03 | District of Columbia | 11 | 163192 | 1364 |
48905 | 48905 | 2022-08-03 | Florida | 12 | 6834572 | 77823 |
48906 | 48906 | 2022-08-03 | Georgia | 13 | 2699050 | 37640 |
48907 | 48907 | 2022-08-03 | Guam | 66 | 56715 | 383 |
48908 | 48908 | 2022-08-03 | Hawaii | 15 | 321378 | 1589 |
48909 | 48909 | 2022-08-03 | Idaho | 16 | 480717 | 5050 |
48910 | 48910 | 2022-08-03 | Illinois | 17 | 3590316 | 38923 |
48911 | 48911 | 2022-08-03 | Indiana | 18 | 1837688 | 24113 |
48912 | 48912 | 2022-08-03 | Iowa | 19 | 822356 | 9817 |
48913 | 48913 | 2022-08-03 | Kansas | 20 | 842282 | 8991 |
48914 | 48914 | 2022-08-03 | Kentucky | 21 | 1486349 | 16397 |
48915 | 48915 | 2022-08-03 | Louisiana | 22 | 1385619 | 17616 |
48916 | 48916 | 2022-08-03 | Maine | 23 | 276699 | 2481 |
48917 | 48917 | 2022-08-03 | Maryland | 24 | 1186986 | 15006 |
48918 | 48918 | 2022-08-03 | Massachusetts | 25 | 1966919 | 21176 |
48919 | 48919 | 2022-08-03 | Michigan | 26 | 2692485 | 37534 |
48920 | 48920 | 2022-08-03 | Minnesota | 27 | 1590564 | 13293 |
48921 | 48921 | 2022-08-03 | Mississippi | 28 | 880758 | 12675 |
48922 | 48922 | 2022-08-03 | Missouri | 29 | 1585051 | 21131 |
48923 | 48923 | 2022-08-03 | Montana | 30 | 297038 | 3473 |
48924 | 48924 | 2022-08-03 | Nebraska | 31 | 518268 | 4370 |
48925 | 48925 | 2022-08-03 | Nevada | 32 | 830502 | 11257 |
48926 | 48926 | 2022-08-03 | New Hampshire | 33 | 339186 | 2631 |
48927 | 48927 | 2022-08-03 | New Jersey | 34 | 2606229 | 34307 |
48928 | 48928 | 2022-08-03 | New Mexico | 35 | 594632 | 8269 |
48929 | 48929 | 2022-08-03 | New York | 36 | 5828675 | 69697 |
48930 | 48930 | 2022-08-03 | North Carolina | 37 | 3016425 | 25697 |
48931 | 48931 | 2022-08-03 | North Dakota | 38 | 258226 | 2356 |
48932 | 48932 | 2022-08-03 | Northern Mariana Islands | 69 | 12720 | 38 |
48933 | 48933 | 2022-08-03 | Ohio | 39 | 2948242 | 39035 |
48934 | 48934 | 2022-08-03 | Oklahoma | 40 | 1128347 | 14576 |
48935 | 48935 | 2022-08-03 | Oregon | 41 | 856231 | 8174 |
48936 | 48936 | 2022-08-03 | Pennsylvania | 42 | 3105341 | 46261 |
48937 | 48937 | 2022-08-03 | Puerto Rico | 72 | 893278 | 4784 |
48938 | 48938 | 2022-08-03 | Rhode Island | 44 | 411760 | 3630 |
48939 | 48939 | 2022-08-03 | South Carolina | 45 | 1605165 | 18192 |
48940 | 48940 | 2022-08-03 | South Dakota | 46 | 251860 | 2963 |
48941 | 48941 | 2022-08-03 | Tennessee | 47 | 2156111 | 26784 |
48942 | 48942 | 2022-08-03 | Texas | 48 | 7496176 | 89592 |
48943 | 48943 | 2022-08-03 | Utah | 49 | 1010550 | 4900 |
48944 | 48944 | 2022-08-03 | Vermont | 50 | 138145 | 693 |
48945 | 48945 | 2022-08-03 | Virgin Islands | 78 | 21869 | 121 |
48946 | 48946 | 2022-08-03 | Virginia | 51 | 1968329 | 20995 |
48947 | 48947 | 2022-08-03 | Washington | 53 | 1744292 | 13745 |
48948 | 48948 | 2022-08-03 | West Virginia | 54 | 559295 | 7169 |
48949 | 48949 | 2022-08-03 | Wisconsin | 55 | 1786641 | 14942 |
48950 | 48950 | 2022-08-03 | Wyoming | 56 | 171322 | 1856 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );