ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-01-07 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Alabama 1
- Alaska 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
- Nevada 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
17065 | 17065 | 2021-01-07 | Alabama | 1 | 389230 | 5080 |
17066 | 17066 | 2021-01-07 | Alaska | 2 | 48961 | 214 |
17067 | 17067 | 2021-01-07 | Arizona | 4 | 588383 | 9764 |
17068 | 17068 | 2021-01-07 | Arkansas | 5 | 245916 | 3926 |
17069 | 17069 | 2021-01-07 | California | 6 | 2589250 | 28554 |
17070 | 17070 | 2021-01-07 | Colorado | 8 | 354998 | 5164 |
17071 | 17071 | 2021-01-07 | Connecticut | 9 | 202758 | 6287 |
17072 | 17072 | 2021-01-07 | Delaware | 10 | 62949 | 949 |
17073 | 17073 | 2021-01-07 | District of Columbia | 11 | 30750 | 808 |
17074 | 17074 | 2021-01-07 | Florida | 12 | 1429714 | 22480 |
17075 | 17075 | 2021-01-07 | Georgia | 13 | 699806 | 10878 |
17076 | 17076 | 2021-01-07 | Guam | 66 | 8355 | 124 |
17077 | 17077 | 2021-01-07 | Hawaii | 15 | 22611 | 297 |
17078 | 17078 | 2021-01-07 | Idaho | 16 | 147500 | 1519 |
17079 | 17079 | 2021-01-07 | Illinois | 17 | 1010808 | 18944 |
17080 | 17080 | 2021-01-07 | Indiana | 18 | 549514 | 8823 |
17081 | 17081 | 2021-01-07 | Iowa | 19 | 293189 | 4065 |
17082 | 17082 | 2021-01-07 | Kansas | 20 | 240540 | 3027 |
17083 | 17083 | 2021-01-07 | Kentucky | 21 | 294951 | 3161 |
17084 | 17084 | 2021-01-07 | Louisiana | 22 | 338054 | 7728 |
17085 | 17085 | 2021-01-07 | Maine | 23 | 27625 | 385 |
17086 | 17086 | 2021-01-07 | Maryland | 24 | 296049 | 6173 |
17087 | 17087 | 2021-01-07 | Massachusetts | 25 | 411601 | 12909 |
17088 | 17088 | 2021-01-07 | Michigan | 26 | 553222 | 13863 |
17089 | 17089 | 2021-01-07 | Minnesota | 27 | 429638 | 5640 |
17090 | 17090 | 2021-01-07 | Mississippi | 28 | 231490 | 5061 |
17091 | 17091 | 2021-01-07 | Missouri | 29 | 440563 | 6238 |
17092 | 17092 | 2021-01-07 | Montana | 30 | 84848 | 1039 |
17093 | 17093 | 2021-01-07 | Nebraska | 31 | 174590 | 1881 |
17094 | 17094 | 2021-01-07 | Nevada | 32 | 241144 | 3349 |
17095 | 17095 | 2021-01-07 | New Hampshire | 33 | 49261 | 827 |
17096 | 17096 | 2021-01-07 | New Jersey | 34 | 564750 | 19646 |
17097 | 17097 | 2021-01-07 | New Mexico | 35 | 151819 | 2682 |
17098 | 17098 | 2021-01-07 | New York | 36 | 1082142 | 38683 |
17099 | 17099 | 2021-01-07 | North Carolina | 37 | 595308 | 7262 |
17100 | 17100 | 2021-01-07 | North Dakota | 38 | 94163 | 1348 |
17101 | 17101 | 2021-01-07 | Northern Mariana Islands | 69 | 125 | 2 |
17102 | 17102 | 2021-01-07 | Ohio | 39 | 753068 | 9462 |
17103 | 17103 | 2021-01-07 | Oklahoma | 40 | 315354 | 2672 |
17104 | 17104 | 2021-01-07 | Oregon | 41 | 121087 | 1577 |
17105 | 17105 | 2021-01-07 | Pennsylvania | 42 | 699018 | 17220 |
17106 | 17106 | 2021-01-07 | Puerto Rico | 72 | 113513 | 1588 |
17107 | 17107 | 2021-01-07 | Rhode Island | 44 | 96591 | 1910 |
17108 | 17108 | 2021-01-07 | South Carolina | 45 | 338112 | 5661 |
17109 | 17109 | 2021-01-07 | South Dakota | 46 | 102132 | 1544 |
17110 | 17110 | 2021-01-07 | Tennessee | 47 | 620557 | 7424 |
17111 | 17111 | 2021-01-07 | Texas | 48 | 1910426 | 29645 |
17112 | 17112 | 2021-01-07 | Utah | 49 | 297317 | 1362 |
17113 | 17113 | 2021-01-07 | Vermont | 50 | 8403 | 155 |
17114 | 17114 | 2021-01-07 | Virgin Islands | 78 | 2042 | 23 |
17115 | 17115 | 2021-01-07 | Virginia | 51 | 382679 | 5275 |
17116 | 17116 | 2021-01-07 | Washington | 53 | 269033 | 3719 |
17117 | 17117 | 2021-01-07 | West Virginia | 54 | 96002 | 1518 |
17118 | 17118 | 2021-01-07 | Wisconsin | 55 | 540508 | 5485 |
17119 | 17119 | 2021-01-07 | Wyoming | 56 | 46168 | 489 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );