ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Fayette" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534867 | 534867 | 2020-09-15 | Fayette | Georgia | 13113 | 1693 | 47 |
531632 | 531632 | 2020-09-14 | Fayette | Georgia | 13113 | 1681 | 45 |
528395 | 528395 | 2020-09-13 | Fayette | Georgia | 13113 | 1675 | 45 |
525159 | 525159 | 2020-09-12 | Fayette | Georgia | 13113 | 1667 | 45 |
521923 | 521923 | 2020-09-11 | Fayette | Georgia | 13113 | 1657 | 44 |
518686 | 518686 | 2020-09-10 | Fayette | Georgia | 13113 | 1653 | 44 |
515451 | 515451 | 2020-09-09 | Fayette | Georgia | 13113 | 1644 | 43 |
512218 | 512218 | 2020-09-08 | Fayette | Georgia | 13113 | 1632 | 43 |
508985 | 508985 | 2020-09-07 | Fayette | Georgia | 13113 | 1628 | 43 |
505753 | 505753 | 2020-09-06 | Fayette | Georgia | 13113 | 1628 | 43 |
502519 | 502519 | 2020-09-05 | Fayette | Georgia | 13113 | 1624 | 41 |
499285 | 499285 | 2020-09-04 | Fayette | Georgia | 13113 | 1613 | 40 |
496052 | 496052 | 2020-09-03 | Fayette | Georgia | 13113 | 1606 | 39 |
492818 | 492818 | 2020-09-02 | Fayette | Georgia | 13113 | 1595 | 39 |
489585 | 489585 | 2020-09-01 | Fayette | Georgia | 13113 | 1585 | 38 |
486352 | 486352 | 2020-08-31 | Fayette | Georgia | 13113 | 1573 | 38 |
483117 | 483117 | 2020-08-30 | Fayette | Georgia | 13113 | 1568 | 38 |
479883 | 479883 | 2020-08-29 | Fayette | Georgia | 13113 | 1564 | 38 |
476650 | 476650 | 2020-08-28 | Fayette | Georgia | 13113 | 1539 | 38 |
473417 | 473417 | 2020-08-27 | Fayette | Georgia | 13113 | 1492 | 36 |
470185 | 470185 | 2020-08-26 | Fayette | Georgia | 13113 | 1453 | 36 |
466956 | 466956 | 2020-08-25 | Fayette | Georgia | 13113 | 1434 | 36 |
463727 | 463727 | 2020-08-24 | Fayette | Georgia | 13113 | 1419 | 36 |
460498 | 460498 | 2020-08-23 | Fayette | Georgia | 13113 | 1412 | 36 |
457271 | 457271 | 2020-08-22 | Fayette | Georgia | 13113 | 1404 | 35 |
454043 | 454043 | 2020-08-21 | Fayette | Georgia | 13113 | 1394 | 34 |
450815 | 450815 | 2020-08-20 | Fayette | Georgia | 13113 | 1388 | 34 |
447587 | 447587 | 2020-08-19 | Fayette | Georgia | 13113 | 1365 | 34 |
444360 | 444360 | 2020-08-18 | Fayette | Georgia | 13113 | 1341 | 34 |
441134 | 441134 | 2020-08-17 | Fayette | Georgia | 13113 | 1305 | 34 |
437908 | 437908 | 2020-08-16 | Fayette | Georgia | 13113 | 1277 | 34 |
434682 | 434682 | 2020-08-15 | Fayette | Georgia | 13113 | 1263 | 33 |
431457 | 431457 | 2020-08-14 | Fayette | Georgia | 13113 | 1243 | 33 |
428229 | 428229 | 2020-08-13 | Fayette | Georgia | 13113 | 1210 | 32 |
425005 | 425005 | 2020-08-12 | Fayette | Georgia | 13113 | 1187 | 31 |
421784 | 421784 | 2020-08-11 | Fayette | Georgia | 13113 | 1159 | 30 |
418563 | 418563 | 2020-08-10 | Fayette | Georgia | 13113 | 1131 | 29 |
415342 | 415342 | 2020-08-09 | Fayette | Georgia | 13113 | 1120 | 28 |
412122 | 412122 | 2020-08-08 | Fayette | Georgia | 13113 | 1100 | 28 |
408903 | 408903 | 2020-08-07 | Fayette | Georgia | 13113 | 1078 | 28 |
405683 | 405683 | 2020-08-06 | Fayette | Georgia | 13113 | 1047 | 26 |
402465 | 402465 | 2020-08-05 | Fayette | Georgia | 13113 | 1028 | 25 |
399249 | 399249 | 2020-08-04 | Fayette | Georgia | 13113 | 994 | 25 |
396033 | 396033 | 2020-08-03 | Fayette | Georgia | 13113 | 980 | 25 |
392817 | 392817 | 2020-08-02 | Fayette | Georgia | 13113 | 970 | 25 |
389600 | 389600 | 2020-08-01 | Fayette | Georgia | 13113 | 949 | 25 |
386383 | 386383 | 2020-07-31 | Fayette | Georgia | 13113 | 918 | 24 |
383165 | 383165 | 2020-07-30 | Fayette | Georgia | 13113 | 898 | 24 |
379948 | 379948 | 2020-07-29 | Fayette | Georgia | 13113 | 873 | 24 |
376731 | 376731 | 2020-07-28 | Fayette | Georgia | 13113 | 855 | 23 |
373517 | 373517 | 2020-07-27 | Fayette | Georgia | 13113 | 825 | 23 |
370305 | 370305 | 2020-07-26 | Fayette | Georgia | 13113 | 805 | 23 |
367095 | 367095 | 2020-07-25 | Fayette | Georgia | 13113 | 788 | 23 |
363888 | 363888 | 2020-07-24 | Fayette | Georgia | 13113 | 764 | 23 |
360681 | 360681 | 2020-07-23 | Fayette | Georgia | 13113 | 742 | 21 |
357476 | 357476 | 2020-07-22 | Fayette | Georgia | 13113 | 702 | 21 |
354273 | 354273 | 2020-07-21 | Fayette | Georgia | 13113 | 693 | 21 |
351071 | 351071 | 2020-07-20 | Fayette | Georgia | 13113 | 669 | 20 |
347870 | 347870 | 2020-07-19 | Fayette | Georgia | 13113 | 654 | 20 |
344670 | 344670 | 2020-07-18 | Fayette | Georgia | 13113 | 629 | 20 |
341471 | 341471 | 2020-07-17 | Fayette | Georgia | 13113 | 612 | 20 |
338274 | 338274 | 2020-07-16 | Fayette | Georgia | 13113 | 584 | 20 |
335079 | 335079 | 2020-07-15 | Fayette | Georgia | 13113 | 565 | 20 |
331886 | 331886 | 2020-07-14 | Fayette | Georgia | 13113 | 549 | 19 |
328699 | 328699 | 2020-07-13 | Fayette | Georgia | 13113 | 532 | 19 |
325513 | 325513 | 2020-07-12 | Fayette | Georgia | 13113 | 514 | 19 |
322332 | 322332 | 2020-07-11 | Fayette | Georgia | 13113 | 509 | 19 |
319153 | 319153 | 2020-07-10 | Fayette | Georgia | 13113 | 498 | 19 |
315980 | 315980 | 2020-07-09 | Fayette | Georgia | 13113 | 476 | 19 |
312805 | 312805 | 2020-07-08 | Fayette | Georgia | 13113 | 472 | 19 |
309635 | 309635 | 2020-07-07 | Fayette | Georgia | 13113 | 458 | 19 |
306467 | 306467 | 2020-07-06 | Fayette | Georgia | 13113 | 422 | 19 |
303303 | 303303 | 2020-07-05 | Fayette | Georgia | 13113 | 414 | 19 |
300139 | 300139 | 2020-07-04 | Fayette | Georgia | 13113 | 408 | 19 |
296977 | 296977 | 2020-07-03 | Fayette | Georgia | 13113 | 384 | 19 |
293821 | 293821 | 2020-07-02 | Fayette | Georgia | 13113 | 363 | 19 |
290667 | 290667 | 2020-07-01 | Fayette | Georgia | 13113 | 346 | 19 |
287516 | 287516 | 2020-06-30 | Fayette | Georgia | 13113 | 341 | 17 |
284370 | 284370 | 2020-06-29 | Fayette | Georgia | 13113 | 326 | 17 |
281224 | 281224 | 2020-06-28 | Fayette | Georgia | 13113 | 326 | 17 |
278077 | 278077 | 2020-06-27 | Fayette | Georgia | 13113 | 324 | 17 |
274929 | 274929 | 2020-06-26 | Fayette | Georgia | 13113 | 322 | 17 |
271789 | 271789 | 2020-06-25 | Fayette | Georgia | 13113 | 314 | 17 |
268653 | 268653 | 2020-06-24 | Fayette | Georgia | 13113 | 305 | 16 |
265523 | 265523 | 2020-06-23 | Fayette | Georgia | 13113 | 299 | 16 |
262395 | 262395 | 2020-06-22 | Fayette | Georgia | 13113 | 292 | 16 |
259268 | 259268 | 2020-06-21 | Fayette | Georgia | 13113 | 280 | 16 |
256141 | 256141 | 2020-06-20 | Fayette | Georgia | 13113 | 279 | 16 |
253022 | 253022 | 2020-06-19 | Fayette | Georgia | 13113 | 278 | 16 |
249907 | 249907 | 2020-06-18 | Fayette | Georgia | 13113 | 271 | 16 |
246795 | 246795 | 2020-06-17 | Fayette | Georgia | 13113 | 271 | 16 |
243682 | 243682 | 2020-06-16 | Fayette | Georgia | 13113 | 270 | 16 |
240571 | 240571 | 2020-06-15 | Fayette | Georgia | 13113 | 261 | 15 |
237463 | 237463 | 2020-06-14 | Fayette | Georgia | 13113 | 261 | 14 |
234356 | 234356 | 2020-06-13 | Fayette | Georgia | 13113 | 260 | 14 |
231250 | 231250 | 2020-06-12 | Fayette | Georgia | 13113 | 259 | 14 |
228147 | 228147 | 2020-06-11 | Fayette | Georgia | 13113 | 258 | 14 |
225045 | 225045 | 2020-06-10 | Fayette | Georgia | 13113 | 254 | 14 |
221950 | 221950 | 2020-06-09 | Fayette | Georgia | 13113 | 254 | 15 |
218855 | 218855 | 2020-06-08 | Fayette | Georgia | 13113 | 247 | 15 |
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);