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-06-21 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|
26140 | 26140 | 2021-06-21 | Alabama | 1 | 549013 | 11311 |
26141 | 26141 | 2021-06-21 | Alaska | 2 | 70372 | 356 |
26142 | 26142 | 2021-06-21 | Arizona | 4 | 890111 | 17843 |
26143 | 26143 | 2021-06-21 | Arkansas | 5 | 345695 | 5876 |
26144 | 26144 | 2021-06-21 | California | 6 | 3810024 | 63353 |
26145 | 26145 | 2021-06-21 | Colorado | 8 | 557234 | 6881 |
26146 | 26146 | 2021-06-21 | Connecticut | 9 | 348757 | 8269 |
26147 | 26147 | 2021-06-21 | Delaware | 10 | 109564 | 1683 |
26148 | 26148 | 2021-06-21 | District of Columbia | 11 | 49248 | 1141 |
26149 | 26149 | 2021-06-21 | Florida | 12 | 2314559 | 37585 |
26150 | 26150 | 2021-06-21 | Georgia | 13 | 1106776 | 20628 |
26151 | 26151 | 2021-06-21 | Guam | 66 | 9253 | 140 |
26152 | 26152 | 2021-06-21 | Hawaii | 15 | 36048 | 510 |
26153 | 26153 | 2021-06-21 | Idaho | 16 | 194327 | 2138 |
26154 | 26154 | 2021-06-21 | Illinois | 17 | 1393461 | 25592 |
26155 | 26155 | 2021-06-21 | Indiana | 18 | 754867 | 13799 |
26156 | 26156 | 2021-06-21 | Iowa | 19 | 373140 | 6115 |
26157 | 26157 | 2021-06-21 | Kansas | 20 | 318248 | 5165 |
26158 | 26158 | 2021-06-21 | Kentucky | 21 | 464584 | 7236 |
26159 | 26159 | 2021-06-21 | Louisiana | 22 | 478139 | 10693 |
26160 | 26160 | 2021-06-21 | Maine | 23 | 68844 | 854 |
26161 | 26161 | 2021-06-21 | Maryland | 24 | 461996 | 9707 |
26162 | 26162 | 2021-06-21 | Massachusetts | 25 | 709443 | 17976 |
26163 | 26163 | 2021-06-21 | Michigan | 26 | 996972 | 20884 |
26164 | 26164 | 2021-06-21 | Minnesota | 27 | 604701 | 7642 |
26165 | 26165 | 2021-06-21 | Mississippi | 28 | 320107 | 7378 |
26166 | 26166 | 2021-06-21 | Missouri | 29 | 626799 | 9850 |
26167 | 26167 | 2021-06-21 | Montana | 30 | 113333 | 1652 |
26168 | 26168 | 2021-06-21 | Nebraska | 31 | 224427 | 2519 |
26169 | 26169 | 2021-06-21 | Nevada | 32 | 329515 | 5646 |
26170 | 26170 | 2021-06-21 | New Hampshire | 33 | 99329 | 1367 |
26171 | 26171 | 2021-06-21 | New Jersey | 34 | 1021323 | 26377 |
26172 | 26172 | 2021-06-21 | New Mexico | 35 | 204961 | 4328 |
26173 | 26173 | 2021-06-21 | New York | 36 | 2110346 | 53034 |
26174 | 26174 | 2021-06-21 | North Carolina | 37 | 1011643 | 13386 |
26175 | 26175 | 2021-06-21 | North Dakota | 38 | 110602 | 1554 |
26176 | 26176 | 2021-06-21 | Northern Mariana Islands | 69 | 183 | 2 |
26177 | 26177 | 2021-06-21 | Ohio | 39 | 1109025 | 20166 |
26178 | 26178 | 2021-06-21 | Oklahoma | 40 | 455986 | 7354 |
26179 | 26179 | 2021-06-21 | Oregon | 41 | 206854 | 2786 |
26180 | 26180 | 2021-06-21 | Pennsylvania | 42 | 1215116 | 27623 |
26181 | 26181 | 2021-06-21 | Puerto Rico | 72 | 173368 | 2540 |
26182 | 26182 | 2021-06-21 | Rhode Island | 44 | 152429 | 2724 |
26183 | 26183 | 2021-06-21 | South Carolina | 45 | 595750 | 9801 |
26184 | 26184 | 2021-06-21 | South Dakota | 46 | 124411 | 2027 |
26185 | 26185 | 2021-06-21 | Tennessee | 47 | 853362 | 12423 |
26186 | 26186 | 2021-06-21 | Texas | 48 | 2980325 | 52300 |
26187 | 26187 | 2021-06-21 | Utah | 49 | 411840 | 2330 |
26188 | 26188 | 2021-06-21 | Vermont | 50 | 24368 | 256 |
26189 | 26189 | 2021-06-21 | Virgin Islands | 78 | 3768 | 30 |
26190 | 26190 | 2021-06-21 | Virginia | 51 | 678765 | 11360 |
26191 | 26191 | 2021-06-21 | Washington | 53 | 449829 | 5881 |
26192 | 26192 | 2021-06-21 | West Virginia | 54 | 163382 | 2863 |
26193 | 26193 | 2021-06-21 | Wisconsin | 55 | 677030 | 8064 |
26194 | 26194 | 2021-06-21 | Wyoming | 56 | 61630 | 734 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );