ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Douglas" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386375 | 386375 | 2020-07-31 | Douglas | Georgia | 13097 | 2245 | 48 |
383157 | 383157 | 2020-07-30 | Douglas | Georgia | 13097 | 2203 | 47 |
379940 | 379940 | 2020-07-29 | Douglas | Georgia | 13097 | 2158 | 46 |
376723 | 376723 | 2020-07-28 | Douglas | Georgia | 13097 | 2117 | 46 |
373509 | 373509 | 2020-07-27 | Douglas | Georgia | 13097 | 2078 | 46 |
370297 | 370297 | 2020-07-26 | Douglas | Georgia | 13097 | 2057 | 46 |
367087 | 367087 | 2020-07-25 | Douglas | Georgia | 13097 | 2027 | 46 |
363880 | 363880 | 2020-07-24 | Douglas | Georgia | 13097 | 1970 | 45 |
360673 | 360673 | 2020-07-23 | Douglas | Georgia | 13097 | 1914 | 44 |
357468 | 357468 | 2020-07-22 | Douglas | Georgia | 13097 | 1853 | 43 |
354265 | 354265 | 2020-07-21 | Douglas | Georgia | 13097 | 1805 | 41 |
351063 | 351063 | 2020-07-20 | Douglas | Georgia | 13097 | 1750 | 41 |
347862 | 347862 | 2020-07-19 | Douglas | Georgia | 13097 | 1733 | 41 |
344662 | 344662 | 2020-07-18 | Douglas | Georgia | 13097 | 1692 | 41 |
341463 | 341463 | 2020-07-17 | Douglas | Georgia | 13097 | 1632 | 41 |
338266 | 338266 | 2020-07-16 | Douglas | Georgia | 13097 | 1576 | 40 |
335071 | 335071 | 2020-07-15 | Douglas | Georgia | 13097 | 1545 | 40 |
331878 | 331878 | 2020-07-14 | Douglas | Georgia | 13097 | 1499 | 40 |
328691 | 328691 | 2020-07-13 | Douglas | Georgia | 13097 | 1461 | 39 |
325505 | 325505 | 2020-07-12 | Douglas | Georgia | 13097 | 1409 | 39 |
322324 | 322324 | 2020-07-11 | Douglas | Georgia | 13097 | 1388 | 39 |
319145 | 319145 | 2020-07-10 | Douglas | Georgia | 13097 | 1347 | 39 |
315972 | 315972 | 2020-07-09 | Douglas | Georgia | 13097 | 1259 | 37 |
312797 | 312797 | 2020-07-08 | Douglas | Georgia | 13097 | 1230 | 37 |
309627 | 309627 | 2020-07-07 | Douglas | Georgia | 13097 | 1179 | 37 |
306459 | 306459 | 2020-07-06 | Douglas | Georgia | 13097 | 1137 | 37 |
303295 | 303295 | 2020-07-05 | Douglas | Georgia | 13097 | 1101 | 36 |
300131 | 300131 | 2020-07-04 | Douglas | Georgia | 13097 | 1079 | 36 |
296969 | 296969 | 2020-07-03 | Douglas | Georgia | 13097 | 1041 | 36 |
293813 | 293813 | 2020-07-02 | Douglas | Georgia | 13097 | 1021 | 36 |
290659 | 290659 | 2020-07-01 | Douglas | Georgia | 13097 | 971 | 36 |
287508 | 287508 | 2020-06-30 | Douglas | Georgia | 13097 | 917 | 36 |
284362 | 284362 | 2020-06-29 | Douglas | Georgia | 13097 | 879 | 36 |
281216 | 281216 | 2020-06-28 | Douglas | Georgia | 13097 | 878 | 36 |
278069 | 278069 | 2020-06-27 | Douglas | Georgia | 13097 | 864 | 36 |
274921 | 274921 | 2020-06-26 | Douglas | Georgia | 13097 | 843 | 36 |
271781 | 271781 | 2020-06-25 | Douglas | Georgia | 13097 | 821 | 35 |
268645 | 268645 | 2020-06-24 | Douglas | Georgia | 13097 | 793 | 35 |
265515 | 265515 | 2020-06-23 | Douglas | Georgia | 13097 | 778 | 35 |
262387 | 262387 | 2020-06-22 | Douglas | Georgia | 13097 | 740 | 36 |
259260 | 259260 | 2020-06-21 | Douglas | Georgia | 13097 | 724 | 35 |
256133 | 256133 | 2020-06-20 | Douglas | Georgia | 13097 | 712 | 35 |
253014 | 253014 | 2020-06-19 | Douglas | Georgia | 13097 | 708 | 34 |
249899 | 249899 | 2020-06-18 | Douglas | Georgia | 13097 | 698 | 34 |
246787 | 246787 | 2020-06-17 | Douglas | Georgia | 13097 | 682 | 33 |
243674 | 243674 | 2020-06-16 | Douglas | Georgia | 13097 | 669 | 32 |
240563 | 240563 | 2020-06-15 | Douglas | Georgia | 13097 | 660 | 28 |
237455 | 237455 | 2020-06-14 | Douglas | Georgia | 13097 | 655 | 28 |
234348 | 234348 | 2020-06-13 | Douglas | Georgia | 13097 | 651 | 28 |
231242 | 231242 | 2020-06-12 | Douglas | Georgia | 13097 | 641 | 28 |
228139 | 228139 | 2020-06-11 | Douglas | Georgia | 13097 | 634 | 27 |
225037 | 225037 | 2020-06-10 | Douglas | Georgia | 13097 | 624 | 26 |
221942 | 221942 | 2020-06-09 | Douglas | Georgia | 13097 | 612 | 27 |
218847 | 218847 | 2020-06-08 | Douglas | Georgia | 13097 | 601 | 25 |
215756 | 215756 | 2020-06-07 | Douglas | Georgia | 13097 | 592 | 25 |
212669 | 212669 | 2020-06-06 | Douglas | Georgia | 13097 | 592 | 25 |
209584 | 209584 | 2020-06-05 | Douglas | Georgia | 13097 | 583 | 25 |
206503 | 206503 | 2020-06-04 | Douglas | Georgia | 13097 | 571 | 25 |
203423 | 203423 | 2020-06-03 | Douglas | Georgia | 13097 | 556 | 25 |
200347 | 200347 | 2020-06-02 | Douglas | Georgia | 13097 | 549 | 25 |
197274 | 197274 | 2020-06-01 | Douglas | Georgia | 13097 | 546 | 25 |
194204 | 194204 | 2020-05-31 | Douglas | Georgia | 13097 | 543 | 25 |
191137 | 191137 | 2020-05-30 | Douglas | Georgia | 13097 | 539 | 25 |
188072 | 188072 | 2020-05-29 | Douglas | Georgia | 13097 | 539 | 24 |
185016 | 185016 | 2020-05-28 | Douglas | Georgia | 13097 | 528 | 24 |
181962 | 181962 | 2020-05-27 | Douglas | Georgia | 13097 | 521 | 24 |
178918 | 178918 | 2020-05-26 | Douglas | Georgia | 13097 | 517 | 23 |
175874 | 175874 | 2020-05-25 | Douglas | Georgia | 13097 | 504 | 22 |
172831 | 172831 | 2020-05-24 | Douglas | Georgia | 13097 | 490 | 22 |
169790 | 169790 | 2020-05-23 | Douglas | Georgia | 13097 | 487 | 22 |
166753 | 166753 | 2020-05-22 | Douglas | Georgia | 13097 | 478 | 22 |
163720 | 163720 | 2020-05-21 | Douglas | Georgia | 13097 | 455 | 22 |
160692 | 160692 | 2020-05-20 | Douglas | Georgia | 13097 | 452 | 19 |
157666 | 157666 | 2020-05-19 | Douglas | Georgia | 13097 | 445 | 19 |
154650 | 154650 | 2020-05-18 | Douglas | Georgia | 13097 | 439 | 18 |
151638 | 151638 | 2020-05-17 | Douglas | Georgia | 13097 | 437 | 15 |
148629 | 148629 | 2020-05-16 | Douglas | Georgia | 13097 | 438 | 15 |
145626 | 145626 | 2020-05-15 | Douglas | Georgia | 13097 | 433 | 15 |
142626 | 142626 | 2020-05-14 | Douglas | Georgia | 13097 | 429 | 14 |
139630 | 139630 | 2020-05-13 | Douglas | Georgia | 13097 | 422 | 14 |
136639 | 136639 | 2020-05-12 | Douglas | Georgia | 13097 | 417 | 12 |
133650 | 133650 | 2020-05-11 | Douglas | Georgia | 13097 | 417 | 12 |
130659 | 130659 | 2020-05-10 | Douglas | Georgia | 13097 | 414 | 11 |
127668 | 127668 | 2020-05-09 | Douglas | Georgia | 13097 | 400 | 11 |
124681 | 124681 | 2020-05-08 | Douglas | Georgia | 13097 | 398 | 11 |
121702 | 121702 | 2020-05-07 | Douglas | Georgia | 13097 | 366 | 11 |
118733 | 118733 | 2020-05-06 | Douglas | Georgia | 13097 | 363 | 11 |
115773 | 115773 | 2020-05-05 | Douglas | Georgia | 13097 | 353 | 11 |
112890 | 112890 | 2020-05-04 | Douglas | Georgia | 13097 | 343 | 11 |
110015 | 110015 | 2020-05-03 | Douglas | Georgia | 13097 | 341 | 11 |
107146 | 107146 | 2020-05-02 | Douglas | Georgia | 13097 | 335 | 11 |
104281 | 104281 | 2020-05-01 | Douglas | Georgia | 13097 | 329 | 11 |
101426 | 101426 | 2020-04-30 | Douglas | Georgia | 13097 | 319 | 11 |
98576 | 98576 | 2020-04-29 | Douglas | Georgia | 13097 | 311 | 11 |
95731 | 95731 | 2020-04-28 | Douglas | Georgia | 13097 | 300 | 11 |
92899 | 92899 | 2020-04-27 | Douglas | Georgia | 13097 | 284 | 11 |
90080 | 90080 | 2020-04-26 | Douglas | Georgia | 13097 | 278 | 8 |
87264 | 87264 | 2020-04-25 | Douglas | Georgia | 13097 | 276 | 8 |
84455 | 84455 | 2020-04-24 | Douglas | Georgia | 13097 | 276 | 8 |
81655 | 81655 | 2020-04-23 | Douglas | Georgia | 13097 | 273 | 8 |
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);