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-09-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 |
---|---|---|---|---|---|---|
31591 | 31591 | 2021-09-28 | Alabama | 1 | 792632 | 14155 |
31592 | 31592 | 2021-09-28 | Alaska | 2 | 111572 | 545 |
31593 | 31593 | 2021-09-28 | American Samoa | 60 | 1 | 0 |
31594 | 31594 | 2021-09-28 | Arizona | 4 | 1087451 | 19920 |
31595 | 31595 | 2021-09-28 | Arkansas | 5 | 493920 | 7651 |
31596 | 31596 | 2021-09-28 | California | 6 | 4722662 | 68985 |
31597 | 31597 | 2021-09-28 | Colorado | 8 | 670932 | 7703 |
31598 | 31598 | 2021-09-28 | Connecticut | 9 | 389730 | 8626 |
31599 | 31599 | 2021-09-28 | Delaware | 10 | 132138 | 1950 |
31600 | 31600 | 2021-09-28 | District of Columbia | 11 | 60898 | 1174 |
31601 | 31601 | 2021-09-28 | Florida | 12 | 3560152 | 54067 |
31602 | 31602 | 2021-09-28 | Georgia | 13 | 1535746 | 24902 |
31603 | 31603 | 2021-09-28 | Guam | 66 | 15505 | 193 |
31604 | 31604 | 2021-09-28 | Hawaii | 15 | 76243 | 754 |
31605 | 31605 | 2021-09-28 | Idaho | 16 | 253813 | 2832 |
31606 | 31606 | 2021-09-28 | Illinois | 17 | 1626227 | 27568 |
31607 | 31607 | 2021-09-28 | Indiana | 18 | 959942 | 15561 |
31608 | 31608 | 2021-09-28 | Iowa | 19 | 449038 | 6482 |
31609 | 31609 | 2021-09-28 | Kansas | 20 | 407540 | 6056 |
31610 | 31610 | 2021-09-28 | Kentucky | 21 | 690107 | 8734 |
31611 | 31611 | 2021-09-28 | Louisiana | 22 | 738613 | 13850 |
31612 | 31612 | 2021-09-28 | Maine | 23 | 88197 | 1022 |
31613 | 31613 | 2021-09-28 | Maryland | 24 | 529966 | 10413 |
31614 | 31614 | 2021-09-28 | Massachusetts | 25 | 808673 | 18577 |
31615 | 31615 | 2021-09-28 | Michigan | 26 | 1139570 | 22229 |
31616 | 31616 | 2021-09-28 | Minnesota | 27 | 706261 | 8212 |
31617 | 31617 | 2021-09-28 | Mississippi | 28 | 486195 | 9538 |
31618 | 31618 | 2021-09-28 | Missouri | 29 | 832995 | 12156 |
31619 | 31619 | 2021-09-28 | Montana | 30 | 148636 | 1989 |
31620 | 31620 | 2021-09-28 | Nebraska | 31 | 264840 | 2813 |
31621 | 31621 | 2021-09-28 | Nevada | 32 | 419379 | 7073 |
31622 | 31622 | 2021-09-28 | New Hampshire | 33 | 119068 | 1477 |
31623 | 31623 | 2021-09-28 | New Jersey | 34 | 1150246 | 27380 |
31624 | 31624 | 2021-09-28 | New Mexico | 35 | 251384 | 4778 |
31625 | 31625 | 2021-09-28 | New York | 36 | 2414540 | 54822 |
31626 | 31626 | 2021-09-28 | North Carolina | 37 | 1388006 | 16305 |
31627 | 31627 | 2021-09-28 | North Dakota | 38 | 130608 | 1641 |
31628 | 31628 | 2021-09-28 | Northern Mariana Islands | 69 | 268 | 2 |
31629 | 31629 | 2021-09-28 | Ohio | 39 | 1400979 | 21945 |
31630 | 31630 | 2021-09-28 | Oklahoma | 40 | 610385 | 8715 |
31631 | 31631 | 2021-09-28 | Oregon | 41 | 326191 | 3750 |
31632 | 31632 | 2021-09-28 | Pennsylvania | 42 | 1420478 | 29226 |
31633 | 31633 | 2021-09-28 | Puerto Rico | 72 | 214366 | 3142 |
31634 | 31634 | 2021-09-28 | Rhode Island | 44 | 171751 | 2834 |
31635 | 31635 | 2021-09-28 | South Carolina | 45 | 852006 | 12259 |
31636 | 31636 | 2021-09-28 | South Dakota | 46 | 143995 | 2133 |
31637 | 31637 | 2021-09-28 | Tennessee | 47 | 1192736 | 14934 |
31638 | 31638 | 2021-09-28 | Texas | 48 | 4035865 | 64806 |
31639 | 31639 | 2021-09-28 | Utah | 49 | 505100 | 2905 |
31640 | 31640 | 2021-09-28 | Vermont | 50 | 33329 | 313 |
31641 | 31641 | 2021-09-28 | Virgin Islands | 78 | 6679 | 70 |
31642 | 31642 | 2021-09-28 | Virginia | 51 | 860493 | 12647 |
31643 | 31643 | 2021-09-28 | Washington | 53 | 654532 | 7641 |
31644 | 31644 | 2021-09-28 | West Virginia | 54 | 237002 | 3578 |
31645 | 31645 | 2021-09-28 | Wisconsin | 55 | 804300 | 8849 |
31646 | 31646 | 2021-09-28 | Wyoming | 56 | 89430 | 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 );