ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where "date" is on date 2020-03-26 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
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 |
---|---|---|---|---|---|---|
1282 | 1282 | 2020-03-26 | Alabama | 1 | 538 | 3 |
1283 | 1283 | 2020-03-26 | Alaska | 2 | 69 | 0 |
1284 | 1284 | 2020-03-26 | Arizona | 4 | 508 | 8 |
1285 | 1285 | 2020-03-26 | Arkansas | 5 | 350 | 3 |
1286 | 1286 | 2020-03-26 | California | 6 | 4060 | 83 |
1287 | 1287 | 2020-03-26 | Colorado | 8 | 1432 | 24 |
1288 | 1288 | 2020-03-26 | Connecticut | 9 | 1012 | 21 |
1289 | 1289 | 2020-03-26 | Delaware | 10 | 143 | 1 |
1290 | 1290 | 2020-03-26 | District of Columbia | 11 | 231 | 3 |
1291 | 1291 | 2020-03-26 | Florida | 12 | 2478 | 29 |
1292 | 1292 | 2020-03-26 | Georgia | 13 | 1641 | 56 |
1293 | 1293 | 2020-03-26 | Guam | 66 | 49 | 1 |
1294 | 1294 | 2020-03-26 | Hawaii | 15 | 106 | 0 |
1295 | 1295 | 2020-03-26 | Idaho | 16 | 189 | 3 |
1296 | 1296 | 2020-03-26 | Illinois | 17 | 2538 | 26 |
1297 | 1297 | 2020-03-26 | Indiana | 18 | 661 | 23 |
1298 | 1298 | 2020-03-26 | Iowa | 19 | 179 | 1 |
1299 | 1299 | 2020-03-26 | Kansas | 20 | 173 | 3 |
1300 | 1300 | 2020-03-26 | Kentucky | 21 | 248 | 5 |
1301 | 1301 | 2020-03-26 | Louisiana | 22 | 2305 | 83 |
1302 | 1302 | 2020-03-26 | Maine | 23 | 155 | 0 |
1303 | 1303 | 2020-03-26 | Maryland | 24 | 581 | 4 |
1304 | 1304 | 2020-03-26 | Massachusetts | 25 | 2417 | 25 |
1305 | 1305 | 2020-03-26 | Michigan | 26 | 2877 | 63 |
1306 | 1306 | 2020-03-26 | Minnesota | 27 | 346 | 2 |
1307 | 1307 | 2020-03-26 | Mississippi | 28 | 486 | 6 |
1308 | 1308 | 2020-03-26 | Missouri | 29 | 508 | 8 |
1309 | 1309 | 2020-03-26 | Montana | 30 | 90 | 0 |
1310 | 1310 | 2020-03-26 | Nebraska | 31 | 91 | 0 |
1311 | 1311 | 2020-03-26 | Nevada | 32 | 535 | 10 |
1312 | 1312 | 2020-03-26 | New Hampshire | 33 | 158 | 1 |
1313 | 1313 | 2020-03-26 | New Jersey | 34 | 6876 | 82 |
1314 | 1314 | 2020-03-26 | New Mexico | 35 | 136 | 1 |
1315 | 1315 | 2020-03-26 | New York | 36 | 39058 | 502 |
1316 | 1316 | 2020-03-26 | North Carolina | 37 | 639 | 2 |
1317 | 1317 | 2020-03-26 | North Dakota | 38 | 58 | 0 |
1318 | 1318 | 2020-03-26 | Ohio | 39 | 867 | 15 |
1319 | 1319 | 2020-03-26 | Oklahoma | 40 | 248 | 7 |
1320 | 1320 | 2020-03-26 | Oregon | 41 | 316 | 11 |
1321 | 1321 | 2020-03-26 | Pennsylvania | 42 | 1690 | 16 |
1322 | 1322 | 2020-03-26 | Puerto Rico | 72 | 64 | 2 |
1323 | 1323 | 2020-03-26 | Rhode Island | 44 | 165 | 0 |
1324 | 1324 | 2020-03-26 | South Carolina | 45 | 456 | 9 |
1325 | 1325 | 2020-03-26 | South Dakota | 46 | 46 | 1 |
1326 | 1326 | 2020-03-26 | Tennessee | 47 | 981 | 3 |
1327 | 1327 | 2020-03-26 | Texas | 48 | 1542 | 21 |
1328 | 1328 | 2020-03-26 | Utah | 49 | 402 | 1 |
1329 | 1329 | 2020-03-26 | Vermont | 50 | 158 | 9 |
1330 | 1330 | 2020-03-26 | Virgin Islands | 78 | 17 | 0 |
1331 | 1331 | 2020-03-26 | Virginia | 51 | 603 | 14 |
1332 | 1332 | 2020-03-26 | Washington | 53 | 3208 | 152 |
1333 | 1333 | 2020-03-26 | West Virginia | 54 | 76 | 0 |
1334 | 1334 | 2020-03-26 | Wisconsin | 55 | 754 | 10 |
1335 | 1335 | 2020-03-26 | Wyoming | 56 | 56 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );