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-27 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 |
---|---|---|---|---|---|---|
1336 | 1336 | 2020-03-27 | Alabama | 1 | 639 | 4 |
1337 | 1337 | 2020-03-27 | Alaska | 2 | 85 | 1 |
1338 | 1338 | 2020-03-27 | Arizona | 4 | 665 | 15 |
1339 | 1339 | 2020-03-27 | Arkansas | 5 | 385 | 3 |
1340 | 1340 | 2020-03-27 | California | 6 | 4915 | 104 |
1341 | 1341 | 2020-03-27 | Colorado | 8 | 1735 | 31 |
1342 | 1342 | 2020-03-27 | Connecticut | 9 | 1291 | 27 |
1343 | 1343 | 2020-03-27 | Delaware | 10 | 165 | 2 |
1344 | 1344 | 2020-03-27 | District of Columbia | 11 | 267 | 3 |
1345 | 1345 | 2020-03-27 | Florida | 12 | 3198 | 46 |
1346 | 1346 | 2020-03-27 | Georgia | 13 | 2198 | 64 |
1347 | 1347 | 2020-03-27 | Guam | 66 | 53 | 1 |
1348 | 1348 | 2020-03-27 | Hawaii | 15 | 120 | 0 |
1349 | 1349 | 2020-03-27 | Idaho | 16 | 232 | 4 |
1350 | 1350 | 2020-03-27 | Illinois | 17 | 3029 | 37 |
1351 | 1351 | 2020-03-27 | Indiana | 18 | 992 | 32 |
1352 | 1352 | 2020-03-27 | Iowa | 19 | 236 | 3 |
1353 | 1353 | 2020-03-27 | Kansas | 20 | 213 | 4 |
1354 | 1354 | 2020-03-27 | Kentucky | 21 | 302 | 8 |
1355 | 1355 | 2020-03-27 | Louisiana | 22 | 2746 | 119 |
1356 | 1356 | 2020-03-27 | Maine | 23 | 168 | 1 |
1357 | 1357 | 2020-03-27 | Maryland | 24 | 790 | 5 |
1358 | 1358 | 2020-03-27 | Massachusetts | 25 | 3240 | 35 |
1359 | 1359 | 2020-03-27 | Michigan | 26 | 3655 | 93 |
1360 | 1360 | 2020-03-27 | Minnesota | 27 | 398 | 4 |
1361 | 1361 | 2020-03-27 | Mississippi | 28 | 579 | 8 |
1362 | 1362 | 2020-03-27 | Missouri | 29 | 670 | 9 |
1363 | 1363 | 2020-03-27 | Montana | 30 | 121 | 1 |
1364 | 1364 | 2020-03-27 | Nebraska | 31 | 102 | 2 |
1365 | 1365 | 2020-03-27 | Nevada | 32 | 621 | 10 |
1366 | 1366 | 2020-03-27 | New Hampshire | 33 | 187 | 2 |
1367 | 1367 | 2020-03-27 | New Jersey | 34 | 8825 | 108 |
1368 | 1368 | 2020-03-27 | New Mexico | 35 | 191 | 1 |
1369 | 1369 | 2020-03-27 | New York | 36 | 44746 | 645 |
1370 | 1370 | 2020-03-27 | North Carolina | 37 | 784 | 3 |
1371 | 1371 | 2020-03-27 | North Dakota | 38 | 68 | 1 |
1372 | 1372 | 2020-03-27 | Ohio | 39 | 1144 | 22 |
1373 | 1373 | 2020-03-27 | Oklahoma | 40 | 322 | 8 |
1374 | 1374 | 2020-03-27 | Oregon | 41 | 415 | 12 |
1375 | 1375 | 2020-03-27 | Pennsylvania | 42 | 2217 | 23 |
1376 | 1376 | 2020-03-27 | Puerto Rico | 72 | 79 | 3 |
1377 | 1377 | 2020-03-27 | Rhode Island | 44 | 203 | 0 |
1378 | 1378 | 2020-03-27 | South Carolina | 45 | 542 | 13 |
1379 | 1379 | 2020-03-27 | South Dakota | 46 | 58 | 1 |
1380 | 1380 | 2020-03-27 | Tennessee | 47 | 1180 | 6 |
1381 | 1381 | 2020-03-27 | Texas | 48 | 1971 | 25 |
1382 | 1382 | 2020-03-27 | Utah | 49 | 480 | 2 |
1383 | 1383 | 2020-03-27 | Vermont | 50 | 184 | 10 |
1384 | 1384 | 2020-03-27 | Virgin Islands | 78 | 19 | 0 |
1385 | 1385 | 2020-03-27 | Virginia | 51 | 605 | 14 |
1386 | 1386 | 2020-03-27 | Washington | 53 | 3770 | 179 |
1387 | 1387 | 2020-03-27 | West Virginia | 54 | 96 | 0 |
1388 | 1388 | 2020-03-27 | Wisconsin | 55 | 930 | 16 |
1389 | 1389 | 2020-03-27 | Wyoming | 56 | 74 | 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 );