ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-08-23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 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
- Nevada 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
29605 | 29605 | 2021-08-23 | Alabama | 1 | 665653 | 12000 |
29606 | 29606 | 2021-08-23 | Alaska | 2 | 83581 | 397 |
29607 | 29607 | 2021-08-23 | Arizona | 4 | 988714 | 18600 |
29608 | 29608 | 2021-08-23 | Arkansas | 5 | 436242 | 6704 |
29609 | 29609 | 2021-08-23 | California | 6 | 4341369 | 65160 |
29610 | 29610 | 2021-08-23 | Colorado | 8 | 606517 | 7246 |
29611 | 29611 | 2021-08-23 | Connecticut | 9 | 367410 | 8335 |
29612 | 29612 | 2021-08-23 | Delaware | 10 | 117051 | 1854 |
29613 | 29613 | 2021-08-23 | District of Columbia | 11 | 53898 | 1155 |
29614 | 29614 | 2021-08-23 | Florida | 12 | 3082733 | 42716 |
29615 | 29615 | 2021-08-23 | Georgia | 13 | 1298893 | 21543 |
29616 | 29616 | 2021-08-23 | Guam | 66 | 10455 | 146 |
29617 | 29617 | 2021-08-23 | Hawaii | 15 | 54608 | 561 |
29618 | 29618 | 2021-08-23 | Idaho | 16 | 214123 | 2302 |
29619 | 29619 | 2021-08-23 | Illinois | 17 | 1495978 | 26275 |
29620 | 29620 | 2021-08-23 | Indiana | 18 | 828906 | 14263 |
29621 | 29621 | 2021-08-23 | Iowa | 19 | 395167 | 6226 |
29622 | 29622 | 2021-08-23 | Kansas | 20 | 359987 | 5522 |
29623 | 29623 | 2021-08-23 | Kentucky | 21 | 544574 | 7606 |
29624 | 29624 | 2021-08-23 | Louisiana | 22 | 660804 | 11977 |
29625 | 29625 | 2021-08-23 | Maine | 23 | 73659 | 924 |
29626 | 29626 | 2021-08-23 | Maryland | 24 | 488115 | 9948 |
29627 | 29627 | 2021-08-23 | Massachusetts | 25 | 747153 | 18179 |
29628 | 29628 | 2021-08-23 | Michigan | 26 | 1043294 | 21396 |
29629 | 29629 | 2021-08-23 | Minnesota | 27 | 635315 | 7860 |
29630 | 29630 | 2021-08-23 | Mississippi | 28 | 413498 | 8047 |
29631 | 29631 | 2021-08-23 | Missouri | 29 | 756277 | 10885 |
29632 | 29632 | 2021-08-23 | Montana | 30 | 123075 | 1760 |
29633 | 29633 | 2021-08-23 | Nebraska | 31 | 238305 | 2571 |
29634 | 29634 | 2021-08-23 | Nevada | 32 | 381766 | 6306 |
29635 | 29635 | 2021-08-23 | New Hampshire | 33 | 105302 | 1402 |
29636 | 29636 | 2021-08-23 | New Jersey | 34 | 1075930 | 26755 |
29637 | 29637 | 2021-08-23 | New Mexico | 35 | 225994 | 4483 |
29638 | 29638 | 2021-08-23 | New York | 36 | 2239183 | 53646 |
29639 | 29639 | 2021-08-23 | North Carolina | 37 | 1162214 | 14133 |
29640 | 29640 | 2021-08-23 | North Dakota | 38 | 114946 | 1582 |
29641 | 29641 | 2021-08-23 | Northern Mariana Islands | 69 | 226 | 2 |
29642 | 29642 | 2021-08-23 | Ohio | 39 | 1183761 | 20689 |
29643 | 29643 | 2021-08-23 | Oklahoma | 40 | 530594 | 7676 |
29644 | 29644 | 2021-08-23 | Oregon | 41 | 257644 | 3056 |
29645 | 29645 | 2021-08-23 | Pennsylvania | 42 | 1274337 | 28076 |
29646 | 29646 | 2021-08-23 | Puerto Rico | 72 | 198374 | 2742 |
29647 | 29647 | 2021-08-23 | Rhode Island | 44 | 160329 | 2757 |
29648 | 29648 | 2021-08-23 | South Carolina | 45 | 695489 | 10314 |
29649 | 29649 | 2021-08-23 | South Dakota | 46 | 128626 | 2057 |
29650 | 29650 | 2021-08-23 | Tennessee | 47 | 980507 | 13102 |
29651 | 29651 | 2021-08-23 | Texas | 48 | 3466970 | 55509 |
29652 | 29652 | 2021-08-23 | Utah | 49 | 454450 | 2584 |
29653 | 29653 | 2021-08-23 | Vermont | 50 | 27132 | 270 |
29654 | 29654 | 2021-08-23 | Virgin Islands | 78 | 5605 | 45 |
29655 | 29655 | 2021-08-23 | Virginia | 51 | 741160 | 11675 |
29656 | 29656 | 2021-08-23 | Washington | 53 | 538206 | 6427 |
29657 | 29657 | 2021-08-23 | West Virginia | 54 | 180019 | 3016 |
29658 | 29658 | 2021-08-23 | Wisconsin | 55 | 718074 | 8373 |
29659 | 29659 | 2021-08-23 | Wyoming | 56 | 71562 | 809 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );