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

View and edit SQL

Suggested facets: date (date)

Link rowid ▼ date state fips cases deaths
1775 2020-04-04 Alabama 1 1632 44
1776 2020-04-04 Alaska 2 169 3
1777 2020-04-04 Arizona 4 2019 53
1778 2020-04-04 Arkansas 5 743 14
1779 2020-04-04 California 6 13796 323
1780 2020-04-04 Colorado 8 4574 126
1781 2020-04-04 Connecticut 9 5276 165
1782 2020-04-04 Delaware 10 593 14
1783 2020-04-04 District of Columbia 11 902 21
1784 2020-04-04 Florida 12 11537 194
1785 2020-04-04 Georgia 13 6383 208
1786 2020-04-04 Guam 66 223 4
1787 2020-04-04 Hawaii 15 349 3
1788 2020-04-04 Idaho 16 1076 10
1789 2020-04-04 Illinois 17 10357 248
1790 2020-04-04 Indiana 18 3975 136
1791 2020-04-04 Iowa 19 786 11
1792 2020-04-04 Kansas 20 702 21
1793 2020-04-04 Kentucky 21 909 40
1794 2020-04-04 Louisiana 22 12500 412
1795 2020-04-04 Maine 23 456 10
1796 2020-04-04 Maryland 24 3125 54
1797 2020-04-04 Massachusetts 25 11736 216
1798 2020-04-04 Michigan 26 14225 541
1799 2020-04-04 Minnesota 27 865 24
1800 2020-04-04 Mississippi 28 1455 35
1801 2020-04-04 Missouri 29 2291 44
1802 2020-04-04 Montana 30 281 6
1803 2020-04-04 Nebraska 31 339 8
1804 2020-04-04 Nevada 32 1758 46
1805 2020-04-04 New Hampshire 33 621 9
1806 2020-04-04 New Jersey 34 34124 847
1807 2020-04-04 New Mexico 35 544 11
1808 2020-04-04 New York 36 115963 4535
1809 2020-04-04 North Carolina 37 2402 30
1810 2020-04-04 North Dakota 38 186 3
1811 2020-04-04 Northern Mariana Islands 69 8 1
1812 2020-04-04 Ohio 39 3739 102
1813 2020-04-04 Oklahoma 40 1159 42
1814 2020-04-04 Oregon 41 1000 26
1815 2020-04-04 Pennsylvania 42 10110 140
1816 2020-04-04 Puerto Rico 72 452 18
1817 2020-04-04 Rhode Island 44 806 17
1818 2020-04-04 South Carolina 45 1917 40
1819 2020-04-04 South Dakota 46 212 2
1820 2020-04-04 Tennessee 47 3265 47
1821 2020-04-04 Texas 48 6566 124
1822 2020-04-04 Utah 49 1426 8
1823 2020-04-04 Vermont 50 461 20
1824 2020-04-04 Virgin Islands 78 42 0
1825 2020-04-04 Virginia 51 2408 52
1826 2020-04-04 Washington 53 7499 318
1827 2020-04-04 West Virginia 54 282 2
1828 2020-04-04 Wisconsin 55 2112 60
1829 2020-04-04 Wyoming 56 189 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
);