ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
746 rows where fips = 21169 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 |
---|---|---|---|---|---|---|---|
96310 | 96310 | 2020-04-28 | Metcalfe | Kentucky | 21169 | 1 | 0 |
99156 | 99156 | 2020-04-29 | Metcalfe | Kentucky | 21169 | 1 | 0 |
102008 | 102008 | 2020-04-30 | Metcalfe | Kentucky | 21169 | 1 | 0 |
104869 | 104869 | 2020-05-01 | Metcalfe | Kentucky | 21169 | 1 | 0 |
107734 | 107734 | 2020-05-02 | Metcalfe | Kentucky | 21169 | 1 | 0 |
110605 | 110605 | 2020-05-03 | Metcalfe | Kentucky | 21169 | 1 | 0 |
113482 | 113482 | 2020-05-04 | Metcalfe | Kentucky | 21169 | 1 | 0 |
116364 | 116364 | 2020-05-05 | Metcalfe | Kentucky | 21169 | 1 | 0 |
119325 | 119325 | 2020-05-06 | Metcalfe | Kentucky | 21169 | 1 | 0 |
122296 | 122296 | 2020-05-07 | Metcalfe | Kentucky | 21169 | 2 | 0 |
125278 | 125278 | 2020-05-08 | Metcalfe | Kentucky | 21169 | 2 | 0 |
128266 | 128266 | 2020-05-09 | Metcalfe | Kentucky | 21169 | 2 | 0 |
131256 | 131256 | 2020-05-10 | Metcalfe | Kentucky | 21169 | 2 | 0 |
134247 | 134247 | 2020-05-11 | Metcalfe | Kentucky | 21169 | 2 | 0 |
137237 | 137237 | 2020-05-12 | Metcalfe | Kentucky | 21169 | 3 | 0 |
140230 | 140230 | 2020-05-13 | Metcalfe | Kentucky | 21169 | 3 | 0 |
143226 | 143226 | 2020-05-14 | Metcalfe | Kentucky | 21169 | 3 | 0 |
146226 | 146226 | 2020-05-15 | Metcalfe | Kentucky | 21169 | 3 | 0 |
149231 | 149231 | 2020-05-16 | Metcalfe | Kentucky | 21169 | 3 | 0 |
152242 | 152242 | 2020-05-17 | Metcalfe | Kentucky | 21169 | 3 | 0 |
155256 | 155256 | 2020-05-18 | Metcalfe | Kentucky | 21169 | 3 | 0 |
158273 | 158273 | 2020-05-19 | Metcalfe | Kentucky | 21169 | 3 | 0 |
161299 | 161299 | 2020-05-20 | Metcalfe | Kentucky | 21169 | 3 | 0 |
164328 | 164328 | 2020-05-21 | Metcalfe | Kentucky | 21169 | 4 | 0 |
167364 | 167364 | 2020-05-22 | Metcalfe | Kentucky | 21169 | 4 | 0 |
170402 | 170402 | 2020-05-23 | Metcalfe | Kentucky | 21169 | 4 | 0 |
173443 | 173443 | 2020-05-24 | Metcalfe | Kentucky | 21169 | 4 | 0 |
176487 | 176487 | 2020-05-25 | Metcalfe | Kentucky | 21169 | 4 | 0 |
179531 | 179531 | 2020-05-26 | Metcalfe | Kentucky | 21169 | 4 | 0 |
182576 | 182576 | 2020-05-27 | Metcalfe | Kentucky | 21169 | 4 | 0 |
185631 | 185631 | 2020-05-28 | Metcalfe | Kentucky | 21169 | 4 | 0 |
188689 | 188689 | 2020-05-29 | Metcalfe | Kentucky | 21169 | 6 | 0 |
191753 | 191753 | 2020-05-30 | Metcalfe | Kentucky | 21169 | 6 | 1 |
194821 | 194821 | 2020-05-31 | Metcalfe | Kentucky | 21169 | 7 | 1 |
197892 | 197892 | 2020-06-01 | Metcalfe | Kentucky | 21169 | 7 | 1 |
200964 | 200964 | 2020-06-02 | Metcalfe | Kentucky | 21169 | 7 | 1 |
204041 | 204041 | 2020-06-03 | Metcalfe | Kentucky | 21169 | 7 | 1 |
207122 | 207122 | 2020-06-04 | Metcalfe | Kentucky | 21169 | 7 | 2 |
210203 | 210203 | 2020-06-05 | Metcalfe | Kentucky | 21169 | 7 | 2 |
213288 | 213288 | 2020-06-06 | Metcalfe | Kentucky | 21169 | 7 | 2 |
216375 | 216375 | 2020-06-07 | Metcalfe | Kentucky | 21169 | 7 | 2 |
219467 | 219467 | 2020-06-08 | Metcalfe | Kentucky | 21169 | 7 | 2 |
222562 | 222562 | 2020-06-09 | Metcalfe | Kentucky | 21169 | 7 | 2 |
225658 | 225658 | 2020-06-10 | Metcalfe | Kentucky | 21169 | 7 | 2 |
228760 | 228760 | 2020-06-11 | Metcalfe | Kentucky | 21169 | 7 | 2 |
231864 | 231864 | 2020-06-12 | Metcalfe | Kentucky | 21169 | 7 | 2 |
234969 | 234969 | 2020-06-13 | Metcalfe | Kentucky | 21169 | 7 | 2 |
238076 | 238076 | 2020-06-14 | Metcalfe | Kentucky | 21169 | 7 | 2 |
241185 | 241185 | 2020-06-15 | Metcalfe | Kentucky | 21169 | 8 | 2 |
244296 | 244296 | 2020-06-16 | Metcalfe | Kentucky | 21169 | 8 | 2 |
247409 | 247409 | 2020-06-17 | Metcalfe | Kentucky | 21169 | 8 | 2 |
250521 | 250521 | 2020-06-18 | Metcalfe | Kentucky | 21169 | 8 | 2 |
253636 | 253636 | 2020-06-19 | Metcalfe | Kentucky | 21169 | 8 | 2 |
256756 | 256756 | 2020-06-20 | Metcalfe | Kentucky | 21169 | 8 | 2 |
259882 | 259882 | 2020-06-21 | Metcalfe | Kentucky | 21169 | 8 | 2 |
263011 | 263011 | 2020-06-22 | Metcalfe | Kentucky | 21169 | 8 | 2 |
266138 | 266138 | 2020-06-23 | Metcalfe | Kentucky | 21169 | 8 | 2 |
269271 | 269271 | 2020-06-24 | Metcalfe | Kentucky | 21169 | 9 | 2 |
272407 | 272407 | 2020-06-25 | Metcalfe | Kentucky | 21169 | 9 | 2 |
275550 | 275550 | 2020-06-26 | Metcalfe | Kentucky | 21169 | 9 | 2 |
278698 | 278698 | 2020-06-27 | Metcalfe | Kentucky | 21169 | 9 | 2 |
281846 | 281846 | 2020-06-28 | Metcalfe | Kentucky | 21169 | 9 | 2 |
284992 | 284992 | 2020-06-29 | Metcalfe | Kentucky | 21169 | 9 | 2 |
288141 | 288141 | 2020-06-30 | Metcalfe | Kentucky | 21169 | 9 | 2 |
291291 | 291291 | 2020-07-01 | Metcalfe | Kentucky | 21169 | 10 | 2 |
294445 | 294445 | 2020-07-02 | Metcalfe | Kentucky | 21169 | 11 | 2 |
297603 | 297603 | 2020-07-03 | Metcalfe | Kentucky | 21169 | 11 | 2 |
300765 | 300765 | 2020-07-04 | Metcalfe | Kentucky | 21169 | 11 | 2 |
303929 | 303929 | 2020-07-05 | Metcalfe | Kentucky | 21169 | 11 | 2 |
307096 | 307096 | 2020-07-06 | Metcalfe | Kentucky | 21169 | 13 | 2 |
310264 | 310264 | 2020-07-07 | Metcalfe | Kentucky | 21169 | 14 | 2 |
313434 | 313434 | 2020-07-08 | Metcalfe | Kentucky | 21169 | 14 | 2 |
316608 | 316608 | 2020-07-09 | Metcalfe | Kentucky | 21169 | 14 | 2 |
319783 | 319783 | 2020-07-10 | Metcalfe | Kentucky | 21169 | 15 | 2 |
322962 | 322962 | 2020-07-11 | Metcalfe | Kentucky | 21169 | 16 | 2 |
326145 | 326145 | 2020-07-12 | Metcalfe | Kentucky | 21169 | 17 | 2 |
329331 | 329331 | 2020-07-13 | Metcalfe | Kentucky | 21169 | 17 | 2 |
332518 | 332518 | 2020-07-14 | Metcalfe | Kentucky | 21169 | 17 | 2 |
335711 | 335711 | 2020-07-15 | Metcalfe | Kentucky | 21169 | 17 | 2 |
338907 | 338907 | 2020-07-16 | Metcalfe | Kentucky | 21169 | 17 | 2 |
342103 | 342103 | 2020-07-17 | Metcalfe | Kentucky | 21169 | 18 | 2 |
345303 | 345303 | 2020-07-18 | Metcalfe | Kentucky | 21169 | 18 | 2 |
348504 | 348504 | 2020-07-19 | Metcalfe | Kentucky | 21169 | 18 | 2 |
351704 | 351704 | 2020-07-20 | Metcalfe | Kentucky | 21169 | 18 | 2 |
354906 | 354906 | 2020-07-21 | Metcalfe | Kentucky | 21169 | 19 | 2 |
358109 | 358109 | 2020-07-22 | Metcalfe | Kentucky | 21169 | 20 | 2 |
361314 | 361314 | 2020-07-23 | Metcalfe | Kentucky | 21169 | 20 | 2 |
364521 | 364521 | 2020-07-24 | Metcalfe | Kentucky | 21169 | 24 | 2 |
367728 | 367728 | 2020-07-25 | Metcalfe | Kentucky | 21169 | 24 | 2 |
370938 | 370938 | 2020-07-26 | Metcalfe | Kentucky | 21169 | 25 | 2 |
374150 | 374150 | 2020-07-27 | Metcalfe | Kentucky | 21169 | 28 | 2 |
377365 | 377365 | 2020-07-28 | Metcalfe | Kentucky | 21169 | 34 | 2 |
380582 | 380582 | 2020-07-29 | Metcalfe | Kentucky | 21169 | 38 | 2 |
383799 | 383799 | 2020-07-30 | Metcalfe | Kentucky | 21169 | 43 | 2 |
387017 | 387017 | 2020-07-31 | Metcalfe | Kentucky | 21169 | 54 | 2 |
390234 | 390234 | 2020-08-01 | Metcalfe | Kentucky | 21169 | 54 | 2 |
393451 | 393451 | 2020-08-02 | Metcalfe | Kentucky | 21169 | 54 | 2 |
396667 | 396667 | 2020-08-03 | Metcalfe | Kentucky | 21169 | 55 | 2 |
399882 | 399882 | 2020-08-04 | Metcalfe | Kentucky | 21169 | 57 | 2 |
403099 | 403099 | 2020-08-05 | Metcalfe | Kentucky | 21169 | 59 | 2 |
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);