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

746 rows where county = "Owen" and state = "Kentucky" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Kentucky · 746 ✖

fips 1

county 1

  • Owen · 746 ✖
Link rowid date ▲ county state fips cases deaths
2500672 2500672 2022-05-13 Owen Kentucky 21187 2370 34
2497414 2497414 2022-05-12 Owen Kentucky 21187 2370 34
2494156 2494156 2022-05-11 Owen Kentucky 21187 2370 34
2490898 2490898 2022-05-10 Owen Kentucky 21187 2370 34
2487641 2487641 2022-05-09 Owen Kentucky 21187 2370 34
2484383 2484383 2022-05-08 Owen Kentucky 21187 2369 34
2481125 2481125 2022-05-07 Owen Kentucky 21187 2369 34
2477867 2477867 2022-05-06 Owen Kentucky 21187 2369 34
2474609 2474609 2022-05-05 Owen Kentucky 21187 2369 34
2471352 2471352 2022-05-04 Owen Kentucky 21187 2369 34
2468096 2468096 2022-05-03 Owen Kentucky 21187 2369 34
2464841 2464841 2022-05-02 Owen Kentucky 21187 2369 34
2461585 2461585 2022-05-01 Owen Kentucky 21187 2366 33
2458329 2458329 2022-04-30 Owen Kentucky 21187 2366 33
2455073 2455073 2022-04-29 Owen Kentucky 21187 2366 33
2451817 2451817 2022-04-28 Owen Kentucky 21187 2366 33
2448561 2448561 2022-04-27 Owen Kentucky 21187 2366 33
2445305 2445305 2022-04-26 Owen Kentucky 21187 2366 33
2442049 2442049 2022-04-25 Owen Kentucky 21187 2366 33
2438793 2438793 2022-04-24 Owen Kentucky 21187 2366 33
2435537 2435537 2022-04-23 Owen Kentucky 21187 2366 33
2432281 2432281 2022-04-22 Owen Kentucky 21187 2366 33
2429025 2429025 2022-04-21 Owen Kentucky 21187 2366 33
2425769 2425769 2022-04-20 Owen Kentucky 21187 2366 33
2422513 2422513 2022-04-19 Owen Kentucky 21187 2366 33
2419257 2419257 2022-04-18 Owen Kentucky 21187 2366 33
2416001 2416001 2022-04-17 Owen Kentucky 21187 2363 33
2412745 2412745 2022-04-16 Owen Kentucky 21187 2363 33
2409489 2409489 2022-04-15 Owen Kentucky 21187 2363 33
2406233 2406233 2022-04-14 Owen Kentucky 21187 2363 33
2402977 2402977 2022-04-13 Owen Kentucky 21187 2363 33
2399723 2399723 2022-04-12 Owen Kentucky 21187 2363 33
2396467 2396467 2022-04-11 Owen Kentucky 21187 2363 33
2393212 2393212 2022-04-10 Owen Kentucky 21187 2360 33
2389956 2389956 2022-04-09 Owen Kentucky 21187 2360 33
2386700 2386700 2022-04-08 Owen Kentucky 21187 2360 33
2383445 2383445 2022-04-07 Owen Kentucky 21187 2360 33
2380190 2380190 2022-04-06 Owen Kentucky 21187 2360 33
2376935 2376935 2022-04-05 Owen Kentucky 21187 2360 33
2373683 2373683 2022-04-04 Owen Kentucky 21187 2360 33
2370430 2370430 2022-04-03 Owen Kentucky 21187 2359 33
2367177 2367177 2022-04-02 Owen Kentucky 21187 2359 33
2363924 2363924 2022-04-01 Owen Kentucky 21187 2359 33
2360670 2360670 2022-03-31 Owen Kentucky 21187 2359 33
2357416 2357416 2022-03-30 Owen Kentucky 21187 2359 33
2354163 2354163 2022-03-29 Owen Kentucky 21187 2359 33
2350911 2350911 2022-03-28 Owen Kentucky 21187 2359 33
2347658 2347658 2022-03-27 Owen Kentucky 21187 2359 32
2344405 2344405 2022-03-26 Owen Kentucky 21187 2359 32
2341152 2341152 2022-03-25 Owen Kentucky 21187 2359 32
2337899 2337899 2022-03-24 Owen Kentucky 21187 2359 32
2334645 2334645 2022-03-23 Owen Kentucky 21187 2359 32
2331391 2331391 2022-03-22 Owen Kentucky 21187 2359 32
2328139 2328139 2022-03-21 Owen Kentucky 21187 2359 32
2324886 2324886 2022-03-20 Owen Kentucky 21187 2353 32
2321632 2321632 2022-03-19 Owen Kentucky 21187 2353 32
2318378 2318378 2022-03-18 Owen Kentucky 21187 2353 32
2315125 2315125 2022-03-17 Owen Kentucky 21187 2353 32
2311872 2311872 2022-03-16 Owen Kentucky 21187 2353 32
2308619 2308619 2022-03-15 Owen Kentucky 21187 2353 32
2305368 2305368 2022-03-14 Owen Kentucky 21187 2353 32
2302116 2302116 2022-03-13 Owen Kentucky 21187 2352 32
2298864 2298864 2022-03-12 Owen Kentucky 21187 2352 32
2295612 2295612 2022-03-11 Owen Kentucky 21187 2352 32
2292360 2292360 2022-03-10 Owen Kentucky 21187 2352 32
2289108 2289108 2022-03-09 Owen Kentucky 21187 2352 32
2285857 2285857 2022-03-08 Owen Kentucky 21187 2352 32
2282605 2282605 2022-03-07 Owen Kentucky 21187 2352 32
2279352 2279352 2022-03-06 Owen Kentucky 21187 2350 32
2276099 2276099 2022-03-05 Owen Kentucky 21187 2350 32
2272846 2272846 2022-03-04 Owen Kentucky 21187 2350 32
2269594 2269594 2022-03-03 Owen Kentucky 21187 2351 32
2266341 2266341 2022-03-02 Owen Kentucky 21187 2348 32
2263090 2263090 2022-03-01 Owen Kentucky 21187 2347 32
2259839 2259839 2022-02-28 Owen Kentucky 21187 2344 32
2256588 2256588 2022-02-27 Owen Kentucky 21187 2341 32
2253337 2253337 2022-02-26 Owen Kentucky 21187 2341 32
2250086 2250086 2022-02-25 Owen Kentucky 21187 2341 32
2246835 2246835 2022-02-24 Owen Kentucky 21187 2335 32
2243584 2243584 2022-02-23 Owen Kentucky 21187 2335 32
2240333 2240333 2022-02-22 Owen Kentucky 21187 2330 32
2237082 2237082 2022-02-21 Owen Kentucky 21187 2330 32
2233831 2233831 2022-02-20 Owen Kentucky 21187 2327 32
2230580 2230580 2022-02-19 Owen Kentucky 21187 2327 32
2227329 2227329 2022-02-18 Owen Kentucky 21187 2327 32
2224078 2224078 2022-02-17 Owen Kentucky 21187 2322 32
2220827 2220827 2022-02-16 Owen Kentucky 21187 2319 32
2217576 2217576 2022-02-15 Owen Kentucky 21187 2316 32
2214325 2214325 2022-02-14 Owen Kentucky 21187 2312 32
2211073 2211073 2022-02-13 Owen Kentucky 21187 2289 32
2207820 2207820 2022-02-12 Owen Kentucky 21187 2289 32
2204567 2204567 2022-02-11 Owen Kentucky 21187 2289 32
2201314 2201314 2022-02-10 Owen Kentucky 21187 2286 32
2198060 2198060 2022-02-09 Owen Kentucky 21187 2281 32
2194806 2194806 2022-02-08 Owen Kentucky 21187 2273 32
2191552 2191552 2022-02-07 Owen Kentucky 21187 2265 30
2188299 2188299 2022-02-06 Owen Kentucky 21187 2261 30
2185046 2185046 2022-02-05 Owen Kentucky 21187 2261 30
2181794 2181794 2022-02-04 Owen Kentucky 21187 2261 30
2178543 2178543 2022-02-03 Owen Kentucky 21187 2256 30

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