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 2020-10-28 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 |
---|---|---|---|---|---|---|
13160 | 13160 | 2020-10-28 | Alabama | 1 | 187706 | 2911 |
13161 | 13161 | 2020-10-28 | Alaska | 2 | 15053 | 67 |
13162 | 13162 | 2020-10-28 | Arizona | 4 | 241259 | 5906 |
13163 | 13163 | 2020-10-28 | Arkansas | 5 | 108640 | 1875 |
13164 | 13164 | 2020-10-28 | California | 6 | 922685 | 17541 |
13165 | 13165 | 2020-10-28 | Colorado | 8 | 100614 | 2277 |
13166 | 13166 | 2020-10-28 | Connecticut | 9 | 69127 | 4604 |
13167 | 13167 | 2020-10-28 | Delaware | 10 | 24392 | 688 |
13168 | 13168 | 2020-10-28 | District of Columbia | 11 | 16973 | 644 |
13169 | 13169 | 2020-10-28 | Florida | 12 | 790418 | 16570 |
13170 | 13170 | 2020-10-28 | Georgia | 13 | 367126 | 7692 |
13171 | 13171 | 2020-10-28 | Guam | 66 | 5435 | 77 |
13172 | 13172 | 2020-10-28 | Hawaii | 15 | 14975 | 212 |
13173 | 13173 | 2020-10-28 | Idaho | 16 | 62197 | 600 |
13174 | 13174 | 2020-10-28 | Illinois | 17 | 395204 | 9912 |
13175 | 13175 | 2020-10-28 | Indiana | 18 | 171566 | 4227 |
13176 | 13176 | 2020-10-28 | Iowa | 19 | 120911 | 1691 |
13177 | 13177 | 2020-10-28 | Kansas | 20 | 83485 | 1007 |
13178 | 13178 | 2020-10-28 | Kentucky | 21 | 103685 | 1509 |
13179 | 13179 | 2020-10-28 | Louisiana | 22 | 185822 | 5890 |
13180 | 13180 | 2020-10-28 | Maine | 23 | 6387 | 146 |
13181 | 13181 | 2020-10-28 | Maryland | 24 | 142918 | 4115 |
13182 | 13182 | 2020-10-28 | Massachusetts | 25 | 154218 | 9924 |
13183 | 13183 | 2020-10-28 | Michigan | 26 | 185818 | 7606 |
13184 | 13184 | 2020-10-28 | Minnesota | 27 | 139497 | 2440 |
13185 | 13185 | 2020-10-28 | Mississippi | 28 | 117617 | 3302 |
13186 | 13186 | 2020-10-28 | Missouri | 29 | 181877 | 2940 |
13187 | 13187 | 2020-10-28 | Montana | 30 | 30051 | 326 |
13188 | 13188 | 2020-10-28 | Nebraska | 31 | 66682 | 634 |
13189 | 13189 | 2020-10-28 | Nevada | 32 | 97824 | 1767 |
13190 | 13190 | 2020-10-28 | New Hampshire | 33 | 10641 | 478 |
13191 | 13191 | 2020-10-28 | New Jersey | 34 | 234790 | 16324 |
13192 | 13192 | 2020-10-28 | New Mexico | 35 | 43826 | 991 |
13193 | 13193 | 2020-10-28 | New York | 36 | 505416 | 33107 |
13194 | 13194 | 2020-10-28 | North Carolina | 37 | 266566 | 4275 |
13195 | 13195 | 2020-10-28 | North Dakota | 38 | 39912 | 493 |
13196 | 13196 | 2020-10-28 | Northern Mariana Islands | 69 | 92 | 2 |
13197 | 13197 | 2020-10-28 | Ohio | 39 | 205347 | 5256 |
13198 | 13198 | 2020-10-28 | Oklahoma | 40 | 119152 | 1286 |
13199 | 13199 | 2020-10-28 | Oregon | 41 | 43228 | 673 |
13200 | 13200 | 2020-10-28 | Pennsylvania | 42 | 205852 | 8789 |
13201 | 13201 | 2020-10-28 | Puerto Rico | 72 | 63587 | 813 |
13202 | 13202 | 2020-10-28 | Rhode Island | 44 | 31944 | 1192 |
13203 | 13203 | 2020-10-28 | South Carolina | 45 | 173491 | 3876 |
13204 | 13204 | 2020-10-28 | South Dakota | 46 | 42000 | 384 |
13205 | 13205 | 2020-10-28 | Tennessee | 47 | 250269 | 3209 |
13206 | 13206 | 2020-10-28 | Texas | 48 | 932245 | 18251 |
13207 | 13207 | 2020-10-28 | Utah | 49 | 108863 | 588 |
13208 | 13208 | 2020-10-28 | Vermont | 50 | 2120 | 58 |
13209 | 13209 | 2020-10-28 | Virgin Islands | 78 | 1353 | 21 |
13210 | 13210 | 2020-10-28 | Virginia | 51 | 176754 | 3616 |
13211 | 13211 | 2020-10-28 | Washington | 53 | 109865 | 2454 |
13212 | 13212 | 2020-10-28 | West Virginia | 54 | 23064 | 436 |
13213 | 13213 | 2020-10-28 | Wisconsin | 55 | 221578 | 1953 |
13214 | 13214 | 2020-10-28 | Wyoming | 56 | 12146 | 77 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );