ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Powell" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387031 | 387031 | 2020-07-31 | Powell | Kentucky | 21197 | 42 | 0 |
383813 | 383813 | 2020-07-30 | Powell | Kentucky | 21197 | 41 | 0 |
380596 | 380596 | 2020-07-29 | Powell | Kentucky | 21197 | 40 | 0 |
377379 | 377379 | 2020-07-28 | Powell | Kentucky | 21197 | 38 | 0 |
374164 | 374164 | 2020-07-27 | Powell | Kentucky | 21197 | 38 | 0 |
370952 | 370952 | 2020-07-26 | Powell | Kentucky | 21197 | 36 | 0 |
367742 | 367742 | 2020-07-25 | Powell | Kentucky | 21197 | 34 | 0 |
364535 | 364535 | 2020-07-24 | Powell | Kentucky | 21197 | 32 | 0 |
361328 | 361328 | 2020-07-23 | Powell | Kentucky | 21197 | 30 | 0 |
358123 | 358123 | 2020-07-22 | Powell | Kentucky | 21197 | 31 | 0 |
354920 | 354920 | 2020-07-21 | Powell | Kentucky | 21197 | 33 | 0 |
351718 | 351718 | 2020-07-20 | Powell | Kentucky | 21197 | 30 | 0 |
348518 | 348518 | 2020-07-19 | Powell | Kentucky | 21197 | 29 | 0 |
345317 | 345317 | 2020-07-18 | Powell | Kentucky | 21197 | 21 | 0 |
342117 | 342117 | 2020-07-17 | Powell | Kentucky | 21197 | 20 | 0 |
338921 | 338921 | 2020-07-16 | Powell | Kentucky | 21197 | 17 | 0 |
335725 | 335725 | 2020-07-15 | Powell | Kentucky | 21197 | 15 | 0 |
332532 | 332532 | 2020-07-14 | Powell | Kentucky | 21197 | 13 | 0 |
329345 | 329345 | 2020-07-13 | Powell | Kentucky | 21197 | 10 | 0 |
326159 | 326159 | 2020-07-12 | Powell | Kentucky | 21197 | 10 | 0 |
322976 | 322976 | 2020-07-11 | Powell | Kentucky | 21197 | 10 | 0 |
319797 | 319797 | 2020-07-10 | Powell | Kentucky | 21197 | 9 | 0 |
316622 | 316622 | 2020-07-09 | Powell | Kentucky | 21197 | 9 | 0 |
313448 | 313448 | 2020-07-08 | Powell | Kentucky | 21197 | 8 | 0 |
310278 | 310278 | 2020-07-07 | Powell | Kentucky | 21197 | 8 | 0 |
307110 | 307110 | 2020-07-06 | Powell | Kentucky | 21197 | 8 | 0 |
303943 | 303943 | 2020-07-05 | Powell | Kentucky | 21197 | 8 | 0 |
300779 | 300779 | 2020-07-04 | Powell | Kentucky | 21197 | 8 | 0 |
297617 | 297617 | 2020-07-03 | Powell | Kentucky | 21197 | 8 | 0 |
294459 | 294459 | 2020-07-02 | Powell | Kentucky | 21197 | 7 | 0 |
291305 | 291305 | 2020-07-01 | Powell | Kentucky | 21197 | 7 | 0 |
288155 | 288155 | 2020-06-30 | Powell | Kentucky | 21197 | 6 | 0 |
285006 | 285006 | 2020-06-29 | Powell | Kentucky | 21197 | 6 | 0 |
281860 | 281860 | 2020-06-28 | Powell | Kentucky | 21197 | 6 | 0 |
278712 | 278712 | 2020-06-27 | Powell | Kentucky | 21197 | 6 | 0 |
275564 | 275564 | 2020-06-26 | Powell | Kentucky | 21197 | 6 | 0 |
272421 | 272421 | 2020-06-25 | Powell | Kentucky | 21197 | 5 | 0 |
269285 | 269285 | 2020-06-24 | Powell | Kentucky | 21197 | 5 | 0 |
266152 | 266152 | 2020-06-23 | Powell | Kentucky | 21197 | 5 | 0 |
263025 | 263025 | 2020-06-22 | Powell | Kentucky | 21197 | 5 | 0 |
259896 | 259896 | 2020-06-21 | Powell | Kentucky | 21197 | 5 | 0 |
256770 | 256770 | 2020-06-20 | Powell | Kentucky | 21197 | 5 | 0 |
253650 | 253650 | 2020-06-19 | Powell | Kentucky | 21197 | 5 | 0 |
250535 | 250535 | 2020-06-18 | Powell | Kentucky | 21197 | 5 | 0 |
247423 | 247423 | 2020-06-17 | Powell | Kentucky | 21197 | 5 | 0 |
244310 | 244310 | 2020-06-16 | Powell | Kentucky | 21197 | 5 | 0 |
241199 | 241199 | 2020-06-15 | Powell | Kentucky | 21197 | 5 | 0 |
238090 | 238090 | 2020-06-14 | Powell | Kentucky | 21197 | 4 | 0 |
234983 | 234983 | 2020-06-13 | Powell | Kentucky | 21197 | 4 | 0 |
231878 | 231878 | 2020-06-12 | Powell | Kentucky | 21197 | 4 | 0 |
228774 | 228774 | 2020-06-11 | Powell | Kentucky | 21197 | 3 | 0 |
225672 | 225672 | 2020-06-10 | Powell | Kentucky | 21197 | 3 | 0 |
222576 | 222576 | 2020-06-09 | Powell | Kentucky | 21197 | 2 | 0 |
219481 | 219481 | 2020-06-08 | Powell | Kentucky | 21197 | 1 | 0 |
216389 | 216389 | 2020-06-07 | Powell | Kentucky | 21197 | 1 | 0 |
213302 | 213302 | 2020-06-06 | Powell | Kentucky | 21197 | 1 | 0 |
210217 | 210217 | 2020-06-05 | Powell | Kentucky | 21197 | 1 | 0 |
207136 | 207136 | 2020-06-04 | Powell | Kentucky | 21197 | 1 | 0 |
204055 | 204055 | 2020-06-03 | Powell | Kentucky | 21197 | 1 | 0 |
200978 | 200978 | 2020-06-02 | Powell | Kentucky | 21197 | 1 | 0 |
197906 | 197906 | 2020-06-01 | Powell | Kentucky | 21197 | 1 | 0 |
194835 | 194835 | 2020-05-31 | Powell | Kentucky | 21197 | 1 | 0 |
191767 | 191767 | 2020-05-30 | Powell | Kentucky | 21197 | 1 | 0 |
188703 | 188703 | 2020-05-29 | Powell | Kentucky | 21197 | 1 | 0 |
185645 | 185645 | 2020-05-28 | Powell | Kentucky | 21197 | 1 | 0 |
182590 | 182590 | 2020-05-27 | Powell | Kentucky | 21197 | 1 | 0 |
179545 | 179545 | 2020-05-26 | Powell | Kentucky | 21197 | 1 | 0 |
176501 | 176501 | 2020-05-25 | Powell | Kentucky | 21197 | 1 | 0 |
173457 | 173457 | 2020-05-24 | Powell | Kentucky | 21197 | 1 | 0 |
170416 | 170416 | 2020-05-23 | Powell | Kentucky | 21197 | 1 | 0 |
167378 | 167378 | 2020-05-22 | Powell | Kentucky | 21197 | 1 | 0 |
164342 | 164342 | 2020-05-21 | Powell | Kentucky | 21197 | 1 | 0 |
161313 | 161313 | 2020-05-20 | Powell | Kentucky | 21197 | 1 | 0 |
158287 | 158287 | 2020-05-19 | Powell | Kentucky | 21197 | 1 | 0 |
155270 | 155270 | 2020-05-18 | Powell | Kentucky | 21197 | 1 | 0 |
152256 | 152256 | 2020-05-17 | Powell | Kentucky | 21197 | 1 | 0 |
149245 | 149245 | 2020-05-16 | Powell | Kentucky | 21197 | 1 | 0 |
146240 | 146240 | 2020-05-15 | Powell | Kentucky | 21197 | 1 | 0 |
143240 | 143240 | 2020-05-14 | Powell | Kentucky | 21197 | 1 | 0 |
140244 | 140244 | 2020-05-13 | Powell | Kentucky | 21197 | 1 | 0 |
137251 | 137251 | 2020-05-12 | Powell | Kentucky | 21197 | 1 | 0 |
134261 | 134261 | 2020-05-11 | Powell | Kentucky | 21197 | 1 | 0 |
131270 | 131270 | 2020-05-10 | Powell | Kentucky | 21197 | 1 | 0 |
128280 | 128280 | 2020-05-09 | Powell | Kentucky | 21197 | 1 | 0 |
125292 | 125292 | 2020-05-08 | Powell | Kentucky | 21197 | 1 | 0 |
122310 | 122310 | 2020-05-07 | Powell | Kentucky | 21197 | 1 | 0 |
119339 | 119339 | 2020-05-06 | Powell | Kentucky | 21197 | 1 | 0 |
116378 | 116378 | 2020-05-05 | Powell | Kentucky | 21197 | 1 | 0 |
113496 | 113496 | 2020-05-04 | Powell | Kentucky | 21197 | 1 | 0 |
110619 | 110619 | 2020-05-03 | Powell | Kentucky | 21197 | 1 | 0 |
107748 | 107748 | 2020-05-02 | Powell | Kentucky | 21197 | 1 | 0 |
104883 | 104883 | 2020-05-01 | Powell | Kentucky | 21197 | 1 | 0 |
102022 | 102022 | 2020-04-30 | Powell | Kentucky | 21197 | 1 | 0 |
99170 | 99170 | 2020-04-29 | Powell | Kentucky | 21197 | 1 | 0 |
96324 | 96324 | 2020-04-28 | Powell | Kentucky | 21197 | 1 | 0 |
93489 | 93489 | 2020-04-27 | Powell | Kentucky | 21197 | 1 | 0 |
90668 | 90668 | 2020-04-26 | Powell | Kentucky | 21197 | 1 | 0 |
87852 | 87852 | 2020-04-25 | Powell | Kentucky | 21197 | 1 | 0 |
85043 | 85043 | 2020-04-24 | Powell | Kentucky | 21197 | 1 | 0 |
82240 | 82240 | 2020-04-23 | Powell | Kentucky | 21197 | 1 | 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);