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-04-23 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1248711 | 1248711 | 2021-04-23 | Appling | Georgia | 13001 | 2296 | 71 |
1248712 | 1248712 | 2021-04-23 | Atkinson | Georgia | 13003 | 1022 | 19 |
1248713 | 1248713 | 2021-04-23 | Bacon | Georgia | 13005 | 1643 | 36 |
1248714 | 1248714 | 2021-04-23 | Baker | Georgia | 13007 | 227 | 9 |
1248715 | 1248715 | 2021-04-23 | Baldwin | Georgia | 13009 | 4473 | 128 |
1248716 | 1248716 | 2021-04-23 | Banks | Georgia | 13011 | 1819 | 35 |
1248717 | 1248717 | 2021-04-23 | Barrow | Georgia | 13013 | 9782 | 133 |
1248718 | 1248718 | 2021-04-23 | Bartow | Georgia | 13015 | 14569 | 223 |
1248719 | 1248719 | 2021-04-23 | Ben Hill | Georgia | 13017 | 2093 | 79 |
1248720 | 1248720 | 2021-04-23 | Berrien | Georgia | 13019 | 1821 | 43 |
1248721 | 1248721 | 2021-04-23 | Bibb | Georgia | 13021 | 15717 | 438 |
1248722 | 1248722 | 2021-04-23 | Bleckley | Georgia | 13023 | 1463 | 51 |
1248723 | 1248723 | 2021-04-23 | Brantley | Georgia | 13025 | 1603 | 37 |
1248724 | 1248724 | 2021-04-23 | Brooks | Georgia | 13027 | 1380 | 47 |
1248725 | 1248725 | 2021-04-23 | Bryan | Georgia | 13029 | 3579 | 37 |
1248726 | 1248726 | 2021-04-23 | Bulloch | Georgia | 13031 | 6750 | 112 |
1248727 | 1248727 | 2021-04-23 | Burke | Georgia | 13033 | 2552 | 60 |
1248728 | 1248728 | 2021-04-23 | Butts | Georgia | 13035 | 3038 | 81 |
1248729 | 1248729 | 2021-04-23 | Calhoun | Georgia | 13037 | 581 | 15 |
1248730 | 1248730 | 2021-04-23 | Camden | Georgia | 13039 | 3917 | 34 |
1248731 | 1248731 | 2021-04-23 | Candler | Georgia | 13043 | 940 | 65 |
1248732 | 1248732 | 2021-04-23 | Carroll | Georgia | 13045 | 11248 | 235 |
1248733 | 1248733 | 2021-04-23 | Catoosa | Georgia | 13047 | 6309 | 68 |
1248734 | 1248734 | 2021-04-23 | Charlton | Georgia | 13049 | 1359 | 33 |
1248735 | 1248735 | 2021-04-23 | Chatham | Georgia | 13051 | 22882 | 439 |
1248736 | 1248736 | 2021-04-23 | Chattahoochee | Georgia | 13053 | 3851 | 15 |
1248737 | 1248737 | 2021-04-23 | Chattooga | Georgia | 13055 | 2797 | 68 |
1248738 | 1248738 | 2021-04-23 | Cherokee | Georgia | 13057 | 30701 | 314 |
1248739 | 1248739 | 2021-04-23 | Clarke | Georgia | 13059 | 14910 | 143 |
1248740 | 1248740 | 2021-04-23 | Clay | Georgia | 13061 | 237 | 3 |
1248741 | 1248741 | 2021-04-23 | Clayton | Georgia | 13063 | 25960 | 461 |
1248742 | 1248742 | 2021-04-23 | Clinch | Georgia | 13065 | 965 | 26 |
1248743 | 1248743 | 2021-04-23 | Cobb | Georgia | 13067 | 77293 | 1029 |
1248744 | 1248744 | 2021-04-23 | Coffee | Georgia | 13069 | 5316 | 170 |
1248745 | 1248745 | 2021-04-23 | Colquitt | Georgia | 13071 | 4668 | 114 |
1248746 | 1248746 | 2021-04-23 | Columbia | Georgia | 13073 | 16656 | 199 |
1248747 | 1248747 | 2021-04-23 | Cook | Georgia | 13075 | 1815 | 42 |
1248748 | 1248748 | 2021-04-23 | Coweta | Georgia | 13077 | 13900 | 216 |
1248749 | 1248749 | 2021-04-23 | Crawford | Georgia | 13079 | 657 | 19 |
1248750 | 1248750 | 2021-04-23 | Crisp | Georgia | 13081 | 2063 | 78 |
1248751 | 1248751 | 2021-04-23 | Dade | Georgia | 13083 | 1426 | 12 |
1248752 | 1248752 | 2021-04-23 | Dawson | Georgia | 13085 | 3025 | 42 |
1248753 | 1248753 | 2021-04-23 | DeKalb | Georgia | 13089 | 64637 | 977 |
1248754 | 1248754 | 2021-04-23 | Decatur | Georgia | 13087 | 2915 | 68 |
1248755 | 1248755 | 2021-04-23 | Dodge | Georgia | 13091 | 2128 | 102 |
1248756 | 1248756 | 2021-04-23 | Dooly | Georgia | 13093 | 1063 | 44 |
1248757 | 1248757 | 2021-04-23 | Dougherty | Georgia | 13095 | 7433 | 300 |
1248758 | 1248758 | 2021-04-23 | Douglas | Georgia | 13097 | 14909 | 210 |
1248759 | 1248759 | 2021-04-23 | Early | Georgia | 13099 | 1170 | 48 |
1248760 | 1248760 | 2021-04-23 | Echols | Georgia | 13101 | 471 | 9 |
1248761 | 1248761 | 2021-04-23 | Effingham | Georgia | 13103 | 4536 | 67 |
1248762 | 1248762 | 2021-04-23 | Elbert | Georgia | 13105 | 2285 | 71 |
1248763 | 1248763 | 2021-04-23 | Emanuel | Georgia | 13107 | 2532 | 81 |
1248764 | 1248764 | 2021-04-23 | Evans | Georgia | 13109 | 955 | 29 |
1248765 | 1248765 | 2021-04-23 | Fannin | Georgia | 13111 | 2367 | 69 |
1248766 | 1248766 | 2021-04-23 | Fayette | Georgia | 13113 | 8794 | 166 |
1248767 | 1248767 | 2021-04-23 | Floyd | Georgia | 13115 | 11933 | 217 |
1248768 | 1248768 | 2021-04-23 | Forsyth | Georgia | 13117 | 22451 | 184 |
1248769 | 1248769 | 2021-04-23 | Franklin | Georgia | 13119 | 2652 | 50 |
1248770 | 1248770 | 2021-04-23 | Fulton | Georgia | 13121 | 95428 | 1347 |
1248771 | 1248771 | 2021-04-23 | Gilmer | Georgia | 13123 | 2928 | 83 |
1248772 | 1248772 | 2021-04-23 | Glascock | Georgia | 13125 | 265 | 19 |
1248773 | 1248773 | 2021-04-23 | Glynn | Georgia | 13127 | 8048 | 171 |
1248774 | 1248774 | 2021-04-23 | Gordon | Georgia | 13129 | 8127 | 112 |
1248775 | 1248775 | 2021-04-23 | Grady | Georgia | 13131 | 2110 | 59 |
1248776 | 1248776 | 2021-04-23 | Greene | Georgia | 13133 | 1816 | 64 |
1248777 | 1248777 | 2021-04-23 | Gwinnett | Georgia | 13135 | 99977 | 1124 |
1248778 | 1248778 | 2021-04-23 | Habersham | Georgia | 13137 | 5143 | 159 |
1248779 | 1248779 | 2021-04-23 | Hall | Georgia | 13139 | 27046 | 457 |
1248780 | 1248780 | 2021-04-23 | Hancock | Georgia | 13141 | 914 | 65 |
1248781 | 1248781 | 2021-04-23 | Haralson | Georgia | 13143 | 2619 | 81 |
1248782 | 1248782 | 2021-04-23 | Harris | Georgia | 13145 | 2512 | 57 |
1248783 | 1248783 | 2021-04-23 | Hart | Georgia | 13147 | 2362 | 52 |
1248784 | 1248784 | 2021-04-23 | Heard | Georgia | 13149 | 856 | 19 |
1248785 | 1248785 | 2021-04-23 | Henry | Georgia | 13151 | 24764 | 318 |
1248786 | 1248786 | 2021-04-23 | Houston | Georgia | 13153 | 14403 | 250 |
1248787 | 1248787 | 2021-04-23 | Irwin | Georgia | 13155 | 918 | 28 |
1248788 | 1248788 | 2021-04-23 | Jackson | Georgia | 13157 | 9741 | 148 |
1248789 | 1248789 | 2021-04-23 | Jasper | Georgia | 13159 | 1387 | 38 |
1248790 | 1248790 | 2021-04-23 | Jeff Davis | Georgia | 13161 | 1878 | 45 |
1248791 | 1248791 | 2021-04-23 | Jefferson | Georgia | 13163 | 1938 | 66 |
1248792 | 1248792 | 2021-04-23 | Jenkins | Georgia | 13165 | 847 | 43 |
1248793 | 1248793 | 2021-04-23 | Johnson | Georgia | 13167 | 1116 | 49 |
1248794 | 1248794 | 2021-04-23 | Jones | Georgia | 13169 | 1989 | 57 |
1248795 | 1248795 | 2021-04-23 | Lamar | Georgia | 13171 | 2021 | 55 |
1248796 | 1248796 | 2021-04-23 | Lanier | Georgia | 13173 | 770 | 13 |
1248797 | 1248797 | 2021-04-23 | Laurens | Georgia | 13175 | 5559 | 166 |
1248798 | 1248798 | 2021-04-23 | Lee | Georgia | 13177 | 2708 | 58 |
1248799 | 1248799 | 2021-04-23 | Liberty | Georgia | 13179 | 3910 | 62 |
1248800 | 1248800 | 2021-04-23 | Lincoln | Georgia | 13181 | 799 | 26 |
1248801 | 1248801 | 2021-04-23 | Long | Georgia | 13183 | 838 | 11 |
1248802 | 1248802 | 2021-04-23 | Lowndes | Georgia | 13185 | 12502 | 205 |
1248803 | 1248803 | 2021-04-23 | Lumpkin | Georgia | 13187 | 2948 | 68 |
1248804 | 1248804 | 2021-04-23 | Macon | Georgia | 13193 | 851 | 29 |
1248805 | 1248805 | 2021-04-23 | Madison | Georgia | 13195 | 3212 | 56 |
1248806 | 1248806 | 2021-04-23 | Marion | Georgia | 13197 | 558 | 19 |
1248807 | 1248807 | 2021-04-23 | McDuffie | Georgia | 13189 | 2440 | 48 |
1248808 | 1248808 | 2021-04-23 | McIntosh | Georgia | 13191 | 851 | 16 |
1248809 | 1248809 | 2021-04-23 | Meriwether | Georgia | 13199 | 1979 | 84 |
1248810 | 1248810 | 2021-04-23 | Miller | Georgia | 13201 | 849 | 13 |
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);