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-09-09 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 |
---|---|---|---|---|---|---|
50967 | 50967 | 2022-09-09 | Alabama | 1 | 1505814 | 20268 |
50968 | 50968 | 2022-09-09 | Alaska | 2 | 293914 | 1297 |
50969 | 50969 | 2022-09-09 | American Samoa | 60 | 8217 | 34 |
50970 | 50970 | 2022-09-09 | Arizona | 4 | 2258040 | 31162 |
50971 | 50971 | 2022-09-09 | Arkansas | 5 | 940689 | 11953 |
50972 | 50972 | 2022-09-09 | California | 6 | 11163758 | 95407 |
50973 | 50973 | 2022-09-09 | Colorado | 8 | 1646331 | 13406 |
50974 | 50974 | 2022-09-09 | Connecticut | 9 | 880603 | 11299 |
50975 | 50975 | 2022-09-09 | Delaware | 10 | 304393 | 3080 |
50976 | 50976 | 2022-09-09 | District of Columbia | 11 | 166893 | 1382 |
50977 | 50977 | 2022-09-09 | Florida | 12 | 7066234 | 80386 |
50978 | 50978 | 2022-09-09 | Georgia | 13 | 2800323 | 38318 |
50979 | 50979 | 2022-09-09 | Guam | 66 | 59190 | 395 |
50980 | 50980 | 2022-09-09 | Hawaii | 15 | 332278 | 1652 |
50981 | 50981 | 2022-09-09 | Idaho | 16 | 491674 | 5134 |
50982 | 50982 | 2022-09-09 | Illinois | 17 | 3722867 | 39445 |
50983 | 50983 | 2022-09-09 | Indiana | 18 | 1908325 | 24506 |
50984 | 50984 | 2022-09-09 | Iowa | 19 | 847235 | 9968 |
50985 | 50985 | 2022-09-09 | Kansas | 20 | 869362 | 9051 |
50986 | 50986 | 2022-09-09 | Kentucky | 21 | 1566416 | 16757 |
50987 | 50987 | 2022-09-09 | Louisiana | 22 | 1442885 | 17923 |
50988 | 50988 | 2022-09-09 | Maine | 23 | 284624 | 2538 |
50989 | 50989 | 2022-09-09 | Maryland | 24 | 1232093 | 15247 |
50990 | 50990 | 2022-09-09 | Massachusetts | 25 | 2021331 | 21536 |
50991 | 50991 | 2022-09-09 | Michigan | 26 | 2786213 | 38121 |
50992 | 50992 | 2022-09-09 | Minnesota | 27 | 1645653 | 13509 |
50993 | 50993 | 2022-09-09 | Mississippi | 28 | 918874 | 12821 |
50994 | 50994 | 2022-09-09 | Missouri | 29 | 1645684 | 21548 |
50995 | 50995 | 2022-09-09 | Montana | 30 | 306875 | 3509 |
50996 | 50996 | 2022-09-09 | Nebraska | 31 | 533046 | 4488 |
50997 | 50997 | 2022-09-09 | Nevada | 32 | 843712 | 11422 |
50998 | 50998 | 2022-09-09 | New Hampshire | 33 | 345777 | 2670 |
50999 | 50999 | 2022-09-09 | New Jersey | 34 | 2694047 | 34622 |
51000 | 51000 | 2022-09-09 | New Mexico | 35 | 613896 | 8485 |
51001 | 51001 | 2022-09-09 | New York | 36 | 6009470 | 70588 |
51002 | 51002 | 2022-09-09 | North Carolina | 37 | 3141302 | 26375 |
51003 | 51003 | 2022-09-09 | North Dakota | 38 | 266273 | 2401 |
51004 | 51004 | 2022-09-09 | Northern Mariana Islands | 69 | 13147 | 40 |
51005 | 51005 | 2022-09-09 | Ohio | 39 | 3096557 | 39576 |
51006 | 51006 | 2022-09-09 | Oklahoma | 40 | 1182071 | 14765 |
51007 | 51007 | 2022-09-09 | Oregon | 41 | 883368 | 8471 |
51008 | 51008 | 2022-09-09 | Pennsylvania | 42 | 3202811 | 46831 |
51009 | 51009 | 2022-09-09 | Puerto Rico | 72 | 971835 | 5028 |
51010 | 51010 | 2022-09-09 | Rhode Island | 44 | 420175 | 3652 |
51011 | 51011 | 2022-09-09 | South Carolina | 45 | 1687640 | 18299 |
51012 | 51012 | 2022-09-09 | South Dakota | 46 | 258510 | 3002 |
51013 | 51013 | 2022-09-09 | Tennessee | 47 | 2257299 | 27252 |
51014 | 51014 | 2022-09-09 | Texas | 48 | 7800411 | 90588 |
51015 | 51015 | 2022-09-09 | Utah | 49 | 1032402 | 4989 |
51016 | 51016 | 2022-09-09 | Vermont | 50 | 140740 | 715 |
51017 | 51017 | 2022-09-09 | Virgin Islands | 78 | 22859 | 122 |
51018 | 51018 | 2022-09-09 | Virginia | 51 | 2058582 | 21587 |
51019 | 51019 | 2022-09-09 | Washington | 53 | 1794094 | 14173 |
51020 | 51020 | 2022-09-09 | West Virginia | 54 | 590441 | 7322 |
51021 | 51021 | 2022-09-09 | Wisconsin | 55 | 1843257 | 15120 |
51022 | 51022 | 2022-09-09 | Wyoming | 56 | 175290 | 1884 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );