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-23 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 |
---|---|---|---|---|---|---|
46599 | 46599 | 2022-06-23 | Alabama | 1 | 1344233 | 19723 |
46600 | 46600 | 2022-06-23 | Alaska | 2 | 267648 | 1246 |
46601 | 46601 | 2022-06-23 | American Samoa | 60 | 6342 | 31 |
46602 | 46602 | 2022-06-23 | Arizona | 4 | 2109053 | 30452 |
46603 | 46603 | 2022-06-23 | Arkansas | 5 | 858553 | 11559 |
46604 | 46604 | 2022-06-23 | California | 6 | 9967883 | 92186 |
46605 | 46605 | 2022-06-23 | Colorado | 8 | 1522588 | 12921 |
46606 | 46606 | 2022-06-23 | Connecticut | 9 | 824295 | 11034 |
46607 | 46607 | 2022-06-23 | Delaware | 10 | 283370 | 2982 |
46608 | 46608 | 2022-06-23 | District of Columbia | 11 | 155268 | 1349 |
46609 | 46609 | 2022-06-23 | Florida | 12 | 6407648 | 75411 |
46610 | 46610 | 2022-06-23 | Georgia | 13 | 2553408 | 36952 |
46611 | 46611 | 2022-06-23 | Guam | 66 | 52053 | 372 |
46612 | 46612 | 2022-06-23 | Hawaii | 15 | 296007 | 1486 |
46613 | 46613 | 2022-06-23 | Idaho | 16 | 459652 | 4963 |
46614 | 46614 | 2022-06-23 | Illinois | 17 | 3407624 | 38483 |
46615 | 46615 | 2022-06-23 | Indiana | 18 | 1762056 | 23841 |
46616 | 46616 | 2022-06-23 | Iowa | 19 | 792554 | 9680 |
46617 | 46617 | 2022-06-23 | Kansas | 20 | 802635 | 8970 |
46618 | 46618 | 2022-06-23 | Kentucky | 21 | 1402658 | 16114 |
46619 | 46619 | 2022-06-23 | Louisiana | 22 | 1294720 | 17388 |
46620 | 46620 | 2022-06-23 | Maine | 23 | 268386 | 2409 |
46621 | 46621 | 2022-06-23 | Maryland | 24 | 1124657 | 14756 |
46622 | 46622 | 2022-06-23 | Massachusetts | 25 | 1913838 | 20881 |
46623 | 46623 | 2022-06-23 | Michigan | 26 | 2592078 | 36744 |
46624 | 46624 | 2022-06-23 | Minnesota | 27 | 1545322 | 13096 |
46625 | 46625 | 2022-06-23 | Mississippi | 28 | 827012 | 12505 |
46626 | 46626 | 2022-06-23 | Missouri | 29 | 1504609 | 20823 |
46627 | 46627 | 2022-06-23 | Montana | 30 | 283610 | 3440 |
46628 | 46628 | 2022-06-23 | Nebraska | 31 | 496506 | 4332 |
46629 | 46629 | 2022-06-23 | Nevada | 32 | 765603 | 11006 |
46630 | 46630 | 2022-06-23 | New Hampshire | 33 | 330628 | 2572 |
46631 | 46631 | 2022-06-23 | New Jersey | 34 | 2467432 | 33980 |
46632 | 46632 | 2022-06-23 | New Mexico | 35 | 557008 | 7901 |
46633 | 46633 | 2022-06-23 | New York | 36 | 5555804 | 68869 |
46634 | 46634 | 2022-06-23 | North Carolina | 37 | 2844268 | 25161 |
46635 | 46635 | 2022-06-23 | North Dakota | 38 | 248555 | 2341 |
46636 | 46636 | 2022-06-23 | Northern Mariana Islands | 69 | 11569 | 34 |
46637 | 46637 | 2022-06-23 | Ohio | 39 | 2831228 | 38778 |
46638 | 46638 | 2022-06-23 | Oklahoma | 40 | 1068168 | 14470 |
46639 | 46639 | 2022-06-23 | Oregon | 41 | 800405 | 7764 |
46640 | 46640 | 2022-06-23 | Pennsylvania | 42 | 2987357 | 45657 |
46641 | 46641 | 2022-06-23 | Puerto Rico | 72 | 783855 | 4512 |
46642 | 46642 | 2022-06-23 | Rhode Island | 44 | 400834 | 3605 |
46643 | 46643 | 2022-06-23 | South Carolina | 45 | 1535392 | 18007 |
46644 | 46644 | 2022-06-23 | South Dakota | 46 | 243269 | 2936 |
46645 | 46645 | 2022-06-23 | Tennessee | 47 | 2053838 | 26356 |
46646 | 46646 | 2022-06-23 | Texas | 48 | 7031682 | 88794 |
46647 | 46647 | 2022-06-23 | Utah | 49 | 975743 | 4816 |
46648 | 46648 | 2022-06-23 | Vermont | 50 | 135030 | 682 |
46649 | 46649 | 2022-06-23 | Virgin Islands | 78 | 20762 | 118 |
46650 | 46650 | 2022-06-23 | Virginia | 51 | 1849990 | 20498 |
46651 | 46651 | 2022-06-23 | Washington | 53 | 1640872 | 13200 |
46652 | 46652 | 2022-06-23 | West Virginia | 54 | 528651 | 7054 |
46653 | 46653 | 2022-06-23 | Wisconsin | 55 | 1716041 | 14756 |
46654 | 46654 | 2022-06-23 | 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 );