ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 13103 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386378 | 386378 | 2020-07-31 | Effingham | Georgia | 13103 | 614 | 1 |
383160 | 383160 | 2020-07-30 | Effingham | Georgia | 13103 | 587 | 1 |
379943 | 379943 | 2020-07-29 | Effingham | Georgia | 13103 | 571 | 1 |
376726 | 376726 | 2020-07-28 | Effingham | Georgia | 13103 | 556 | 1 |
373512 | 373512 | 2020-07-27 | Effingham | Georgia | 13103 | 542 | 1 |
370300 | 370300 | 2020-07-26 | Effingham | Georgia | 13103 | 533 | 1 |
367090 | 367090 | 2020-07-25 | Effingham | Georgia | 13103 | 524 | 1 |
363883 | 363883 | 2020-07-24 | Effingham | Georgia | 13103 | 491 | 1 |
360676 | 360676 | 2020-07-23 | Effingham | Georgia | 13103 | 468 | 1 |
357471 | 357471 | 2020-07-22 | Effingham | Georgia | 13103 | 444 | 1 |
354268 | 354268 | 2020-07-21 | Effingham | Georgia | 13103 | 435 | 1 |
351066 | 351066 | 2020-07-20 | Effingham | Georgia | 13103 | 419 | 1 |
347865 | 347865 | 2020-07-19 | Effingham | Georgia | 13103 | 400 | 1 |
344665 | 344665 | 2020-07-18 | Effingham | Georgia | 13103 | 393 | 1 |
341466 | 341466 | 2020-07-17 | Effingham | Georgia | 13103 | 380 | 1 |
338269 | 338269 | 2020-07-16 | Effingham | Georgia | 13103 | 373 | 1 |
335074 | 335074 | 2020-07-15 | Effingham | Georgia | 13103 | 360 | 1 |
331881 | 331881 | 2020-07-14 | Effingham | Georgia | 13103 | 354 | 1 |
328694 | 328694 | 2020-07-13 | Effingham | Georgia | 13103 | 333 | 1 |
325508 | 325508 | 2020-07-12 | Effingham | Georgia | 13103 | 284 | 1 |
322327 | 322327 | 2020-07-11 | Effingham | Georgia | 13103 | 273 | 1 |
319148 | 319148 | 2020-07-10 | Effingham | Georgia | 13103 | 260 | 1 |
315975 | 315975 | 2020-07-09 | Effingham | Georgia | 13103 | 224 | 1 |
312800 | 312800 | 2020-07-08 | Effingham | Georgia | 13103 | 222 | 1 |
309630 | 309630 | 2020-07-07 | Effingham | Georgia | 13103 | 216 | 1 |
306462 | 306462 | 2020-07-06 | Effingham | Georgia | 13103 | 210 | 1 |
303298 | 303298 | 2020-07-05 | Effingham | Georgia | 13103 | 200 | 1 |
300134 | 300134 | 2020-07-04 | Effingham | Georgia | 13103 | 192 | 1 |
296972 | 296972 | 2020-07-03 | Effingham | Georgia | 13103 | 175 | 1 |
293816 | 293816 | 2020-07-02 | Effingham | Georgia | 13103 | 163 | 1 |
290662 | 290662 | 2020-07-01 | Effingham | Georgia | 13103 | 148 | 1 |
287511 | 287511 | 2020-06-30 | Effingham | Georgia | 13103 | 141 | 1 |
284365 | 284365 | 2020-06-29 | Effingham | Georgia | 13103 | 131 | 1 |
281219 | 281219 | 2020-06-28 | Effingham | Georgia | 13103 | 126 | 1 |
278072 | 278072 | 2020-06-27 | Effingham | Georgia | 13103 | 123 | 1 |
274924 | 274924 | 2020-06-26 | Effingham | Georgia | 13103 | 122 | 1 |
271784 | 271784 | 2020-06-25 | Effingham | Georgia | 13103 | 117 | 1 |
268648 | 268648 | 2020-06-24 | Effingham | Georgia | 13103 | 114 | 1 |
265518 | 265518 | 2020-06-23 | Effingham | Georgia | 13103 | 111 | 1 |
262390 | 262390 | 2020-06-22 | Effingham | Georgia | 13103 | 101 | 1 |
259263 | 259263 | 2020-06-21 | Effingham | Georgia | 13103 | 98 | 1 |
256136 | 256136 | 2020-06-20 | Effingham | Georgia | 13103 | 96 | 1 |
253017 | 253017 | 2020-06-19 | Effingham | Georgia | 13103 | 95 | 1 |
249902 | 249902 | 2020-06-18 | Effingham | Georgia | 13103 | 91 | 1 |
246790 | 246790 | 2020-06-17 | Effingham | Georgia | 13103 | 88 | 1 |
243677 | 243677 | 2020-06-16 | Effingham | Georgia | 13103 | 86 | 1 |
240566 | 240566 | 2020-06-15 | Effingham | Georgia | 13103 | 86 | 1 |
237458 | 237458 | 2020-06-14 | Effingham | Georgia | 13103 | 86 | 1 |
234351 | 234351 | 2020-06-13 | Effingham | Georgia | 13103 | 86 | 1 |
231245 | 231245 | 2020-06-12 | Effingham | Georgia | 13103 | 83 | 1 |
228142 | 228142 | 2020-06-11 | Effingham | Georgia | 13103 | 84 | 1 |
225040 | 225040 | 2020-06-10 | Effingham | Georgia | 13103 | 81 | 1 |
221945 | 221945 | 2020-06-09 | Effingham | Georgia | 13103 | 81 | 1 |
218850 | 218850 | 2020-06-08 | Effingham | Georgia | 13103 | 78 | 1 |
215759 | 215759 | 2020-06-07 | Effingham | Georgia | 13103 | 78 | 1 |
212672 | 212672 | 2020-06-06 | Effingham | Georgia | 13103 | 78 | 1 |
209587 | 209587 | 2020-06-05 | Effingham | Georgia | 13103 | 78 | 1 |
206506 | 206506 | 2020-06-04 | Effingham | Georgia | 13103 | 77 | 1 |
203426 | 203426 | 2020-06-03 | Effingham | Georgia | 13103 | 75 | 1 |
200350 | 200350 | 2020-06-02 | Effingham | Georgia | 13103 | 75 | 1 |
197277 | 197277 | 2020-06-01 | Effingham | Georgia | 13103 | 74 | 1 |
194207 | 194207 | 2020-05-31 | Effingham | Georgia | 13103 | 74 | 1 |
191140 | 191140 | 2020-05-30 | Effingham | Georgia | 13103 | 73 | 1 |
188075 | 188075 | 2020-05-29 | Effingham | Georgia | 13103 | 73 | 1 |
185019 | 185019 | 2020-05-28 | Effingham | Georgia | 13103 | 75 | 1 |
181965 | 181965 | 2020-05-27 | Effingham | Georgia | 13103 | 74 | 1 |
178921 | 178921 | 2020-05-26 | Effingham | Georgia | 13103 | 75 | 1 |
175877 | 175877 | 2020-05-25 | Effingham | Georgia | 13103 | 63 | 1 |
172834 | 172834 | 2020-05-24 | Effingham | Georgia | 13103 | 63 | 1 |
169793 | 169793 | 2020-05-23 | Effingham | Georgia | 13103 | 63 | 1 |
166756 | 166756 | 2020-05-22 | Effingham | Georgia | 13103 | 61 | 1 |
163723 | 163723 | 2020-05-21 | Effingham | Georgia | 13103 | 50 | 1 |
160695 | 160695 | 2020-05-20 | Effingham | Georgia | 13103 | 48 | 1 |
157669 | 157669 | 2020-05-19 | Effingham | Georgia | 13103 | 47 | 1 |
154653 | 154653 | 2020-05-18 | Effingham | Georgia | 13103 | 45 | 1 |
151641 | 151641 | 2020-05-17 | Effingham | Georgia | 13103 | 42 | 1 |
148632 | 148632 | 2020-05-16 | Effingham | Georgia | 13103 | 42 | 1 |
145629 | 145629 | 2020-05-15 | Effingham | Georgia | 13103 | 38 | 1 |
142629 | 142629 | 2020-05-14 | Effingham | Georgia | 13103 | 38 | 1 |
139633 | 139633 | 2020-05-13 | Effingham | Georgia | 13103 | 38 | 1 |
136642 | 136642 | 2020-05-12 | Effingham | Georgia | 13103 | 38 | 1 |
133653 | 133653 | 2020-05-11 | Effingham | Georgia | 13103 | 38 | 1 |
130662 | 130662 | 2020-05-10 | Effingham | Georgia | 13103 | 38 | 1 |
127671 | 127671 | 2020-05-09 | Effingham | Georgia | 13103 | 37 | 1 |
124684 | 124684 | 2020-05-08 | Effingham | Georgia | 13103 | 37 | 1 |
121705 | 121705 | 2020-05-07 | Effingham | Georgia | 13103 | 37 | 1 |
118736 | 118736 | 2020-05-06 | Effingham | Georgia | 13103 | 38 | 1 |
115776 | 115776 | 2020-05-05 | Effingham | Georgia | 13103 | 38 | 1 |
112893 | 112893 | 2020-05-04 | Effingham | Georgia | 13103 | 36 | 1 |
110018 | 110018 | 2020-05-03 | Effingham | Georgia | 13103 | 36 | 1 |
107149 | 107149 | 2020-05-02 | Effingham | Georgia | 13103 | 36 | 1 |
104284 | 104284 | 2020-05-01 | Effingham | Georgia | 13103 | 36 | 1 |
101429 | 101429 | 2020-04-30 | Effingham | Georgia | 13103 | 35 | 1 |
98579 | 98579 | 2020-04-29 | Effingham | Georgia | 13103 | 34 | 1 |
95734 | 95734 | 2020-04-28 | Effingham | Georgia | 13103 | 34 | 1 |
92902 | 92902 | 2020-04-27 | Effingham | Georgia | 13103 | 34 | 1 |
90083 | 90083 | 2020-04-26 | Effingham | Georgia | 13103 | 34 | 1 |
87267 | 87267 | 2020-04-25 | Effingham | Georgia | 13103 | 34 | 1 |
84458 | 84458 | 2020-04-24 | Effingham | Georgia | 13103 | 34 | 1 |
81658 | 81658 | 2020-04-23 | Effingham | Georgia | 13103 | 33 | 1 |
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);