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-20 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 56
- 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
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
48111 | 48111 | 2022-07-20 | Alabama | 1 | 1401893 | 19852 |
48112 | 48112 | 2022-07-20 | Alaska | 2 | 279532 | 1270 |
48113 | 48113 | 2022-07-20 | American Samoa | 60 | 7471 | 33 |
48114 | 48114 | 2022-07-20 | Arizona | 4 | 2179180 | 30698 |
48115 | 48115 | 2022-07-20 | Arkansas | 5 | 890943 | 11654 |
48116 | 48116 | 2022-07-20 | California | 6 | 10513729 | 93180 |
48117 | 48117 | 2022-07-20 | Colorado | 8 | 1583788 | 13125 |
48118 | 48118 | 2022-07-20 | Connecticut | 9 | 845240 | 11092 |
48119 | 48119 | 2022-07-20 | Delaware | 10 | 290401 | 3010 |
48120 | 48120 | 2022-07-20 | District of Columbia | 11 | 160723 | 1363 |
48121 | 48121 | 2022-07-20 | Florida | 12 | 6691964 | 76922 |
48122 | 48122 | 2022-07-20 | Georgia | 13 | 2644433 | 37407 |
48123 | 48123 | 2022-07-20 | Guam | 66 | 55132 | 378 |
48124 | 48124 | 2022-07-20 | Hawaii | 15 | 313805 | 1545 |
48125 | 48125 | 2022-07-20 | Idaho | 16 | 474268 | 5013 |
48126 | 48126 | 2022-07-20 | Illinois | 17 | 3522590 | 38785 |
48127 | 48127 | 2022-07-20 | Indiana | 18 | 1807442 | 24014 |
48128 | 48128 | 2022-07-20 | Iowa | 19 | 810664 | 9759 |
48129 | 48129 | 2022-07-20 | Kansas | 20 | 827865 | 8978 |
48130 | 48130 | 2022-07-20 | Kentucky | 21 | 1449092 | 16293 |
48131 | 48131 | 2022-07-20 | Louisiana | 22 | 1357396 | 17493 |
48132 | 48132 | 2022-07-20 | Maine | 23 | 273813 | 2464 |
48133 | 48133 | 2022-07-20 | Maryland | 24 | 1164403 | 14897 |
48134 | 48134 | 2022-07-20 | Massachusetts | 25 | 1944319 | 21068 |
48135 | 48135 | 2022-07-20 | Michigan | 26 | 2652659 | 37291 |
48136 | 48136 | 2022-07-20 | Minnesota | 27 | 1571008 | 13205 |
48137 | 48137 | 2022-07-20 | Mississippi | 28 | 862528 | 12589 |
48138 | 48138 | 2022-07-20 | Missouri | 29 | 1557382 | 21009 |
48139 | 48139 | 2022-07-20 | Montana | 30 | 292489 | 3455 |
48140 | 48140 | 2022-07-20 | Nebraska | 31 | 510735 | 4363 |
48141 | 48141 | 2022-07-20 | Nevada | 32 | 796282 | 11189 |
48142 | 48142 | 2022-07-20 | New Hampshire | 33 | 336189 | 2615 |
48143 | 48143 | 2022-07-20 | New Jersey | 34 | 2556303 | 34189 |
48144 | 48144 | 2022-07-20 | New Mexico | 35 | 582061 | 8140 |
48145 | 48145 | 2022-07-20 | New York | 36 | 5735607 | 69352 |
48146 | 48146 | 2022-07-20 | North Carolina | 37 | 2949264 | 25445 |
48147 | 48147 | 2022-07-20 | North Dakota | 38 | 254466 | 2351 |
48148 | 48148 | 2022-07-20 | Northern Mariana Islands | 69 | 12920 | 35 |
48149 | 48149 | 2022-07-20 | Ohio | 39 | 2891756 | 38959 |
48150 | 48150 | 2022-07-20 | Oklahoma | 40 | 1104163 | 14525 |
48151 | 48151 | 2022-07-20 | Oregon | 41 | 839295 | 7981 |
48152 | 48152 | 2022-07-20 | Pennsylvania | 42 | 3058316 | 46047 |
48153 | 48153 | 2022-07-20 | Puerto Rico | 72 | 857289 | 4700 |
48154 | 48154 | 2022-07-20 | Rhode Island | 44 | 407886 | 3624 |
48155 | 48155 | 2022-07-20 | South Carolina | 45 | 1587503 | 18132 |
48156 | 48156 | 2022-07-20 | South Dakota | 46 | 248788 | 2947 |
48157 | 48157 | 2022-07-20 | Tennessee | 47 | 2119111 | 26598 |
48158 | 48158 | 2022-07-20 | Texas | 48 | 7334919 | 89209 |
48159 | 48159 | 2022-07-20 | Utah | 49 | 997808 | 4869 |
48160 | 48160 | 2022-07-20 | Vermont | 50 | 137264 | 689 |
48161 | 48161 | 2022-07-20 | Virgin Islands | 78 | 21499 | 120 |
48162 | 48162 | 2022-07-20 | Virginia | 51 | 1925915 | 20839 |
48163 | 48163 | 2022-07-20 | Washington | 53 | 1713951 | 13550 |
48164 | 48164 | 2022-07-20 | West Virginia | 54 | 546772 | 7115 |
48165 | 48165 | 2022-07-20 | Wisconsin | 55 | 1759029 | 14867 |
48166 | 48166 | 2022-07-20 | Wyoming | 56 | 168678 | 1850 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );