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-10-14 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 |
---|---|---|---|---|---|---|
52927 | 52927 | 2022-10-14 | Alabama | 1 | 1528739 | 20505 |
52928 | 52928 | 2022-10-14 | Alaska | 2 | 297740 | 1350 |
52929 | 52929 | 2022-10-14 | American Samoa | 60 | 8251 | 34 |
52930 | 52930 | 2022-10-14 | Arizona | 4 | 2277635 | 31455 |
52931 | 52931 | 2022-10-14 | Arkansas | 5 | 955518 | 12359 |
52932 | 52932 | 2022-10-14 | California | 6 | 11317620 | 96460 |
52933 | 52933 | 2022-10-14 | Colorado | 8 | 1670653 | 13569 |
52934 | 52934 | 2022-10-14 | Connecticut | 9 | 904993 | 11403 |
52935 | 52935 | 2022-10-14 | Delaware | 10 | 310993 | 3136 |
52936 | 52936 | 2022-10-14 | District of Columbia | 11 | 169116 | 1392 |
52937 | 52937 | 2022-10-14 | Florida | 12 | 7139149 | 81910 |
52938 | 52938 | 2022-10-14 | Georgia | 13 | 2828618 | 38882 |
52939 | 52939 | 2022-10-14 | Guam | 66 | 59664 | 402 |
52940 | 52940 | 2022-10-14 | Hawaii | 15 | 349598 | 1696 |
52941 | 52941 | 2022-10-14 | Idaho | 16 | 498183 | 5201 |
52942 | 52942 | 2022-10-14 | Illinois | 17 | 3790782 | 39843 |
52943 | 52943 | 2022-10-14 | Indiana | 18 | 1930022 | 24816 |
52944 | 52944 | 2022-10-14 | Iowa | 19 | 859632 | 10126 |
52945 | 52945 | 2022-10-14 | Kansas | 20 | 883499 | 9609 |
52946 | 52946 | 2022-10-14 | Kentucky | 21 | 1600312 | 17111 |
52947 | 52947 | 2022-10-14 | Louisiana | 22 | 1459308 | 18136 |
52948 | 52948 | 2022-10-14 | Maine | 23 | 293532 | 2624 |
52949 | 52949 | 2022-10-14 | Maryland | 24 | 1259085 | 15469 |
52950 | 52950 | 2022-10-14 | Massachusetts | 25 | 2069848 | 21841 |
52951 | 52951 | 2022-10-14 | Michigan | 26 | 2861595 | 38919 |
52952 | 52952 | 2022-10-14 | Minnesota | 27 | 1676151 | 13738 |
52953 | 52953 | 2022-10-14 | Mississippi | 28 | 930438 | 12945 |
52954 | 52954 | 2022-10-14 | Missouri | 29 | 1677735 | 21791 |
52955 | 52955 | 2022-10-14 | Montana | 30 | 313031 | 3566 |
52956 | 52956 | 2022-10-14 | Nebraska | 31 | 539389 | 4552 |
52957 | 52957 | 2022-10-14 | Nevada | 32 | 850060 | 11535 |
52958 | 52958 | 2022-10-14 | New Hampshire | 33 | 353387 | 2715 |
52959 | 52959 | 2022-10-14 | New Jersey | 34 | 2767413 | 34823 |
52960 | 52960 | 2022-10-14 | New Mexico | 35 | 622170 | 8603 |
52961 | 52961 | 2022-10-14 | New York | 36 | 6166185 | 71435 |
52962 | 52962 | 2022-10-14 | North Carolina | 37 | 3220858 | 26895 |
52963 | 52963 | 2022-10-14 | North Dakota | 38 | 271085 | 2430 |
52964 | 52964 | 2022-10-14 | Northern Mariana Islands | 69 | 13171 | 40 |
52965 | 52965 | 2022-10-14 | Ohio | 39 | 3162278 | 40037 |
52966 | 52966 | 2022-10-14 | Oklahoma | 40 | 1203469 | 14924 |
52967 | 52967 | 2022-10-14 | Oregon | 41 | 902319 | 8622 |
52968 | 52968 | 2022-10-14 | Pennsylvania | 42 | 3280190 | 47442 |
52969 | 52969 | 2022-10-14 | Puerto Rico | 72 | 1000112 | 5206 |
52970 | 52970 | 2022-10-14 | Rhode Island | 44 | 428874 | 3681 |
52971 | 52971 | 2022-10-14 | South Carolina | 45 | 1715434 | 18468 |
52972 | 52972 | 2022-10-14 | South Dakota | 46 | 262837 | 3046 |
52973 | 52973 | 2022-10-14 | Tennessee | 47 | 2291224 | 27717 |
52974 | 52974 | 2022-10-14 | Texas | 48 | 7898606 | 91139 |
52975 | 52975 | 2022-10-14 | Utah | 49 | 1041933 | 5034 |
52976 | 52976 | 2022-10-14 | Vermont | 50 | 143683 | 732 |
52977 | 52977 | 2022-10-14 | Virgin Islands | 78 | 23240 | 123 |
52978 | 52978 | 2022-10-14 | Virginia | 51 | 2102929 | 22032 |
52979 | 52979 | 2022-10-14 | Washington | 53 | 1827975 | 14485 |
52980 | 52980 | 2022-10-14 | West Virginia | 54 | 604108 | 7470 |
52981 | 52981 | 2022-10-14 | Wisconsin | 55 | 1880837 | 15352 |
52982 | 52982 | 2022-10-14 | Wyoming | 56 | 177635 | 1904 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );