us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-03-28
This data as json, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid ▼ | date | state | fips | cases | deaths |
---|---|---|---|---|---|---|
1390 | 1390 | 2020-03-28 | Alabama | 1 | 720 | 4 |
1391 | 1391 | 2020-03-28 | Alaska | 2 | 102 | 1 |
1392 | 1392 | 2020-03-28 | Arizona | 4 | 773 | 15 |
1393 | 1393 | 2020-03-28 | Arkansas | 5 | 409 | 5 |
1394 | 1394 | 2020-03-28 | California | 6 | 5566 | 122 |
1395 | 1395 | 2020-03-28 | Colorado | 8 | 2061 | 44 |
1396 | 1396 | 2020-03-28 | Connecticut | 9 | 1524 | 33 |
1397 | 1397 | 2020-03-28 | Delaware | 10 | 214 | 5 |
1398 | 1398 | 2020-03-28 | District of Columbia | 11 | 304 | 4 |
1399 | 1399 | 2020-03-28 | Florida | 12 | 4038 | 56 |
1400 | 1400 | 2020-03-28 | Georgia | 13 | 2447 | 79 |
1401 | 1401 | 2020-03-28 | Guam | 66 | 57 | 1 |
1402 | 1402 | 2020-03-28 | Hawaii | 15 | 151 | 0 |
1403 | 1403 | 2020-03-28 | Idaho | 16 | 262 | 5 |
1404 | 1404 | 2020-03-28 | Illinois | 17 | 3547 | 50 |
1405 | 1405 | 2020-03-28 | Indiana | 18 | 1239 | 38 |
1406 | 1406 | 2020-03-28 | Iowa | 19 | 298 | 3 |
1407 | 1407 | 2020-03-28 | Kansas | 20 | 272 | 6 |
1408 | 1408 | 2020-03-28 | Kentucky | 21 | 394 | 9 |
1409 | 1409 | 2020-03-28 | Louisiana | 22 | 3315 | 137 |
1410 | 1410 | 2020-03-28 | Maine | 23 | 211 | 1 |
1411 | 1411 | 2020-03-28 | Maryland | 24 | 1066 | 10 |
1412 | 1412 | 2020-03-28 | Massachusetts | 25 | 4257 | 44 |
1413 | 1413 | 2020-03-28 | Michigan | 26 | 4634 | 112 |
1414 | 1414 | 2020-03-28 | Minnesota | 27 | 442 | 5 |
1415 | 1415 | 2020-03-28 | Mississippi | 28 | 669 | 13 |
1416 | 1416 | 2020-03-28 | Missouri | 29 | 837 | 11 |
1417 | 1417 | 2020-03-28 | Montana | 30 | 147 | 1 |
1418 | 1418 | 2020-03-28 | Nebraska | 31 | 122 | 2 |
1419 | 1419 | 2020-03-28 | Nevada | 32 | 738 | 14 |
1420 | 1420 | 2020-03-28 | New Hampshire | 33 | 214 | 2 |
1421 | 1421 | 2020-03-28 | New Jersey | 34 | 11124 | 140 |
1422 | 1422 | 2020-03-28 | New Mexico | 35 | 210 | 2 |
1423 | 1423 | 2020-03-28 | New York | 36 | 53517 | 935 |
1424 | 1424 | 2020-03-28 | North Carolina | 37 | 972 | 4 |
1425 | 1425 | 2020-03-28 | North Dakota | 38 | 93 | 1 |
1426 | 1426 | 2020-03-28 | Northern Mariana Islands | 69 | 2 | 0 |
1427 | 1427 | 2020-03-28 | Ohio | 39 | 1406 | 25 |
1428 | 1428 | 2020-03-28 | Oklahoma | 40 | 377 | 15 |
1429 | 1429 | 2020-03-28 | Oregon | 41 | 480 | 13 |
1430 | 1430 | 2020-03-28 | Pennsylvania | 42 | 2815 | 35 |
1431 | 1431 | 2020-03-28 | Puerto Rico | 72 | 100 | 3 |
1432 | 1432 | 2020-03-28 | Rhode Island | 44 | 239 | 2 |
1433 | 1433 | 2020-03-28 | South Carolina | 45 | 661 | 15 |
1434 | 1434 | 2020-03-28 | South Dakota | 46 | 68 | 1 |
1435 | 1435 | 2020-03-28 | Tennessee | 47 | 1363 | 6 |
1436 | 1436 | 2020-03-28 | Texas | 48 | 2381 | 30 |
1437 | 1437 | 2020-03-28 | Utah | 49 | 608 | 2 |
1438 | 1438 | 2020-03-28 | Vermont | 50 | 211 | 12 |
1439 | 1439 | 2020-03-28 | Virgin Islands | 78 | 19 | 0 |
1440 | 1440 | 2020-03-28 | Virginia | 51 | 739 | 17 |
1441 | 1441 | 2020-03-28 | Washington | 53 | 4311 | 193 |
1442 | 1442 | 2020-03-28 | West Virginia | 54 | 113 | 0 |
1443 | 1443 | 2020-03-28 | Wisconsin | 55 | 1042 | 17 |
1444 | 1444 | 2020-03-28 | Wyoming | 56 | 85 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );