ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Scott" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387037 | 387037 | 2020-07-31 | Scott | Kentucky | 21209 | 311 | 0 |
383819 | 383819 | 2020-07-30 | Scott | Kentucky | 21209 | 298 | 0 |
380602 | 380602 | 2020-07-29 | Scott | Kentucky | 21209 | 286 | 0 |
377385 | 377385 | 2020-07-28 | Scott | Kentucky | 21209 | 268 | 0 |
374170 | 374170 | 2020-07-27 | Scott | Kentucky | 21209 | 262 | 0 |
370958 | 370958 | 2020-07-26 | Scott | Kentucky | 21209 | 261 | 0 |
367748 | 367748 | 2020-07-25 | Scott | Kentucky | 21209 | 250 | 0 |
364541 | 364541 | 2020-07-24 | Scott | Kentucky | 21209 | 220 | 0 |
361334 | 361334 | 2020-07-23 | Scott | Kentucky | 21209 | 205 | 0 |
358129 | 358129 | 2020-07-22 | Scott | Kentucky | 21209 | 193 | 0 |
354926 | 354926 | 2020-07-21 | Scott | Kentucky | 21209 | 174 | 0 |
351724 | 351724 | 2020-07-20 | Scott | Kentucky | 21209 | 169 | 0 |
348524 | 348524 | 2020-07-19 | Scott | Kentucky | 21209 | 168 | 0 |
345323 | 345323 | 2020-07-18 | Scott | Kentucky | 21209 | 153 | 0 |
342123 | 342123 | 2020-07-17 | Scott | Kentucky | 21209 | 136 | 0 |
338927 | 338927 | 2020-07-16 | Scott | Kentucky | 21209 | 137 | 0 |
335731 | 335731 | 2020-07-15 | Scott | Kentucky | 21209 | 133 | 0 |
332538 | 332538 | 2020-07-14 | Scott | Kentucky | 21209 | 131 | 0 |
329351 | 329351 | 2020-07-13 | Scott | Kentucky | 21209 | 127 | 0 |
326165 | 326165 | 2020-07-12 | Scott | Kentucky | 21209 | 127 | 0 |
322982 | 322982 | 2020-07-11 | Scott | Kentucky | 21209 | 126 | 0 |
319803 | 319803 | 2020-07-10 | Scott | Kentucky | 21209 | 117 | 0 |
316628 | 316628 | 2020-07-09 | Scott | Kentucky | 21209 | 113 | 0 |
313454 | 313454 | 2020-07-08 | Scott | Kentucky | 21209 | 112 | 0 |
310284 | 310284 | 2020-07-07 | Scott | Kentucky | 21209 | 107 | 0 |
307116 | 307116 | 2020-07-06 | Scott | Kentucky | 21209 | 101 | 0 |
303949 | 303949 | 2020-07-05 | Scott | Kentucky | 21209 | 99 | 0 |
300785 | 300785 | 2020-07-04 | Scott | Kentucky | 21209 | 99 | 0 |
297623 | 297623 | 2020-07-03 | Scott | Kentucky | 21209 | 99 | 0 |
294465 | 294465 | 2020-07-02 | Scott | Kentucky | 21209 | 97 | 0 |
291311 | 291311 | 2020-07-01 | Scott | Kentucky | 21209 | 91 | 0 |
288160 | 288160 | 2020-06-30 | Scott | Kentucky | 21209 | 87 | 0 |
285011 | 285011 | 2020-06-29 | Scott | Kentucky | 21209 | 83 | 0 |
281865 | 281865 | 2020-06-28 | Scott | Kentucky | 21209 | 82 | 0 |
278717 | 278717 | 2020-06-27 | Scott | Kentucky | 21209 | 82 | 0 |
275569 | 275569 | 2020-06-26 | Scott | Kentucky | 21209 | 83 | 0 |
272426 | 272426 | 2020-06-25 | Scott | Kentucky | 21209 | 79 | 0 |
269290 | 269290 | 2020-06-24 | Scott | Kentucky | 21209 | 76 | 0 |
266157 | 266157 | 2020-06-23 | Scott | Kentucky | 21209 | 75 | 0 |
263030 | 263030 | 2020-06-22 | Scott | Kentucky | 21209 | 67 | 0 |
259901 | 259901 | 2020-06-21 | Scott | Kentucky | 21209 | 67 | 0 |
256775 | 256775 | 2020-06-20 | Scott | Kentucky | 21209 | 66 | 0 |
253655 | 253655 | 2020-06-19 | Scott | Kentucky | 21209 | 60 | 0 |
250540 | 250540 | 2020-06-18 | Scott | Kentucky | 21209 | 57 | 0 |
247428 | 247428 | 2020-06-17 | Scott | Kentucky | 21209 | 54 | 0 |
244315 | 244315 | 2020-06-16 | Scott | Kentucky | 21209 | 54 | 0 |
241204 | 241204 | 2020-06-15 | Scott | Kentucky | 21209 | 54 | 0 |
238095 | 238095 | 2020-06-14 | Scott | Kentucky | 21209 | 54 | 0 |
234988 | 234988 | 2020-06-13 | Scott | Kentucky | 21209 | 54 | 0 |
231883 | 231883 | 2020-06-12 | Scott | Kentucky | 21209 | 54 | 0 |
228779 | 228779 | 2020-06-11 | Scott | Kentucky | 21209 | 54 | 0 |
225677 | 225677 | 2020-06-10 | Scott | Kentucky | 21209 | 54 | 0 |
222581 | 222581 | 2020-06-09 | Scott | Kentucky | 21209 | 54 | 0 |
219486 | 219486 | 2020-06-08 | Scott | Kentucky | 21209 | 54 | 0 |
216394 | 216394 | 2020-06-07 | Scott | Kentucky | 21209 | 37 | 0 |
213307 | 213307 | 2020-06-06 | Scott | Kentucky | 21209 | 37 | 0 |
210222 | 210222 | 2020-06-05 | Scott | Kentucky | 21209 | 37 | 0 |
207141 | 207141 | 2020-06-04 | Scott | Kentucky | 21209 | 37 | 0 |
204060 | 204060 | 2020-06-03 | Scott | Kentucky | 21209 | 35 | 0 |
200983 | 200983 | 2020-06-02 | Scott | Kentucky | 21209 | 35 | 0 |
197911 | 197911 | 2020-06-01 | Scott | Kentucky | 21209 | 35 | 0 |
194840 | 194840 | 2020-05-31 | Scott | Kentucky | 21209 | 35 | 0 |
191772 | 191772 | 2020-05-30 | Scott | Kentucky | 21209 | 35 | 0 |
188708 | 188708 | 2020-05-29 | Scott | Kentucky | 21209 | 35 | 0 |
185650 | 185650 | 2020-05-28 | Scott | Kentucky | 21209 | 35 | 0 |
182595 | 182595 | 2020-05-27 | Scott | Kentucky | 21209 | 35 | 0 |
179550 | 179550 | 2020-05-26 | Scott | Kentucky | 21209 | 35 | 0 |
176506 | 176506 | 2020-05-25 | Scott | Kentucky | 21209 | 34 | 0 |
173462 | 173462 | 2020-05-24 | Scott | Kentucky | 21209 | 34 | 0 |
170421 | 170421 | 2020-05-23 | Scott | Kentucky | 21209 | 34 | 0 |
167383 | 167383 | 2020-05-22 | Scott | Kentucky | 21209 | 34 | 0 |
164347 | 164347 | 2020-05-21 | Scott | Kentucky | 21209 | 34 | 0 |
161318 | 161318 | 2020-05-20 | Scott | Kentucky | 21209 | 34 | 0 |
158292 | 158292 | 2020-05-19 | Scott | Kentucky | 21209 | 34 | 0 |
155275 | 155275 | 2020-05-18 | Scott | Kentucky | 21209 | 34 | 0 |
152261 | 152261 | 2020-05-17 | Scott | Kentucky | 21209 | 34 | 0 |
149250 | 149250 | 2020-05-16 | Scott | Kentucky | 21209 | 34 | 0 |
146245 | 146245 | 2020-05-15 | Scott | Kentucky | 21209 | 34 | 0 |
143245 | 143245 | 2020-05-14 | Scott | Kentucky | 21209 | 33 | 0 |
140249 | 140249 | 2020-05-13 | Scott | Kentucky | 21209 | 33 | 0 |
137256 | 137256 | 2020-05-12 | Scott | Kentucky | 21209 | 33 | 0 |
134266 | 134266 | 2020-05-11 | Scott | Kentucky | 21209 | 32 | 0 |
131275 | 131275 | 2020-05-10 | Scott | Kentucky | 21209 | 32 | 0 |
128285 | 128285 | 2020-05-09 | Scott | Kentucky | 21209 | 32 | 0 |
125297 | 125297 | 2020-05-08 | Scott | Kentucky | 21209 | 32 | 0 |
122315 | 122315 | 2020-05-07 | Scott | Kentucky | 21209 | 32 | 0 |
119344 | 119344 | 2020-05-06 | Scott | Kentucky | 21209 | 31 | 0 |
116383 | 116383 | 2020-05-05 | Scott | Kentucky | 21209 | 31 | 0 |
113501 | 113501 | 2020-05-04 | Scott | Kentucky | 21209 | 31 | 0 |
110624 | 110624 | 2020-05-03 | Scott | Kentucky | 21209 | 29 | 0 |
107753 | 107753 | 2020-05-02 | Scott | Kentucky | 21209 | 29 | 0 |
104888 | 104888 | 2020-05-01 | Scott | Kentucky | 21209 | 29 | 0 |
102027 | 102027 | 2020-04-30 | Scott | Kentucky | 21209 | 29 | 0 |
99175 | 99175 | 2020-04-29 | Scott | Kentucky | 21209 | 29 | 0 |
96329 | 96329 | 2020-04-28 | Scott | Kentucky | 21209 | 29 | 0 |
93494 | 93494 | 2020-04-27 | Scott | Kentucky | 21209 | 28 | 0 |
90673 | 90673 | 2020-04-26 | Scott | Kentucky | 21209 | 28 | 0 |
87857 | 87857 | 2020-04-25 | Scott | Kentucky | 21209 | 28 | 0 |
85048 | 85048 | 2020-04-24 | Scott | Kentucky | 21209 | 28 | 0 |
82245 | 82245 | 2020-04-23 | Scott | Kentucky | 21209 | 28 | 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);