ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Leslie" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418195 | 1418195 | 2021-06-14 | Leslie | Kentucky | 21131 | 941 | 8 |
1414949 | 1414949 | 2021-06-13 | Leslie | Kentucky | 21131 | 941 | 8 |
1411704 | 1411704 | 2021-06-12 | Leslie | Kentucky | 21131 | 941 | 8 |
1408459 | 1408459 | 2021-06-11 | Leslie | Kentucky | 21131 | 941 | 8 |
1405213 | 1405213 | 2021-06-10 | Leslie | Kentucky | 21131 | 941 | 8 |
1401968 | 1401968 | 2021-06-09 | Leslie | Kentucky | 21131 | 941 | 8 |
1398723 | 1398723 | 2021-06-08 | Leslie | Kentucky | 21131 | 940 | 8 |
1395476 | 1395476 | 2021-06-07 | Leslie | Kentucky | 21131 | 939 | 8 |
1392231 | 1392231 | 2021-06-06 | Leslie | Kentucky | 21131 | 939 | 8 |
1388986 | 1388986 | 2021-06-05 | Leslie | Kentucky | 21131 | 939 | 8 |
1385741 | 1385741 | 2021-06-04 | Leslie | Kentucky | 21131 | 939 | 8 |
1382495 | 1382495 | 2021-06-03 | Leslie | Kentucky | 21131 | 938 | 8 |
1379250 | 1379250 | 2021-06-02 | Leslie | Kentucky | 21131 | 938 | 8 |
1376004 | 1376004 | 2021-06-01 | Leslie | Kentucky | 21131 | 937 | 8 |
1372759 | 1372759 | 2021-05-31 | Leslie | Kentucky | 21131 | 931 | 8 |
1369514 | 1369514 | 2021-05-30 | Leslie | Kentucky | 21131 | 931 | 8 |
1366268 | 1366268 | 2021-05-29 | Leslie | Kentucky | 21131 | 931 | 8 |
1363022 | 1363022 | 2021-05-28 | Leslie | Kentucky | 21131 | 930 | 8 |
1359775 | 1359775 | 2021-05-27 | Leslie | Kentucky | 21131 | 928 | 8 |
1356529 | 1356529 | 2021-05-26 | Leslie | Kentucky | 21131 | 928 | 8 |
1353283 | 1353283 | 2021-05-25 | Leslie | Kentucky | 21131 | 926 | 8 |
1350037 | 1350037 | 2021-05-24 | Leslie | Kentucky | 21131 | 924 | 8 |
1346790 | 1346790 | 2021-05-23 | Leslie | Kentucky | 21131 | 924 | 8 |
1343542 | 1343542 | 2021-05-22 | Leslie | Kentucky | 21131 | 922 | 8 |
1340294 | 1340294 | 2021-05-21 | Leslie | Kentucky | 21131 | 922 | 8 |
1337047 | 1337047 | 2021-05-20 | Leslie | Kentucky | 21131 | 921 | 8 |
1333800 | 1333800 | 2021-05-19 | Leslie | Kentucky | 21131 | 920 | 8 |
1330553 | 1330553 | 2021-05-18 | Leslie | Kentucky | 21131 | 920 | 8 |
1327306 | 1327306 | 2021-05-17 | Leslie | Kentucky | 21131 | 920 | 8 |
1324060 | 1324060 | 2021-05-16 | Leslie | Kentucky | 21131 | 919 | 8 |
1320814 | 1320814 | 2021-05-15 | Leslie | Kentucky | 21131 | 919 | 8 |
1317567 | 1317567 | 2021-05-14 | Leslie | Kentucky | 21131 | 918 | 8 |
1314320 | 1314320 | 2021-05-13 | Leslie | Kentucky | 21131 | 918 | 8 |
1311073 | 1311073 | 2021-05-12 | Leslie | Kentucky | 21131 | 916 | 8 |
1307827 | 1307827 | 2021-05-11 | Leslie | Kentucky | 21131 | 914 | 8 |
1304581 | 1304581 | 2021-05-10 | Leslie | Kentucky | 21131 | 911 | 8 |
1301334 | 1301334 | 2021-05-09 | Leslie | Kentucky | 21131 | 911 | 8 |
1298087 | 1298087 | 2021-05-08 | Leslie | Kentucky | 21131 | 910 | 8 |
1294841 | 1294841 | 2021-05-07 | Leslie | Kentucky | 21131 | 910 | 8 |
1291595 | 1291595 | 2021-05-06 | Leslie | Kentucky | 21131 | 910 | 8 |
1288349 | 1288349 | 2021-05-05 | Leslie | Kentucky | 21131 | 910 | 8 |
1285103 | 1285103 | 2021-05-04 | Leslie | Kentucky | 21131 | 909 | 8 |
1281856 | 1281856 | 2021-05-03 | Leslie | Kentucky | 21131 | 909 | 7 |
1278609 | 1278609 | 2021-05-02 | Leslie | Kentucky | 21131 | 909 | 7 |
1275362 | 1275362 | 2021-05-01 | Leslie | Kentucky | 21131 | 909 | 7 |
1272115 | 1272115 | 2021-04-30 | Leslie | Kentucky | 21131 | 908 | 7 |
1268868 | 1268868 | 2021-04-29 | Leslie | Kentucky | 21131 | 907 | 7 |
1265621 | 1265621 | 2021-04-28 | Leslie | Kentucky | 21131 | 905 | 7 |
1262374 | 1262374 | 2021-04-27 | Leslie | Kentucky | 21131 | 904 | 7 |
1259127 | 1259127 | 2021-04-26 | Leslie | Kentucky | 21131 | 897 | 7 |
1255880 | 1255880 | 2021-04-25 | Leslie | Kentucky | 21131 | 897 | 7 |
1252633 | 1252633 | 2021-04-24 | Leslie | Kentucky | 21131 | 897 | 7 |
1249386 | 1249386 | 2021-04-23 | Leslie | Kentucky | 21131 | 897 | 7 |
1246139 | 1246139 | 2021-04-22 | Leslie | Kentucky | 21131 | 896 | 7 |
1242892 | 1242892 | 2021-04-21 | Leslie | Kentucky | 21131 | 895 | 7 |
1239645 | 1239645 | 2021-04-20 | Leslie | Kentucky | 21131 | 894 | 6 |
1236398 | 1236398 | 2021-04-19 | Leslie | Kentucky | 21131 | 891 | 6 |
1233151 | 1233151 | 2021-04-18 | Leslie | Kentucky | 21131 | 891 | 6 |
1229903 | 1229903 | 2021-04-17 | Leslie | Kentucky | 21131 | 889 | 6 |
1226655 | 1226655 | 2021-04-16 | Leslie | Kentucky | 21131 | 887 | 6 |
1223408 | 1223408 | 2021-04-15 | Leslie | Kentucky | 21131 | 885 | 6 |
1220160 | 1220160 | 2021-04-14 | Leslie | Kentucky | 21131 | 884 | 6 |
1216912 | 1216912 | 2021-04-13 | Leslie | Kentucky | 21131 | 880 | 6 |
1213665 | 1213665 | 2021-04-12 | Leslie | Kentucky | 21131 | 876 | 6 |
1210417 | 1210417 | 2021-04-11 | Leslie | Kentucky | 21131 | 876 | 6 |
1207168 | 1207168 | 2021-04-10 | Leslie | Kentucky | 21131 | 876 | 6 |
1203920 | 1203920 | 2021-04-09 | Leslie | Kentucky | 21131 | 875 | 6 |
1200672 | 1200672 | 2021-04-08 | Leslie | Kentucky | 21131 | 873 | 6 |
1197423 | 1197423 | 2021-04-07 | Leslie | Kentucky | 21131 | 871 | 6 |
1194175 | 1194175 | 2021-04-06 | Leslie | Kentucky | 21131 | 869 | 6 |
1190925 | 1190925 | 2021-04-05 | Leslie | Kentucky | 21131 | 869 | 6 |
1187678 | 1187678 | 2021-04-04 | Leslie | Kentucky | 21131 | 868 | 6 |
1184431 | 1184431 | 2021-04-03 | Leslie | Kentucky | 21131 | 868 | 6 |
1181184 | 1181184 | 2021-04-02 | Leslie | Kentucky | 21131 | 868 | 6 |
1177937 | 1177937 | 2021-04-01 | Leslie | Kentucky | 21131 | 866 | 6 |
1174690 | 1174690 | 2021-03-31 | Leslie | Kentucky | 21131 | 863 | 6 |
1171443 | 1171443 | 2021-03-30 | Leslie | Kentucky | 21131 | 860 | 6 |
1168195 | 1168195 | 2021-03-29 | Leslie | Kentucky | 21131 | 859 | 6 |
1164947 | 1164947 | 2021-03-28 | Leslie | Kentucky | 21131 | 859 | 6 |
1161699 | 1161699 | 2021-03-27 | Leslie | Kentucky | 21131 | 858 | 6 |
1158451 | 1158451 | 2021-03-26 | Leslie | Kentucky | 21131 | 854 | 6 |
1155204 | 1155204 | 2021-03-25 | Leslie | Kentucky | 21131 | 854 | 6 |
1151957 | 1151957 | 2021-03-24 | Leslie | Kentucky | 21131 | 852 | 5 |
1148710 | 1148710 | 2021-03-23 | Leslie | Kentucky | 21131 | 850 | 5 |
1145463 | 1145463 | 2021-03-22 | Leslie | Kentucky | 21131 | 851 | 5 |
1142216 | 1142216 | 2021-03-21 | Leslie | Kentucky | 21131 | 851 | 5 |
1138970 | 1138970 | 2021-03-20 | Leslie | Kentucky | 21131 | 851 | 5 |
1135724 | 1135724 | 2021-03-19 | Leslie | Kentucky | 21131 | 850 | 5 |
1132477 | 1132477 | 2021-03-18 | Leslie | Kentucky | 21131 | 837 | 5 |
1129229 | 1129229 | 2021-03-17 | Leslie | Kentucky | 21131 | 832 | 3 |
1125983 | 1125983 | 2021-03-16 | Leslie | Kentucky | 21131 | 832 | 3 |
1122737 | 1122737 | 2021-03-15 | Leslie | Kentucky | 21131 | 831 | 3 |
1119490 | 1119490 | 2021-03-14 | Leslie | Kentucky | 21131 | 830 | 3 |
1116243 | 1116243 | 2021-03-13 | Leslie | Kentucky | 21131 | 824 | 3 |
1112997 | 1112997 | 2021-03-12 | Leslie | Kentucky | 21131 | 823 | 3 |
1109751 | 1109751 | 2021-03-11 | Leslie | Kentucky | 21131 | 823 | 2 |
1106505 | 1106505 | 2021-03-10 | Leslie | Kentucky | 21131 | 821 | 2 |
1103259 | 1103259 | 2021-03-09 | Leslie | Kentucky | 21131 | 821 | 2 |
1100013 | 1100013 | 2021-03-08 | Leslie | Kentucky | 21131 | 817 | 2 |
1096765 | 1096765 | 2021-03-07 | Leslie | Kentucky | 21131 | 817 | 2 |
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);