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-10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|
40719 | 40719 | 2022-03-10 | Alabama | 1 | 1288454 | 18766 |
40720 | 40720 | 2022-03-10 | Alaska | 2 | 241191 | 1165 |
40721 | 40721 | 2022-03-10 | American Samoa | 60 | 382 | 0 |
40722 | 40722 | 2022-03-10 | Arizona | 4 | 1987318 | 28097 |
40723 | 40723 | 2022-03-10 | Arkansas | 5 | 824988 | 10836 |
40724 | 40724 | 2022-03-10 | California | 6 | 9028579 | 87197 |
40725 | 40725 | 2022-03-10 | Colorado | 8 | 1329539 | 12081 |
40726 | 40726 | 2022-03-10 | Connecticut | 9 | 729354 | 10615 |
40727 | 40727 | 2022-03-10 | Delaware | 10 | 257848 | 2753 |
40728 | 40728 | 2022-03-10 | District of Columbia | 11 | 135086 | 1324 |
40729 | 40729 | 2022-03-10 | Florida | 12 | 5823350 | 71474 |
40730 | 40730 | 2022-03-10 | Georgia | 13 | 2405387 | 34741 |
40731 | 40731 | 2022-03-10 | Guam | 66 | 47092 | 338 |
40732 | 40732 | 2022-03-10 | Hawaii | 15 | 231844 | 1351 |
40733 | 40733 | 2022-03-10 | Idaho | 16 | 437151 | 4818 |
40734 | 40734 | 2022-03-10 | Illinois | 17 | 3049442 | 37271 |
40735 | 40735 | 2022-03-10 | Indiana | 18 | 1690382 | 23126 |
40736 | 40736 | 2022-03-10 | Iowa | 19 | 756359 | 9262 |
40737 | 40737 | 2022-03-10 | Kansas | 20 | 769354 | 8027 |
40738 | 40738 | 2022-03-10 | Kentucky | 21 | 1300073 | 14182 |
40739 | 40739 | 2022-03-10 | Louisiana | 22 | 1229511 | 16862 |
40740 | 40740 | 2022-03-10 | Maine | 23 | 231758 | 2140 |
40741 | 40741 | 2022-03-10 | Maryland | 24 | 1005981 | 14229 |
40742 | 40742 | 2022-03-10 | Massachusetts | 25 | 1679921 | 23732 |
40743 | 40743 | 2022-03-10 | Michigan | 26 | 2364186 | 35096 |
40744 | 40744 | 2022-03-10 | Minnesota | 27 | 1421512 | 12455 |
40745 | 40745 | 2022-03-10 | Mississippi | 28 | 792289 | 12247 |
40746 | 40746 | 2022-03-10 | Missouri | 29 | 1419328 | 19532 |
40747 | 40747 | 2022-03-10 | Montana | 30 | 271832 | 3222 |
40748 | 40748 | 2022-03-10 | Nebraska | 31 | 476807 | 4025 |
40749 | 40749 | 2022-03-10 | Nevada | 32 | 687506 | 9895 |
40750 | 40750 | 2022-03-10 | New Hampshire | 33 | 299999 | 2414 |
40751 | 40751 | 2022-03-10 | New Jersey | 34 | 2178977 | 33067 |
40752 | 40752 | 2022-03-10 | New Mexico | 35 | 514901 | 7042 |
40753 | 40753 | 2022-03-10 | New York | 36 | 4925680 | 67003 |
40754 | 40754 | 2022-03-10 | North Carolina | 37 | 2608470 | 22902 |
40755 | 40755 | 2022-03-10 | North Dakota | 38 | 239043 | 2270 |
40756 | 40756 | 2022-03-10 | Northern Mariana Islands | 69 | 10326 | 30 |
40757 | 40757 | 2022-03-10 | Ohio | 39 | 2662425 | 37212 |
40758 | 40758 | 2022-03-10 | Oklahoma | 40 | 1026650 | 13514 |
40759 | 40759 | 2022-03-10 | Oregon | 41 | 698982 | 6854 |
40760 | 40760 | 2022-03-10 | Pennsylvania | 42 | 2767631 | 43767 |
40761 | 40761 | 2022-03-10 | Puerto Rico | 72 | 508994 | 4146 |
40762 | 40762 | 2022-03-10 | Rhode Island | 44 | 357647 | 3421 |
40763 | 40763 | 2022-03-10 | South Carolina | 45 | 1464590 | 17331 |
40764 | 40764 | 2022-03-10 | South Dakota | 46 | 236552 | 2848 |
40765 | 40765 | 2022-03-10 | Tennessee | 47 | 1966089 | 24549 |
40766 | 40766 | 2022-03-10 | Texas | 48 | 6601706 | 86266 |
40767 | 40767 | 2022-03-10 | Utah | 49 | 925469 | 4518 |
40768 | 40768 | 2022-03-10 | Vermont | 50 | 113762 | 608 |
40769 | 40769 | 2022-03-10 | Virgin Islands | 78 | 15449 | 109 |
40770 | 40770 | 2022-03-10 | Virginia | 51 | 1651940 | 19165 |
40771 | 40771 | 2022-03-10 | Washington | 53 | 1435650 | 12210 |
40772 | 40772 | 2022-03-10 | West Virginia | 54 | 494406 | 6544 |
40773 | 40773 | 2022-03-10 | Wisconsin | 55 | 1577393 | 13664 |
40774 | 40774 | 2022-03-10 | Wyoming | 56 | 155686 | 1749 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );