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

772 rows where county = "Washington" and state = "Idaho" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Idaho · 772 ✖

fips 1

county 1

  • Washington · 772 ✖
Link rowid date ▲ county state fips cases deaths
2500176 2500176 2022-05-13 Washington Idaho 16087 2394 57
2496918 2496918 2022-05-12 Washington Idaho 16087 2393 57
2493660 2493660 2022-05-11 Washington Idaho 16087 2393 57
2490402 2490402 2022-05-10 Washington Idaho 16087 2392 57
2487145 2487145 2022-05-09 Washington Idaho 16087 2392 57
2483887 2483887 2022-05-08 Washington Idaho 16087 2392 57
2480629 2480629 2022-05-07 Washington Idaho 16087 2392 57
2477371 2477371 2022-05-06 Washington Idaho 16087 2392 57
2474113 2474113 2022-05-05 Washington Idaho 16087 2392 57
2470856 2470856 2022-05-04 Washington Idaho 16087 2392 57
2467600 2467600 2022-05-03 Washington Idaho 16087 2391 57
2464345 2464345 2022-05-02 Washington Idaho 16087 2391 57
2461089 2461089 2022-05-01 Washington Idaho 16087 2390 57
2457833 2457833 2022-04-30 Washington Idaho 16087 2390 57
2454577 2454577 2022-04-29 Washington Idaho 16087 2390 57
2451321 2451321 2022-04-28 Washington Idaho 16087 2388 57
2448065 2448065 2022-04-27 Washington Idaho 16087 2388 57
2444809 2444809 2022-04-26 Washington Idaho 16087 2388 57
2441553 2441553 2022-04-25 Washington Idaho 16087 2388 57
2438297 2438297 2022-04-24 Washington Idaho 16087 2388 57
2435041 2435041 2022-04-23 Washington Idaho 16087 2388 57
2431785 2431785 2022-04-22 Washington Idaho 16087 2388 57
2428529 2428529 2022-04-21 Washington Idaho 16087 2388 57
2425273 2425273 2022-04-20 Washington Idaho 16087 2388 57
2422017 2422017 2022-04-19 Washington Idaho 16087 2386 57
2418761 2418761 2022-04-18 Washington Idaho 16087 2386 57
2415505 2415505 2022-04-17 Washington Idaho 16087 2386 57
2412249 2412249 2022-04-16 Washington Idaho 16087 2386 57
2408993 2408993 2022-04-15 Washington Idaho 16087 2386 57
2405737 2405737 2022-04-14 Washington Idaho 16087 2386 57
2402482 2402482 2022-04-13 Washington Idaho 16087 2386 57
2399227 2399227 2022-04-12 Washington Idaho 16087 2386 57
2395972 2395972 2022-04-11 Washington Idaho 16087 2386 57
2392716 2392716 2022-04-10 Washington Idaho 16087 2386 57
2389460 2389460 2022-04-09 Washington Idaho 16087 2386 57
2386205 2386205 2022-04-08 Washington Idaho 16087 2386 57
2382950 2382950 2022-04-07 Washington Idaho 16087 2387 57
2379695 2379695 2022-04-06 Washington Idaho 16087 2379 57
2376441 2376441 2022-04-05 Washington Idaho 16087 2368 57
2373189 2373189 2022-04-04 Washington Idaho 16087 2368 57
2369936 2369936 2022-04-03 Washington Idaho 16087 2368 57
2366683 2366683 2022-04-02 Washington Idaho 16087 2368 57
2363430 2363430 2022-04-01 Washington Idaho 16087 2368 57
2360176 2360176 2022-03-31 Washington Idaho 16087 2368 57
2356922 2356922 2022-03-30 Washington Idaho 16087 2368 57
2353669 2353669 2022-03-29 Washington Idaho 16087 2368 57
2350417 2350417 2022-03-28 Washington Idaho 16087 2368 57
2347164 2347164 2022-03-27 Washington Idaho 16087 2368 57
2343911 2343911 2022-03-26 Washington Idaho 16087 2368 57
2340658 2340658 2022-03-25 Washington Idaho 16087 2368 57
2337405 2337405 2022-03-24 Washington Idaho 16087 2368 57
2334151 2334151 2022-03-23 Washington Idaho 16087 2368 57
2330897 2330897 2022-03-22 Washington Idaho 16087 2367 57
2327645 2327645 2022-03-21 Washington Idaho 16087 2366 56
2324392 2324392 2022-03-20 Washington Idaho 16087 2366 56
2321138 2321138 2022-03-19 Washington Idaho 16087 2366 56
2317884 2317884 2022-03-18 Washington Idaho 16087 2366 56
2314631 2314631 2022-03-17 Washington Idaho 16087 2364 56
2311378 2311378 2022-03-16 Washington Idaho 16087 2364 56
2308125 2308125 2022-03-15 Washington Idaho 16087 2363 56
2304874 2304874 2022-03-14 Washington Idaho 16087 2363 56
2301622 2301622 2022-03-13 Washington Idaho 16087 2362 56
2298370 2298370 2022-03-12 Washington Idaho 16087 2362 56
2295118 2295118 2022-03-11 Washington Idaho 16087 2362 56
2291866 2291866 2022-03-10 Washington Idaho 16087 2362 56
2288614 2288614 2022-03-09 Washington Idaho 16087 2360 56
2285363 2285363 2022-03-08 Washington Idaho 16087 2361 56
2282111 2282111 2022-03-07 Washington Idaho 16087 2359 56
2278858 2278858 2022-03-06 Washington Idaho 16087 2359 56
2275605 2275605 2022-03-05 Washington Idaho 16087 2359 56
2272352 2272352 2022-03-04 Washington Idaho 16087 2359 56
2269100 2269100 2022-03-03 Washington Idaho 16087 2352 56
2265847 2265847 2022-03-02 Washington Idaho 16087 2345 57
2262596 2262596 2022-03-01 Washington Idaho 16087 2332 56
2259345 2259345 2022-02-28 Washington Idaho 16087 2328 56
2256094 2256094 2022-02-27 Washington Idaho 16087 2322 56
2252843 2252843 2022-02-26 Washington Idaho 16087 2322 56
2249592 2249592 2022-02-25 Washington Idaho 16087 2322 56
2246341 2246341 2022-02-24 Washington Idaho 16087 2310 56
2243090 2243090 2022-02-23 Washington Idaho 16087 2304 56
2239839 2239839 2022-02-22 Washington Idaho 16087 2295 56
2236588 2236588 2022-02-21 Washington Idaho 16087 2288 56
2233337 2233337 2022-02-20 Washington Idaho 16087 2288 56
2230086 2230086 2022-02-19 Washington Idaho 16087 2288 56
2226835 2226835 2022-02-18 Washington Idaho 16087 2282 56
2223584 2223584 2022-02-17 Washington Idaho 16087 2270 54
2220333 2220333 2022-02-16 Washington Idaho 16087 2251 54
2217082 2217082 2022-02-15 Washington Idaho 16087 2239 54
2213831 2213831 2022-02-14 Washington Idaho 16087 2233 54
2210579 2210579 2022-02-13 Washington Idaho 16087 2222 53
2207326 2207326 2022-02-12 Washington Idaho 16087 2222 53
2204073 2204073 2022-02-11 Washington Idaho 16087 2216 53
2200820 2200820 2022-02-10 Washington Idaho 16087 2201 53
2197566 2197566 2022-02-09 Washington Idaho 16087 2179 53
2194312 2194312 2022-02-08 Washington Idaho 16087 2167 53
2191058 2191058 2022-02-07 Washington Idaho 16087 2152 53
2187805 2187805 2022-02-06 Washington Idaho 16087 2134 53
2184552 2184552 2022-02-05 Washington Idaho 16087 2134 53
2181300 2181300 2022-02-04 Washington Idaho 16087 2128 53
2178049 2178049 2022-02-03 Washington Idaho 16087 2118 53

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