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

777 rows where county = "Washington" 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 · 777 ✖

fips 1

county 1

  • Washington · 777 ✖
Link rowid date ▲ county state fips cases deaths
2500693 2500693 2022-05-13 Washington Kentucky 21229 3967 61
2497435 2497435 2022-05-12 Washington Kentucky 21229 3967 61
2494177 2494177 2022-05-11 Washington Kentucky 21229 3967 61
2490919 2490919 2022-05-10 Washington Kentucky 21229 3967 61
2487662 2487662 2022-05-09 Washington Kentucky 21229 3967 61
2484404 2484404 2022-05-08 Washington Kentucky 21229 3953 61
2481146 2481146 2022-05-07 Washington Kentucky 21229 3953 61
2477888 2477888 2022-05-06 Washington Kentucky 21229 3953 61
2474630 2474630 2022-05-05 Washington Kentucky 21229 3953 61
2471373 2471373 2022-05-04 Washington Kentucky 21229 3953 61
2468117 2468117 2022-05-03 Washington Kentucky 21229 3953 61
2464862 2464862 2022-05-02 Washington Kentucky 21229 3953 61
2461606 2461606 2022-05-01 Washington Kentucky 21229 3948 61
2458350 2458350 2022-04-30 Washington Kentucky 21229 3948 61
2455094 2455094 2022-04-29 Washington Kentucky 21229 3948 61
2451838 2451838 2022-04-28 Washington Kentucky 21229 3948 61
2448582 2448582 2022-04-27 Washington Kentucky 21229 3948 61
2445326 2445326 2022-04-26 Washington Kentucky 21229 3948 61
2442070 2442070 2022-04-25 Washington Kentucky 21229 3948 61
2438814 2438814 2022-04-24 Washington Kentucky 21229 3941 61
2435558 2435558 2022-04-23 Washington Kentucky 21229 3941 61
2432302 2432302 2022-04-22 Washington Kentucky 21229 3941 61
2429046 2429046 2022-04-21 Washington Kentucky 21229 3941 61
2425790 2425790 2022-04-20 Washington Kentucky 21229 3941 61
2422534 2422534 2022-04-19 Washington Kentucky 21229 3941 61
2419278 2419278 2022-04-18 Washington Kentucky 21229 3941 61
2416022 2416022 2022-04-17 Washington Kentucky 21229 3934 61
2412766 2412766 2022-04-16 Washington Kentucky 21229 3934 61
2409510 2409510 2022-04-15 Washington Kentucky 21229 3934 61
2406254 2406254 2022-04-14 Washington Kentucky 21229 3934 61
2402998 2402998 2022-04-13 Washington Kentucky 21229 3934 61
2399744 2399744 2022-04-12 Washington Kentucky 21229 3934 61
2396488 2396488 2022-04-11 Washington Kentucky 21229 3934 61
2393233 2393233 2022-04-10 Washington Kentucky 21229 3921 59
2389977 2389977 2022-04-09 Washington Kentucky 21229 3921 59
2386721 2386721 2022-04-08 Washington Kentucky 21229 3921 59
2383466 2383466 2022-04-07 Washington Kentucky 21229 3921 59
2380211 2380211 2022-04-06 Washington Kentucky 21229 3921 59
2376956 2376956 2022-04-05 Washington Kentucky 21229 3921 59
2373704 2373704 2022-04-04 Washington Kentucky 21229 3921 59
2370451 2370451 2022-04-03 Washington Kentucky 21229 3911 57
2367198 2367198 2022-04-02 Washington Kentucky 21229 3911 57
2363945 2363945 2022-04-01 Washington Kentucky 21229 3911 57
2360691 2360691 2022-03-31 Washington Kentucky 21229 3911 57
2357437 2357437 2022-03-30 Washington Kentucky 21229 3911 57
2354184 2354184 2022-03-29 Washington Kentucky 21229 3911 57
2350932 2350932 2022-03-28 Washington Kentucky 21229 3911 57
2347679 2347679 2022-03-27 Washington Kentucky 21229 3901 57
2344426 2344426 2022-03-26 Washington Kentucky 21229 3901 57
2341173 2341173 2022-03-25 Washington Kentucky 21229 3901 57
2337920 2337920 2022-03-24 Washington Kentucky 21229 3901 57
2334666 2334666 2022-03-23 Washington Kentucky 21229 3901 57
2331412 2331412 2022-03-22 Washington Kentucky 21229 3901 57
2328160 2328160 2022-03-21 Washington Kentucky 21229 3901 57
2324907 2324907 2022-03-20 Washington Kentucky 21229 3875 57
2321653 2321653 2022-03-19 Washington Kentucky 21229 3875 57
2318399 2318399 2022-03-18 Washington Kentucky 21229 3875 57
2315146 2315146 2022-03-17 Washington Kentucky 21229 3875 57
2311893 2311893 2022-03-16 Washington Kentucky 21229 3875 57
2308640 2308640 2022-03-15 Washington Kentucky 21229 3875 57
2305389 2305389 2022-03-14 Washington Kentucky 21229 3875 57
2302137 2302137 2022-03-13 Washington Kentucky 21229 3859 56
2298885 2298885 2022-03-12 Washington Kentucky 21229 3859 56
2295633 2295633 2022-03-11 Washington Kentucky 21229 3859 56
2292381 2292381 2022-03-10 Washington Kentucky 21229 3859 56
2289129 2289129 2022-03-09 Washington Kentucky 21229 3859 56
2285878 2285878 2022-03-08 Washington Kentucky 21229 3859 56
2282626 2282626 2022-03-07 Washington Kentucky 21229 3859 56
2279373 2279373 2022-03-06 Washington Kentucky 21229 3851 56
2276120 2276120 2022-03-05 Washington Kentucky 21229 3851 56
2272867 2272867 2022-03-04 Washington Kentucky 21229 3851 56
2269615 2269615 2022-03-03 Washington Kentucky 21229 3847 56
2266362 2266362 2022-03-02 Washington Kentucky 21229 3843 56
2263111 2263111 2022-03-01 Washington Kentucky 21229 3833 55
2259860 2259860 2022-02-28 Washington Kentucky 21229 3825 55
2256609 2256609 2022-02-27 Washington Kentucky 21229 3821 55
2253358 2253358 2022-02-26 Washington Kentucky 21229 3821 55
2250107 2250107 2022-02-25 Washington Kentucky 21229 3821 55
2246856 2246856 2022-02-24 Washington Kentucky 21229 3815 55
2243605 2243605 2022-02-23 Washington Kentucky 21229 3815 55
2240354 2240354 2022-02-22 Washington Kentucky 21229 3811 55
2237103 2237103 2022-02-21 Washington Kentucky 21229 3799 55
2233852 2233852 2022-02-20 Washington Kentucky 21229 3784 55
2230601 2230601 2022-02-19 Washington Kentucky 21229 3784 55
2227350 2227350 2022-02-18 Washington Kentucky 21229 3784 55
2224099 2224099 2022-02-17 Washington Kentucky 21229 3763 55
2220848 2220848 2022-02-16 Washington Kentucky 21229 3752 55
2217597 2217597 2022-02-15 Washington Kentucky 21229 3737 54
2214346 2214346 2022-02-14 Washington Kentucky 21229 3729 54
2211094 2211094 2022-02-13 Washington Kentucky 21229 3680 54
2207841 2207841 2022-02-12 Washington Kentucky 21229 3680 54
2204588 2204588 2022-02-11 Washington Kentucky 21229 3680 54
2201335 2201335 2022-02-10 Washington Kentucky 21229 3664 54
2198081 2198081 2022-02-09 Washington Kentucky 21229 3643 54
2194827 2194827 2022-02-08 Washington Kentucky 21229 3625 54
2191573 2191573 2022-02-07 Washington Kentucky 21229 3606 54
2188320 2188320 2022-02-06 Washington Kentucky 21229 3587 54
2185067 2185067 2022-02-05 Washington Kentucky 21229 3587 54
2181815 2181815 2022-02-04 Washington Kentucky 21229 3587 54
2178564 2178564 2022-02-03 Washington Kentucky 21229 3570 54

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