us-states

Table actions
Big Local News snapshots this data daily from https://github.com/nytimes/covid-19-data. This is time series data for U.S. confirmed cases and deaths down to the county level. There are three CSV files released once a day: national-level data, state-level data and county-level data. Each file contains date, county/state name, FIPS code, number of confirmed cases, number of deaths going back to January 21. All data is gathered by New York Times reporters from state and local health departments or official government announcements. The data is updated once a day in the morning, usually around 8 a.m. EDT, with a full day’s worth of data from the day before. Please cite the New York Times as described in the README and check terms of use.

Data source: Big Local News · About: big-local-datasette

55 rows where "date" is on date 2020-03-29

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date state fips cases deaths
1445 1445 2020-03-29 Alabama 1 830 5
1446 1446 2020-03-29 Alaska 2 114 2
1447 1447 2020-03-29 Arizona 4 930 18
1448 1448 2020-03-29 Arkansas 5 449 6
1449 1449 2020-03-29 California 6 6321 132
1450 1450 2020-03-29 Colorado 8 2315 47
1451 1451 2020-03-29 Connecticut 9 1993 34
1452 1452 2020-03-29 Delaware 10 232 6
1453 1453 2020-03-29 District of Columbia 11 342 5
1454 1454 2020-03-29 Florida 12 4943 60
1455 1455 2020-03-29 Georgia 13 2683 83
1456 1456 2020-03-29 Guam 66 58 1
1457 1457 2020-03-29 Hawaii 15 175 0
1458 1458 2020-03-29 Idaho 16 310 6
1459 1459 2020-03-29 Illinois 17 4615 71
1460 1460 2020-03-29 Indiana 18 1522 40
1461 1461 2020-03-29 Iowa 19 336 4
1462 1462 2020-03-29 Kansas 20 333 7
1463 1463 2020-03-29 Kentucky 21 439 9
1464 1464 2020-03-29 Louisiana 22 3539 153
1465 1465 2020-03-29 Maine 23 253 3
1466 1466 2020-03-29 Maryland 24 1244 11
1467 1467 2020-03-29 Massachusetts 25 4955 48
1468 1468 2020-03-29 Michigan 26 5486 132
1469 1469 2020-03-29 Minnesota 27 504 9
1470 1470 2020-03-29 Mississippi 28 759 14
1471 1471 2020-03-29 Missouri 29 902 12
1472 1472 2020-03-29 Montana 30 161 1
1473 1473 2020-03-29 Nebraska 31 138 2
1474 1474 2020-03-29 Nevada 32 920 15
1475 1475 2020-03-29 New Hampshire 33 258 3
1476 1476 2020-03-29 New Jersey 34 13386 161
1477 1477 2020-03-29 New Mexico 35 237 2
1478 1478 2020-03-29 New York 36 59783 1180
1479 1479 2020-03-29 North Carolina 37 1166 6
1480 1480 2020-03-29 North Dakota 38 97 1
1481 1481 2020-03-29 Northern Mariana Islands 69 2 0
1482 1482 2020-03-29 Ohio 39 1665 30
1483 1483 2020-03-29 Oklahoma 40 429 16
1484 1484 2020-03-29 Oregon 41 549 13
1485 1485 2020-03-29 Pennsylvania 42 3441 40
1486 1486 2020-03-29 Puerto Rico 72 127 5
1487 1487 2020-03-29 Rhode Island 44 294 3
1488 1488 2020-03-29 South Carolina 45 775 16
1489 1489 2020-03-29 South Dakota 46 90 1
1490 1490 2020-03-29 Tennessee 47 1569 7
1491 1491 2020-03-29 Texas 48 2722 35
1492 1492 2020-03-29 Utah 49 719 2
1493 1493 2020-03-29 Vermont 50 235 12
1494 1494 2020-03-29 Virgin Islands 78 23 0
1495 1495 2020-03-29 Virginia 51 889 22
1496 1496 2020-03-29 Washington 53 4897 209
1497 1497 2020-03-29 West Virginia 54 124 1
1498 1498 2020-03-29 Wisconsin 55 1120 17
1499 1499 2020-03-29 Wyoming 56 88 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us-states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);