ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Forsyth" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
748881 | 748881 | 2020-11-20 | Forsyth | Georgia | 13117 | 6244 | 61 |
745635 | 745635 | 2020-11-19 | Forsyth | Georgia | 13117 | 6189 | 61 |
742388 | 742388 | 2020-11-18 | Forsyth | Georgia | 13117 | 6122 | 58 |
739141 | 739141 | 2020-11-17 | Forsyth | Georgia | 13117 | 6032 | 58 |
735897 | 735897 | 2020-11-16 | Forsyth | Georgia | 13117 | 5892 | 57 |
732651 | 732651 | 2020-11-15 | Forsyth | Georgia | 13117 | 5884 | 57 |
729406 | 729406 | 2020-11-14 | Forsyth | Georgia | 13117 | 5849 | 57 |
726163 | 726163 | 2020-11-13 | Forsyth | Georgia | 13117 | 5792 | 57 |
722920 | 722920 | 2020-11-12 | Forsyth | Georgia | 13117 | 5752 | 57 |
719677 | 719677 | 2020-11-11 | Forsyth | Georgia | 13117 | 5709 | 56 |
716434 | 716434 | 2020-11-10 | Forsyth | Georgia | 13117 | 5669 | 55 |
713190 | 713190 | 2020-11-09 | Forsyth | Georgia | 13117 | 5556 | 55 |
709946 | 709946 | 2020-11-08 | Forsyth | Georgia | 13117 | 5537 | 55 |
706702 | 706702 | 2020-11-07 | Forsyth | Georgia | 13117 | 5516 | 55 |
703459 | 703459 | 2020-11-06 | Forsyth | Georgia | 13117 | 5476 | 55 |
700216 | 700216 | 2020-11-05 | Forsyth | Georgia | 13117 | 5423 | 55 |
696972 | 696972 | 2020-11-04 | Forsyth | Georgia | 13117 | 5388 | 55 |
693730 | 693730 | 2020-11-03 | Forsyth | Georgia | 13117 | 5329 | 54 |
690487 | 690487 | 2020-11-02 | Forsyth | Georgia | 13117 | 5311 | 54 |
687242 | 687242 | 2020-11-01 | Forsyth | Georgia | 13117 | 5261 | 54 |
683998 | 683998 | 2020-10-31 | Forsyth | Georgia | 13117 | 5243 | 54 |
680755 | 680755 | 2020-10-30 | Forsyth | Georgia | 13117 | 5178 | 54 |
677512 | 677512 | 2020-10-29 | Forsyth | Georgia | 13117 | 5147 | 54 |
674269 | 674269 | 2020-10-28 | Forsyth | Georgia | 13117 | 5127 | 53 |
671027 | 671027 | 2020-10-27 | Forsyth | Georgia | 13117 | 5090 | 53 |
667784 | 667784 | 2020-10-26 | Forsyth | Georgia | 13117 | 5055 | 53 |
664539 | 664539 | 2020-10-25 | Forsyth | Georgia | 13117 | 4990 | 52 |
661295 | 661295 | 2020-10-24 | Forsyth | Georgia | 13117 | 4977 | 52 |
658051 | 658051 | 2020-10-23 | Forsyth | Georgia | 13117 | 4950 | 52 |
654806 | 654806 | 2020-10-22 | Forsyth | Georgia | 13117 | 4910 | 52 |
651561 | 651561 | 2020-10-21 | Forsyth | Georgia | 13117 | 4890 | 52 |
648317 | 648317 | 2020-10-20 | Forsyth | Georgia | 13117 | 4878 | 52 |
645072 | 645072 | 2020-10-19 | Forsyth | Georgia | 13117 | 4863 | 52 |
641824 | 641824 | 2020-10-18 | Forsyth | Georgia | 13117 | 4849 | 51 |
638577 | 638577 | 2020-10-17 | Forsyth | Georgia | 13117 | 4826 | 50 |
635332 | 635332 | 2020-10-16 | Forsyth | Georgia | 13117 | 4801 | 50 |
632086 | 632086 | 2020-10-15 | Forsyth | Georgia | 13117 | 4765 | 48 |
628842 | 628842 | 2020-10-14 | Forsyth | Georgia | 13117 | 4739 | 48 |
625599 | 625599 | 2020-10-13 | Forsyth | Georgia | 13117 | 4699 | 48 |
622356 | 622356 | 2020-10-12 | Forsyth | Georgia | 13117 | 4677 | 48 |
619113 | 619113 | 2020-10-11 | Forsyth | Georgia | 13117 | 4675 | 48 |
615871 | 615871 | 2020-10-10 | Forsyth | Georgia | 13117 | 4656 | 48 |
612630 | 612630 | 2020-10-09 | Forsyth | Georgia | 13117 | 4634 | 47 |
609388 | 609388 | 2020-10-08 | Forsyth | Georgia | 13117 | 4612 | 47 |
606145 | 606145 | 2020-10-07 | Forsyth | Georgia | 13117 | 4586 | 47 |
602903 | 602903 | 2020-10-06 | Forsyth | Georgia | 13117 | 4552 | 47 |
599660 | 599660 | 2020-10-05 | Forsyth | Georgia | 13117 | 4526 | 47 |
596417 | 596417 | 2020-10-04 | Forsyth | Georgia | 13117 | 4211 | 47 |
593175 | 593175 | 2020-10-03 | Forsyth | Georgia | 13117 | 4200 | 46 |
589935 | 589935 | 2020-10-02 | Forsyth | Georgia | 13117 | 4182 | 46 |
586694 | 586694 | 2020-10-01 | Forsyth | Georgia | 13117 | 4160 | 46 |
583454 | 583454 | 2020-09-30 | Forsyth | Georgia | 13117 | 4114 | 46 |
580215 | 580215 | 2020-09-29 | Forsyth | Georgia | 13117 | 4052 | 45 |
576974 | 576974 | 2020-09-28 | Forsyth | Georgia | 13117 | 4022 | 45 |
573731 | 573731 | 2020-09-27 | Forsyth | Georgia | 13117 | 4007 | 45 |
570489 | 570489 | 2020-09-26 | Forsyth | Georgia | 13117 | 3979 | 45 |
567247 | 567247 | 2020-09-25 | Forsyth | Georgia | 13117 | 3926 | 45 |
564007 | 564007 | 2020-09-24 | Forsyth | Georgia | 13117 | 3868 | 45 |
560767 | 560767 | 2020-09-23 | Forsyth | Georgia | 13117 | 3832 | 45 |
557531 | 557531 | 2020-09-22 | Forsyth | Georgia | 13117 | 3772 | 44 |
554294 | 554294 | 2020-09-21 | Forsyth | Georgia | 13117 | 3751 | 42 |
551055 | 551055 | 2020-09-20 | Forsyth | Georgia | 13117 | 3731 | 42 |
547816 | 547816 | 2020-09-19 | Forsyth | Georgia | 13117 | 3705 | 42 |
544578 | 544578 | 2020-09-18 | Forsyth | Georgia | 13117 | 3665 | 42 |
541342 | 541342 | 2020-09-17 | Forsyth | Georgia | 13117 | 3629 | 41 |
538105 | 538105 | 2020-09-16 | Forsyth | Georgia | 13117 | 3611 | 40 |
534869 | 534869 | 2020-09-15 | Forsyth | Georgia | 13117 | 3568 | 40 |
531634 | 531634 | 2020-09-14 | Forsyth | Georgia | 13117 | 3545 | 40 |
528397 | 528397 | 2020-09-13 | Forsyth | Georgia | 13117 | 3528 | 40 |
525161 | 525161 | 2020-09-12 | Forsyth | Georgia | 13117 | 3515 | 40 |
521925 | 521925 | 2020-09-11 | Forsyth | Georgia | 13117 | 3482 | 39 |
518688 | 518688 | 2020-09-10 | Forsyth | Georgia | 13117 | 3463 | 38 |
515453 | 515453 | 2020-09-09 | Forsyth | Georgia | 13117 | 3422 | 37 |
512220 | 512220 | 2020-09-08 | Forsyth | Georgia | 13117 | 3384 | 36 |
508987 | 508987 | 2020-09-07 | Forsyth | Georgia | 13117 | 3358 | 36 |
505755 | 505755 | 2020-09-06 | Forsyth | Georgia | 13117 | 3353 | 36 |
502521 | 502521 | 2020-09-05 | Forsyth | Georgia | 13117 | 3324 | 36 |
499287 | 499287 | 2020-09-04 | Forsyth | Georgia | 13117 | 3281 | 36 |
496054 | 496054 | 2020-09-03 | Forsyth | Georgia | 13117 | 3240 | 35 |
492820 | 492820 | 2020-09-02 | Forsyth | Georgia | 13117 | 3200 | 33 |
489587 | 489587 | 2020-09-01 | Forsyth | Georgia | 13117 | 3154 | 33 |
486354 | 486354 | 2020-08-31 | Forsyth | Georgia | 13117 | 3091 | 33 |
483119 | 483119 | 2020-08-30 | Forsyth | Georgia | 13117 | 3079 | 33 |
479885 | 479885 | 2020-08-29 | Forsyth | Georgia | 13117 | 3057 | 33 |
476652 | 476652 | 2020-08-28 | Forsyth | Georgia | 13117 | 3015 | 32 |
473419 | 473419 | 2020-08-27 | Forsyth | Georgia | 13117 | 2975 | 31 |
470187 | 470187 | 2020-08-26 | Forsyth | Georgia | 13117 | 2938 | 31 |
466958 | 466958 | 2020-08-25 | Forsyth | Georgia | 13117 | 2884 | 32 |
463729 | 463729 | 2020-08-24 | Forsyth | Georgia | 13117 | 2814 | 31 |
460500 | 460500 | 2020-08-23 | Forsyth | Georgia | 13117 | 2808 | 31 |
457273 | 457273 | 2020-08-22 | Forsyth | Georgia | 13117 | 2797 | 31 |
454045 | 454045 | 2020-08-21 | Forsyth | Georgia | 13117 | 2754 | 31 |
450817 | 450817 | 2020-08-20 | Forsyth | Georgia | 13117 | 2710 | 31 |
447589 | 447589 | 2020-08-19 | Forsyth | Georgia | 13117 | 2681 | 29 |
444362 | 444362 | 2020-08-18 | Forsyth | Georgia | 13117 | 2625 | 27 |
441136 | 441136 | 2020-08-17 | Forsyth | Georgia | 13117 | 2586 | 27 |
437910 | 437910 | 2020-08-16 | Forsyth | Georgia | 13117 | 2569 | 27 |
434684 | 434684 | 2020-08-15 | Forsyth | Georgia | 13117 | 2554 | 26 |
431459 | 431459 | 2020-08-14 | Forsyth | Georgia | 13117 | 2507 | 26 |
428231 | 428231 | 2020-08-13 | Forsyth | Georgia | 13117 | 2455 | 26 |
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);