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-24 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 |
---|---|---|---|---|---|---|
46655 | 46655 | 2022-06-24 | Alabama | 1 | 1346268 | 19729 |
46656 | 46656 | 2022-06-24 | Alaska | 2 | 267648 | 1246 |
46657 | 46657 | 2022-06-24 | American Samoa | 60 | 6414 | 31 |
46658 | 46658 | 2022-06-24 | Arizona | 4 | 2109053 | 30452 |
46659 | 46659 | 2022-06-24 | Arkansas | 5 | 859615 | 11564 |
46660 | 46660 | 2022-06-24 | California | 6 | 10025036 | 92271 |
46661 | 46661 | 2022-06-24 | Colorado | 8 | 1525626 | 12935 |
46662 | 46662 | 2022-06-24 | Connecticut | 9 | 825075 | 11034 |
46663 | 46663 | 2022-06-24 | Delaware | 10 | 283632 | 2983 |
46664 | 46664 | 2022-06-24 | District of Columbia | 11 | 155268 | 1349 |
46665 | 46665 | 2022-06-24 | Florida | 12 | 6419490 | 75491 |
46666 | 46666 | 2022-06-24 | Georgia | 13 | 2553408 | 36952 |
46667 | 46667 | 2022-06-24 | Guam | 66 | 52203 | 372 |
46668 | 46668 | 2022-06-24 | Hawaii | 15 | 296007 | 1486 |
46669 | 46669 | 2022-06-24 | Idaho | 16 | 460843 | 4968 |
46670 | 46670 | 2022-06-24 | Illinois | 17 | 3413207 | 38510 |
46671 | 46671 | 2022-06-24 | Indiana | 18 | 1764876 | 23841 |
46672 | 46672 | 2022-06-24 | Iowa | 19 | 792554 | 9680 |
46673 | 46673 | 2022-06-24 | Kansas | 20 | 802635 | 8977 |
46674 | 46674 | 2022-06-24 | Kentucky | 21 | 1403622 | 16114 |
46675 | 46675 | 2022-06-24 | Louisiana | 22 | 1296861 | 17392 |
46676 | 46676 | 2022-06-24 | Maine | 23 | 268633 | 2410 |
46677 | 46677 | 2022-06-24 | Maryland | 24 | 1126355 | 14760 |
46678 | 46678 | 2022-06-24 | Massachusetts | 25 | 1915764 | 20891 |
46679 | 46679 | 2022-06-24 | Michigan | 26 | 2592078 | 36744 |
46680 | 46680 | 2022-06-24 | Minnesota | 27 | 1547019 | 13101 |
46681 | 46681 | 2022-06-24 | Mississippi | 28 | 828389 | 12507 |
46682 | 46682 | 2022-06-24 | Missouri | 29 | 1512582 | 20879 |
46683 | 46683 | 2022-06-24 | Montana | 30 | 285352 | 3444 |
46684 | 46684 | 2022-06-24 | Nebraska | 31 | 497100 | 4334 |
46685 | 46685 | 2022-06-24 | Nevada | 32 | 766935 | 11017 |
46686 | 46686 | 2022-06-24 | New Hampshire | 33 | 330828 | 2574 |
46687 | 46687 | 2022-06-24 | New Jersey | 34 | 2470738 | 33994 |
46688 | 46688 | 2022-06-24 | New Mexico | 35 | 558259 | 7907 |
46689 | 46689 | 2022-06-24 | New York | 36 | 5563095 | 68886 |
46690 | 46690 | 2022-06-24 | North Carolina | 37 | 2844446 | 25161 |
46691 | 46691 | 2022-06-24 | North Dakota | 38 | 248961 | 2341 |
46692 | 46692 | 2022-06-24 | Northern Mariana Islands | 69 | 11569 | 34 |
46693 | 46693 | 2022-06-24 | Ohio | 39 | 2831228 | 38778 |
46694 | 46694 | 2022-06-24 | Oklahoma | 40 | 1068168 | 14470 |
46695 | 46695 | 2022-06-24 | Oregon | 41 | 802157 | 7783 |
46696 | 46696 | 2022-06-24 | Pennsylvania | 42 | 2989896 | 45678 |
46697 | 46697 | 2022-06-24 | Puerto Rico | 72 | 788310 | 4519 |
46698 | 46698 | 2022-06-24 | Rhode Island | 44 | 401108 | 3605 |
46699 | 46699 | 2022-06-24 | South Carolina | 45 | 1535392 | 18007 |
46700 | 46700 | 2022-06-24 | South Dakota | 46 | 243269 | 2936 |
46701 | 46701 | 2022-06-24 | Tennessee | 47 | 2056496 | 26358 |
46702 | 46702 | 2022-06-24 | Texas | 48 | 7043184 | 88808 |
46703 | 46703 | 2022-06-24 | Utah | 49 | 975743 | 4816 |
46704 | 46704 | 2022-06-24 | Vermont | 50 | 135030 | 682 |
46705 | 46705 | 2022-06-24 | Virgin Islands | 78 | 20791 | 118 |
46706 | 46706 | 2022-06-24 | Virginia | 51 | 1852970 | 20519 |
46707 | 46707 | 2022-06-24 | Washington | 53 | 1647494 | 13227 |
46708 | 46708 | 2022-06-24 | West Virginia | 54 | 529262 | 7056 |
46709 | 46709 | 2022-06-24 | Wisconsin | 55 | 1717867 | 14767 |
46710 | 46710 | 2022-06-24 | Wyoming | 56 | 163340 | 1829 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );