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 |
---|---|---|---|---|---|---|---|
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 |
78845 | 78845 | 2020-04-22 | Clayton | Georgia | 13063 | 549 | 21 |
76061 | 76061 | 2020-04-21 | Clayton | Georgia | 13063 | 547 | 21 |
73285 | 73285 | 2020-04-20 | Clayton | Georgia | 13063 | 540 | 20 |
70516 | 70516 | 2020-04-19 | Clayton | Georgia | 13063 | 520 | 17 |
67754 | 67754 | 2020-04-18 | Clayton | Georgia | 13063 | 505 | 17 |
65006 | 65006 | 2020-04-17 | Clayton | Georgia | 13063 | 499 | 16 |
62273 | 62273 | 2020-04-16 | Clayton | Georgia | 13063 | 473 | 13 |
59553 | 59553 | 2020-04-15 | Clayton | Georgia | 13063 | 462 | 13 |
56846 | 56846 | 2020-04-14 | Clayton | Georgia | 13063 | 435 | 12 |
54154 | 54154 | 2020-04-13 | Clayton | Georgia | 13063 | 396 | 12 |
51474 | 51474 | 2020-04-12 | Clayton | Georgia | 13063 | 372 | 11 |
48813 | 48813 | 2020-04-11 | Clayton | Georgia | 13063 | 339 | 11 |
46183 | 46183 | 2020-04-10 | Clayton | Georgia | 13063 | 328 | 11 |
43581 | 43581 | 2020-04-09 | Clayton | Georgia | 13063 | 298 | 11 |
41007 | 41007 | 2020-04-08 | Clayton | Georgia | 13063 | 289 | 10 |
38463 | 38463 | 2020-04-07 | Clayton | Georgia | 13063 | 278 | 10 |
35971 | 35971 | 2020-04-06 | Clayton | Georgia | 13063 | 254 | 9 |
33523 | 33523 | 2020-04-05 | Clayton | Georgia | 13063 | 238 | 9 |
31117 | 31117 | 2020-04-04 | Clayton | Georgia | 13063 | 235 | 9 |
28757 | 28757 | 2020-04-03 | Clayton | Georgia | 13063 | 206 | 8 |
26454 | 26454 | 2020-04-02 | Clayton | Georgia | 13063 | 165 | 6 |
24223 | 24223 | 2020-04-01 | Clayton | Georgia | 13063 | 128 | 5 |
22060 | 22060 | 2020-03-31 | Clayton | Georgia | 13063 | 112 | 3 |
19981 | 19981 | 2020-03-30 | Clayton | Georgia | 13063 | 62 | 2 |
17995 | 17995 | 2020-03-29 | Clayton | Georgia | 13063 | 59 | 1 |
16098 | 16098 | 2020-03-28 | Clayton | Georgia | 13063 | 57 | 1 |
14312 | 14312 | 2020-03-27 | Clayton | Georgia | 13063 | 53 | 1 |
12640 | 12640 | 2020-03-26 | Clayton | Georgia | 13063 | 37 | 1 |
11091 | 11091 | 2020-03-25 | Clayton | Georgia | 13063 | 29 | 1 |
9716 | 9716 | 2020-03-24 | Clayton | Georgia | 13063 | 21 | 1 |
8467 | 8467 | 2020-03-23 | Clayton | Georgia | 13063 | 19 | 1 |
7319 | 7319 | 2020-03-22 | Clayton | Georgia | 13063 | 13 | 1 |
6275 | 6275 | 2020-03-21 | Clayton | Georgia | 13063 | 12 | 0 |
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);