ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124,889 rows where state = "Georgia" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 13121 803
- 13233 799
- 13067 798
- 13135 798
- 13057 797
- 13089 796
- 13113 796
- 13115 796
- 13049 795
- 13015 794
- 13177 794
- 13185 794
- 13129 792
- 13151 792
- 13077 791
- 13059 790
- 13063 790
- 13095 790
- 13217 790
- 13117 789
- 13139 789
- 13223 789
- 13285 789
- 13245 788
- 13313 788
- 13073 787
- 13153 787
- 13021 786
- 13099 786
- 13103 786
- …
county >30
- Fulton 803
- Polk 799
- Cobb 798
- Gwinnett 798
- Cherokee 797
- DeKalb 796
- Fayette 796
- Floyd 796
- Charlton 795
- Bartow 794
- Lee 794
- Lowndes 794
- Gordon 792
- Henry 792
- Coweta 791
- Clarke 790
- Clayton 790
- Dougherty 790
- Newton 790
- Forsyth 789
- Hall 789
- Paulding 789
- Troup 789
- Richmond 788
- Whitfield 788
- Columbia 787
- Houston 787
- Bibb 786
- Early 786
- Effingham 786
- …
state 1
- Georgia · 124,889 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
19953 | 19953 | 2020-03-30 | Appling | Georgia | 13001 | 2 | 0 |
22032 | 22032 | 2020-03-31 | Appling | Georgia | 13001 | 1 | 0 |
24195 | 24195 | 2020-04-01 | Appling | Georgia | 13001 | 1 | 0 |
26426 | 26426 | 2020-04-02 | Appling | Georgia | 13001 | 3 | 0 |
28729 | 28729 | 2020-04-03 | Appling | Georgia | 13001 | 5 | 0 |
31089 | 31089 | 2020-04-04 | Appling | Georgia | 13001 | 5 | 0 |
33495 | 33495 | 2020-04-05 | Appling | Georgia | 13001 | 5 | 0 |
35941 | 35941 | 2020-04-06 | Appling | Georgia | 13001 | 6 | 0 |
38433 | 38433 | 2020-04-07 | Appling | Georgia | 13001 | 6 | 0 |
40977 | 40977 | 2020-04-08 | Appling | Georgia | 13001 | 7 | 0 |
43551 | 43551 | 2020-04-09 | Appling | Georgia | 13001 | 7 | 0 |
46153 | 46153 | 2020-04-10 | Appling | Georgia | 13001 | 9 | 0 |
48783 | 48783 | 2020-04-11 | Appling | Georgia | 13001 | 9 | 0 |
51444 | 51444 | 2020-04-12 | Appling | Georgia | 13001 | 10 | 0 |
54124 | 54124 | 2020-04-13 | Appling | Georgia | 13001 | 13 | 0 |
56816 | 56816 | 2020-04-14 | Appling | Georgia | 13001 | 13 | 0 |
59523 | 59523 | 2020-04-15 | Appling | Georgia | 13001 | 14 | 0 |
62243 | 62243 | 2020-04-16 | Appling | Georgia | 13001 | 17 | 0 |
64976 | 64976 | 2020-04-17 | Appling | Georgia | 13001 | 18 | 0 |
67724 | 67724 | 2020-04-18 | Appling | Georgia | 13001 | 20 | 0 |
70486 | 70486 | 2020-04-19 | Appling | Georgia | 13001 | 20 | 0 |
73255 | 73255 | 2020-04-20 | Appling | Georgia | 13001 | 21 | 0 |
76031 | 76031 | 2020-04-21 | Appling | Georgia | 13001 | 21 | 1 |
78815 | 78815 | 2020-04-22 | Appling | Georgia | 13001 | 47 | 2 |
81608 | 81608 | 2020-04-23 | Appling | Georgia | 13001 | 49 | 3 |
84408 | 84408 | 2020-04-24 | Appling | Georgia | 13001 | 53 | 4 |
87217 | 87217 | 2020-04-25 | Appling | Georgia | 13001 | 54 | 4 |
90033 | 90033 | 2020-04-26 | Appling | Georgia | 13001 | 56 | 4 |
92852 | 92852 | 2020-04-27 | Appling | Georgia | 13001 | 60 | 5 |
95684 | 95684 | 2020-04-28 | Appling | Georgia | 13001 | 65 | 5 |
98529 | 98529 | 2020-04-29 | Appling | Georgia | 13001 | 65 | 6 |
101379 | 101379 | 2020-04-30 | Appling | Georgia | 13001 | 70 | 6 |
104234 | 104234 | 2020-05-01 | Appling | Georgia | 13001 | 72 | 6 |
107099 | 107099 | 2020-05-02 | Appling | Georgia | 13001 | 72 | 6 |
109968 | 109968 | 2020-05-03 | Appling | Georgia | 13001 | 72 | 5 |
112843 | 112843 | 2020-05-04 | Appling | Georgia | 13001 | 74 | 7 |
115726 | 115726 | 2020-05-05 | Appling | Georgia | 13001 | 77 | 9 |
118686 | 118686 | 2020-05-06 | Appling | Georgia | 13001 | 78 | 10 |
121655 | 121655 | 2020-05-07 | Appling | Georgia | 13001 | 88 | 10 |
124634 | 124634 | 2020-05-08 | Appling | Georgia | 13001 | 89 | 10 |
127621 | 127621 | 2020-05-09 | Appling | Georgia | 13001 | 92 | 10 |
130612 | 130612 | 2020-05-10 | Appling | Georgia | 13001 | 93 | 10 |
133603 | 133603 | 2020-05-11 | Appling | Georgia | 13001 | 93 | 10 |
136592 | 136592 | 2020-05-12 | Appling | Georgia | 13001 | 96 | 10 |
139583 | 139583 | 2020-05-13 | Appling | Georgia | 13001 | 99 | 10 |
142579 | 142579 | 2020-05-14 | Appling | Georgia | 13001 | 108 | 10 |
145579 | 145579 | 2020-05-15 | Appling | Georgia | 13001 | 108 | 10 |
148582 | 148582 | 2020-05-16 | Appling | Georgia | 13001 | 108 | 10 |
151591 | 151591 | 2020-05-17 | Appling | Georgia | 13001 | 108 | 11 |
154603 | 154603 | 2020-05-18 | Appling | Georgia | 13001 | 111 | 11 |
157619 | 157619 | 2020-05-19 | Appling | Georgia | 13001 | 113 | 11 |
160645 | 160645 | 2020-05-20 | Appling | Georgia | 13001 | 115 | 11 |
163673 | 163673 | 2020-05-21 | Appling | Georgia | 13001 | 118 | 12 |
166706 | 166706 | 2020-05-22 | Appling | Georgia | 13001 | 121 | 13 |
169743 | 169743 | 2020-05-23 | Appling | Georgia | 13001 | 124 | 13 |
172784 | 172784 | 2020-05-24 | Appling | Georgia | 13001 | 132 | 13 |
175827 | 175827 | 2020-05-25 | Appling | Georgia | 13001 | 134 | 13 |
178871 | 178871 | 2020-05-26 | Appling | Georgia | 13001 | 138 | 13 |
181915 | 181915 | 2020-05-27 | Appling | Georgia | 13001 | 143 | 13 |
184969 | 184969 | 2020-05-28 | Appling | Georgia | 13001 | 148 | 13 |
188025 | 188025 | 2020-05-29 | Appling | Georgia | 13001 | 156 | 13 |
191090 | 191090 | 2020-05-30 | Appling | Georgia | 13001 | 156 | 13 |
194157 | 194157 | 2020-05-31 | Appling | Georgia | 13001 | 159 | 13 |
197227 | 197227 | 2020-06-01 | Appling | Georgia | 13001 | 161 | 13 |
200300 | 200300 | 2020-06-02 | Appling | Georgia | 13001 | 161 | 13 |
203376 | 203376 | 2020-06-03 | Appling | Georgia | 13001 | 170 | 13 |
206456 | 206456 | 2020-06-04 | Appling | Georgia | 13001 | 172 | 13 |
209537 | 209537 | 2020-06-05 | Appling | Georgia | 13001 | 180 | 13 |
212622 | 212622 | 2020-06-06 | Appling | Georgia | 13001 | 185 | 13 |
215709 | 215709 | 2020-06-07 | Appling | Georgia | 13001 | 185 | 13 |
218800 | 218800 | 2020-06-08 | Appling | Georgia | 13001 | 189 | 13 |
221895 | 221895 | 2020-06-09 | Appling | Georgia | 13001 | 197 | 13 |
224990 | 224990 | 2020-06-10 | Appling | Georgia | 13001 | 199 | 13 |
228092 | 228092 | 2020-06-11 | Appling | Georgia | 13001 | 200 | 13 |
231195 | 231195 | 2020-06-12 | Appling | Georgia | 13001 | 199 | 13 |
234301 | 234301 | 2020-06-13 | Appling | Georgia | 13001 | 204 | 13 |
237408 | 237408 | 2020-06-14 | Appling | Georgia | 13001 | 205 | 13 |
240516 | 240516 | 2020-06-15 | Appling | Georgia | 13001 | 204 | 13 |
243627 | 243627 | 2020-06-16 | Appling | Georgia | 13001 | 207 | 13 |
246740 | 246740 | 2020-06-17 | Appling | Georgia | 13001 | 208 | 13 |
249852 | 249852 | 2020-06-18 | Appling | Georgia | 13001 | 208 | 13 |
252967 | 252967 | 2020-06-19 | Appling | Georgia | 13001 | 214 | 13 |
256086 | 256086 | 2020-06-20 | Appling | Georgia | 13001 | 216 | 13 |
259213 | 259213 | 2020-06-21 | Appling | Georgia | 13001 | 217 | 13 |
262340 | 262340 | 2020-06-22 | Appling | Georgia | 13001 | 220 | 13 |
265468 | 265468 | 2020-06-23 | Appling | Georgia | 13001 | 223 | 13 |
268598 | 268598 | 2020-06-24 | Appling | Georgia | 13001 | 227 | 13 |
271734 | 271734 | 2020-06-25 | Appling | Georgia | 13001 | 230 | 14 |
274874 | 274874 | 2020-06-26 | Appling | Georgia | 13001 | 241 | 14 |
278022 | 278022 | 2020-06-27 | Appling | Georgia | 13001 | 247 | 14 |
281169 | 281169 | 2020-06-28 | Appling | Georgia | 13001 | 254 | 14 |
284315 | 284315 | 2020-06-29 | Appling | Georgia | 13001 | 256 | 14 |
287461 | 287461 | 2020-06-30 | Appling | Georgia | 13001 | 258 | 14 |
290612 | 290612 | 2020-07-01 | Appling | Georgia | 13001 | 260 | 14 |
293766 | 293766 | 2020-07-02 | Appling | Georgia | 13001 | 266 | 14 |
296922 | 296922 | 2020-07-03 | Appling | Georgia | 13001 | 274 | 14 |
300084 | 300084 | 2020-07-04 | Appling | Georgia | 13001 | 285 | 14 |
303248 | 303248 | 2020-07-05 | Appling | Georgia | 13001 | 290 | 14 |
306412 | 306412 | 2020-07-06 | Appling | Georgia | 13001 | 299 | 14 |
309580 | 309580 | 2020-07-07 | Appling | Georgia | 13001 | 302 | 14 |
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);