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-10-28 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 |
---|---|---|---|---|---|---|
53711 | 53711 | 2022-10-28 | Alabama | 1 | 1534287 | 20558 |
53712 | 53712 | 2022-10-28 | Alaska | 2 | 298479 | 1369 |
53713 | 53713 | 2022-10-28 | American Samoa | 60 | 8257 | 34 |
53714 | 53714 | 2022-10-28 | Arizona | 4 | 2287886 | 31548 |
53715 | 53715 | 2022-10-28 | Arkansas | 5 | 959296 | 12475 |
53716 | 53716 | 2022-10-28 | California | 6 | 11362397 | 96928 |
53717 | 53717 | 2022-10-28 | Colorado | 8 | 1680534 | 13618 |
53718 | 53718 | 2022-10-28 | Connecticut | 9 | 912055 | 11463 |
53719 | 53719 | 2022-10-28 | Delaware | 10 | 312990 | 3147 |
53720 | 53720 | 2022-10-28 | District of Columbia | 11 | 169709 | 1397 |
53721 | 53721 | 2022-10-28 | Florida | 12 | 7149300 | 82176 |
53722 | 53722 | 2022-10-28 | Georgia | 13 | 2835571 | 39057 |
53723 | 53723 | 2022-10-28 | Guam | 66 | 59720 | 402 |
53724 | 53724 | 2022-10-28 | Hawaii | 15 | 353081 | 1701 |
53725 | 53725 | 2022-10-28 | Idaho | 16 | 499980 | 5220 |
53726 | 53726 | 2022-10-28 | Illinois | 17 | 3816464 | 39982 |
53727 | 53727 | 2022-10-28 | Indiana | 18 | 1937565 | 24901 |
53728 | 53728 | 2022-10-28 | Iowa | 19 | 862925 | 10177 |
53729 | 53729 | 2022-10-28 | Kansas | 20 | 888322 | 9632 |
53730 | 53730 | 2022-10-28 | Kentucky | 21 | 1611523 | 17261 |
53731 | 53731 | 2022-10-28 | Louisiana | 22 | 1461433 | 18168 |
53732 | 53732 | 2022-10-28 | Maine | 23 | 297021 | 2644 |
53733 | 53733 | 2022-10-28 | Maryland | 24 | 1268014 | 15550 |
53734 | 53734 | 2022-10-28 | Massachusetts | 25 | 2086638 | 22023 |
53735 | 53735 | 2022-10-28 | Michigan | 26 | 2886176 | 39250 |
53736 | 53736 | 2022-10-28 | Minnesota | 27 | 1686048 | 13825 |
53737 | 53737 | 2022-10-28 | Mississippi | 28 | 933065 | 12968 |
53738 | 53738 | 2022-10-28 | Missouri | 29 | 1684195 | 21847 |
53739 | 53739 | 2022-10-28 | Montana | 30 | 314743 | 3574 |
53740 | 53740 | 2022-10-28 | Nebraska | 31 | 535012 | 4550 |
53741 | 53741 | 2022-10-28 | Nevada | 32 | 852961 | 11555 |
53742 | 53742 | 2022-10-28 | New Hampshire | 33 | 356867 | 2745 |
53743 | 53743 | 2022-10-28 | New Jersey | 34 | 2791469 | 34905 |
53744 | 53744 | 2022-10-28 | New Mexico | 35 | 627203 | 8644 |
53745 | 53745 | 2022-10-28 | New York | 36 | 6228543 | 72414 |
53746 | 53746 | 2022-10-28 | North Carolina | 37 | 3237440 | 26963 |
53747 | 53747 | 2022-10-28 | North Dakota | 38 | 272812 | 2434 |
53748 | 53748 | 2022-10-28 | Northern Mariana Islands | 69 | 13171 | 40 |
53749 | 53749 | 2022-10-28 | Ohio | 39 | 3185038 | 40178 |
53750 | 53750 | 2022-10-28 | Oklahoma | 40 | 1208316 | 14961 |
53751 | 53751 | 2022-10-28 | Oregon | 41 | 908188 | 8680 |
53752 | 53752 | 2022-10-28 | Pennsylvania | 42 | 3304816 | 47705 |
53753 | 53753 | 2022-10-28 | Puerto Rico | 72 | 1012950 | 5252 |
53754 | 53754 | 2022-10-28 | Rhode Island | 44 | 432042 | 3696 |
53755 | 53755 | 2022-10-28 | South Carolina | 45 | 1721693 | 18578 |
53756 | 53756 | 2022-10-28 | South Dakota | 46 | 264187 | 3059 |
53757 | 53757 | 2022-10-28 | Tennessee | 47 | 2298594 | 27792 |
53758 | 53758 | 2022-10-28 | Texas | 48 | 7921604 | 91310 |
53759 | 53759 | 2022-10-28 | Utah | 49 | 1045758 | 5056 |
53760 | 53760 | 2022-10-28 | Vermont | 50 | 144895 | 740 |
53761 | 53761 | 2022-10-28 | Virgin Islands | 78 | 23311 | 124 |
53762 | 53762 | 2022-10-28 | Virginia | 51 | 2117608 | 22189 |
53763 | 53763 | 2022-10-28 | Washington | 53 | 1835792 | 14595 |
53764 | 53764 | 2022-10-28 | West Virginia | 54 | 607366 | 7514 |
53765 | 53765 | 2022-10-28 | Wisconsin | 55 | 1895481 | 15460 |
53766 | 53766 | 2022-10-28 | Wyoming | 56 | 178444 | 1908 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );