ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where fips = 21045 and state = "Kentucky" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
57359 | 57359 | 2020-04-14 | Casey | Kentucky | 21045 | 1 | 0 |
60068 | 60068 | 2020-04-15 | Casey | Kentucky | 21045 | 1 | 0 |
62788 | 62788 | 2020-04-16 | Casey | Kentucky | 21045 | 1 | 0 |
65527 | 65527 | 2020-04-17 | Casey | Kentucky | 21045 | 1 | 0 |
68276 | 68276 | 2020-04-18 | Casey | Kentucky | 21045 | 1 | 0 |
71037 | 71037 | 2020-04-19 | Casey | Kentucky | 21045 | 1 | 0 |
73809 | 73809 | 2020-04-20 | Casey | Kentucky | 21045 | 1 | 0 |
76589 | 76589 | 2020-04-21 | Casey | Kentucky | 21045 | 1 | 0 |
79374 | 79374 | 2020-04-22 | Casey | Kentucky | 21045 | 1 | 0 |
82171 | 82171 | 2020-04-23 | Casey | Kentucky | 21045 | 1 | 0 |
84974 | 84974 | 2020-04-24 | Casey | Kentucky | 21045 | 1 | 0 |
87783 | 87783 | 2020-04-25 | Casey | Kentucky | 21045 | 1 | 0 |
90599 | 90599 | 2020-04-26 | Casey | Kentucky | 21045 | 1 | 0 |
93420 | 93420 | 2020-04-27 | Casey | Kentucky | 21045 | 1 | 0 |
96253 | 96253 | 2020-04-28 | Casey | Kentucky | 21045 | 1 | 0 |
99099 | 99099 | 2020-04-29 | Casey | Kentucky | 21045 | 1 | 0 |
101951 | 101951 | 2020-04-30 | Casey | Kentucky | 21045 | 1 | 0 |
104812 | 104812 | 2020-05-01 | Casey | Kentucky | 21045 | 1 | 0 |
107677 | 107677 | 2020-05-02 | Casey | Kentucky | 21045 | 1 | 0 |
110548 | 110548 | 2020-05-03 | Casey | Kentucky | 21045 | 1 | 0 |
113425 | 113425 | 2020-05-04 | Casey | Kentucky | 21045 | 1 | 0 |
116307 | 116307 | 2020-05-05 | Casey | Kentucky | 21045 | 1 | 0 |
119268 | 119268 | 2020-05-06 | Casey | Kentucky | 21045 | 1 | 0 |
122238 | 122238 | 2020-05-07 | Casey | Kentucky | 21045 | 1 | 0 |
125220 | 125220 | 2020-05-08 | Casey | Kentucky | 21045 | 1 | 0 |
128208 | 128208 | 2020-05-09 | Casey | Kentucky | 21045 | 1 | 0 |
131198 | 131198 | 2020-05-10 | Casey | Kentucky | 21045 | 1 | 0 |
134189 | 134189 | 2020-05-11 | Casey | Kentucky | 21045 | 1 | 0 |
137179 | 137179 | 2020-05-12 | Casey | Kentucky | 21045 | 1 | 0 |
140172 | 140172 | 2020-05-13 | Casey | Kentucky | 21045 | 1 | 0 |
143168 | 143168 | 2020-05-14 | Casey | Kentucky | 21045 | 2 | 0 |
146168 | 146168 | 2020-05-15 | Casey | Kentucky | 21045 | 2 | 0 |
149172 | 149172 | 2020-05-16 | Casey | Kentucky | 21045 | 2 | 0 |
152183 | 152183 | 2020-05-17 | Casey | Kentucky | 21045 | 2 | 0 |
155197 | 155197 | 2020-05-18 | Casey | Kentucky | 21045 | 2 | 0 |
158214 | 158214 | 2020-05-19 | Casey | Kentucky | 21045 | 2 | 0 |
161239 | 161239 | 2020-05-20 | Casey | Kentucky | 21045 | 2 | 0 |
164268 | 164268 | 2020-05-21 | Casey | Kentucky | 21045 | 2 | 0 |
167304 | 167304 | 2020-05-22 | Casey | Kentucky | 21045 | 2 | 0 |
170342 | 170342 | 2020-05-23 | Casey | Kentucky | 21045 | 2 | 0 |
173383 | 173383 | 2020-05-24 | Casey | Kentucky | 21045 | 2 | 0 |
176427 | 176427 | 2020-05-25 | Casey | Kentucky | 21045 | 2 | 0 |
179471 | 179471 | 2020-05-26 | Casey | Kentucky | 21045 | 2 | 0 |
182516 | 182516 | 2020-05-27 | Casey | Kentucky | 21045 | 2 | 0 |
185570 | 185570 | 2020-05-28 | Casey | Kentucky | 21045 | 2 | 0 |
188628 | 188628 | 2020-05-29 | Casey | Kentucky | 21045 | 3 | 0 |
191692 | 191692 | 2020-05-30 | Casey | Kentucky | 21045 | 3 | 0 |
194760 | 194760 | 2020-05-31 | Casey | Kentucky | 21045 | 3 | 0 |
197831 | 197831 | 2020-06-01 | Casey | Kentucky | 21045 | 3 | 0 |
200902 | 200902 | 2020-06-02 | Casey | Kentucky | 21045 | 3 | 0 |
203979 | 203979 | 2020-06-03 | Casey | Kentucky | 21045 | 5 | 0 |
207060 | 207060 | 2020-06-04 | Casey | Kentucky | 21045 | 5 | 0 |
210141 | 210141 | 2020-06-05 | Casey | Kentucky | 21045 | 8 | 0 |
213226 | 213226 | 2020-06-06 | Casey | Kentucky | 21045 | 8 | 0 |
216313 | 216313 | 2020-06-07 | Casey | Kentucky | 21045 | 8 | 0 |
219405 | 219405 | 2020-06-08 | Casey | Kentucky | 21045 | 8 | 0 |
222500 | 222500 | 2020-06-09 | Casey | Kentucky | 21045 | 8 | 0 |
225596 | 225596 | 2020-06-10 | Casey | Kentucky | 21045 | 10 | 0 |
228698 | 228698 | 2020-06-11 | Casey | Kentucky | 21045 | 10 | 0 |
231802 | 231802 | 2020-06-12 | Casey | Kentucky | 21045 | 10 | 0 |
234907 | 234907 | 2020-06-13 | Casey | Kentucky | 21045 | 10 | 0 |
238014 | 238014 | 2020-06-14 | Casey | Kentucky | 21045 | 10 | 0 |
241123 | 241123 | 2020-06-15 | Casey | Kentucky | 21045 | 10 | 0 |
244234 | 244234 | 2020-06-16 | Casey | Kentucky | 21045 | 10 | 0 |
247347 | 247347 | 2020-06-17 | Casey | Kentucky | 21045 | 10 | 0 |
250459 | 250459 | 2020-06-18 | Casey | Kentucky | 21045 | 11 | 0 |
253574 | 253574 | 2020-06-19 | Casey | Kentucky | 21045 | 11 | 0 |
256694 | 256694 | 2020-06-20 | Casey | Kentucky | 21045 | 13 | 0 |
259820 | 259820 | 2020-06-21 | Casey | Kentucky | 21045 | 13 | 0 |
262949 | 262949 | 2020-06-22 | Casey | Kentucky | 21045 | 13 | 0 |
266076 | 266076 | 2020-06-23 | Casey | Kentucky | 21045 | 13 | 0 |
269209 | 269209 | 2020-06-24 | Casey | Kentucky | 21045 | 13 | 0 |
272345 | 272345 | 2020-06-25 | Casey | Kentucky | 21045 | 14 | 0 |
275488 | 275488 | 2020-06-26 | Casey | Kentucky | 21045 | 15 | 0 |
278636 | 278636 | 2020-06-27 | Casey | Kentucky | 21045 | 15 | 0 |
281784 | 281784 | 2020-06-28 | Casey | Kentucky | 21045 | 15 | 0 |
284930 | 284930 | 2020-06-29 | Casey | Kentucky | 21045 | 18 | 0 |
288079 | 288079 | 2020-06-30 | Casey | Kentucky | 21045 | 19 | 0 |
291229 | 291229 | 2020-07-01 | Casey | Kentucky | 21045 | 19 | 0 |
294383 | 294383 | 2020-07-02 | Casey | Kentucky | 21045 | 19 | 0 |
297541 | 297541 | 2020-07-03 | Casey | Kentucky | 21045 | 21 | 0 |
300703 | 300703 | 2020-07-04 | Casey | Kentucky | 21045 | 21 | 0 |
303867 | 303867 | 2020-07-05 | Casey | Kentucky | 21045 | 21 | 0 |
307034 | 307034 | 2020-07-06 | Casey | Kentucky | 21045 | 38 | 0 |
310202 | 310202 | 2020-07-07 | Casey | Kentucky | 21045 | 40 | 1 |
313372 | 313372 | 2020-07-08 | Casey | Kentucky | 21045 | 41 | 1 |
316546 | 316546 | 2020-07-09 | Casey | Kentucky | 21045 | 55 | 1 |
319721 | 319721 | 2020-07-10 | Casey | Kentucky | 21045 | 84 | 1 |
322900 | 322900 | 2020-07-11 | Casey | Kentucky | 21045 | 88 | 1 |
326083 | 326083 | 2020-07-12 | Casey | Kentucky | 21045 | 94 | 2 |
329269 | 329269 | 2020-07-13 | Casey | Kentucky | 21045 | 98 | 3 |
332456 | 332456 | 2020-07-14 | Casey | Kentucky | 21045 | 103 | 4 |
335649 | 335649 | 2020-07-15 | Casey | Kentucky | 21045 | 113 | 4 |
338845 | 338845 | 2020-07-16 | Casey | Kentucky | 21045 | 118 | 5 |
342041 | 342041 | 2020-07-17 | Casey | Kentucky | 21045 | 126 | 5 |
345241 | 345241 | 2020-07-18 | Casey | Kentucky | 21045 | 128 | 5 |
348442 | 348442 | 2020-07-19 | Casey | Kentucky | 21045 | 128 | 6 |
351642 | 351642 | 2020-07-20 | Casey | Kentucky | 21045 | 130 | 7 |
354844 | 354844 | 2020-07-21 | Casey | Kentucky | 21045 | 135 | 7 |
358047 | 358047 | 2020-07-22 | Casey | Kentucky | 21045 | 140 | 8 |
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);