ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

54,809 rows where state = "Georgia" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Georgia · 54,809 ✖
Link rowid date ▲ county state fips cases deaths
1076615 1076615 2021-03-01 Appling Georgia 13001 2217 64
1076616 1076616 2021-03-01 Atkinson Georgia 13003 984 19
1076617 1076617 2021-03-01 Bacon Georgia 13005 1360 34
1076618 1076618 2021-03-01 Baker Georgia 13007 221 7
1076619 1076619 2021-03-01 Baldwin Georgia 13009 4288 109
1076620 1076620 2021-03-01 Banks Georgia 13011 1731 34
1076621 1076621 2021-03-01 Barrow Georgia 13013 8980 117
1076622 1076622 2021-03-01 Bartow Georgia 13015 13141 198
1076623 1076623 2021-03-01 Ben Hill Georgia 13017 2044 73
1076624 1076624 2021-03-01 Berrien Georgia 13019 1726 41
1076625 1076625 2021-03-01 Bibb Georgia 13021 14928 380
1076626 1076626 2021-03-01 Bleckley Georgia 13023 1434 49
1076627 1076627 2021-03-01 Brantley Georgia 13025 1516 29
1076628 1076628 2021-03-01 Brooks Georgia 13027 1308 45
1076629 1076629 2021-03-01 Bryan Georgia 13029 3235 33
1076630 1076630 2021-03-01 Bulloch Georgia 13031 6439 91
1076631 1076631 2021-03-01 Burke Georgia 13033 2392 52
1076632 1076632 2021-03-01 Butts Georgia 13035 2684 73
1076633 1076633 2021-03-01 Calhoun Georgia 13037 578 15
1076634 1076634 2021-03-01 Camden Georgia 13039 3708 31
1076635 1076635 2021-03-01 Candler Georgia 13043 917 59
1076636 1076636 2021-03-01 Carroll Georgia 13045 10575 213
1076637 1076637 2021-03-01 Catoosa Georgia 13047 5670 63
1076638 1076638 2021-03-01 Charlton Georgia 13049 1308 27
1076639 1076639 2021-03-01 Chatham Georgia 13051 20952 369
1076640 1076640 2021-03-01 Chattahoochee Georgia 13053 3080 11
1076641 1076641 2021-03-01 Chattooga Georgia 13055 2600 66
1076642 1076642 2021-03-01 Cherokee Georgia 13057 27637 265
1076643 1076643 2021-03-01 Clarke Georgia 13059 14118 119
1076644 1076644 2021-03-01 Clay Georgia 13061 232 3
1076645 1076645 2021-03-01 Clayton Georgia 13063 23329 389
1076646 1076646 2021-03-01 Clinch Georgia 13065 914 24
1076647 1076647 2021-03-01 Cobb Georgia 13067 69901 915
1076648 1076648 2021-03-01 Coffee Georgia 13069 5216 150
1076649 1076649 2021-03-01 Colquitt Georgia 13071 4436 101
1076650 1076650 2021-03-01 Columbia Georgia 13073 15762 187
1076651 1076651 2021-03-01 Cook Georgia 13075 1723 40
1076652 1076652 2021-03-01 Coweta Georgia 13077 12959 163
1076653 1076653 2021-03-01 Crawford Georgia 13079 620 16
1076654 1076654 2021-03-01 Crisp Georgia 13081 1917 60
1076655 1076655 2021-03-01 Dade Georgia 13083 1298 10
1076656 1076656 2021-03-01 Dawson Georgia 13085 2835 35
1076657 1076657 2021-03-01 DeKalb Georgia 13089 57411 834
1076658 1076658 2021-03-01 Decatur Georgia 13087 2752 65
1076659 1076659 2021-03-01 Dodge Georgia 13091 2096 98
1076660 1076660 2021-03-01 Dooly Georgia 13093 993 40
1076661 1076661 2021-03-01 Dougherty Georgia 13095 7094 279
1076662 1076662 2021-03-01 Douglas Georgia 13097 13468 180
1076663 1076663 2021-03-01 Early Georgia 13099 1128 44
1076664 1076664 2021-03-01 Echols Georgia 13101 458 6
1076665 1076665 2021-03-01 Effingham Georgia 13103 4235 60
1076666 1076666 2021-03-01 Elbert Georgia 13105 2215 63
1076667 1076667 2021-03-01 Emanuel Georgia 13107 2458 78
1076668 1076668 2021-03-01 Evans Georgia 13109 912 22
1076669 1076669 2021-03-01 Fannin Georgia 13111 2190 60
1076670 1076670 2021-03-01 Fayette Georgia 13113 8117 142
1076671 1076671 2021-03-01 Floyd Georgia 13115 11070 197
1076672 1076672 2021-03-01 Forsyth Georgia 13117 20081 155
1076673 1076673 2021-03-01 Franklin Georgia 13119 2567 44
1076674 1076674 2021-03-01 Fulton Georgia 13121 86060 1127
1076675 1076675 2021-03-01 Gilmer Georgia 13123 2793 74
1076676 1076676 2021-03-01 Glascock Georgia 13125 259 17
1076677 1076677 2021-03-01 Glynn Georgia 13127 7596 160
1076678 1076678 2021-03-01 Gordon Georgia 13129 7582 102
1076679 1076679 2021-03-01 Grady Georgia 13131 2021 55
1076680 1076680 2021-03-01 Greene Georgia 13133 1716 52
1076681 1076681 2021-03-01 Gwinnett Georgia 13135 92484 958
1076682 1076682 2021-03-01 Habersham Georgia 13137 5072 142
1076683 1076683 2021-03-01 Hall Georgia 13139 25727 400
1076684 1076684 2021-03-01 Hancock Georgia 13141 882 57
1076685 1076685 2021-03-01 Haralson Georgia 13143 2457 77
1076686 1076686 2021-03-01 Harris Georgia 13145 2334 48
1076687 1076687 2021-03-01 Hart Georgia 13147 2275 50
1076688 1076688 2021-03-01 Heard Georgia 13149 804 16
1076689 1076689 2021-03-01 Henry Georgia 13151 21880 268
1076690 1076690 2021-03-01 Houston Georgia 13153 13455 223
1076691 1076691 2021-03-01 Irwin Georgia 13155 903 25
1076692 1076692 2021-03-01 Jackson Georgia 13157 9094 131
1076693 1076693 2021-03-01 Jasper Georgia 13159 1304 33
1076694 1076694 2021-03-01 Jeff Davis Georgia 13161 1778 44
1076695 1076695 2021-03-01 Jefferson Georgia 13163 1865 58
1076696 1076696 2021-03-01 Jenkins Georgia 13165 812 39
1076697 1076697 2021-03-01 Johnson Georgia 13167 1092 47
1076698 1076698 2021-03-01 Jones Georgia 13169 1903 43
1076699 1076699 2021-03-01 Lamar Georgia 13171 1888 49
1076700 1076700 2021-03-01 Lanier Georgia 13173 744 12
1076701 1076701 2021-03-01 Laurens Georgia 13175 5400 156
1076702 1076702 2021-03-01 Lee Georgia 13177 2595 51
1076703 1076703 2021-03-01 Liberty Georgia 13179 3150 51
1076704 1076704 2021-03-01 Lincoln Georgia 13181 755 21
1076705 1076705 2021-03-01 Long Georgia 13183 809 12
1076706 1076706 2021-03-01 Lowndes Georgia 13185 11766 186
1076707 1076707 2021-03-01 Lumpkin Georgia 13187 2794 60
1076708 1076708 2021-03-01 Macon Georgia 13193 788 26
1076709 1076709 2021-03-01 Madison Georgia 13195 3067 47
1076710 1076710 2021-03-01 Marion Georgia 13197 533 15
1076711 1076711 2021-03-01 McDuffie Georgia 13189 2295 43
1076712 1076712 2021-03-01 McIntosh Georgia 13191 735 15
1076713 1076713 2021-03-01 Meriwether Georgia 13199 1860 59
1076714 1076714 2021-03-01 Miller Georgia 13201 772 9

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);