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-06-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 |
---|---|---|---|---|---|---|---|
1391556 | 1391556 | 2021-06-06 | Appling | Georgia | 13001 | 2324 | 72 |
1391557 | 1391557 | 2021-06-06 | Atkinson | Georgia | 13003 | 1037 | 22 |
1391558 | 1391558 | 2021-06-06 | Bacon | Georgia | 13005 | 1662 | 39 |
1391559 | 1391559 | 2021-06-06 | Baker | Georgia | 13007 | 230 | 9 |
1391560 | 1391560 | 2021-06-06 | Baldwin | Georgia | 13009 | 4588 | 133 |
1391561 | 1391561 | 2021-06-06 | Banks | Georgia | 13011 | 1863 | 40 |
1391562 | 1391562 | 2021-06-06 | Barrow | Georgia | 13013 | 10165 | 141 |
1391563 | 1391563 | 2021-06-06 | Bartow | Georgia | 13015 | 14970 | 234 |
1391564 | 1391564 | 2021-06-06 | Ben Hill | Georgia | 13017 | 2131 | 81 |
1391565 | 1391565 | 2021-06-06 | Berrien | Georgia | 13019 | 1876 | 46 |
1391566 | 1391566 | 2021-06-06 | Bibb | Georgia | 13021 | 16091 | 460 |
1391567 | 1391567 | 2021-06-06 | Bleckley | Georgia | 13023 | 1492 | 51 |
1391568 | 1391568 | 2021-06-06 | Brantley | Georgia | 13025 | 1657 | 40 |
1391569 | 1391569 | 2021-06-06 | Brooks | Georgia | 13027 | 1416 | 48 |
1391570 | 1391570 | 2021-06-06 | Bryan | Georgia | 13029 | 3709 | 41 |
1391571 | 1391571 | 2021-06-06 | Bulloch | Georgia | 13031 | 6865 | 120 |
1391572 | 1391572 | 2021-06-06 | Burke | Georgia | 13033 | 2611 | 64 |
1391573 | 1391573 | 2021-06-06 | Butts | Georgia | 13035 | 3184 | 88 |
1391574 | 1391574 | 2021-06-06 | Calhoun | Georgia | 13037 | 585 | 15 |
1391575 | 1391575 | 2021-06-06 | Camden | Georgia | 13039 | 4023 | 38 |
1391576 | 1391576 | 2021-06-06 | Candler | Georgia | 13043 | 978 | 67 |
1391577 | 1391577 | 2021-06-06 | Carroll | Georgia | 13045 | 11532 | 244 |
1391578 | 1391578 | 2021-06-06 | Catoosa | Georgia | 13047 | 6655 | 71 |
1391579 | 1391579 | 2021-06-06 | Charlton | Georgia | 13049 | 1563 | 34 |
1391580 | 1391580 | 2021-06-06 | Chatham | Georgia | 13051 | 23556 | 464 |
1391581 | 1391581 | 2021-06-06 | Chattahoochee | Georgia | 13053 | 4279 | 16 |
1391582 | 1391582 | 2021-06-06 | Chattooga | Georgia | 13055 | 2901 | 74 |
1391583 | 1391583 | 2021-06-06 | Cherokee | Georgia | 13057 | 31651 | 331 |
1391584 | 1391584 | 2021-06-06 | Clarke | Georgia | 13059 | 15172 | 148 |
1391585 | 1391585 | 2021-06-06 | Clay | Georgia | 13061 | 237 | 3 |
1391586 | 1391586 | 2021-06-06 | Clayton | Georgia | 13063 | 27269 | 507 |
1391587 | 1391587 | 2021-06-06 | Clinch | Georgia | 13065 | 987 | 27 |
1391588 | 1391588 | 2021-06-06 | Cobb | Georgia | 13067 | 80098 | 1088 |
1391589 | 1391589 | 2021-06-06 | Coffee | Georgia | 13069 | 5350 | 174 |
1391590 | 1391590 | 2021-06-06 | Colquitt | Georgia | 13071 | 4797 | 125 |
1391591 | 1391591 | 2021-06-06 | Columbia | Georgia | 13073 | 17067 | 210 |
1391592 | 1391592 | 2021-06-06 | Cook | Georgia | 13075 | 1841 | 44 |
1391593 | 1391593 | 2021-06-06 | Coweta | Georgia | 13077 | 14301 | 225 |
1391594 | 1391594 | 2021-06-06 | Crawford | Georgia | 13079 | 656 | 21 |
1391595 | 1391595 | 2021-06-06 | Crisp | Georgia | 13081 | 2105 | 85 |
1391596 | 1391596 | 2021-06-06 | Dade | Georgia | 13083 | 1489 | 14 |
1391597 | 1391597 | 2021-06-06 | Dawson | Georgia | 13085 | 3129 | 48 |
1391598 | 1391598 | 2021-06-06 | DeKalb | Georgia | 13089 | 67265 | 1052 |
1391599 | 1391599 | 2021-06-06 | Decatur | Georgia | 13087 | 2977 | 70 |
1391600 | 1391600 | 2021-06-06 | Dodge | Georgia | 13091 | 2147 | 104 |
1391601 | 1391601 | 2021-06-06 | Dooly | Georgia | 13093 | 1090 | 46 |
1391602 | 1391602 | 2021-06-06 | Dougherty | Georgia | 13095 | 7681 | 308 |
1391603 | 1391603 | 2021-06-06 | Douglas | Georgia | 13097 | 15524 | 227 |
1391604 | 1391604 | 2021-06-06 | Early | Georgia | 13099 | 1191 | 48 |
1391605 | 1391605 | 2021-06-06 | Echols | Georgia | 13101 | 481 | 9 |
1391606 | 1391606 | 2021-06-06 | Effingham | Georgia | 13103 | 4685 | 69 |
1391607 | 1391607 | 2021-06-06 | Elbert | Georgia | 13105 | 2306 | 74 |
1391608 | 1391608 | 2021-06-06 | Emanuel | Georgia | 13107 | 2583 | 82 |
1391609 | 1391609 | 2021-06-06 | Evans | Georgia | 13109 | 979 | 29 |
1391610 | 1391610 | 2021-06-06 | Fannin | Georgia | 13111 | 2420 | 74 |
1391611 | 1391611 | 2021-06-06 | Fayette | Georgia | 13113 | 9099 | 176 |
1391612 | 1391612 | 2021-06-06 | Floyd | Georgia | 13115 | 12132 | 235 |
1391613 | 1391613 | 2021-06-06 | Forsyth | Georgia | 13117 | 23179 | 201 |
1391614 | 1391614 | 2021-06-06 | Franklin | Georgia | 13119 | 2713 | 52 |
1391615 | 1391615 | 2021-06-06 | Fulton | Georgia | 13121 | 98848 | 1435 |
1391616 | 1391616 | 2021-06-06 | Gilmer | Georgia | 13123 | 3027 | 87 |
1391617 | 1391617 | 2021-06-06 | Glascock | Georgia | 13125 | 269 | 19 |
1391618 | 1391618 | 2021-06-06 | Glynn | Georgia | 13127 | 8287 | 178 |
1391619 | 1391619 | 2021-06-06 | Gordon | Georgia | 13129 | 8292 | 117 |
1391620 | 1391620 | 2021-06-06 | Grady | Georgia | 13131 | 2253 | 62 |
1391621 | 1391621 | 2021-06-06 | Greene | Georgia | 13133 | 1845 | 62 |
1391622 | 1391622 | 2021-06-06 | Gwinnett | Georgia | 13135 | 102858 | 1190 |
1391623 | 1391623 | 2021-06-06 | Habersham | Georgia | 13137 | 5202 | 161 |
1391624 | 1391624 | 2021-06-06 | Hall | Georgia | 13139 | 27738 | 483 |
1391625 | 1391625 | 2021-06-06 | Hancock | Georgia | 13141 | 929 | 68 |
1391626 | 1391626 | 2021-06-06 | Haralson | Georgia | 13143 | 2673 | 87 |
1391627 | 1391627 | 2021-06-06 | Harris | Georgia | 13145 | 2625 | 61 |
1391628 | 1391628 | 2021-06-06 | Hart | Georgia | 13147 | 2404 | 56 |
1391629 | 1391629 | 2021-06-06 | Heard | Georgia | 13149 | 885 | 22 |
1391630 | 1391630 | 2021-06-06 | Henry | Georgia | 13151 | 25781 | 333 |
1391631 | 1391631 | 2021-06-06 | Houston | Georgia | 13153 | 14868 | 267 |
1391632 | 1391632 | 2021-06-06 | Irwin | Georgia | 13155 | 982 | 30 |
1391633 | 1391633 | 2021-06-06 | Jackson | Georgia | 13157 | 9972 | 147 |
1391634 | 1391634 | 2021-06-06 | Jasper | Georgia | 13159 | 1417 | 38 |
1391635 | 1391635 | 2021-06-06 | Jeff Davis | Georgia | 13161 | 1906 | 43 |
1391636 | 1391636 | 2021-06-06 | Jefferson | Georgia | 13163 | 1968 | 69 |
1391637 | 1391637 | 2021-06-06 | Jenkins | Georgia | 13165 | 857 | 44 |
1391638 | 1391638 | 2021-06-06 | Johnson | Georgia | 13167 | 1127 | 50 |
1391639 | 1391639 | 2021-06-06 | Jones | Georgia | 13169 | 2055 | 57 |
1391640 | 1391640 | 2021-06-06 | Lamar | Georgia | 13171 | 2061 | 58 |
1391641 | 1391641 | 2021-06-06 | Lanier | Georgia | 13173 | 796 | 13 |
1391642 | 1391642 | 2021-06-06 | Laurens | Georgia | 13175 | 5657 | 170 |
1391643 | 1391643 | 2021-06-06 | Lee | Georgia | 13177 | 2769 | 58 |
1391644 | 1391644 | 2021-06-06 | Liberty | Georgia | 13179 | 4157 | 65 |
1391645 | 1391645 | 2021-06-06 | Lincoln | Georgia | 13181 | 832 | 28 |
1391646 | 1391646 | 2021-06-06 | Long | Georgia | 13183 | 879 | 13 |
1391647 | 1391647 | 2021-06-06 | Lowndes | Georgia | 13185 | 12910 | 213 |
1391648 | 1391648 | 2021-06-06 | Lumpkin | Georgia | 13187 | 3034 | 76 |
1391649 | 1391649 | 2021-06-06 | Macon | Georgia | 13193 | 887 | 35 |
1391650 | 1391650 | 2021-06-06 | Madison | Georgia | 13195 | 3282 | 57 |
1391651 | 1391651 | 2021-06-06 | Marion | Georgia | 13197 | 568 | 22 |
1391652 | 1391652 | 2021-06-06 | McDuffie | Georgia | 13189 | 2527 | 50 |
1391653 | 1391653 | 2021-06-06 | McIntosh | Georgia | 13191 | 869 | 16 |
1391654 | 1391654 | 2021-06-06 | Meriwether | Georgia | 13199 | 2054 | 88 |
1391655 | 1391655 | 2021-06-06 | Miller | Georgia | 13201 | 855 | 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);