ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where fips = 21131 and state = "Kentucky" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
34012 | 34012 | 2020-04-05 | Leslie | Kentucky | 21131 | 1 | 0 |
36470 | 36470 | 2020-04-06 | Leslie | Kentucky | 21131 | 1 | 0 |
38977 | 38977 | 2020-04-07 | Leslie | Kentucky | 21131 | 1 | 0 |
41527 | 41527 | 2020-04-08 | Leslie | Kentucky | 21131 | 1 | 0 |
44103 | 44103 | 2020-04-09 | Leslie | Kentucky | 21131 | 1 | 0 |
46711 | 46711 | 2020-04-10 | Leslie | Kentucky | 21131 | 1 | 0 |
49351 | 49351 | 2020-04-11 | Leslie | Kentucky | 21131 | 1 | 0 |
52017 | 52017 | 2020-04-12 | Leslie | Kentucky | 21131 | 1 | 0 |
54698 | 54698 | 2020-04-13 | Leslie | Kentucky | 21131 | 1 | 0 |
57395 | 57395 | 2020-04-14 | Leslie | Kentucky | 21131 | 2 | 0 |
60104 | 60104 | 2020-04-15 | Leslie | Kentucky | 21131 | 2 | 0 |
62824 | 62824 | 2020-04-16 | Leslie | Kentucky | 21131 | 2 | 0 |
65563 | 65563 | 2020-04-17 | Leslie | Kentucky | 21131 | 2 | 0 |
68312 | 68312 | 2020-04-18 | Leslie | Kentucky | 21131 | 2 | 0 |
71075 | 71075 | 2020-04-19 | Leslie | Kentucky | 21131 | 2 | 0 |
73847 | 73847 | 2020-04-20 | Leslie | Kentucky | 21131 | 2 | 0 |
76628 | 76628 | 2020-04-21 | Leslie | Kentucky | 21131 | 2 | 0 |
79413 | 79413 | 2020-04-22 | Leslie | Kentucky | 21131 | 2 | 0 |
82210 | 82210 | 2020-04-23 | Leslie | Kentucky | 21131 | 2 | 0 |
85013 | 85013 | 2020-04-24 | Leslie | Kentucky | 21131 | 2 | 0 |
87822 | 87822 | 2020-04-25 | Leslie | Kentucky | 21131 | 2 | 0 |
90638 | 90638 | 2020-04-26 | Leslie | Kentucky | 21131 | 2 | 0 |
93459 | 93459 | 2020-04-27 | Leslie | Kentucky | 21131 | 2 | 0 |
96292 | 96292 | 2020-04-28 | Leslie | Kentucky | 21131 | 2 | 0 |
99138 | 99138 | 2020-04-29 | Leslie | Kentucky | 21131 | 2 | 0 |
101990 | 101990 | 2020-04-30 | Leslie | Kentucky | 21131 | 4 | 0 |
104851 | 104851 | 2020-05-01 | Leslie | Kentucky | 21131 | 4 | 0 |
107716 | 107716 | 2020-05-02 | Leslie | Kentucky | 21131 | 4 | 0 |
110587 | 110587 | 2020-05-03 | Leslie | Kentucky | 21131 | 4 | 0 |
113464 | 113464 | 2020-05-04 | Leslie | Kentucky | 21131 | 4 | 0 |
116346 | 116346 | 2020-05-05 | Leslie | Kentucky | 21131 | 4 | 0 |
119307 | 119307 | 2020-05-06 | Leslie | Kentucky | 21131 | 4 | 0 |
122278 | 122278 | 2020-05-07 | Leslie | Kentucky | 21131 | 4 | 0 |
125260 | 125260 | 2020-05-08 | Leslie | Kentucky | 21131 | 5 | 0 |
128248 | 128248 | 2020-05-09 | Leslie | Kentucky | 21131 | 5 | 0 |
131238 | 131238 | 2020-05-10 | Leslie | Kentucky | 21131 | 5 | 0 |
134229 | 134229 | 2020-05-11 | Leslie | Kentucky | 21131 | 5 | 0 |
137219 | 137219 | 2020-05-12 | Leslie | Kentucky | 21131 | 5 | 0 |
140212 | 140212 | 2020-05-13 | Leslie | Kentucky | 21131 | 5 | 0 |
143208 | 143208 | 2020-05-14 | Leslie | Kentucky | 21131 | 6 | 0 |
146208 | 146208 | 2020-05-15 | Leslie | Kentucky | 21131 | 6 | 0 |
149212 | 149212 | 2020-05-16 | Leslie | Kentucky | 21131 | 6 | 0 |
152223 | 152223 | 2020-05-17 | Leslie | Kentucky | 21131 | 6 | 0 |
155237 | 155237 | 2020-05-18 | Leslie | Kentucky | 21131 | 6 | 0 |
158254 | 158254 | 2020-05-19 | Leslie | Kentucky | 21131 | 6 | 0 |
161280 | 161280 | 2020-05-20 | Leslie | Kentucky | 21131 | 6 | 0 |
164309 | 164309 | 2020-05-21 | Leslie | Kentucky | 21131 | 6 | 0 |
167345 | 167345 | 2020-05-22 | Leslie | Kentucky | 21131 | 6 | 0 |
170383 | 170383 | 2020-05-23 | Leslie | Kentucky | 21131 | 6 | 0 |
173424 | 173424 | 2020-05-24 | Leslie | Kentucky | 21131 | 6 | 0 |
176468 | 176468 | 2020-05-25 | Leslie | Kentucky | 21131 | 6 | 0 |
179512 | 179512 | 2020-05-26 | Leslie | Kentucky | 21131 | 6 | 0 |
182557 | 182557 | 2020-05-27 | Leslie | Kentucky | 21131 | 6 | 0 |
185612 | 185612 | 2020-05-28 | Leslie | Kentucky | 21131 | 6 | 0 |
188670 | 188670 | 2020-05-29 | Leslie | Kentucky | 21131 | 6 | 0 |
191734 | 191734 | 2020-05-30 | Leslie | Kentucky | 21131 | 6 | 0 |
194802 | 194802 | 2020-05-31 | Leslie | Kentucky | 21131 | 6 | 0 |
197873 | 197873 | 2020-06-01 | Leslie | Kentucky | 21131 | 6 | 0 |
200945 | 200945 | 2020-06-02 | Leslie | Kentucky | 21131 | 6 | 0 |
204022 | 204022 | 2020-06-03 | Leslie | Kentucky | 21131 | 6 | 0 |
207103 | 207103 | 2020-06-04 | Leslie | Kentucky | 21131 | 6 | 0 |
210184 | 210184 | 2020-06-05 | Leslie | Kentucky | 21131 | 6 | 0 |
213269 | 213269 | 2020-06-06 | Leslie | Kentucky | 21131 | 6 | 0 |
216356 | 216356 | 2020-06-07 | Leslie | Kentucky | 21131 | 6 | 0 |
219448 | 219448 | 2020-06-08 | Leslie | Kentucky | 21131 | 6 | 0 |
222543 | 222543 | 2020-06-09 | Leslie | Kentucky | 21131 | 6 | 0 |
225639 | 225639 | 2020-06-10 | Leslie | Kentucky | 21131 | 6 | 0 |
228741 | 228741 | 2020-06-11 | Leslie | Kentucky | 21131 | 6 | 0 |
231845 | 231845 | 2020-06-12 | Leslie | Kentucky | 21131 | 6 | 0 |
234950 | 234950 | 2020-06-13 | Leslie | Kentucky | 21131 | 6 | 0 |
238057 | 238057 | 2020-06-14 | Leslie | Kentucky | 21131 | 6 | 0 |
241166 | 241166 | 2020-06-15 | Leslie | Kentucky | 21131 | 6 | 0 |
244277 | 244277 | 2020-06-16 | Leslie | Kentucky | 21131 | 6 | 0 |
247390 | 247390 | 2020-06-17 | Leslie | Kentucky | 21131 | 7 | 0 |
250502 | 250502 | 2020-06-18 | Leslie | Kentucky | 21131 | 7 | 0 |
253617 | 253617 | 2020-06-19 | Leslie | Kentucky | 21131 | 7 | 0 |
256737 | 256737 | 2020-06-20 | Leslie | Kentucky | 21131 | 7 | 0 |
259863 | 259863 | 2020-06-21 | Leslie | Kentucky | 21131 | 7 | 0 |
262992 | 262992 | 2020-06-22 | Leslie | Kentucky | 21131 | 8 | 0 |
266119 | 266119 | 2020-06-23 | Leslie | Kentucky | 21131 | 8 | 0 |
269252 | 269252 | 2020-06-24 | Leslie | Kentucky | 21131 | 8 | 0 |
272388 | 272388 | 2020-06-25 | Leslie | Kentucky | 21131 | 8 | 0 |
275531 | 275531 | 2020-06-26 | Leslie | Kentucky | 21131 | 8 | 0 |
278679 | 278679 | 2020-06-27 | Leslie | Kentucky | 21131 | 8 | 0 |
281827 | 281827 | 2020-06-28 | Leslie | Kentucky | 21131 | 8 | 0 |
284973 | 284973 | 2020-06-29 | Leslie | Kentucky | 21131 | 8 | 0 |
288122 | 288122 | 2020-06-30 | Leslie | Kentucky | 21131 | 8 | 0 |
291272 | 291272 | 2020-07-01 | Leslie | Kentucky | 21131 | 8 | 0 |
294426 | 294426 | 2020-07-02 | Leslie | Kentucky | 21131 | 9 | 0 |
297584 | 297584 | 2020-07-03 | Leslie | Kentucky | 21131 | 10 | 0 |
300746 | 300746 | 2020-07-04 | Leslie | Kentucky | 21131 | 10 | 0 |
303910 | 303910 | 2020-07-05 | Leslie | Kentucky | 21131 | 10 | 0 |
307077 | 307077 | 2020-07-06 | Leslie | Kentucky | 21131 | 10 | 0 |
310245 | 310245 | 2020-07-07 | Leslie | Kentucky | 21131 | 10 | 0 |
313415 | 313415 | 2020-07-08 | Leslie | Kentucky | 21131 | 11 | 0 |
316589 | 316589 | 2020-07-09 | Leslie | Kentucky | 21131 | 11 | 0 |
319764 | 319764 | 2020-07-10 | Leslie | Kentucky | 21131 | 11 | 0 |
322943 | 322943 | 2020-07-11 | Leslie | Kentucky | 21131 | 11 | 0 |
326126 | 326126 | 2020-07-12 | Leslie | Kentucky | 21131 | 11 | 0 |
329312 | 329312 | 2020-07-13 | Leslie | Kentucky | 21131 | 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);