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

790 rows where county = "Lincoln", fips = 53043 and state = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Washington · 790 ✖

fips 1

  • 53043 · 790 ✖

county 1

  • Lincoln · 790 ✖
Link rowid date ▲ county state fips cases deaths
2502664 2502664 2022-05-13 Lincoln Washington 53043 2224 28
2499406 2499406 2022-05-12 Lincoln Washington 53043 2219 28
2496148 2496148 2022-05-11 Lincoln Washington 53043 2219 28
2492890 2492890 2022-05-10 Lincoln Washington 53043 2217 28
2489632 2489632 2022-05-09 Lincoln Washington 53043 2217 28
2486375 2486375 2022-05-08 Lincoln Washington 53043 2217 28
2483117 2483117 2022-05-07 Lincoln Washington 53043 2217 28
2479859 2479859 2022-05-06 Lincoln Washington 53043 2217 28
2476601 2476601 2022-05-05 Lincoln Washington 53043 2217 28
2473343 2473343 2022-05-04 Lincoln Washington 53043 2217 28
2470087 2470087 2022-05-03 Lincoln Washington 53043 2215 28
2466831 2466831 2022-05-02 Lincoln Washington 53043 2215 28
2463576 2463576 2022-05-01 Lincoln Washington 53043 2215 28
2460320 2460320 2022-04-30 Lincoln Washington 53043 2215 28
2457064 2457064 2022-04-29 Lincoln Washington 53043 2215 28
2453808 2453808 2022-04-28 Lincoln Washington 53043 2215 28
2450552 2450552 2022-04-27 Lincoln Washington 53043 2215 28
2447296 2447296 2022-04-26 Lincoln Washington 53043 2212 28
2444040 2444040 2022-04-25 Lincoln Washington 53043 2212 28
2440784 2440784 2022-04-24 Lincoln Washington 53043 2211 28
2437528 2437528 2022-04-23 Lincoln Washington 53043 2211 28
2434272 2434272 2022-04-22 Lincoln Washington 53043 2211 28
2431016 2431016 2022-04-21 Lincoln Washington 53043 2211 28
2427760 2427760 2022-04-20 Lincoln Washington 53043 2211 28
2424504 2424504 2022-04-19 Lincoln Washington 53043 2210 28
2421248 2421248 2022-04-18 Lincoln Washington 53043 2210 28
2417992 2417992 2022-04-17 Lincoln Washington 53043 2209 28
2414736 2414736 2022-04-16 Lincoln Washington 53043 2209 28
2411480 2411480 2022-04-15 Lincoln Washington 53043 2209 28
2408224 2408224 2022-04-14 Lincoln Washington 53043 2209 27
2404968 2404968 2022-04-13 Lincoln Washington 53043 2209 27
2401713 2401713 2022-04-12 Lincoln Washington 53043 2206 27
2398458 2398458 2022-04-11 Lincoln Washington 53043 2206 27
2395203 2395203 2022-04-10 Lincoln Washington 53043 2206 27
2391947 2391947 2022-04-09 Lincoln Washington 53043 2206 27
2388691 2388691 2022-04-08 Lincoln Washington 53043 2206 27
2385436 2385436 2022-04-07 Lincoln Washington 53043 2206 27
2382181 2382181 2022-04-06 Lincoln Washington 53043 2206 27
2378926 2378926 2022-04-05 Lincoln Washington 53043 2206 27
2375672 2375672 2022-04-04 Lincoln Washington 53043 2206 27
2372420 2372420 2022-04-03 Lincoln Washington 53043 2206 27
2369167 2369167 2022-04-02 Lincoln Washington 53043 2206 27
2365914 2365914 2022-04-01 Lincoln Washington 53043 2206 27
2362661 2362661 2022-03-31 Lincoln Washington 53043 2204 27
2359407 2359407 2022-03-30 Lincoln Washington 53043 2204 27
2356153 2356153 2022-03-29 Lincoln Washington 53043 2201 27
2352900 2352900 2022-03-28 Lincoln Washington 53043 2201 27
2349648 2349648 2022-03-27 Lincoln Washington 53043 2201 27
2346395 2346395 2022-03-26 Lincoln Washington 53043 2201 27
2343142 2343142 2022-03-25 Lincoln Washington 53043 2201 27
2339889 2339889 2022-03-24 Lincoln Washington 53043 2200 27
2336636 2336636 2022-03-23 Lincoln Washington 53043 2200 27
2333382 2333382 2022-03-22 Lincoln Washington 53043 2200 27
2330128 2330128 2022-03-21 Lincoln Washington 53043 2200 27
2326876 2326876 2022-03-20 Lincoln Washington 53043 2198 27
2323623 2323623 2022-03-19 Lincoln Washington 53043 2198 27
2320369 2320369 2022-03-18 Lincoln Washington 53043 2198 27
2317115 2317115 2022-03-17 Lincoln Washington 53043 2196 27
2313862 2313862 2022-03-16 Lincoln Washington 53043 2196 27
2310609 2310609 2022-03-15 Lincoln Washington 53043 2193 27
2307356 2307356 2022-03-14 Lincoln Washington 53043 2193 27
2304105 2304105 2022-03-13 Lincoln Washington 53043 2188 27
2300853 2300853 2022-03-12 Lincoln Washington 53043 2188 27
2297601 2297601 2022-03-11 Lincoln Washington 53043 2188 27
2294349 2294349 2022-03-10 Lincoln Washington 53043 2185 27
2291097 2291097 2022-03-09 Lincoln Washington 53043 2185 27
2287845 2287845 2022-03-08 Lincoln Washington 53043 2183 27
2284593 2284593 2022-03-07 Lincoln Washington 53043 2183 27
2281341 2281341 2022-03-06 Lincoln Washington 53043 2182 27
2278088 2278088 2022-03-05 Lincoln Washington 53043 2182 27
2274835 2274835 2022-03-04 Lincoln Washington 53043 2182 27
2271582 2271582 2022-03-03 Lincoln Washington 53043 2175 27
2268330 2268330 2022-03-02 Lincoln Washington 53043 2175 27
2265077 2265077 2022-03-01 Lincoln Washington 53043 2172 27
2261827 2261827 2022-02-28 Lincoln Washington 53043 2172 27
2258576 2258576 2022-02-27 Lincoln Washington 53043 2167 27
2255325 2255325 2022-02-26 Lincoln Washington 53043 2167 27
2252074 2252074 2022-02-25 Lincoln Washington 53043 2167 27
2248823 2248823 2022-02-24 Lincoln Washington 53043 2163 27
2245572 2245572 2022-02-23 Lincoln Washington 53043 2163 27
2242321 2242321 2022-02-22 Lincoln Washington 53043 2169 27
2239070 2239070 2022-02-21 Lincoln Washington 53043 2169 27
2235819 2235819 2022-02-20 Lincoln Washington 53043 2169 27
2232568 2232568 2022-02-19 Lincoln Washington 53043 2169 27
2229317 2229317 2022-02-18 Lincoln Washington 53043 2169 27
2226066 2226066 2022-02-17 Lincoln Washington 53043 2189 27
2222815 2222815 2022-02-16 Lincoln Washington 53043 2189 27
2219564 2219564 2022-02-15 Lincoln Washington 53043 2172 27
2216314 2216314 2022-02-14 Lincoln Washington 53043 2172 27
2213063 2213063 2022-02-13 Lincoln Washington 53043 2159 27
2209810 2209810 2022-02-12 Lincoln Washington 53043 2159 27
2206557 2206557 2022-02-11 Lincoln Washington 53043 2159 27
2203304 2203304 2022-02-10 Lincoln Washington 53043 2098 27
2200050 2200050 2022-02-09 Lincoln Washington 53043 2098 27
2196796 2196796 2022-02-08 Lincoln Washington 53043 2075 27
2193541 2193541 2022-02-07 Lincoln Washington 53043 2075 27
2190288 2190288 2022-02-06 Lincoln Washington 53043 2056 27
2187035 2187035 2022-02-05 Lincoln Washington 53043 2056 27
2183782 2183782 2022-02-04 Lincoln Washington 53043 2056 27
2180530 2180530 2022-02-03 Lincoln Washington 53043 2030 27

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