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-09-21 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 |
---|---|---|---|---|---|---|
51639 | 51639 | 2022-09-21 | Alabama | 1 | 1517046 | 20380 |
51640 | 51640 | 2022-09-21 | Alaska | 2 | 295877 | 1321 |
51641 | 51641 | 2022-09-21 | American Samoa | 60 | 8217 | 34 |
51642 | 51642 | 2022-09-21 | Arizona | 4 | 2268158 | 31326 |
51643 | 51643 | 2022-09-21 | Arkansas | 5 | 947967 | 12028 |
51644 | 51644 | 2022-09-21 | California | 6 | 11203061 | 95726 |
51645 | 51645 | 2022-09-21 | Colorado | 8 | 1655107 | 13459 |
51646 | 51646 | 2022-09-21 | Connecticut | 9 | 890231 | 11343 |
51647 | 51647 | 2022-09-21 | Delaware | 10 | 306738 | 3088 |
51648 | 51648 | 2022-09-21 | District of Columbia | 11 | 167857 | 1383 |
51649 | 51649 | 2022-09-21 | Florida | 12 | 7101223 | 81007 |
51650 | 51650 | 2022-09-21 | Georgia | 13 | 2816561 | 38611 |
51651 | 51651 | 2022-09-21 | Guam | 66 | 59421 | 401 |
51652 | 51652 | 2022-09-21 | Hawaii | 15 | 334620 | 1676 |
51653 | 51653 | 2022-09-21 | Idaho | 16 | 494194 | 5167 |
51654 | 51654 | 2022-09-21 | Illinois | 17 | 3750347 | 39598 |
51655 | 51655 | 2022-09-21 | Indiana | 18 | 1917862 | 24614 |
51656 | 51656 | 2022-09-21 | Iowa | 19 | 853840 | 10051 |
51657 | 51657 | 2022-09-21 | Kansas | 20 | 876232 | 9095 |
51658 | 51658 | 2022-09-21 | Kentucky | 21 | 1583653 | 16902 |
51659 | 51659 | 2022-09-21 | Louisiana | 22 | 1451304 | 17993 |
51660 | 51660 | 2022-09-21 | Maine | 23 | 287283 | 2569 |
51661 | 51661 | 2022-09-21 | Maryland | 24 | 1242937 | 15340 |
51662 | 51662 | 2022-09-21 | Massachusetts | 25 | 2030335 | 21588 |
51663 | 51663 | 2022-09-21 | Michigan | 26 | 2821489 | 38464 |
51664 | 51664 | 2022-09-21 | Minnesota | 27 | 1651999 | 13558 |
51665 | 51665 | 2022-09-21 | Mississippi | 28 | 925596 | 12879 |
51666 | 51666 | 2022-09-21 | Missouri | 29 | 1656666 | 21593 |
51667 | 51667 | 2022-09-21 | Montana | 30 | 308301 | 3513 |
51668 | 51668 | 2022-09-21 | Nebraska | 31 | 535877 | 4490 |
51669 | 51669 | 2022-09-21 | Nevada | 32 | 846668 | 11475 |
51670 | 51670 | 2022-09-21 | New Hampshire | 33 | 348102 | 2688 |
51671 | 51671 | 2022-09-21 | New Jersey | 34 | 2719359 | 34696 |
51672 | 51672 | 2022-09-21 | New Mexico | 35 | 616648 | 8536 |
51673 | 51673 | 2022-09-21 | New York | 36 | 6064374 | 70875 |
51674 | 51674 | 2022-09-21 | North Carolina | 37 | 3182775 | 26468 |
51675 | 51675 | 2022-09-21 | North Dakota | 38 | 267287 | 2411 |
51676 | 51676 | 2022-09-21 | Northern Mariana Islands | 69 | 13166 | 40 |
51677 | 51677 | 2022-09-21 | Ohio | 39 | 3117109 | 39675 |
51678 | 51678 | 2022-09-21 | Oklahoma | 40 | 1192446 | 14784 |
51679 | 51679 | 2022-09-21 | Oregon | 41 | 890507 | 8520 |
51680 | 51680 | 2022-09-21 | Pennsylvania | 42 | 3239298 | 47098 |
51681 | 51681 | 2022-09-21 | Puerto Rico | 72 | 981287 | 5085 |
51682 | 51682 | 2022-09-21 | Rhode Island | 44 | 421739 | 3661 |
51683 | 51683 | 2022-09-21 | South Carolina | 45 | 1703439 | 18331 |
51684 | 51684 | 2022-09-21 | South Dakota | 46 | 260639 | 3017 |
51685 | 51685 | 2022-09-21 | Tennessee | 47 | 2271764 | 27362 |
51686 | 51686 | 2022-09-21 | Texas | 48 | 7856339 | 90830 |
51687 | 51687 | 2022-09-21 | Utah | 49 | 1034893 | 5001 |
51688 | 51688 | 2022-09-21 | Vermont | 50 | 141840 | 719 |
51689 | 51689 | 2022-09-21 | Virgin Islands | 78 | 23083 | 123 |
51690 | 51690 | 2022-09-21 | Virginia | 51 | 2076914 | 21729 |
51691 | 51691 | 2022-09-21 | Washington | 53 | 1805951 | 14277 |
51692 | 51692 | 2022-09-21 | West Virginia | 54 | 597303 | 7379 |
51693 | 51693 | 2022-09-21 | Wisconsin | 55 | 1857343 | 15215 |
51694 | 51694 | 2022-09-21 | Wyoming | 56 | 176256 | 1891 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );