ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where fips = 21235 and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
41570 | 41570 | 2020-04-08 | Whitley | Kentucky | 21235 | 1 | 0 |
44146 | 44146 | 2020-04-09 | Whitley | Kentucky | 21235 | 1 | 0 |
46754 | 46754 | 2020-04-10 | Whitley | Kentucky | 21235 | 1 | 0 |
49395 | 49395 | 2020-04-11 | Whitley | Kentucky | 21235 | 4 | 0 |
52065 | 52065 | 2020-04-12 | Whitley | Kentucky | 21235 | 5 | 0 |
54746 | 54746 | 2020-04-13 | Whitley | Kentucky | 21235 | 5 | 0 |
57444 | 57444 | 2020-04-14 | Whitley | Kentucky | 21235 | 5 | 0 |
60152 | 60152 | 2020-04-15 | Whitley | Kentucky | 21235 | 7 | 0 |
62873 | 62873 | 2020-04-16 | Whitley | Kentucky | 21235 | 7 | 0 |
65612 | 65612 | 2020-04-17 | Whitley | Kentucky | 21235 | 8 | 0 |
68361 | 68361 | 2020-04-18 | Whitley | Kentucky | 21235 | 8 | 0 |
71124 | 71124 | 2020-04-19 | Whitley | Kentucky | 21235 | 8 | 0 |
73896 | 73896 | 2020-04-20 | Whitley | Kentucky | 21235 | 8 | 0 |
76676 | 76676 | 2020-04-21 | Whitley | Kentucky | 21235 | 8 | 0 |
79462 | 79462 | 2020-04-22 | Whitley | Kentucky | 21235 | 10 | 0 |
82258 | 82258 | 2020-04-23 | Whitley | Kentucky | 21235 | 10 | 0 |
85062 | 85062 | 2020-04-24 | Whitley | Kentucky | 21235 | 10 | 0 |
87871 | 87871 | 2020-04-25 | Whitley | Kentucky | 21235 | 10 | 0 |
90687 | 90687 | 2020-04-26 | Whitley | Kentucky | 21235 | 11 | 0 |
93508 | 93508 | 2020-04-27 | Whitley | Kentucky | 21235 | 11 | 0 |
96343 | 96343 | 2020-04-28 | Whitley | Kentucky | 21235 | 11 | 0 |
99189 | 99189 | 2020-04-29 | Whitley | Kentucky | 21235 | 11 | 0 |
102041 | 102041 | 2020-04-30 | Whitley | Kentucky | 21235 | 11 | 0 |
104902 | 104902 | 2020-05-01 | Whitley | Kentucky | 21235 | 11 | 0 |
107766 | 107766 | 2020-05-02 | Whitley | Kentucky | 21235 | 11 | 0 |
110638 | 110638 | 2020-05-03 | Whitley | Kentucky | 21235 | 11 | 0 |
113515 | 113515 | 2020-05-04 | Whitley | Kentucky | 21235 | 11 | 0 |
116397 | 116397 | 2020-05-05 | Whitley | Kentucky | 21235 | 11 | 0 |
119358 | 119358 | 2020-05-06 | Whitley | Kentucky | 21235 | 11 | 0 |
122329 | 122329 | 2020-05-07 | Whitley | Kentucky | 21235 | 11 | 0 |
125311 | 125311 | 2020-05-08 | Whitley | Kentucky | 21235 | 11 | 0 |
128298 | 128298 | 2020-05-09 | Whitley | Kentucky | 21235 | 11 | 0 |
131288 | 131288 | 2020-05-10 | Whitley | Kentucky | 21235 | 11 | 0 |
134279 | 134279 | 2020-05-11 | Whitley | Kentucky | 21235 | 12 | 0 |
137269 | 137269 | 2020-05-12 | Whitley | Kentucky | 21235 | 12 | 0 |
140263 | 140263 | 2020-05-13 | Whitley | Kentucky | 21235 | 12 | 0 |
143258 | 143258 | 2020-05-14 | Whitley | Kentucky | 21235 | 12 | 0 |
146258 | 146258 | 2020-05-15 | Whitley | Kentucky | 21235 | 12 | 0 |
149263 | 149263 | 2020-05-16 | Whitley | Kentucky | 21235 | 12 | 0 |
152274 | 152274 | 2020-05-17 | Whitley | Kentucky | 21235 | 12 | 0 |
155288 | 155288 | 2020-05-18 | Whitley | Kentucky | 21235 | 12 | 0 |
158305 | 158305 | 2020-05-19 | Whitley | Kentucky | 21235 | 13 | 0 |
161331 | 161331 | 2020-05-20 | Whitley | Kentucky | 21235 | 13 | 0 |
164360 | 164360 | 2020-05-21 | Whitley | Kentucky | 21235 | 13 | 0 |
167396 | 167396 | 2020-05-22 | Whitley | Kentucky | 21235 | 13 | 0 |
170434 | 170434 | 2020-05-23 | Whitley | Kentucky | 21235 | 13 | 0 |
173475 | 173475 | 2020-05-24 | Whitley | Kentucky | 21235 | 13 | 0 |
176519 | 176519 | 2020-05-25 | Whitley | Kentucky | 21235 | 13 | 0 |
179563 | 179563 | 2020-05-26 | Whitley | Kentucky | 21235 | 13 | 0 |
182608 | 182608 | 2020-05-27 | Whitley | Kentucky | 21235 | 13 | 0 |
185663 | 185663 | 2020-05-28 | Whitley | Kentucky | 21235 | 13 | 0 |
188721 | 188721 | 2020-05-29 | Whitley | Kentucky | 21235 | 13 | 0 |
191785 | 191785 | 2020-05-30 | Whitley | Kentucky | 21235 | 13 | 0 |
194853 | 194853 | 2020-05-31 | Whitley | Kentucky | 21235 | 13 | 0 |
197924 | 197924 | 2020-06-01 | Whitley | Kentucky | 21235 | 13 | 0 |
200996 | 200996 | 2020-06-02 | Whitley | Kentucky | 21235 | 13 | 0 |
204073 | 204073 | 2020-06-03 | Whitley | Kentucky | 21235 | 13 | 0 |
207154 | 207154 | 2020-06-04 | Whitley | Kentucky | 21235 | 13 | 0 |
210235 | 210235 | 2020-06-05 | Whitley | Kentucky | 21235 | 13 | 0 |
213320 | 213320 | 2020-06-06 | Whitley | Kentucky | 21235 | 13 | 0 |
216407 | 216407 | 2020-06-07 | Whitley | Kentucky | 21235 | 13 | 0 |
219499 | 219499 | 2020-06-08 | Whitley | Kentucky | 21235 | 13 | 0 |
222594 | 222594 | 2020-06-09 | Whitley | Kentucky | 21235 | 14 | 0 |
225690 | 225690 | 2020-06-10 | Whitley | Kentucky | 21235 | 15 | 0 |
228792 | 228792 | 2020-06-11 | Whitley | Kentucky | 21235 | 15 | 0 |
231896 | 231896 | 2020-06-12 | Whitley | Kentucky | 21235 | 17 | 0 |
235001 | 235001 | 2020-06-13 | Whitley | Kentucky | 21235 | 17 | 0 |
238108 | 238108 | 2020-06-14 | Whitley | Kentucky | 21235 | 17 | 0 |
241217 | 241217 | 2020-06-15 | Whitley | Kentucky | 21235 | 17 | 0 |
244328 | 244328 | 2020-06-16 | Whitley | Kentucky | 21235 | 17 | 0 |
247441 | 247441 | 2020-06-17 | Whitley | Kentucky | 21235 | 18 | 0 |
250553 | 250553 | 2020-06-18 | Whitley | Kentucky | 21235 | 19 | 0 |
253668 | 253668 | 2020-06-19 | Whitley | Kentucky | 21235 | 19 | 0 |
256788 | 256788 | 2020-06-20 | Whitley | Kentucky | 21235 | 19 | 0 |
259914 | 259914 | 2020-06-21 | Whitley | Kentucky | 21235 | 20 | 0 |
263043 | 263043 | 2020-06-22 | Whitley | Kentucky | 21235 | 21 | 0 |
266170 | 266170 | 2020-06-23 | Whitley | Kentucky | 21235 | 23 | 0 |
269303 | 269303 | 2020-06-24 | Whitley | Kentucky | 21235 | 24 | 0 |
272439 | 272439 | 2020-06-25 | Whitley | Kentucky | 21235 | 24 | 0 |
275582 | 275582 | 2020-06-26 | Whitley | Kentucky | 21235 | 24 | 0 |
278730 | 278730 | 2020-06-27 | Whitley | Kentucky | 21235 | 25 | 0 |
281878 | 281878 | 2020-06-28 | Whitley | Kentucky | 21235 | 25 | 0 |
285024 | 285024 | 2020-06-29 | Whitley | Kentucky | 21235 | 27 | 0 |
288173 | 288173 | 2020-06-30 | Whitley | Kentucky | 21235 | 28 | 0 |
291324 | 291324 | 2020-07-01 | Whitley | Kentucky | 21235 | 28 | 0 |
294478 | 294478 | 2020-07-02 | Whitley | Kentucky | 21235 | 29 | 0 |
297636 | 297636 | 2020-07-03 | Whitley | Kentucky | 21235 | 32 | 0 |
300798 | 300798 | 2020-07-04 | Whitley | Kentucky | 21235 | 32 | 0 |
303962 | 303962 | 2020-07-05 | Whitley | Kentucky | 21235 | 32 | 0 |
307129 | 307129 | 2020-07-06 | Whitley | Kentucky | 21235 | 40 | 0 |
310297 | 310297 | 2020-07-07 | Whitley | Kentucky | 21235 | 41 | 0 |
313467 | 313467 | 2020-07-08 | Whitley | Kentucky | 21235 | 47 | 0 |
316641 | 316641 | 2020-07-09 | Whitley | Kentucky | 21235 | 49 | 0 |
319816 | 319816 | 2020-07-10 | Whitley | Kentucky | 21235 | 49 | 0 |
322995 | 322995 | 2020-07-11 | Whitley | Kentucky | 21235 | 51 | 0 |
326178 | 326178 | 2020-07-12 | Whitley | Kentucky | 21235 | 54 | 0 |
329364 | 329364 | 2020-07-13 | Whitley | Kentucky | 21235 | 54 | 0 |
332551 | 332551 | 2020-07-14 | Whitley | Kentucky | 21235 | 57 | 0 |
335744 | 335744 | 2020-07-15 | Whitley | Kentucky | 21235 | 62 | 0 |
338940 | 338940 | 2020-07-16 | Whitley | Kentucky | 21235 | 64 | 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);