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-23 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 |
---|---|---|---|---|---|---|
41447 | 41447 | 2022-03-23 | Alabama | 1 | 1291946 | 19169 |
41448 | 41448 | 2022-03-23 | Alaska | 2 | 244247 | 1186 |
41449 | 41449 | 2022-03-23 | American Samoa | 60 | 1932 | 0 |
41450 | 41450 | 2022-03-23 | Arizona | 4 | 1997037 | 28883 |
41451 | 41451 | 2022-03-23 | Arkansas | 5 | 831947 | 11152 |
41452 | 41452 | 2022-03-23 | California | 6 | 9079164 | 88461 |
41453 | 41453 | 2022-03-23 | Colorado | 8 | 1342319 | 12186 |
41454 | 41454 | 2022-03-23 | Connecticut | 9 | 733328 | 10740 |
41455 | 41455 | 2022-03-23 | Delaware | 10 | 258803 | 2835 |
41456 | 41456 | 2022-03-23 | District of Columbia | 11 | 135955 | 1329 |
41457 | 41457 | 2022-03-23 | Florida | 12 | 5838503 | 72880 |
41458 | 41458 | 2022-03-23 | Georgia | 13 | 2414539 | 35254 |
41459 | 41459 | 2022-03-23 | Guam | 66 | 47911 | 341 |
41460 | 41460 | 2022-03-23 | Hawaii | 15 | 233569 | 1370 |
41461 | 41461 | 2022-03-23 | Idaho | 16 | 443399 | 4863 |
41462 | 41462 | 2022-03-23 | Illinois | 17 | 3063751 | 37554 |
41463 | 41463 | 2022-03-23 | Indiana | 18 | 1693683 | 23334 |
41464 | 41464 | 2022-03-23 | Iowa | 19 | 757985 | 9402 |
41465 | 41465 | 2022-03-23 | Kansas | 20 | 770530 | 8222 |
41466 | 41466 | 2022-03-23 | Kentucky | 21 | 1316778 | 14676 |
41467 | 41467 | 2022-03-23 | Louisiana | 22 | 1231556 | 17045 |
41468 | 41468 | 2022-03-23 | Maine | 23 | 234159 | 2190 |
41469 | 41469 | 2022-03-23 | Maryland | 24 | 1009607 | 14311 |
41470 | 41470 | 2022-03-23 | Massachusetts | 25 | 1689750 | 20058 |
41471 | 41471 | 2022-03-23 | Michigan | 26 | 2376507 | 35493 |
41472 | 41472 | 2022-03-23 | Minnesota | 27 | 1426546 | 12562 |
41473 | 41473 | 2022-03-23 | Mississippi | 28 | 793870 | 12369 |
41474 | 41474 | 2022-03-23 | Missouri | 29 | 1424494 | 20041 |
41475 | 41475 | 2022-03-23 | Montana | 30 | 272554 | 3238 |
41476 | 41476 | 2022-03-23 | Nebraska | 31 | 477227 | 4051 |
41477 | 41477 | 2022-03-23 | Nevada | 32 | 711794 | 10031 |
41478 | 41478 | 2022-03-23 | New Hampshire | 33 | 301534 | 2443 |
41479 | 41479 | 2022-03-23 | New Jersey | 34 | 2190843 | 33192 |
41480 | 41480 | 2022-03-23 | New Mexico | 35 | 516889 | 7182 |
41481 | 41481 | 2022-03-23 | New York | 36 | 4953072 | 67238 |
41482 | 41482 | 2022-03-23 | North Carolina | 37 | 2623506 | 23140 |
41483 | 41483 | 2022-03-23 | North Dakota | 38 | 239442 | 2279 |
41484 | 41484 | 2022-03-23 | Northern Mariana Islands | 69 | 10985 | 31 |
41485 | 41485 | 2022-03-23 | Ohio | 39 | 2666030 | 37608 |
41486 | 41486 | 2022-03-23 | Oklahoma | 40 | 1031145 | 13730 |
41487 | 41487 | 2022-03-23 | Oregon | 41 | 702288 | 7013 |
41488 | 41488 | 2022-03-23 | Pennsylvania | 42 | 2776302 | 44115 |
41489 | 41489 | 2022-03-23 | Puerto Rico | 72 | 511654 | 4158 |
41490 | 41490 | 2022-03-23 | Rhode Island | 44 | 359823 | 3433 |
41491 | 41491 | 2022-03-23 | South Carolina | 45 | 1467115 | 17493 |
41492 | 41492 | 2022-03-23 | South Dakota | 46 | 236955 | 2880 |
41493 | 41493 | 2022-03-23 | Tennessee | 47 | 1970164 | 25214 |
41494 | 41494 | 2022-03-23 | Texas | 48 | 6652826 | 87120 |
41495 | 41495 | 2022-03-23 | Utah | 49 | 927224 | 4645 |
41496 | 41496 | 2022-03-23 | Vermont | 50 | 115531 | 614 |
41497 | 41497 | 2022-03-23 | Virgin Islands | 78 | 15596 | 110 |
41498 | 41498 | 2022-03-23 | Virginia | 51 | 1663132 | 19563 |
41499 | 41499 | 2022-03-23 | Washington | 53 | 1449475 | 12467 |
41500 | 41500 | 2022-03-23 | West Virginia | 54 | 496983 | 6680 |
41501 | 41501 | 2022-03-23 | Wisconsin | 55 | 1582174 | 14102 |
41502 | 41502 | 2022-03-23 | Wyoming | 56 | 155988 | 1783 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );