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-22 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 |
---|---|---|---|---|---|---|
49959 | 49959 | 2022-08-22 | Alabama | 1 | 1470163 | 20046 |
49960 | 49960 | 2022-08-22 | Alaska | 2 | 289203 | 1290 |
49961 | 49961 | 2022-08-22 | American Samoa | 60 | 7471 | 33 |
49962 | 49962 | 2022-08-22 | Arizona | 4 | 2237208 | 30982 |
49963 | 49963 | 2022-08-22 | Arkansas | 5 | 923512 | 11861 |
49964 | 49964 | 2022-08-22 | California | 6 | 10987530 | 94571 |
49965 | 49965 | 2022-08-22 | Colorado | 8 | 1628707 | 13321 |
49966 | 49966 | 2022-08-22 | Connecticut | 9 | 869372 | 11180 |
49967 | 49967 | 2022-08-22 | Delaware | 10 | 300955 | 3039 |
49968 | 49968 | 2022-08-22 | District of Columbia | 11 | 165055 | 1377 |
49969 | 49969 | 2022-08-22 | Florida | 12 | 6971052 | 79236 |
49970 | 49970 | 2022-08-22 | Georgia | 13 | 2748287 | 37923 |
49971 | 49971 | 2022-08-22 | Guam | 66 | 58330 | 390 |
49972 | 49972 | 2022-08-22 | Hawaii | 15 | 327175 | 1616 |
49973 | 49973 | 2022-08-22 | Idaho | 16 | 486697 | 5095 |
49974 | 49974 | 2022-08-22 | Illinois | 17 | 3660411 | 39199 |
49975 | 49975 | 2022-08-22 | Indiana | 18 | 1876822 | 24339 |
49976 | 49976 | 2022-08-22 | Iowa | 19 | 834877 | 9882 |
49977 | 49977 | 2022-08-22 | Kansas | 20 | 854326 | 8965 |
49978 | 49978 | 2022-08-22 | Kentucky | 21 | 1535280 | 16603 |
49979 | 49979 | 2022-08-22 | Louisiana | 22 | 1413628 | 17795 |
49980 | 49980 | 2022-08-22 | Maine | 23 | 280403 | 2499 |
49981 | 49981 | 2022-08-22 | Maryland | 24 | 1211903 | 15114 |
49982 | 49982 | 2022-08-22 | Massachusetts | 25 | 1996454 | 21342 |
49983 | 49983 | 2022-08-22 | Michigan | 26 | 2731787 | 37774 |
49984 | 49984 | 2022-08-22 | Minnesota | 27 | 1621194 | 13393 |
49985 | 49985 | 2022-08-22 | Mississippi | 28 | 900888 | 12758 |
49986 | 49986 | 2022-08-22 | Missouri | 29 | 1617125 | 21327 |
49987 | 49987 | 2022-08-22 | Montana | 30 | 302734 | 3492 |
49988 | 49988 | 2022-08-22 | Nebraska | 31 | 525171 | 4445 |
49989 | 49989 | 2022-08-22 | Nevada | 32 | 837892 | 11359 |
49990 | 49990 | 2022-08-22 | New Hampshire | 33 | 342916 | 2647 |
49991 | 49991 | 2022-08-22 | New Jersey | 34 | 2656736 | 34467 |
49992 | 49992 | 2022-08-22 | New Mexico | 35 | 606805 | 8367 |
49993 | 49993 | 2022-08-22 | New York | 36 | 5937264 | 70162 |
49994 | 49994 | 2022-08-22 | North Carolina | 37 | 3074964 | 25770 |
49995 | 49995 | 2022-08-22 | North Dakota | 38 | 262554 | 2376 |
49996 | 49996 | 2022-08-22 | Northern Mariana Islands | 69 | 13050 | 40 |
49997 | 49997 | 2022-08-22 | Ohio | 39 | 3026110 | 39310 |
49998 | 49998 | 2022-08-22 | Oklahoma | 40 | 1156567 | 14643 |
49999 | 49999 | 2022-08-22 | Oregon | 41 | 872287 | 8354 |
50000 | 50000 | 2022-08-22 | Pennsylvania | 42 | 3150248 | 46514 |
50001 | 50001 | 2022-08-22 | Puerto Rico | 72 | 940446 | 4909 |
50002 | 50002 | 2022-08-22 | Rhode Island | 44 | 414931 | 3636 |
50003 | 50003 | 2022-08-22 | South Carolina | 45 | 1650748 | 18227 |
50004 | 50004 | 2022-08-22 | South Dakota | 46 | 254670 | 2979 |
50005 | 50005 | 2022-08-22 | Tennessee | 47 | 2198364 | 27040 |
50006 | 50006 | 2022-08-22 | Texas | 48 | 7667298 | 90121 |
50007 | 50007 | 2022-08-22 | Utah | 49 | 1023940 | 4953 |
50008 | 50008 | 2022-08-22 | Vermont | 50 | 139226 | 702 |
50009 | 50009 | 2022-08-22 | Virgin Islands | 78 | 22300 | 122 |
50010 | 50010 | 2022-08-22 | Virginia | 51 | 2017131 | 21263 |
50011 | 50011 | 2022-08-22 | Washington | 53 | 1774116 | 13978 |
50012 | 50012 | 2022-08-22 | West Virginia | 54 | 574724 | 7251 |
50013 | 50013 | 2022-08-22 | Wisconsin | 55 | 1818776 | 15013 |
50014 | 50014 | 2022-08-22 | 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 );