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-07-01 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 |
---|---|---|---|---|---|---|
47047 | 47047 | 2022-07-01 | Alabama | 1 | 1359051 | 19759 |
47048 | 47048 | 2022-07-01 | Alaska | 2 | 270747 | 1246 |
47049 | 47049 | 2022-07-01 | American Samoa | 60 | 6505 | 31 |
47050 | 47050 | 2022-07-01 | Arizona | 4 | 2125567 | 30515 |
47051 | 47051 | 2022-07-01 | Arkansas | 5 | 866816 | 11585 |
47052 | 47052 | 2022-07-01 | California | 6 | 10156643 | 92541 |
47053 | 47053 | 2022-07-01 | Colorado | 8 | 1543247 | 12969 |
47054 | 47054 | 2022-07-01 | Connecticut | 9 | 831880 | 11045 |
47055 | 47055 | 2022-07-01 | Delaware | 10 | 285403 | 2984 |
47056 | 47056 | 2022-07-01 | District of Columbia | 11 | 157041 | 1351 |
47057 | 47057 | 2022-07-01 | Florida | 12 | 6493977 | 75891 |
47058 | 47058 | 2022-07-01 | Georgia | 13 | 2573368 | 37075 |
47059 | 47059 | 2022-07-01 | Guam | 66 | 53036 | 373 |
47060 | 47060 | 2022-07-01 | Hawaii | 15 | 301246 | 1501 |
47061 | 47061 | 2022-07-01 | Idaho | 16 | 464212 | 4983 |
47062 | 47062 | 2022-07-01 | Illinois | 17 | 3441474 | 38601 |
47063 | 47063 | 2022-07-01 | Indiana | 18 | 1775886 | 23877 |
47064 | 47064 | 2022-07-01 | Iowa | 19 | 796611 | 9688 |
47065 | 47065 | 2022-07-01 | Kansas | 20 | 807650 | 8980 |
47066 | 47066 | 2022-07-01 | Kentucky | 21 | 1413470 | 16144 |
47067 | 47067 | 2022-07-01 | Louisiana | 22 | 1310829 | 17418 |
47068 | 47068 | 2022-07-01 | Maine | 23 | 270123 | 2418 |
47069 | 47069 | 2022-07-01 | Maryland | 24 | 1136584 | 14794 |
47070 | 47070 | 2022-07-01 | Massachusetts | 25 | 1926543 | 20953 |
47071 | 47071 | 2022-07-01 | Michigan | 26 | 2606431 | 36918 |
47072 | 47072 | 2022-07-01 | Minnesota | 27 | 1553161 | 13127 |
47073 | 47073 | 2022-07-01 | Mississippi | 28 | 836757 | 12526 |
47074 | 47074 | 2022-07-01 | Missouri | 29 | 1526041 | 20937 |
47075 | 47075 | 2022-07-01 | Montana | 30 | 287462 | 3445 |
47076 | 47076 | 2022-07-01 | Nebraska | 31 | 500574 | 4342 |
47077 | 47077 | 2022-07-01 | Nevada | 32 | 773841 | 11039 |
47078 | 47078 | 2022-07-01 | New Hampshire | 33 | 332364 | 2586 |
47079 | 47079 | 2022-07-01 | New Jersey | 34 | 2492366 | 34057 |
47080 | 47080 | 2022-07-01 | New Mexico | 35 | 564678 | 7948 |
47081 | 47081 | 2022-07-01 | New York | 36 | 5604401 | 69011 |
47082 | 47082 | 2022-07-01 | North Carolina | 37 | 2868272 | 25219 |
47083 | 47083 | 2022-07-01 | North Dakota | 38 | 250319 | 2343 |
47084 | 47084 | 2022-07-01 | Northern Mariana Islands | 69 | 11829 | 35 |
47085 | 47085 | 2022-07-01 | Ohio | 39 | 2848453 | 38852 |
47086 | 47086 | 2022-07-01 | Oklahoma | 40 | 1076350 | 14472 |
47087 | 47087 | 2022-07-01 | Oregon | 41 | 813051 | 7818 |
47088 | 47088 | 2022-07-01 | Pennsylvania | 42 | 3006257 | 45766 |
47089 | 47089 | 2022-07-01 | Puerto Rico | 72 | 810448 | 4579 |
47090 | 47090 | 2022-07-01 | Rhode Island | 44 | 403052 | 3611 |
47091 | 47091 | 2022-07-01 | South Carolina | 45 | 1546406 | 18033 |
47092 | 47092 | 2022-07-01 | South Dakota | 46 | 244523 | 2938 |
47093 | 47093 | 2022-07-01 | Tennessee | 47 | 2072627 | 26444 |
47094 | 47094 | 2022-07-01 | Texas | 48 | 7118332 | 88923 |
47095 | 47095 | 2022-07-01 | Utah | 49 | 983139 | 4834 |
47096 | 47096 | 2022-07-01 | Vermont | 50 | 135668 | 683 |
47097 | 47097 | 2022-07-01 | Virgin Islands | 78 | 20928 | 118 |
47098 | 47098 | 2022-07-01 | Virginia | 51 | 1872624 | 20630 |
47099 | 47099 | 2022-07-01 | Washington | 53 | 1667056 | 13313 |
47100 | 47100 | 2022-07-01 | West Virginia | 54 | 533213 | 7064 |
47101 | 47101 | 2022-07-01 | Wisconsin | 55 | 1728350 | 14807 |
47102 | 47102 | 2022-07-01 | Wyoming | 56 | 164456 | 1834 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );