ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Clayton" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386358 | 386358 | 2020-07-31 | Clayton | Georgia | 13063 | 4413 | 97 |
383140 | 383140 | 2020-07-30 | Clayton | Georgia | 13063 | 4339 | 95 |
379923 | 379923 | 2020-07-29 | Clayton | Georgia | 13063 | 4248 | 95 |
376706 | 376706 | 2020-07-28 | Clayton | Georgia | 13063 | 4151 | 94 |
373492 | 373492 | 2020-07-27 | Clayton | Georgia | 13063 | 4063 | 92 |
370280 | 370280 | 2020-07-26 | Clayton | Georgia | 13063 | 4002 | 92 |
367070 | 367070 | 2020-07-25 | Clayton | Georgia | 13063 | 3948 | 92 |
363863 | 363863 | 2020-07-24 | Clayton | Georgia | 13063 | 3838 | 90 |
360656 | 360656 | 2020-07-23 | Clayton | Georgia | 13063 | 3737 | 89 |
357451 | 357451 | 2020-07-22 | Clayton | Georgia | 13063 | 3630 | 88 |
354248 | 354248 | 2020-07-21 | Clayton | Georgia | 13063 | 3542 | 86 |
351046 | 351046 | 2020-07-20 | Clayton | Georgia | 13063 | 3455 | 85 |
347845 | 347845 | 2020-07-19 | Clayton | Georgia | 13063 | 3411 | 85 |
344645 | 344645 | 2020-07-18 | Clayton | Georgia | 13063 | 3331 | 85 |
341446 | 341446 | 2020-07-17 | Clayton | Georgia | 13063 | 3236 | 85 |
338249 | 338249 | 2020-07-16 | Clayton | Georgia | 13063 | 3132 | 84 |
335054 | 335054 | 2020-07-15 | Clayton | Georgia | 13063 | 3060 | 84 |
331861 | 331861 | 2020-07-14 | Clayton | Georgia | 13063 | 2984 | 82 |
328674 | 328674 | 2020-07-13 | Clayton | Georgia | 13063 | 2920 | 82 |
325488 | 325488 | 2020-07-12 | Clayton | Georgia | 13063 | 2811 | 82 |
322307 | 322307 | 2020-07-11 | Clayton | Georgia | 13063 | 2759 | 82 |
319128 | 319128 | 2020-07-10 | Clayton | Georgia | 13063 | 2708 | 81 |
315955 | 315955 | 2020-07-09 | Clayton | Georgia | 13063 | 2580 | 81 |
312780 | 312780 | 2020-07-08 | Clayton | Georgia | 13063 | 2517 | 81 |
309610 | 309610 | 2020-07-07 | Clayton | Georgia | 13063 | 2439 | 81 |
306442 | 306442 | 2020-07-06 | Clayton | Georgia | 13063 | 2376 | 80 |
303278 | 303278 | 2020-07-05 | Clayton | Georgia | 13063 | 2344 | 79 |
300114 | 300114 | 2020-07-04 | Clayton | Georgia | 13063 | 2280 | 79 |
296952 | 296952 | 2020-07-03 | Clayton | Georgia | 13063 | 2181 | 79 |
293796 | 293796 | 2020-07-02 | Clayton | Georgia | 13063 | 2076 | 79 |
290642 | 290642 | 2020-07-01 | Clayton | Georgia | 13063 | 2002 | 79 |
287491 | 287491 | 2020-06-30 | Clayton | Georgia | 13063 | 1939 | 79 |
284345 | 284345 | 2020-06-29 | Clayton | Georgia | 13063 | 1888 | 79 |
281199 | 281199 | 2020-06-28 | Clayton | Georgia | 13063 | 1884 | 79 |
278052 | 278052 | 2020-06-27 | Clayton | Georgia | 13063 | 1864 | 79 |
274904 | 274904 | 2020-06-26 | Clayton | Georgia | 13063 | 1825 | 79 |
271764 | 271764 | 2020-06-25 | Clayton | Georgia | 13063 | 1781 | 79 |
268628 | 268628 | 2020-06-24 | Clayton | Georgia | 13063 | 1726 | 78 |
265498 | 265498 | 2020-06-23 | Clayton | Georgia | 13063 | 1687 | 77 |
262370 | 262370 | 2020-06-22 | Clayton | Georgia | 13063 | 1631 | 76 |
259243 | 259243 | 2020-06-21 | Clayton | Georgia | 13063 | 1598 | 76 |
256116 | 256116 | 2020-06-20 | Clayton | Georgia | 13063 | 1567 | 76 |
252997 | 252997 | 2020-06-19 | Clayton | Georgia | 13063 | 1550 | 76 |
249882 | 249882 | 2020-06-18 | Clayton | Georgia | 13063 | 1518 | 75 |
246770 | 246770 | 2020-06-17 | Clayton | Georgia | 13063 | 1495 | 74 |
243657 | 243657 | 2020-06-16 | Clayton | Georgia | 13063 | 1461 | 73 |
240546 | 240546 | 2020-06-15 | Clayton | Georgia | 13063 | 1440 | 72 |
237438 | 237438 | 2020-06-14 | Clayton | Georgia | 13063 | 1431 | 69 |
234331 | 234331 | 2020-06-13 | Clayton | Georgia | 13063 | 1427 | 69 |
231225 | 231225 | 2020-06-12 | Clayton | Georgia | 13063 | 1413 | 65 |
228122 | 228122 | 2020-06-11 | Clayton | Georgia | 13063 | 1399 | 59 |
225020 | 225020 | 2020-06-10 | Clayton | Georgia | 13063 | 1378 | 58 |
221925 | 221925 | 2020-06-09 | Clayton | Georgia | 13063 | 1362 | 54 |
218830 | 218830 | 2020-06-08 | Clayton | Georgia | 13063 | 1343 | 52 |
215739 | 215739 | 2020-06-07 | Clayton | Georgia | 13063 | 1328 | 51 |
212652 | 212652 | 2020-06-06 | Clayton | Georgia | 13063 | 1323 | 51 |
209567 | 209567 | 2020-06-05 | Clayton | Georgia | 13063 | 1310 | 52 |
206486 | 206486 | 2020-06-04 | Clayton | Georgia | 13063 | 1282 | 51 |
203406 | 203406 | 2020-06-03 | Clayton | Georgia | 13063 | 1260 | 51 |
200330 | 200330 | 2020-06-02 | Clayton | Georgia | 13063 | 1238 | 51 |
197257 | 197257 | 2020-06-01 | Clayton | Georgia | 13063 | 1234 | 50 |
194187 | 194187 | 2020-05-31 | Clayton | Georgia | 13063 | 1221 | 49 |
191120 | 191120 | 2020-05-30 | Clayton | Georgia | 13063 | 1216 | 45 |
188055 | 188055 | 2020-05-29 | Clayton | Georgia | 13063 | 1217 | 45 |
184999 | 184999 | 2020-05-28 | Clayton | Georgia | 13063 | 1204 | 45 |
181945 | 181945 | 2020-05-27 | Clayton | Georgia | 13063 | 1189 | 46 |
178901 | 178901 | 2020-05-26 | Clayton | Georgia | 13063 | 1173 | 44 |
175857 | 175857 | 2020-05-25 | Clayton | Georgia | 13063 | 1132 | 43 |
172814 | 172814 | 2020-05-24 | Clayton | Georgia | 13063 | 1119 | 43 |
169773 | 169773 | 2020-05-23 | Clayton | Georgia | 13063 | 1089 | 43 |
166736 | 166736 | 2020-05-22 | Clayton | Georgia | 13063 | 1071 | 43 |
163703 | 163703 | 2020-05-21 | Clayton | Georgia | 13063 | 1047 | 42 |
160675 | 160675 | 2020-05-20 | Clayton | Georgia | 13063 | 1034 | 39 |
157649 | 157649 | 2020-05-19 | Clayton | Georgia | 13063 | 1010 | 38 |
154633 | 154633 | 2020-05-18 | Clayton | Georgia | 13063 | 1009 | 38 |
151621 | 151621 | 2020-05-17 | Clayton | Georgia | 13063 | 1005 | 39 |
148612 | 148612 | 2020-05-16 | Clayton | Georgia | 13063 | 1002 | 38 |
145609 | 145609 | 2020-05-15 | Clayton | Georgia | 13063 | 999 | 38 |
142609 | 142609 | 2020-05-14 | Clayton | Georgia | 13063 | 983 | 36 |
139613 | 139613 | 2020-05-13 | Clayton | Georgia | 13063 | 955 | 35 |
136622 | 136622 | 2020-05-12 | Clayton | Georgia | 13063 | 951 | 35 |
133633 | 133633 | 2020-05-11 | Clayton | Georgia | 13063 | 944 | 34 |
130642 | 130642 | 2020-05-10 | Clayton | Georgia | 13063 | 921 | 34 |
127651 | 127651 | 2020-05-09 | Clayton | Georgia | 13063 | 901 | 34 |
124664 | 124664 | 2020-05-08 | Clayton | Georgia | 13063 | 888 | 34 |
121685 | 121685 | 2020-05-07 | Clayton | Georgia | 13063 | 878 | 34 |
118716 | 118716 | 2020-05-06 | Clayton | Georgia | 13063 | 849 | 33 |
115756 | 115756 | 2020-05-05 | Clayton | Georgia | 13063 | 813 | 33 |
112873 | 112873 | 2020-05-04 | Clayton | Georgia | 13063 | 804 | 32 |
109998 | 109998 | 2020-05-03 | Clayton | Georgia | 13063 | 793 | 33 |
107129 | 107129 | 2020-05-02 | Clayton | Georgia | 13063 | 777 | 33 |
104264 | 104264 | 2020-05-01 | Clayton | Georgia | 13063 | 733 | 33 |
101409 | 101409 | 2020-04-30 | Clayton | Georgia | 13063 | 716 | 30 |
98559 | 98559 | 2020-04-29 | Clayton | Georgia | 13063 | 693 | 27 |
95714 | 95714 | 2020-04-28 | Clayton | Georgia | 13063 | 672 | 24 |
92882 | 92882 | 2020-04-27 | Clayton | Georgia | 13063 | 649 | 24 |
90063 | 90063 | 2020-04-26 | Clayton | Georgia | 13063 | 641 | 21 |
87247 | 87247 | 2020-04-25 | Clayton | Georgia | 13063 | 642 | 21 |
84438 | 84438 | 2020-04-24 | Clayton | Georgia | 13063 | 629 | 21 |
81638 | 81638 | 2020-04-23 | Clayton | Georgia | 13063 | 616 | 21 |
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);