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 2021-07-30 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1566856 | 1566856 | 2021-07-30 | Appling | Georgia | 13001 | 2440 | 72 |
1566857 | 1566857 | 2021-07-30 | Atkinson | Georgia | 13003 | 1117 | 23 |
1566858 | 1566858 | 2021-07-30 | Bacon | Georgia | 13005 | 1762 | 40 |
1566859 | 1566859 | 2021-07-30 | Baker | Georgia | 13007 | 267 | 11 |
1566860 | 1566860 | 2021-07-30 | Baldwin | Georgia | 13009 | 4682 | 137 |
1566861 | 1566861 | 2021-07-30 | Banks | Georgia | 13011 | 1933 | 41 |
1566862 | 1566862 | 2021-07-30 | Barrow | Georgia | 13013 | 10562 | 147 |
1566863 | 1566863 | 2021-07-30 | Bartow | Georgia | 13015 | 15547 | 242 |
1566864 | 1566864 | 2021-07-30 | Ben Hill | Georgia | 13017 | 2224 | 84 |
1566865 | 1566865 | 2021-07-30 | Berrien | Georgia | 13019 | 2079 | 48 |
1566866 | 1566866 | 2021-07-30 | Bibb | Georgia | 13021 | 17073 | 467 |
1566867 | 1566867 | 2021-07-30 | Bleckley | Georgia | 13023 | 1633 | 52 |
1566868 | 1566868 | 2021-07-30 | Brantley | Georgia | 13025 | 1787 | 41 |
1566869 | 1566869 | 2021-07-30 | Brooks | Georgia | 13027 | 1546 | 50 |
1566870 | 1566870 | 2021-07-30 | Bryan | Georgia | 13029 | 4044 | 42 |
1566871 | 1566871 | 2021-07-30 | Bulloch | Georgia | 13031 | 7227 | 122 |
1566872 | 1566872 | 2021-07-30 | Burke | Georgia | 13033 | 2740 | 65 |
1566873 | 1566873 | 2021-07-30 | Butts | Georgia | 13035 | 3306 | 90 |
1566874 | 1566874 | 2021-07-30 | Calhoun | Georgia | 13037 | 607 | 16 |
1566875 | 1566875 | 2021-07-30 | Camden | Georgia | 13039 | 4937 | 43 |
1566876 | 1566876 | 2021-07-30 | Candler | Georgia | 13043 | 1043 | 68 |
1566877 | 1566877 | 2021-07-30 | Carroll | Georgia | 13045 | 12087 | 247 |
1566878 | 1566878 | 2021-07-30 | Catoosa | Georgia | 13047 | 6938 | 77 |
1566879 | 1566879 | 2021-07-30 | Charlton | Georgia | 13049 | 1785 | 36 |
1566880 | 1566880 | 2021-07-30 | Chatham | Georgia | 13051 | 25328 | 473 |
1566881 | 1566881 | 2021-07-30 | Chattahoochee | Georgia | 13053 | 4901 | 17 |
1566882 | 1566882 | 2021-07-30 | Chattooga | Georgia | 13055 | 3006 | 76 |
1566883 | 1566883 | 2021-07-30 | Cherokee | Georgia | 13057 | 32750 | 338 |
1566884 | 1566884 | 2021-07-30 | Clarke | Georgia | 13059 | 15602 | 149 |
1566885 | 1566885 | 2021-07-30 | Clay | Georgia | 13061 | 245 | 3 |
1566886 | 1566886 | 2021-07-30 | Clayton | Georgia | 13063 | 28750 | 528 |
1566887 | 1566887 | 2021-07-30 | Clinch | Georgia | 13065 | 1020 | 27 |
1566888 | 1566888 | 2021-07-30 | Cobb | Georgia | 13067 | 83362 | 1124 |
1566889 | 1566889 | 2021-07-30 | Coffee | Georgia | 13069 | 5764 | 182 |
1566890 | 1566890 | 2021-07-30 | Colquitt | Georgia | 13071 | 5140 | 131 |
1566891 | 1566891 | 2021-07-30 | Columbia | Georgia | 13073 | 17791 | 212 |
1566892 | 1566892 | 2021-07-30 | Cook | Georgia | 13075 | 2089 | 43 |
1566893 | 1566893 | 2021-07-30 | Coweta | Georgia | 13077 | 15024 | 236 |
1566894 | 1566894 | 2021-07-30 | Crawford | Georgia | 13079 | 714 | 21 |
1566895 | 1566895 | 2021-07-30 | Crisp | Georgia | 13081 | 2177 | 91 |
1566896 | 1566896 | 2021-07-30 | Dade | Georgia | 13083 | 1522 | 14 |
1566897 | 1566897 | 2021-07-30 | Dawson | Georgia | 13085 | 3205 | 49 |
1566898 | 1566898 | 2021-07-30 | DeKalb | Georgia | 13089 | 70064 | 1085 |
1566899 | 1566899 | 2021-07-30 | Decatur | Georgia | 13087 | 3137 | 75 |
1566900 | 1566900 | 2021-07-30 | Dodge | Georgia | 13091 | 2250 | 109 |
1566901 | 1566901 | 2021-07-30 | Dooly | Georgia | 13093 | 1128 | 44 |
1566902 | 1566902 | 2021-07-30 | Dougherty | Georgia | 13095 | 8032 | 312 |
1566903 | 1566903 | 2021-07-30 | Douglas | Georgia | 13097 | 16302 | 233 |
1566904 | 1566904 | 2021-07-30 | Early | Georgia | 13099 | 1264 | 47 |
1566905 | 1566905 | 2021-07-30 | Echols | Georgia | 13101 | 532 | 9 |
1566906 | 1566906 | 2021-07-30 | Effingham | Georgia | 13103 | 5056 | 76 |
1566907 | 1566907 | 2021-07-30 | Elbert | Georgia | 13105 | 2350 | 74 |
1566908 | 1566908 | 2021-07-30 | Emanuel | Georgia | 13107 | 2744 | 84 |
1566909 | 1566909 | 2021-07-30 | Evans | Georgia | 13109 | 1109 | 33 |
1566910 | 1566910 | 2021-07-30 | Fannin | Georgia | 13111 | 2578 | 75 |
1566911 | 1566911 | 2021-07-30 | Fayette | Georgia | 13113 | 9581 | 178 |
1566912 | 1566912 | 2021-07-30 | Floyd | Georgia | 13115 | 12523 | 242 |
1566913 | 1566913 | 2021-07-30 | Forsyth | Georgia | 13117 | 24044 | 205 |
1566914 | 1566914 | 2021-07-30 | Franklin | Georgia | 13119 | 2825 | 57 |
1566915 | 1566915 | 2021-07-30 | Fulton | Georgia | 13121 | 103372 | 1492 |
1566916 | 1566916 | 2021-07-30 | Gilmer | Georgia | 13123 | 3143 | 91 |
1566917 | 1566917 | 2021-07-30 | Glascock | Georgia | 13125 | 275 | 19 |
1566918 | 1566918 | 2021-07-30 | Glynn | Georgia | 13127 | 8939 | 181 |
1566919 | 1566919 | 2021-07-30 | Gordon | Georgia | 13129 | 8522 | 120 |
1566920 | 1566920 | 2021-07-30 | Grady | Georgia | 13131 | 2430 | 66 |
1566921 | 1566921 | 2021-07-30 | Greene | Georgia | 13133 | 1889 | 62 |
1566922 | 1566922 | 2021-07-30 | Gwinnett | Georgia | 13135 | 106048 | 1216 |
1566923 | 1566923 | 2021-07-30 | Habersham | Georgia | 13137 | 5319 | 165 |
1566924 | 1566924 | 2021-07-30 | Hall | Georgia | 13139 | 28673 | 500 |
1566925 | 1566925 | 2021-07-30 | Hancock | Georgia | 13141 | 949 | 69 |
1566926 | 1566926 | 2021-07-30 | Haralson | Georgia | 13143 | 2805 | 91 |
1566927 | 1566927 | 2021-07-30 | Harris | Georgia | 13145 | 2768 | 65 |
1566928 | 1566928 | 2021-07-30 | Hart | Georgia | 13147 | 2521 | 56 |
1566929 | 1566929 | 2021-07-30 | Heard | Georgia | 13149 | 945 | 23 |
1566930 | 1566930 | 2021-07-30 | Henry | Georgia | 13151 | 27326 | 340 |
1566931 | 1566931 | 2021-07-30 | Houston | Georgia | 13153 | 15806 | 274 |
1566932 | 1566932 | 2021-07-30 | Irwin | Georgia | 13155 | 1070 | 31 |
1566933 | 1566933 | 2021-07-30 | Jackson | Georgia | 13157 | 10338 | 153 |
1566934 | 1566934 | 2021-07-30 | Jasper | Georgia | 13159 | 1454 | 40 |
1566935 | 1566935 | 2021-07-30 | Jeff Davis | Georgia | 13161 | 2022 | 45 |
1566936 | 1566936 | 2021-07-30 | Jefferson | Georgia | 13163 | 2010 | 69 |
1566937 | 1566937 | 2021-07-30 | Jenkins | Georgia | 13165 | 908 | 44 |
1566938 | 1566938 | 2021-07-30 | Johnson | Georgia | 13167 | 1175 | 50 |
1566939 | 1566939 | 2021-07-30 | Jones | Georgia | 13169 | 2152 | 61 |
1566940 | 1566940 | 2021-07-30 | Lamar | Georgia | 13171 | 2167 | 59 |
1566941 | 1566941 | 2021-07-30 | Lanier | Georgia | 13173 | 840 | 14 |
1566942 | 1566942 | 2021-07-30 | Laurens | Georgia | 13175 | 6007 | 173 |
1566943 | 1566943 | 2021-07-30 | Lee | Georgia | 13177 | 2968 | 59 |
1566944 | 1566944 | 2021-07-30 | Liberty | Georgia | 13179 | 4514 | 68 |
1566945 | 1566945 | 2021-07-30 | Lincoln | Georgia | 13181 | 858 | 28 |
1566946 | 1566946 | 2021-07-30 | Long | Georgia | 13183 | 982 | 14 |
1566947 | 1566947 | 2021-07-30 | Lowndes | Georgia | 13185 | 13994 | 220 |
1566948 | 1566948 | 2021-07-30 | Lumpkin | Georgia | 13187 | 3140 | 83 |
1566949 | 1566949 | 2021-07-30 | Macon | Georgia | 13193 | 902 | 37 |
1566950 | 1566950 | 2021-07-30 | Madison | Georgia | 13195 | 3378 | 56 |
1566951 | 1566951 | 2021-07-30 | Marion | Georgia | 13197 | 617 | 26 |
1566952 | 1566952 | 2021-07-30 | McDuffie | Georgia | 13189 | 2628 | 52 |
1566953 | 1566953 | 2021-07-30 | McIntosh | Georgia | 13191 | 897 | 16 |
1566954 | 1566954 | 2021-07-30 | Meriwether | Georgia | 13199 | 2137 | 92 |
1566955 | 1566955 | 2021-07-30 | Miller | Georgia | 13201 | 874 | 14 |
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);