ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,428 rows where county = "Powell" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22494 | 22494 | 2020-03-31 | Powell | Kentucky | 21197 | 1 | 0 |
24670 | 24670 | 2020-04-01 | Powell | Kentucky | 21197 | 1 | 0 |
26920 | 26920 | 2020-04-02 | Powell | Kentucky | 21197 | 1 | 0 |
29236 | 29236 | 2020-04-03 | Powell | Kentucky | 21197 | 1 | 0 |
31614 | 31614 | 2020-04-04 | Powell | Kentucky | 21197 | 1 | 0 |
34039 | 34039 | 2020-04-05 | Powell | Kentucky | 21197 | 1 | 0 |
36497 | 36497 | 2020-04-06 | Powell | Kentucky | 21197 | 1 | 0 |
39004 | 39004 | 2020-04-07 | Powell | Kentucky | 21197 | 1 | 0 |
41554 | 41554 | 2020-04-08 | Powell | Kentucky | 21197 | 1 | 0 |
44130 | 44130 | 2020-04-09 | Powell | Kentucky | 21197 | 1 | 0 |
46738 | 46738 | 2020-04-10 | Powell | Kentucky | 21197 | 2 | 0 |
49378 | 49378 | 2020-04-11 | Powell | Kentucky | 21197 | 2 | 0 |
52046 | 52046 | 2020-04-12 | Powell | Kentucky | 21197 | 1 | 0 |
54727 | 54727 | 2020-04-13 | Powell | Kentucky | 21197 | 1 | 0 |
57425 | 57425 | 2020-04-14 | Powell | Kentucky | 21197 | 1 | 0 |
60134 | 60134 | 2020-04-15 | Powell | Kentucky | 21197 | 1 | 0 |
62854 | 62854 | 2020-04-16 | Powell | Kentucky | 21197 | 1 | 0 |
65593 | 65593 | 2020-04-17 | Powell | Kentucky | 21197 | 1 | 0 |
68342 | 68342 | 2020-04-18 | Powell | Kentucky | 21197 | 1 | 0 |
71105 | 71105 | 2020-04-19 | Powell | Kentucky | 21197 | 1 | 0 |
73877 | 73877 | 2020-04-20 | Powell | Kentucky | 21197 | 1 | 0 |
76658 | 76658 | 2020-04-21 | Powell | Kentucky | 21197 | 1 | 0 |
79443 | 79443 | 2020-04-22 | Powell | Kentucky | 21197 | 1 | 0 |
82240 | 82240 | 2020-04-23 | Powell | Kentucky | 21197 | 1 | 0 |
85043 | 85043 | 2020-04-24 | Powell | Kentucky | 21197 | 1 | 0 |
87852 | 87852 | 2020-04-25 | Powell | Kentucky | 21197 | 1 | 0 |
90668 | 90668 | 2020-04-26 | Powell | Kentucky | 21197 | 1 | 0 |
93489 | 93489 | 2020-04-27 | Powell | Kentucky | 21197 | 1 | 0 |
96324 | 96324 | 2020-04-28 | Powell | Kentucky | 21197 | 1 | 0 |
99170 | 99170 | 2020-04-29 | Powell | Kentucky | 21197 | 1 | 0 |
102022 | 102022 | 2020-04-30 | Powell | Kentucky | 21197 | 1 | 0 |
104883 | 104883 | 2020-05-01 | Powell | Kentucky | 21197 | 1 | 0 |
107748 | 107748 | 2020-05-02 | Powell | Kentucky | 21197 | 1 | 0 |
110619 | 110619 | 2020-05-03 | Powell | Kentucky | 21197 | 1 | 0 |
113496 | 113496 | 2020-05-04 | Powell | Kentucky | 21197 | 1 | 0 |
116378 | 116378 | 2020-05-05 | Powell | Kentucky | 21197 | 1 | 0 |
119339 | 119339 | 2020-05-06 | Powell | Kentucky | 21197 | 1 | 0 |
122310 | 122310 | 2020-05-07 | Powell | Kentucky | 21197 | 1 | 0 |
125292 | 125292 | 2020-05-08 | Powell | Kentucky | 21197 | 1 | 0 |
128280 | 128280 | 2020-05-09 | Powell | Kentucky | 21197 | 1 | 0 |
131270 | 131270 | 2020-05-10 | Powell | Kentucky | 21197 | 1 | 0 |
134261 | 134261 | 2020-05-11 | Powell | Kentucky | 21197 | 1 | 0 |
137251 | 137251 | 2020-05-12 | Powell | Kentucky | 21197 | 1 | 0 |
140244 | 140244 | 2020-05-13 | Powell | Kentucky | 21197 | 1 | 0 |
143240 | 143240 | 2020-05-14 | Powell | Kentucky | 21197 | 1 | 0 |
146240 | 146240 | 2020-05-15 | Powell | Kentucky | 21197 | 1 | 0 |
149245 | 149245 | 2020-05-16 | Powell | Kentucky | 21197 | 1 | 0 |
152256 | 152256 | 2020-05-17 | Powell | Kentucky | 21197 | 1 | 0 |
155270 | 155270 | 2020-05-18 | Powell | Kentucky | 21197 | 1 | 0 |
158287 | 158287 | 2020-05-19 | Powell | Kentucky | 21197 | 1 | 0 |
161313 | 161313 | 2020-05-20 | Powell | Kentucky | 21197 | 1 | 0 |
164342 | 164342 | 2020-05-21 | Powell | Kentucky | 21197 | 1 | 0 |
167378 | 167378 | 2020-05-22 | Powell | Kentucky | 21197 | 1 | 0 |
170416 | 170416 | 2020-05-23 | Powell | Kentucky | 21197 | 1 | 0 |
173457 | 173457 | 2020-05-24 | Powell | Kentucky | 21197 | 1 | 0 |
176501 | 176501 | 2020-05-25 | Powell | Kentucky | 21197 | 1 | 0 |
179545 | 179545 | 2020-05-26 | Powell | Kentucky | 21197 | 1 | 0 |
182590 | 182590 | 2020-05-27 | Powell | Kentucky | 21197 | 1 | 0 |
185645 | 185645 | 2020-05-28 | Powell | Kentucky | 21197 | 1 | 0 |
188703 | 188703 | 2020-05-29 | Powell | Kentucky | 21197 | 1 | 0 |
191767 | 191767 | 2020-05-30 | Powell | Kentucky | 21197 | 1 | 0 |
194835 | 194835 | 2020-05-31 | Powell | Kentucky | 21197 | 1 | 0 |
197906 | 197906 | 2020-06-01 | Powell | Kentucky | 21197 | 1 | 0 |
200978 | 200978 | 2020-06-02 | Powell | Kentucky | 21197 | 1 | 0 |
204055 | 204055 | 2020-06-03 | Powell | Kentucky | 21197 | 1 | 0 |
207136 | 207136 | 2020-06-04 | Powell | Kentucky | 21197 | 1 | 0 |
210217 | 210217 | 2020-06-05 | Powell | Kentucky | 21197 | 1 | 0 |
213302 | 213302 | 2020-06-06 | Powell | Kentucky | 21197 | 1 | 0 |
216389 | 216389 | 2020-06-07 | Powell | Kentucky | 21197 | 1 | 0 |
219481 | 219481 | 2020-06-08 | Powell | Kentucky | 21197 | 1 | 0 |
222576 | 222576 | 2020-06-09 | Powell | Kentucky | 21197 | 2 | 0 |
225672 | 225672 | 2020-06-10 | Powell | Kentucky | 21197 | 3 | 0 |
228774 | 228774 | 2020-06-11 | Powell | Kentucky | 21197 | 3 | 0 |
231878 | 231878 | 2020-06-12 | Powell | Kentucky | 21197 | 4 | 0 |
234983 | 234983 | 2020-06-13 | Powell | Kentucky | 21197 | 4 | 0 |
238090 | 238090 | 2020-06-14 | Powell | Kentucky | 21197 | 4 | 0 |
241199 | 241199 | 2020-06-15 | Powell | Kentucky | 21197 | 5 | 0 |
244310 | 244310 | 2020-06-16 | Powell | Kentucky | 21197 | 5 | 0 |
247423 | 247423 | 2020-06-17 | Powell | Kentucky | 21197 | 5 | 0 |
250535 | 250535 | 2020-06-18 | Powell | Kentucky | 21197 | 5 | 0 |
253650 | 253650 | 2020-06-19 | Powell | Kentucky | 21197 | 5 | 0 |
256770 | 256770 | 2020-06-20 | Powell | Kentucky | 21197 | 5 | 0 |
259896 | 259896 | 2020-06-21 | Powell | Kentucky | 21197 | 5 | 0 |
263025 | 263025 | 2020-06-22 | Powell | Kentucky | 21197 | 5 | 0 |
266152 | 266152 | 2020-06-23 | Powell | Kentucky | 21197 | 5 | 0 |
269285 | 269285 | 2020-06-24 | Powell | Kentucky | 21197 | 5 | 0 |
272421 | 272421 | 2020-06-25 | Powell | Kentucky | 21197 | 5 | 0 |
275564 | 275564 | 2020-06-26 | Powell | Kentucky | 21197 | 6 | 0 |
278712 | 278712 | 2020-06-27 | Powell | Kentucky | 21197 | 6 | 0 |
281860 | 281860 | 2020-06-28 | Powell | Kentucky | 21197 | 6 | 0 |
285006 | 285006 | 2020-06-29 | Powell | Kentucky | 21197 | 6 | 0 |
288155 | 288155 | 2020-06-30 | Powell | Kentucky | 21197 | 6 | 0 |
291305 | 291305 | 2020-07-01 | Powell | Kentucky | 21197 | 7 | 0 |
294459 | 294459 | 2020-07-02 | Powell | Kentucky | 21197 | 7 | 0 |
297617 | 297617 | 2020-07-03 | Powell | Kentucky | 21197 | 8 | 0 |
300779 | 300779 | 2020-07-04 | Powell | Kentucky | 21197 | 8 | 0 |
303943 | 303943 | 2020-07-05 | Powell | Kentucky | 21197 | 8 | 0 |
307110 | 307110 | 2020-07-06 | Powell | Kentucky | 21197 | 8 | 0 |
310278 | 310278 | 2020-07-07 | Powell | Kentucky | 21197 | 8 | 0 |
313448 | 313448 | 2020-07-08 | Powell | Kentucky | 21197 | 8 | 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);