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

View and edit SQL

Suggested facets: date (date)

Link rowid ▼ date state fips cases deaths
2105 2020-04-10 Alabama 1 3008 80
2106 2020-04-10 Alaska 2 244 5
2107 2020-04-10 Arizona 4 3112 97
2108 2020-04-10 Arkansas 5 1202 24
2109 2020-04-10 California 6 21366 594
2110 2020-04-10 Colorado 8 6510 253
2111 2020-04-10 Connecticut 9 10538 448
2112 2020-04-10 Delaware 10 1326 32
2113 2020-04-10 District of Columbia 11 1660 38
2114 2020-04-10 Florida 12 17960 418
2115 2020-04-10 Georgia 13 11859 425
2116 2020-04-10 Guam 66 577 4
2117 2020-04-10 Hawaii 15 463 8
2118 2020-04-10 Idaho 16 1425 25
2119 2020-04-10 Illinois 17 17887 607
2120 2020-04-10 Indiana 18 6960 353
2121 2020-04-10 Iowa 19 1388 31
2122 2020-04-10 Kansas 20 1180 50
2123 2020-04-10 Kentucky 21 1702 90
2124 2020-04-10 Louisiana 22 19253 755
2125 2020-04-10 Maine 23 586 17
2126 2020-04-10 Maryland 24 6968 172
2127 2020-04-10 Massachusetts 25 20974 599
2128 2020-04-10 Michigan 26 22646 1280
2129 2020-04-10 Minnesota 27 1335 57
2130 2020-04-10 Mississippi 28 2469 82
2131 2020-04-10 Missouri 29 3799 105
2132 2020-04-10 Montana 30 365 6
2133 2020-04-10 Nebraska 31 678 18
2134 2020-04-10 Nevada 32 2606 86
2135 2020-04-10 New Hampshire 33 885 22
2136 2020-04-10 New Jersey 34 54588 1932
2137 2020-04-10 New Mexico 35 1090 19
2138 2020-04-10 New York 36 172830 10162
2139 2020-04-10 North Carolina 37 3906 78
2140 2020-04-10 North Dakota 38 278 7
2141 2020-04-10 Northern Mariana Islands 69 11 2
2142 2020-04-10 Ohio 39 5879 231
2143 2020-04-10 Oklahoma 40 1794 88
2144 2020-04-10 Oregon 41 1371 48
2145 2020-04-10 Pennsylvania 42 20128 435
2146 2020-04-10 Puerto Rico 72 725 39
2147 2020-04-10 Rhode Island 44 2015 49
2148 2020-04-10 South Carolina 45 3065 72
2149 2020-04-10 South Dakota 46 536 6
2150 2020-04-10 Tennessee 47 4793 104
2151 2020-04-10 Texas 48 12291 249
2152 2020-04-10 Utah 49 2103 17
2153 2020-04-10 Vermont 50 679 24
2154 2020-04-10 Virgin Islands 78 51 1
2155 2020-04-10 Virginia 51 4509 121
2156 2020-04-10 Washington 53 9888 483
2157 2020-04-10 West Virginia 54 537 5
2158 2020-04-10 Wisconsin 55 3068 131
2159 2020-04-10 Wyoming 56 320 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
);