ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Hardin" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1489583 | 1489583 | 2021-07-06 | Hardin | Kentucky | 21093 | 10020 | 170 |
1486336 | 1486336 | 2021-07-05 | Hardin | Kentucky | 21093 | 10017 | 170 |
1483090 | 1483090 | 2021-07-04 | Hardin | Kentucky | 21093 | 10017 | 170 |
1479843 | 1479843 | 2021-07-03 | Hardin | Kentucky | 21093 | 10017 | 170 |
1476597 | 1476597 | 2021-07-02 | Hardin | Kentucky | 21093 | 10017 | 170 |
1473351 | 1473351 | 2021-07-01 | Hardin | Kentucky | 21093 | 10011 | 170 |
1470105 | 1470105 | 2021-06-30 | Hardin | Kentucky | 21093 | 10004 | 170 |
1466860 | 1466860 | 2021-06-29 | Hardin | Kentucky | 21093 | 9995 | 170 |
1463615 | 1463615 | 2021-06-28 | Hardin | Kentucky | 21093 | 9985 | 170 |
1460370 | 1460370 | 2021-06-27 | Hardin | Kentucky | 21093 | 9979 | 170 |
1457125 | 1457125 | 2021-06-26 | Hardin | Kentucky | 21093 | 9979 | 170 |
1453880 | 1453880 | 2021-06-25 | Hardin | Kentucky | 21093 | 9979 | 170 |
1450634 | 1450634 | 2021-06-24 | Hardin | Kentucky | 21093 | 9975 | 168 |
1447389 | 1447389 | 2021-06-23 | Hardin | Kentucky | 21093 | 9972 | 167 |
1444144 | 1444144 | 2021-06-22 | Hardin | Kentucky | 21093 | 9967 | 167 |
1440899 | 1440899 | 2021-06-21 | Hardin | Kentucky | 21093 | 9957 | 167 |
1437652 | 1437652 | 2021-06-20 | Hardin | Kentucky | 21093 | 9941 | 167 |
1434405 | 1434405 | 2021-06-19 | Hardin | Kentucky | 21093 | 9941 | 167 |
1431159 | 1431159 | 2021-06-18 | Hardin | Kentucky | 21093 | 9941 | 167 |
1427914 | 1427914 | 2021-06-17 | Hardin | Kentucky | 21093 | 9937 | 167 |
1424669 | 1424669 | 2021-06-16 | Hardin | Kentucky | 21093 | 9932 | 167 |
1421421 | 1421421 | 2021-06-15 | Hardin | Kentucky | 21093 | 9926 | 167 |
1418176 | 1418176 | 2021-06-14 | Hardin | Kentucky | 21093 | 9924 | 167 |
1414930 | 1414930 | 2021-06-13 | Hardin | Kentucky | 21093 | 9922 | 167 |
1411685 | 1411685 | 2021-06-12 | Hardin | Kentucky | 21093 | 9920 | 167 |
1408440 | 1408440 | 2021-06-11 | Hardin | Kentucky | 21093 | 9917 | 167 |
1405194 | 1405194 | 2021-06-10 | Hardin | Kentucky | 21093 | 9907 | 167 |
1401949 | 1401949 | 2021-06-09 | Hardin | Kentucky | 21093 | 9899 | 167 |
1398704 | 1398704 | 2021-06-08 | Hardin | Kentucky | 21093 | 9891 | 167 |
1395457 | 1395457 | 2021-06-07 | Hardin | Kentucky | 21093 | 9883 | 167 |
1392212 | 1392212 | 2021-06-06 | Hardin | Kentucky | 21093 | 9884 | 167 |
1388967 | 1388967 | 2021-06-05 | Hardin | Kentucky | 21093 | 9884 | 167 |
1385722 | 1385722 | 2021-06-04 | Hardin | Kentucky | 21093 | 9875 | 167 |
1382476 | 1382476 | 2021-06-03 | Hardin | Kentucky | 21093 | 9869 | 167 |
1379231 | 1379231 | 2021-06-02 | Hardin | Kentucky | 21093 | 9857 | 167 |
1375985 | 1375985 | 2021-06-01 | Hardin | Kentucky | 21093 | 9845 | 167 |
1372740 | 1372740 | 2021-05-31 | Hardin | Kentucky | 21093 | 9838 | 160 |
1369495 | 1369495 | 2021-05-30 | Hardin | Kentucky | 21093 | 9838 | 160 |
1366249 | 1366249 | 2021-05-29 | Hardin | Kentucky | 21093 | 9838 | 160 |
1363003 | 1363003 | 2021-05-28 | Hardin | Kentucky | 21093 | 9831 | 158 |
1359756 | 1359756 | 2021-05-27 | Hardin | Kentucky | 21093 | 9824 | 157 |
1356510 | 1356510 | 2021-05-26 | Hardin | Kentucky | 21093 | 9821 | 157 |
1353264 | 1353264 | 2021-05-25 | Hardin | Kentucky | 21093 | 9815 | 157 |
1350018 | 1350018 | 2021-05-24 | Hardin | Kentucky | 21093 | 9807 | 157 |
1346771 | 1346771 | 2021-05-23 | Hardin | Kentucky | 21093 | 9806 | 157 |
1343523 | 1343523 | 2021-05-22 | Hardin | Kentucky | 21093 | 9806 | 157 |
1340275 | 1340275 | 2021-05-21 | Hardin | Kentucky | 21093 | 9798 | 157 |
1337028 | 1337028 | 2021-05-20 | Hardin | Kentucky | 21093 | 9788 | 157 |
1333781 | 1333781 | 2021-05-19 | Hardin | Kentucky | 21093 | 9783 | 157 |
1330534 | 1330534 | 2021-05-18 | Hardin | Kentucky | 21093 | 9772 | 157 |
1327287 | 1327287 | 2021-05-17 | Hardin | Kentucky | 21093 | 9751 | 157 |
1324041 | 1324041 | 2021-05-16 | Hardin | Kentucky | 21093 | 9751 | 157 |
1320795 | 1320795 | 2021-05-15 | Hardin | Kentucky | 21093 | 9749 | 157 |
1317548 | 1317548 | 2021-05-14 | Hardin | Kentucky | 21093 | 9740 | 157 |
1314301 | 1314301 | 2021-05-13 | Hardin | Kentucky | 21093 | 9726 | 157 |
1311054 | 1311054 | 2021-05-12 | Hardin | Kentucky | 21093 | 9707 | 157 |
1307808 | 1307808 | 2021-05-11 | Hardin | Kentucky | 21093 | 9696 | 156 |
1304562 | 1304562 | 2021-05-10 | Hardin | Kentucky | 21093 | 9685 | 156 |
1301315 | 1301315 | 2021-05-09 | Hardin | Kentucky | 21093 | 9684 | 156 |
1298068 | 1298068 | 2021-05-08 | Hardin | Kentucky | 21093 | 9680 | 154 |
1294822 | 1294822 | 2021-05-07 | Hardin | Kentucky | 21093 | 9674 | 154 |
1291576 | 1291576 | 2021-05-06 | Hardin | Kentucky | 21093 | 9660 | 154 |
1288330 | 1288330 | 2021-05-05 | Hardin | Kentucky | 21093 | 9650 | 154 |
1285084 | 1285084 | 2021-05-04 | Hardin | Kentucky | 21093 | 9640 | 154 |
1281837 | 1281837 | 2021-05-03 | Hardin | Kentucky | 21093 | 9623 | 154 |
1278590 | 1278590 | 2021-05-02 | Hardin | Kentucky | 21093 | 9623 | 154 |
1275343 | 1275343 | 2021-05-01 | Hardin | Kentucky | 21093 | 9618 | 154 |
1272096 | 1272096 | 2021-04-30 | Hardin | Kentucky | 21093 | 9601 | 154 |
1268849 | 1268849 | 2021-04-29 | Hardin | Kentucky | 21093 | 9585 | 154 |
1265602 | 1265602 | 2021-04-28 | Hardin | Kentucky | 21093 | 9565 | 154 |
1262355 | 1262355 | 2021-04-27 | Hardin | Kentucky | 21093 | 9537 | 154 |
1259108 | 1259108 | 2021-04-26 | Hardin | Kentucky | 21093 | 9517 | 154 |
1255861 | 1255861 | 2021-04-25 | Hardin | Kentucky | 21093 | 9512 | 154 |
1252614 | 1252614 | 2021-04-24 | Hardin | Kentucky | 21093 | 9512 | 153 |
1249367 | 1249367 | 2021-04-23 | Hardin | Kentucky | 21093 | 9503 | 153 |
1246120 | 1246120 | 2021-04-22 | Hardin | Kentucky | 21093 | 9494 | 151 |
1242873 | 1242873 | 2021-04-21 | Hardin | Kentucky | 21093 | 9488 | 151 |
1239626 | 1239626 | 2021-04-20 | Hardin | Kentucky | 21093 | 9472 | 151 |
1236379 | 1236379 | 2021-04-19 | Hardin | Kentucky | 21093 | 9452 | 150 |
1233132 | 1233132 | 2021-04-18 | Hardin | Kentucky | 21093 | 9450 | 149 |
1229884 | 1229884 | 2021-04-17 | Hardin | Kentucky | 21093 | 9449 | 149 |
1226636 | 1226636 | 2021-04-16 | Hardin | Kentucky | 21093 | 9445 | 149 |
1223389 | 1223389 | 2021-04-15 | Hardin | Kentucky | 21093 | 9432 | 149 |
1220141 | 1220141 | 2021-04-14 | Hardin | Kentucky | 21093 | 9419 | 149 |
1216893 | 1216893 | 2021-04-13 | Hardin | Kentucky | 21093 | 9394 | 147 |
1213646 | 1213646 | 2021-04-12 | Hardin | Kentucky | 21093 | 9386 | 147 |
1210398 | 1210398 | 2021-04-11 | Hardin | Kentucky | 21093 | 9383 | 147 |
1207149 | 1207149 | 2021-04-10 | Hardin | Kentucky | 21093 | 9382 | 147 |
1203901 | 1203901 | 2021-04-09 | Hardin | Kentucky | 21093 | 9375 | 147 |
1200653 | 1200653 | 2021-04-08 | Hardin | Kentucky | 21093 | 9365 | 147 |
1197404 | 1197404 | 2021-04-07 | Hardin | Kentucky | 21093 | 9354 | 147 |
1194156 | 1194156 | 2021-04-06 | Hardin | Kentucky | 21093 | 9324 | 147 |
1190906 | 1190906 | 2021-04-05 | Hardin | Kentucky | 21093 | 9320 | 147 |
1187659 | 1187659 | 2021-04-04 | Hardin | Kentucky | 21093 | 9311 | 146 |
1184412 | 1184412 | 2021-04-03 | Hardin | Kentucky | 21093 | 9311 | 146 |
1181165 | 1181165 | 2021-04-02 | Hardin | Kentucky | 21093 | 9309 | 144 |
1177918 | 1177918 | 2021-04-01 | Hardin | Kentucky | 21093 | 9295 | 143 |
1174671 | 1174671 | 2021-03-31 | Hardin | Kentucky | 21093 | 9277 | 143 |
1171424 | 1171424 | 2021-03-30 | Hardin | Kentucky | 21093 | 9264 | 138 |
1168176 | 1168176 | 2021-03-29 | Hardin | Kentucky | 21093 | 9247 | 137 |
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);