ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where "date" is on date 2020-10-06 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
602846 | 602846 | 2020-10-06 | Appling | Georgia | 13001 | 1146 | 33 |
602847 | 602847 | 2020-10-06 | Atkinson | Georgia | 13003 | 508 | 4 |
602848 | 602848 | 2020-10-06 | Bacon | Georgia | 13005 | 670 | 14 |
602849 | 602849 | 2020-10-06 | Baker | Georgia | 13007 | 94 | 4 |
602850 | 602850 | 2020-10-06 | Baldwin | Georgia | 13009 | 2231 | 58 |
602851 | 602851 | 2020-10-06 | Banks | Georgia | 13011 | 510 | 8 |
602852 | 602852 | 2020-10-06 | Barrow | Georgia | 13013 | 2401 | 48 |
602853 | 602853 | 2020-10-06 | Bartow | Georgia | 13015 | 3195 | 88 |
602854 | 602854 | 2020-10-06 | Ben Hill | Georgia | 13017 | 866 | 26 |
602855 | 602855 | 2020-10-06 | Berrien | Georgia | 13019 | 549 | 12 |
602856 | 602856 | 2020-10-06 | Bibb | Georgia | 13021 | 6292 | 181 |
602857 | 602857 | 2020-10-06 | Bleckley | Georgia | 13023 | 531 | 21 |
602858 | 602858 | 2020-10-06 | Brantley | Georgia | 13025 | 482 | 10 |
602859 | 602859 | 2020-10-06 | Brooks | Georgia | 13027 | 560 | 26 |
602860 | 602860 | 2020-10-06 | Bryan | Georgia | 13029 | 1216 | 11 |
602861 | 602861 | 2020-10-06 | Bulloch | Georgia | 13031 | 3226 | 28 |
602862 | 602862 | 2020-10-06 | Burke | Georgia | 13033 | 1016 | 10 |
602863 | 602863 | 2020-10-06 | Butts | Georgia | 13035 | 795 | 43 |
602864 | 602864 | 2020-10-06 | Calhoun | Georgia | 13037 | 265 | 9 |
602865 | 602865 | 2020-10-06 | Camden | Georgia | 13039 | 1352 | 16 |
602866 | 602866 | 2020-10-06 | Candler | Georgia | 13043 | 491 | 21 |
602867 | 602867 | 2020-10-06 | Carroll | Georgia | 13045 | 3321 | 70 |
602868 | 602868 | 2020-10-06 | Catoosa | Georgia | 13047 | 1256 | 20 |
602869 | 602869 | 2020-10-06 | Charlton | Georgia | 13049 | 710 | 9 |
602870 | 602870 | 2020-10-06 | Chatham | Georgia | 13051 | 8804 | 169 |
602871 | 602871 | 2020-10-06 | Chattahoochee | Georgia | 13053 | 1709 | 1 |
602872 | 602872 | 2020-10-06 | Chattooga | Georgia | 13055 | 828 | 22 |
602873 | 602873 | 2020-10-06 | Cherokee | Georgia | 13057 | 6722 | 94 |
602874 | 602874 | 2020-10-06 | Clarke | Georgia | 13059 | 6009 | 45 |
602875 | 602875 | 2020-10-06 | Clay | Georgia | 13061 | 123 | 3 |
602876 | 602876 | 2020-10-06 | Clayton | Georgia | 13063 | 7557 | 163 |
602877 | 602877 | 2020-10-06 | Clinch | Georgia | 13065 | 418 | 9 |
602878 | 602878 | 2020-10-06 | Cobb | Georgia | 13067 | 21606 | 435 |
602879 | 602879 | 2020-10-06 | Coffee | Georgia | 13069 | 2306 | 54 |
602880 | 602880 | 2020-10-06 | Colquitt | Georgia | 13071 | 2204 | 36 |
602881 | 602881 | 2020-10-06 | Columbia | Georgia | 13073 | 4275 | 62 |
602882 | 602882 | 2020-10-06 | Cook | Georgia | 13075 | 599 | 14 |
602883 | 602883 | 2020-10-06 | Coweta | Georgia | 13077 | 3313 | 52 |
602884 | 602884 | 2020-10-06 | Crawford | Georgia | 13079 | 188 | 5 |
602885 | 602885 | 2020-10-06 | Crisp | Georgia | 13081 | 731 | 19 |
602886 | 602886 | 2020-10-06 | Dade | Georgia | 13083 | 299 | 5 |
602887 | 602887 | 2020-10-06 | Dawson | Georgia | 13085 | 871 | 8 |
602888 | 602888 | 2020-10-06 | DeKalb | Georgia | 13089 | 20059 | 373 |
602889 | 602889 | 2020-10-06 | Decatur | Georgia | 13087 | 1261 | 32 |
602890 | 602890 | 2020-10-06 | Dodge | Georgia | 13091 | 629 | 12 |
602891 | 602891 | 2020-10-06 | Dooly | Georgia | 13093 | 392 | 14 |
602892 | 602892 | 2020-10-06 | Dougherty | Georgia | 13095 | 3344 | 188 |
602893 | 602893 | 2020-10-06 | Douglas | Georgia | 13097 | 3927 | 70 |
602894 | 602894 | 2020-10-06 | Early | Georgia | 13099 | 548 | 33 |
602895 | 602895 | 2020-10-06 | Echols | Georgia | 13101 | 248 | 2 |
602896 | 602896 | 2020-10-06 | Effingham | Georgia | 13103 | 1549 | 26 |
602897 | 602897 | 2020-10-06 | Elbert | Georgia | 13105 | 746 | 5 |
602898 | 602898 | 2020-10-06 | Emanuel | Georgia | 13107 | 1142 | 32 |
602899 | 602899 | 2020-10-06 | Evans | Georgia | 13109 | 460 | 6 |
602900 | 602900 | 2020-10-06 | Fannin | Georgia | 13111 | 740 | 26 |
602901 | 602901 | 2020-10-06 | Fayette | Georgia | 13113 | 2202 | 52 |
602902 | 602902 | 2020-10-06 | Floyd | Georgia | 13115 | 3391 | 47 |
602903 | 602903 | 2020-10-06 | Forsyth | Georgia | 13117 | 4552 | 47 |
602904 | 602904 | 2020-10-06 | Franklin | Georgia | 13119 | 794 | 14 |
602905 | 602905 | 2020-10-06 | Fulton | Georgia | 13121 | 29976 | 581 |
602906 | 602906 | 2020-10-06 | Gilmer | Georgia | 13123 | 926 | 13 |
602907 | 602907 | 2020-10-06 | Glascock | Georgia | 13125 | 48 | 2 |
602908 | 602908 | 2020-10-06 | Glynn | Georgia | 13127 | 3568 | 97 |
602909 | 602909 | 2020-10-06 | Gordon | Georgia | 13129 | 1958 | 40 |
602910 | 602910 | 2020-10-06 | Grady | Georgia | 13131 | 845 | 23 |
602911 | 602911 | 2020-10-06 | Greene | Georgia | 13133 | 566 | 24 |
602912 | 602912 | 2020-10-06 | Gwinnett | Georgia | 13135 | 29653 | 418 |
602913 | 602913 | 2020-10-06 | Habersham | Georgia | 13137 | 1756 | 71 |
602914 | 602914 | 2020-10-06 | Hall | Georgia | 13139 | 9783 | 159 |
602915 | 602915 | 2020-10-06 | Hancock | Georgia | 13141 | 407 | 43 |
602916 | 602916 | 2020-10-06 | Haralson | Georgia | 13143 | 611 | 9 |
602917 | 602917 | 2020-10-06 | Harris | Georgia | 13145 | 835 | 22 |
602918 | 602918 | 2020-10-06 | Hart | Georgia | 13147 | 542 | 13 |
602919 | 602919 | 2020-10-06 | Heard | Georgia | 13149 | 233 | 6 |
602920 | 602920 | 2020-10-06 | Henry | Georgia | 13151 | 5892 | 106 |
602921 | 602921 | 2020-10-06 | Houston | Georgia | 13153 | 3416 | 84 |
602922 | 602922 | 2020-10-06 | Irwin | Georgia | 13155 | 344 | 7 |
602923 | 602923 | 2020-10-06 | Jackson | Georgia | 13157 | 2160 | 35 |
602924 | 602924 | 2020-10-06 | Jasper | Georgia | 13159 | 331 | 4 |
602925 | 602925 | 2020-10-06 | Jeff Davis | Georgia | 13161 | 813 | 20 |
602926 | 602926 | 2020-10-06 | Jefferson | Georgia | 13163 | 849 | 30 |
602927 | 602927 | 2020-10-06 | Jenkins | Georgia | 13165 | 448 | 30 |
602928 | 602928 | 2020-10-06 | Johnson | Georgia | 13167 | 457 | 22 |
602929 | 602929 | 2020-10-06 | Jones | Georgia | 13169 | 602 | 11 |
602930 | 602930 | 2020-10-06 | Lamar | Georgia | 13171 | 458 | 19 |
602931 | 602931 | 2020-10-06 | Lanier | Georgia | 13173 | 333 | 6 |
602932 | 602932 | 2020-10-06 | Laurens | Georgia | 13175 | 1927 | 77 |
602933 | 602933 | 2020-10-06 | Lee | Georgia | 13177 | 781 | 26 |
602934 | 602934 | 2020-10-06 | Liberty | Georgia | 13179 | 1165 | 23 |
602935 | 602935 | 2020-10-06 | Lincoln | Georgia | 13181 | 228 | 7 |
602936 | 602936 | 2020-10-06 | Long | Georgia | 13183 | 272 | 3 |
602937 | 602937 | 2020-10-06 | Lowndes | Georgia | 13185 | 4490 | 85 |
602938 | 602938 | 2020-10-06 | Lumpkin | Georgia | 13187 | 958 | 14 |
602939 | 602939 | 2020-10-06 | Macon | Georgia | 13193 | 265 | 10 |
602940 | 602940 | 2020-10-06 | Madison | Georgia | 13195 | 778 | 8 |
602941 | 602941 | 2020-10-06 | Marion | Georgia | 13197 | 217 | 9 |
602942 | 602942 | 2020-10-06 | McDuffie | Georgia | 13189 | 671 | 14 |
602943 | 602943 | 2020-10-06 | McIntosh | Georgia | 13191 | 308 | 7 |
602944 | 602944 | 2020-10-06 | Meriwether | Georgia | 13199 | 647 | 14 |
602945 | 602945 | 2020-10-06 | Miller | Georgia | 13201 | 292 | 1 |
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);