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 2021-10-01 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 |
---|---|---|---|---|---|---|
31759 | 31759 | 2021-10-01 | Alabama | 1 | 798320 | 14393 |
31760 | 31760 | 2021-10-01 | Alaska | 2 | 114867 | 560 |
31761 | 31761 | 2021-10-01 | American Samoa | 60 | 1 | 0 |
31762 | 31762 | 2021-10-01 | Arizona | 4 | 1097225 | 20039 |
31763 | 31763 | 2021-10-01 | Arkansas | 5 | 496934 | 7718 |
31764 | 31764 | 2021-10-01 | California | 6 | 4747079 | 69387 |
31765 | 31765 | 2021-10-01 | Colorado | 8 | 677143 | 7772 |
31766 | 31766 | 2021-10-01 | Connecticut | 9 | 391066 | 8650 |
31767 | 31767 | 2021-10-01 | Delaware | 10 | 133599 | 1954 |
31768 | 31768 | 2021-10-01 | District of Columbia | 11 | 61331 | 1176 |
31769 | 31769 | 2021-10-01 | Florida | 12 | 3576581 | 55299 |
31770 | 31770 | 2021-10-01 | Georgia | 13 | 1547658 | 25371 |
31771 | 31771 | 2021-10-01 | Guam | 66 | 16137 | 199 |
31772 | 31772 | 2021-10-01 | Hawaii | 15 | 77143 | 786 |
31773 | 31773 | 2021-10-01 | Idaho | 16 | 259147 | 2936 |
31774 | 31774 | 2021-10-01 | Illinois | 17 | 1635964 | 27714 |
31775 | 31775 | 2021-10-01 | Indiana | 18 | 969375 | 15686 |
31776 | 31776 | 2021-10-01 | Iowa | 19 | 452057 | 6563 |
31777 | 31777 | 2021-10-01 | Kansas | 20 | 412319 | 6097 |
31778 | 31778 | 2021-10-01 | Kentucky | 21 | 700971 | 8896 |
31779 | 31779 | 2021-10-01 | Louisiana | 22 | 741906 | 13988 |
31780 | 31780 | 2021-10-01 | Maine | 23 | 90727 | 1024 |
31781 | 31781 | 2021-10-01 | Maryland | 24 | 534101 | 10460 |
31782 | 31782 | 2021-10-01 | Massachusetts | 25 | 813599 | 18647 |
31783 | 31783 | 2021-10-01 | Michigan | 26 | 1157226 | 22421 |
31784 | 31784 | 2021-10-01 | Minnesota | 27 | 714893 | 8273 |
31785 | 31785 | 2021-10-01 | Mississippi | 28 | 489216 | 9646 |
31786 | 31786 | 2021-10-01 | Missouri | 29 | 838961 | 12216 |
31787 | 31787 | 2021-10-01 | Montana | 30 | 152159 | 2017 |
31788 | 31788 | 2021-10-01 | Nebraska | 31 | 267079 | 2840 |
31789 | 31789 | 2021-10-01 | Nevada | 32 | 422329 | 7166 |
31790 | 31790 | 2021-10-01 | New Hampshire | 33 | 120763 | 1481 |
31791 | 31791 | 2021-10-01 | New Jersey | 34 | 1156243 | 27443 |
31792 | 31792 | 2021-10-01 | New Mexico | 35 | 253815 | 4814 |
31793 | 31793 | 2021-10-01 | New York | 36 | 2430353 | 54976 |
31794 | 31794 | 2021-10-01 | North Carolina | 37 | 1402049 | 16625 |
31795 | 31795 | 2021-10-01 | North Dakota | 38 | 132842 | 1645 |
31796 | 31796 | 2021-10-01 | Northern Mariana Islands | 69 | 270 | 2 |
31797 | 31797 | 2021-10-01 | Ohio | 39 | 1420206 | 22273 |
31798 | 31798 | 2021-10-01 | Oklahoma | 40 | 615217 | 8949 |
31799 | 31799 | 2021-10-01 | Oregon | 41 | 331709 | 3815 |
31800 | 31800 | 2021-10-01 | Pennsylvania | 42 | 1435292 | 29437 |
31801 | 31801 | 2021-10-01 | Puerto Rico | 72 | 214897 | 3155 |
31802 | 31802 | 2021-10-01 | Rhode Island | 44 | 172719 | 2838 |
31803 | 31803 | 2021-10-01 | South Carolina | 45 | 860369 | 12570 |
31804 | 31804 | 2021-10-01 | South Dakota | 46 | 145474 | 2145 |
31805 | 31805 | 2021-10-01 | Tennessee | 47 | 1203531 | 15082 |
31806 | 31806 | 2021-10-01 | Texas | 48 | 4069475 | 65858 |
31807 | 31807 | 2021-10-01 | Utah | 49 | 510308 | 2943 |
31808 | 31808 | 2021-10-01 | Vermont | 50 | 33852 | 318 |
31809 | 31809 | 2021-10-01 | Virgin Islands | 78 | 6786 | 71 |
31810 | 31810 | 2021-10-01 | Virginia | 51 | 869328 | 12806 |
31811 | 31811 | 2021-10-01 | Washington | 53 | 663560 | 7824 |
31812 | 31812 | 2021-10-01 | West Virginia | 54 | 242104 | 3722 |
31813 | 31813 | 2021-10-01 | Wisconsin | 55 | 814364 | 8901 |
31814 | 31814 | 2021-10-01 | Wyoming | 56 | 91169 | 996 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );