us-counties

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

1,076,224 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ date county state fips cases deaths
101 101 2020-02-08 San Francisco California 6075 2 0
102 102 2020-02-08 Santa Clara California 6085 2 0
103 103 2020-02-08 Cook Illinois 17031 2 0
104 104 2020-02-08 Suffolk Massachusetts 25025 1 0
105 105 2020-02-08 Snohomish Washington 53061 1 0
106 106 2020-02-08 Dane Wisconsin 55025 1 0
107 107 2020-02-09 Maricopa Arizona 4013 1 0
108 108 2020-02-09 Los Angeles California 6037 1 0
109 109 2020-02-09 Orange California 6059 1 0
110 110 2020-02-09 San Francisco California 6075 2 0
111 111 2020-02-09 Santa Clara California 6085 2 0
112 112 2020-02-09 Cook Illinois 17031 2 0
113 113 2020-02-09 Suffolk Massachusetts 25025 1 0
114 114 2020-02-09 Snohomish Washington 53061 1 0
115 115 2020-02-09 Dane Wisconsin 55025 1 0
116 116 2020-02-10 Maricopa Arizona 4013 1 0
117 117 2020-02-10 Los Angeles California 6037 1 0
118 118 2020-02-10 Orange California 6059 1 0
119 119 2020-02-10 San Diego California 6073 1 0
120 120 2020-02-10 San Francisco California 6075 2 0
121 121 2020-02-10 Santa Clara California 6085 2 0
122 122 2020-02-10 Cook Illinois 17031 2 0
123 123 2020-02-10 Suffolk Massachusetts 25025 1 0
124 124 2020-02-10 Snohomish Washington 53061 1 0
125 125 2020-02-10 Dane Wisconsin 55025 1 0
126 126 2020-02-11 Maricopa Arizona 4013 1 0
127 127 2020-02-11 Los Angeles California 6037 1 0
128 128 2020-02-11 Orange California 6059 1 0
129 129 2020-02-11 San Diego California 6073 1 0
130 130 2020-02-11 San Francisco California 6075 2 0
131 131 2020-02-11 Santa Clara California 6085 2 0
132 132 2020-02-11 Cook Illinois 17031 2 0
133 133 2020-02-11 Suffolk Massachusetts 25025 1 0
134 134 2020-02-11 Snohomish Washington 53061 1 0
135 135 2020-02-11 Dane Wisconsin 55025 1 0
136 136 2020-02-12 Maricopa Arizona 4013 1 0
137 137 2020-02-12 Los Angeles California 6037 1 0
138 138 2020-02-12 Orange California 6059 1 0
139 139 2020-02-12 San Diego California 6073 1 0
140 140 2020-02-12 San Francisco California 6075 2 0
141 141 2020-02-12 Santa Clara California 6085 2 0
142 142 2020-02-12 Cook Illinois 17031 2 0
143 143 2020-02-12 Suffolk Massachusetts 25025 1 0
144 144 2020-02-12 Bexar Texas 48029 1 0
145 145 2020-02-12 Snohomish Washington 53061 1 0
146 146 2020-02-12 Dane Wisconsin 55025 1 0
147 147 2020-02-13 Maricopa Arizona 4013 1 0
148 148 2020-02-13 Los Angeles California 6037 1 0
149 149 2020-02-13 Orange California 6059 1 0
150 150 2020-02-13 San Diego California 6073 1 0
151 151 2020-02-13 San Francisco California 6075 2 0
152 152 2020-02-13 Santa Clara California 6085 2 0
153 153 2020-02-13 Cook Illinois 17031 2 0
154 154 2020-02-13 Suffolk Massachusetts 25025 1 0
155 155 2020-02-13 Bexar Texas 48029 2 0
156 156 2020-02-13 Snohomish Washington 53061 1 0
157 157 2020-02-13 Dane Wisconsin 55025 1 0
158 158 2020-02-14 Maricopa Arizona 4013 1 0
159 159 2020-02-14 Los Angeles California 6037 1 0
160 160 2020-02-14 Orange California 6059 1 0
161 161 2020-02-14 San Diego California 6073 1 0
162 162 2020-02-14 San Francisco California 6075 2 0
163 163 2020-02-14 Santa Clara California 6085 2 0
164 164 2020-02-14 Cook Illinois 17031 2 0
165 165 2020-02-14 Suffolk Massachusetts 25025 1 0
166 166 2020-02-14 Bexar Texas 48029 2 0
167 167 2020-02-14 Snohomish Washington 53061 1 0
168 168 2020-02-14 Dane Wisconsin 55025 1 0
169 169 2020-02-15 Maricopa Arizona 4013 1 0
170 170 2020-02-15 Los Angeles California 6037 1 0
171 171 2020-02-15 Orange California 6059 1 0
172 172 2020-02-15 San Diego California 6073 1 0
173 173 2020-02-15 San Francisco California 6075 2 0
174 174 2020-02-15 Santa Clara California 6085 2 0
175 175 2020-02-15 Cook Illinois 17031 2 0
176 176 2020-02-15 Suffolk Massachusetts 25025 1 0
177 177 2020-02-15 Bexar Texas 48029 2 0
178 178 2020-02-15 Snohomish Washington 53061 1 0
179 179 2020-02-15 Dane Wisconsin 55025 1 0
180 180 2020-02-16 Maricopa Arizona 4013 1 0
181 181 2020-02-16 Los Angeles California 6037 1 0
182 182 2020-02-16 Orange California 6059 1 0
183 183 2020-02-16 San Diego California 6073 1 0
184 184 2020-02-16 San Francisco California 6075 2 0
185 185 2020-02-16 Santa Clara California 6085 2 0
186 186 2020-02-16 Cook Illinois 17031 2 0
187 187 2020-02-16 Suffolk Massachusetts 25025 1 0
188 188 2020-02-16 Bexar Texas 48029 2 0
189 189 2020-02-16 Snohomish Washington 53061 1 0
190 190 2020-02-16 Dane Wisconsin 55025 1 0
191 191 2020-02-17 Maricopa Arizona 4013 1 0
192 192 2020-02-17 Los Angeles California 6037 1 0
193 193 2020-02-17 Orange California 6059 1 0
194 194 2020-02-17 San Diego California 6073 1 0
195 195 2020-02-17 San Francisco California 6075 2 0
196 196 2020-02-17 Santa Clara California 6085 2 0
197 197 2020-02-17 Cook Illinois 17031 2 0
198 198 2020-02-17 Suffolk Massachusetts 25025 1 0
199 199 2020-02-17 Douglas Nebraska 31055 10 0
200 200 2020-02-17 Bexar Texas 48029 2 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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