ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 21203 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387034 | 387034 | 2020-07-31 | Rockcastle | Kentucky | 21203 | 60 | 0 |
383816 | 383816 | 2020-07-30 | Rockcastle | Kentucky | 21203 | 56 | 0 |
380599 | 380599 | 2020-07-29 | Rockcastle | Kentucky | 21203 | 52 | 0 |
377382 | 377382 | 2020-07-28 | Rockcastle | Kentucky | 21203 | 48 | 0 |
374167 | 374167 | 2020-07-27 | Rockcastle | Kentucky | 21203 | 47 | 0 |
370955 | 370955 | 2020-07-26 | Rockcastle | Kentucky | 21203 | 46 | 0 |
367745 | 367745 | 2020-07-25 | Rockcastle | Kentucky | 21203 | 46 | 0 |
364538 | 364538 | 2020-07-24 | Rockcastle | Kentucky | 21203 | 46 | 0 |
361331 | 361331 | 2020-07-23 | Rockcastle | Kentucky | 21203 | 44 | 0 |
358126 | 358126 | 2020-07-22 | Rockcastle | Kentucky | 21203 | 44 | 0 |
354923 | 354923 | 2020-07-21 | Rockcastle | Kentucky | 21203 | 44 | 0 |
351721 | 351721 | 2020-07-20 | Rockcastle | Kentucky | 21203 | 40 | 0 |
348521 | 348521 | 2020-07-19 | Rockcastle | Kentucky | 21203 | 40 | 0 |
345320 | 345320 | 2020-07-18 | Rockcastle | Kentucky | 21203 | 40 | 0 |
342120 | 342120 | 2020-07-17 | Rockcastle | Kentucky | 21203 | 38 | 0 |
338924 | 338924 | 2020-07-16 | Rockcastle | Kentucky | 21203 | 37 | 0 |
335728 | 335728 | 2020-07-15 | Rockcastle | Kentucky | 21203 | 34 | 0 |
332535 | 332535 | 2020-07-14 | Rockcastle | Kentucky | 21203 | 34 | 0 |
329348 | 329348 | 2020-07-13 | Rockcastle | Kentucky | 21203 | 32 | 0 |
326162 | 326162 | 2020-07-12 | Rockcastle | Kentucky | 21203 | 32 | 0 |
322979 | 322979 | 2020-07-11 | Rockcastle | Kentucky | 21203 | 32 | 0 |
319800 | 319800 | 2020-07-10 | Rockcastle | Kentucky | 21203 | 32 | 0 |
316625 | 316625 | 2020-07-09 | Rockcastle | Kentucky | 21203 | 31 | 0 |
313451 | 313451 | 2020-07-08 | Rockcastle | Kentucky | 21203 | 30 | 0 |
310281 | 310281 | 2020-07-07 | Rockcastle | Kentucky | 21203 | 27 | 0 |
307113 | 307113 | 2020-07-06 | Rockcastle | Kentucky | 21203 | 27 | 0 |
303946 | 303946 | 2020-07-05 | Rockcastle | Kentucky | 21203 | 21 | 0 |
300782 | 300782 | 2020-07-04 | Rockcastle | Kentucky | 21203 | 21 | 0 |
297620 | 297620 | 2020-07-03 | Rockcastle | Kentucky | 21203 | 21 | 0 |
294462 | 294462 | 2020-07-02 | Rockcastle | Kentucky | 21203 | 21 | 0 |
291308 | 291308 | 2020-07-01 | Rockcastle | Kentucky | 21203 | 21 | 0 |
288157 | 288157 | 2020-06-30 | Rockcastle | Kentucky | 21203 | 21 | 0 |
285008 | 285008 | 2020-06-29 | Rockcastle | Kentucky | 21203 | 19 | 0 |
281862 | 281862 | 2020-06-28 | Rockcastle | Kentucky | 21203 | 19 | 0 |
278714 | 278714 | 2020-06-27 | Rockcastle | Kentucky | 21203 | 19 | 0 |
275566 | 275566 | 2020-06-26 | Rockcastle | Kentucky | 21203 | 18 | 0 |
272423 | 272423 | 2020-06-25 | Rockcastle | Kentucky | 21203 | 18 | 0 |
269287 | 269287 | 2020-06-24 | Rockcastle | Kentucky | 21203 | 18 | 0 |
266154 | 266154 | 2020-06-23 | Rockcastle | Kentucky | 21203 | 18 | 0 |
263027 | 263027 | 2020-06-22 | Rockcastle | Kentucky | 21203 | 17 | 0 |
259898 | 259898 | 2020-06-21 | Rockcastle | Kentucky | 21203 | 17 | 0 |
256772 | 256772 | 2020-06-20 | Rockcastle | Kentucky | 21203 | 16 | 0 |
253652 | 253652 | 2020-06-19 | Rockcastle | Kentucky | 21203 | 16 | 0 |
250537 | 250537 | 2020-06-18 | Rockcastle | Kentucky | 21203 | 16 | 0 |
247425 | 247425 | 2020-06-17 | Rockcastle | Kentucky | 21203 | 15 | 0 |
244312 | 244312 | 2020-06-16 | Rockcastle | Kentucky | 21203 | 14 | 0 |
241201 | 241201 | 2020-06-15 | Rockcastle | Kentucky | 21203 | 14 | 0 |
238092 | 238092 | 2020-06-14 | Rockcastle | Kentucky | 21203 | 14 | 0 |
234985 | 234985 | 2020-06-13 | Rockcastle | Kentucky | 21203 | 14 | 0 |
231880 | 231880 | 2020-06-12 | Rockcastle | Kentucky | 21203 | 14 | 0 |
228776 | 228776 | 2020-06-11 | Rockcastle | Kentucky | 21203 | 13 | 0 |
225674 | 225674 | 2020-06-10 | Rockcastle | Kentucky | 21203 | 13 | 0 |
222578 | 222578 | 2020-06-09 | Rockcastle | Kentucky | 21203 | 13 | 0 |
219483 | 219483 | 2020-06-08 | Rockcastle | Kentucky | 21203 | 13 | 0 |
216391 | 216391 | 2020-06-07 | Rockcastle | Kentucky | 21203 | 13 | 0 |
213304 | 213304 | 2020-06-06 | Rockcastle | Kentucky | 21203 | 13 | 0 |
210219 | 210219 | 2020-06-05 | Rockcastle | Kentucky | 21203 | 13 | 0 |
207138 | 207138 | 2020-06-04 | Rockcastle | Kentucky | 21203 | 13 | 0 |
204057 | 204057 | 2020-06-03 | Rockcastle | Kentucky | 21203 | 13 | 0 |
200980 | 200980 | 2020-06-02 | Rockcastle | Kentucky | 21203 | 13 | 0 |
197908 | 197908 | 2020-06-01 | Rockcastle | Kentucky | 21203 | 13 | 0 |
194837 | 194837 | 2020-05-31 | Rockcastle | Kentucky | 21203 | 13 | 0 |
191769 | 191769 | 2020-05-30 | Rockcastle | Kentucky | 21203 | 13 | 0 |
188705 | 188705 | 2020-05-29 | Rockcastle | Kentucky | 21203 | 13 | 0 |
185647 | 185647 | 2020-05-28 | Rockcastle | Kentucky | 21203 | 13 | 0 |
182592 | 182592 | 2020-05-27 | Rockcastle | Kentucky | 21203 | 13 | 0 |
179547 | 179547 | 2020-05-26 | Rockcastle | Kentucky | 21203 | 13 | 0 |
176503 | 176503 | 2020-05-25 | Rockcastle | Kentucky | 21203 | 13 | 0 |
173459 | 173459 | 2020-05-24 | Rockcastle | Kentucky | 21203 | 13 | 0 |
170418 | 170418 | 2020-05-23 | Rockcastle | Kentucky | 21203 | 13 | 0 |
167380 | 167380 | 2020-05-22 | Rockcastle | Kentucky | 21203 | 13 | 0 |
164344 | 164344 | 2020-05-21 | Rockcastle | Kentucky | 21203 | 13 | 0 |
161315 | 161315 | 2020-05-20 | Rockcastle | Kentucky | 21203 | 13 | 0 |
158289 | 158289 | 2020-05-19 | Rockcastle | Kentucky | 21203 | 12 | 0 |
155272 | 155272 | 2020-05-18 | Rockcastle | Kentucky | 21203 | 12 | 0 |
152258 | 152258 | 2020-05-17 | Rockcastle | Kentucky | 21203 | 12 | 0 |
149247 | 149247 | 2020-05-16 | Rockcastle | Kentucky | 21203 | 13 | 0 |
146242 | 146242 | 2020-05-15 | Rockcastle | Kentucky | 21203 | 13 | 0 |
143242 | 143242 | 2020-05-14 | Rockcastle | Kentucky | 21203 | 13 | 0 |
140246 | 140246 | 2020-05-13 | Rockcastle | Kentucky | 21203 | 13 | 0 |
137253 | 137253 | 2020-05-12 | Rockcastle | Kentucky | 21203 | 13 | 0 |
134263 | 134263 | 2020-05-11 | Rockcastle | Kentucky | 21203 | 13 | 0 |
131272 | 131272 | 2020-05-10 | Rockcastle | Kentucky | 21203 | 13 | 0 |
128282 | 128282 | 2020-05-09 | Rockcastle | Kentucky | 21203 | 13 | 0 |
125294 | 125294 | 2020-05-08 | Rockcastle | Kentucky | 21203 | 13 | 0 |
122312 | 122312 | 2020-05-07 | Rockcastle | Kentucky | 21203 | 13 | 0 |
119341 | 119341 | 2020-05-06 | Rockcastle | Kentucky | 21203 | 13 | 0 |
116380 | 116380 | 2020-05-05 | Rockcastle | Kentucky | 21203 | 12 | 0 |
113498 | 113498 | 2020-05-04 | Rockcastle | Kentucky | 21203 | 11 | 0 |
110621 | 110621 | 2020-05-03 | Rockcastle | Kentucky | 21203 | 11 | 0 |
107750 | 107750 | 2020-05-02 | Rockcastle | Kentucky | 21203 | 11 | 0 |
104885 | 104885 | 2020-05-01 | Rockcastle | Kentucky | 21203 | 11 | 0 |
102024 | 102024 | 2020-04-30 | Rockcastle | Kentucky | 21203 | 11 | 0 |
99172 | 99172 | 2020-04-29 | Rockcastle | Kentucky | 21203 | 11 | 0 |
96326 | 96326 | 2020-04-28 | Rockcastle | Kentucky | 21203 | 11 | 0 |
93491 | 93491 | 2020-04-27 | Rockcastle | Kentucky | 21203 | 11 | 0 |
90670 | 90670 | 2020-04-26 | Rockcastle | Kentucky | 21203 | 11 | 0 |
87854 | 87854 | 2020-04-25 | Rockcastle | Kentucky | 21203 | 11 | 0 |
85045 | 85045 | 2020-04-24 | Rockcastle | Kentucky | 21203 | 11 | 0 |
82242 | 82242 | 2020-04-23 | Rockcastle | Kentucky | 21203 | 11 | 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);