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 |
---|---|---|---|---|---|---|---|
535508 | 535508 | 2020-09-15 | Morgan | Kentucky | 21175 | 50 | 0 |
532273 | 532273 | 2020-09-14 | Morgan | Kentucky | 21175 | 50 | 0 |
529036 | 529036 | 2020-09-13 | Morgan | Kentucky | 21175 | 50 | 0 |
525800 | 525800 | 2020-09-12 | Morgan | Kentucky | 21175 | 50 | 0 |
522564 | 522564 | 2020-09-11 | Morgan | Kentucky | 21175 | 50 | 0 |
519327 | 519327 | 2020-09-10 | Morgan | Kentucky | 21175 | 51 | 0 |
516092 | 516092 | 2020-09-09 | Morgan | Kentucky | 21175 | 51 | 0 |
512859 | 512859 | 2020-09-08 | Morgan | Kentucky | 21175 | 51 | 0 |
509627 | 509627 | 2020-09-07 | Morgan | Kentucky | 21175 | 50 | 0 |
506394 | 506394 | 2020-09-06 | Morgan | Kentucky | 21175 | 50 | 0 |
503160 | 503160 | 2020-09-05 | Morgan | Kentucky | 21175 | 50 | 0 |
499927 | 499927 | 2020-09-04 | Morgan | Kentucky | 21175 | 50 | 0 |
496693 | 496693 | 2020-09-03 | Morgan | Kentucky | 21175 | 50 | 0 |
493460 | 493460 | 2020-09-02 | Morgan | Kentucky | 21175 | 49 | 0 |
490226 | 490226 | 2020-09-01 | Morgan | Kentucky | 21175 | 47 | 0 |
486993 | 486993 | 2020-08-31 | Morgan | Kentucky | 21175 | 46 | 0 |
483758 | 483758 | 2020-08-30 | Morgan | Kentucky | 21175 | 45 | 0 |
480524 | 480524 | 2020-08-29 | Morgan | Kentucky | 21175 | 45 | 0 |
477291 | 477291 | 2020-08-28 | Morgan | Kentucky | 21175 | 43 | 0 |
474058 | 474058 | 2020-08-27 | Morgan | Kentucky | 21175 | 41 | 0 |
470826 | 470826 | 2020-08-26 | Morgan | Kentucky | 21175 | 41 | 0 |
467597 | 467597 | 2020-08-25 | Morgan | Kentucky | 21175 | 41 | 0 |
464368 | 464368 | 2020-08-24 | Morgan | Kentucky | 21175 | 40 | 0 |
461137 | 461137 | 2020-08-23 | Morgan | Kentucky | 21175 | 40 | 0 |
457910 | 457910 | 2020-08-22 | Morgan | Kentucky | 21175 | 40 | 0 |
454682 | 454682 | 2020-08-21 | Morgan | Kentucky | 21175 | 40 | 0 |
451454 | 451454 | 2020-08-20 | Morgan | Kentucky | 21175 | 37 | 0 |
448226 | 448226 | 2020-08-19 | Morgan | Kentucky | 21175 | 37 | 0 |
444999 | 444999 | 2020-08-18 | Morgan | Kentucky | 21175 | 36 | 0 |
441773 | 441773 | 2020-08-17 | Morgan | Kentucky | 21175 | 36 | 0 |
438546 | 438546 | 2020-08-16 | Morgan | Kentucky | 21175 | 35 | 0 |
435321 | 435321 | 2020-08-15 | Morgan | Kentucky | 21175 | 35 | 0 |
432096 | 432096 | 2020-08-14 | Morgan | Kentucky | 21175 | 33 | 0 |
428868 | 428868 | 2020-08-13 | Morgan | Kentucky | 21175 | 32 | 0 |
425644 | 425644 | 2020-08-12 | Morgan | Kentucky | 21175 | 30 | 0 |
422423 | 422423 | 2020-08-11 | Morgan | Kentucky | 21175 | 30 | 0 |
419201 | 419201 | 2020-08-10 | Morgan | Kentucky | 21175 | 31 | 0 |
415980 | 415980 | 2020-08-09 | Morgan | Kentucky | 21175 | 31 | 0 |
412760 | 412760 | 2020-08-08 | Morgan | Kentucky | 21175 | 31 | 0 |
409540 | 409540 | 2020-08-07 | Morgan | Kentucky | 21175 | 32 | 0 |
406320 | 406320 | 2020-08-06 | Morgan | Kentucky | 21175 | 30 | 0 |
403102 | 403102 | 2020-08-05 | Morgan | Kentucky | 21175 | 30 | 0 |
399885 | 399885 | 2020-08-04 | Morgan | Kentucky | 21175 | 30 | 0 |
396670 | 396670 | 2020-08-03 | Morgan | Kentucky | 21175 | 30 | 0 |
393454 | 393454 | 2020-08-02 | Morgan | Kentucky | 21175 | 29 | 0 |
390237 | 390237 | 2020-08-01 | Morgan | Kentucky | 21175 | 28 | 0 |
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 |
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);