ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Bourbon" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947409 | 947409 | 2021-01-20 | Bourbon | Kentucky | 21017 | 1279 | 9 |
944162 | 944162 | 2021-01-19 | Bourbon | Kentucky | 21017 | 1263 | 9 |
940917 | 940917 | 2021-01-18 | Bourbon | Kentucky | 21017 | 1245 | 7 |
937672 | 937672 | 2021-01-17 | Bourbon | Kentucky | 21017 | 1225 | 6 |
934427 | 934427 | 2021-01-16 | Bourbon | Kentucky | 21017 | 1221 | 6 |
931182 | 931182 | 2021-01-15 | Bourbon | Kentucky | 21017 | 1221 | 6 |
927937 | 927937 | 2021-01-14 | Bourbon | Kentucky | 21017 | 1192 | 6 |
924691 | 924691 | 2021-01-13 | Bourbon | Kentucky | 21017 | 1175 | 4 |
921446 | 921446 | 2021-01-12 | Bourbon | Kentucky | 21017 | 1175 | 4 |
918201 | 918201 | 2021-01-11 | Bourbon | Kentucky | 21017 | 1150 | 4 |
914956 | 914956 | 2021-01-10 | Bourbon | Kentucky | 21017 | 1128 | 4 |
911711 | 911711 | 2021-01-09 | Bourbon | Kentucky | 21017 | 1128 | 4 |
908466 | 908466 | 2021-01-08 | Bourbon | Kentucky | 21017 | 1128 | 4 |
905220 | 905220 | 2021-01-07 | Bourbon | Kentucky | 21017 | 1095 | 2 |
901975 | 901975 | 2021-01-06 | Bourbon | Kentucky | 21017 | 1078 | 2 |
898730 | 898730 | 2021-01-05 | Bourbon | Kentucky | 21017 | 1078 | 2 |
895485 | 895485 | 2021-01-04 | Bourbon | Kentucky | 21017 | 1056 | 1 |
892238 | 892238 | 2021-01-03 | Bourbon | Kentucky | 21017 | 1000 | 1 |
888992 | 888992 | 2021-01-02 | Bourbon | Kentucky | 21017 | 1000 | 1 |
885746 | 885746 | 2021-01-01 | Bourbon | Kentucky | 21017 | 1000 | 1 |
882501 | 882501 | 2020-12-31 | Bourbon | Kentucky | 21017 | 1000 | 1 |
879256 | 879256 | 2020-12-30 | Bourbon | Kentucky | 21017 | 979 | 1 |
876011 | 876011 | 2020-12-29 | Bourbon | Kentucky | 21017 | 979 | 1 |
872766 | 872766 | 2020-12-28 | Bourbon | Kentucky | 21017 | 964 | 1 |
869521 | 869521 | 2020-12-27 | Bourbon | Kentucky | 21017 | 852 | 1 |
866276 | 866276 | 2020-12-26 | Bourbon | Kentucky | 21017 | 848 | 1 |
863031 | 863031 | 2020-12-25 | Bourbon | Kentucky | 21017 | 838 | 1 |
859786 | 859786 | 2020-12-24 | Bourbon | Kentucky | 21017 | 838 | 1 |
856541 | 856541 | 2020-12-23 | Bourbon | Kentucky | 21017 | 838 | 1 |
853296 | 853296 | 2020-12-22 | Bourbon | Kentucky | 21017 | 838 | 1 |
850051 | 850051 | 2020-12-21 | Bourbon | Kentucky | 21017 | 795 | 1 |
846806 | 846806 | 2020-12-20 | Bourbon | Kentucky | 21017 | 783 | 1 |
843560 | 843560 | 2020-12-19 | Bourbon | Kentucky | 21017 | 779 | 1 |
840315 | 840315 | 2020-12-18 | Bourbon | Kentucky | 21017 | 779 | 1 |
837070 | 837070 | 2020-12-17 | Bourbon | Kentucky | 21017 | 755 | 1 |
833824 | 833824 | 2020-12-16 | Bourbon | Kentucky | 21017 | 732 | 1 |
830577 | 830577 | 2020-12-15 | Bourbon | Kentucky | 21017 | 724 | 1 |
827331 | 827331 | 2020-12-14 | Bourbon | Kentucky | 21017 | 724 | 1 |
824084 | 824084 | 2020-12-13 | Bourbon | Kentucky | 21017 | 705 | 1 |
820838 | 820838 | 2020-12-12 | Bourbon | Kentucky | 21017 | 706 | 1 |
817592 | 817592 | 2020-12-11 | Bourbon | Kentucky | 21017 | 690 | 1 |
814346 | 814346 | 2020-12-10 | Bourbon | Kentucky | 21017 | 672 | 1 |
811101 | 811101 | 2020-12-09 | Bourbon | Kentucky | 21017 | 656 | 1 |
807856 | 807856 | 2020-12-08 | Bourbon | Kentucky | 21017 | 656 | 1 |
804611 | 804611 | 2020-12-07 | Bourbon | Kentucky | 21017 | 643 | 1 |
801366 | 801366 | 2020-12-06 | Bourbon | Kentucky | 21017 | 627 | 1 |
798121 | 798121 | 2020-12-05 | Bourbon | Kentucky | 21017 | 624 | 1 |
794876 | 794876 | 2020-12-04 | Bourbon | Kentucky | 21017 | 606 | 1 |
791631 | 791631 | 2020-12-03 | Bourbon | Kentucky | 21017 | 587 | 1 |
788386 | 788386 | 2020-12-02 | Bourbon | Kentucky | 21017 | 581 | 1 |
785142 | 785142 | 2020-12-01 | Bourbon | Kentucky | 21017 | 581 | 1 |
781897 | 781897 | 2020-11-30 | Bourbon | Kentucky | 21017 | 567 | 1 |
778651 | 778651 | 2020-11-29 | Bourbon | Kentucky | 21017 | 541 | 1 |
775406 | 775406 | 2020-11-28 | Bourbon | Kentucky | 21017 | 536 | 1 |
772161 | 772161 | 2020-11-27 | Bourbon | Kentucky | 21017 | 530 | 1 |
768916 | 768916 | 2020-11-26 | Bourbon | Kentucky | 21017 | 519 | 1 |
765670 | 765670 | 2020-11-25 | Bourbon | Kentucky | 21017 | 519 | 1 |
762425 | 762425 | 2020-11-24 | Bourbon | Kentucky | 21017 | 510 | 1 |
759180 | 759180 | 2020-11-23 | Bourbon | Kentucky | 21017 | 502 | 1 |
755933 | 755933 | 2020-11-22 | Bourbon | Kentucky | 21017 | 490 | 1 |
752687 | 752687 | 2020-11-21 | Bourbon | Kentucky | 21017 | 490 | 1 |
749441 | 749441 | 2020-11-20 | Bourbon | Kentucky | 21017 | 480 | 1 |
746195 | 746195 | 2020-11-19 | Bourbon | Kentucky | 21017 | 473 | 1 |
742948 | 742948 | 2020-11-18 | Bourbon | Kentucky | 21017 | 464 | 1 |
739701 | 739701 | 2020-11-17 | Bourbon | Kentucky | 21017 | 464 | 1 |
736457 | 736457 | 2020-11-16 | Bourbon | Kentucky | 21017 | 448 | 1 |
733211 | 733211 | 2020-11-15 | Bourbon | Kentucky | 21017 | 435 | 1 |
729966 | 729966 | 2020-11-14 | Bourbon | Kentucky | 21017 | 430 | 1 |
726723 | 726723 | 2020-11-13 | Bourbon | Kentucky | 21017 | 430 | 1 |
723480 | 723480 | 2020-11-12 | Bourbon | Kentucky | 21017 | 420 | 1 |
720237 | 720237 | 2020-11-11 | Bourbon | Kentucky | 21017 | 409 | 1 |
716994 | 716994 | 2020-11-10 | Bourbon | Kentucky | 21017 | 404 | 1 |
713750 | 713750 | 2020-11-09 | Bourbon | Kentucky | 21017 | 394 | 1 |
710506 | 710506 | 2020-11-08 | Bourbon | Kentucky | 21017 | 381 | 1 |
707262 | 707262 | 2020-11-07 | Bourbon | Kentucky | 21017 | 381 | 1 |
704019 | 704019 | 2020-11-06 | Bourbon | Kentucky | 21017 | 381 | 1 |
700777 | 700777 | 2020-11-05 | Bourbon | Kentucky | 21017 | 372 | 1 |
697533 | 697533 | 2020-11-04 | Bourbon | Kentucky | 21017 | 359 | 1 |
694290 | 694290 | 2020-11-03 | Bourbon | Kentucky | 21017 | 349 | 1 |
691048 | 691048 | 2020-11-02 | Bourbon | Kentucky | 21017 | 345 | 1 |
687803 | 687803 | 2020-11-01 | Bourbon | Kentucky | 21017 | 338 | 1 |
684559 | 684559 | 2020-10-31 | Bourbon | Kentucky | 21017 | 338 | 1 |
681316 | 681316 | 2020-10-30 | Bourbon | Kentucky | 21017 | 338 | 1 |
678072 | 678072 | 2020-10-29 | Bourbon | Kentucky | 21017 | 335 | 1 |
674830 | 674830 | 2020-10-28 | Bourbon | Kentucky | 21017 | 327 | 1 |
671587 | 671587 | 2020-10-27 | Bourbon | Kentucky | 21017 | 327 | 1 |
668345 | 668345 | 2020-10-26 | Bourbon | Kentucky | 21017 | 320 | 1 |
665101 | 665101 | 2020-10-25 | Bourbon | Kentucky | 21017 | 314 | 1 |
661856 | 661856 | 2020-10-24 | Bourbon | Kentucky | 21017 | 314 | 1 |
658612 | 658612 | 2020-10-23 | Bourbon | Kentucky | 21017 | 314 | 1 |
655367 | 655367 | 2020-10-22 | Bourbon | Kentucky | 21017 | 306 | 1 |
652122 | 652122 | 2020-10-21 | Bourbon | Kentucky | 21017 | 301 | 1 |
648877 | 648877 | 2020-10-20 | Bourbon | Kentucky | 21017 | 297 | 1 |
645633 | 645633 | 2020-10-19 | Bourbon | Kentucky | 21017 | 293 | 1 |
642386 | 642386 | 2020-10-18 | Bourbon | Kentucky | 21017 | 283 | 1 |
639139 | 639139 | 2020-10-17 | Bourbon | Kentucky | 21017 | 283 | 1 |
635893 | 635893 | 2020-10-16 | Bourbon | Kentucky | 21017 | 283 | 1 |
632647 | 632647 | 2020-10-15 | Bourbon | Kentucky | 21017 | 282 | 1 |
629403 | 629403 | 2020-10-14 | Bourbon | Kentucky | 21017 | 273 | 1 |
626159 | 626159 | 2020-10-13 | Bourbon | Kentucky | 21017 | 258 | 1 |
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);