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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947413 | 947413 | 2021-01-20 | Breathitt | Kentucky | 21025 | 787 | 3 |
944166 | 944166 | 2021-01-19 | Breathitt | Kentucky | 21025 | 773 | 3 |
940921 | 940921 | 2021-01-18 | Breathitt | Kentucky | 21025 | 765 | 3 |
937676 | 937676 | 2021-01-17 | Breathitt | Kentucky | 21025 | 764 | 3 |
934431 | 934431 | 2021-01-16 | Breathitt | Kentucky | 21025 | 760 | 3 |
931186 | 931186 | 2021-01-15 | Breathitt | Kentucky | 21025 | 756 | 3 |
927941 | 927941 | 2021-01-14 | Breathitt | Kentucky | 21025 | 741 | 3 |
924695 | 924695 | 2021-01-13 | Breathitt | Kentucky | 21025 | 736 | 3 |
921450 | 921450 | 2021-01-12 | Breathitt | Kentucky | 21025 | 723 | 3 |
918205 | 918205 | 2021-01-11 | Breathitt | Kentucky | 21025 | 719 | 3 |
914960 | 914960 | 2021-01-10 | Breathitt | Kentucky | 21025 | 717 | 3 |
911715 | 911715 | 2021-01-09 | Breathitt | Kentucky | 21025 | 715 | 3 |
908470 | 908470 | 2021-01-08 | Breathitt | Kentucky | 21025 | 702 | 3 |
905224 | 905224 | 2021-01-07 | Breathitt | Kentucky | 21025 | 692 | 3 |
901979 | 901979 | 2021-01-06 | Breathitt | Kentucky | 21025 | 683 | 3 |
898734 | 898734 | 2021-01-05 | Breathitt | Kentucky | 21025 | 657 | 3 |
895489 | 895489 | 2021-01-04 | Breathitt | Kentucky | 21025 | 656 | 3 |
892242 | 892242 | 2021-01-03 | Breathitt | Kentucky | 21025 | 655 | 3 |
888996 | 888996 | 2021-01-02 | Breathitt | Kentucky | 21025 | 650 | 3 |
885750 | 885750 | 2021-01-01 | Breathitt | Kentucky | 21025 | 597 | 3 |
882505 | 882505 | 2020-12-31 | Breathitt | Kentucky | 21025 | 597 | 3 |
879260 | 879260 | 2020-12-30 | Breathitt | Kentucky | 21025 | 597 | 3 |
876015 | 876015 | 2020-12-29 | Breathitt | Kentucky | 21025 | 583 | 3 |
872770 | 872770 | 2020-12-28 | Breathitt | Kentucky | 21025 | 572 | 3 |
869525 | 869525 | 2020-12-27 | Breathitt | Kentucky | 21025 | 572 | 3 |
866280 | 866280 | 2020-12-26 | Breathitt | Kentucky | 21025 | 554 | 3 |
863035 | 863035 | 2020-12-25 | Breathitt | Kentucky | 21025 | 543 | 3 |
859790 | 859790 | 2020-12-24 | Breathitt | Kentucky | 21025 | 543 | 3 |
856545 | 856545 | 2020-12-23 | Breathitt | Kentucky | 21025 | 543 | 3 |
853300 | 853300 | 2020-12-22 | Breathitt | Kentucky | 21025 | 529 | 3 |
850055 | 850055 | 2020-12-21 | Breathitt | Kentucky | 21025 | 518 | 3 |
846810 | 846810 | 2020-12-20 | Breathitt | Kentucky | 21025 | 514 | 3 |
843564 | 843564 | 2020-12-19 | Breathitt | Kentucky | 21025 | 514 | 3 |
840319 | 840319 | 2020-12-18 | Breathitt | Kentucky | 21025 | 501 | 3 |
837074 | 837074 | 2020-12-17 | Breathitt | Kentucky | 21025 | 492 | 3 |
833828 | 833828 | 2020-12-16 | Breathitt | Kentucky | 21025 | 488 | 3 |
830581 | 830581 | 2020-12-15 | Breathitt | Kentucky | 21025 | 481 | 3 |
827335 | 827335 | 2020-12-14 | Breathitt | Kentucky | 21025 | 461 | 3 |
824088 | 824088 | 2020-12-13 | Breathitt | Kentucky | 21025 | 460 | 3 |
820842 | 820842 | 2020-12-12 | Breathitt | Kentucky | 21025 | 459 | 3 |
817596 | 817596 | 2020-12-11 | Breathitt | Kentucky | 21025 | 444 | 3 |
814350 | 814350 | 2020-12-10 | Breathitt | Kentucky | 21025 | 432 | 3 |
811105 | 811105 | 2020-12-09 | Breathitt | Kentucky | 21025 | 425 | 3 |
807860 | 807860 | 2020-12-08 | Breathitt | Kentucky | 21025 | 423 | 3 |
804615 | 804615 | 2020-12-07 | Breathitt | Kentucky | 21025 | 422 | 3 |
801370 | 801370 | 2020-12-06 | Breathitt | Kentucky | 21025 | 422 | 3 |
798125 | 798125 | 2020-12-05 | Breathitt | Kentucky | 21025 | 396 | 3 |
794880 | 794880 | 2020-12-04 | Breathitt | Kentucky | 21025 | 384 | 3 |
791635 | 791635 | 2020-12-03 | Breathitt | Kentucky | 21025 | 374 | 3 |
788390 | 788390 | 2020-12-02 | Breathitt | Kentucky | 21025 | 374 | 3 |
785146 | 785146 | 2020-12-01 | Breathitt | Kentucky | 21025 | 374 | 3 |
781901 | 781901 | 2020-11-30 | Breathitt | Kentucky | 21025 | 372 | 3 |
778655 | 778655 | 2020-11-29 | Breathitt | Kentucky | 21025 | 367 | 3 |
775410 | 775410 | 2020-11-28 | Breathitt | Kentucky | 21025 | 349 | 3 |
772165 | 772165 | 2020-11-27 | Breathitt | Kentucky | 21025 | 336 | 3 |
768920 | 768920 | 2020-11-26 | Breathitt | Kentucky | 21025 | 323 | 3 |
765674 | 765674 | 2020-11-25 | Breathitt | Kentucky | 21025 | 323 | 3 |
762429 | 762429 | 2020-11-24 | Breathitt | Kentucky | 21025 | 311 | 3 |
759184 | 759184 | 2020-11-23 | Breathitt | Kentucky | 21025 | 309 | 3 |
755937 | 755937 | 2020-11-22 | Breathitt | Kentucky | 21025 | 294 | 3 |
752691 | 752691 | 2020-11-21 | Breathitt | Kentucky | 21025 | 292 | 3 |
749445 | 749445 | 2020-11-20 | Breathitt | Kentucky | 21025 | 284 | 3 |
746199 | 746199 | 2020-11-19 | Breathitt | Kentucky | 21025 | 277 | 3 |
742952 | 742952 | 2020-11-18 | Breathitt | Kentucky | 21025 | 274 | 3 |
739705 | 739705 | 2020-11-17 | Breathitt | Kentucky | 21025 | 257 | 3 |
736461 | 736461 | 2020-11-16 | Breathitt | Kentucky | 21025 | 244 | 2 |
733215 | 733215 | 2020-11-15 | Breathitt | Kentucky | 21025 | 229 | 2 |
729970 | 729970 | 2020-11-14 | Breathitt | Kentucky | 21025 | 224 | 2 |
726727 | 726727 | 2020-11-13 | Breathitt | Kentucky | 21025 | 215 | 2 |
723484 | 723484 | 2020-11-12 | Breathitt | Kentucky | 21025 | 205 | 2 |
720241 | 720241 | 2020-11-11 | Breathitt | Kentucky | 21025 | 202 | 2 |
716998 | 716998 | 2020-11-10 | Breathitt | Kentucky | 21025 | 193 | 2 |
713754 | 713754 | 2020-11-09 | Breathitt | Kentucky | 21025 | 186 | 2 |
710510 | 710510 | 2020-11-08 | Breathitt | Kentucky | 21025 | 186 | 2 |
707266 | 707266 | 2020-11-07 | Breathitt | Kentucky | 21025 | 186 | 2 |
704023 | 704023 | 2020-11-06 | Breathitt | Kentucky | 21025 | 181 | 1 |
700781 | 700781 | 2020-11-05 | Breathitt | Kentucky | 21025 | 170 | 1 |
697537 | 697537 | 2020-11-04 | Breathitt | Kentucky | 21025 | 162 | 1 |
694294 | 694294 | 2020-11-03 | Breathitt | Kentucky | 21025 | 161 | 1 |
691052 | 691052 | 2020-11-02 | Breathitt | Kentucky | 21025 | 159 | 1 |
687807 | 687807 | 2020-11-01 | Breathitt | Kentucky | 21025 | 153 | 1 |
684563 | 684563 | 2020-10-31 | Breathitt | Kentucky | 21025 | 151 | 1 |
681320 | 681320 | 2020-10-30 | Breathitt | Kentucky | 21025 | 146 | 1 |
678076 | 678076 | 2020-10-29 | Breathitt | Kentucky | 21025 | 143 | 1 |
674834 | 674834 | 2020-10-28 | Breathitt | Kentucky | 21025 | 138 | 1 |
671591 | 671591 | 2020-10-27 | Breathitt | Kentucky | 21025 | 130 | 0 |
668349 | 668349 | 2020-10-26 | Breathitt | Kentucky | 21025 | 127 | 0 |
665105 | 665105 | 2020-10-25 | Breathitt | Kentucky | 21025 | 127 | 0 |
661860 | 661860 | 2020-10-24 | Breathitt | Kentucky | 21025 | 121 | 0 |
658616 | 658616 | 2020-10-23 | Breathitt | Kentucky | 21025 | 117 | 0 |
655371 | 655371 | 2020-10-22 | Breathitt | Kentucky | 21025 | 115 | 0 |
652126 | 652126 | 2020-10-21 | Breathitt | Kentucky | 21025 | 114 | 0 |
648881 | 648881 | 2020-10-20 | Breathitt | Kentucky | 21025 | 112 | 0 |
645637 | 645637 | 2020-10-19 | Breathitt | Kentucky | 21025 | 108 | 0 |
642390 | 642390 | 2020-10-18 | Breathitt | Kentucky | 21025 | 108 | 0 |
639143 | 639143 | 2020-10-17 | Breathitt | Kentucky | 21025 | 108 | 0 |
635897 | 635897 | 2020-10-16 | Breathitt | Kentucky | 21025 | 108 | 0 |
632651 | 632651 | 2020-10-15 | Breathitt | Kentucky | 21025 | 106 | 0 |
629407 | 629407 | 2020-10-14 | Breathitt | Kentucky | 21025 | 105 | 0 |
626163 | 626163 | 2020-10-13 | Breathitt | Kentucky | 21025 | 105 | 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);