ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Madison" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418202 | 1418202 | 2021-06-14 | Madison | Kentucky | 21151 | 9523 | 111 |
1414956 | 1414956 | 2021-06-13 | Madison | Kentucky | 21151 | 9522 | 111 |
1411711 | 1411711 | 2021-06-12 | Madison | Kentucky | 21151 | 9522 | 111 |
1408466 | 1408466 | 2021-06-11 | Madison | Kentucky | 21151 | 9519 | 111 |
1405220 | 1405220 | 2021-06-10 | Madison | Kentucky | 21151 | 9516 | 111 |
1401975 | 1401975 | 2021-06-09 | Madison | Kentucky | 21151 | 9505 | 111 |
1398730 | 1398730 | 2021-06-08 | Madison | Kentucky | 21151 | 9497 | 111 |
1395483 | 1395483 | 2021-06-07 | Madison | Kentucky | 21151 | 9475 | 111 |
1392238 | 1392238 | 2021-06-06 | Madison | Kentucky | 21151 | 9475 | 111 |
1388993 | 1388993 | 2021-06-05 | Madison | Kentucky | 21151 | 9475 | 111 |
1385748 | 1385748 | 2021-06-04 | Madison | Kentucky | 21151 | 9469 | 111 |
1382502 | 1382502 | 2021-06-03 | Madison | Kentucky | 21151 | 9461 | 111 |
1379257 | 1379257 | 2021-06-02 | Madison | Kentucky | 21151 | 9457 | 111 |
1376011 | 1376011 | 2021-06-01 | Madison | Kentucky | 21151 | 9445 | 111 |
1372766 | 1372766 | 2021-05-31 | Madison | Kentucky | 21151 | 9434 | 111 |
1369521 | 1369521 | 2021-05-30 | Madison | Kentucky | 21151 | 9434 | 111 |
1366275 | 1366275 | 2021-05-29 | Madison | Kentucky | 21151 | 9434 | 111 |
1363029 | 1363029 | 2021-05-28 | Madison | Kentucky | 21151 | 9433 | 111 |
1359782 | 1359782 | 2021-05-27 | Madison | Kentucky | 21151 | 9424 | 111 |
1356536 | 1356536 | 2021-05-26 | Madison | Kentucky | 21151 | 9414 | 111 |
1353290 | 1353290 | 2021-05-25 | Madison | Kentucky | 21151 | 9407 | 111 |
1350044 | 1350044 | 2021-05-24 | Madison | Kentucky | 21151 | 9401 | 111 |
1346797 | 1346797 | 2021-05-23 | Madison | Kentucky | 21151 | 9400 | 111 |
1343549 | 1343549 | 2021-05-22 | Madison | Kentucky | 21151 | 9400 | 111 |
1340301 | 1340301 | 2021-05-21 | Madison | Kentucky | 21151 | 9398 | 111 |
1337054 | 1337054 | 2021-05-20 | Madison | Kentucky | 21151 | 9393 | 111 |
1333807 | 1333807 | 2021-05-19 | Madison | Kentucky | 21151 | 9386 | 111 |
1330560 | 1330560 | 2021-05-18 | Madison | Kentucky | 21151 | 9377 | 110 |
1327313 | 1327313 | 2021-05-17 | Madison | Kentucky | 21151 | 9363 | 109 |
1324067 | 1324067 | 2021-05-16 | Madison | Kentucky | 21151 | 9361 | 109 |
1320821 | 1320821 | 2021-05-15 | Madison | Kentucky | 21151 | 9359 | 109 |
1317574 | 1317574 | 2021-05-14 | Madison | Kentucky | 21151 | 9352 | 109 |
1314327 | 1314327 | 2021-05-13 | Madison | Kentucky | 21151 | 9349 | 109 |
1311080 | 1311080 | 2021-05-12 | Madison | Kentucky | 21151 | 9347 | 109 |
1307834 | 1307834 | 2021-05-11 | Madison | Kentucky | 21151 | 9339 | 109 |
1304588 | 1304588 | 2021-05-10 | Madison | Kentucky | 21151 | 9330 | 109 |
1301341 | 1301341 | 2021-05-09 | Madison | Kentucky | 21151 | 9326 | 109 |
1298094 | 1298094 | 2021-05-08 | Madison | Kentucky | 21151 | 9321 | 109 |
1294848 | 1294848 | 2021-05-07 | Madison | Kentucky | 21151 | 9319 | 109 |
1291602 | 1291602 | 2021-05-06 | Madison | Kentucky | 21151 | 9314 | 109 |
1288356 | 1288356 | 2021-05-05 | Madison | Kentucky | 21151 | 9299 | 109 |
1285110 | 1285110 | 2021-05-04 | Madison | Kentucky | 21151 | 9288 | 109 |
1281863 | 1281863 | 2021-05-03 | Madison | Kentucky | 21151 | 9269 | 109 |
1278616 | 1278616 | 2021-05-02 | Madison | Kentucky | 21151 | 9269 | 109 |
1275369 | 1275369 | 2021-05-01 | Madison | Kentucky | 21151 | 9262 | 109 |
1272122 | 1272122 | 2021-04-30 | Madison | Kentucky | 21151 | 9258 | 109 |
1268875 | 1268875 | 2021-04-29 | Madison | Kentucky | 21151 | 9249 | 109 |
1265628 | 1265628 | 2021-04-28 | Madison | Kentucky | 21151 | 9234 | 109 |
1262381 | 1262381 | 2021-04-27 | Madison | Kentucky | 21151 | 9230 | 109 |
1259134 | 1259134 | 2021-04-26 | Madison | Kentucky | 21151 | 9209 | 109 |
1255887 | 1255887 | 2021-04-25 | Madison | Kentucky | 21151 | 9206 | 109 |
1252640 | 1252640 | 2021-04-24 | Madison | Kentucky | 21151 | 9200 | 109 |
1249393 | 1249393 | 2021-04-23 | Madison | Kentucky | 21151 | 9195 | 109 |
1246146 | 1246146 | 2021-04-22 | Madison | Kentucky | 21151 | 9184 | 109 |
1242899 | 1242899 | 2021-04-21 | Madison | Kentucky | 21151 | 9176 | 109 |
1239652 | 1239652 | 2021-04-20 | Madison | Kentucky | 21151 | 9162 | 109 |
1236405 | 1236405 | 2021-04-19 | Madison | Kentucky | 21151 | 9148 | 109 |
1233158 | 1233158 | 2021-04-18 | Madison | Kentucky | 21151 | 9146 | 109 |
1229910 | 1229910 | 2021-04-17 | Madison | Kentucky | 21151 | 9140 | 109 |
1226662 | 1226662 | 2021-04-16 | Madison | Kentucky | 21151 | 9138 | 109 |
1223415 | 1223415 | 2021-04-15 | Madison | Kentucky | 21151 | 9128 | 109 |
1220167 | 1220167 | 2021-04-14 | Madison | Kentucky | 21151 | 9119 | 108 |
1216919 | 1216919 | 2021-04-13 | Madison | Kentucky | 21151 | 9108 | 108 |
1213672 | 1213672 | 2021-04-12 | Madison | Kentucky | 21151 | 9094 | 108 |
1210424 | 1210424 | 2021-04-11 | Madison | Kentucky | 21151 | 9086 | 108 |
1207175 | 1207175 | 2021-04-10 | Madison | Kentucky | 21151 | 9082 | 108 |
1203927 | 1203927 | 2021-04-09 | Madison | Kentucky | 21151 | 9083 | 108 |
1200679 | 1200679 | 2021-04-08 | Madison | Kentucky | 21151 | 9075 | 108 |
1197430 | 1197430 | 2021-04-07 | Madison | Kentucky | 21151 | 9065 | 108 |
1194182 | 1194182 | 2021-04-06 | Madison | Kentucky | 21151 | 9045 | 108 |
1190932 | 1190932 | 2021-04-05 | Madison | Kentucky | 21151 | 9045 | 108 |
1187685 | 1187685 | 2021-04-04 | Madison | Kentucky | 21151 | 9036 | 108 |
1184438 | 1184438 | 2021-04-03 | Madison | Kentucky | 21151 | 9036 | 108 |
1181191 | 1181191 | 2021-04-02 | Madison | Kentucky | 21151 | 9029 | 108 |
1177944 | 1177944 | 2021-04-01 | Madison | Kentucky | 21151 | 9021 | 107 |
1174697 | 1174697 | 2021-03-31 | Madison | Kentucky | 21151 | 9003 | 107 |
1171450 | 1171450 | 2021-03-30 | Madison | Kentucky | 21151 | 8994 | 107 |
1168202 | 1168202 | 2021-03-29 | Madison | Kentucky | 21151 | 8984 | 107 |
1164954 | 1164954 | 2021-03-28 | Madison | Kentucky | 21151 | 8975 | 107 |
1161706 | 1161706 | 2021-03-27 | Madison | Kentucky | 21151 | 8966 | 107 |
1158458 | 1158458 | 2021-03-26 | Madison | Kentucky | 21151 | 8958 | 107 |
1155211 | 1155211 | 2021-03-25 | Madison | Kentucky | 21151 | 8939 | 106 |
1151964 | 1151964 | 2021-03-24 | Madison | Kentucky | 21151 | 8932 | 105 |
1148717 | 1148717 | 2021-03-23 | Madison | Kentucky | 21151 | 8926 | 103 |
1145470 | 1145470 | 2021-03-22 | Madison | Kentucky | 21151 | 8902 | 103 |
1142223 | 1142223 | 2021-03-21 | Madison | Kentucky | 21151 | 8891 | 103 |
1138977 | 1138977 | 2021-03-20 | Madison | Kentucky | 21151 | 8884 | 103 |
1135731 | 1135731 | 2021-03-19 | Madison | Kentucky | 21151 | 8882 | 103 |
1132484 | 1132484 | 2021-03-18 | Madison | Kentucky | 21151 | 8873 | 99 |
1129236 | 1129236 | 2021-03-17 | Madison | Kentucky | 21151 | 8851 | 90 |
1125990 | 1125990 | 2021-03-16 | Madison | Kentucky | 21151 | 8843 | 90 |
1122744 | 1122744 | 2021-03-15 | Madison | Kentucky | 21151 | 8831 | 90 |
1119497 | 1119497 | 2021-03-14 | Madison | Kentucky | 21151 | 8822 | 90 |
1116250 | 1116250 | 2021-03-13 | Madison | Kentucky | 21151 | 8820 | 90 |
1113004 | 1113004 | 2021-03-12 | Madison | Kentucky | 21151 | 8808 | 90 |
1109758 | 1109758 | 2021-03-11 | Madison | Kentucky | 21151 | 8799 | 90 |
1106512 | 1106512 | 2021-03-10 | Madison | Kentucky | 21151 | 8784 | 90 |
1103266 | 1103266 | 2021-03-09 | Madison | Kentucky | 21151 | 8771 | 90 |
1100020 | 1100020 | 2021-03-08 | Madison | Kentucky | 21151 | 8746 | 90 |
1096772 | 1096772 | 2021-03-07 | Madison | Kentucky | 21151 | 8745 | 90 |
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);