ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Effingham" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
933859 | 933859 | 2021-01-16 | Effingham | Georgia | 13103 | 3156 | 38 |
930614 | 930614 | 2021-01-15 | Effingham | Georgia | 13103 | 3101 | 38 |
927369 | 927369 | 2021-01-14 | Effingham | Georgia | 13103 | 3050 | 37 |
924123 | 924123 | 2021-01-13 | Effingham | Georgia | 13103 | 3027 | 37 |
920878 | 920878 | 2021-01-12 | Effingham | Georgia | 13103 | 2994 | 37 |
917633 | 917633 | 2021-01-11 | Effingham | Georgia | 13103 | 2967 | 37 |
914388 | 914388 | 2021-01-10 | Effingham | Georgia | 13103 | 2950 | 37 |
911143 | 911143 | 2021-01-09 | Effingham | Georgia | 13103 | 2931 | 37 |
907898 | 907898 | 2021-01-08 | Effingham | Georgia | 13103 | 2903 | 37 |
904652 | 904652 | 2021-01-07 | Effingham | Georgia | 13103 | 2851 | 37 |
901407 | 901407 | 2021-01-06 | Effingham | Georgia | 13103 | 2829 | 37 |
898162 | 898162 | 2021-01-05 | Effingham | Georgia | 13103 | 2800 | 36 |
894917 | 894917 | 2021-01-04 | Effingham | Georgia | 13103 | 2784 | 36 |
891670 | 891670 | 2021-01-03 | Effingham | Georgia | 13103 | 2765 | 35 |
888423 | 888423 | 2021-01-02 | Effingham | Georgia | 13103 | 2743 | 35 |
885178 | 885178 | 2021-01-01 | Effingham | Georgia | 13103 | 2722 | 35 |
881933 | 881933 | 2020-12-31 | Effingham | Georgia | 13103 | 2702 | 35 |
878688 | 878688 | 2020-12-30 | Effingham | Georgia | 13103 | 2659 | 35 |
875443 | 875443 | 2020-12-29 | Effingham | Georgia | 13103 | 2622 | 35 |
872198 | 872198 | 2020-12-28 | Effingham | Georgia | 13103 | 2598 | 35 |
868953 | 868953 | 2020-12-27 | Effingham | Georgia | 13103 | 2593 | 35 |
865708 | 865708 | 2020-12-26 | Effingham | Georgia | 13103 | 2588 | 35 |
862463 | 862463 | 2020-12-25 | Effingham | Georgia | 13103 | 2574 | 35 |
859218 | 859218 | 2020-12-24 | Effingham | Georgia | 13103 | 2557 | 35 |
855973 | 855973 | 2020-12-23 | Effingham | Georgia | 13103 | 2529 | 34 |
852728 | 852728 | 2020-12-22 | Effingham | Georgia | 13103 | 2513 | 34 |
849483 | 849483 | 2020-12-21 | Effingham | Georgia | 13103 | 2492 | 34 |
846238 | 846238 | 2020-12-20 | Effingham | Georgia | 13103 | 2480 | 34 |
842992 | 842992 | 2020-12-19 | Effingham | Georgia | 13103 | 2465 | 34 |
839747 | 839747 | 2020-12-18 | Effingham | Georgia | 13103 | 2447 | 34 |
836502 | 836502 | 2020-12-17 | Effingham | Georgia | 13103 | 2414 | 34 |
833256 | 833256 | 2020-12-16 | Effingham | Georgia | 13103 | 2408 | 34 |
830009 | 830009 | 2020-12-15 | Effingham | Georgia | 13103 | 2384 | 34 |
826763 | 826763 | 2020-12-14 | Effingham | Georgia | 13103 | 2371 | 34 |
823516 | 823516 | 2020-12-13 | Effingham | Georgia | 13103 | 2366 | 34 |
820270 | 820270 | 2020-12-12 | Effingham | Georgia | 13103 | 2349 | 34 |
817024 | 817024 | 2020-12-11 | Effingham | Georgia | 13103 | 2334 | 34 |
813778 | 813778 | 2020-12-10 | Effingham | Georgia | 13103 | 2333 | 34 |
810534 | 810534 | 2020-12-09 | Effingham | Georgia | 13103 | 2314 | 33 |
807289 | 807289 | 2020-12-08 | Effingham | Georgia | 13103 | 2303 | 33 |
804044 | 804044 | 2020-12-07 | Effingham | Georgia | 13103 | 2296 | 33 |
800799 | 800799 | 2020-12-06 | Effingham | Georgia | 13103 | 2286 | 33 |
797554 | 797554 | 2020-12-05 | Effingham | Georgia | 13103 | 2279 | 33 |
794309 | 794309 | 2020-12-04 | Effingham | Georgia | 13103 | 2273 | 33 |
791064 | 791064 | 2020-12-03 | Effingham | Georgia | 13103 | 2267 | 33 |
787819 | 787819 | 2020-12-02 | Effingham | Georgia | 13103 | 2250 | 33 |
784575 | 784575 | 2020-12-01 | Effingham | Georgia | 13103 | 2239 | 33 |
781330 | 781330 | 2020-11-30 | Effingham | Georgia | 13103 | 2232 | 33 |
778084 | 778084 | 2020-11-29 | Effingham | Georgia | 13103 | 2229 | 33 |
774839 | 774839 | 2020-11-28 | Effingham | Georgia | 13103 | 2225 | 33 |
771594 | 771594 | 2020-11-27 | Effingham | Georgia | 13103 | 2213 | 33 |
768349 | 768349 | 2020-11-26 | Effingham | Georgia | 13103 | 2207 | 33 |
765103 | 765103 | 2020-11-25 | Effingham | Georgia | 13103 | 2198 | 33 |
761858 | 761858 | 2020-11-24 | Effingham | Georgia | 13103 | 2182 | 32 |
758613 | 758613 | 2020-11-23 | Effingham | Georgia | 13103 | 2171 | 32 |
755366 | 755366 | 2020-11-22 | Effingham | Georgia | 13103 | 2159 | 32 |
752120 | 752120 | 2020-11-21 | Effingham | Georgia | 13103 | 2155 | 32 |
748874 | 748874 | 2020-11-20 | Effingham | Georgia | 13103 | 2140 | 31 |
745628 | 745628 | 2020-11-19 | Effingham | Georgia | 13103 | 2129 | 31 |
742381 | 742381 | 2020-11-18 | Effingham | Georgia | 13103 | 2111 | 30 |
739134 | 739134 | 2020-11-17 | Effingham | Georgia | 13103 | 2091 | 30 |
735890 | 735890 | 2020-11-16 | Effingham | Georgia | 13103 | 2065 | 30 |
732644 | 732644 | 2020-11-15 | Effingham | Georgia | 13103 | 2055 | 30 |
729399 | 729399 | 2020-11-14 | Effingham | Georgia | 13103 | 2053 | 30 |
726156 | 726156 | 2020-11-13 | Effingham | Georgia | 13103 | 2046 | 30 |
722913 | 722913 | 2020-11-12 | Effingham | Georgia | 13103 | 2023 | 30 |
719670 | 719670 | 2020-11-11 | Effingham | Georgia | 13103 | 2004 | 30 |
716427 | 716427 | 2020-11-10 | Effingham | Georgia | 13103 | 1993 | 30 |
713183 | 713183 | 2020-11-09 | Effingham | Georgia | 13103 | 1979 | 30 |
709939 | 709939 | 2020-11-08 | Effingham | Georgia | 13103 | 1964 | 30 |
706695 | 706695 | 2020-11-07 | Effingham | Georgia | 13103 | 1959 | 30 |
703452 | 703452 | 2020-11-06 | Effingham | Georgia | 13103 | 1954 | 30 |
700209 | 700209 | 2020-11-05 | Effingham | Georgia | 13103 | 1940 | 30 |
696965 | 696965 | 2020-11-04 | Effingham | Georgia | 13103 | 1927 | 30 |
693723 | 693723 | 2020-11-03 | Effingham | Georgia | 13103 | 1916 | 29 |
690480 | 690480 | 2020-11-02 | Effingham | Georgia | 13103 | 1913 | 29 |
687235 | 687235 | 2020-11-01 | Effingham | Georgia | 13103 | 1899 | 29 |
683991 | 683991 | 2020-10-31 | Effingham | Georgia | 13103 | 1896 | 29 |
680748 | 680748 | 2020-10-30 | Effingham | Georgia | 13103 | 1881 | 29 |
677505 | 677505 | 2020-10-29 | Effingham | Georgia | 13103 | 1871 | 28 |
674262 | 674262 | 2020-10-28 | Effingham | Georgia | 13103 | 1863 | 28 |
671020 | 671020 | 2020-10-27 | Effingham | Georgia | 13103 | 1852 | 28 |
667777 | 667777 | 2020-10-26 | Effingham | Georgia | 13103 | 1832 | 28 |
664532 | 664532 | 2020-10-25 | Effingham | Georgia | 13103 | 1810 | 28 |
661288 | 661288 | 2020-10-24 | Effingham | Georgia | 13103 | 1802 | 28 |
658044 | 658044 | 2020-10-23 | Effingham | Georgia | 13103 | 1792 | 27 |
654799 | 654799 | 2020-10-22 | Effingham | Georgia | 13103 | 1778 | 27 |
651554 | 651554 | 2020-10-21 | Effingham | Georgia | 13103 | 1766 | 28 |
648310 | 648310 | 2020-10-20 | Effingham | Georgia | 13103 | 1752 | 28 |
645065 | 645065 | 2020-10-19 | Effingham | Georgia | 13103 | 1740 | 28 |
641817 | 641817 | 2020-10-18 | Effingham | Georgia | 13103 | 1719 | 28 |
638570 | 638570 | 2020-10-17 | Effingham | Georgia | 13103 | 1701 | 28 |
635325 | 635325 | 2020-10-16 | Effingham | Georgia | 13103 | 1684 | 28 |
632079 | 632079 | 2020-10-15 | Effingham | Georgia | 13103 | 1667 | 28 |
628835 | 628835 | 2020-10-14 | Effingham | Georgia | 13103 | 1655 | 28 |
625592 | 625592 | 2020-10-13 | Effingham | Georgia | 13103 | 1643 | 28 |
622349 | 622349 | 2020-10-12 | Effingham | Georgia | 13103 | 1630 | 28 |
619106 | 619106 | 2020-10-11 | Effingham | Georgia | 13103 | 1621 | 28 |
615864 | 615864 | 2020-10-10 | Effingham | Georgia | 13103 | 1587 | 28 |
612623 | 612623 | 2020-10-09 | Effingham | Georgia | 13103 | 1576 | 28 |
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);