ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Upson" and state = "Georgia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14392 | 14392 | 2020-03-27 | Upson | Georgia | 13293 | 2 | 0 |
16181 | 16181 | 2020-03-28 | Upson | Georgia | 13293 | 5 | 0 |
18078 | 18078 | 2020-03-29 | Upson | Georgia | 13293 | 5 | 0 |
20073 | 20073 | 2020-03-30 | Upson | Georgia | 13293 | 5 | 0 |
22158 | 22158 | 2020-03-31 | Upson | Georgia | 13293 | 5 | 0 |
24324 | 24324 | 2020-04-01 | Upson | Georgia | 13293 | 6 | 0 |
26556 | 26556 | 2020-04-02 | Upson | Georgia | 13293 | 6 | 0 |
28863 | 28863 | 2020-04-03 | Upson | Georgia | 13293 | 8 | 0 |
31223 | 31223 | 2020-04-04 | Upson | Georgia | 13293 | 12 | 0 |
33630 | 33630 | 2020-04-05 | Upson | Georgia | 13293 | 13 | 0 |
36081 | 36081 | 2020-04-06 | Upson | Georgia | 13293 | 25 | 0 |
38574 | 38574 | 2020-04-07 | Upson | Georgia | 13293 | 29 | 0 |
41118 | 41118 | 2020-04-08 | Upson | Georgia | 13293 | 39 | 0 |
43692 | 43692 | 2020-04-09 | Upson | Georgia | 13293 | 42 | 0 |
46294 | 46294 | 2020-04-10 | Upson | Georgia | 13293 | 50 | 0 |
48925 | 48925 | 2020-04-11 | Upson | Georgia | 13293 | 51 | 1 |
51587 | 51587 | 2020-04-12 | Upson | Georgia | 13293 | 56 | 1 |
54267 | 54267 | 2020-04-13 | Upson | Georgia | 13293 | 122 | 3 |
56959 | 56959 | 2020-04-14 | Upson | Georgia | 13293 | 128 | 5 |
59666 | 59666 | 2020-04-15 | Upson | Georgia | 13293 | 139 | 5 |
62386 | 62386 | 2020-04-16 | Upson | Georgia | 13293 | 143 | 6 |
65119 | 65119 | 2020-04-17 | Upson | Georgia | 13293 | 164 | 8 |
67867 | 67867 | 2020-04-18 | Upson | Georgia | 13293 | 170 | 8 |
70629 | 70629 | 2020-04-19 | Upson | Georgia | 13293 | 173 | 8 |
73398 | 73398 | 2020-04-20 | Upson | Georgia | 13293 | 175 | 10 |
76174 | 76174 | 2020-04-21 | Upson | Georgia | 13293 | 180 | 11 |
78958 | 78958 | 2020-04-22 | Upson | Georgia | 13293 | 185 | 12 |
81751 | 81751 | 2020-04-23 | Upson | Georgia | 13293 | 191 | 14 |
84551 | 84551 | 2020-04-24 | Upson | Georgia | 13293 | 193 | 14 |
87360 | 87360 | 2020-04-25 | Upson | Georgia | 13293 | 196 | 14 |
90176 | 90176 | 2020-04-26 | Upson | Georgia | 13293 | 197 | 14 |
92995 | 92995 | 2020-04-27 | Upson | Georgia | 13293 | 203 | 17 |
95827 | 95827 | 2020-04-28 | Upson | Georgia | 13293 | 208 | 17 |
98671 | 98671 | 2020-04-29 | Upson | Georgia | 13293 | 212 | 17 |
101522 | 101522 | 2020-04-30 | Upson | Georgia | 13293 | 217 | 18 |
104377 | 104377 | 2020-05-01 | Upson | Georgia | 13293 | 224 | 18 |
107242 | 107242 | 2020-05-02 | Upson | Georgia | 13293 | 225 | 18 |
110112 | 110112 | 2020-05-03 | Upson | Georgia | 13293 | 230 | 20 |
112987 | 112987 | 2020-05-04 | Upson | Georgia | 13293 | 240 | 21 |
115870 | 115870 | 2020-05-05 | Upson | Georgia | 13293 | 243 | 23 |
118830 | 118830 | 2020-05-06 | Upson | Georgia | 13293 | 245 | 23 |
121800 | 121800 | 2020-05-07 | Upson | Georgia | 13293 | 246 | 24 |
124779 | 124779 | 2020-05-08 | Upson | Georgia | 13293 | 247 | 24 |
127766 | 127766 | 2020-05-09 | Upson | Georgia | 13293 | 249 | 24 |
130757 | 130757 | 2020-05-10 | Upson | Georgia | 13293 | 250 | 24 |
133748 | 133748 | 2020-05-11 | Upson | Georgia | 13293 | 250 | 24 |
136737 | 136737 | 2020-05-12 | Upson | Georgia | 13293 | 254 | 25 |
139728 | 139728 | 2020-05-13 | Upson | Georgia | 13293 | 255 | 25 |
142724 | 142724 | 2020-05-14 | Upson | Georgia | 13293 | 255 | 27 |
145724 | 145724 | 2020-05-15 | Upson | Georgia | 13293 | 257 | 28 |
148727 | 148727 | 2020-05-16 | Upson | Georgia | 13293 | 258 | 29 |
151736 | 151736 | 2020-05-17 | Upson | Georgia | 13293 | 260 | 29 |
154748 | 154748 | 2020-05-18 | Upson | Georgia | 13293 | 261 | 31 |
157764 | 157764 | 2020-05-19 | Upson | Georgia | 13293 | 267 | 31 |
160790 | 160790 | 2020-05-20 | Upson | Georgia | 13293 | 267 | 31 |
163818 | 163818 | 2020-05-21 | Upson | Georgia | 13293 | 271 | 33 |
166851 | 166851 | 2020-05-22 | Upson | Georgia | 13293 | 271 | 33 |
169888 | 169888 | 2020-05-23 | Upson | Georgia | 13293 | 272 | 33 |
172929 | 172929 | 2020-05-24 | Upson | Georgia | 13293 | 273 | 33 |
175972 | 175972 | 2020-05-25 | Upson | Georgia | 13293 | 275 | 33 |
179016 | 179016 | 2020-05-26 | Upson | Georgia | 13293 | 279 | 33 |
182060 | 182060 | 2020-05-27 | Upson | Georgia | 13293 | 280 | 34 |
185114 | 185114 | 2020-05-28 | Upson | Georgia | 13293 | 280 | 34 |
188170 | 188170 | 2020-05-29 | Upson | Georgia | 13293 | 280 | 34 |
191235 | 191235 | 2020-05-30 | Upson | Georgia | 13293 | 280 | 34 |
194302 | 194302 | 2020-05-31 | Upson | Georgia | 13293 | 281 | 34 |
197372 | 197372 | 2020-06-01 | Upson | Georgia | 13293 | 283 | 34 |
200445 | 200445 | 2020-06-02 | Upson | Georgia | 13293 | 284 | 34 |
203521 | 203521 | 2020-06-03 | Upson | Georgia | 13293 | 290 | 34 |
206601 | 206601 | 2020-06-04 | Upson | Georgia | 13293 | 289 | 34 |
209682 | 209682 | 2020-06-05 | Upson | Georgia | 13293 | 290 | 35 |
212767 | 212767 | 2020-06-06 | Upson | Georgia | 13293 | 290 | 35 |
215854 | 215854 | 2020-06-07 | Upson | Georgia | 13293 | 290 | 35 |
218945 | 218945 | 2020-06-08 | Upson | Georgia | 13293 | 290 | 35 |
222040 | 222040 | 2020-06-09 | Upson | Georgia | 13293 | 290 | 36 |
225135 | 225135 | 2020-06-10 | Upson | Georgia | 13293 | 291 | 36 |
228237 | 228237 | 2020-06-11 | Upson | Georgia | 13293 | 295 | 38 |
231340 | 231340 | 2020-06-12 | Upson | Georgia | 13293 | 295 | 38 |
234446 | 234446 | 2020-06-13 | Upson | Georgia | 13293 | 295 | 38 |
237553 | 237553 | 2020-06-14 | Upson | Georgia | 13293 | 295 | 40 |
240661 | 240661 | 2020-06-15 | Upson | Georgia | 13293 | 295 | 40 |
243772 | 243772 | 2020-06-16 | Upson | Georgia | 13293 | 300 | 42 |
246885 | 246885 | 2020-06-17 | Upson | Georgia | 13293 | 308 | 42 |
249997 | 249997 | 2020-06-18 | Upson | Georgia | 13293 | 309 | 42 |
253112 | 253112 | 2020-06-19 | Upson | Georgia | 13293 | 312 | 43 |
256231 | 256231 | 2020-06-20 | Upson | Georgia | 13293 | 319 | 43 |
259358 | 259358 | 2020-06-21 | Upson | Georgia | 13293 | 319 | 43 |
262485 | 262485 | 2020-06-22 | Upson | Georgia | 13293 | 323 | 43 |
265613 | 265613 | 2020-06-23 | Upson | Georgia | 13293 | 328 | 43 |
268743 | 268743 | 2020-06-24 | Upson | Georgia | 13293 | 341 | 43 |
271879 | 271879 | 2020-06-25 | Upson | Georgia | 13293 | 343 | 43 |
275019 | 275019 | 2020-06-26 | Upson | Georgia | 13293 | 343 | 43 |
278167 | 278167 | 2020-06-27 | Upson | Georgia | 13293 | 348 | 43 |
281314 | 281314 | 2020-06-28 | Upson | Georgia | 13293 | 348 | 43 |
284460 | 284460 | 2020-06-29 | Upson | Georgia | 13293 | 348 | 43 |
287606 | 287606 | 2020-06-30 | Upson | Georgia | 13293 | 355 | 43 |
290757 | 290757 | 2020-07-01 | Upson | Georgia | 13293 | 363 | 43 |
293911 | 293911 | 2020-07-02 | Upson | Georgia | 13293 | 369 | 43 |
297067 | 297067 | 2020-07-03 | Upson | Georgia | 13293 | 374 | 43 |
300229 | 300229 | 2020-07-04 | Upson | Georgia | 13293 | 377 | 43 |
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);