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-06-28 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 |
---|---|---|---|---|---|---|
46879 | 46879 | 2022-06-28 | Alabama | 1 | 1352915 | 19739 |
46880 | 46880 | 2022-06-28 | Alaska | 2 | 267648 | 1246 |
46881 | 46881 | 2022-06-28 | American Samoa | 60 | 6414 | 31 |
46882 | 46882 | 2022-06-28 | Arizona | 4 | 2109053 | 30452 |
46883 | 46883 | 2022-06-28 | Arkansas | 5 | 862823 | 11574 |
46884 | 46884 | 2022-06-28 | California | 6 | 10087984 | 92371 |
46885 | 46885 | 2022-06-28 | Colorado | 8 | 1537595 | 12953 |
46886 | 46886 | 2022-06-28 | Connecticut | 9 | 827615 | 11045 |
46887 | 46887 | 2022-06-28 | Delaware | 10 | 284461 | 2984 |
46888 | 46888 | 2022-06-28 | District of Columbia | 11 | 155817 | 1349 |
46889 | 46889 | 2022-06-28 | Florida | 12 | 6447100 | 75671 |
46890 | 46890 | 2022-06-28 | Georgia | 13 | 2553494 | 36952 |
46891 | 46891 | 2022-06-28 | Guam | 66 | 52557 | 372 |
46892 | 46892 | 2022-06-28 | Hawaii | 15 | 296007 | 1486 |
46893 | 46893 | 2022-06-28 | Idaho | 16 | 461766 | 4970 |
46894 | 46894 | 2022-06-28 | Illinois | 17 | 3427364 | 38559 |
46895 | 46895 | 2022-06-28 | Indiana | 18 | 1769015 | 23856 |
46896 | 46896 | 2022-06-28 | Iowa | 19 | 793888 | 9680 |
46897 | 46897 | 2022-06-28 | Kansas | 20 | 802635 | 8977 |
46898 | 46898 | 2022-06-28 | Kentucky | 21 | 1412437 | 16144 |
46899 | 46899 | 2022-06-28 | Louisiana | 22 | 1302530 | 17404 |
46900 | 46900 | 2022-06-28 | Maine | 23 | 269308 | 2413 |
46901 | 46901 | 2022-06-28 | Maryland | 24 | 1131638 | 14778 |
46902 | 46902 | 2022-06-28 | Massachusetts | 25 | 1920969 | 20910 |
46903 | 46903 | 2022-06-28 | Michigan | 26 | 2599713 | 36876 |
46904 | 46904 | 2022-06-28 | Minnesota | 27 | 1551880 | 13113 |
46905 | 46905 | 2022-06-28 | Mississippi | 28 | 832212 | 12516 |
46906 | 46906 | 2022-06-28 | Missouri | 29 | 1515512 | 20889 |
46907 | 46907 | 2022-06-28 | Montana | 30 | 285514 | 3444 |
46908 | 46908 | 2022-06-28 | Nebraska | 31 | 497100 | 4334 |
46909 | 46909 | 2022-06-28 | Nevada | 32 | 768271 | 11026 |
46910 | 46910 | 2022-06-28 | New Hampshire | 33 | 331619 | 2579 |
46911 | 46911 | 2022-06-28 | New Jersey | 34 | 2481697 | 34023 |
46912 | 46912 | 2022-06-28 | New Mexico | 35 | 561665 | 7926 |
46913 | 46913 | 2022-06-28 | New York | 36 | 5584234 | 68943 |
46914 | 46914 | 2022-06-28 | North Carolina | 37 | 2844931 | 25161 |
46915 | 46915 | 2022-06-28 | North Dakota | 38 | 248961 | 2342 |
46916 | 46916 | 2022-06-28 | Northern Mariana Islands | 69 | 11759 | 35 |
46917 | 46917 | 2022-06-28 | Ohio | 39 | 2831228 | 38778 |
46918 | 46918 | 2022-06-28 | Oklahoma | 40 | 1070735 | 14470 |
46919 | 46919 | 2022-06-28 | Oregon | 41 | 807890 | 7804 |
46920 | 46920 | 2022-06-28 | Pennsylvania | 42 | 2993089 | 45715 |
46921 | 46921 | 2022-06-28 | Puerto Rico | 72 | 798438 | 4544 |
46922 | 46922 | 2022-06-28 | Rhode Island | 44 | 402024 | 3609 |
46923 | 46923 | 2022-06-28 | South Carolina | 45 | 1546406 | 18033 |
46924 | 46924 | 2022-06-28 | South Dakota | 46 | 243269 | 2936 |
46925 | 46925 | 2022-06-28 | Tennessee | 47 | 2059137 | 26364 |
46926 | 46926 | 2022-06-28 | Texas | 48 | 7081610 | 88848 |
46927 | 46927 | 2022-06-28 | Utah | 49 | 975743 | 4816 |
46928 | 46928 | 2022-06-28 | Vermont | 50 | 135030 | 682 |
46929 | 46929 | 2022-06-28 | Virgin Islands | 78 | 20878 | 118 |
46930 | 46930 | 2022-06-28 | Virginia | 51 | 1862659 | 20558 |
46931 | 46931 | 2022-06-28 | Washington | 53 | 1654976 | 13239 |
46932 | 46932 | 2022-06-28 | West Virginia | 54 | 531176 | 7057 |
46933 | 46933 | 2022-06-28 | Wisconsin | 55 | 1722738 | 14778 |
46934 | 46934 | 2022-06-28 | Wyoming | 56 | 164456 | 1834 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );