ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Troup" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386468 | 386468 | 2020-07-31 | Troup | Georgia | 13285 | 2158 | 58 |
383250 | 383250 | 2020-07-30 | Troup | Georgia | 13285 | 2140 | 54 |
380033 | 380033 | 2020-07-29 | Troup | Georgia | 13285 | 2130 | 53 |
376816 | 376816 | 2020-07-28 | Troup | Georgia | 13285 | 2109 | 53 |
373602 | 373602 | 2020-07-27 | Troup | Georgia | 13285 | 2090 | 52 |
370390 | 370390 | 2020-07-26 | Troup | Georgia | 13285 | 2085 | 52 |
367180 | 367180 | 2020-07-25 | Troup | Georgia | 13285 | 2069 | 52 |
363973 | 363973 | 2020-07-24 | Troup | Georgia | 13285 | 2027 | 52 |
360766 | 360766 | 2020-07-23 | Troup | Georgia | 13285 | 1999 | 50 |
357561 | 357561 | 2020-07-22 | Troup | Georgia | 13285 | 1957 | 49 |
354358 | 354358 | 2020-07-21 | Troup | Georgia | 13285 | 1939 | 45 |
351156 | 351156 | 2020-07-20 | Troup | Georgia | 13285 | 1874 | 43 |
347955 | 347955 | 2020-07-19 | Troup | Georgia | 13285 | 1866 | 43 |
344755 | 344755 | 2020-07-18 | Troup | Georgia | 13285 | 1857 | 43 |
341556 | 341556 | 2020-07-17 | Troup | Georgia | 13285 | 1841 | 44 |
338359 | 338359 | 2020-07-16 | Troup | Georgia | 13285 | 1815 | 39 |
335164 | 335164 | 2020-07-15 | Troup | Georgia | 13285 | 1802 | 39 |
331971 | 331971 | 2020-07-14 | Troup | Georgia | 13285 | 1767 | 38 |
328784 | 328784 | 2020-07-13 | Troup | Georgia | 13285 | 1756 | 38 |
325598 | 325598 | 2020-07-12 | Troup | Georgia | 13285 | 1750 | 38 |
322417 | 322417 | 2020-07-11 | Troup | Georgia | 13285 | 1744 | 38 |
319238 | 319238 | 2020-07-10 | Troup | Georgia | 13285 | 1716 | 38 |
316065 | 316065 | 2020-07-09 | Troup | Georgia | 13285 | 1698 | 38 |
312890 | 312890 | 2020-07-08 | Troup | Georgia | 13285 | 1678 | 36 |
309720 | 309720 | 2020-07-07 | Troup | Georgia | 13285 | 1650 | 36 |
306552 | 306552 | 2020-07-06 | Troup | Georgia | 13285 | 1627 | 35 |
303388 | 303388 | 2020-07-05 | Troup | Georgia | 13285 | 1600 | 35 |
300224 | 300224 | 2020-07-04 | Troup | Georgia | 13285 | 1582 | 35 |
297062 | 297062 | 2020-07-03 | Troup | Georgia | 13285 | 1549 | 35 |
293906 | 293906 | 2020-07-02 | Troup | Georgia | 13285 | 1516 | 35 |
290752 | 290752 | 2020-07-01 | Troup | Georgia | 13285 | 1464 | 34 |
287601 | 287601 | 2020-06-30 | Troup | Georgia | 13285 | 1398 | 32 |
284455 | 284455 | 2020-06-29 | Troup | Georgia | 13285 | 1336 | 31 |
281309 | 281309 | 2020-06-28 | Troup | Georgia | 13285 | 1335 | 31 |
278162 | 278162 | 2020-06-27 | Troup | Georgia | 13285 | 1300 | 31 |
275014 | 275014 | 2020-06-26 | Troup | Georgia | 13285 | 1277 | 31 |
271874 | 271874 | 2020-06-25 | Troup | Georgia | 13285 | 1233 | 29 |
268738 | 268738 | 2020-06-24 | Troup | Georgia | 13285 | 1209 | 29 |
265608 | 265608 | 2020-06-23 | Troup | Georgia | 13285 | 1158 | 29 |
262480 | 262480 | 2020-06-22 | Troup | Georgia | 13285 | 1027 | 28 |
259353 | 259353 | 2020-06-21 | Troup | Georgia | 13285 | 978 | 26 |
256226 | 256226 | 2020-06-20 | Troup | Georgia | 13285 | 947 | 26 |
253107 | 253107 | 2020-06-19 | Troup | Georgia | 13285 | 922 | 25 |
249992 | 249992 | 2020-06-18 | Troup | Georgia | 13285 | 863 | 24 |
246880 | 246880 | 2020-06-17 | Troup | Georgia | 13285 | 844 | 25 |
243767 | 243767 | 2020-06-16 | Troup | Georgia | 13285 | 805 | 23 |
240656 | 240656 | 2020-06-15 | Troup | Georgia | 13285 | 792 | 23 |
237548 | 237548 | 2020-06-14 | Troup | Georgia | 13285 | 759 | 23 |
234441 | 234441 | 2020-06-13 | Troup | Georgia | 13285 | 733 | 23 |
231335 | 231335 | 2020-06-12 | Troup | Georgia | 13285 | 701 | 22 |
228232 | 228232 | 2020-06-11 | Troup | Georgia | 13285 | 613 | 13 |
225130 | 225130 | 2020-06-10 | Troup | Georgia | 13285 | 545 | 12 |
222035 | 222035 | 2020-06-09 | Troup | Georgia | 13285 | 476 | 11 |
218940 | 218940 | 2020-06-08 | Troup | Georgia | 13285 | 446 | 11 |
215849 | 215849 | 2020-06-07 | Troup | Georgia | 13285 | 426 | 11 |
212762 | 212762 | 2020-06-06 | Troup | Georgia | 13285 | 416 | 11 |
209677 | 209677 | 2020-06-05 | Troup | Georgia | 13285 | 395 | 11 |
206596 | 206596 | 2020-06-04 | Troup | Georgia | 13285 | 363 | 11 |
203516 | 203516 | 2020-06-03 | Troup | Georgia | 13285 | 345 | 11 |
200440 | 200440 | 2020-06-02 | Troup | Georgia | 13285 | 320 | 11 |
197367 | 197367 | 2020-06-01 | Troup | Georgia | 13285 | 318 | 11 |
194297 | 194297 | 2020-05-31 | Troup | Georgia | 13285 | 313 | 11 |
191230 | 191230 | 2020-05-30 | Troup | Georgia | 13285 | 307 | 11 |
188165 | 188165 | 2020-05-29 | Troup | Georgia | 13285 | 292 | 10 |
185109 | 185109 | 2020-05-28 | Troup | Georgia | 13285 | 283 | 10 |
182055 | 182055 | 2020-05-27 | Troup | Georgia | 13285 | 268 | 10 |
179011 | 179011 | 2020-05-26 | Troup | Georgia | 13285 | 268 | 10 |
175967 | 175967 | 2020-05-25 | Troup | Georgia | 13285 | 260 | 9 |
172924 | 172924 | 2020-05-24 | Troup | Georgia | 13285 | 250 | 9 |
169883 | 169883 | 2020-05-23 | Troup | Georgia | 13285 | 245 | 9 |
166846 | 166846 | 2020-05-22 | Troup | Georgia | 13285 | 238 | 9 |
163813 | 163813 | 2020-05-21 | Troup | Georgia | 13285 | 227 | 8 |
160785 | 160785 | 2020-05-20 | Troup | Georgia | 13285 | 215 | 6 |
157759 | 157759 | 2020-05-19 | Troup | Georgia | 13285 | 213 | 6 |
154743 | 154743 | 2020-05-18 | Troup | Georgia | 13285 | 201 | 6 |
151731 | 151731 | 2020-05-17 | Troup | Georgia | 13285 | 200 | 6 |
148722 | 148722 | 2020-05-16 | Troup | Georgia | 13285 | 199 | 6 |
145719 | 145719 | 2020-05-15 | Troup | Georgia | 13285 | 195 | 6 |
142719 | 142719 | 2020-05-14 | Troup | Georgia | 13285 | 192 | 5 |
139723 | 139723 | 2020-05-13 | Troup | Georgia | 13285 | 192 | 5 |
136732 | 136732 | 2020-05-12 | Troup | Georgia | 13285 | 196 | 5 |
133743 | 133743 | 2020-05-11 | Troup | Georgia | 13285 | 190 | 5 |
130752 | 130752 | 2020-05-10 | Troup | Georgia | 13285 | 186 | 5 |
127761 | 127761 | 2020-05-09 | Troup | Georgia | 13285 | 185 | 5 |
124774 | 124774 | 2020-05-08 | Troup | Georgia | 13285 | 177 | 5 |
121795 | 121795 | 2020-05-07 | Troup | Georgia | 13285 | 173 | 5 |
118825 | 118825 | 2020-05-06 | Troup | Georgia | 13285 | 168 | 5 |
115865 | 115865 | 2020-05-05 | Troup | Georgia | 13285 | 163 | 5 |
112982 | 112982 | 2020-05-04 | Troup | Georgia | 13285 | 159 | 5 |
110107 | 110107 | 2020-05-03 | Troup | Georgia | 13285 | 154 | 4 |
107237 | 107237 | 2020-05-02 | Troup | Georgia | 13285 | 154 | 4 |
104372 | 104372 | 2020-05-01 | Troup | Georgia | 13285 | 150 | 4 |
101517 | 101517 | 2020-04-30 | Troup | Georgia | 13285 | 148 | 4 |
98667 | 98667 | 2020-04-29 | Troup | Georgia | 13285 | 145 | 4 |
95822 | 95822 | 2020-04-28 | Troup | Georgia | 13285 | 140 | 4 |
92990 | 92990 | 2020-04-27 | Troup | Georgia | 13285 | 138 | 4 |
90171 | 90171 | 2020-04-26 | Troup | Georgia | 13285 | 126 | 4 |
87355 | 87355 | 2020-04-25 | Troup | Georgia | 13285 | 122 | 4 |
84546 | 84546 | 2020-04-24 | Troup | Georgia | 13285 | 122 | 4 |
81746 | 81746 | 2020-04-23 | Troup | Georgia | 13285 | 118 | 4 |
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);