ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where fips = 21193 and state = "Kentucky" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
31613 | 31613 | 2020-04-04 | Perry | Kentucky | 21193 | 2 | 0 |
34037 | 34037 | 2020-04-05 | Perry | Kentucky | 21193 | 3 | 0 |
36495 | 36495 | 2020-04-06 | Perry | Kentucky | 21193 | 3 | 0 |
39002 | 39002 | 2020-04-07 | Perry | Kentucky | 21193 | 3 | 0 |
41552 | 41552 | 2020-04-08 | Perry | Kentucky | 21193 | 3 | 0 |
44128 | 44128 | 2020-04-09 | Perry | Kentucky | 21193 | 3 | 0 |
46736 | 46736 | 2020-04-10 | Perry | Kentucky | 21193 | 3 | 0 |
49376 | 49376 | 2020-04-11 | Perry | Kentucky | 21193 | 3 | 0 |
52044 | 52044 | 2020-04-12 | Perry | Kentucky | 21193 | 3 | 0 |
54725 | 54725 | 2020-04-13 | Perry | Kentucky | 21193 | 4 | 0 |
57423 | 57423 | 2020-04-14 | Perry | Kentucky | 21193 | 4 | 0 |
60132 | 60132 | 2020-04-15 | Perry | Kentucky | 21193 | 4 | 0 |
62852 | 62852 | 2020-04-16 | Perry | Kentucky | 21193 | 4 | 0 |
65591 | 65591 | 2020-04-17 | Perry | Kentucky | 21193 | 4 | 0 |
68340 | 68340 | 2020-04-18 | Perry | Kentucky | 21193 | 4 | 0 |
71103 | 71103 | 2020-04-19 | Perry | Kentucky | 21193 | 4 | 0 |
73875 | 73875 | 2020-04-20 | Perry | Kentucky | 21193 | 4 | 0 |
76656 | 76656 | 2020-04-21 | Perry | Kentucky | 21193 | 5 | 0 |
79441 | 79441 | 2020-04-22 | Perry | Kentucky | 21193 | 5 | 0 |
82238 | 82238 | 2020-04-23 | Perry | Kentucky | 21193 | 5 | 0 |
85041 | 85041 | 2020-04-24 | Perry | Kentucky | 21193 | 5 | 0 |
87850 | 87850 | 2020-04-25 | Perry | Kentucky | 21193 | 6 | 0 |
90666 | 90666 | 2020-04-26 | Perry | Kentucky | 21193 | 6 | 0 |
93487 | 93487 | 2020-04-27 | Perry | Kentucky | 21193 | 6 | 0 |
96322 | 96322 | 2020-04-28 | Perry | Kentucky | 21193 | 6 | 0 |
99168 | 99168 | 2020-04-29 | Perry | Kentucky | 21193 | 6 | 0 |
102020 | 102020 | 2020-04-30 | Perry | Kentucky | 21193 | 12 | 0 |
104881 | 104881 | 2020-05-01 | Perry | Kentucky | 21193 | 13 | 0 |
107746 | 107746 | 2020-05-02 | Perry | Kentucky | 21193 | 13 | 0 |
110617 | 110617 | 2020-05-03 | Perry | Kentucky | 21193 | 14 | 0 |
113494 | 113494 | 2020-05-04 | Perry | Kentucky | 21193 | 14 | 0 |
116376 | 116376 | 2020-05-05 | Perry | Kentucky | 21193 | 14 | 0 |
119337 | 119337 | 2020-05-06 | Perry | Kentucky | 21193 | 14 | 0 |
122308 | 122308 | 2020-05-07 | Perry | Kentucky | 21193 | 14 | 0 |
125290 | 125290 | 2020-05-08 | Perry | Kentucky | 21193 | 14 | 0 |
128278 | 128278 | 2020-05-09 | Perry | Kentucky | 21193 | 14 | 0 |
131268 | 131268 | 2020-05-10 | Perry | Kentucky | 21193 | 14 | 0 |
134259 | 134259 | 2020-05-11 | Perry | Kentucky | 21193 | 16 | 0 |
137249 | 137249 | 2020-05-12 | Perry | Kentucky | 21193 | 16 | 0 |
140242 | 140242 | 2020-05-13 | Perry | Kentucky | 21193 | 16 | 0 |
143238 | 143238 | 2020-05-14 | Perry | Kentucky | 21193 | 18 | 0 |
146238 | 146238 | 2020-05-15 | Perry | Kentucky | 21193 | 19 | 0 |
149243 | 149243 | 2020-05-16 | Perry | Kentucky | 21193 | 19 | 0 |
152254 | 152254 | 2020-05-17 | Perry | Kentucky | 21193 | 19 | 0 |
155268 | 155268 | 2020-05-18 | Perry | Kentucky | 21193 | 20 | 0 |
158285 | 158285 | 2020-05-19 | Perry | Kentucky | 21193 | 20 | 0 |
161311 | 161311 | 2020-05-20 | Perry | Kentucky | 21193 | 19 | 0 |
164340 | 164340 | 2020-05-21 | Perry | Kentucky | 21193 | 19 | 0 |
167376 | 167376 | 2020-05-22 | Perry | Kentucky | 21193 | 19 | 0 |
170414 | 170414 | 2020-05-23 | Perry | Kentucky | 21193 | 19 | 0 |
173455 | 173455 | 2020-05-24 | Perry | Kentucky | 21193 | 19 | 0 |
176499 | 176499 | 2020-05-25 | Perry | Kentucky | 21193 | 19 | 0 |
179543 | 179543 | 2020-05-26 | Perry | Kentucky | 21193 | 19 | 0 |
182588 | 182588 | 2020-05-27 | Perry | Kentucky | 21193 | 19 | 0 |
185643 | 185643 | 2020-05-28 | Perry | Kentucky | 21193 | 19 | 0 |
188701 | 188701 | 2020-05-29 | Perry | Kentucky | 21193 | 19 | 0 |
191765 | 191765 | 2020-05-30 | Perry | Kentucky | 21193 | 19 | 0 |
194833 | 194833 | 2020-05-31 | Perry | Kentucky | 21193 | 19 | 0 |
197904 | 197904 | 2020-06-01 | Perry | Kentucky | 21193 | 19 | 0 |
200976 | 200976 | 2020-06-02 | Perry | Kentucky | 21193 | 21 | 0 |
204053 | 204053 | 2020-06-03 | Perry | Kentucky | 21193 | 22 | 0 |
207134 | 207134 | 2020-06-04 | Perry | Kentucky | 21193 | 22 | 0 |
210215 | 210215 | 2020-06-05 | Perry | Kentucky | 21193 | 22 | 0 |
213300 | 213300 | 2020-06-06 | Perry | Kentucky | 21193 | 22 | 0 |
216387 | 216387 | 2020-06-07 | Perry | Kentucky | 21193 | 22 | 0 |
219479 | 219479 | 2020-06-08 | Perry | Kentucky | 21193 | 22 | 0 |
222574 | 222574 | 2020-06-09 | Perry | Kentucky | 21193 | 22 | 0 |
225670 | 225670 | 2020-06-10 | Perry | Kentucky | 21193 | 22 | 0 |
228772 | 228772 | 2020-06-11 | Perry | Kentucky | 21193 | 22 | 0 |
231876 | 231876 | 2020-06-12 | Perry | Kentucky | 21193 | 23 | 0 |
234981 | 234981 | 2020-06-13 | Perry | Kentucky | 21193 | 23 | 0 |
238088 | 238088 | 2020-06-14 | Perry | Kentucky | 21193 | 28 | 0 |
241197 | 241197 | 2020-06-15 | Perry | Kentucky | 21193 | 28 | 0 |
244308 | 244308 | 2020-06-16 | Perry | Kentucky | 21193 | 28 | 0 |
247421 | 247421 | 2020-06-17 | Perry | Kentucky | 21193 | 28 | 0 |
250533 | 250533 | 2020-06-18 | Perry | Kentucky | 21193 | 28 | 1 |
253648 | 253648 | 2020-06-19 | Perry | Kentucky | 21193 | 38 | 1 |
256768 | 256768 | 2020-06-20 | Perry | Kentucky | 21193 | 39 | 1 |
259894 | 259894 | 2020-06-21 | Perry | Kentucky | 21193 | 41 | 1 |
263023 | 263023 | 2020-06-22 | Perry | Kentucky | 21193 | 43 | 1 |
266150 | 266150 | 2020-06-23 | Perry | Kentucky | 21193 | 49 | 1 |
269283 | 269283 | 2020-06-24 | Perry | Kentucky | 21193 | 53 | 1 |
272419 | 272419 | 2020-06-25 | Perry | Kentucky | 21193 | 55 | 1 |
275562 | 275562 | 2020-06-26 | Perry | Kentucky | 21193 | 56 | 1 |
278710 | 278710 | 2020-06-27 | Perry | Kentucky | 21193 | 57 | 1 |
281858 | 281858 | 2020-06-28 | Perry | Kentucky | 21193 | 59 | 1 |
285004 | 285004 | 2020-06-29 | Perry | Kentucky | 21193 | 59 | 1 |
288153 | 288153 | 2020-06-30 | Perry | Kentucky | 21193 | 59 | 1 |
291303 | 291303 | 2020-07-01 | Perry | Kentucky | 21193 | 59 | 1 |
294457 | 294457 | 2020-07-02 | Perry | Kentucky | 21193 | 62 | 1 |
297615 | 297615 | 2020-07-03 | Perry | Kentucky | 21193 | 62 | 1 |
300777 | 300777 | 2020-07-04 | Perry | Kentucky | 21193 | 62 | 1 |
303941 | 303941 | 2020-07-05 | Perry | Kentucky | 21193 | 62 | 1 |
307108 | 307108 | 2020-07-06 | Perry | Kentucky | 21193 | 68 | 1 |
310276 | 310276 | 2020-07-07 | Perry | Kentucky | 21193 | 69 | 1 |
313446 | 313446 | 2020-07-08 | Perry | Kentucky | 21193 | 73 | 2 |
316620 | 316620 | 2020-07-09 | Perry | Kentucky | 21193 | 74 | 2 |
319795 | 319795 | 2020-07-10 | Perry | Kentucky | 21193 | 81 | 2 |
322974 | 322974 | 2020-07-11 | Perry | Kentucky | 21193 | 83 | 2 |
326157 | 326157 | 2020-07-12 | Perry | Kentucky | 21193 | 86 | 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);