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-04-03

View and edit SQL

Suggested facets: date (date)

Link rowid ▼ date state fips cases deaths
1720 2020-04-03 Alabama 1 1535 38
1721 2020-04-03 Alaska 2 156 2
1722 2020-04-03 Arizona 4 1769 41
1723 2020-04-03 Arkansas 5 738 12
1724 2020-04-03 California 6 12569 282
1725 2020-04-03 Colorado 8 4182 110
1726 2020-04-03 Connecticut 9 4915 132
1727 2020-04-03 Delaware 10 450 14
1728 2020-04-03 District of Columbia 11 757 15
1729 2020-04-03 Florida 12 10260 169
1730 2020-04-03 Georgia 13 5967 198
1731 2020-04-03 Guam 66 154 4
1732 2020-04-03 Hawaii 15 317 3
1733 2020-04-03 Idaho 16 1012 10
1734 2020-04-03 Illinois 17 8904 212
1735 2020-04-03 Indiana 18 3455 118
1736 2020-04-03 Iowa 19 699 11
1737 2020-04-03 Kansas 20 625 19
1738 2020-04-03 Kentucky 21 762 34
1739 2020-04-03 Louisiana 22 10299 370
1740 2020-04-03 Maine 23 432 9
1741 2020-04-03 Maryland 24 2758 42
1742 2020-04-03 Massachusetts 25 10402 192
1743 2020-04-03 Michigan 26 12669 478
1744 2020-04-03 Minnesota 27 789 22
1745 2020-04-03 Mississippi 28 1358 29
1746 2020-04-03 Missouri 29 2113 36
1747 2020-04-03 Montana 30 262 5
1748 2020-04-03 Nebraska 31 297 6
1749 2020-04-03 Nevada 32 1549 43
1750 2020-04-03 New Hampshire 33 540 7
1751 2020-04-03 New Jersey 34 29895 647
1752 2020-04-03 New Mexico 35 495 10
1753 2020-04-03 New York 36 103689 3716
1754 2020-04-03 North Carolina 37 2093 23
1755 2020-04-03 North Dakota 38 173 3
1756 2020-04-03 Northern Mariana Islands 69 8 1
1757 2020-04-03 Ohio 39 3312 91
1758 2020-04-03 Oklahoma 40 989 38
1759 2020-04-03 Oregon 41 899 22
1760 2020-04-03 Pennsylvania 42 8420 102
1761 2020-04-03 Puerto Rico 72 378 15
1762 2020-04-03 Rhode Island 44 711 14
1763 2020-04-03 South Carolina 45 1700 34
1764 2020-04-03 South Dakota 46 187 2
1765 2020-04-03 Tennessee 47 3032 38
1766 2020-04-03 Texas 48 5773 98
1767 2020-04-03 Utah 49 1248 7
1768 2020-04-03 Vermont 50 389 17
1769 2020-04-03 Virgin Islands 78 38 0
1770 2020-04-03 Virginia 51 2011 46
1771 2020-04-03 Washington 53 6967 293
1772 2020-04-03 West Virginia 54 242 2
1773 2020-04-03 Wisconsin 55 1916 50
1774 2020-04-03 Wyoming 56 167 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
);