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-07-01 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 |
---|---|---|---|---|---|---|
26690 | 26690 | 2021-07-01 | Alabama | 1 | 550983 | 11352 |
26691 | 26691 | 2021-07-01 | Alaska | 2 | 70669 | 360 |
26692 | 26692 | 2021-07-01 | Arizona | 4 | 895347 | 17939 |
26693 | 26693 | 2021-07-01 | Arkansas | 5 | 350085 | 5909 |
26694 | 26694 | 2021-07-01 | California | 6 | 3866606 | 63709 |
26695 | 26695 | 2021-07-01 | Colorado | 8 | 561460 | 6952 |
26696 | 26696 | 2021-07-01 | Connecticut | 9 | 349387 | 8279 |
26697 | 26697 | 2021-07-01 | Delaware | 10 | 109770 | 1694 |
26698 | 26698 | 2021-07-01 | District of Columbia | 11 | 49362 | 1141 |
26699 | 26699 | 2021-07-01 | Florida | 12 | 2331916 | 37913 |
26700 | 26700 | 2021-07-01 | Georgia | 13 | 1110606 | 20734 |
26701 | 26701 | 2021-07-01 | Guam | 66 | 9335 | 141 |
26702 | 26702 | 2021-07-01 | Hawaii | 15 | 36435 | 515 |
26703 | 26703 | 2021-07-01 | Idaho | 16 | 195166 | 2156 |
26704 | 26704 | 2021-07-01 | Illinois | 17 | 1396270 | 25687 |
26705 | 26705 | 2021-07-01 | Indiana | 18 | 757671 | 13855 |
26706 | 26706 | 2021-07-01 | Iowa | 19 | 373960 | 6140 |
26707 | 26707 | 2021-07-01 | Kansas | 20 | 319626 | 5189 |
26708 | 26708 | 2021-07-01 | Kentucky | 21 | 466106 | 7269 |
26709 | 26709 | 2021-07-01 | Louisiana | 22 | 482035 | 10748 |
26710 | 26710 | 2021-07-01 | Maine | 23 | 69054 | 859 |
26711 | 26711 | 2021-07-01 | Maryland | 24 | 462571 | 9744 |
26712 | 26712 | 2021-07-01 | Massachusetts | 25 | 710049 | 17997 |
26713 | 26713 | 2021-07-01 | Michigan | 26 | 998847 | 20998 |
26714 | 26714 | 2021-07-01 | Minnesota | 27 | 605541 | 7692 |
26715 | 26715 | 2021-07-01 | Mississippi | 28 | 321944 | 7415 |
26716 | 26716 | 2021-07-01 | Missouri | 29 | 636120 | 9938 |
26717 | 26717 | 2021-07-01 | Montana | 30 | 113928 | 1666 |
26718 | 26718 | 2021-07-01 | Nebraska | 31 | 224802 | 2520 |
26719 | 26719 | 2021-07-01 | Nevada | 32 | 334255 | 5692 |
26720 | 26720 | 2021-07-01 | New Hampshire | 33 | 99527 | 1372 |
26721 | 26721 | 2021-07-01 | New Jersey | 34 | 1023613 | 26463 |
26722 | 26722 | 2021-07-01 | New Mexico | 35 | 205629 | 4345 |
26723 | 26723 | 2021-07-01 | New York | 36 | 2113544 | 53107 |
26724 | 26724 | 2021-07-01 | North Carolina | 37 | 1014967 | 13447 |
26725 | 26725 | 2021-07-01 | North Dakota | 38 | 110749 | 1559 |
26726 | 26726 | 2021-07-01 | Northern Mariana Islands | 69 | 183 | 2 |
26727 | 26727 | 2021-07-01 | Ohio | 39 | 1111903 | 20309 |
26728 | 26728 | 2021-07-01 | Oklahoma | 40 | 458150 | 7388 |
26729 | 26729 | 2021-07-01 | Oregon | 41 | 208900 | 2808 |
26730 | 26730 | 2021-07-01 | Pennsylvania | 42 | 1216965 | 27684 |
26731 | 26731 | 2021-07-01 | Puerto Rico | 72 | 173673 | 2549 |
26732 | 26732 | 2021-07-01 | Rhode Island | 44 | 152618 | 2730 |
26733 | 26733 | 2021-07-01 | South Carolina | 45 | 597021 | 9826 |
26734 | 26734 | 2021-07-01 | South Dakota | 46 | 124561 | 2038 |
26735 | 26735 | 2021-07-01 | Tennessee | 47 | 854430 | 12472 |
26736 | 26736 | 2021-07-01 | Texas | 48 | 2995274 | 52554 |
26737 | 26737 | 2021-07-01 | Utah | 49 | 415750 | 2375 |
26738 | 26738 | 2021-07-01 | Vermont | 50 | 24412 | 257 |
26739 | 26739 | 2021-07-01 | Virgin Islands | 78 | 3895 | 30 |
26740 | 26740 | 2021-07-01 | Virginia | 51 | 680564 | 11419 |
26741 | 26741 | 2021-07-01 | Washington | 53 | 454087 | 5992 |
26742 | 26742 | 2021-07-01 | West Virginia | 54 | 164097 | 2897 |
26743 | 26743 | 2021-07-01 | Wisconsin | 55 | 677952 | 8134 |
26744 | 26744 | 2021-07-01 | Wyoming | 56 | 62353 | 747 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );