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-04-22 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 |
---|---|---|---|---|---|---|
43127 | 43127 | 2022-04-22 | Alabama | 1 | 1299137 | 19541 |
43128 | 43128 | 2022-04-22 | Alaska | 2 | 249901 | 1209 |
43129 | 43129 | 2022-04-22 | American Samoa | 60 | 5517 | 12 |
43130 | 43130 | 2022-04-22 | Arizona | 4 | 2019174 | 29852 |
43131 | 43131 | 2022-04-22 | Arkansas | 5 | 834864 | 11369 |
43132 | 43132 | 2022-04-22 | California | 6 | 9191757 | 90090 |
43133 | 43133 | 2022-04-22 | Colorado | 8 | 1381226 | 12293 |
43134 | 43134 | 2022-04-22 | Connecticut | 9 | 751810 | 10834 |
43135 | 43135 | 2022-04-22 | Delaware | 10 | 261118 | 2896 |
43136 | 43136 | 2022-04-22 | District of Columbia | 11 | 140845 | 1333 |
43137 | 43137 | 2022-04-22 | Florida | 12 | 5899188 | 73830 |
43138 | 43138 | 2022-04-22 | Georgia | 13 | 2439765 | 36217 |
43139 | 43139 | 2022-04-22 | Guam | 66 | 48895 | 355 |
43140 | 43140 | 2022-04-22 | Hawaii | 15 | 238763 | 1404 |
43141 | 43141 | 2022-04-22 | Idaho | 16 | 445646 | 4925 |
43142 | 43142 | 2022-04-22 | Illinois | 17 | 3119711 | 37859 |
43143 | 43143 | 2022-04-22 | Indiana | 18 | 1696759 | 23535 |
43144 | 43144 | 2022-04-22 | Iowa | 19 | 761487 | 9510 |
43145 | 43145 | 2022-04-22 | Kansas | 20 | 774680 | 8597 |
43146 | 43146 | 2022-04-22 | Kentucky | 21 | 1333203 | 15322 |
43147 | 43147 | 2022-04-22 | Louisiana | 22 | 1236111 | 17223 |
43148 | 43148 | 2022-04-22 | Maine | 23 | 241716 | 2280 |
43149 | 43149 | 2022-04-22 | Maryland | 24 | 1025184 | 14422 |
43150 | 43150 | 2022-04-22 | Massachusetts | 25 | 1738231 | 20222 |
43151 | 43151 | 2022-04-22 | Michigan | 26 | 2411464 | 35935 |
43152 | 43152 | 2022-04-22 | Minnesota | 27 | 1444119 | 12752 |
43153 | 43153 | 2022-04-22 | Mississippi | 28 | 796840 | 12436 |
43154 | 43154 | 2022-04-22 | Missouri | 29 | 1431774 | 20192 |
43155 | 43155 | 2022-04-22 | Montana | 30 | 273733 | 3262 |
43156 | 43156 | 2022-04-22 | Nebraska | 31 | 479181 | 4197 |
43157 | 43157 | 2022-04-22 | Nevada | 32 | 717028 | 10684 |
43158 | 43158 | 2022-04-22 | New Hampshire | 33 | 307528 | 2475 |
43159 | 43159 | 2022-04-22 | New Jersey | 34 | 2240701 | 33371 |
43160 | 43160 | 2022-04-22 | New Mexico | 35 | 521018 | 7444 |
43161 | 43161 | 2022-04-22 | New York | 36 | 5096091 | 67557 |
43162 | 43162 | 2022-04-22 | North Carolina | 37 | 2649561 | 23373 |
43163 | 43163 | 2022-04-22 | North Dakota | 38 | 240713 | 2307 |
43164 | 43164 | 2022-04-22 | Northern Mariana Islands | 69 | 11221 | 34 |
43165 | 43165 | 2022-04-22 | Ohio | 39 | 2688327 | 38360 |
43166 | 43166 | 2022-04-22 | Oklahoma | 40 | 1038801 | 14219 |
43167 | 43167 | 2022-04-22 | Oregon | 41 | 714346 | 7478 |
43168 | 43168 | 2022-04-22 | Pennsylvania | 42 | 2804987 | 44592 |
43169 | 43169 | 2022-04-22 | Puerto Rico | 72 | 541706 | 4190 |
43170 | 43170 | 2022-04-22 | Rhode Island | 44 | 368246 | 3532 |
43171 | 43171 | 2022-04-22 | South Carolina | 45 | 1472093 | 17734 |
43172 | 43172 | 2022-04-22 | South Dakota | 46 | 237535 | 2901 |
43173 | 43173 | 2022-04-22 | Tennessee | 47 | 1978233 | 25860 |
43174 | 43174 | 2022-04-22 | Texas | 48 | 6734367 | 88199 |
43175 | 43175 | 2022-04-22 | Utah | 49 | 930785 | 4740 |
43176 | 43176 | 2022-04-22 | Vermont | 50 | 121534 | 629 |
43177 | 43177 | 2022-04-22 | Virgin Islands | 78 | 16091 | 111 |
43178 | 43178 | 2022-04-22 | Virginia | 51 | 1691268 | 20149 |
43179 | 43179 | 2022-04-22 | Washington | 53 | 1484441 | 12708 |
43180 | 43180 | 2022-04-22 | West Virginia | 54 | 499796 | 6823 |
43181 | 43181 | 2022-04-22 | Wisconsin | 55 | 1601656 | 14403 |
43182 | 43182 | 2022-04-22 | Wyoming | 56 | 156392 | 1807 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );