ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Jessamine" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090264 | 1090264 | 2021-03-05 | Jessamine | Kentucky | 21113 | 4222 | 53 |
1087019 | 1087019 | 2021-03-04 | Jessamine | Kentucky | 21113 | 4214 | 53 |
1083773 | 1083773 | 2021-03-03 | Jessamine | Kentucky | 21113 | 4206 | 53 |
1080527 | 1080527 | 2021-03-02 | Jessamine | Kentucky | 21113 | 4185 | 51 |
1077282 | 1077282 | 2021-03-01 | Jessamine | Kentucky | 21113 | 4172 | 51 |
1074036 | 1074036 | 2021-02-28 | Jessamine | Kentucky | 21113 | 4161 | 51 |
1070790 | 1070790 | 2021-02-27 | Jessamine | Kentucky | 21113 | 4150 | 51 |
1067545 | 1067545 | 2021-02-26 | Jessamine | Kentucky | 21113 | 4135 | 51 |
1064300 | 1064300 | 2021-02-25 | Jessamine | Kentucky | 21113 | 4129 | 51 |
1061055 | 1061055 | 2021-02-24 | Jessamine | Kentucky | 21113 | 4101 | 51 |
1057809 | 1057809 | 2021-02-23 | Jessamine | Kentucky | 21113 | 4076 | 49 |
1054563 | 1054563 | 2021-02-22 | Jessamine | Kentucky | 21113 | 4054 | 49 |
1051316 | 1051316 | 2021-02-21 | Jessamine | Kentucky | 21113 | 4050 | 49 |
1048069 | 1048069 | 2021-02-20 | Jessamine | Kentucky | 21113 | 4032 | 49 |
1044824 | 1044824 | 2021-02-19 | Jessamine | Kentucky | 21113 | 4017 | 49 |
1041579 | 1041579 | 2021-02-18 | Jessamine | Kentucky | 21113 | 3999 | 49 |
1038334 | 1038334 | 2021-02-17 | Jessamine | Kentucky | 21113 | 3981 | 49 |
1035089 | 1035089 | 2021-02-16 | Jessamine | Kentucky | 21113 | 3975 | 49 |
1031843 | 1031843 | 2021-02-15 | Jessamine | Kentucky | 21113 | 3963 | 49 |
1028596 | 1028596 | 2021-02-14 | Jessamine | Kentucky | 21113 | 3949 | 49 |
1025351 | 1025351 | 2021-02-13 | Jessamine | Kentucky | 21113 | 3930 | 49 |
1022106 | 1022106 | 2021-02-12 | Jessamine | Kentucky | 21113 | 3920 | 49 |
1018861 | 1018861 | 2021-02-11 | Jessamine | Kentucky | 21113 | 3909 | 49 |
1015616 | 1015616 | 2021-02-10 | Jessamine | Kentucky | 21113 | 3894 | 49 |
1012371 | 1012371 | 2021-02-09 | Jessamine | Kentucky | 21113 | 3872 | 48 |
1009125 | 1009125 | 2021-02-08 | Jessamine | Kentucky | 21113 | 3859 | 48 |
1005879 | 1005879 | 2021-02-07 | Jessamine | Kentucky | 21113 | 3850 | 48 |
1002633 | 1002633 | 2021-02-06 | Jessamine | Kentucky | 21113 | 3821 | 48 |
999387 | 999387 | 2021-02-05 | Jessamine | Kentucky | 21113 | 3806 | 48 |
996141 | 996141 | 2021-02-04 | Jessamine | Kentucky | 21113 | 3782 | 48 |
992895 | 992895 | 2021-02-03 | Jessamine | Kentucky | 21113 | 3766 | 48 |
989649 | 989649 | 2021-02-02 | Jessamine | Kentucky | 21113 | 3743 | 48 |
986402 | 986402 | 2021-02-01 | Jessamine | Kentucky | 21113 | 3699 | 48 |
983155 | 983155 | 2021-01-31 | Jessamine | Kentucky | 21113 | 3655 | 48 |
979909 | 979909 | 2021-01-30 | Jessamine | Kentucky | 21113 | 3652 | 48 |
976663 | 976663 | 2021-01-29 | Jessamine | Kentucky | 21113 | 3652 | 48 |
973418 | 973418 | 2021-01-28 | Jessamine | Kentucky | 21113 | 3623 | 48 |
970173 | 970173 | 2021-01-27 | Jessamine | Kentucky | 21113 | 3564 | 48 |
966929 | 966929 | 2021-01-26 | Jessamine | Kentucky | 21113 | 3510 | 48 |
963684 | 963684 | 2021-01-25 | Jessamine | Kentucky | 21113 | 3461 | 48 |
960439 | 960439 | 2021-01-24 | Jessamine | Kentucky | 21113 | 3446 | 48 |
957193 | 957193 | 2021-01-23 | Jessamine | Kentucky | 21113 | 3400 | 48 |
953948 | 953948 | 2021-01-22 | Jessamine | Kentucky | 21113 | 3385 | 48 |
950703 | 950703 | 2021-01-21 | Jessamine | Kentucky | 21113 | 3326 | 48 |
947457 | 947457 | 2021-01-20 | Jessamine | Kentucky | 21113 | 3291 | 48 |
944210 | 944210 | 2021-01-19 | Jessamine | Kentucky | 21113 | 3248 | 48 |
940965 | 940965 | 2021-01-18 | Jessamine | Kentucky | 21113 | 3194 | 48 |
937720 | 937720 | 2021-01-17 | Jessamine | Kentucky | 21113 | 3194 | 49 |
934475 | 934475 | 2021-01-16 | Jessamine | Kentucky | 21113 | 3129 | 48 |
931230 | 931230 | 2021-01-15 | Jessamine | Kentucky | 21113 | 3129 | 48 |
927985 | 927985 | 2021-01-14 | Jessamine | Kentucky | 21113 | 3096 | 48 |
924739 | 924739 | 2021-01-13 | Jessamine | Kentucky | 21113 | 3054 | 48 |
921494 | 921494 | 2021-01-12 | Jessamine | Kentucky | 21113 | 3019 | 48 |
918249 | 918249 | 2021-01-11 | Jessamine | Kentucky | 21113 | 2965 | 48 |
915004 | 915004 | 2021-01-10 | Jessamine | Kentucky | 21113 | 2962 | 47 |
911759 | 911759 | 2021-01-09 | Jessamine | Kentucky | 21113 | 2890 | 47 |
908514 | 908514 | 2021-01-08 | Jessamine | Kentucky | 21113 | 2890 | 47 |
905268 | 905268 | 2021-01-07 | Jessamine | Kentucky | 21113 | 2834 | 47 |
902023 | 902023 | 2021-01-06 | Jessamine | Kentucky | 21113 | 2784 | 47 |
898778 | 898778 | 2021-01-05 | Jessamine | Kentucky | 21113 | 2743 | 47 |
895533 | 895533 | 2021-01-04 | Jessamine | Kentucky | 21113 | 2719 | 47 |
892286 | 892286 | 2021-01-03 | Jessamine | Kentucky | 21113 | 2699 | 47 |
889040 | 889040 | 2021-01-02 | Jessamine | Kentucky | 21113 | 2668 | 47 |
885794 | 885794 | 2021-01-01 | Jessamine | Kentucky | 21113 | 2621 | 46 |
882549 | 882549 | 2020-12-31 | Jessamine | Kentucky | 21113 | 2621 | 46 |
879304 | 879304 | 2020-12-30 | Jessamine | Kentucky | 21113 | 2598 | 46 |
876059 | 876059 | 2020-12-29 | Jessamine | Kentucky | 21113 | 2570 | 46 |
872814 | 872814 | 2020-12-28 | Jessamine | Kentucky | 21113 | 2535 | 45 |
869569 | 869569 | 2020-12-27 | Jessamine | Kentucky | 21113 | 2534 | 45 |
866324 | 866324 | 2020-12-26 | Jessamine | Kentucky | 21113 | 2524 | 44 |
863079 | 863079 | 2020-12-25 | Jessamine | Kentucky | 21113 | 2492 | 42 |
859834 | 859834 | 2020-12-24 | Jessamine | Kentucky | 21113 | 2492 | 42 |
856589 | 856589 | 2020-12-23 | Jessamine | Kentucky | 21113 | 2477 | 42 |
853344 | 853344 | 2020-12-22 | Jessamine | Kentucky | 21113 | 2461 | 42 |
850099 | 850099 | 2020-12-21 | Jessamine | Kentucky | 21113 | 2434 | 42 |
846854 | 846854 | 2020-12-20 | Jessamine | Kentucky | 21113 | 2433 | 42 |
843608 | 843608 | 2020-12-19 | Jessamine | Kentucky | 21113 | 2421 | 42 |
840363 | 840363 | 2020-12-18 | Jessamine | Kentucky | 21113 | 2403 | 41 |
837118 | 837118 | 2020-12-17 | Jessamine | Kentucky | 21113 | 2379 | 41 |
833872 | 833872 | 2020-12-16 | Jessamine | Kentucky | 21113 | 2345 | 39 |
830625 | 830625 | 2020-12-15 | Jessamine | Kentucky | 21113 | 2323 | 39 |
827379 | 827379 | 2020-12-14 | Jessamine | Kentucky | 21113 | 2296 | 39 |
824132 | 824132 | 2020-12-13 | Jessamine | Kentucky | 21113 | 2282 | 38 |
820886 | 820886 | 2020-12-12 | Jessamine | Kentucky | 21113 | 2258 | 38 |
817640 | 817640 | 2020-12-11 | Jessamine | Kentucky | 21113 | 2222 | 38 |
814394 | 814394 | 2020-12-10 | Jessamine | Kentucky | 21113 | 2179 | 38 |
811149 | 811149 | 2020-12-09 | Jessamine | Kentucky | 21113 | 2151 | 38 |
807904 | 807904 | 2020-12-08 | Jessamine | Kentucky | 21113 | 2124 | 37 |
804659 | 804659 | 2020-12-07 | Jessamine | Kentucky | 21113 | 2077 | 37 |
801414 | 801414 | 2020-12-06 | Jessamine | Kentucky | 21113 | 2050 | 36 |
798169 | 798169 | 2020-12-05 | Jessamine | Kentucky | 21113 | 2016 | 35 |
794924 | 794924 | 2020-12-04 | Jessamine | Kentucky | 21113 | 1968 | 34 |
791679 | 791679 | 2020-12-03 | Jessamine | Kentucky | 21113 | 1935 | 34 |
788434 | 788434 | 2020-12-02 | Jessamine | Kentucky | 21113 | 1906 | 31 |
785190 | 785190 | 2020-12-01 | Jessamine | Kentucky | 21113 | 1868 | 31 |
781945 | 781945 | 2020-11-30 | Jessamine | Kentucky | 21113 | 1840 | 30 |
778699 | 778699 | 2020-11-29 | Jessamine | Kentucky | 21113 | 1822 | 30 |
775454 | 775454 | 2020-11-28 | Jessamine | Kentucky | 21113 | 1783 | 30 |
772209 | 772209 | 2020-11-27 | Jessamine | Kentucky | 21113 | 1722 | 30 |
768964 | 768964 | 2020-11-26 | Jessamine | Kentucky | 21113 | 1684 | 30 |
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);