ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where fips = 21223 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387044 | 387044 | 2020-07-31 | Trimble | Kentucky | 21223 | 32 | 0 |
383826 | 383826 | 2020-07-30 | Trimble | Kentucky | 21223 | 32 | 0 |
380609 | 380609 | 2020-07-29 | Trimble | Kentucky | 21223 | 28 | 0 |
377392 | 377392 | 2020-07-28 | Trimble | Kentucky | 21223 | 27 | 0 |
374177 | 374177 | 2020-07-27 | Trimble | Kentucky | 21223 | 27 | 0 |
370965 | 370965 | 2020-07-26 | Trimble | Kentucky | 21223 | 27 | 0 |
367755 | 367755 | 2020-07-25 | Trimble | Kentucky | 21223 | 27 | 0 |
364548 | 364548 | 2020-07-24 | Trimble | Kentucky | 21223 | 27 | 0 |
361341 | 361341 | 2020-07-23 | Trimble | Kentucky | 21223 | 25 | 0 |
358136 | 358136 | 2020-07-22 | Trimble | Kentucky | 21223 | 25 | 0 |
354933 | 354933 | 2020-07-21 | Trimble | Kentucky | 21223 | 25 | 0 |
351731 | 351731 | 2020-07-20 | Trimble | Kentucky | 21223 | 25 | 0 |
348531 | 348531 | 2020-07-19 | Trimble | Kentucky | 21223 | 25 | 0 |
345330 | 345330 | 2020-07-18 | Trimble | Kentucky | 21223 | 20 | 0 |
342130 | 342130 | 2020-07-17 | Trimble | Kentucky | 21223 | 20 | 0 |
338934 | 338934 | 2020-07-16 | Trimble | Kentucky | 21223 | 18 | 0 |
335738 | 335738 | 2020-07-15 | Trimble | Kentucky | 21223 | 16 | 0 |
332545 | 332545 | 2020-07-14 | Trimble | Kentucky | 21223 | 16 | 0 |
329358 | 329358 | 2020-07-13 | Trimble | Kentucky | 21223 | 15 | 0 |
326172 | 326172 | 2020-07-12 | Trimble | Kentucky | 21223 | 15 | 0 |
322989 | 322989 | 2020-07-11 | Trimble | Kentucky | 21223 | 15 | 0 |
319810 | 319810 | 2020-07-10 | Trimble | Kentucky | 21223 | 13 | 0 |
316635 | 316635 | 2020-07-09 | Trimble | Kentucky | 21223 | 9 | 0 |
313461 | 313461 | 2020-07-08 | Trimble | Kentucky | 21223 | 7 | 0 |
310291 | 310291 | 2020-07-07 | Trimble | Kentucky | 21223 | 7 | 0 |
307123 | 307123 | 2020-07-06 | Trimble | Kentucky | 21223 | 7 | 0 |
303956 | 303956 | 2020-07-05 | Trimble | Kentucky | 21223 | 7 | 0 |
300792 | 300792 | 2020-07-04 | Trimble | Kentucky | 21223 | 7 | 0 |
297630 | 297630 | 2020-07-03 | Trimble | Kentucky | 21223 | 7 | 0 |
294472 | 294472 | 2020-07-02 | Trimble | Kentucky | 21223 | 7 | 0 |
291318 | 291318 | 2020-07-01 | Trimble | Kentucky | 21223 | 7 | 0 |
288167 | 288167 | 2020-06-30 | Trimble | Kentucky | 21223 | 7 | 0 |
285018 | 285018 | 2020-06-29 | Trimble | Kentucky | 21223 | 7 | 0 |
281872 | 281872 | 2020-06-28 | Trimble | Kentucky | 21223 | 7 | 0 |
278724 | 278724 | 2020-06-27 | Trimble | Kentucky | 21223 | 6 | 0 |
275576 | 275576 | 2020-06-26 | Trimble | Kentucky | 21223 | 6 | 0 |
272433 | 272433 | 2020-06-25 | Trimble | Kentucky | 21223 | 6 | 0 |
269297 | 269297 | 2020-06-24 | Trimble | Kentucky | 21223 | 6 | 0 |
266164 | 266164 | 2020-06-23 | Trimble | Kentucky | 21223 | 6 | 0 |
263037 | 263037 | 2020-06-22 | Trimble | Kentucky | 21223 | 5 | 0 |
259908 | 259908 | 2020-06-21 | Trimble | Kentucky | 21223 | 5 | 0 |
256782 | 256782 | 2020-06-20 | Trimble | Kentucky | 21223 | 5 | 0 |
253662 | 253662 | 2020-06-19 | Trimble | Kentucky | 21223 | 5 | 0 |
250547 | 250547 | 2020-06-18 | Trimble | Kentucky | 21223 | 5 | 0 |
247435 | 247435 | 2020-06-17 | Trimble | Kentucky | 21223 | 5 | 0 |
244322 | 244322 | 2020-06-16 | Trimble | Kentucky | 21223 | 5 | 0 |
241211 | 241211 | 2020-06-15 | Trimble | Kentucky | 21223 | 5 | 0 |
238102 | 238102 | 2020-06-14 | Trimble | Kentucky | 21223 | 5 | 0 |
234995 | 234995 | 2020-06-13 | Trimble | Kentucky | 21223 | 5 | 0 |
231890 | 231890 | 2020-06-12 | Trimble | Kentucky | 21223 | 5 | 0 |
228786 | 228786 | 2020-06-11 | Trimble | Kentucky | 21223 | 5 | 0 |
225684 | 225684 | 2020-06-10 | Trimble | Kentucky | 21223 | 6 | 0 |
222588 | 222588 | 2020-06-09 | Trimble | Kentucky | 21223 | 6 | 0 |
219493 | 219493 | 2020-06-08 | Trimble | Kentucky | 21223 | 6 | 0 |
216401 | 216401 | 2020-06-07 | Trimble | Kentucky | 21223 | 6 | 0 |
213314 | 213314 | 2020-06-06 | Trimble | Kentucky | 21223 | 6 | 0 |
210229 | 210229 | 2020-06-05 | Trimble | Kentucky | 21223 | 6 | 0 |
207148 | 207148 | 2020-06-04 | Trimble | Kentucky | 21223 | 6 | 0 |
204067 | 204067 | 2020-06-03 | Trimble | Kentucky | 21223 | 6 | 0 |
200990 | 200990 | 2020-06-02 | Trimble | Kentucky | 21223 | 6 | 0 |
197918 | 197918 | 2020-06-01 | Trimble | Kentucky | 21223 | 6 | 0 |
194847 | 194847 | 2020-05-31 | Trimble | Kentucky | 21223 | 6 | 0 |
191779 | 191779 | 2020-05-30 | Trimble | Kentucky | 21223 | 6 | 0 |
188715 | 188715 | 2020-05-29 | Trimble | Kentucky | 21223 | 5 | 0 |
185657 | 185657 | 2020-05-28 | Trimble | Kentucky | 21223 | 5 | 0 |
182602 | 182602 | 2020-05-27 | Trimble | Kentucky | 21223 | 5 | 0 |
179557 | 179557 | 2020-05-26 | Trimble | Kentucky | 21223 | 5 | 0 |
176513 | 176513 | 2020-05-25 | Trimble | Kentucky | 21223 | 5 | 0 |
173469 | 173469 | 2020-05-24 | Trimble | Kentucky | 21223 | 5 | 0 |
170428 | 170428 | 2020-05-23 | Trimble | Kentucky | 21223 | 5 | 0 |
167390 | 167390 | 2020-05-22 | Trimble | Kentucky | 21223 | 5 | 0 |
164354 | 164354 | 2020-05-21 | Trimble | Kentucky | 21223 | 4 | 0 |
161325 | 161325 | 2020-05-20 | Trimble | Kentucky | 21223 | 3 | 0 |
158299 | 158299 | 2020-05-19 | Trimble | Kentucky | 21223 | 3 | 0 |
155282 | 155282 | 2020-05-18 | Trimble | Kentucky | 21223 | 3 | 0 |
152268 | 152268 | 2020-05-17 | Trimble | Kentucky | 21223 | 3 | 0 |
149257 | 149257 | 2020-05-16 | Trimble | Kentucky | 21223 | 3 | 0 |
146252 | 146252 | 2020-05-15 | Trimble | Kentucky | 21223 | 3 | 0 |
143252 | 143252 | 2020-05-14 | Trimble | Kentucky | 21223 | 3 | 0 |
140256 | 140256 | 2020-05-13 | Trimble | Kentucky | 21223 | 3 | 0 |
137263 | 137263 | 2020-05-12 | Trimble | Kentucky | 21223 | 3 | 0 |
134273 | 134273 | 2020-05-11 | Trimble | Kentucky | 21223 | 3 | 0 |
131282 | 131282 | 2020-05-10 | Trimble | Kentucky | 21223 | 3 | 0 |
128292 | 128292 | 2020-05-09 | Trimble | Kentucky | 21223 | 3 | 0 |
125304 | 125304 | 2020-05-08 | Trimble | Kentucky | 21223 | 3 | 0 |
122322 | 122322 | 2020-05-07 | Trimble | Kentucky | 21223 | 3 | 0 |
119351 | 119351 | 2020-05-06 | Trimble | Kentucky | 21223 | 3 | 0 |
116390 | 116390 | 2020-05-05 | Trimble | Kentucky | 21223 | 3 | 0 |
113508 | 113508 | 2020-05-04 | Trimble | Kentucky | 21223 | 3 | 0 |
110631 | 110631 | 2020-05-03 | Trimble | Kentucky | 21223 | 3 | 0 |
107760 | 107760 | 2020-05-02 | Trimble | Kentucky | 21223 | 3 | 0 |
104895 | 104895 | 2020-05-01 | Trimble | Kentucky | 21223 | 3 | 0 |
102034 | 102034 | 2020-04-30 | Trimble | Kentucky | 21223 | 3 | 0 |
99182 | 99182 | 2020-04-29 | Trimble | Kentucky | 21223 | 3 | 0 |
96336 | 96336 | 2020-04-28 | Trimble | Kentucky | 21223 | 3 | 0 |
93501 | 93501 | 2020-04-27 | Trimble | Kentucky | 21223 | 3 | 0 |
90680 | 90680 | 2020-04-26 | Trimble | Kentucky | 21223 | 3 | 0 |
87864 | 87864 | 2020-04-25 | Trimble | Kentucky | 21223 | 2 | 0 |
85055 | 85055 | 2020-04-24 | Trimble | Kentucky | 21223 | 2 | 0 |
82252 | 82252 | 2020-04-23 | Trimble | Kentucky | 21223 | 2 | 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);