ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "DeKalb" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386370 | 386370 | 2020-07-31 | DeKalb | Georgia | 13089 | 12127 | 222 |
383152 | 383152 | 2020-07-30 | DeKalb | Georgia | 13089 | 11916 | 213 |
379935 | 379935 | 2020-07-29 | DeKalb | Georgia | 13089 | 11679 | 213 |
376718 | 376718 | 2020-07-28 | DeKalb | Georgia | 13089 | 11494 | 208 |
373504 | 373504 | 2020-07-27 | DeKalb | Georgia | 13089 | 11281 | 207 |
370292 | 370292 | 2020-07-26 | DeKalb | Georgia | 13089 | 11159 | 207 |
367082 | 367082 | 2020-07-25 | DeKalb | Georgia | 13089 | 11025 | 206 |
363875 | 363875 | 2020-07-24 | DeKalb | Georgia | 13089 | 10767 | 204 |
360668 | 360668 | 2020-07-23 | DeKalb | Georgia | 13089 | 10480 | 199 |
357463 | 357463 | 2020-07-22 | DeKalb | Georgia | 13089 | 10203 | 196 |
354260 | 354260 | 2020-07-21 | DeKalb | Georgia | 13089 | 9950 | 190 |
351058 | 351058 | 2020-07-20 | DeKalb | Georgia | 13089 | 9800 | 188 |
347857 | 347857 | 2020-07-19 | DeKalb | Georgia | 13089 | 9732 | 188 |
344657 | 344657 | 2020-07-18 | DeKalb | Georgia | 13089 | 9597 | 188 |
341458 | 341458 | 2020-07-17 | DeKalb | Georgia | 13089 | 9308 | 187 |
338261 | 338261 | 2020-07-16 | DeKalb | Georgia | 13089 | 9165 | 186 |
335066 | 335066 | 2020-07-15 | DeKalb | Georgia | 13089 | 8980 | 186 |
331873 | 331873 | 2020-07-14 | DeKalb | Georgia | 13089 | 8784 | 183 |
328686 | 328686 | 2020-07-13 | DeKalb | Georgia | 13089 | 8618 | 182 |
325500 | 325500 | 2020-07-12 | DeKalb | Georgia | 13089 | 8253 | 180 |
322319 | 322319 | 2020-07-11 | DeKalb | Georgia | 13089 | 8144 | 181 |
319140 | 319140 | 2020-07-10 | DeKalb | Georgia | 13089 | 7973 | 177 |
315967 | 315967 | 2020-07-09 | DeKalb | Georgia | 13089 | 7472 | 175 |
312792 | 312792 | 2020-07-08 | DeKalb | Georgia | 13089 | 7362 | 175 |
309622 | 309622 | 2020-07-07 | DeKalb | Georgia | 13089 | 7158 | 173 |
306454 | 306454 | 2020-07-06 | DeKalb | Georgia | 13089 | 7050 | 173 |
303290 | 303290 | 2020-07-05 | DeKalb | Georgia | 13089 | 6905 | 173 |
300126 | 300126 | 2020-07-04 | DeKalb | Georgia | 13089 | 6689 | 173 |
296964 | 296964 | 2020-07-03 | DeKalb | Georgia | 13089 | 6381 | 173 |
293808 | 293808 | 2020-07-02 | DeKalb | Georgia | 13089 | 6172 | 173 |
290654 | 290654 | 2020-07-01 | DeKalb | Georgia | 13089 | 5959 | 173 |
287503 | 287503 | 2020-06-30 | DeKalb | Georgia | 13089 | 5841 | 173 |
284357 | 284357 | 2020-06-29 | DeKalb | Georgia | 13089 | 5469 | 171 |
281211 | 281211 | 2020-06-28 | DeKalb | Georgia | 13089 | 5448 | 171 |
278064 | 278064 | 2020-06-27 | DeKalb | Georgia | 13089 | 5404 | 171 |
274916 | 274916 | 2020-06-26 | DeKalb | Georgia | 13089 | 5322 | 171 |
271776 | 271776 | 2020-06-25 | DeKalb | Georgia | 13089 | 5258 | 168 |
268640 | 268640 | 2020-06-24 | DeKalb | Georgia | 13089 | 5158 | 166 |
265510 | 265510 | 2020-06-23 | DeKalb | Georgia | 13089 | 5042 | 166 |
262382 | 262382 | 2020-06-22 | DeKalb | Georgia | 13089 | 4791 | 165 |
259255 | 259255 | 2020-06-21 | DeKalb | Georgia | 13089 | 4694 | 165 |
256128 | 256128 | 2020-06-20 | DeKalb | Georgia | 13089 | 4666 | 165 |
253009 | 253009 | 2020-06-19 | DeKalb | Georgia | 13089 | 4637 | 164 |
249894 | 249894 | 2020-06-18 | DeKalb | Georgia | 13089 | 4541 | 158 |
246782 | 246782 | 2020-06-17 | DeKalb | Georgia | 13089 | 4489 | 155 |
243669 | 243669 | 2020-06-16 | DeKalb | Georgia | 13089 | 4411 | 152 |
240558 | 240558 | 2020-06-15 | DeKalb | Georgia | 13089 | 4355 | 148 |
237450 | 237450 | 2020-06-14 | DeKalb | Georgia | 13089 | 4311 | 145 |
234343 | 234343 | 2020-06-13 | DeKalb | Georgia | 13089 | 4303 | 145 |
231237 | 231237 | 2020-06-12 | DeKalb | Georgia | 13089 | 4282 | 142 |
228134 | 228134 | 2020-06-11 | DeKalb | Georgia | 13089 | 4229 | 139 |
225032 | 225032 | 2020-06-10 | DeKalb | Georgia | 13089 | 4186 | 136 |
221937 | 221937 | 2020-06-09 | DeKalb | Georgia | 13089 | 4120 | 135 |
218842 | 218842 | 2020-06-08 | DeKalb | Georgia | 13089 | 4054 | 125 |
215751 | 215751 | 2020-06-07 | DeKalb | Georgia | 13089 | 4012 | 125 |
212664 | 212664 | 2020-06-06 | DeKalb | Georgia | 13089 | 4008 | 125 |
209579 | 209579 | 2020-06-05 | DeKalb | Georgia | 13089 | 3986 | 124 |
206498 | 206498 | 2020-06-04 | DeKalb | Georgia | 13089 | 3939 | 122 |
203418 | 203418 | 2020-06-03 | DeKalb | Georgia | 13089 | 3874 | 122 |
200342 | 200342 | 2020-06-02 | DeKalb | Georgia | 13089 | 3803 | 121 |
197269 | 197269 | 2020-06-01 | DeKalb | Georgia | 13089 | 3795 | 121 |
194199 | 194199 | 2020-05-31 | DeKalb | Georgia | 13089 | 3734 | 120 |
191132 | 191132 | 2020-05-30 | DeKalb | Georgia | 13089 | 3731 | 112 |
188067 | 188067 | 2020-05-29 | DeKalb | Georgia | 13089 | 3718 | 112 |
185011 | 185011 | 2020-05-28 | DeKalb | Georgia | 13089 | 3635 | 112 |
181957 | 181957 | 2020-05-27 | DeKalb | Georgia | 13089 | 3573 | 111 |
178913 | 178913 | 2020-05-26 | DeKalb | Georgia | 13089 | 3421 | 107 |
175869 | 175869 | 2020-05-25 | DeKalb | Georgia | 13089 | 3305 | 104 |
172826 | 172826 | 2020-05-24 | DeKalb | Georgia | 13089 | 3257 | 102 |
169785 | 169785 | 2020-05-23 | DeKalb | Georgia | 13089 | 3146 | 102 |
166748 | 166748 | 2020-05-22 | DeKalb | Georgia | 13089 | 3080 | 100 |
163715 | 163715 | 2020-05-21 | DeKalb | Georgia | 13089 | 3038 | 96 |
160687 | 160687 | 2020-05-20 | DeKalb | Georgia | 13089 | 2979 | 88 |
157661 | 157661 | 2020-05-19 | DeKalb | Georgia | 13089 | 2918 | 87 |
154645 | 154645 | 2020-05-18 | DeKalb | Georgia | 13089 | 2856 | 86 |
151633 | 151633 | 2020-05-17 | DeKalb | Georgia | 13089 | 2802 | 82 |
148624 | 148624 | 2020-05-16 | DeKalb | Georgia | 13089 | 2800 | 81 |
145621 | 145621 | 2020-05-15 | DeKalb | Georgia | 13089 | 2751 | 80 |
142621 | 142621 | 2020-05-14 | DeKalb | Georgia | 13089 | 2664 | 75 |
139625 | 139625 | 2020-05-13 | DeKalb | Georgia | 13089 | 2632 | 73 |
136634 | 136634 | 2020-05-12 | DeKalb | Georgia | 13089 | 2605 | 72 |
133645 | 133645 | 2020-05-11 | DeKalb | Georgia | 13089 | 2555 | 71 |
130654 | 130654 | 2020-05-10 | DeKalb | Georgia | 13089 | 2536 | 69 |
127663 | 127663 | 2020-05-09 | DeKalb | Georgia | 13089 | 2489 | 69 |
124676 | 124676 | 2020-05-08 | DeKalb | Georgia | 13089 | 2445 | 69 |
121697 | 121697 | 2020-05-07 | DeKalb | Georgia | 13089 | 2396 | 62 |
118728 | 118728 | 2020-05-06 | DeKalb | Georgia | 13089 | 2357 | 61 |
115768 | 115768 | 2020-05-05 | DeKalb | Georgia | 13089 | 2284 | 59 |
112885 | 112885 | 2020-05-04 | DeKalb | Georgia | 13089 | 2255 | 57 |
110010 | 110010 | 2020-05-03 | DeKalb | Georgia | 13089 | 2184 | 53 |
107141 | 107141 | 2020-05-02 | DeKalb | Georgia | 13089 | 2148 | 52 |
104276 | 104276 | 2020-05-01 | DeKalb | Georgia | 13089 | 2073 | 49 |
101421 | 101421 | 2020-04-30 | DeKalb | Georgia | 13089 | 2027 | 47 |
98571 | 98571 | 2020-04-29 | DeKalb | Georgia | 13089 | 1980 | 46 |
95726 | 95726 | 2020-04-28 | DeKalb | Georgia | 13089 | 1907 | 44 |
92894 | 92894 | 2020-04-27 | DeKalb | Georgia | 13089 | 1855 | 42 |
90075 | 90075 | 2020-04-26 | DeKalb | Georgia | 13089 | 1800 | 36 |
87259 | 87259 | 2020-04-25 | DeKalb | Georgia | 13089 | 1788 | 36 |
84450 | 84450 | 2020-04-24 | DeKalb | Georgia | 13089 | 1721 | 36 |
81650 | 81650 | 2020-04-23 | DeKalb | Georgia | 13089 | 1689 | 34 |
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);