ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where county = "Morgan" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418217 | 1418217 | 2021-06-14 | Morgan | Kentucky | 21175 | 2315 | 4 |
1414971 | 1414971 | 2021-06-13 | Morgan | Kentucky | 21175 | 2309 | 4 |
1411726 | 1411726 | 2021-06-12 | Morgan | Kentucky | 21175 | 2309 | 3 |
1408481 | 1408481 | 2021-06-11 | Morgan | Kentucky | 21175 | 2308 | 3 |
1405235 | 1405235 | 2021-06-10 | Morgan | Kentucky | 21175 | 2307 | 3 |
1401990 | 1401990 | 2021-06-09 | Morgan | Kentucky | 21175 | 2303 | 3 |
1398745 | 1398745 | 2021-06-08 | Morgan | Kentucky | 21175 | 2303 | 3 |
1395498 | 1395498 | 2021-06-07 | Morgan | Kentucky | 21175 | 2302 | 3 |
1392253 | 1392253 | 2021-06-06 | Morgan | Kentucky | 21175 | 2302 | 3 |
1389008 | 1389008 | 2021-06-05 | Morgan | Kentucky | 21175 | 2302 | 3 |
1385763 | 1385763 | 2021-06-04 | Morgan | Kentucky | 21175 | 2302 | 3 |
1382517 | 1382517 | 2021-06-03 | Morgan | Kentucky | 21175 | 2299 | 3 |
1379272 | 1379272 | 2021-06-02 | Morgan | Kentucky | 21175 | 2293 | 3 |
1376026 | 1376026 | 2021-06-01 | Morgan | Kentucky | 21175 | 2293 | 3 |
1372781 | 1372781 | 2021-05-31 | Morgan | Kentucky | 21175 | 2291 | 3 |
1369536 | 1369536 | 2021-05-30 | Morgan | Kentucky | 21175 | 2291 | 3 |
1366290 | 1366290 | 2021-05-29 | Morgan | Kentucky | 21175 | 2291 | 3 |
1363044 | 1363044 | 2021-05-28 | Morgan | Kentucky | 21175 | 2289 | 3 |
1359797 | 1359797 | 2021-05-27 | Morgan | Kentucky | 21175 | 2289 | 3 |
1356551 | 1356551 | 2021-05-26 | Morgan | Kentucky | 21175 | 2284 | 3 |
1353305 | 1353305 | 2021-05-25 | Morgan | Kentucky | 21175 | 2283 | 3 |
1350059 | 1350059 | 2021-05-24 | Morgan | Kentucky | 21175 | 2281 | 3 |
1346812 | 1346812 | 2021-05-23 | Morgan | Kentucky | 21175 | 2281 | 3 |
1343564 | 1343564 | 2021-05-22 | Morgan | Kentucky | 21175 | 2279 | 3 |
1340316 | 1340316 | 2021-05-21 | Morgan | Kentucky | 21175 | 2278 | 3 |
1337069 | 1337069 | 2021-05-20 | Morgan | Kentucky | 21175 | 2276 | 3 |
1333822 | 1333822 | 2021-05-19 | Morgan | Kentucky | 21175 | 2276 | 3 |
1330575 | 1330575 | 2021-05-18 | Morgan | Kentucky | 21175 | 2270 | 3 |
1327328 | 1327328 | 2021-05-17 | Morgan | Kentucky | 21175 | 2269 | 3 |
1324082 | 1324082 | 2021-05-16 | Morgan | Kentucky | 21175 | 2269 | 3 |
1320836 | 1320836 | 2021-05-15 | Morgan | Kentucky | 21175 | 2269 | 3 |
1317589 | 1317589 | 2021-05-14 | Morgan | Kentucky | 21175 | 2266 | 3 |
1314342 | 1314342 | 2021-05-13 | Morgan | Kentucky | 21175 | 2261 | 3 |
1311095 | 1311095 | 2021-05-12 | Morgan | Kentucky | 21175 | 2255 | 3 |
1307849 | 1307849 | 2021-05-11 | Morgan | Kentucky | 21175 | 2255 | 3 |
1304603 | 1304603 | 2021-05-10 | Morgan | Kentucky | 21175 | 2255 | 3 |
1301356 | 1301356 | 2021-05-09 | Morgan | Kentucky | 21175 | 2255 | 3 |
1298109 | 1298109 | 2021-05-08 | Morgan | Kentucky | 21175 | 2255 | 3 |
1294863 | 1294863 | 2021-05-07 | Morgan | Kentucky | 21175 | 2251 | 3 |
1291617 | 1291617 | 2021-05-06 | Morgan | Kentucky | 21175 | 2250 | 3 |
1288371 | 1288371 | 2021-05-05 | Morgan | Kentucky | 21175 | 2249 | 3 |
1285125 | 1285125 | 2021-05-04 | Morgan | Kentucky | 21175 | 2244 | 3 |
1281878 | 1281878 | 2021-05-03 | Morgan | Kentucky | 21175 | 2244 | 3 |
1278631 | 1278631 | 2021-05-02 | Morgan | Kentucky | 21175 | 2238 | 3 |
1275384 | 1275384 | 2021-05-01 | Morgan | Kentucky | 21175 | 2238 | 3 |
1272137 | 1272137 | 2021-04-30 | Morgan | Kentucky | 21175 | 2237 | 3 |
1268890 | 1268890 | 2021-04-29 | Morgan | Kentucky | 21175 | 2237 | 3 |
1265643 | 1265643 | 2021-04-28 | Morgan | Kentucky | 21175 | 2236 | 3 |
1262396 | 1262396 | 2021-04-27 | Morgan | Kentucky | 21175 | 2228 | 3 |
1259149 | 1259149 | 2021-04-26 | Morgan | Kentucky | 21175 | 2219 | 3 |
1255902 | 1255902 | 2021-04-25 | Morgan | Kentucky | 21175 | 2218 | 3 |
1252655 | 1252655 | 2021-04-24 | Morgan | Kentucky | 21175 | 2218 | 3 |
1249408 | 1249408 | 2021-04-23 | Morgan | Kentucky | 21175 | 2218 | 3 |
1246161 | 1246161 | 2021-04-22 | Morgan | Kentucky | 21175 | 2210 | 3 |
1242914 | 1242914 | 2021-04-21 | Morgan | Kentucky | 21175 | 2208 | 3 |
1239667 | 1239667 | 2021-04-20 | Morgan | Kentucky | 21175 | 2190 | 3 |
1236420 | 1236420 | 2021-04-19 | Morgan | Kentucky | 21175 | 2186 | 3 |
1233173 | 1233173 | 2021-04-18 | Morgan | Kentucky | 21175 | 2184 | 3 |
1229925 | 1229925 | 2021-04-17 | Morgan | Kentucky | 21175 | 2182 | 3 |
1226677 | 1226677 | 2021-04-16 | Morgan | Kentucky | 21175 | 2176 | 3 |
1223430 | 1223430 | 2021-04-15 | Morgan | Kentucky | 21175 | 2164 | 3 |
1220182 | 1220182 | 2021-04-14 | Morgan | Kentucky | 21175 | 2159 | 3 |
1216934 | 1216934 | 2021-04-13 | Morgan | Kentucky | 21175 | 2155 | 3 |
1213687 | 1213687 | 2021-04-12 | Morgan | Kentucky | 21175 | 2149 | 3 |
1210439 | 1210439 | 2021-04-11 | Morgan | Kentucky | 21175 | 2145 | 3 |
1207190 | 1207190 | 2021-04-10 | Morgan | Kentucky | 21175 | 2143 | 3 |
1203942 | 1203942 | 2021-04-09 | Morgan | Kentucky | 21175 | 2141 | 3 |
1200694 | 1200694 | 2021-04-08 | Morgan | Kentucky | 21175 | 2137 | 3 |
1197445 | 1197445 | 2021-04-07 | Morgan | Kentucky | 21175 | 2135 | 3 |
1194197 | 1194197 | 2021-04-06 | Morgan | Kentucky | 21175 | 2130 | 3 |
1190947 | 1190947 | 2021-04-05 | Morgan | Kentucky | 21175 | 2132 | 3 |
1187700 | 1187700 | 2021-04-04 | Morgan | Kentucky | 21175 | 2129 | 3 |
1184453 | 1184453 | 2021-04-03 | Morgan | Kentucky | 21175 | 2129 | 3 |
1181206 | 1181206 | 2021-04-02 | Morgan | Kentucky | 21175 | 2119 | 3 |
1177959 | 1177959 | 2021-04-01 | Morgan | Kentucky | 21175 | 2117 | 3 |
1174712 | 1174712 | 2021-03-31 | Morgan | Kentucky | 21175 | 2108 | 3 |
1171465 | 1171465 | 2021-03-30 | Morgan | Kentucky | 21175 | 2101 | 3 |
1168217 | 1168217 | 2021-03-29 | Morgan | Kentucky | 21175 | 2101 | 3 |
1164969 | 1164969 | 2021-03-28 | Morgan | Kentucky | 21175 | 2101 | 3 |
1161721 | 1161721 | 2021-03-27 | Morgan | Kentucky | 21175 | 2101 | 3 |
1158473 | 1158473 | 2021-03-26 | Morgan | Kentucky | 21175 | 2094 | 3 |
1155226 | 1155226 | 2021-03-25 | Morgan | Kentucky | 21175 | 2094 | 3 |
1151979 | 1151979 | 2021-03-24 | Morgan | Kentucky | 21175 | 2090 | 3 |
1148732 | 1148732 | 2021-03-23 | Morgan | Kentucky | 21175 | 2081 | 3 |
1145485 | 1145485 | 2021-03-22 | Morgan | Kentucky | 21175 | 2077 | 3 |
1142238 | 1142238 | 2021-03-21 | Morgan | Kentucky | 21175 | 2077 | 3 |
1138992 | 1138992 | 2021-03-20 | Morgan | Kentucky | 21175 | 2076 | 3 |
1135746 | 1135746 | 2021-03-19 | Morgan | Kentucky | 21175 | 2075 | 3 |
1132499 | 1132499 | 2021-03-18 | Morgan | Kentucky | 21175 | 2072 | 3 |
1129251 | 1129251 | 2021-03-17 | Morgan | Kentucky | 21175 | 2066 | 1 |
1126005 | 1126005 | 2021-03-16 | Morgan | Kentucky | 21175 | 2064 | 1 |
1122759 | 1122759 | 2021-03-15 | Morgan | Kentucky | 21175 | 2061 | 1 |
1119512 | 1119512 | 2021-03-14 | Morgan | Kentucky | 21175 | 2061 | 1 |
1116265 | 1116265 | 2021-03-13 | Morgan | Kentucky | 21175 | 2061 | 1 |
1113019 | 1113019 | 2021-03-12 | Morgan | Kentucky | 21175 | 2053 | 1 |
1109773 | 1109773 | 2021-03-11 | Morgan | Kentucky | 21175 | 2050 | 1 |
1106527 | 1106527 | 2021-03-10 | Morgan | Kentucky | 21175 | 2045 | 1 |
1103281 | 1103281 | 2021-03-09 | Morgan | Kentucky | 21175 | 2042 | 1 |
1100035 | 1100035 | 2021-03-08 | Morgan | Kentucky | 21175 | 2042 | 1 |
1096787 | 1096787 | 2021-03-07 | Morgan | Kentucky | 21175 | 2041 | 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);