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-05-15 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
145579 | 145579 | 2020-05-15 | Appling | Georgia | 13001 | 108 | 10 |
145580 | 145580 | 2020-05-15 | Atkinson | Georgia | 13003 | 20 | 2 |
145581 | 145581 | 2020-05-15 | Bacon | Georgia | 13005 | 59 | 2 |
145582 | 145582 | 2020-05-15 | Baker | Georgia | 13007 | 33 | 2 |
145583 | 145583 | 2020-05-15 | Baldwin | Georgia | 13009 | 282 | 12 |
145584 | 145584 | 2020-05-15 | Banks | Georgia | 13011 | 43 | 0 |
145585 | 145585 | 2020-05-15 | Barrow | Georgia | 13013 | 258 | 8 |
145586 | 145586 | 2020-05-15 | Bartow | Georgia | 13015 | 385 | 35 |
145587 | 145587 | 2020-05-15 | Ben Hill | Georgia | 13017 | 45 | 1 |
145588 | 145588 | 2020-05-15 | Berrien | Georgia | 13019 | 20 | 0 |
145589 | 145589 | 2020-05-15 | Bibb | Georgia | 13021 | 391 | 16 |
145590 | 145590 | 2020-05-15 | Bleckley | Georgia | 13023 | 33 | 0 |
145591 | 145591 | 2020-05-15 | Brantley | Georgia | 13025 | 35 | 2 |
145592 | 145592 | 2020-05-15 | Brooks | Georgia | 13027 | 64 | 8 |
145593 | 145593 | 2020-05-15 | Bryan | Georgia | 13029 | 61 | 4 |
145594 | 145594 | 2020-05-15 | Bulloch | Georgia | 13031 | 45 | 2 |
145595 | 145595 | 2020-05-15 | Burke | Georgia | 13033 | 112 | 3 |
145596 | 145596 | 2020-05-15 | Butts | Georgia | 13035 | 196 | 17 |
145597 | 145597 | 2020-05-15 | Calhoun | Georgia | 13037 | 124 | 7 |
145598 | 145598 | 2020-05-15 | Camden | Georgia | 13039 | 46 | 1 |
145599 | 145599 | 2020-05-15 | Candler | Georgia | 13043 | 10 | 0 |
145600 | 145600 | 2020-05-15 | Carroll | Georgia | 13045 | 408 | 20 |
145601 | 145601 | 2020-05-15 | Catoosa | Georgia | 13047 | 71 | 0 |
145602 | 145602 | 2020-05-15 | Charlton | Georgia | 13049 | 26 | 1 |
145603 | 145603 | 2020-05-15 | Chatham | Georgia | 13051 | 353 | 14 |
145604 | 145604 | 2020-05-15 | Chattahoochee | Georgia | 13053 | 19 | 0 |
145605 | 145605 | 2020-05-15 | Chattooga | Georgia | 13055 | 15 | 2 |
145606 | 145606 | 2020-05-15 | Cherokee | Georgia | 13057 | 695 | 23 |
145607 | 145607 | 2020-05-15 | Clarke | Georgia | 13059 | 197 | 13 |
145608 | 145608 | 2020-05-15 | Clay | Georgia | 13061 | 28 | 3 |
145609 | 145609 | 2020-05-15 | Clayton | Georgia | 13063 | 999 | 38 |
145610 | 145610 | 2020-05-15 | Clinch | Georgia | 13065 | 40 | 1 |
145611 | 145611 | 2020-05-15 | Cobb | Georgia | 13067 | 2395 | 132 |
145612 | 145612 | 2020-05-15 | Coffee | Georgia | 13069 | 192 | 11 |
145613 | 145613 | 2020-05-15 | Colquitt | Georgia | 13071 | 245 | 11 |
145614 | 145614 | 2020-05-15 | Columbia | Georgia | 13073 | 202 | 6 |
145615 | 145615 | 2020-05-15 | Cook | Georgia | 13075 | 32 | 2 |
145616 | 145616 | 2020-05-15 | Coweta | Georgia | 13077 | 282 | 4 |
145617 | 145617 | 2020-05-15 | Crawford | Georgia | 13079 | 19 | 0 |
145618 | 145618 | 2020-05-15 | Crisp | Georgia | 13081 | 193 | 7 |
145619 | 145619 | 2020-05-15 | Dade | Georgia | 13083 | 20 | 1 |
145620 | 145620 | 2020-05-15 | Dawson | Georgia | 13085 | 84 | 1 |
145621 | 145621 | 2020-05-15 | DeKalb | Georgia | 13089 | 2751 | 80 |
145622 | 145622 | 2020-05-15 | Decatur | Georgia | 13087 | 116 | 3 |
145623 | 145623 | 2020-05-15 | Dodge | Georgia | 13091 | 38 | 2 |
145624 | 145624 | 2020-05-15 | Dooly | Georgia | 13093 | 155 | 12 |
145625 | 145625 | 2020-05-15 | Dougherty | Georgia | 13095 | 1662 | 134 |
145626 | 145626 | 2020-05-15 | Douglas | Georgia | 13097 | 433 | 15 |
145627 | 145627 | 2020-05-15 | Early | Georgia | 13099 | 233 | 28 |
145628 | 145628 | 2020-05-15 | Echols | Georgia | 13101 | 15 | 0 |
145629 | 145629 | 2020-05-15 | Effingham | Georgia | 13103 | 38 | 1 |
145630 | 145630 | 2020-05-15 | Elbert | Georgia | 13105 | 46 | 0 |
145631 | 145631 | 2020-05-15 | Emanuel | Georgia | 13107 | 25 | 1 |
145632 | 145632 | 2020-05-15 | Evans | Georgia | 13109 | 4 | 0 |
145633 | 145633 | 2020-05-15 | Fannin | Georgia | 13111 | 36 | 1 |
145634 | 145634 | 2020-05-15 | Fayette | Georgia | 13113 | 205 | 11 |
145635 | 145635 | 2020-05-15 | Floyd | Georgia | 13115 | 172 | 13 |
145636 | 145636 | 2020-05-15 | Forsyth | Georgia | 13117 | 397 | 11 |
145637 | 145637 | 2020-05-15 | Franklin | Georgia | 13119 | 31 | 1 |
145638 | 145638 | 2020-05-15 | Fulton | Georgia | 13121 | 3703 | 164 |
145639 | 145639 | 2020-05-15 | Gilmer | Georgia | 13123 | 105 | 0 |
145640 | 145640 | 2020-05-15 | Glascock | Georgia | 13125 | 1 | 0 |
145641 | 145641 | 2020-05-15 | Glynn | Georgia | 13127 | 77 | 1 |
145642 | 145642 | 2020-05-15 | Gordon | Georgia | 13129 | 125 | 15 |
145643 | 145643 | 2020-05-15 | Grady | Georgia | 13131 | 90 | 4 |
145644 | 145644 | 2020-05-15 | Greene | Georgia | 13133 | 57 | 6 |
145645 | 145645 | 2020-05-15 | Gwinnett | Georgia | 13135 | 2597 | 101 |
145646 | 145646 | 2020-05-15 | Habersham | Georgia | 13137 | 411 | 16 |
145647 | 145647 | 2020-05-15 | Hall | Georgia | 13139 | 2140 | 40 |
145648 | 145648 | 2020-05-15 | Hancock | Georgia | 13141 | 149 | 4 |
145649 | 145649 | 2020-05-15 | Haralson | Georgia | 13143 | 34 | 2 |
145650 | 145650 | 2020-05-15 | Harris | Georgia | 13145 | 75 | 3 |
145651 | 145651 | 2020-05-15 | Hart | Georgia | 13147 | 19 | 0 |
145652 | 145652 | 2020-05-15 | Heard | Georgia | 13149 | 17 | 1 |
145653 | 145653 | 2020-05-15 | Henry | Georgia | 13151 | 628 | 18 |
145654 | 145654 | 2020-05-15 | Houston | Georgia | 13153 | 314 | 16 |
145655 | 145655 | 2020-05-15 | Irwin | Georgia | 13155 | 22 | 1 |
145656 | 145656 | 2020-05-15 | Jackson | Georgia | 13157 | 127 | 3 |
145657 | 145657 | 2020-05-15 | Jasper | Georgia | 13159 | 26 | 0 |
145658 | 145658 | 2020-05-15 | Jeff Davis | Georgia | 13161 | 24 | 1 |
145659 | 145659 | 2020-05-15 | Jefferson | Georgia | 13163 | 22 | 1 |
145660 | 145660 | 2020-05-15 | Jenkins | Georgia | 13165 | 16 | 1 |
145661 | 145661 | 2020-05-15 | Johnson | Georgia | 13167 | 71 | 2 |
145662 | 145662 | 2020-05-15 | Jones | Georgia | 13169 | 30 | 0 |
145663 | 145663 | 2020-05-15 | Lamar | Georgia | 13171 | 41 | 1 |
145664 | 145664 | 2020-05-15 | Lanier | Georgia | 13173 | 12 | 2 |
145665 | 145665 | 2020-05-15 | Laurens | Georgia | 13175 | 87 | 1 |
145666 | 145666 | 2020-05-15 | Lee | Georgia | 13177 | 344 | 23 |
145667 | 145667 | 2020-05-15 | Liberty | Georgia | 13179 | 45 | 0 |
145668 | 145668 | 2020-05-15 | Lincoln | Georgia | 13181 | 12 | 0 |
145669 | 145669 | 2020-05-15 | Long | Georgia | 13183 | 6 | 0 |
145670 | 145670 | 2020-05-15 | Lowndes | Georgia | 13185 | 202 | 4 |
145671 | 145671 | 2020-05-15 | Lumpkin | Georgia | 13187 | 82 | 1 |
145672 | 145672 | 2020-05-15 | Macon | Georgia | 13193 | 90 | 5 |
145673 | 145673 | 2020-05-15 | Madison | Georgia | 13195 | 29 | 1 |
145674 | 145674 | 2020-05-15 | Marion | Georgia | 13197 | 39 | 1 |
145675 | 145675 | 2020-05-15 | McDuffie | Georgia | 13189 | 53 | 4 |
145676 | 145676 | 2020-05-15 | McIntosh | Georgia | 13191 | 9 | 0 |
145677 | 145677 | 2020-05-15 | Meriwether | Georgia | 13199 | 73 | 1 |
145678 | 145678 | 2020-05-15 | Miller | Georgia | 13201 | 38 | 0 |
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);