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 2021-10-06 sorted by date
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 |
---|---|---|---|---|---|---|
32039 | 32039 | 2021-10-06 | Alabama | 1 | 804249 | 14612 |
32040 | 32040 | 2021-10-06 | Alaska | 2 | 118809 | 567 |
32041 | 32041 | 2021-10-06 | American Samoa | 60 | 3 | 0 |
32042 | 32042 | 2021-10-06 | Arizona | 4 | 1108830 | 20250 |
32043 | 32043 | 2021-10-06 | Arkansas | 5 | 499886 | 7781 |
32044 | 32044 | 2021-10-06 | California | 6 | 4775779 | 69819 |
32045 | 32045 | 2021-10-06 | Colorado | 8 | 686076 | 7843 |
32046 | 32046 | 2021-10-06 | Connecticut | 9 | 392951 | 8667 |
32047 | 32047 | 2021-10-06 | Delaware | 10 | 135695 | 1977 |
32048 | 32048 | 2021-10-06 | District of Columbia | 11 | 61978 | 1180 |
32049 | 32049 | 2021-10-06 | Florida | 12 | 3594182 | 55625 |
32050 | 32050 | 2021-10-06 | Georgia | 13 | 1558745 | 25918 |
32051 | 32051 | 2021-10-06 | Guam | 66 | 16758 | 211 |
32052 | 32052 | 2021-10-06 | Hawaii | 15 | 78127 | 815 |
32053 | 32053 | 2021-10-06 | Idaho | 16 | 264710 | 3046 |
32054 | 32054 | 2021-10-06 | Illinois | 17 | 1648902 | 27878 |
32055 | 32055 | 2021-10-06 | Indiana | 18 | 980206 | 15921 |
32056 | 32056 | 2021-10-06 | Iowa | 19 | 461729 | 6654 |
32057 | 32057 | 2021-10-06 | Kansas | 20 | 416428 | 6134 |
32058 | 32058 | 2021-10-06 | Kentucky | 21 | 711453 | 9067 |
32059 | 32059 | 2021-10-06 | Louisiana | 22 | 745571 | 14102 |
32060 | 32060 | 2021-10-06 | Maine | 23 | 93201 | 1065 |
32061 | 32061 | 2021-10-06 | Maryland | 24 | 539283 | 10533 |
32062 | 32062 | 2021-10-06 | Massachusetts | 25 | 819939 | 18707 |
32063 | 32063 | 2021-10-06 | Michigan | 26 | 1176689 | 22590 |
32064 | 32064 | 2021-10-06 | Minnesota | 27 | 729447 | 8356 |
32065 | 32065 | 2021-10-06 | Mississippi | 28 | 492558 | 9768 |
32066 | 32066 | 2021-10-06 | Missouri | 29 | 845632 | 12382 |
32067 | 32067 | 2021-10-06 | Montana | 30 | 156245 | 2061 |
32068 | 32068 | 2021-10-06 | Nebraska | 31 | 269942 | 2841 |
32069 | 32069 | 2021-10-06 | Nevada | 32 | 434754 | 7246 |
32070 | 32070 | 2021-10-06 | New Hampshire | 33 | 122934 | 1493 |
32071 | 32071 | 2021-10-06 | New Jersey | 34 | 1164378 | 27542 |
32072 | 32072 | 2021-10-06 | New Mexico | 35 | 256947 | 4842 |
32073 | 32073 | 2021-10-06 | New York | 36 | 2453544 | 55131 |
32074 | 32074 | 2021-10-06 | North Carolina | 37 | 1419463 | 16962 |
32075 | 32075 | 2021-10-06 | North Dakota | 38 | 135761 | 1662 |
32076 | 32076 | 2021-10-06 | Northern Mariana Islands | 69 | 273 | 2 |
32077 | 32077 | 2021-10-06 | Ohio | 39 | 1445786 | 22490 |
32078 | 32078 | 2021-10-06 | Oklahoma | 40 | 620834 | 9213 |
32079 | 32079 | 2021-10-06 | Oregon | 41 | 338130 | 3900 |
32080 | 32080 | 2021-10-06 | Pennsylvania | 42 | 1458445 | 29722 |
32081 | 32081 | 2021-10-06 | Puerto Rico | 72 | 215549 | 3175 |
32082 | 32082 | 2021-10-06 | Rhode Island | 44 | 173937 | 2848 |
32083 | 32083 | 2021-10-06 | South Carolina | 45 | 869838 | 12784 |
32084 | 32084 | 2021-10-06 | South Dakota | 46 | 146995 | 2167 |
32085 | 32085 | 2021-10-06 | Tennessee | 47 | 1215820 | 15317 |
32086 | 32086 | 2021-10-06 | Texas | 48 | 4108141 | 67015 |
32087 | 32087 | 2021-10-06 | Utah | 49 | 516848 | 2974 |
32088 | 32088 | 2021-10-06 | Vermont | 50 | 34632 | 327 |
32089 | 32089 | 2021-10-06 | Virgin Islands | 78 | 6873 | 72 |
32090 | 32090 | 2021-10-06 | Virginia | 51 | 882437 | 12999 |
32091 | 32091 | 2021-10-06 | Washington | 53 | 675511 | 7970 |
32092 | 32092 | 2021-10-06 | West Virginia | 54 | 247806 | 3839 |
32093 | 32093 | 2021-10-06 | Wisconsin | 55 | 828403 | 8970 |
32094 | 32094 | 2021-10-06 | Wyoming | 56 | 93083 | 1041 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );