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

801 rows where fips = 53007 and state = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Washington · 801 ✖

fips 1

  • 53007 · 801 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502646 2502646 2022-05-13 Chelan Washington 53007 20463 162
2499388 2499388 2022-05-12 Chelan Washington 53007 20426 162
2496130 2496130 2022-05-11 Chelan Washington 53007 20426 162
2492872 2492872 2022-05-10 Chelan Washington 53007 20369 162
2489614 2489614 2022-05-09 Chelan Washington 53007 20367 162
2486357 2486357 2022-05-08 Chelan Washington 53007 20321 162
2483099 2483099 2022-05-07 Chelan Washington 53007 20321 162
2479841 2479841 2022-05-06 Chelan Washington 53007 20321 162
2476583 2476583 2022-05-05 Chelan Washington 53007 20310 162
2473325 2473325 2022-05-04 Chelan Washington 53007 20308 162
2470069 2470069 2022-05-03 Chelan Washington 53007 20277 162
2466813 2466813 2022-05-02 Chelan Washington 53007 20276 162
2463558 2463558 2022-05-01 Chelan Washington 53007 20247 162
2460302 2460302 2022-04-30 Chelan Washington 53007 20247 162
2457046 2457046 2022-04-29 Chelan Washington 53007 20247 162
2453790 2453790 2022-04-28 Chelan Washington 53007 20224 162
2450534 2450534 2022-04-27 Chelan Washington 53007 20222 162
2447278 2447278 2022-04-26 Chelan Washington 53007 20195 162
2444022 2444022 2022-04-25 Chelan Washington 53007 20195 162
2440766 2440766 2022-04-24 Chelan Washington 53007 20175 162
2437510 2437510 2022-04-23 Chelan Washington 53007 20175 162
2434254 2434254 2022-04-22 Chelan Washington 53007 20175 162
2430998 2430998 2022-04-21 Chelan Washington 53007 20154 162
2427742 2427742 2022-04-20 Chelan Washington 53007 20154 162
2424486 2424486 2022-04-19 Chelan Washington 53007 20149 162
2421230 2421230 2022-04-18 Chelan Washington 53007 20149 162
2417974 2417974 2022-04-17 Chelan Washington 53007 20131 162
2414718 2414718 2022-04-16 Chelan Washington 53007 20131 162
2411462 2411462 2022-04-15 Chelan Washington 53007 20131 162
2408206 2408206 2022-04-14 Chelan Washington 53007 20131 162
2404950 2404950 2022-04-13 Chelan Washington 53007 20119 162
2401695 2401695 2022-04-12 Chelan Washington 53007 20091 162
2398440 2398440 2022-04-11 Chelan Washington 53007 20091 162
2395185 2395185 2022-04-10 Chelan Washington 53007 20091 162
2391929 2391929 2022-04-09 Chelan Washington 53007 20091 162
2388673 2388673 2022-04-08 Chelan Washington 53007 20091 162
2385418 2385418 2022-04-07 Chelan Washington 53007 20086 162
2382163 2382163 2022-04-06 Chelan Washington 53007 20073 162
2378908 2378908 2022-04-05 Chelan Washington 53007 20067 161
2375654 2375654 2022-04-04 Chelan Washington 53007 20067 161
2372402 2372402 2022-04-03 Chelan Washington 53007 20058 161
2369149 2369149 2022-04-02 Chelan Washington 53007 20058 161
2365896 2365896 2022-04-01 Chelan Washington 53007 20058 161
2362643 2362643 2022-03-31 Chelan Washington 53007 20047 161
2359389 2359389 2022-03-30 Chelan Washington 53007 20042 161
2356135 2356135 2022-03-29 Chelan Washington 53007 20039 161
2352882 2352882 2022-03-28 Chelan Washington 53007 20036 161
2349630 2349630 2022-03-27 Chelan Washington 53007 20025 161
2346377 2346377 2022-03-26 Chelan Washington 53007 20025 161
2343124 2343124 2022-03-25 Chelan Washington 53007 20025 161
2339871 2339871 2022-03-24 Chelan Washington 53007 20014 160
2336618 2336618 2022-03-23 Chelan Washington 53007 20014 160
2333364 2333364 2022-03-22 Chelan Washington 53007 20004 158
2330110 2330110 2022-03-21 Chelan Washington 53007 20000 158
2326858 2326858 2022-03-20 Chelan Washington 53007 19983 158
2323605 2323605 2022-03-19 Chelan Washington 53007 19983 158
2320351 2320351 2022-03-18 Chelan Washington 53007 19983 158
2317097 2317097 2022-03-17 Chelan Washington 53007 19978 157
2313844 2313844 2022-03-16 Chelan Washington 53007 19968 157
2310591 2310591 2022-03-15 Chelan Washington 53007 19947 157
2307338 2307338 2022-03-14 Chelan Washington 53007 19947 157
2304087 2304087 2022-03-13 Chelan Washington 53007 19931 157
2300835 2300835 2022-03-12 Chelan Washington 53007 19931 157
2297583 2297583 2022-03-11 Chelan Washington 53007 19931 157
2294331 2294331 2022-03-10 Chelan Washington 53007 19928 157
2291079 2291079 2022-03-09 Chelan Washington 53007 19912 157
2287827 2287827 2022-03-08 Chelan Washington 53007 19886 156
2284575 2284575 2022-03-07 Chelan Washington 53007 19886 156
2281323 2281323 2022-03-06 Chelan Washington 53007 19864 156
2278070 2278070 2022-03-05 Chelan Washington 53007 19864 156
2274817 2274817 2022-03-04 Chelan Washington 53007 19864 156
2271564 2271564 2022-03-03 Chelan Washington 53007 19844 154
2268312 2268312 2022-03-02 Chelan Washington 53007 19812 154
2265059 2265059 2022-03-01 Chelan Washington 53007 19783 153
2261809 2261809 2022-02-28 Chelan Washington 53007 19744 153
2258558 2258558 2022-02-27 Chelan Washington 53007 19711 153
2255307 2255307 2022-02-26 Chelan Washington 53007 19711 153
2252056 2252056 2022-02-25 Chelan Washington 53007 19711 153
2248805 2248805 2022-02-24 Chelan Washington 53007 19588 152
2245554 2245554 2022-02-23 Chelan Washington 53007 19588 152
2242303 2242303 2022-02-22 Chelan Washington 53007 19525 151
2239052 2239052 2022-02-21 Chelan Washington 53007 19525 151
2235801 2235801 2022-02-20 Chelan Washington 53007 19525 151
2232550 2232550 2022-02-19 Chelan Washington 53007 19525 151
2229299 2229299 2022-02-18 Chelan Washington 53007 19525 151
2226048 2226048 2022-02-17 Chelan Washington 53007 19615 150
2222797 2222797 2022-02-16 Chelan Washington 53007 19615 150
2219546 2219546 2022-02-15 Chelan Washington 53007 19571 147
2216296 2216296 2022-02-14 Chelan Washington 53007 19571 147
2213045 2213045 2022-02-13 Chelan Washington 53007 19510 147
2209792 2209792 2022-02-12 Chelan Washington 53007 19510 147
2206539 2206539 2022-02-11 Chelan Washington 53007 19510 147
2203286 2203286 2022-02-10 Chelan Washington 53007 19246 145
2200032 2200032 2022-02-09 Chelan Washington 53007 19246 145
2196778 2196778 2022-02-08 Chelan Washington 53007 19111 145
2193523 2193523 2022-02-07 Chelan Washington 53007 19111 145
2190270 2190270 2022-02-06 Chelan Washington 53007 18931 143
2187017 2187017 2022-02-05 Chelan Washington 53007 18931 143
2183764 2183764 2022-02-04 Chelan Washington 53007 18931 143
2180512 2180512 2022-02-03 Chelan Washington 53007 18703 142

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