ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where county = "Morgan" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387020 | 387020 | 2020-07-31 | Morgan | Kentucky | 21175 | 28 | 0 |
383802 | 383802 | 2020-07-30 | Morgan | Kentucky | 21175 | 28 | 0 |
380585 | 380585 | 2020-07-29 | Morgan | Kentucky | 21175 | 28 | 0 |
377368 | 377368 | 2020-07-28 | Morgan | Kentucky | 21175 | 28 | 0 |
374153 | 374153 | 2020-07-27 | Morgan | Kentucky | 21175 | 28 | 0 |
370941 | 370941 | 2020-07-26 | Morgan | Kentucky | 21175 | 28 | 0 |
367731 | 367731 | 2020-07-25 | Morgan | Kentucky | 21175 | 27 | 0 |
364524 | 364524 | 2020-07-24 | Morgan | Kentucky | 21175 | 25 | 0 |
361317 | 361317 | 2020-07-23 | Morgan | Kentucky | 21175 | 24 | 0 |
358112 | 358112 | 2020-07-22 | Morgan | Kentucky | 21175 | 24 | 0 |
354909 | 354909 | 2020-07-21 | Morgan | Kentucky | 21175 | 24 | 0 |
351707 | 351707 | 2020-07-20 | Morgan | Kentucky | 21175 | 23 | 0 |
348507 | 348507 | 2020-07-19 | Morgan | Kentucky | 21175 | 23 | 0 |
345306 | 345306 | 2020-07-18 | Morgan | Kentucky | 21175 | 22 | 0 |
342106 | 342106 | 2020-07-17 | Morgan | Kentucky | 21175 | 21 | 0 |
338910 | 338910 | 2020-07-16 | Morgan | Kentucky | 21175 | 20 | 0 |
335714 | 335714 | 2020-07-15 | Morgan | Kentucky | 21175 | 20 | 0 |
332521 | 332521 | 2020-07-14 | Morgan | Kentucky | 21175 | 20 | 0 |
329334 | 329334 | 2020-07-13 | Morgan | Kentucky | 21175 | 15 | 0 |
326148 | 326148 | 2020-07-12 | Morgan | Kentucky | 21175 | 15 | 0 |
322965 | 322965 | 2020-07-11 | Morgan | Kentucky | 21175 | 13 | 0 |
319786 | 319786 | 2020-07-10 | Morgan | Kentucky | 21175 | 12 | 0 |
316611 | 316611 | 2020-07-09 | Morgan | Kentucky | 21175 | 12 | 0 |
313437 | 313437 | 2020-07-08 | Morgan | Kentucky | 21175 | 11 | 0 |
310267 | 310267 | 2020-07-07 | Morgan | Kentucky | 21175 | 11 | 0 |
307099 | 307099 | 2020-07-06 | Morgan | Kentucky | 21175 | 10 | 0 |
303932 | 303932 | 2020-07-05 | Morgan | Kentucky | 21175 | 9 | 0 |
300768 | 300768 | 2020-07-04 | Morgan | Kentucky | 21175 | 9 | 0 |
297606 | 297606 | 2020-07-03 | Morgan | Kentucky | 21175 | 9 | 0 |
294448 | 294448 | 2020-07-02 | Morgan | Kentucky | 21175 | 8 | 0 |
291294 | 291294 | 2020-07-01 | Morgan | Kentucky | 21175 | 8 | 0 |
288144 | 288144 | 2020-06-30 | Morgan | Kentucky | 21175 | 8 | 0 |
284995 | 284995 | 2020-06-29 | Morgan | Kentucky | 21175 | 8 | 0 |
281849 | 281849 | 2020-06-28 | Morgan | Kentucky | 21175 | 8 | 0 |
278701 | 278701 | 2020-06-27 | Morgan | Kentucky | 21175 | 8 | 0 |
275553 | 275553 | 2020-06-26 | Morgan | Kentucky | 21175 | 8 | 0 |
272410 | 272410 | 2020-06-25 | Morgan | Kentucky | 21175 | 8 | 0 |
269274 | 269274 | 2020-06-24 | Morgan | Kentucky | 21175 | 8 | 0 |
266141 | 266141 | 2020-06-23 | Morgan | Kentucky | 21175 | 7 | 0 |
263014 | 263014 | 2020-06-22 | Morgan | Kentucky | 21175 | 7 | 0 |
259885 | 259885 | 2020-06-21 | Morgan | Kentucky | 21175 | 7 | 0 |
256759 | 256759 | 2020-06-20 | Morgan | Kentucky | 21175 | 7 | 0 |
253639 | 253639 | 2020-06-19 | Morgan | Kentucky | 21175 | 7 | 0 |
250524 | 250524 | 2020-06-18 | Morgan | Kentucky | 21175 | 7 | 0 |
247412 | 247412 | 2020-06-17 | Morgan | Kentucky | 21175 | 7 | 0 |
244299 | 244299 | 2020-06-16 | Morgan | Kentucky | 21175 | 6 | 0 |
241188 | 241188 | 2020-06-15 | Morgan | Kentucky | 21175 | 6 | 0 |
238079 | 238079 | 2020-06-14 | Morgan | Kentucky | 21175 | 6 | 0 |
234972 | 234972 | 2020-06-13 | Morgan | Kentucky | 21175 | 6 | 0 |
231867 | 231867 | 2020-06-12 | Morgan | Kentucky | 21175 | 6 | 0 |
228763 | 228763 | 2020-06-11 | Morgan | Kentucky | 21175 | 4 | 0 |
225661 | 225661 | 2020-06-10 | Morgan | Kentucky | 21175 | 4 | 0 |
222565 | 222565 | 2020-06-09 | Morgan | Kentucky | 21175 | 4 | 0 |
219470 | 219470 | 2020-06-08 | Morgan | Kentucky | 21175 | 3 | 0 |
216378 | 216378 | 2020-06-07 | Morgan | Kentucky | 21175 | 3 | 0 |
213291 | 213291 | 2020-06-06 | Morgan | Kentucky | 21175 | 3 | 0 |
210206 | 210206 | 2020-06-05 | Morgan | Kentucky | 21175 | 3 | 0 |
207125 | 207125 | 2020-06-04 | Morgan | Kentucky | 21175 | 3 | 0 |
204044 | 204044 | 2020-06-03 | Morgan | Kentucky | 21175 | 3 | 0 |
200967 | 200967 | 2020-06-02 | Morgan | Kentucky | 21175 | 1 | 0 |
197895 | 197895 | 2020-06-01 | Morgan | Kentucky | 21175 | 1 | 0 |
194824 | 194824 | 2020-05-31 | Morgan | Kentucky | 21175 | 1 | 0 |
191756 | 191756 | 2020-05-30 | Morgan | Kentucky | 21175 | 1 | 0 |
188692 | 188692 | 2020-05-29 | Morgan | Kentucky | 21175 | 1 | 0 |
185634 | 185634 | 2020-05-28 | Morgan | Kentucky | 21175 | 1 | 0 |
182579 | 182579 | 2020-05-27 | Morgan | Kentucky | 21175 | 1 | 0 |
179534 | 179534 | 2020-05-26 | Morgan | Kentucky | 21175 | 1 | 0 |
176490 | 176490 | 2020-05-25 | Morgan | Kentucky | 21175 | 1 | 0 |
173446 | 173446 | 2020-05-24 | Morgan | Kentucky | 21175 | 1 | 0 |
170405 | 170405 | 2020-05-23 | Morgan | Kentucky | 21175 | 1 | 0 |
167367 | 167367 | 2020-05-22 | Morgan | Kentucky | 21175 | 1 | 0 |
164331 | 164331 | 2020-05-21 | Morgan | Kentucky | 21175 | 1 | 0 |
161302 | 161302 | 2020-05-20 | Morgan | Kentucky | 21175 | 1 | 0 |
158276 | 158276 | 2020-05-19 | Morgan | Kentucky | 21175 | 1 | 0 |
155259 | 155259 | 2020-05-18 | Morgan | Kentucky | 21175 | 1 | 0 |
152245 | 152245 | 2020-05-17 | Morgan | Kentucky | 21175 | 1 | 0 |
149234 | 149234 | 2020-05-16 | Morgan | Kentucky | 21175 | 1 | 0 |
146229 | 146229 | 2020-05-15 | Morgan | Kentucky | 21175 | 1 | 0 |
143229 | 143229 | 2020-05-14 | Morgan | Kentucky | 21175 | 1 | 0 |
140233 | 140233 | 2020-05-13 | Morgan | Kentucky | 21175 | 1 | 0 |
137240 | 137240 | 2020-05-12 | Morgan | Kentucky | 21175 | 1 | 0 |
134250 | 134250 | 2020-05-11 | Morgan | Kentucky | 21175 | 1 | 0 |
131259 | 131259 | 2020-05-10 | Morgan | Kentucky | 21175 | 1 | 0 |
128269 | 128269 | 2020-05-09 | Morgan | Kentucky | 21175 | 1 | 0 |
125281 | 125281 | 2020-05-08 | Morgan | Kentucky | 21175 | 1 | 0 |
122299 | 122299 | 2020-05-07 | Morgan | Kentucky | 21175 | 1 | 0 |
119328 | 119328 | 2020-05-06 | Morgan | Kentucky | 21175 | 1 | 0 |
116367 | 116367 | 2020-05-05 | Morgan | Kentucky | 21175 | 1 | 0 |
113485 | 113485 | 2020-05-04 | Morgan | Kentucky | 21175 | 1 | 0 |
110608 | 110608 | 2020-05-03 | Morgan | Kentucky | 21175 | 1 | 0 |
107737 | 107737 | 2020-05-02 | Morgan | Kentucky | 21175 | 1 | 0 |
104872 | 104872 | 2020-05-01 | Morgan | Kentucky | 21175 | 1 | 0 |
102011 | 102011 | 2020-04-30 | Morgan | Kentucky | 21175 | 1 | 0 |
99159 | 99159 | 2020-04-29 | Morgan | Kentucky | 21175 | 1 | 0 |
96313 | 96313 | 2020-04-28 | Morgan | Kentucky | 21175 | 1 | 0 |
93479 | 93479 | 2020-04-27 | Morgan | Kentucky | 21175 | 1 | 0 |
90658 | 90658 | 2020-04-26 | Morgan | Kentucky | 21175 | 1 | 0 |
87842 | 87842 | 2020-04-25 | Morgan | Kentucky | 21175 | 1 | 0 |
85033 | 85033 | 2020-04-24 | Morgan | Kentucky | 21175 | 1 | 0 |
82230 | 82230 | 2020-04-23 | Morgan | Kentucky | 21175 | 1 | 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);