ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,566 rows where county = "Berkeley" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
135468 | 135468 | 2020-05-11 | Berkeley | South Carolina | 45015 | 195 | 15 |
136082 | 136082 | 2020-05-11 | Berkeley | West Virginia | 54003 | 191 | 5 |
138458 | 138458 | 2020-05-12 | Berkeley | South Carolina | 45015 | 197 | 15 |
139073 | 139073 | 2020-05-12 | Berkeley | West Virginia | 54003 | 191 | 6 |
141454 | 141454 | 2020-05-13 | Berkeley | South Carolina | 45015 | 198 | 15 |
142069 | 142069 | 2020-05-13 | Berkeley | West Virginia | 54003 | 196 | 6 |
144450 | 144450 | 2020-05-14 | Berkeley | South Carolina | 45015 | 199 | 15 |
145066 | 145066 | 2020-05-14 | Berkeley | West Virginia | 54003 | 200 | 6 |
147451 | 147451 | 2020-05-15 | Berkeley | South Carolina | 45015 | 201 | 15 |
148069 | 148069 | 2020-05-15 | Berkeley | West Virginia | 54003 | 205 | 6 |
150459 | 150459 | 2020-05-16 | Berkeley | South Carolina | 45015 | 203 | 15 |
151078 | 151078 | 2020-05-16 | Berkeley | West Virginia | 54003 | 207 | 6 |
153470 | 153470 | 2020-05-17 | Berkeley | South Carolina | 45015 | 201 | 15 |
154089 | 154089 | 2020-05-17 | Berkeley | West Virginia | 54003 | 210 | 6 |
156487 | 156487 | 2020-05-18 | Berkeley | South Carolina | 45015 | 203 | 15 |
157106 | 157106 | 2020-05-18 | Berkeley | West Virginia | 54003 | 215 | 6 |
159508 | 159508 | 2020-05-19 | Berkeley | South Carolina | 45015 | 203 | 15 |
160130 | 160130 | 2020-05-19 | Berkeley | West Virginia | 54003 | 223 | 6 |
162535 | 162535 | 2020-05-20 | Berkeley | South Carolina | 45015 | 205 | 15 |
163158 | 163158 | 2020-05-20 | Berkeley | West Virginia | 54003 | 245 | 6 |
165564 | 165564 | 2020-05-21 | Berkeley | South Carolina | 45015 | 209 | 15 |
166187 | 166187 | 2020-05-21 | Berkeley | West Virginia | 54003 | 251 | 6 |
168600 | 168600 | 2020-05-22 | Berkeley | South Carolina | 45015 | 211 | 15 |
169223 | 169223 | 2020-05-22 | Berkeley | West Virginia | 54003 | 264 | 6 |
171639 | 171639 | 2020-05-23 | Berkeley | South Carolina | 45015 | 214 | 15 |
172264 | 172264 | 2020-05-23 | Berkeley | West Virginia | 54003 | 270 | 6 |
174681 | 174681 | 2020-05-24 | Berkeley | South Carolina | 45015 | 215 | 15 |
175307 | 175307 | 2020-05-24 | Berkeley | West Virginia | 54003 | 286 | 6 |
177725 | 177725 | 2020-05-25 | Berkeley | South Carolina | 45015 | 218 | 15 |
178352 | 178352 | 2020-05-25 | Berkeley | West Virginia | 54003 | 287 | 6 |
180768 | 180768 | 2020-05-26 | Berkeley | South Carolina | 45015 | 219 | 15 |
181396 | 181396 | 2020-05-26 | Berkeley | West Virginia | 54003 | 290 | 6 |
183818 | 183818 | 2020-05-27 | Berkeley | South Carolina | 45015 | 219 | 15 |
184447 | 184447 | 2020-05-27 | Berkeley | West Virginia | 54003 | 297 | 6 |
186875 | 186875 | 2020-05-28 | Berkeley | South Carolina | 45015 | 224 | 15 |
187504 | 187504 | 2020-05-28 | Berkeley | West Virginia | 54003 | 298 | 6 |
189937 | 189937 | 2020-05-29 | Berkeley | South Carolina | 45015 | 228 | 16 |
190568 | 190568 | 2020-05-29 | Berkeley | West Virginia | 54003 | 304 | 6 |
193002 | 193002 | 2020-05-30 | Berkeley | South Carolina | 45015 | 230 | 16 |
193634 | 193634 | 2020-05-30 | Berkeley | West Virginia | 54003 | 307 | 6 |
196071 | 196071 | 2020-05-31 | Berkeley | South Carolina | 45015 | 233 | 16 |
196704 | 196704 | 2020-05-31 | Berkeley | West Virginia | 54003 | 308 | 6 |
199144 | 199144 | 2020-06-01 | Berkeley | South Carolina | 45015 | 235 | 16 |
199777 | 199777 | 2020-06-01 | Berkeley | West Virginia | 54003 | 314 | 6 |
202219 | 202219 | 2020-06-02 | Berkeley | South Carolina | 45015 | 242 | 16 |
202853 | 202853 | 2020-06-02 | Berkeley | West Virginia | 54003 | 319 | 7 |
205296 | 205296 | 2020-06-03 | Berkeley | South Carolina | 45015 | 243 | 17 |
205932 | 205932 | 2020-06-03 | Berkeley | West Virginia | 54003 | 326 | 7 |
208377 | 208377 | 2020-06-04 | Berkeley | South Carolina | 45015 | 253 | 17 |
209014 | 209014 | 2020-06-04 | Berkeley | West Virginia | 54003 | 336 | 7 |
211459 | 211459 | 2020-06-05 | Berkeley | South Carolina | 45015 | 257 | 17 |
212099 | 212099 | 2020-06-05 | Berkeley | West Virginia | 54003 | 340 | 8 |
214545 | 214545 | 2020-06-06 | Berkeley | South Carolina | 45015 | 263 | 17 |
215186 | 215186 | 2020-06-06 | Berkeley | West Virginia | 54003 | 343 | 8 |
217635 | 217635 | 2020-06-07 | Berkeley | South Carolina | 45015 | 273 | 17 |
218276 | 218276 | 2020-06-07 | Berkeley | West Virginia | 54003 | 344 | 8 |
220727 | 220727 | 2020-06-08 | Berkeley | South Carolina | 45015 | 282 | 18 |
221368 | 221368 | 2020-06-08 | Berkeley | West Virginia | 54003 | 347 | 8 |
223822 | 223822 | 2020-06-09 | Berkeley | South Carolina | 45015 | 291 | 19 |
224464 | 224464 | 2020-06-09 | Berkeley | West Virginia | 54003 | 353 | 8 |
226922 | 226922 | 2020-06-10 | Berkeley | South Carolina | 45015 | 315 | 19 |
227564 | 227564 | 2020-06-10 | Berkeley | West Virginia | 54003 | 361 | 8 |
230026 | 230026 | 2020-06-11 | Berkeley | South Carolina | 45015 | 335 | 19 |
230668 | 230668 | 2020-06-11 | Berkeley | West Virginia | 54003 | 369 | 8 |
233131 | 233131 | 2020-06-12 | Berkeley | South Carolina | 45015 | 346 | 19 |
233773 | 233773 | 2020-06-12 | Berkeley | West Virginia | 54003 | 376 | 9 |
236236 | 236236 | 2020-06-13 | Berkeley | South Carolina | 45015 | 364 | 19 |
236880 | 236880 | 2020-06-13 | Berkeley | West Virginia | 54003 | 386 | 9 |
239344 | 239344 | 2020-06-14 | Berkeley | South Carolina | 45015 | 386 | 19 |
239988 | 239988 | 2020-06-14 | Berkeley | West Virginia | 54003 | 386 | 9 |
242453 | 242453 | 2020-06-15 | Berkeley | South Carolina | 45015 | 406 | 19 |
243099 | 243099 | 2020-06-15 | Berkeley | West Virginia | 54003 | 395 | 9 |
245565 | 245565 | 2020-06-16 | Berkeley | South Carolina | 45015 | 427 | 19 |
246212 | 246212 | 2020-06-16 | Berkeley | West Virginia | 54003 | 399 | 9 |
248678 | 248678 | 2020-06-17 | Berkeley | South Carolina | 45015 | 434 | 20 |
249324 | 249324 | 2020-06-17 | Berkeley | West Virginia | 54003 | 407 | 9 |
251793 | 251793 | 2020-06-18 | Berkeley | South Carolina | 45015 | 458 | 20 |
252439 | 252439 | 2020-06-18 | Berkeley | West Virginia | 54003 | 415 | 9 |
254908 | 254908 | 2020-06-19 | Berkeley | South Carolina | 45015 | 515 | 20 |
255558 | 255558 | 2020-06-19 | Berkeley | West Virginia | 54003 | 427 | 9 |
258034 | 258034 | 2020-06-20 | Berkeley | South Carolina | 45015 | 563 | 20 |
258685 | 258685 | 2020-06-20 | Berkeley | West Virginia | 54003 | 429 | 9 |
261161 | 261161 | 2020-06-21 | Berkeley | South Carolina | 45015 | 599 | 20 |
261812 | 261812 | 2020-06-21 | Berkeley | West Virginia | 54003 | 432 | 10 |
264289 | 264289 | 2020-06-22 | Berkeley | South Carolina | 45015 | 644 | 20 |
264941 | 264941 | 2020-06-22 | Berkeley | West Virginia | 54003 | 433 | 10 |
267417 | 267417 | 2020-06-23 | Berkeley | South Carolina | 45015 | 695 | 20 |
268070 | 268070 | 2020-06-23 | Berkeley | West Virginia | 54003 | 438 | 10 |
270551 | 270551 | 2020-06-24 | Berkeley | South Carolina | 45015 | 740 | 20 |
271204 | 271204 | 2020-06-24 | Berkeley | West Virginia | 54003 | 440 | 10 |
273690 | 273690 | 2020-06-25 | Berkeley | South Carolina | 45015 | 805 | 21 |
274344 | 274344 | 2020-06-25 | Berkeley | West Virginia | 54003 | 441 | 10 |
276837 | 276837 | 2020-06-26 | Berkeley | South Carolina | 45015 | 854 | 21 |
277492 | 277492 | 2020-06-26 | Berkeley | West Virginia | 54003 | 446 | 10 |
279985 | 279985 | 2020-06-27 | Berkeley | South Carolina | 45015 | 892 | 21 |
280640 | 280640 | 2020-06-27 | Berkeley | West Virginia | 54003 | 449 | 10 |
283131 | 283131 | 2020-06-28 | Berkeley | South Carolina | 45015 | 949 | 21 |
283786 | 283786 | 2020-06-28 | Berkeley | West Virginia | 54003 | 450 | 10 |
286276 | 286276 | 2020-06-29 | Berkeley | South Carolina | 45015 | 1007 | 21 |
286932 | 286932 | 2020-06-29 | Berkeley | West Virginia | 54003 | 454 | 10 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);