ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

922 rows where deaths = 28 and state = "Kentucky" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

state 1

  • Kentucky · 922 ✖
Link rowid date ▲ county state fips cases deaths
2500666 2500666 2022-05-13 Morgan Kentucky 21175 5272 28
2500697 2500697 2022-05-13 Wolfe Kentucky 21237 2531 28
2497408 2497408 2022-05-12 Morgan Kentucky 21175 5272 28
2497439 2497439 2022-05-12 Wolfe Kentucky 21237 2531 28
2494150 2494150 2022-05-11 Morgan Kentucky 21175 5272 28
2494181 2494181 2022-05-11 Wolfe Kentucky 21237 2531 28
2490892 2490892 2022-05-10 Morgan Kentucky 21175 5272 28
2490923 2490923 2022-05-10 Wolfe Kentucky 21237 2531 28
2487635 2487635 2022-05-09 Morgan Kentucky 21175 5272 28
2487666 2487666 2022-05-09 Wolfe Kentucky 21237 2531 28
2484293 2484293 2022-05-08 Ballard Kentucky 21007 1384 28
2481035 2481035 2022-05-07 Ballard Kentucky 21007 1384 28
2477777 2477777 2022-05-06 Ballard Kentucky 21007 1384 28
2474519 2474519 2022-05-05 Ballard Kentucky 21007 1384 28
2471262 2471262 2022-05-04 Ballard Kentucky 21007 1384 28
2468006 2468006 2022-05-03 Ballard Kentucky 21007 1384 28
2464751 2464751 2022-05-02 Ballard Kentucky 21007 1384 28
2461495 2461495 2022-05-01 Ballard Kentucky 21007 1379 28
2458239 2458239 2022-04-30 Ballard Kentucky 21007 1379 28
2454983 2454983 2022-04-29 Ballard Kentucky 21007 1379 28
2451727 2451727 2022-04-28 Ballard Kentucky 21007 1379 28
2448471 2448471 2022-04-27 Ballard Kentucky 21007 1379 28
2445215 2445215 2022-04-26 Ballard Kentucky 21007 1379 28
2441959 2441959 2022-04-25 Ballard Kentucky 21007 1379 28
2438703 2438703 2022-04-24 Ballard Kentucky 21007 1373 28
2438737 2438737 2022-04-24 Fulton Kentucky 21075 1211 28
2435447 2435447 2022-04-23 Ballard Kentucky 21007 1373 28
2435481 2435481 2022-04-23 Fulton Kentucky 21075 1211 28
2432191 2432191 2022-04-22 Ballard Kentucky 21007 1373 28
2432225 2432225 2022-04-22 Fulton Kentucky 21075 1211 28
2428935 2428935 2022-04-21 Ballard Kentucky 21007 1373 28
2428969 2428969 2022-04-21 Fulton Kentucky 21075 1211 28
2425679 2425679 2022-04-20 Ballard Kentucky 21007 1373 28
2425713 2425713 2022-04-20 Fulton Kentucky 21075 1211 28
2422423 2422423 2022-04-19 Ballard Kentucky 21007 1373 28
2422457 2422457 2022-04-19 Fulton Kentucky 21075 1211 28
2419167 2419167 2022-04-18 Ballard Kentucky 21007 1373 28
2419201 2419201 2022-04-18 Fulton Kentucky 21075 1211 28
2415911 2415911 2022-04-17 Ballard Kentucky 21007 1349 28
2415945 2415945 2022-04-17 Fulton Kentucky 21075 1207 28
2412655 2412655 2022-04-16 Ballard Kentucky 21007 1349 28
2412689 2412689 2022-04-16 Fulton Kentucky 21075 1207 28
2409399 2409399 2022-04-15 Ballard Kentucky 21007 1349 28
2409433 2409433 2022-04-15 Fulton Kentucky 21075 1207 28
2406143 2406143 2022-04-14 Ballard Kentucky 21007 1349 28
2406177 2406177 2022-04-14 Fulton Kentucky 21075 1207 28
2402887 2402887 2022-04-13 Ballard Kentucky 21007 1349 28
2402921 2402921 2022-04-13 Fulton Kentucky 21075 1207 28
2399633 2399633 2022-04-12 Ballard Kentucky 21007 1349 28
2399667 2399667 2022-04-12 Fulton Kentucky 21075 1207 28
2396377 2396377 2022-04-11 Ballard Kentucky 21007 1349 28
2396411 2396411 2022-04-11 Fulton Kentucky 21075 1207 28
2393122 2393122 2022-04-10 Ballard Kentucky 21007 1333 28
2393156 2393156 2022-04-10 Fulton Kentucky 21075 1205 28
2389866 2389866 2022-04-09 Ballard Kentucky 21007 1333 28
2389900 2389900 2022-04-09 Fulton Kentucky 21075 1205 28
2386610 2386610 2022-04-08 Ballard Kentucky 21007 1333 28
2386644 2386644 2022-04-08 Fulton Kentucky 21075 1205 28
2383355 2383355 2022-04-07 Ballard Kentucky 21007 1333 28
2383389 2383389 2022-04-07 Fulton Kentucky 21075 1205 28
2380100 2380100 2022-04-06 Ballard Kentucky 21007 1333 28
2380134 2380134 2022-04-06 Fulton Kentucky 21075 1205 28
2376845 2376845 2022-04-05 Ballard Kentucky 21007 1333 28
2376879 2376879 2022-04-05 Fulton Kentucky 21075 1205 28
2373593 2373593 2022-04-04 Ballard Kentucky 21007 1333 28
2373627 2373627 2022-04-04 Fulton Kentucky 21075 1205 28
2370340 2370340 2022-04-03 Ballard Kentucky 21007 1308 28
2370374 2370374 2022-04-03 Fulton Kentucky 21075 1167 28
2367087 2367087 2022-04-02 Ballard Kentucky 21007 1308 28
2367121 2367121 2022-04-02 Fulton Kentucky 21075 1167 28
2363834 2363834 2022-04-01 Ballard Kentucky 21007 1308 28
2363868 2363868 2022-04-01 Fulton Kentucky 21075 1167 28
2360580 2360580 2022-03-31 Ballard Kentucky 21007 1308 28
2360614 2360614 2022-03-31 Fulton Kentucky 21075 1167 28
2357326 2357326 2022-03-30 Ballard Kentucky 21007 1308 28
2357360 2357360 2022-03-30 Fulton Kentucky 21075 1167 28
2354073 2354073 2022-03-29 Ballard Kentucky 21007 1308 28
2354107 2354107 2022-03-29 Fulton Kentucky 21075 1167 28
2350821 2350821 2022-03-28 Ballard Kentucky 21007 1308 28
2350855 2350855 2022-03-28 Fulton Kentucky 21075 1167 28
2347568 2347568 2022-03-27 Ballard Kentucky 21007 1287 28
2344315 2344315 2022-03-26 Ballard Kentucky 21007 1287 28
2341062 2341062 2022-03-25 Ballard Kentucky 21007 1287 28
2337809 2337809 2022-03-24 Ballard Kentucky 21007 1287 28
2334555 2334555 2022-03-23 Ballard Kentucky 21007 1287 28
2331301 2331301 2022-03-22 Ballard Kentucky 21007 1287 28
2328049 2328049 2022-03-21 Ballard Kentucky 21007 1287 28
2324796 2324796 2022-03-20 Ballard Kentucky 21007 1266 28
2324821 2324821 2022-03-20 Cumberland Kentucky 21057 2169 28
2321542 2321542 2022-03-19 Ballard Kentucky 21007 1266 28
2321567 2321567 2022-03-19 Cumberland Kentucky 21057 2169 28
2318288 2318288 2022-03-18 Ballard Kentucky 21007 1266 28
2318313 2318313 2022-03-18 Cumberland Kentucky 21057 2169 28
2315035 2315035 2022-03-17 Ballard Kentucky 21007 1266 28
2315060 2315060 2022-03-17 Cumberland Kentucky 21057 2169 28
2311782 2311782 2022-03-16 Ballard Kentucky 21007 1266 28
2311807 2311807 2022-03-16 Cumberland Kentucky 21057 2169 28
2308529 2308529 2022-03-15 Ballard Kentucky 21007 1266 28
2308554 2308554 2022-03-15 Cumberland Kentucky 21057 2169 28
2305278 2305278 2022-03-14 Ballard Kentucky 21007 1266 28

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);