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

782 rows where county = "Douglas" and fips = 53017 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 53017 · 782 ✖

county 1

  • Douglas · 782 ✖
Link rowid date ▲ county state fips cases deaths
2502651 2502651 2022-05-13 Douglas Washington 53017 11269 70
2499393 2499393 2022-05-12 Douglas Washington 53017 11246 70
2496135 2496135 2022-05-11 Douglas Washington 53017 11246 70
2492877 2492877 2022-05-10 Douglas Washington 53017 11211 70
2489619 2489619 2022-05-09 Douglas Washington 53017 11209 70
2486362 2486362 2022-05-08 Douglas Washington 53017 11185 70
2483104 2483104 2022-05-07 Douglas Washington 53017 11185 70
2479846 2479846 2022-05-06 Douglas Washington 53017 11185 70
2476588 2476588 2022-05-05 Douglas Washington 53017 11170 70
2473330 2473330 2022-05-04 Douglas Washington 53017 11170 70
2470074 2470074 2022-05-03 Douglas Washington 53017 11209 70
2466818 2466818 2022-05-02 Douglas Washington 53017 11209 70
2463563 2463563 2022-05-01 Douglas Washington 53017 11131 70
2460307 2460307 2022-04-30 Douglas Washington 53017 11131 70
2457051 2457051 2022-04-29 Douglas Washington 53017 11131 70
2453795 2453795 2022-04-28 Douglas Washington 53017 11122 69
2450539 2450539 2022-04-27 Douglas Washington 53017 11121 69
2447283 2447283 2022-04-26 Douglas Washington 53017 11103 69
2444027 2444027 2022-04-25 Douglas Washington 53017 11103 69
2440771 2440771 2022-04-24 Douglas Washington 53017 11093 69
2437515 2437515 2022-04-23 Douglas Washington 53017 11093 69
2434259 2434259 2022-04-22 Douglas Washington 53017 11093 69
2431003 2431003 2022-04-21 Douglas Washington 53017 11087 69
2427747 2427747 2022-04-20 Douglas Washington 53017 11087 69
2424491 2424491 2022-04-19 Douglas Washington 53017 11075 69
2421235 2421235 2022-04-18 Douglas Washington 53017 11075 69
2417979 2417979 2022-04-17 Douglas Washington 53017 11072 69
2414723 2414723 2022-04-16 Douglas Washington 53017 11072 69
2411467 2411467 2022-04-15 Douglas Washington 53017 11072 69
2408211 2408211 2022-04-14 Douglas Washington 53017 11071 69
2404955 2404955 2022-04-13 Douglas Washington 53017 11065 69
2401700 2401700 2022-04-12 Douglas Washington 53017 11059 69
2398445 2398445 2022-04-11 Douglas Washington 53017 11059 69
2395190 2395190 2022-04-10 Douglas Washington 53017 11059 69
2391934 2391934 2022-04-09 Douglas Washington 53017 11059 69
2388678 2388678 2022-04-08 Douglas Washington 53017 11059 69
2385423 2385423 2022-04-07 Douglas Washington 53017 11059 69
2382168 2382168 2022-04-06 Douglas Washington 53017 11055 69
2378913 2378913 2022-04-05 Douglas Washington 53017 11049 69
2375659 2375659 2022-04-04 Douglas Washington 53017 11049 69
2372407 2372407 2022-04-03 Douglas Washington 53017 11042 69
2369154 2369154 2022-04-02 Douglas Washington 53017 11042 69
2365901 2365901 2022-04-01 Douglas Washington 53017 11042 69
2362648 2362648 2022-03-31 Douglas Washington 53017 11042 69
2359394 2359394 2022-03-30 Douglas Washington 53017 11036 69
2356140 2356140 2022-03-29 Douglas Washington 53017 11036 69
2352887 2352887 2022-03-28 Douglas Washington 53017 11033 69
2349635 2349635 2022-03-27 Douglas Washington 53017 11028 69
2346382 2346382 2022-03-26 Douglas Washington 53017 11028 69
2343129 2343129 2022-03-25 Douglas Washington 53017 11028 69
2339876 2339876 2022-03-24 Douglas Washington 53017 11025 69
2336623 2336623 2022-03-23 Douglas Washington 53017 11025 69
2333369 2333369 2022-03-22 Douglas Washington 53017 11024 69
2330115 2330115 2022-03-21 Douglas Washington 53017 11022 69
2326863 2326863 2022-03-20 Douglas Washington 53017 11018 69
2323610 2323610 2022-03-19 Douglas Washington 53017 11018 69
2320356 2320356 2022-03-18 Douglas Washington 53017 11018 69
2317102 2317102 2022-03-17 Douglas Washington 53017 11014 68
2313849 2313849 2022-03-16 Douglas Washington 53017 11008 68
2310596 2310596 2022-03-15 Douglas Washington 53017 11000 67
2307343 2307343 2022-03-14 Douglas Washington 53017 11000 67
2304092 2304092 2022-03-13 Douglas Washington 53017 10987 67
2300840 2300840 2022-03-12 Douglas Washington 53017 10987 67
2297588 2297588 2022-03-11 Douglas Washington 53017 10987 67
2294336 2294336 2022-03-10 Douglas Washington 53017 10987 66
2291084 2291084 2022-03-09 Douglas Washington 53017 10975 66
2287832 2287832 2022-03-08 Douglas Washington 53017 10963 66
2284580 2284580 2022-03-07 Douglas Washington 53017 10963 66
2281328 2281328 2022-03-06 Douglas Washington 53017 10953 65
2278075 2278075 2022-03-05 Douglas Washington 53017 10953 65
2274822 2274822 2022-03-04 Douglas Washington 53017 10953 65
2271569 2271569 2022-03-03 Douglas Washington 53017 10942 65
2268317 2268317 2022-03-02 Douglas Washington 53017 10923 65
2265064 2265064 2022-03-01 Douglas Washington 53017 10907 65
2261814 2261814 2022-02-28 Douglas Washington 53017 10886 65
2258563 2258563 2022-02-27 Douglas Washington 53017 10867 65
2255312 2255312 2022-02-26 Douglas Washington 53017 10867 65
2252061 2252061 2022-02-25 Douglas Washington 53017 10867 65
2248810 2248810 2022-02-24 Douglas Washington 53017 10811 65
2245559 2245559 2022-02-23 Douglas Washington 53017 10811 65
2242308 2242308 2022-02-22 Douglas Washington 53017 10750 65
2239057 2239057 2022-02-21 Douglas Washington 53017 10750 65
2235806 2235806 2022-02-20 Douglas Washington 53017 10750 65
2232555 2232555 2022-02-19 Douglas Washington 53017 10750 65
2229304 2229304 2022-02-18 Douglas Washington 53017 10750 65
2226053 2226053 2022-02-17 Douglas Washington 53017 10722 62
2222802 2222802 2022-02-16 Douglas Washington 53017 10722 62
2219551 2219551 2022-02-15 Douglas Washington 53017 10704 61
2216301 2216301 2022-02-14 Douglas Washington 53017 10704 61
2213050 2213050 2022-02-13 Douglas Washington 53017 10670 61
2209797 2209797 2022-02-12 Douglas Washington 53017 10670 61
2206544 2206544 2022-02-11 Douglas Washington 53017 10670 61
2203291 2203291 2022-02-10 Douglas Washington 53017 10533 59
2200037 2200037 2022-02-09 Douglas Washington 53017 10533 59
2196783 2196783 2022-02-08 Douglas Washington 53017 10416 59
2193528 2193528 2022-02-07 Douglas Washington 53017 10416 59
2190275 2190275 2022-02-06 Douglas Washington 53017 10320 58
2187022 2187022 2022-02-05 Douglas Washington 53017 10320 58
2183769 2183769 2022-02-04 Douglas Washington 53017 10320 58
2180517 2180517 2022-02-03 Douglas Washington 53017 10154 56

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