ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 21011 and state = "Kentucky" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
26863 | 26863 | 2020-04-02 | Bath | Kentucky | 21011 | 1 | 0 |
29179 | 29179 | 2020-04-03 | Bath | Kentucky | 21011 | 1 | 0 |
31553 | 31553 | 2020-04-04 | Bath | Kentucky | 21011 | 1 | 0 |
33970 | 33970 | 2020-04-05 | Bath | Kentucky | 21011 | 1 | 0 |
36428 | 36428 | 2020-04-06 | Bath | Kentucky | 21011 | 1 | 0 |
38933 | 38933 | 2020-04-07 | Bath | Kentucky | 21011 | 1 | 0 |
41482 | 41482 | 2020-04-08 | Bath | Kentucky | 21011 | 1 | 0 |
44057 | 44057 | 2020-04-09 | Bath | Kentucky | 21011 | 1 | 0 |
46665 | 46665 | 2020-04-10 | Bath | Kentucky | 21011 | 1 | 0 |
49302 | 49302 | 2020-04-11 | Bath | Kentucky | 21011 | 2 | 0 |
51968 | 51968 | 2020-04-12 | Bath | Kentucky | 21011 | 3 | 0 |
54649 | 54649 | 2020-04-13 | Bath | Kentucky | 21011 | 3 | 0 |
57344 | 57344 | 2020-04-14 | Bath | Kentucky | 21011 | 3 | 0 |
60053 | 60053 | 2020-04-15 | Bath | Kentucky | 21011 | 3 | 0 |
62773 | 62773 | 2020-04-16 | Bath | Kentucky | 21011 | 3 | 0 |
65512 | 65512 | 2020-04-17 | Bath | Kentucky | 21011 | 3 | 0 |
68261 | 68261 | 2020-04-18 | Bath | Kentucky | 21011 | 3 | 0 |
71022 | 71022 | 2020-04-19 | Bath | Kentucky | 21011 | 3 | 0 |
73794 | 73794 | 2020-04-20 | Bath | Kentucky | 21011 | 3 | 0 |
76574 | 76574 | 2020-04-21 | Bath | Kentucky | 21011 | 3 | 0 |
79359 | 79359 | 2020-04-22 | Bath | Kentucky | 21011 | 3 | 0 |
82155 | 82155 | 2020-04-23 | Bath | Kentucky | 21011 | 3 | 0 |
84958 | 84958 | 2020-04-24 | Bath | Kentucky | 21011 | 3 | 0 |
87767 | 87767 | 2020-04-25 | Bath | Kentucky | 21011 | 4 | 0 |
90583 | 90583 | 2020-04-26 | Bath | Kentucky | 21011 | 4 | 0 |
93404 | 93404 | 2020-04-27 | Bath | Kentucky | 21011 | 4 | 0 |
96237 | 96237 | 2020-04-28 | Bath | Kentucky | 21011 | 4 | 0 |
99083 | 99083 | 2020-04-29 | Bath | Kentucky | 21011 | 4 | 0 |
101935 | 101935 | 2020-04-30 | Bath | Kentucky | 21011 | 4 | 1 |
104796 | 104796 | 2020-05-01 | Bath | Kentucky | 21011 | 4 | 1 |
107661 | 107661 | 2020-05-02 | Bath | Kentucky | 21011 | 4 | 1 |
110532 | 110532 | 2020-05-03 | Bath | Kentucky | 21011 | 4 | 1 |
113409 | 113409 | 2020-05-04 | Bath | Kentucky | 21011 | 4 | 1 |
116291 | 116291 | 2020-05-05 | Bath | Kentucky | 21011 | 4 | 1 |
119252 | 119252 | 2020-05-06 | Bath | Kentucky | 21011 | 4 | 1 |
122222 | 122222 | 2020-05-07 | Bath | Kentucky | 21011 | 4 | 1 |
125204 | 125204 | 2020-05-08 | Bath | Kentucky | 21011 | 4 | 1 |
128192 | 128192 | 2020-05-09 | Bath | Kentucky | 21011 | 5 | 1 |
131182 | 131182 | 2020-05-10 | Bath | Kentucky | 21011 | 5 | 1 |
134173 | 134173 | 2020-05-11 | Bath | Kentucky | 21011 | 6 | 1 |
137163 | 137163 | 2020-05-12 | Bath | Kentucky | 21011 | 7 | 1 |
140156 | 140156 | 2020-05-13 | Bath | Kentucky | 21011 | 7 | 1 |
143152 | 143152 | 2020-05-14 | Bath | Kentucky | 21011 | 7 | 1 |
146152 | 146152 | 2020-05-15 | Bath | Kentucky | 21011 | 7 | 1 |
149156 | 149156 | 2020-05-16 | Bath | Kentucky | 21011 | 7 | 1 |
152167 | 152167 | 2020-05-17 | Bath | Kentucky | 21011 | 7 | 1 |
155180 | 155180 | 2020-05-18 | Bath | Kentucky | 21011 | 7 | 1 |
158197 | 158197 | 2020-05-19 | Bath | Kentucky | 21011 | 7 | 1 |
161222 | 161222 | 2020-05-20 | Bath | Kentucky | 21011 | 7 | 1 |
164251 | 164251 | 2020-05-21 | Bath | Kentucky | 21011 | 8 | 1 |
167287 | 167287 | 2020-05-22 | Bath | Kentucky | 21011 | 8 | 1 |
170325 | 170325 | 2020-05-23 | Bath | Kentucky | 21011 | 8 | 1 |
173366 | 173366 | 2020-05-24 | Bath | Kentucky | 21011 | 8 | 1 |
176410 | 176410 | 2020-05-25 | Bath | Kentucky | 21011 | 8 | 1 |
179454 | 179454 | 2020-05-26 | Bath | Kentucky | 21011 | 8 | 1 |
182499 | 182499 | 2020-05-27 | Bath | Kentucky | 21011 | 8 | 1 |
185553 | 185553 | 2020-05-28 | Bath | Kentucky | 21011 | 8 | 1 |
188611 | 188611 | 2020-05-29 | Bath | Kentucky | 21011 | 9 | 1 |
191675 | 191675 | 2020-05-30 | Bath | Kentucky | 21011 | 9 | 1 |
194743 | 194743 | 2020-05-31 | Bath | Kentucky | 21011 | 9 | 1 |
197814 | 197814 | 2020-06-01 | Bath | Kentucky | 21011 | 9 | 1 |
200885 | 200885 | 2020-06-02 | Bath | Kentucky | 21011 | 9 | 1 |
203962 | 203962 | 2020-06-03 | Bath | Kentucky | 21011 | 9 | 1 |
207043 | 207043 | 2020-06-04 | Bath | Kentucky | 21011 | 9 | 1 |
210124 | 210124 | 2020-06-05 | Bath | Kentucky | 21011 | 9 | 1 |
213209 | 213209 | 2020-06-06 | Bath | Kentucky | 21011 | 9 | 1 |
216296 | 216296 | 2020-06-07 | Bath | Kentucky | 21011 | 9 | 1 |
219388 | 219388 | 2020-06-08 | Bath | Kentucky | 21011 | 9 | 1 |
222483 | 222483 | 2020-06-09 | Bath | Kentucky | 21011 | 9 | 1 |
225579 | 225579 | 2020-06-10 | Bath | Kentucky | 21011 | 9 | 1 |
228681 | 228681 | 2020-06-11 | Bath | Kentucky | 21011 | 9 | 1 |
231785 | 231785 | 2020-06-12 | Bath | Kentucky | 21011 | 10 | 1 |
234890 | 234890 | 2020-06-13 | Bath | Kentucky | 21011 | 10 | 1 |
237997 | 237997 | 2020-06-14 | Bath | Kentucky | 21011 | 10 | 1 |
241106 | 241106 | 2020-06-15 | Bath | Kentucky | 21011 | 10 | 1 |
244217 | 244217 | 2020-06-16 | Bath | Kentucky | 21011 | 10 | 1 |
247330 | 247330 | 2020-06-17 | Bath | Kentucky | 21011 | 10 | 1 |
250442 | 250442 | 2020-06-18 | Bath | Kentucky | 21011 | 10 | 1 |
253557 | 253557 | 2020-06-19 | Bath | Kentucky | 21011 | 10 | 1 |
256677 | 256677 | 2020-06-20 | Bath | Kentucky | 21011 | 10 | 1 |
259803 | 259803 | 2020-06-21 | Bath | Kentucky | 21011 | 10 | 1 |
262932 | 262932 | 2020-06-22 | Bath | Kentucky | 21011 | 10 | 1 |
266059 | 266059 | 2020-06-23 | Bath | Kentucky | 21011 | 11 | 1 |
269192 | 269192 | 2020-06-24 | Bath | Kentucky | 21011 | 11 | 1 |
272328 | 272328 | 2020-06-25 | Bath | Kentucky | 21011 | 11 | 1 |
275471 | 275471 | 2020-06-26 | Bath | Kentucky | 21011 | 12 | 1 |
278619 | 278619 | 2020-06-27 | Bath | Kentucky | 21011 | 13 | 1 |
281767 | 281767 | 2020-06-28 | Bath | Kentucky | 21011 | 13 | 1 |
284913 | 284913 | 2020-06-29 | Bath | Kentucky | 21011 | 13 | 1 |
288062 | 288062 | 2020-06-30 | Bath | Kentucky | 21011 | 15 | 1 |
291212 | 291212 | 2020-07-01 | Bath | Kentucky | 21011 | 15 | 1 |
294366 | 294366 | 2020-07-02 | Bath | Kentucky | 21011 | 15 | 1 |
297524 | 297524 | 2020-07-03 | Bath | Kentucky | 21011 | 18 | 1 |
300686 | 300686 | 2020-07-04 | Bath | Kentucky | 21011 | 18 | 1 |
303850 | 303850 | 2020-07-05 | Bath | Kentucky | 21011 | 18 | 1 |
307017 | 307017 | 2020-07-06 | Bath | Kentucky | 21011 | 18 | 1 |
310185 | 310185 | 2020-07-07 | Bath | Kentucky | 21011 | 18 | 1 |
313355 | 313355 | 2020-07-08 | Bath | Kentucky | 21011 | 18 | 1 |
316529 | 316529 | 2020-07-09 | Bath | Kentucky | 21011 | 18 | 1 |
319704 | 319704 | 2020-07-10 | Bath | Kentucky | 21011 | 18 | 1 |
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);