ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where fips = 21053 and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
31569 | 31569 | 2020-04-04 | Clinton | Kentucky | 21053 | 1 | 0 |
33987 | 33987 | 2020-04-05 | Clinton | Kentucky | 21053 | 1 | 0 |
36445 | 36445 | 2020-04-06 | Clinton | Kentucky | 21053 | 1 | 0 |
38950 | 38950 | 2020-04-07 | Clinton | Kentucky | 21053 | 1 | 0 |
41499 | 41499 | 2020-04-08 | Clinton | Kentucky | 21053 | 1 | 0 |
44074 | 44074 | 2020-04-09 | Clinton | Kentucky | 21053 | 1 | 0 |
46682 | 46682 | 2020-04-10 | Clinton | Kentucky | 21053 | 3 | 0 |
49319 | 49319 | 2020-04-11 | Clinton | Kentucky | 21053 | 3 | 0 |
51985 | 51985 | 2020-04-12 | Clinton | Kentucky | 21053 | 2 | 0 |
54666 | 54666 | 2020-04-13 | Clinton | Kentucky | 21053 | 2 | 0 |
57362 | 57362 | 2020-04-14 | Clinton | Kentucky | 21053 | 2 | 0 |
60071 | 60071 | 2020-04-15 | Clinton | Kentucky | 21053 | 2 | 0 |
62791 | 62791 | 2020-04-16 | Clinton | Kentucky | 21053 | 2 | 0 |
65530 | 65530 | 2020-04-17 | Clinton | Kentucky | 21053 | 2 | 0 |
68279 | 68279 | 2020-04-18 | Clinton | Kentucky | 21053 | 2 | 0 |
71041 | 71041 | 2020-04-19 | Clinton | Kentucky | 21053 | 2 | 0 |
73813 | 73813 | 2020-04-20 | Clinton | Kentucky | 21053 | 2 | 0 |
76593 | 76593 | 2020-04-21 | Clinton | Kentucky | 21053 | 2 | 0 |
79378 | 79378 | 2020-04-22 | Clinton | Kentucky | 21053 | 2 | 0 |
82175 | 82175 | 2020-04-23 | Clinton | Kentucky | 21053 | 2 | 0 |
84978 | 84978 | 2020-04-24 | Clinton | Kentucky | 21053 | 2 | 0 |
87787 | 87787 | 2020-04-25 | Clinton | Kentucky | 21053 | 2 | 0 |
90603 | 90603 | 2020-04-26 | Clinton | Kentucky | 21053 | 2 | 0 |
93424 | 93424 | 2020-04-27 | Clinton | Kentucky | 21053 | 2 | 0 |
96257 | 96257 | 2020-04-28 | Clinton | Kentucky | 21053 | 3 | 0 |
99103 | 99103 | 2020-04-29 | Clinton | Kentucky | 21053 | 3 | 0 |
101955 | 101955 | 2020-04-30 | Clinton | Kentucky | 21053 | 3 | 0 |
104816 | 104816 | 2020-05-01 | Clinton | Kentucky | 21053 | 3 | 0 |
107681 | 107681 | 2020-05-02 | Clinton | Kentucky | 21053 | 3 | 0 |
110552 | 110552 | 2020-05-03 | Clinton | Kentucky | 21053 | 3 | 0 |
113429 | 113429 | 2020-05-04 | Clinton | Kentucky | 21053 | 3 | 0 |
116311 | 116311 | 2020-05-05 | Clinton | Kentucky | 21053 | 3 | 0 |
119272 | 119272 | 2020-05-06 | Clinton | Kentucky | 21053 | 3 | 0 |
122242 | 122242 | 2020-05-07 | Clinton | Kentucky | 21053 | 3 | 0 |
125224 | 125224 | 2020-05-08 | Clinton | Kentucky | 21053 | 3 | 0 |
128212 | 128212 | 2020-05-09 | Clinton | Kentucky | 21053 | 3 | 0 |
131202 | 131202 | 2020-05-10 | Clinton | Kentucky | 21053 | 3 | 0 |
134193 | 134193 | 2020-05-11 | Clinton | Kentucky | 21053 | 3 | 0 |
137183 | 137183 | 2020-05-12 | Clinton | Kentucky | 21053 | 3 | 0 |
140176 | 140176 | 2020-05-13 | Clinton | Kentucky | 21053 | 3 | 0 |
143172 | 143172 | 2020-05-14 | Clinton | Kentucky | 21053 | 3 | 0 |
146172 | 146172 | 2020-05-15 | Clinton | Kentucky | 21053 | 3 | 0 |
149176 | 149176 | 2020-05-16 | Clinton | Kentucky | 21053 | 3 | 0 |
152187 | 152187 | 2020-05-17 | Clinton | Kentucky | 21053 | 3 | 0 |
155201 | 155201 | 2020-05-18 | Clinton | Kentucky | 21053 | 3 | 0 |
158218 | 158218 | 2020-05-19 | Clinton | Kentucky | 21053 | 3 | 0 |
161243 | 161243 | 2020-05-20 | Clinton | Kentucky | 21053 | 3 | 0 |
164272 | 164272 | 2020-05-21 | Clinton | Kentucky | 21053 | 3 | 0 |
167308 | 167308 | 2020-05-22 | Clinton | Kentucky | 21053 | 3 | 0 |
170346 | 170346 | 2020-05-23 | Clinton | Kentucky | 21053 | 3 | 0 |
173387 | 173387 | 2020-05-24 | Clinton | Kentucky | 21053 | 3 | 0 |
176431 | 176431 | 2020-05-25 | Clinton | Kentucky | 21053 | 3 | 0 |
179475 | 179475 | 2020-05-26 | Clinton | Kentucky | 21053 | 3 | 0 |
182520 | 182520 | 2020-05-27 | Clinton | Kentucky | 21053 | 3 | 0 |
185574 | 185574 | 2020-05-28 | Clinton | Kentucky | 21053 | 3 | 0 |
188632 | 188632 | 2020-05-29 | Clinton | Kentucky | 21053 | 3 | 0 |
191696 | 191696 | 2020-05-30 | Clinton | Kentucky | 21053 | 3 | 0 |
194764 | 194764 | 2020-05-31 | Clinton | Kentucky | 21053 | 3 | 0 |
197835 | 197835 | 2020-06-01 | Clinton | Kentucky | 21053 | 4 | 0 |
200906 | 200906 | 2020-06-02 | Clinton | Kentucky | 21053 | 4 | 0 |
203983 | 203983 | 2020-06-03 | Clinton | Kentucky | 21053 | 4 | 0 |
207064 | 207064 | 2020-06-04 | Clinton | Kentucky | 21053 | 5 | 0 |
210145 | 210145 | 2020-06-05 | Clinton | Kentucky | 21053 | 5 | 0 |
213230 | 213230 | 2020-06-06 | Clinton | Kentucky | 21053 | 5 | 0 |
216317 | 216317 | 2020-06-07 | Clinton | Kentucky | 21053 | 5 | 0 |
219409 | 219409 | 2020-06-08 | Clinton | Kentucky | 21053 | 5 | 0 |
222504 | 222504 | 2020-06-09 | Clinton | Kentucky | 21053 | 5 | 0 |
225600 | 225600 | 2020-06-10 | Clinton | Kentucky | 21053 | 5 | 0 |
228702 | 228702 | 2020-06-11 | Clinton | Kentucky | 21053 | 5 | 0 |
231806 | 231806 | 2020-06-12 | Clinton | Kentucky | 21053 | 5 | 0 |
234911 | 234911 | 2020-06-13 | Clinton | Kentucky | 21053 | 5 | 0 |
238018 | 238018 | 2020-06-14 | Clinton | Kentucky | 21053 | 5 | 0 |
241127 | 241127 | 2020-06-15 | Clinton | Kentucky | 21053 | 5 | 0 |
244238 | 244238 | 2020-06-16 | Clinton | Kentucky | 21053 | 5 | 0 |
247351 | 247351 | 2020-06-17 | Clinton | Kentucky | 21053 | 5 | 0 |
250463 | 250463 | 2020-06-18 | Clinton | Kentucky | 21053 | 5 | 0 |
253578 | 253578 | 2020-06-19 | Clinton | Kentucky | 21053 | 5 | 0 |
256698 | 256698 | 2020-06-20 | Clinton | Kentucky | 21053 | 5 | 0 |
259824 | 259824 | 2020-06-21 | Clinton | Kentucky | 21053 | 5 | 0 |
262953 | 262953 | 2020-06-22 | Clinton | Kentucky | 21053 | 5 | 0 |
266080 | 266080 | 2020-06-23 | Clinton | Kentucky | 21053 | 5 | 0 |
269213 | 269213 | 2020-06-24 | Clinton | Kentucky | 21053 | 5 | 0 |
272349 | 272349 | 2020-06-25 | Clinton | Kentucky | 21053 | 5 | 0 |
275492 | 275492 | 2020-06-26 | Clinton | Kentucky | 21053 | 5 | 0 |
278640 | 278640 | 2020-06-27 | Clinton | Kentucky | 21053 | 5 | 0 |
281788 | 281788 | 2020-06-28 | Clinton | Kentucky | 21053 | 5 | 0 |
284934 | 284934 | 2020-06-29 | Clinton | Kentucky | 21053 | 5 | 0 |
288083 | 288083 | 2020-06-30 | Clinton | Kentucky | 21053 | 5 | 0 |
291233 | 291233 | 2020-07-01 | Clinton | Kentucky | 21053 | 5 | 0 |
294387 | 294387 | 2020-07-02 | Clinton | Kentucky | 21053 | 5 | 0 |
297545 | 297545 | 2020-07-03 | Clinton | Kentucky | 21053 | 5 | 0 |
300707 | 300707 | 2020-07-04 | Clinton | Kentucky | 21053 | 5 | 0 |
303871 | 303871 | 2020-07-05 | Clinton | Kentucky | 21053 | 5 | 0 |
307038 | 307038 | 2020-07-06 | Clinton | Kentucky | 21053 | 7 | 0 |
310206 | 310206 | 2020-07-07 | Clinton | Kentucky | 21053 | 7 | 0 |
313376 | 313376 | 2020-07-08 | Clinton | Kentucky | 21053 | 8 | 0 |
316550 | 316550 | 2020-07-09 | Clinton | Kentucky | 21053 | 8 | 0 |
319725 | 319725 | 2020-07-10 | Clinton | Kentucky | 21053 | 8 | 0 |
322904 | 322904 | 2020-07-11 | Clinton | Kentucky | 21053 | 8 | 0 |
326087 | 326087 | 2020-07-12 | Clinton | Kentucky | 21053 | 8 | 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);