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-03-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 |
---|---|---|---|---|---|---|
41279 | 41279 | 2022-03-20 | Alabama | 1 | 1291186 | 19038 |
41280 | 41280 | 2022-03-20 | Alaska | 2 | 243316 | 1166 |
41281 | 41281 | 2022-03-20 | American Samoa | 60 | 1005 | 0 |
41282 | 41282 | 2022-03-20 | Arizona | 4 | 1992471 | 28547 |
41283 | 41283 | 2022-03-20 | Arkansas | 5 | 830310 | 11100 |
41284 | 41284 | 2022-03-20 | California | 6 | 9064239 | 88162 |
41285 | 41285 | 2022-03-20 | Colorado | 8 | 1337264 | 12136 |
41286 | 41286 | 2022-03-20 | Connecticut | 9 | 731868 | 10717 |
41287 | 41287 | 2022-03-20 | Delaware | 10 | 258671 | 2833 |
41288 | 41288 | 2022-03-20 | District of Columbia | 11 | 135752 | 1327 |
41289 | 41289 | 2022-03-20 | Florida | 12 | 5834058 | 72704 |
41290 | 41290 | 2022-03-20 | Georgia | 13 | 2412266 | 35109 |
41291 | 41291 | 2022-03-20 | Guam | 66 | 47699 | 342 |
41292 | 41292 | 2022-03-20 | Hawaii | 15 | 232845 | 1365 |
41293 | 41293 | 2022-03-20 | Idaho | 16 | 442029 | 4838 |
41294 | 41294 | 2022-03-20 | Illinois | 17 | 3058721 | 37459 |
41295 | 41295 | 2022-03-20 | Indiana | 18 | 1692784 | 23290 |
41296 | 41296 | 2022-03-20 | Iowa | 19 | 757551 | 9349 |
41297 | 41297 | 2022-03-20 | Kansas | 20 | 770162 | 8176 |
41298 | 41298 | 2022-03-20 | Kentucky | 21 | 1310548 | 14441 |
41299 | 41299 | 2022-03-20 | Louisiana | 22 | 1230998 | 16996 |
41300 | 41300 | 2022-03-20 | Maine | 23 | 233696 | 2182 |
41301 | 41301 | 2022-03-20 | Maryland | 24 | 1009004 | 14298 |
41302 | 41302 | 2022-03-20 | Massachusetts | 25 | 1685937 | 20029 |
41303 | 41303 | 2022-03-20 | Michigan | 26 | 2372750 | 35379 |
41304 | 41304 | 2022-03-20 | Minnesota | 27 | 1424823 | 12531 |
41305 | 41305 | 2022-03-20 | Mississippi | 28 | 793390 | 12330 |
41306 | 41306 | 2022-03-20 | Missouri | 29 | 1422857 | 19859 |
41307 | 41307 | 2022-03-20 | Montana | 30 | 272346 | 3235 |
41308 | 41308 | 2022-03-20 | Nebraska | 31 | 477198 | 4047 |
41309 | 41309 | 2022-03-20 | Nevada | 32 | 711249 | 9988 |
41310 | 41310 | 2022-03-20 | New Hampshire | 33 | 300941 | 2434 |
41311 | 41311 | 2022-03-20 | New Jersey | 34 | 2188228 | 33170 |
41312 | 41312 | 2022-03-20 | New Mexico | 35 | 516210 | 7147 |
41313 | 41313 | 2022-03-20 | New York | 36 | 4946816 | 67198 |
41314 | 41314 | 2022-03-20 | North Carolina | 37 | 2618734 | 23068 |
41315 | 41315 | 2022-03-20 | North Dakota | 38 | 239442 | 2279 |
41316 | 41316 | 2022-03-20 | Northern Mariana Islands | 69 | 10689 | 31 |
41317 | 41317 | 2022-03-20 | Ohio | 39 | 2666030 | 37608 |
41318 | 41318 | 2022-03-20 | Oklahoma | 40 | 1029977 | 13730 |
41319 | 41319 | 2022-03-20 | Oregon | 41 | 701198 | 6971 |
41320 | 41320 | 2022-03-20 | Pennsylvania | 42 | 2774815 | 44049 |
41321 | 41321 | 2022-03-20 | Puerto Rico | 72 | 511236 | 4154 |
41322 | 41322 | 2022-03-20 | Rhode Island | 44 | 359064 | 3429 |
41323 | 41323 | 2022-03-20 | South Carolina | 45 | 1465739 | 17380 |
41324 | 41324 | 2022-03-20 | South Dakota | 46 | 236845 | 2875 |
41325 | 41325 | 2022-03-20 | Tennessee | 47 | 1969275 | 25181 |
41326 | 41326 | 2022-03-20 | Texas | 48 | 6633345 | 86942 |
41327 | 41327 | 2022-03-20 | Utah | 49 | 926636 | 4561 |
41328 | 41328 | 2022-03-20 | Vermont | 50 | 114868 | 611 |
41329 | 41329 | 2022-03-20 | Virgin Islands | 78 | 15578 | 110 |
41330 | 41330 | 2022-03-20 | Virginia | 51 | 1659710 | 19466 |
41331 | 41331 | 2022-03-20 | Washington | 53 | 1445951 | 12406 |
41332 | 41332 | 2022-03-20 | West Virginia | 54 | 496409 | 6646 |
41333 | 41333 | 2022-03-20 | Wisconsin | 55 | 1580539 | 13960 |
41334 | 41334 | 2022-03-20 | Wyoming | 56 | 155907 | 1769 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );