ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Ballard" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386936 | 386936 | 2020-07-31 | Ballard | Kentucky | 21007 | 30 | 0 |
383718 | 383718 | 2020-07-30 | Ballard | Kentucky | 21007 | 30 | 0 |
380501 | 380501 | 2020-07-29 | Ballard | Kentucky | 21007 | 29 | 0 |
377284 | 377284 | 2020-07-28 | Ballard | Kentucky | 21007 | 28 | 0 |
374069 | 374069 | 2020-07-27 | Ballard | Kentucky | 21007 | 28 | 0 |
370857 | 370857 | 2020-07-26 | Ballard | Kentucky | 21007 | 28 | 0 |
367647 | 367647 | 2020-07-25 | Ballard | Kentucky | 21007 | 28 | 0 |
364440 | 364440 | 2020-07-24 | Ballard | Kentucky | 21007 | 28 | 0 |
361233 | 361233 | 2020-07-23 | Ballard | Kentucky | 21007 | 26 | 0 |
358028 | 358028 | 2020-07-22 | Ballard | Kentucky | 21007 | 26 | 0 |
354825 | 354825 | 2020-07-21 | Ballard | Kentucky | 21007 | 25 | 0 |
351623 | 351623 | 2020-07-20 | Ballard | Kentucky | 21007 | 25 | 0 |
348423 | 348423 | 2020-07-19 | Ballard | Kentucky | 21007 | 25 | 0 |
345222 | 345222 | 2020-07-18 | Ballard | Kentucky | 21007 | 25 | 0 |
342022 | 342022 | 2020-07-17 | Ballard | Kentucky | 21007 | 25 | 0 |
338826 | 338826 | 2020-07-16 | Ballard | Kentucky | 21007 | 22 | 0 |
335630 | 335630 | 2020-07-15 | Ballard | Kentucky | 21007 | 22 | 0 |
332437 | 332437 | 2020-07-14 | Ballard | Kentucky | 21007 | 22 | 0 |
329250 | 329250 | 2020-07-13 | Ballard | Kentucky | 21007 | 18 | 0 |
326064 | 326064 | 2020-07-12 | Ballard | Kentucky | 21007 | 18 | 0 |
322881 | 322881 | 2020-07-11 | Ballard | Kentucky | 21007 | 17 | 0 |
319702 | 319702 | 2020-07-10 | Ballard | Kentucky | 21007 | 16 | 0 |
316527 | 316527 | 2020-07-09 | Ballard | Kentucky | 21007 | 15 | 0 |
313353 | 313353 | 2020-07-08 | Ballard | Kentucky | 21007 | 15 | 0 |
310183 | 310183 | 2020-07-07 | Ballard | Kentucky | 21007 | 15 | 0 |
307015 | 307015 | 2020-07-06 | Ballard | Kentucky | 21007 | 16 | 0 |
303848 | 303848 | 2020-07-05 | Ballard | Kentucky | 21007 | 15 | 0 |
300684 | 300684 | 2020-07-04 | Ballard | Kentucky | 21007 | 15 | 0 |
297522 | 297522 | 2020-07-03 | Ballard | Kentucky | 21007 | 15 | 0 |
294364 | 294364 | 2020-07-02 | Ballard | Kentucky | 21007 | 15 | 0 |
291210 | 291210 | 2020-07-01 | Ballard | Kentucky | 21007 | 15 | 0 |
288060 | 288060 | 2020-06-30 | Ballard | Kentucky | 21007 | 15 | 0 |
284911 | 284911 | 2020-06-29 | Ballard | Kentucky | 21007 | 15 | 0 |
281765 | 281765 | 2020-06-28 | Ballard | Kentucky | 21007 | 15 | 0 |
278617 | 278617 | 2020-06-27 | Ballard | Kentucky | 21007 | 15 | 0 |
275469 | 275469 | 2020-06-26 | Ballard | Kentucky | 21007 | 15 | 0 |
272326 | 272326 | 2020-06-25 | Ballard | Kentucky | 21007 | 15 | 0 |
269190 | 269190 | 2020-06-24 | Ballard | Kentucky | 21007 | 15 | 0 |
266057 | 266057 | 2020-06-23 | Ballard | Kentucky | 21007 | 15 | 0 |
262930 | 262930 | 2020-06-22 | Ballard | Kentucky | 21007 | 15 | 0 |
259801 | 259801 | 2020-06-21 | Ballard | Kentucky | 21007 | 15 | 0 |
256675 | 256675 | 2020-06-20 | Ballard | Kentucky | 21007 | 15 | 0 |
253555 | 253555 | 2020-06-19 | Ballard | Kentucky | 21007 | 15 | 0 |
250440 | 250440 | 2020-06-18 | Ballard | Kentucky | 21007 | 15 | 0 |
247328 | 247328 | 2020-06-17 | Ballard | Kentucky | 21007 | 15 | 0 |
244215 | 244215 | 2020-06-16 | Ballard | Kentucky | 21007 | 15 | 0 |
241104 | 241104 | 2020-06-15 | Ballard | Kentucky | 21007 | 15 | 0 |
237995 | 237995 | 2020-06-14 | Ballard | Kentucky | 21007 | 15 | 0 |
234888 | 234888 | 2020-06-13 | Ballard | Kentucky | 21007 | 14 | 0 |
231783 | 231783 | 2020-06-12 | Ballard | Kentucky | 21007 | 14 | 0 |
228679 | 228679 | 2020-06-11 | Ballard | Kentucky | 21007 | 13 | 0 |
225577 | 225577 | 2020-06-10 | Ballard | Kentucky | 21007 | 13 | 0 |
222481 | 222481 | 2020-06-09 | Ballard | Kentucky | 21007 | 13 | 0 |
219386 | 219386 | 2020-06-08 | Ballard | Kentucky | 21007 | 13 | 0 |
216294 | 216294 | 2020-06-07 | Ballard | Kentucky | 21007 | 13 | 0 |
213207 | 213207 | 2020-06-06 | Ballard | Kentucky | 21007 | 13 | 0 |
210122 | 210122 | 2020-06-05 | Ballard | Kentucky | 21007 | 12 | 0 |
207041 | 207041 | 2020-06-04 | Ballard | Kentucky | 21007 | 12 | 0 |
203960 | 203960 | 2020-06-03 | Ballard | Kentucky | 21007 | 12 | 0 |
200883 | 200883 | 2020-06-02 | Ballard | Kentucky | 21007 | 12 | 0 |
197812 | 197812 | 2020-06-01 | Ballard | Kentucky | 21007 | 12 | 0 |
194741 | 194741 | 2020-05-31 | Ballard | Kentucky | 21007 | 12 | 0 |
191673 | 191673 | 2020-05-30 | Ballard | Kentucky | 21007 | 12 | 0 |
188609 | 188609 | 2020-05-29 | Ballard | Kentucky | 21007 | 10 | 0 |
185551 | 185551 | 2020-05-28 | Ballard | Kentucky | 21007 | 10 | 0 |
182497 | 182497 | 2020-05-27 | Ballard | Kentucky | 21007 | 10 | 0 |
179452 | 179452 | 2020-05-26 | Ballard | Kentucky | 21007 | 10 | 0 |
176408 | 176408 | 2020-05-25 | Ballard | Kentucky | 21007 | 10 | 0 |
173364 | 173364 | 2020-05-24 | Ballard | Kentucky | 21007 | 10 | 0 |
170323 | 170323 | 2020-05-23 | Ballard | Kentucky | 21007 | 10 | 0 |
167285 | 167285 | 2020-05-22 | Ballard | Kentucky | 21007 | 10 | 0 |
164249 | 164249 | 2020-05-21 | Ballard | Kentucky | 21007 | 10 | 0 |
161220 | 161220 | 2020-05-20 | Ballard | Kentucky | 21007 | 10 | 0 |
158195 | 158195 | 2020-05-19 | Ballard | Kentucky | 21007 | 10 | 0 |
155178 | 155178 | 2020-05-18 | Ballard | Kentucky | 21007 | 10 | 0 |
152165 | 152165 | 2020-05-17 | Ballard | Kentucky | 21007 | 10 | 0 |
149154 | 149154 | 2020-05-16 | Ballard | Kentucky | 21007 | 10 | 0 |
146150 | 146150 | 2020-05-15 | Ballard | Kentucky | 21007 | 10 | 0 |
143150 | 143150 | 2020-05-14 | Ballard | Kentucky | 21007 | 10 | 0 |
140154 | 140154 | 2020-05-13 | Ballard | Kentucky | 21007 | 8 | 0 |
137161 | 137161 | 2020-05-12 | Ballard | Kentucky | 21007 | 8 | 0 |
134171 | 134171 | 2020-05-11 | Ballard | Kentucky | 21007 | 8 | 0 |
131180 | 131180 | 2020-05-10 | Ballard | Kentucky | 21007 | 8 | 0 |
128190 | 128190 | 2020-05-09 | Ballard | Kentucky | 21007 | 8 | 0 |
125202 | 125202 | 2020-05-08 | Ballard | Kentucky | 21007 | 8 | 0 |
122220 | 122220 | 2020-05-07 | Ballard | Kentucky | 21007 | 8 | 0 |
119250 | 119250 | 2020-05-06 | Ballard | Kentucky | 21007 | 8 | 0 |
116289 | 116289 | 2020-05-05 | Ballard | Kentucky | 21007 | 8 | 0 |
113407 | 113407 | 2020-05-04 | Ballard | Kentucky | 21007 | 8 | 0 |
110530 | 110530 | 2020-05-03 | Ballard | Kentucky | 21007 | 10 | 0 |
107659 | 107659 | 2020-05-02 | Ballard | Kentucky | 21007 | 10 | 0 |
104794 | 104794 | 2020-05-01 | Ballard | Kentucky | 21007 | 10 | 0 |
101933 | 101933 | 2020-04-30 | Ballard | Kentucky | 21007 | 9 | 0 |
99081 | 99081 | 2020-04-29 | Ballard | Kentucky | 21007 | 9 | 0 |
96235 | 96235 | 2020-04-28 | Ballard | Kentucky | 21007 | 9 | 0 |
93402 | 93402 | 2020-04-27 | Ballard | Kentucky | 21007 | 7 | 0 |
90581 | 90581 | 2020-04-26 | Ballard | Kentucky | 21007 | 7 | 0 |
87765 | 87765 | 2020-04-25 | Ballard | Kentucky | 21007 | 5 | 0 |
84956 | 84956 | 2020-04-24 | Ballard | Kentucky | 21007 | 5 | 0 |
82153 | 82153 | 2020-04-23 | Ballard | Kentucky | 21007 | 4 | 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);