ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Breathitt" and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
288069 | 288069 | 2020-06-30 | Breathitt | Kentucky | 21025 | 8 | 0 |
291219 | 291219 | 2020-07-01 | Breathitt | Kentucky | 21025 | 8 | 0 |
294373 | 294373 | 2020-07-02 | Breathitt | Kentucky | 21025 | 8 | 0 |
297531 | 297531 | 2020-07-03 | Breathitt | Kentucky | 21025 | 9 | 0 |
300693 | 300693 | 2020-07-04 | Breathitt | Kentucky | 21025 | 9 | 0 |
303857 | 303857 | 2020-07-05 | Breathitt | Kentucky | 21025 | 9 | 0 |
307024 | 307024 | 2020-07-06 | Breathitt | Kentucky | 21025 | 10 | 0 |
310192 | 310192 | 2020-07-07 | Breathitt | Kentucky | 21025 | 12 | 0 |
313362 | 313362 | 2020-07-08 | Breathitt | Kentucky | 21025 | 12 | 0 |
316536 | 316536 | 2020-07-09 | Breathitt | Kentucky | 21025 | 12 | 0 |
319711 | 319711 | 2020-07-10 | Breathitt | Kentucky | 21025 | 15 | 0 |
322890 | 322890 | 2020-07-11 | Breathitt | Kentucky | 21025 | 15 | 0 |
326073 | 326073 | 2020-07-12 | Breathitt | Kentucky | 21025 | 15 | 0 |
329259 | 329259 | 2020-07-13 | Breathitt | Kentucky | 21025 | 15 | 0 |
332446 | 332446 | 2020-07-14 | Breathitt | Kentucky | 21025 | 15 | 0 |
335639 | 335639 | 2020-07-15 | Breathitt | Kentucky | 21025 | 15 | 0 |
338835 | 338835 | 2020-07-16 | Breathitt | Kentucky | 21025 | 16 | 0 |
342031 | 342031 | 2020-07-17 | Breathitt | Kentucky | 21025 | 16 | 0 |
345231 | 345231 | 2020-07-18 | Breathitt | Kentucky | 21025 | 16 | 0 |
348432 | 348432 | 2020-07-19 | Breathitt | Kentucky | 21025 | 16 | 0 |
351632 | 351632 | 2020-07-20 | Breathitt | Kentucky | 21025 | 16 | 0 |
354834 | 354834 | 2020-07-21 | Breathitt | Kentucky | 21025 | 18 | 0 |
358037 | 358037 | 2020-07-22 | Breathitt | Kentucky | 21025 | 18 | 0 |
361242 | 361242 | 2020-07-23 | Breathitt | Kentucky | 21025 | 18 | 0 |
364449 | 364449 | 2020-07-24 | Breathitt | Kentucky | 21025 | 19 | 0 |
367656 | 367656 | 2020-07-25 | Breathitt | Kentucky | 21025 | 19 | 0 |
370866 | 370866 | 2020-07-26 | Breathitt | Kentucky | 21025 | 20 | 0 |
374078 | 374078 | 2020-07-27 | Breathitt | Kentucky | 21025 | 20 | 0 |
377293 | 377293 | 2020-07-28 | Breathitt | Kentucky | 21025 | 21 | 0 |
380510 | 380510 | 2020-07-29 | Breathitt | Kentucky | 21025 | 22 | 0 |
383727 | 383727 | 2020-07-30 | Breathitt | Kentucky | 21025 | 24 | 0 |
386945 | 386945 | 2020-07-31 | Breathitt | Kentucky | 21025 | 24 | 0 |
390162 | 390162 | 2020-08-01 | Breathitt | Kentucky | 21025 | 25 | 0 |
393379 | 393379 | 2020-08-02 | Breathitt | Kentucky | 21025 | 26 | 0 |
396595 | 396595 | 2020-08-03 | Breathitt | Kentucky | 21025 | 26 | 0 |
399810 | 399810 | 2020-08-04 | Breathitt | Kentucky | 21025 | 26 | 0 |
403027 | 403027 | 2020-08-05 | Breathitt | Kentucky | 21025 | 28 | 0 |
406245 | 406245 | 2020-08-06 | Breathitt | Kentucky | 21025 | 28 | 0 |
409465 | 409465 | 2020-08-07 | Breathitt | Kentucky | 21025 | 28 | 0 |
412685 | 412685 | 2020-08-08 | Breathitt | Kentucky | 21025 | 28 | 0 |
415905 | 415905 | 2020-08-09 | Breathitt | Kentucky | 21025 | 31 | 0 |
419126 | 419126 | 2020-08-10 | Breathitt | Kentucky | 21025 | 31 | 0 |
422348 | 422348 | 2020-08-11 | Breathitt | Kentucky | 21025 | 31 | 0 |
425569 | 425569 | 2020-08-12 | Breathitt | Kentucky | 21025 | 32 | 0 |
428793 | 428793 | 2020-08-13 | Breathitt | Kentucky | 21025 | 33 | 0 |
432021 | 432021 | 2020-08-14 | Breathitt | Kentucky | 21025 | 32 | 0 |
435246 | 435246 | 2020-08-15 | Breathitt | Kentucky | 21025 | 33 | 0 |
438471 | 438471 | 2020-08-16 | Breathitt | Kentucky | 21025 | 33 | 0 |
441698 | 441698 | 2020-08-17 | Breathitt | Kentucky | 21025 | 33 | 0 |
444924 | 444924 | 2020-08-18 | Breathitt | Kentucky | 21025 | 33 | 0 |
448151 | 448151 | 2020-08-19 | Breathitt | Kentucky | 21025 | 34 | 0 |
451379 | 451379 | 2020-08-20 | Breathitt | Kentucky | 21025 | 36 | 0 |
454607 | 454607 | 2020-08-21 | Breathitt | Kentucky | 21025 | 38 | 0 |
457835 | 457835 | 2020-08-22 | Breathitt | Kentucky | 21025 | 39 | 0 |
461062 | 461062 | 2020-08-23 | Breathitt | Kentucky | 21025 | 39 | 0 |
464293 | 464293 | 2020-08-24 | Breathitt | Kentucky | 21025 | 49 | 0 |
467522 | 467522 | 2020-08-25 | Breathitt | Kentucky | 21025 | 49 | 0 |
470751 | 470751 | 2020-08-26 | Breathitt | Kentucky | 21025 | 51 | 0 |
473983 | 473983 | 2020-08-27 | Breathitt | Kentucky | 21025 | 54 | 0 |
477216 | 477216 | 2020-08-28 | Breathitt | Kentucky | 21025 | 54 | 0 |
480449 | 480449 | 2020-08-29 | Breathitt | Kentucky | 21025 | 55 | 0 |
483683 | 483683 | 2020-08-30 | Breathitt | Kentucky | 21025 | 55 | 0 |
486918 | 486918 | 2020-08-31 | Breathitt | Kentucky | 21025 | 55 | 0 |
490151 | 490151 | 2020-09-01 | Breathitt | Kentucky | 21025 | 56 | 0 |
493385 | 493385 | 2020-09-02 | Breathitt | Kentucky | 21025 | 56 | 0 |
496618 | 496618 | 2020-09-03 | Breathitt | Kentucky | 21025 | 57 | 0 |
499852 | 499852 | 2020-09-04 | Breathitt | Kentucky | 21025 | 57 | 0 |
503085 | 503085 | 2020-09-05 | Breathitt | Kentucky | 21025 | 57 | 0 |
506319 | 506319 | 2020-09-06 | Breathitt | Kentucky | 21025 | 57 | 0 |
509552 | 509552 | 2020-09-07 | Breathitt | Kentucky | 21025 | 57 | 0 |
512784 | 512784 | 2020-09-08 | Breathitt | Kentucky | 21025 | 58 | 0 |
516017 | 516017 | 2020-09-09 | Breathitt | Kentucky | 21025 | 58 | 0 |
519252 | 519252 | 2020-09-10 | Breathitt | Kentucky | 21025 | 66 | 0 |
522489 | 522489 | 2020-09-11 | Breathitt | Kentucky | 21025 | 66 | 0 |
525725 | 525725 | 2020-09-12 | Breathitt | Kentucky | 21025 | 68 | 0 |
528961 | 528961 | 2020-09-13 | Breathitt | Kentucky | 21025 | 68 | 0 |
532198 | 532198 | 2020-09-14 | Breathitt | Kentucky | 21025 | 70 | 0 |
535433 | 535433 | 2020-09-15 | Breathitt | Kentucky | 21025 | 76 | 0 |
538670 | 538670 | 2020-09-16 | Breathitt | Kentucky | 21025 | 77 | 0 |
541906 | 541906 | 2020-09-17 | Breathitt | Kentucky | 21025 | 82 | 0 |
545142 | 545142 | 2020-09-18 | Breathitt | Kentucky | 21025 | 82 | 0 |
548380 | 548380 | 2020-09-19 | Breathitt | Kentucky | 21025 | 82 | 0 |
551619 | 551619 | 2020-09-20 | Breathitt | Kentucky | 21025 | 82 | 0 |
554858 | 554858 | 2020-09-21 | Breathitt | Kentucky | 21025 | 82 | 0 |
558095 | 558095 | 2020-09-22 | Breathitt | Kentucky | 21025 | 83 | 0 |
561331 | 561331 | 2020-09-23 | Breathitt | Kentucky | 21025 | 84 | 0 |
564571 | 564571 | 2020-09-24 | Breathitt | Kentucky | 21025 | 84 | 0 |
567811 | 567811 | 2020-09-25 | Breathitt | Kentucky | 21025 | 87 | 0 |
571053 | 571053 | 2020-09-26 | Breathitt | Kentucky | 21025 | 87 | 0 |
574296 | 574296 | 2020-09-27 | Breathitt | Kentucky | 21025 | 87 | 0 |
577538 | 577538 | 2020-09-28 | Breathitt | Kentucky | 21025 | 87 | 0 |
580779 | 580779 | 2020-09-29 | Breathitt | Kentucky | 21025 | 89 | 0 |
584019 | 584019 | 2020-09-30 | Breathitt | Kentucky | 21025 | 91 | 0 |
587259 | 587259 | 2020-10-01 | Breathitt | Kentucky | 21025 | 92 | 0 |
590500 | 590500 | 2020-10-02 | Breathitt | Kentucky | 21025 | 95 | 0 |
593741 | 593741 | 2020-10-03 | Breathitt | Kentucky | 21025 | 95 | 0 |
596983 | 596983 | 2020-10-04 | Breathitt | Kentucky | 21025 | 97 | 0 |
600225 | 600225 | 2020-10-05 | Breathitt | Kentucky | 21025 | 97 | 0 |
603468 | 603468 | 2020-10-06 | Breathitt | Kentucky | 21025 | 98 | 0 |
606710 | 606710 | 2020-10-07 | Breathitt | Kentucky | 21025 | 98 | 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);