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-08 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 |
---|---|---|---|---|---|---|
42343 | 42343 | 2022-04-08 | Alabama | 1 | 1296730 | 19376 |
42344 | 42344 | 2022-04-08 | Alaska | 2 | 247078 | 1192 |
42345 | 42345 | 2022-04-08 | American Samoa | 60 | 4957 | 8 |
42346 | 42346 | 2022-04-08 | Arizona | 4 | 2014020 | 29681 |
42347 | 42347 | 2022-04-08 | Arkansas | 5 | 833595 | 11301 |
42348 | 42348 | 2022-04-08 | California | 6 | 9132016 | 89426 |
42349 | 42349 | 2022-04-08 | Colorado | 8 | 1361839 | 12199 |
42350 | 42350 | 2022-04-08 | Connecticut | 9 | 740894 | 10801 |
42351 | 42351 | 2022-04-08 | Delaware | 10 | 259008 | 2871 |
42352 | 42352 | 2022-04-08 | District of Columbia | 11 | 137603 | 1331 |
42353 | 42353 | 2022-04-08 | Florida | 12 | 5862817 | 73538 |
42354 | 42354 | 2022-04-08 | Georgia | 13 | 2433184 | 35911 |
42355 | 42355 | 2022-04-08 | Guam | 66 | 48510 | 353 |
42356 | 42356 | 2022-04-08 | Hawaii | 15 | 235797 | 1379 |
42357 | 42357 | 2022-04-08 | Idaho | 16 | 444727 | 4898 |
42358 | 42358 | 2022-04-08 | Illinois | 17 | 3086087 | 37764 |
42359 | 42359 | 2022-04-08 | Indiana | 18 | 1692704 | 23479 |
42360 | 42360 | 2022-04-08 | Iowa | 19 | 759475 | 9454 |
42361 | 42361 | 2022-04-08 | Kansas | 20 | 771854 | 8500 |
42362 | 42362 | 2022-04-08 | Kentucky | 21 | 1326505 | 15054 |
42363 | 42363 | 2022-04-08 | Louisiana | 22 | 1233479 | 17177 |
42364 | 42364 | 2022-04-08 | Maine | 23 | 237481 | 2221 |
42365 | 42365 | 2022-04-08 | Maryland | 24 | 1015622 | 14371 |
42366 | 42366 | 2022-04-08 | Massachusetts | 25 | 1709900 | 20143 |
42367 | 42367 | 2022-04-08 | Michigan | 26 | 2387517 | 35736 |
42368 | 42368 | 2022-04-08 | Minnesota | 27 | 1433465 | 12680 |
42369 | 42369 | 2022-04-08 | Mississippi | 28 | 795824 | 12413 |
42370 | 42370 | 2022-04-08 | Missouri | 29 | 1429494 | 20178 |
42371 | 42371 | 2022-04-08 | Montana | 30 | 273092 | 3255 |
42372 | 42372 | 2022-04-08 | Nebraska | 31 | 478044 | 4175 |
42373 | 42373 | 2022-04-08 | Nevada | 32 | 714478 | 10154 |
42374 | 42374 | 2022-04-08 | New Hampshire | 33 | 303755 | 2458 |
42375 | 42375 | 2022-04-08 | New Jersey | 34 | 2212245 | 33294 |
42376 | 42376 | 2022-04-08 | New Mexico | 35 | 518941 | 7362 |
42377 | 42377 | 2022-04-08 | New York | 36 | 5011544 | 67387 |
42378 | 42378 | 2022-04-08 | North Carolina | 37 | 2635742 | 23268 |
42379 | 42379 | 2022-04-08 | North Dakota | 38 | 240110 | 2298 |
42380 | 42380 | 2022-04-08 | Northern Mariana Islands | 69 | 11158 | 33 |
42381 | 42381 | 2022-04-08 | Ohio | 39 | 2676629 | 38166 |
42382 | 42382 | 2022-04-08 | Oklahoma | 40 | 1035301 | 14087 |
42383 | 42383 | 2022-04-08 | Oregon | 41 | 706687 | 7296 |
42384 | 42384 | 2022-04-08 | Pennsylvania | 42 | 2787687 | 44404 |
42385 | 42385 | 2022-04-08 | Puerto Rico | 72 | 518750 | 4173 |
42386 | 42386 | 2022-04-08 | Rhode Island | 44 | 363372 | 3525 |
42387 | 42387 | 2022-04-08 | South Carolina | 45 | 1469706 | 17650 |
42388 | 42388 | 2022-04-08 | South Dakota | 46 | 237246 | 2893 |
42389 | 42389 | 2022-04-08 | Tennessee | 47 | 1973820 | 25618 |
42390 | 42390 | 2022-04-08 | Texas | 48 | 6701915 | 87747 |
42391 | 42391 | 2022-04-08 | Utah | 49 | 928847 | 4730 |
42392 | 42392 | 2022-04-08 | Vermont | 50 | 117991 | 620 |
42393 | 42393 | 2022-04-08 | Virgin Islands | 78 | 15764 | 111 |
42394 | 42394 | 2022-04-08 | Virginia | 51 | 1675845 | 19859 |
42395 | 42395 | 2022-04-08 | Washington | 53 | 1468041 | 12623 |
42396 | 42396 | 2022-04-08 | West Virginia | 54 | 498414 | 6753 |
42397 | 42397 | 2022-04-08 | Wisconsin | 55 | 1590422 | 14344 |
42398 | 42398 | 2022-04-08 | Wyoming | 56 | 156281 | 1796 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );