ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Clarke" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386356 | 386356 | 2020-07-31 | Clarke | Georgia | 13059 | 1665 | 17 |
383138 | 383138 | 2020-07-30 | Clarke | Georgia | 13059 | 1591 | 16 |
379921 | 379921 | 2020-07-29 | Clarke | Georgia | 13059 | 1557 | 16 |
376704 | 376704 | 2020-07-28 | Clarke | Georgia | 13059 | 1507 | 15 |
373490 | 373490 | 2020-07-27 | Clarke | Georgia | 13059 | 1475 | 15 |
370278 | 370278 | 2020-07-26 | Clarke | Georgia | 13059 | 1449 | 15 |
367068 | 367068 | 2020-07-25 | Clarke | Georgia | 13059 | 1439 | 15 |
363861 | 363861 | 2020-07-24 | Clarke | Georgia | 13059 | 1396 | 15 |
360654 | 360654 | 2020-07-23 | Clarke | Georgia | 13059 | 1356 | 15 |
357449 | 357449 | 2020-07-22 | Clarke | Georgia | 13059 | 1306 | 15 |
354246 | 354246 | 2020-07-21 | Clarke | Georgia | 13059 | 1286 | 15 |
351044 | 351044 | 2020-07-20 | Clarke | Georgia | 13059 | 1255 | 15 |
347843 | 347843 | 2020-07-19 | Clarke | Georgia | 13059 | 1238 | 15 |
344643 | 344643 | 2020-07-18 | Clarke | Georgia | 13059 | 1205 | 15 |
341444 | 341444 | 2020-07-17 | Clarke | Georgia | 13059 | 1140 | 15 |
338247 | 338247 | 2020-07-16 | Clarke | Georgia | 13059 | 1087 | 15 |
335052 | 335052 | 2020-07-15 | Clarke | Georgia | 13059 | 1045 | 15 |
331859 | 331859 | 2020-07-14 | Clarke | Georgia | 13059 | 1007 | 15 |
328672 | 328672 | 2020-07-13 | Clarke | Georgia | 13059 | 977 | 15 |
325486 | 325486 | 2020-07-12 | Clarke | Georgia | 13059 | 939 | 15 |
322305 | 322305 | 2020-07-11 | Clarke | Georgia | 13059 | 925 | 15 |
319126 | 319126 | 2020-07-10 | Clarke | Georgia | 13059 | 897 | 15 |
315953 | 315953 | 2020-07-09 | Clarke | Georgia | 13059 | 841 | 15 |
312778 | 312778 | 2020-07-08 | Clarke | Georgia | 13059 | 804 | 15 |
309608 | 309608 | 2020-07-07 | Clarke | Georgia | 13059 | 775 | 15 |
306440 | 306440 | 2020-07-06 | Clarke | Georgia | 13059 | 738 | 15 |
303276 | 303276 | 2020-07-05 | Clarke | Georgia | 13059 | 714 | 15 |
300112 | 300112 | 2020-07-04 | Clarke | Georgia | 13059 | 690 | 15 |
296950 | 296950 | 2020-07-03 | Clarke | Georgia | 13059 | 661 | 15 |
293794 | 293794 | 2020-07-02 | Clarke | Georgia | 13059 | 607 | 15 |
290640 | 290640 | 2020-07-01 | Clarke | Georgia | 13059 | 574 | 15 |
287489 | 287489 | 2020-06-30 | Clarke | Georgia | 13059 | 531 | 15 |
284343 | 284343 | 2020-06-29 | Clarke | Georgia | 13059 | 490 | 15 |
281197 | 281197 | 2020-06-28 | Clarke | Georgia | 13059 | 485 | 15 |
278050 | 278050 | 2020-06-27 | Clarke | Georgia | 13059 | 481 | 15 |
274902 | 274902 | 2020-06-26 | Clarke | Georgia | 13059 | 463 | 15 |
271762 | 271762 | 2020-06-25 | Clarke | Georgia | 13059 | 441 | 15 |
268626 | 268626 | 2020-06-24 | Clarke | Georgia | 13059 | 419 | 15 |
265496 | 265496 | 2020-06-23 | Clarke | Georgia | 13059 | 408 | 15 |
262368 | 262368 | 2020-06-22 | Clarke | Georgia | 13059 | 391 | 15 |
259241 | 259241 | 2020-06-21 | Clarke | Georgia | 13059 | 381 | 15 |
256114 | 256114 | 2020-06-20 | Clarke | Georgia | 13059 | 376 | 15 |
252995 | 252995 | 2020-06-19 | Clarke | Georgia | 13059 | 374 | 15 |
249880 | 249880 | 2020-06-18 | Clarke | Georgia | 13059 | 363 | 15 |
246768 | 246768 | 2020-06-17 | Clarke | Georgia | 13059 | 361 | 15 |
243655 | 243655 | 2020-06-16 | Clarke | Georgia | 13059 | 353 | 15 |
240544 | 240544 | 2020-06-15 | Clarke | Georgia | 13059 | 348 | 15 |
237436 | 237436 | 2020-06-14 | Clarke | Georgia | 13059 | 342 | 15 |
234329 | 234329 | 2020-06-13 | Clarke | Georgia | 13059 | 341 | 15 |
231223 | 231223 | 2020-06-12 | Clarke | Georgia | 13059 | 338 | 15 |
228120 | 228120 | 2020-06-11 | Clarke | Georgia | 13059 | 332 | 15 |
225018 | 225018 | 2020-06-10 | Clarke | Georgia | 13059 | 331 | 15 |
221923 | 221923 | 2020-06-09 | Clarke | Georgia | 13059 | 328 | 15 |
218828 | 218828 | 2020-06-08 | Clarke | Georgia | 13059 | 325 | 15 |
215737 | 215737 | 2020-06-07 | Clarke | Georgia | 13059 | 321 | 15 |
212650 | 212650 | 2020-06-06 | Clarke | Georgia | 13059 | 318 | 15 |
209565 | 209565 | 2020-06-05 | Clarke | Georgia | 13059 | 315 | 15 |
206484 | 206484 | 2020-06-04 | Clarke | Georgia | 13059 | 299 | 15 |
203404 | 203404 | 2020-06-03 | Clarke | Georgia | 13059 | 296 | 14 |
200328 | 200328 | 2020-06-02 | Clarke | Georgia | 13059 | 295 | 14 |
197255 | 197255 | 2020-06-01 | Clarke | Georgia | 13059 | 293 | 13 |
194185 | 194185 | 2020-05-31 | Clarke | Georgia | 13059 | 283 | 13 |
191118 | 191118 | 2020-05-30 | Clarke | Georgia | 13059 | 283 | 13 |
188053 | 188053 | 2020-05-29 | Clarke | Georgia | 13059 | 279 | 13 |
184997 | 184997 | 2020-05-28 | Clarke | Georgia | 13059 | 270 | 13 |
181943 | 181943 | 2020-05-27 | Clarke | Georgia | 13059 | 259 | 13 |
178899 | 178899 | 2020-05-26 | Clarke | Georgia | 13059 | 249 | 13 |
175855 | 175855 | 2020-05-25 | Clarke | Georgia | 13059 | 232 | 13 |
172812 | 172812 | 2020-05-24 | Clarke | Georgia | 13059 | 224 | 13 |
169771 | 169771 | 2020-05-23 | Clarke | Georgia | 13059 | 222 | 13 |
166734 | 166734 | 2020-05-22 | Clarke | Georgia | 13059 | 219 | 13 |
163701 | 163701 | 2020-05-21 | Clarke | Georgia | 13059 | 208 | 13 |
160673 | 160673 | 2020-05-20 | Clarke | Georgia | 13059 | 200 | 13 |
157647 | 157647 | 2020-05-19 | Clarke | Georgia | 13059 | 200 | 13 |
154631 | 154631 | 2020-05-18 | Clarke | Georgia | 13059 | 200 | 13 |
151619 | 151619 | 2020-05-17 | Clarke | Georgia | 13059 | 194 | 13 |
148610 | 148610 | 2020-05-16 | Clarke | Georgia | 13059 | 195 | 13 |
145607 | 145607 | 2020-05-15 | Clarke | Georgia | 13059 | 197 | 13 |
142607 | 142607 | 2020-05-14 | Clarke | Georgia | 13059 | 192 | 13 |
139611 | 139611 | 2020-05-13 | Clarke | Georgia | 13059 | 190 | 13 |
136620 | 136620 | 2020-05-12 | Clarke | Georgia | 13059 | 189 | 13 |
133631 | 133631 | 2020-05-11 | Clarke | Georgia | 13059 | 188 | 13 |
130640 | 130640 | 2020-05-10 | Clarke | Georgia | 13059 | 186 | 13 |
127649 | 127649 | 2020-05-09 | Clarke | Georgia | 13059 | 182 | 13 |
124662 | 124662 | 2020-05-08 | Clarke | Georgia | 13059 | 180 | 13 |
121683 | 121683 | 2020-05-07 | Clarke | Georgia | 13059 | 176 | 13 |
118714 | 118714 | 2020-05-06 | Clarke | Georgia | 13059 | 174 | 13 |
115754 | 115754 | 2020-05-05 | Clarke | Georgia | 13059 | 167 | 13 |
112871 | 112871 | 2020-05-04 | Clarke | Georgia | 13059 | 161 | 13 |
109996 | 109996 | 2020-05-03 | Clarke | Georgia | 13059 | 156 | 13 |
107127 | 107127 | 2020-05-02 | Clarke | Georgia | 13059 | 156 | 13 |
104262 | 104262 | 2020-05-01 | Clarke | Georgia | 13059 | 155 | 13 |
101407 | 101407 | 2020-04-30 | Clarke | Georgia | 13059 | 150 | 13 |
98557 | 98557 | 2020-04-29 | Clarke | Georgia | 13059 | 144 | 13 |
95712 | 95712 | 2020-04-28 | Clarke | Georgia | 13059 | 142 | 13 |
92880 | 92880 | 2020-04-27 | Clarke | Georgia | 13059 | 140 | 13 |
90061 | 90061 | 2020-04-26 | Clarke | Georgia | 13059 | 123 | 13 |
87245 | 87245 | 2020-04-25 | Clarke | Georgia | 13059 | 127 | 13 |
84436 | 84436 | 2020-04-24 | Clarke | Georgia | 13059 | 127 | 13 |
81636 | 81636 | 2020-04-23 | Clarke | Georgia | 13059 | 122 | 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);