ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where date = "2021-09-29" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1765018 | 1765018 | 2021-09-29 | Appling | Georgia | 13001 | 3409 | 89 |
1765019 | 1765019 | 2021-09-29 | Atkinson | Georgia | 13003 | 1518 | 27 |
1765020 | 1765020 | 2021-09-29 | Bacon | Georgia | 13005 | 2445 | 52 |
1765021 | 1765021 | 2021-09-29 | Baker | Georgia | 13007 | 361 | 14 |
1765022 | 1765022 | 2021-09-29 | Baldwin | Georgia | 13009 | 6519 | 168 |
1765023 | 1765023 | 2021-09-29 | Banks | Georgia | 13011 | 2646 | 55 |
1765024 | 1765024 | 2021-09-29 | Barrow | Georgia | 13013 | 14093 | 176 |
1765025 | 1765025 | 2021-09-29 | Bartow | Georgia | 13015 | 19808 | 310 |
1765026 | 1765026 | 2021-09-29 | Ben Hill | Georgia | 13017 | 3169 | 94 |
1765027 | 1765027 | 2021-09-29 | Berrien | Georgia | 13019 | 3405 | 58 |
1765028 | 1765028 | 2021-09-29 | Bibb | Georgia | 13021 | 24674 | 566 |
1765029 | 1765029 | 2021-09-29 | Bleckley | Georgia | 13023 | 2271 | 64 |
1765030 | 1765030 | 2021-09-29 | Brantley | Georgia | 13025 | 3084 | 73 |
1765031 | 1765031 | 2021-09-29 | Brooks | Georgia | 13027 | 2374 | 62 |
1765032 | 1765032 | 2021-09-29 | Bryan | Georgia | 13029 | 6196 | 56 |
1765033 | 1765033 | 2021-09-29 | Bulloch | Georgia | 13031 | 11047 | 173 |
1765034 | 1765034 | 2021-09-29 | Burke | Georgia | 13033 | 3670 | 73 |
1765035 | 1765035 | 2021-09-29 | Butts | Georgia | 13035 | 4478 | 97 |
1765036 | 1765036 | 2021-09-29 | Calhoun | Georgia | 13037 | 835 | 21 |
1765037 | 1765037 | 2021-09-29 | Camden | Georgia | 13039 | 7669 | 85 |
1765038 | 1765038 | 2021-09-29 | Candler | Georgia | 13043 | 1558 | 80 |
1765039 | 1765039 | 2021-09-29 | Carroll | Georgia | 13045 | 16015 | 284 |
1765040 | 1765040 | 2021-09-29 | Catoosa | Georgia | 13047 | 9113 | 91 |
1765041 | 1765041 | 2021-09-29 | Charlton | Georgia | 13049 | 2181 | 52 |
1765042 | 1765042 | 2021-09-29 | Chatham | Georgia | 13051 | 37592 | 602 |
1765043 | 1765043 | 2021-09-29 | Chattahoochee | Georgia | 13053 | 5405 | 17 |
1765044 | 1765044 | 2021-09-29 | Chattooga | Georgia | 13055 | 4377 | 91 |
1765045 | 1765045 | 2021-09-29 | Cherokee | Georgia | 13057 | 42353 | 407 |
1765046 | 1765046 | 2021-09-29 | Clarke | Georgia | 13059 | 19540 | 166 |
1765047 | 1765047 | 2021-09-29 | Clay | Georgia | 13061 | 313 | 4 |
1765048 | 1765048 | 2021-09-29 | Clayton | Georgia | 13063 | 37839 | 632 |
1765049 | 1765049 | 2021-09-29 | Clinch | Georgia | 13065 | 1445 | 33 |
1765050 | 1765050 | 2021-09-29 | Cobb | Georgia | 13067 | 105459 | 1268 |
1765051 | 1765051 | 2021-09-29 | Coffee | Georgia | 13069 | 7667 | 205 |
1765052 | 1765052 | 2021-09-29 | Colquitt | Georgia | 13071 | 7399 | 167 |
1765053 | 1765053 | 2021-09-29 | Columbia | Georgia | 13073 | 24069 | 259 |
1765054 | 1765054 | 2021-09-29 | Cook | Georgia | 13075 | 3547 | 54 |
1765055 | 1765055 | 2021-09-29 | Coweta | Georgia | 13077 | 20089 | 300 |
1765056 | 1765056 | 2021-09-29 | Crawford | Georgia | 13079 | 1090 | 37 |
1765057 | 1765057 | 2021-09-29 | Crisp | Georgia | 13081 | 3076 | 105 |
1765058 | 1765058 | 2021-09-29 | Dade | Georgia | 13083 | 2068 | 17 |
1765059 | 1765059 | 2021-09-29 | Dawson | Georgia | 13085 | 4541 | 57 |
1765060 | 1765060 | 2021-09-29 | DeKalb | Georgia | 13089 | 88147 | 1204 |
1765061 | 1765061 | 2021-09-29 | Decatur | Georgia | 13087 | 4609 | 92 |
1765062 | 1765062 | 2021-09-29 | Dodge | Georgia | 13091 | 3534 | 117 |
1765063 | 1765063 | 2021-09-29 | Dooly | Georgia | 13093 | 1597 | 53 |
1765064 | 1765064 | 2021-09-29 | Dougherty | Georgia | 13095 | 11904 | 371 |
1765065 | 1765065 | 2021-09-29 | Douglas | Georgia | 13097 | 21456 | 266 |
1765066 | 1765066 | 2021-09-29 | Early | Georgia | 13099 | 1810 | 56 |
1765067 | 1765067 | 2021-09-29 | Echols | Georgia | 13101 | 709 | 9 |
1765068 | 1765068 | 2021-09-29 | Effingham | Georgia | 13103 | 8751 | 139 |
1765069 | 1765069 | 2021-09-29 | Elbert | Georgia | 13105 | 3094 | 81 |
1765070 | 1765070 | 2021-09-29 | Emanuel | Georgia | 13107 | 4307 | 102 |
1765071 | 1765071 | 2021-09-29 | Evans | Georgia | 13109 | 1592 | 44 |
1765072 | 1765072 | 2021-09-29 | Fannin | Georgia | 13111 | 3607 | 96 |
1765073 | 1765073 | 2021-09-29 | Fayette | Georgia | 13113 | 12710 | 206 |
1765074 | 1765074 | 2021-09-29 | Floyd | Georgia | 13115 | 17712 | 315 |
1765075 | 1765075 | 2021-09-29 | Forsyth | Georgia | 13117 | 32894 | 237 |
1765076 | 1765076 | 2021-09-29 | Franklin | Georgia | 13119 | 3799 | 70 |
1765077 | 1765077 | 2021-09-29 | Fulton | Georgia | 13121 | 127786 | 1632 |
1765078 | 1765078 | 2021-09-29 | Gilmer | Georgia | 13123 | 4402 | 121 |
1765079 | 1765079 | 2021-09-29 | Glascock | Georgia | 13125 | 401 | 19 |
1765080 | 1765080 | 2021-09-29 | Glynn | Georgia | 13127 | 15102 | 309 |
1765081 | 1765081 | 2021-09-29 | Gordon | Georgia | 13129 | 10961 | 171 |
1765082 | 1765082 | 2021-09-29 | Grady | Georgia | 13131 | 3478 | 83 |
1765083 | 1765083 | 2021-09-29 | Greene | Georgia | 13133 | 2626 | 69 |
1765084 | 1765084 | 2021-09-29 | Gwinnett | Georgia | 13135 | 127000 | 1342 |
1765085 | 1765085 | 2021-09-29 | Habersham | Georgia | 13137 | 7176 | 179 |
1765086 | 1765086 | 2021-09-29 | Hall | Georgia | 13139 | 36575 | 572 |
1765087 | 1765087 | 2021-09-29 | Hancock | Georgia | 13141 | 1114 | 75 |
1765088 | 1765088 | 2021-09-29 | Haralson | Georgia | 13143 | 3684 | 103 |
1765089 | 1765089 | 2021-09-29 | Harris | Georgia | 13145 | 3564 | 75 |
1765090 | 1765090 | 2021-09-29 | Hart | Georgia | 13147 | 3399 | 61 |
1765091 | 1765091 | 2021-09-29 | Heard | Georgia | 13149 | 1444 | 32 |
1765092 | 1765092 | 2021-09-29 | Henry | Georgia | 13151 | 36665 | 429 |
1765093 | 1765093 | 2021-09-29 | Houston | Georgia | 13153 | 24159 | 333 |
1765094 | 1765094 | 2021-09-29 | Irwin | Georgia | 13155 | 1417 | 32 |
1765095 | 1765095 | 2021-09-29 | Jackson | Georgia | 13157 | 14171 | 187 |
1765096 | 1765096 | 2021-09-29 | Jasper | Georgia | 13159 | 2065 | 53 |
1765097 | 1765097 | 2021-09-29 | Jeff Davis | Georgia | 13161 | 2887 | 54 |
1765098 | 1765098 | 2021-09-29 | Jefferson | Georgia | 13163 | 2602 | 77 |
1765099 | 1765099 | 2021-09-29 | Jenkins | Georgia | 13165 | 1149 | 49 |
1765100 | 1765100 | 2021-09-29 | Johnson | Georgia | 13167 | 1521 | 57 |
1765101 | 1765101 | 2021-09-29 | Jones | Georgia | 13169 | 3332 | 79 |
1765102 | 1765102 | 2021-09-29 | Lamar | Georgia | 13171 | 3319 | 79 |
1765103 | 1765103 | 2021-09-29 | Lanier | Georgia | 13173 | 1431 | 15 |
1765104 | 1765104 | 2021-09-29 | Laurens | Georgia | 13175 | 8861 | 220 |
1765105 | 1765105 | 2021-09-29 | Lee | Georgia | 13177 | 4551 | 74 |
1765106 | 1765106 | 2021-09-29 | Liberty | Georgia | 13179 | 7120 | 89 |
1765107 | 1765107 | 2021-09-29 | Lincoln | Georgia | 13181 | 1133 | 32 |
1765108 | 1765108 | 2021-09-29 | Long | Georgia | 13183 | 1635 | 19 |
1765109 | 1765109 | 2021-09-29 | Lowndes | Georgia | 13185 | 20736 | 278 |
1765110 | 1765110 | 2021-09-29 | Lumpkin | Georgia | 13187 | 4689 | 90 |
1765111 | 1765111 | 2021-09-29 | Macon | Georgia | 13193 | 1285 | 38 |
1765112 | 1765112 | 2021-09-29 | Madison | Georgia | 13195 | 4776 | 65 |
1765113 | 1765113 | 2021-09-29 | Marion | Georgia | 13197 | 931 | 33 |
1765114 | 1765114 | 2021-09-29 | McDuffie | Georgia | 13189 | 3400 | 66 |
1765115 | 1765115 | 2021-09-29 | McIntosh | Georgia | 13191 | 1684 | 26 |
1765116 | 1765116 | 2021-09-29 | Meriwether | Georgia | 13199 | 2898 | 100 |
1765117 | 1765117 | 2021-09-29 | Miller | Georgia | 13201 | 1184 | 18 |
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);