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-11-02 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 |
---|---|---|---|---|---|---|
53991 | 53991 | 2022-11-02 | Alabama | 1 | 1534287 | 20558 |
53992 | 53992 | 2022-11-02 | Alaska | 2 | 298845 | 1369 |
53993 | 53993 | 2022-11-02 | American Samoa | 60 | 8257 | 34 |
53994 | 53994 | 2022-11-02 | Arizona | 4 | 2293015 | 31573 |
53995 | 53995 | 2022-11-02 | Arkansas | 5 | 960630 | 12506 |
53996 | 53996 | 2022-11-02 | California | 6 | 11367123 | 96976 |
53997 | 53997 | 2022-11-02 | Colorado | 8 | 1684272 | 13635 |
53998 | 53998 | 2022-11-02 | Connecticut | 9 | 913979 | 11478 |
53999 | 53999 | 2022-11-02 | Delaware | 10 | 313600 | 3147 |
54000 | 54000 | 2022-11-02 | District of Columbia | 11 | 169709 | 1397 |
54001 | 54001 | 2022-11-02 | Florida | 12 | 7149300 | 82176 |
54002 | 54002 | 2022-11-02 | Georgia | 13 | 2839500 | 39127 |
54003 | 54003 | 2022-11-02 | Guam | 66 | 59804 | 404 |
54004 | 54004 | 2022-11-02 | Hawaii | 15 | 354077 | 1708 |
54005 | 54005 | 2022-11-02 | Idaho | 16 | 500972 | 5228 |
54006 | 54006 | 2022-11-02 | Illinois | 17 | 3825128 | 40032 |
54007 | 54007 | 2022-11-02 | Indiana | 18 | 1942708 | 24901 |
54008 | 54008 | 2022-11-02 | Iowa | 19 | 864752 | 10207 |
54009 | 54009 | 2022-11-02 | Kansas | 20 | 890680 | 9632 |
54010 | 54010 | 2022-11-02 | Kentucky | 21 | 1618948 | 17322 |
54011 | 54011 | 2022-11-02 | Louisiana | 22 | 1463379 | 18193 |
54012 | 54012 | 2022-11-02 | Maine | 23 | 297958 | 2653 |
54013 | 54013 | 2022-11-02 | Maryland | 24 | 1271118 | 15578 |
54014 | 54014 | 2022-11-02 | Massachusetts | 25 | 2086638 | 22023 |
54015 | 54015 | 2022-11-02 | Michigan | 26 | 2889119 | 39354 |
54016 | 54016 | 2022-11-02 | Minnesota | 27 | 1686048 | 13825 |
54017 | 54017 | 2022-11-02 | Mississippi | 28 | 934401 | 12992 |
54018 | 54018 | 2022-11-02 | Missouri | 29 | 1690224 | 21867 |
54019 | 54019 | 2022-11-02 | Montana | 30 | 314811 | 3574 |
54020 | 54020 | 2022-11-02 | Nebraska | 31 | 535305 | 4550 |
54021 | 54021 | 2022-11-02 | Nevada | 32 | 852961 | 11570 |
54022 | 54022 | 2022-11-02 | New Hampshire | 33 | 357570 | 2761 |
54023 | 54023 | 2022-11-02 | New Jersey | 34 | 2801506 | 34925 |
54024 | 54024 | 2022-11-02 | New Mexico | 35 | 629318 | 8647 |
54025 | 54025 | 2022-11-02 | New York | 36 | 6248012 | 72468 |
54026 | 54026 | 2022-11-02 | North Carolina | 37 | 3246175 | 27244 |
54027 | 54027 | 2022-11-02 | North Dakota | 38 | 272812 | 2434 |
54028 | 54028 | 2022-11-02 | Northern Mariana Islands | 69 | 13212 | 41 |
54029 | 54029 | 2022-11-02 | Ohio | 39 | 3185038 | 40178 |
54030 | 54030 | 2022-11-02 | Oklahoma | 40 | 1208316 | 14961 |
54031 | 54031 | 2022-11-02 | Oregon | 41 | 910693 | 8726 |
54032 | 54032 | 2022-11-02 | Pennsylvania | 42 | 3317854 | 47840 |
54033 | 54033 | 2022-11-02 | Puerto Rico | 72 | 1016756 | 5265 |
54034 | 54034 | 2022-11-02 | Rhode Island | 44 | 432042 | 3696 |
54035 | 54035 | 2022-11-02 | South Carolina | 45 | 1725160 | 18633 |
54036 | 54036 | 2022-11-02 | South Dakota | 46 | 265019 | 3065 |
54037 | 54037 | 2022-11-02 | Tennessee | 47 | 2305487 | 27839 |
54038 | 54038 | 2022-11-02 | Texas | 48 | 7928639 | 91349 |
54039 | 54039 | 2022-11-02 | Utah | 49 | 1045758 | 5056 |
54040 | 54040 | 2022-11-02 | Vermont | 50 | 145409 | 754 |
54041 | 54041 | 2022-11-02 | Virgin Islands | 78 | 23311 | 124 |
54042 | 54042 | 2022-11-02 | Virginia | 51 | 2122439 | 22211 |
54043 | 54043 | 2022-11-02 | Washington | 53 | 1838841 | 14631 |
54044 | 54044 | 2022-11-02 | West Virginia | 54 | 608652 | 7534 |
54045 | 54045 | 2022-11-02 | Wisconsin | 55 | 1900042 | 15481 |
54046 | 54046 | 2022-11-02 | Wyoming | 56 | 178866 | 1914 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );