ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 13117 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386385 | 386385 | 2020-07-31 | Forsyth | Georgia | 13117 | 1858 | 19 |
383167 | 383167 | 2020-07-30 | Forsyth | Georgia | 13117 | 1796 | 19 |
379950 | 379950 | 2020-07-29 | Forsyth | Georgia | 13117 | 1730 | 18 |
376733 | 376733 | 2020-07-28 | Forsyth | Georgia | 13117 | 1691 | 17 |
373519 | 373519 | 2020-07-27 | Forsyth | Georgia | 13117 | 1641 | 16 |
370307 | 370307 | 2020-07-26 | Forsyth | Georgia | 13117 | 1617 | 16 |
367097 | 367097 | 2020-07-25 | Forsyth | Georgia | 13117 | 1597 | 16 |
363890 | 363890 | 2020-07-24 | Forsyth | Georgia | 13117 | 1556 | 16 |
360683 | 360683 | 2020-07-23 | Forsyth | Georgia | 13117 | 1499 | 16 |
357478 | 357478 | 2020-07-22 | Forsyth | Georgia | 13117 | 1454 | 16 |
354275 | 354275 | 2020-07-21 | Forsyth | Georgia | 13117 | 1414 | 16 |
351073 | 351073 | 2020-07-20 | Forsyth | Georgia | 13117 | 1383 | 16 |
347872 | 347872 | 2020-07-19 | Forsyth | Georgia | 13117 | 1372 | 16 |
344672 | 344672 | 2020-07-18 | Forsyth | Georgia | 13117 | 1355 | 16 |
341473 | 341473 | 2020-07-17 | Forsyth | Georgia | 13117 | 1312 | 16 |
338276 | 338276 | 2020-07-16 | Forsyth | Georgia | 13117 | 1280 | 16 |
335081 | 335081 | 2020-07-15 | Forsyth | Georgia | 13117 | 1257 | 15 |
331888 | 331888 | 2020-07-14 | Forsyth | Georgia | 13117 | 1223 | 15 |
328701 | 328701 | 2020-07-13 | Forsyth | Georgia | 13117 | 1193 | 15 |
325515 | 325515 | 2020-07-12 | Forsyth | Georgia | 13117 | 1148 | 15 |
322334 | 322334 | 2020-07-11 | Forsyth | Georgia | 13117 | 1123 | 15 |
319155 | 319155 | 2020-07-10 | Forsyth | Georgia | 13117 | 1096 | 15 |
315982 | 315982 | 2020-07-09 | Forsyth | Georgia | 13117 | 1057 | 15 |
312807 | 312807 | 2020-07-08 | Forsyth | Georgia | 13117 | 1042 | 15 |
309637 | 309637 | 2020-07-07 | Forsyth | Georgia | 13117 | 1006 | 15 |
306469 | 306469 | 2020-07-06 | Forsyth | Georgia | 13117 | 959 | 15 |
303305 | 303305 | 2020-07-05 | Forsyth | Georgia | 13117 | 944 | 15 |
300141 | 300141 | 2020-07-04 | Forsyth | Georgia | 13117 | 934 | 15 |
296979 | 296979 | 2020-07-03 | Forsyth | Georgia | 13117 | 903 | 15 |
293823 | 293823 | 2020-07-02 | Forsyth | Georgia | 13117 | 871 | 15 |
290669 | 290669 | 2020-07-01 | Forsyth | Georgia | 13117 | 851 | 15 |
287518 | 287518 | 2020-06-30 | Forsyth | Georgia | 13117 | 828 | 15 |
284372 | 284372 | 2020-06-29 | Forsyth | Georgia | 13117 | 792 | 15 |
281226 | 281226 | 2020-06-28 | Forsyth | Georgia | 13117 | 788 | 15 |
278079 | 278079 | 2020-06-27 | Forsyth | Georgia | 13117 | 778 | 15 |
274931 | 274931 | 2020-06-26 | Forsyth | Georgia | 13117 | 756 | 15 |
271791 | 271791 | 2020-06-25 | Forsyth | Georgia | 13117 | 737 | 15 |
268655 | 268655 | 2020-06-24 | Forsyth | Georgia | 13117 | 721 | 14 |
265525 | 265525 | 2020-06-23 | Forsyth | Georgia | 13117 | 694 | 14 |
262397 | 262397 | 2020-06-22 | Forsyth | Georgia | 13117 | 660 | 14 |
259270 | 259270 | 2020-06-21 | Forsyth | Georgia | 13117 | 650 | 14 |
256143 | 256143 | 2020-06-20 | Forsyth | Georgia | 13117 | 642 | 14 |
253024 | 253024 | 2020-06-19 | Forsyth | Georgia | 13117 | 638 | 14 |
249909 | 249909 | 2020-06-18 | Forsyth | Georgia | 13117 | 627 | 14 |
246797 | 246797 | 2020-06-17 | Forsyth | Georgia | 13117 | 616 | 13 |
243684 | 243684 | 2020-06-16 | Forsyth | Georgia | 13117 | 603 | 13 |
240573 | 240573 | 2020-06-15 | Forsyth | Georgia | 13117 | 598 | 13 |
237465 | 237465 | 2020-06-14 | Forsyth | Georgia | 13117 | 595 | 13 |
234358 | 234358 | 2020-06-13 | Forsyth | Georgia | 13117 | 594 | 13 |
231252 | 231252 | 2020-06-12 | Forsyth | Georgia | 13117 | 589 | 13 |
228149 | 228149 | 2020-06-11 | Forsyth | Georgia | 13117 | 579 | 13 |
225047 | 225047 | 2020-06-10 | Forsyth | Georgia | 13117 | 579 | 12 |
221952 | 221952 | 2020-06-09 | Forsyth | Georgia | 13117 | 575 | 12 |
218857 | 218857 | 2020-06-08 | Forsyth | Georgia | 13117 | 556 | 12 |
215766 | 215766 | 2020-06-07 | Forsyth | Georgia | 13117 | 546 | 12 |
212679 | 212679 | 2020-06-06 | Forsyth | Georgia | 13117 | 546 | 12 |
209594 | 209594 | 2020-06-05 | Forsyth | Georgia | 13117 | 541 | 12 |
206513 | 206513 | 2020-06-04 | Forsyth | Georgia | 13117 | 535 | 12 |
203433 | 203433 | 2020-06-03 | Forsyth | Georgia | 13117 | 534 | 12 |
200357 | 200357 | 2020-06-02 | Forsyth | Georgia | 13117 | 532 | 12 |
197284 | 197284 | 2020-06-01 | Forsyth | Georgia | 13117 | 523 | 12 |
194214 | 194214 | 2020-05-31 | Forsyth | Georgia | 13117 | 512 | 12 |
191147 | 191147 | 2020-05-30 | Forsyth | Georgia | 13117 | 512 | 12 |
188082 | 188082 | 2020-05-29 | Forsyth | Georgia | 13117 | 512 | 12 |
185026 | 185026 | 2020-05-28 | Forsyth | Georgia | 13117 | 507 | 12 |
181972 | 181972 | 2020-05-27 | Forsyth | Georgia | 13117 | 502 | 13 |
178928 | 178928 | 2020-05-26 | Forsyth | Georgia | 13117 | 492 | 13 |
175884 | 175884 | 2020-05-25 | Forsyth | Georgia | 13117 | 480 | 12 |
172841 | 172841 | 2020-05-24 | Forsyth | Georgia | 13117 | 449 | 12 |
169800 | 169800 | 2020-05-23 | Forsyth | Georgia | 13117 | 446 | 12 |
166763 | 166763 | 2020-05-22 | Forsyth | Georgia | 13117 | 444 | 12 |
163730 | 163730 | 2020-05-21 | Forsyth | Georgia | 13117 | 443 | 12 |
160702 | 160702 | 2020-05-20 | Forsyth | Georgia | 13117 | 434 | 11 |
157676 | 157676 | 2020-05-19 | Forsyth | Georgia | 13117 | 412 | 11 |
154660 | 154660 | 2020-05-18 | Forsyth | Georgia | 13117 | 405 | 11 |
151648 | 151648 | 2020-05-17 | Forsyth | Georgia | 13117 | 399 | 11 |
148639 | 148639 | 2020-05-16 | Forsyth | Georgia | 13117 | 398 | 11 |
145636 | 145636 | 2020-05-15 | Forsyth | Georgia | 13117 | 397 | 11 |
142636 | 142636 | 2020-05-14 | Forsyth | Georgia | 13117 | 395 | 11 |
139640 | 139640 | 2020-05-13 | Forsyth | Georgia | 13117 | 393 | 11 |
136649 | 136649 | 2020-05-12 | Forsyth | Georgia | 13117 | 386 | 11 |
133660 | 133660 | 2020-05-11 | Forsyth | Georgia | 13117 | 391 | 10 |
130669 | 130669 | 2020-05-10 | Forsyth | Georgia | 13117 | 388 | 10 |
127678 | 127678 | 2020-05-09 | Forsyth | Georgia | 13117 | 366 | 10 |
124691 | 124691 | 2020-05-08 | Forsyth | Georgia | 13117 | 364 | 10 |
121712 | 121712 | 2020-05-07 | Forsyth | Georgia | 13117 | 361 | 10 |
118743 | 118743 | 2020-05-06 | Forsyth | Georgia | 13117 | 356 | 10 |
115783 | 115783 | 2020-05-05 | Forsyth | Georgia | 13117 | 347 | 10 |
112900 | 112900 | 2020-05-04 | Forsyth | Georgia | 13117 | 341 | 10 |
110025 | 110025 | 2020-05-03 | Forsyth | Georgia | 13117 | 332 | 10 |
107156 | 107156 | 2020-05-02 | Forsyth | Georgia | 13117 | 331 | 10 |
104291 | 104291 | 2020-05-01 | Forsyth | Georgia | 13117 | 309 | 10 |
101436 | 101436 | 2020-04-30 | Forsyth | Georgia | 13117 | 299 | 9 |
98586 | 98586 | 2020-04-29 | Forsyth | Georgia | 13117 | 292 | 9 |
95741 | 95741 | 2020-04-28 | Forsyth | Georgia | 13117 | 284 | 9 |
92909 | 92909 | 2020-04-27 | Forsyth | Georgia | 13117 | 271 | 8 |
90090 | 90090 | 2020-04-26 | Forsyth | Georgia | 13117 | 252 | 8 |
87274 | 87274 | 2020-04-25 | Forsyth | Georgia | 13117 | 249 | 8 |
84465 | 84465 | 2020-04-24 | Forsyth | Georgia | 13117 | 241 | 8 |
81665 | 81665 | 2020-04-23 | Forsyth | Georgia | 13117 | 235 | 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);