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-30 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|
53823 | 53823 | 2022-10-30 | Alabama | 1 | 1534287 | 20558 |
53824 | 53824 | 2022-10-30 | Alaska | 2 | 298479 | 1369 |
53825 | 53825 | 2022-10-30 | American Samoa | 60 | 8257 | 34 |
53826 | 53826 | 2022-10-30 | Arizona | 4 | 2287886 | 31548 |
53827 | 53827 | 2022-10-30 | Arkansas | 5 | 959682 | 12488 |
53828 | 53828 | 2022-10-30 | California | 6 | 11362397 | 96928 |
53829 | 53829 | 2022-10-30 | Colorado | 8 | 1680534 | 13618 |
53830 | 53830 | 2022-10-30 | Connecticut | 9 | 912997 | 11463 |
53831 | 53831 | 2022-10-30 | Delaware | 10 | 312990 | 3147 |
53832 | 53832 | 2022-10-30 | District of Columbia | 11 | 169709 | 1397 |
53833 | 53833 | 2022-10-30 | Florida | 12 | 7149300 | 82176 |
53834 | 53834 | 2022-10-30 | Georgia | 13 | 2835571 | 39057 |
53835 | 53835 | 2022-10-30 | Guam | 66 | 59720 | 402 |
53836 | 53836 | 2022-10-30 | Hawaii | 15 | 353081 | 1701 |
53837 | 53837 | 2022-10-30 | Idaho | 16 | 499980 | 5220 |
53838 | 53838 | 2022-10-30 | Illinois | 17 | 3816464 | 39982 |
53839 | 53839 | 2022-10-30 | Indiana | 18 | 1937565 | 24901 |
53840 | 53840 | 2022-10-30 | Iowa | 19 | 862925 | 10177 |
53841 | 53841 | 2022-10-30 | Kansas | 20 | 888322 | 9632 |
53842 | 53842 | 2022-10-30 | Kentucky | 21 | 1611523 | 17261 |
53843 | 53843 | 2022-10-30 | Louisiana | 22 | 1461433 | 18168 |
53844 | 53844 | 2022-10-30 | Maine | 23 | 297246 | 2648 |
53845 | 53845 | 2022-10-30 | Maryland | 24 | 1268014 | 15550 |
53846 | 53846 | 2022-10-30 | Massachusetts | 25 | 2086638 | 22023 |
53847 | 53847 | 2022-10-30 | Michigan | 26 | 2886176 | 39250 |
53848 | 53848 | 2022-10-30 | Minnesota | 27 | 1686048 | 13825 |
53849 | 53849 | 2022-10-30 | Mississippi | 28 | 933065 | 12968 |
53850 | 53850 | 2022-10-30 | Missouri | 29 | 1684195 | 21847 |
53851 | 53851 | 2022-10-30 | Montana | 30 | 314743 | 3574 |
53852 | 53852 | 2022-10-30 | Nebraska | 31 | 535012 | 4550 |
53853 | 53853 | 2022-10-30 | Nevada | 32 | 852961 | 11555 |
53854 | 53854 | 2022-10-30 | New Hampshire | 33 | 356867 | 2745 |
53855 | 53855 | 2022-10-30 | New Jersey | 34 | 2791469 | 34905 |
53856 | 53856 | 2022-10-30 | New Mexico | 35 | 627203 | 8644 |
53857 | 53857 | 2022-10-30 | New York | 36 | 6232565 | 72414 |
53858 | 53858 | 2022-10-30 | North Carolina | 37 | 3237440 | 26963 |
53859 | 53859 | 2022-10-30 | North Dakota | 38 | 272812 | 2434 |
53860 | 53860 | 2022-10-30 | Northern Mariana Islands | 69 | 13171 | 40 |
53861 | 53861 | 2022-10-30 | Ohio | 39 | 3185038 | 40178 |
53862 | 53862 | 2022-10-30 | Oklahoma | 40 | 1208316 | 14961 |
53863 | 53863 | 2022-10-30 | Oregon | 41 | 908188 | 8680 |
53864 | 53864 | 2022-10-30 | Pennsylvania | 42 | 3304816 | 47705 |
53865 | 53865 | 2022-10-30 | Puerto Rico | 72 | 1014746 | 5259 |
53866 | 53866 | 2022-10-30 | Rhode Island | 44 | 432042 | 3696 |
53867 | 53867 | 2022-10-30 | South Carolina | 45 | 1721693 | 18578 |
53868 | 53868 | 2022-10-30 | South Dakota | 46 | 264187 | 3059 |
53869 | 53869 | 2022-10-30 | Tennessee | 47 | 2298594 | 27792 |
53870 | 53870 | 2022-10-30 | Texas | 48 | 7921604 | 91310 |
53871 | 53871 | 2022-10-30 | Utah | 49 | 1045758 | 5056 |
53872 | 53872 | 2022-10-30 | Vermont | 50 | 144895 | 740 |
53873 | 53873 | 2022-10-30 | Virgin Islands | 78 | 23311 | 124 |
53874 | 53874 | 2022-10-30 | Virginia | 51 | 2117608 | 22189 |
53875 | 53875 | 2022-10-30 | Washington | 53 | 1835792 | 14595 |
53876 | 53876 | 2022-10-30 | West Virginia | 54 | 607366 | 7514 |
53877 | 53877 | 2022-10-30 | Wisconsin | 55 | 1895481 | 15460 |
53878 | 53878 | 2022-10-30 | 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 );