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

776 rows where county = "Washington" and fips = 37187 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

  • 37187 · 776 ✖

county 1

  • Washington · 776 ✖
Link rowid date ▲ county state fips cases deaths
2501579 2501579 2022-05-13 Washington North Carolina 37187 3056 50
2498321 2498321 2022-05-12 Washington North Carolina 37187 3056 50
2495063 2495063 2022-05-11 Washington North Carolina 37187 3056 50
2491805 2491805 2022-05-10 Washington North Carolina 37187 3054 50
2488547 2488547 2022-05-09 Washington North Carolina 37187 3054 50
2485290 2485290 2022-05-08 Washington North Carolina 37187 3054 50
2482032 2482032 2022-05-07 Washington North Carolina 37187 3054 50
2478774 2478774 2022-05-06 Washington North Carolina 37187 3054 50
2475516 2475516 2022-05-05 Washington North Carolina 37187 3054 50
2472259 2472259 2022-05-04 Washington North Carolina 37187 3054 50
2469003 2469003 2022-05-03 Washington North Carolina 37187 3041 50
2465747 2465747 2022-05-02 Washington North Carolina 37187 3041 50
2462492 2462492 2022-05-01 Washington North Carolina 37187 3041 50
2459236 2459236 2022-04-30 Washington North Carolina 37187 3041 50
2455980 2455980 2022-04-29 Washington North Carolina 37187 3041 50
2452724 2452724 2022-04-28 Washington North Carolina 37187 3041 50
2449468 2449468 2022-04-27 Washington North Carolina 37187 3041 50
2446211 2446211 2022-04-26 Washington North Carolina 37187 3016 50
2442956 2442956 2022-04-25 Washington North Carolina 37187 3016 50
2439700 2439700 2022-04-24 Washington North Carolina 37187 3016 50
2436444 2436444 2022-04-23 Washington North Carolina 37187 3016 50
2433188 2433188 2022-04-22 Washington North Carolina 37187 3016 50
2429932 2429932 2022-04-21 Washington North Carolina 37187 3016 50
2426676 2426676 2022-04-20 Washington North Carolina 37187 3016 50
2423420 2423420 2022-04-19 Washington North Carolina 37187 3016 50
2420163 2420163 2022-04-18 Washington North Carolina 37187 3016 50
2416908 2416908 2022-04-17 Washington North Carolina 37187 3016 50
2413652 2413652 2022-04-16 Washington North Carolina 37187 3016 50
2410396 2410396 2022-04-15 Washington North Carolina 37187 3016 50
2407140 2407140 2022-04-14 Washington North Carolina 37187 3016 50
2403884 2403884 2022-04-13 Washington North Carolina 37187 3016 50
2400629 2400629 2022-04-12 Washington North Carolina 37187 3015 50
2397374 2397374 2022-04-11 Washington North Carolina 37187 3015 50
2394119 2394119 2022-04-10 Washington North Carolina 37187 3015 50
2390863 2390863 2022-04-09 Washington North Carolina 37187 3015 50
2387607 2387607 2022-04-08 Washington North Carolina 37187 3015 50
2384352 2384352 2022-04-07 Washington North Carolina 37187 3015 50
2381097 2381097 2022-04-06 Washington North Carolina 37187 3015 50
2377842 2377842 2022-04-05 Washington North Carolina 37187 3015 50
2374589 2374589 2022-04-04 Washington North Carolina 37187 3013 50
2371337 2371337 2022-04-03 Washington North Carolina 37187 3012 50
2368084 2368084 2022-04-02 Washington North Carolina 37187 3012 50
2364831 2364831 2022-04-01 Washington North Carolina 37187 3012 50
2361577 2361577 2022-03-31 Washington North Carolina 37187 3012 50
2358323 2358323 2022-03-30 Washington North Carolina 37187 3012 50
2355069 2355069 2022-03-29 Washington North Carolina 37187 3010 50
2351816 2351816 2022-03-28 Washington North Carolina 37187 3010 50
2348564 2348564 2022-03-27 Washington North Carolina 37187 3010 50
2345311 2345311 2022-03-26 Washington North Carolina 37187 3010 50
2342058 2342058 2022-03-25 Washington North Carolina 37187 3010 50
2338805 2338805 2022-03-24 Washington North Carolina 37187 3009 50
2335551 2335551 2022-03-23 Washington North Carolina 37187 3009 50
2332297 2332297 2022-03-22 Washington North Carolina 37187 3009 50
2329044 2329044 2022-03-21 Washington North Carolina 37187 3007 50
2325792 2325792 2022-03-20 Washington North Carolina 37187 3007 50
2322539 2322539 2022-03-19 Washington North Carolina 37187 3007 50
2319285 2319285 2022-03-18 Washington North Carolina 37187 3007 50
2316031 2316031 2022-03-17 Washington North Carolina 37187 3006 50
2312778 2312778 2022-03-16 Washington North Carolina 37187 3006 50
2309525 2309525 2022-03-15 Washington North Carolina 37187 3004 50
2306272 2306272 2022-03-14 Washington North Carolina 37187 3004 50
2303021 2303021 2022-03-13 Washington North Carolina 37187 3004 50
2299769 2299769 2022-03-12 Washington North Carolina 37187 3004 50
2296517 2296517 2022-03-11 Washington North Carolina 37187 3004 50
2293265 2293265 2022-03-10 Washington North Carolina 37187 3002 50
2290013 2290013 2022-03-09 Washington North Carolina 37187 3000 50
2286761 2286761 2022-03-08 Washington North Carolina 37187 3000 50
2283509 2283509 2022-03-07 Washington North Carolina 37187 2999 50
2280257 2280257 2022-03-06 Washington North Carolina 37187 2996 49
2277004 2277004 2022-03-05 Washington North Carolina 37187 2996 49
2273751 2273751 2022-03-04 Washington North Carolina 37187 2996 49
2270498 2270498 2022-03-03 Washington North Carolina 37187 2983 49
2267246 2267246 2022-03-02 Washington North Carolina 37187 2962 48
2263994 2263994 2022-03-01 Washington North Carolina 37187 2959 48
2260743 2260743 2022-02-28 Washington North Carolina 37187 2959 48
2257492 2257492 2022-02-27 Washington North Carolina 37187 2957 48
2254241 2254241 2022-02-26 Washington North Carolina 37187 2957 48
2250990 2250990 2022-02-25 Washington North Carolina 37187 2957 48
2247739 2247739 2022-02-24 Washington North Carolina 37187 2956 48
2244488 2244488 2022-02-23 Washington North Carolina 37187 2956 48
2241237 2241237 2022-02-22 Washington North Carolina 37187 2953 47
2237986 2237986 2022-02-21 Washington North Carolina 37187 2953 46
2234735 2234735 2022-02-20 Washington North Carolina 37187 2946 46
2231484 2231484 2022-02-19 Washington North Carolina 37187 2946 46
2228233 2228233 2022-02-18 Washington North Carolina 37187 2946 46
2224982 2224982 2022-02-17 Washington North Carolina 37187 2942 46
2221731 2221731 2022-02-16 Washington North Carolina 37187 2932 46
2218480 2218480 2022-02-15 Washington North Carolina 37187 2927 45
2215229 2215229 2022-02-14 Washington North Carolina 37187 2927 45
2211978 2211978 2022-02-13 Washington North Carolina 37187 2901 45
2208725 2208725 2022-02-12 Washington North Carolina 37187 2901 45
2205472 2205472 2022-02-11 Washington North Carolina 37187 2901 45
2202219 2202219 2022-02-10 Washington North Carolina 37187 2899 45
2198965 2198965 2022-02-09 Washington North Carolina 37187 2879 44
2195711 2195711 2022-02-08 Washington North Carolina 37187 2862 43
2192457 2192457 2022-02-07 Washington North Carolina 37187 2863 43
2189203 2189203 2022-02-06 Washington North Carolina 37187 2829 42
2185950 2185950 2022-02-05 Washington North Carolina 37187 2829 42
2182698 2182698 2022-02-04 Washington North Carolina 37187 2829 42
2179446 2179446 2022-02-03 Washington North Carolina 37187 2822 42

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