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 |
---|---|---|---|---|---|---|---|
1090216 | 1090216 | 2021-03-05 | Bourbon | Kentucky | 21017 | 1563 | 12 |
1086971 | 1086971 | 2021-03-04 | Bourbon | Kentucky | 21017 | 1559 | 12 |
1083725 | 1083725 | 2021-03-03 | Bourbon | Kentucky | 21017 | 1555 | 12 |
1080479 | 1080479 | 2021-03-02 | Bourbon | Kentucky | 21017 | 1552 | 12 |
1077234 | 1077234 | 2021-03-01 | Bourbon | Kentucky | 21017 | 1548 | 12 |
1073988 | 1073988 | 2021-02-28 | Bourbon | Kentucky | 21017 | 1549 | 12 |
1070742 | 1070742 | 2021-02-27 | Bourbon | Kentucky | 21017 | 1546 | 12 |
1067497 | 1067497 | 2021-02-26 | Bourbon | Kentucky | 21017 | 1540 | 12 |
1064252 | 1064252 | 2021-02-25 | Bourbon | Kentucky | 21017 | 1535 | 12 |
1061007 | 1061007 | 2021-02-24 | Bourbon | Kentucky | 21017 | 1524 | 12 |
1057761 | 1057761 | 2021-02-23 | Bourbon | Kentucky | 21017 | 1520 | 12 |
1054515 | 1054515 | 2021-02-22 | Bourbon | Kentucky | 21017 | 1521 | 12 |
1051268 | 1051268 | 2021-02-21 | Bourbon | Kentucky | 21017 | 1520 | 12 |
1048021 | 1048021 | 2021-02-20 | Bourbon | Kentucky | 21017 | 1521 | 12 |
1044776 | 1044776 | 2021-02-19 | Bourbon | Kentucky | 21017 | 1515 | 12 |
1041531 | 1041531 | 2021-02-18 | Bourbon | Kentucky | 21017 | 1511 | 12 |
1038286 | 1038286 | 2021-02-17 | Bourbon | Kentucky | 21017 | 1506 | 12 |
1035041 | 1035041 | 2021-02-16 | Bourbon | Kentucky | 21017 | 1507 | 12 |
1031795 | 1031795 | 2021-02-15 | Bourbon | Kentucky | 21017 | 1504 | 12 |
1028548 | 1028548 | 2021-02-14 | Bourbon | Kentucky | 21017 | 1499 | 12 |
1025303 | 1025303 | 2021-02-13 | Bourbon | Kentucky | 21017 | 1492 | 12 |
1022058 | 1022058 | 2021-02-12 | Bourbon | Kentucky | 21017 | 1489 | 12 |
1018813 | 1018813 | 2021-02-11 | Bourbon | Kentucky | 21017 | 1488 | 12 |
1015568 | 1015568 | 2021-02-10 | Bourbon | Kentucky | 21017 | 1489 | 12 |
1012323 | 1012323 | 2021-02-09 | Bourbon | Kentucky | 21017 | 1483 | 12 |
1009077 | 1009077 | 2021-02-08 | Bourbon | Kentucky | 21017 | 1478 | 12 |
1005831 | 1005831 | 2021-02-07 | Bourbon | Kentucky | 21017 | 1465 | 12 |
1002585 | 1002585 | 2021-02-06 | Bourbon | Kentucky | 21017 | 1460 | 12 |
999339 | 999339 | 2021-02-05 | Bourbon | Kentucky | 21017 | 1454 | 12 |
996093 | 996093 | 2021-02-04 | Bourbon | Kentucky | 21017 | 1449 | 11 |
992847 | 992847 | 2021-02-03 | Bourbon | Kentucky | 21017 | 1442 | 11 |
989601 | 989601 | 2021-02-02 | Bourbon | Kentucky | 21017 | 1418 | 11 |
986354 | 986354 | 2021-02-01 | Bourbon | Kentucky | 21017 | 1407 | 11 |
983107 | 983107 | 2021-01-31 | Bourbon | Kentucky | 21017 | 1406 | 11 |
979861 | 979861 | 2021-01-30 | Bourbon | Kentucky | 21017 | 1401 | 11 |
976615 | 976615 | 2021-01-29 | Bourbon | Kentucky | 21017 | 1388 | 10 |
973370 | 973370 | 2021-01-28 | Bourbon | Kentucky | 21017 | 1376 | 9 |
970125 | 970125 | 2021-01-27 | Bourbon | Kentucky | 21017 | 1356 | 9 |
966881 | 966881 | 2021-01-26 | Bourbon | Kentucky | 21017 | 1339 | 9 |
963636 | 963636 | 2021-01-25 | Bourbon | Kentucky | 21017 | 1332 | 9 |
960391 | 960391 | 2021-01-24 | Bourbon | Kentucky | 21017 | 1324 | 9 |
957145 | 957145 | 2021-01-23 | Bourbon | Kentucky | 21017 | 1309 | 9 |
953900 | 953900 | 2021-01-22 | Bourbon | Kentucky | 21017 | 1309 | 9 |
950655 | 950655 | 2021-01-21 | Bourbon | Kentucky | 21017 | 1279 | 9 |
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 |
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);