ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,097 rows where deaths = 3 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Boyd 117
- Pike 113
- Lyon 98
- Bracken 88
- Morgan 87
- Breathitt 78
- Nicholas 77
- Christian 76
- Meade 72
- Fulton 65
- Owen 65
- Trimble 57
- Simpson 56
- Carter 53
- McCracken 50
- Garrard 47
- Martin 47
- Crittenden 46
- Henry 43
- Grant 35
- Rowan 31
- Ballard 28
- Pendleton 28
- Shelby 28
- Webster 28
- Montgomery 27
- Harlan 24
- Hickman 24
- Trigg 24
- Clay 23
- …
state 1
- Kentucky · 2,097 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1759163 | 1759163 | 2021-09-27 | Elliott | Kentucky | 21063 | 1256 | 3 |
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 |
1233181 | 1233181 | 2021-04-18 | Pendleton | Kentucky | 21191 | 1003 | 3 |
1229925 | 1229925 | 2021-04-17 | Morgan | Kentucky | 21175 | 2182 | 3 |
1229933 | 1229933 | 2021-04-17 | Pendleton | Kentucky | 21191 | 1001 | 3 |
1226677 | 1226677 | 2021-04-16 | Morgan | Kentucky | 21175 | 2176 | 3 |
1226685 | 1226685 | 2021-04-16 | Pendleton | Kentucky | 21191 | 1001 | 3 |
1223430 | 1223430 | 2021-04-15 | Morgan | Kentucky | 21175 | 2164 | 3 |
1223438 | 1223438 | 2021-04-15 | Pendleton | Kentucky | 21191 | 999 | 3 |
1220182 | 1220182 | 2021-04-14 | Morgan | Kentucky | 21175 | 2159 | 3 |
1220190 | 1220190 | 2021-04-14 | Pendleton | Kentucky | 21191 | 999 | 3 |
1216934 | 1216934 | 2021-04-13 | Morgan | Kentucky | 21175 | 2155 | 3 |
1216942 | 1216942 | 2021-04-13 | Pendleton | Kentucky | 21191 | 996 | 3 |
1213687 | 1213687 | 2021-04-12 | Morgan | Kentucky | 21175 | 2149 | 3 |
1213695 | 1213695 | 2021-04-12 | Pendleton | Kentucky | 21191 | 994 | 3 |
1210439 | 1210439 | 2021-04-11 | Morgan | Kentucky | 21175 | 2145 | 3 |
1210447 | 1210447 | 2021-04-11 | Pendleton | Kentucky | 21191 | 994 | 3 |
1207190 | 1207190 | 2021-04-10 | Morgan | Kentucky | 21175 | 2143 | 3 |
1207198 | 1207198 | 2021-04-10 | Pendleton | Kentucky | 21191 | 993 | 3 |
1203942 | 1203942 | 2021-04-09 | Morgan | Kentucky | 21175 | 2141 | 3 |
1203950 | 1203950 | 2021-04-09 | Pendleton | Kentucky | 21191 | 991 | 3 |
1200694 | 1200694 | 2021-04-08 | Morgan | Kentucky | 21175 | 2137 | 3 |
1200702 | 1200702 | 2021-04-08 | Pendleton | Kentucky | 21191 | 991 | 3 |
1197445 | 1197445 | 2021-04-07 | Morgan | Kentucky | 21175 | 2135 | 3 |
1197453 | 1197453 | 2021-04-07 | Pendleton | Kentucky | 21191 | 986 | 3 |
1194197 | 1194197 | 2021-04-06 | Morgan | Kentucky | 21175 | 2130 | 3 |
1194205 | 1194205 | 2021-04-06 | Pendleton | Kentucky | 21191 | 986 | 3 |
1190947 | 1190947 | 2021-04-05 | Morgan | Kentucky | 21175 | 2132 | 3 |
1190955 | 1190955 | 2021-04-05 | Pendleton | Kentucky | 21191 | 987 | 3 |
1187700 | 1187700 | 2021-04-04 | Morgan | Kentucky | 21175 | 2129 | 3 |
1187708 | 1187708 | 2021-04-04 | Pendleton | Kentucky | 21191 | 988 | 3 |
1184453 | 1184453 | 2021-04-03 | Morgan | Kentucky | 21175 | 2129 | 3 |
1184461 | 1184461 | 2021-04-03 | Pendleton | Kentucky | 21191 | 988 | 3 |
1181206 | 1181206 | 2021-04-02 | Morgan | Kentucky | 21175 | 2119 | 3 |
1181214 | 1181214 | 2021-04-02 | Pendleton | Kentucky | 21191 | 986 | 3 |
1177959 | 1177959 | 2021-04-01 | Morgan | Kentucky | 21175 | 2117 | 3 |
1177967 | 1177967 | 2021-04-01 | Pendleton | Kentucky | 21191 | 985 | 3 |
1174712 | 1174712 | 2021-03-31 | Morgan | Kentucky | 21175 | 2108 | 3 |
1174720 | 1174720 | 2021-03-31 | Pendleton | Kentucky | 21191 | 985 | 3 |
1171465 | 1171465 | 2021-03-30 | Morgan | Kentucky | 21175 | 2101 | 3 |
1171473 | 1171473 | 2021-03-30 | Pendleton | Kentucky | 21191 | 984 | 3 |
1168217 | 1168217 | 2021-03-29 | Morgan | Kentucky | 21175 | 2101 | 3 |
1168225 | 1168225 | 2021-03-29 | Pendleton | Kentucky | 21191 | 985 | 3 |
1164969 | 1164969 | 2021-03-28 | Morgan | Kentucky | 21175 | 2101 | 3 |
1164977 | 1164977 | 2021-03-28 | Pendleton | Kentucky | 21191 | 985 | 3 |
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);