ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Columbia" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386363 | 386363 | 2020-07-31 | Columbia | Georgia | 13073 | 1793 | 19 |
383145 | 383145 | 2020-07-30 | Columbia | Georgia | 13073 | 1739 | 19 |
379928 | 379928 | 2020-07-29 | Columbia | Georgia | 13073 | 1689 | 19 |
376711 | 376711 | 2020-07-28 | Columbia | Georgia | 13073 | 1615 | 18 |
373497 | 373497 | 2020-07-27 | Columbia | Georgia | 13073 | 1548 | 18 |
370285 | 370285 | 2020-07-26 | Columbia | Georgia | 13073 | 1495 | 18 |
367075 | 367075 | 2020-07-25 | Columbia | Georgia | 13073 | 1439 | 18 |
363868 | 363868 | 2020-07-24 | Columbia | Georgia | 13073 | 1395 | 18 |
360661 | 360661 | 2020-07-23 | Columbia | Georgia | 13073 | 1361 | 17 |
357456 | 357456 | 2020-07-22 | Columbia | Georgia | 13073 | 1323 | 17 |
354253 | 354253 | 2020-07-21 | Columbia | Georgia | 13073 | 1300 | 15 |
351051 | 351051 | 2020-07-20 | Columbia | Georgia | 13073 | 1242 | 14 |
347850 | 347850 | 2020-07-19 | Columbia | Georgia | 13073 | 1205 | 14 |
344650 | 344650 | 2020-07-18 | Columbia | Georgia | 13073 | 1186 | 14 |
341451 | 341451 | 2020-07-17 | Columbia | Georgia | 13073 | 1123 | 14 |
338254 | 338254 | 2020-07-16 | Columbia | Georgia | 13073 | 1057 | 13 |
335059 | 335059 | 2020-07-15 | Columbia | Georgia | 13073 | 1044 | 12 |
331866 | 331866 | 2020-07-14 | Columbia | Georgia | 13073 | 980 | 12 |
328679 | 328679 | 2020-07-13 | Columbia | Georgia | 13073 | 961 | 12 |
325493 | 325493 | 2020-07-12 | Columbia | Georgia | 13073 | 852 | 12 |
322312 | 322312 | 2020-07-11 | Columbia | Georgia | 13073 | 829 | 12 |
319133 | 319133 | 2020-07-10 | Columbia | Georgia | 13073 | 783 | 12 |
315960 | 315960 | 2020-07-09 | Columbia | Georgia | 13073 | 709 | 12 |
312785 | 312785 | 2020-07-08 | Columbia | Georgia | 13073 | 690 | 12 |
309615 | 309615 | 2020-07-07 | Columbia | Georgia | 13073 | 655 | 10 |
306447 | 306447 | 2020-07-06 | Columbia | Georgia | 13073 | 637 | 9 |
303283 | 303283 | 2020-07-05 | Columbia | Georgia | 13073 | 627 | 9 |
300119 | 300119 | 2020-07-04 | Columbia | Georgia | 13073 | 602 | 9 |
296957 | 296957 | 2020-07-03 | Columbia | Georgia | 13073 | 565 | 9 |
293801 | 293801 | 2020-07-02 | Columbia | Georgia | 13073 | 531 | 9 |
290647 | 290647 | 2020-07-01 | Columbia | Georgia | 13073 | 505 | 9 |
287496 | 287496 | 2020-06-30 | Columbia | Georgia | 13073 | 470 | 9 |
284350 | 284350 | 2020-06-29 | Columbia | Georgia | 13073 | 444 | 9 |
281204 | 281204 | 2020-06-28 | Columbia | Georgia | 13073 | 422 | 9 |
278057 | 278057 | 2020-06-27 | Columbia | Georgia | 13073 | 410 | 9 |
274909 | 274909 | 2020-06-26 | Columbia | Georgia | 13073 | 392 | 9 |
271769 | 271769 | 2020-06-25 | Columbia | Georgia | 13073 | 377 | 9 |
268633 | 268633 | 2020-06-24 | Columbia | Georgia | 13073 | 367 | 9 |
265503 | 265503 | 2020-06-23 | Columbia | Georgia | 13073 | 359 | 8 |
262375 | 262375 | 2020-06-22 | Columbia | Georgia | 13073 | 345 | 8 |
259248 | 259248 | 2020-06-21 | Columbia | Georgia | 13073 | 342 | 8 |
256121 | 256121 | 2020-06-20 | Columbia | Georgia | 13073 | 339 | 8 |
253002 | 253002 | 2020-06-19 | Columbia | Georgia | 13073 | 335 | 8 |
249887 | 249887 | 2020-06-18 | Columbia | Georgia | 13073 | 329 | 8 |
246775 | 246775 | 2020-06-17 | Columbia | Georgia | 13073 | 324 | 8 |
243662 | 243662 | 2020-06-16 | Columbia | Georgia | 13073 | 305 | 8 |
240551 | 240551 | 2020-06-15 | Columbia | Georgia | 13073 | 301 | 8 |
237443 | 237443 | 2020-06-14 | Columbia | Georgia | 13073 | 300 | 8 |
234336 | 234336 | 2020-06-13 | Columbia | Georgia | 13073 | 296 | 8 |
231230 | 231230 | 2020-06-12 | Columbia | Georgia | 13073 | 295 | 8 |
228127 | 228127 | 2020-06-11 | Columbia | Georgia | 13073 | 290 | 8 |
225025 | 225025 | 2020-06-10 | Columbia | Georgia | 13073 | 289 | 8 |
221930 | 221930 | 2020-06-09 | Columbia | Georgia | 13073 | 288 | 8 |
218835 | 218835 | 2020-06-08 | Columbia | Georgia | 13073 | 278 | 8 |
215744 | 215744 | 2020-06-07 | Columbia | Georgia | 13073 | 274 | 8 |
212657 | 212657 | 2020-06-06 | Columbia | Georgia | 13073 | 274 | 8 |
209572 | 209572 | 2020-06-05 | Columbia | Georgia | 13073 | 270 | 8 |
206491 | 206491 | 2020-06-04 | Columbia | Georgia | 13073 | 266 | 8 |
203411 | 203411 | 2020-06-03 | Columbia | Georgia | 13073 | 266 | 8 |
200335 | 200335 | 2020-06-02 | Columbia | Georgia | 13073 | 251 | 8 |
197262 | 197262 | 2020-06-01 | Columbia | Georgia | 13073 | 251 | 8 |
194192 | 194192 | 2020-05-31 | Columbia | Georgia | 13073 | 248 | 7 |
191125 | 191125 | 2020-05-30 | Columbia | Georgia | 13073 | 248 | 7 |
188060 | 188060 | 2020-05-29 | Columbia | Georgia | 13073 | 248 | 7 |
185004 | 185004 | 2020-05-28 | Columbia | Georgia | 13073 | 243 | 7 |
181950 | 181950 | 2020-05-27 | Columbia | Georgia | 13073 | 237 | 7 |
178906 | 178906 | 2020-05-26 | Columbia | Georgia | 13073 | 229 | 7 |
175862 | 175862 | 2020-05-25 | Columbia | Georgia | 13073 | 224 | 6 |
172819 | 172819 | 2020-05-24 | Columbia | Georgia | 13073 | 223 | 6 |
169778 | 169778 | 2020-05-23 | Columbia | Georgia | 13073 | 223 | 6 |
166741 | 166741 | 2020-05-22 | Columbia | Georgia | 13073 | 223 | 6 |
163708 | 163708 | 2020-05-21 | Columbia | Georgia | 13073 | 224 | 6 |
160680 | 160680 | 2020-05-20 | Columbia | Georgia | 13073 | 214 | 6 |
157654 | 157654 | 2020-05-19 | Columbia | Georgia | 13073 | 212 | 6 |
154638 | 154638 | 2020-05-18 | Columbia | Georgia | 13073 | 212 | 6 |
151626 | 151626 | 2020-05-17 | Columbia | Georgia | 13073 | 205 | 6 |
148617 | 148617 | 2020-05-16 | Columbia | Georgia | 13073 | 205 | 6 |
145614 | 145614 | 2020-05-15 | Columbia | Georgia | 13073 | 202 | 6 |
142614 | 142614 | 2020-05-14 | Columbia | Georgia | 13073 | 197 | 6 |
139618 | 139618 | 2020-05-13 | Columbia | Georgia | 13073 | 191 | 6 |
136627 | 136627 | 2020-05-12 | Columbia | Georgia | 13073 | 186 | 6 |
133638 | 133638 | 2020-05-11 | Columbia | Georgia | 13073 | 183 | 5 |
130647 | 130647 | 2020-05-10 | Columbia | Georgia | 13073 | 183 | 5 |
127656 | 127656 | 2020-05-09 | Columbia | Georgia | 13073 | 179 | 5 |
124669 | 124669 | 2020-05-08 | Columbia | Georgia | 13073 | 178 | 5 |
121690 | 121690 | 2020-05-07 | Columbia | Georgia | 13073 | 170 | 5 |
118721 | 118721 | 2020-05-06 | Columbia | Georgia | 13073 | 170 | 5 |
115761 | 115761 | 2020-05-05 | Columbia | Georgia | 13073 | 169 | 5 |
112878 | 112878 | 2020-05-04 | Columbia | Georgia | 13073 | 168 | 4 |
110003 | 110003 | 2020-05-03 | Columbia | Georgia | 13073 | 164 | 4 |
107134 | 107134 | 2020-05-02 | Columbia | Georgia | 13073 | 163 | 4 |
104269 | 104269 | 2020-05-01 | Columbia | Georgia | 13073 | 162 | 4 |
101414 | 101414 | 2020-04-30 | Columbia | Georgia | 13073 | 160 | 4 |
98564 | 98564 | 2020-04-29 | Columbia | Georgia | 13073 | 156 | 4 |
95719 | 95719 | 2020-04-28 | Columbia | Georgia | 13073 | 149 | 3 |
92887 | 92887 | 2020-04-27 | Columbia | Georgia | 13073 | 144 | 2 |
90068 | 90068 | 2020-04-26 | Columbia | Georgia | 13073 | 143 | 2 |
87252 | 87252 | 2020-04-25 | Columbia | Georgia | 13073 | 138 | 2 |
84443 | 84443 | 2020-04-24 | Columbia | Georgia | 13073 | 137 | 2 |
81643 | 81643 | 2020-04-23 | Columbia | Georgia | 13073 | 129 | 2 |
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);