ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Pend Oreille" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502668 | 2502668 | 2022-05-13 | Pend Oreille | Washington | 53051 | 2508 | 36 |
2499410 | 2499410 | 2022-05-12 | Pend Oreille | Washington | 53051 | 2507 | 36 |
2496152 | 2496152 | 2022-05-11 | Pend Oreille | Washington | 53051 | 2507 | 36 |
2492894 | 2492894 | 2022-05-10 | Pend Oreille | Washington | 53051 | 2507 | 36 |
2489636 | 2489636 | 2022-05-09 | Pend Oreille | Washington | 53051 | 2507 | 36 |
2486379 | 2486379 | 2022-05-08 | Pend Oreille | Washington | 53051 | 2505 | 36 |
2483121 | 2483121 | 2022-05-07 | Pend Oreille | Washington | 53051 | 2505 | 36 |
2479863 | 2479863 | 2022-05-06 | Pend Oreille | Washington | 53051 | 2505 | 36 |
2476605 | 2476605 | 2022-05-05 | Pend Oreille | Washington | 53051 | 2505 | 36 |
2473347 | 2473347 | 2022-05-04 | Pend Oreille | Washington | 53051 | 2505 | 36 |
2470091 | 2470091 | 2022-05-03 | Pend Oreille | Washington | 53051 | 2505 | 36 |
2466835 | 2466835 | 2022-05-02 | Pend Oreille | Washington | 53051 | 2505 | 36 |
2463580 | 2463580 | 2022-05-01 | Pend Oreille | Washington | 53051 | 2504 | 36 |
2460324 | 2460324 | 2022-04-30 | Pend Oreille | Washington | 53051 | 2504 | 36 |
2457068 | 2457068 | 2022-04-29 | Pend Oreille | Washington | 53051 | 2504 | 36 |
2453812 | 2453812 | 2022-04-28 | Pend Oreille | Washington | 53051 | 2502 | 36 |
2450556 | 2450556 | 2022-04-27 | Pend Oreille | Washington | 53051 | 2502 | 36 |
2447300 | 2447300 | 2022-04-26 | Pend Oreille | Washington | 53051 | 2505 | 36 |
2444044 | 2444044 | 2022-04-25 | Pend Oreille | Washington | 53051 | 2505 | 36 |
2440788 | 2440788 | 2022-04-24 | Pend Oreille | Washington | 53051 | 2499 | 36 |
2437532 | 2437532 | 2022-04-23 | Pend Oreille | Washington | 53051 | 2499 | 36 |
2434276 | 2434276 | 2022-04-22 | Pend Oreille | Washington | 53051 | 2499 | 36 |
2431020 | 2431020 | 2022-04-21 | Pend Oreille | Washington | 53051 | 2498 | 36 |
2427764 | 2427764 | 2022-04-20 | Pend Oreille | Washington | 53051 | 2498 | 36 |
2424508 | 2424508 | 2022-04-19 | Pend Oreille | Washington | 53051 | 2498 | 36 |
2421252 | 2421252 | 2022-04-18 | Pend Oreille | Washington | 53051 | 2498 | 36 |
2417996 | 2417996 | 2022-04-17 | Pend Oreille | Washington | 53051 | 2497 | 36 |
2414740 | 2414740 | 2022-04-16 | Pend Oreille | Washington | 53051 | 2497 | 36 |
2411484 | 2411484 | 2022-04-15 | Pend Oreille | Washington | 53051 | 2497 | 36 |
2408228 | 2408228 | 2022-04-14 | Pend Oreille | Washington | 53051 | 2494 | 36 |
2404972 | 2404972 | 2022-04-13 | Pend Oreille | Washington | 53051 | 2494 | 36 |
2401717 | 2401717 | 2022-04-12 | Pend Oreille | Washington | 53051 | 2494 | 36 |
2398462 | 2398462 | 2022-04-11 | Pend Oreille | Washington | 53051 | 2494 | 36 |
2395207 | 2395207 | 2022-04-10 | Pend Oreille | Washington | 53051 | 2494 | 36 |
2391951 | 2391951 | 2022-04-09 | Pend Oreille | Washington | 53051 | 2494 | 36 |
2388695 | 2388695 | 2022-04-08 | Pend Oreille | Washington | 53051 | 2494 | 36 |
2385440 | 2385440 | 2022-04-07 | Pend Oreille | Washington | 53051 | 2494 | 36 |
2382185 | 2382185 | 2022-04-06 | Pend Oreille | Washington | 53051 | 2494 | 36 |
2378930 | 2378930 | 2022-04-05 | Pend Oreille | Washington | 53051 | 2494 | 36 |
2375676 | 2375676 | 2022-04-04 | Pend Oreille | Washington | 53051 | 2494 | 36 |
2372424 | 2372424 | 2022-04-03 | Pend Oreille | Washington | 53051 | 2493 | 36 |
2369171 | 2369171 | 2022-04-02 | Pend Oreille | Washington | 53051 | 2493 | 36 |
2365918 | 2365918 | 2022-04-01 | Pend Oreille | Washington | 53051 | 2493 | 36 |
2362665 | 2362665 | 2022-03-31 | Pend Oreille | Washington | 53051 | 2493 | 36 |
2359411 | 2359411 | 2022-03-30 | Pend Oreille | Washington | 53051 | 2493 | 36 |
2356157 | 2356157 | 2022-03-29 | Pend Oreille | Washington | 53051 | 2492 | 36 |
2352904 | 2352904 | 2022-03-28 | Pend Oreille | Washington | 53051 | 2492 | 36 |
2349652 | 2349652 | 2022-03-27 | Pend Oreille | Washington | 53051 | 2488 | 36 |
2346399 | 2346399 | 2022-03-26 | Pend Oreille | Washington | 53051 | 2488 | 36 |
2343146 | 2343146 | 2022-03-25 | Pend Oreille | Washington | 53051 | 2488 | 36 |
2339893 | 2339893 | 2022-03-24 | Pend Oreille | Washington | 53051 | 2479 | 36 |
2336640 | 2336640 | 2022-03-23 | Pend Oreille | Washington | 53051 | 2479 | 36 |
2333386 | 2333386 | 2022-03-22 | Pend Oreille | Washington | 53051 | 2475 | 36 |
2330132 | 2330132 | 2022-03-21 | Pend Oreille | Washington | 53051 | 2475 | 36 |
2326880 | 2326880 | 2022-03-20 | Pend Oreille | Washington | 53051 | 2473 | 36 |
2323627 | 2323627 | 2022-03-19 | Pend Oreille | Washington | 53051 | 2473 | 36 |
2320373 | 2320373 | 2022-03-18 | Pend Oreille | Washington | 53051 | 2473 | 36 |
2317119 | 2317119 | 2022-03-17 | Pend Oreille | Washington | 53051 | 2473 | 36 |
2313866 | 2313866 | 2022-03-16 | Pend Oreille | Washington | 53051 | 2473 | 36 |
2310613 | 2310613 | 2022-03-15 | Pend Oreille | Washington | 53051 | 2470 | 36 |
2307360 | 2307360 | 2022-03-14 | Pend Oreille | Washington | 53051 | 2470 | 36 |
2304109 | 2304109 | 2022-03-13 | Pend Oreille | Washington | 53051 | 2467 | 35 |
2300857 | 2300857 | 2022-03-12 | Pend Oreille | Washington | 53051 | 2467 | 35 |
2297605 | 2297605 | 2022-03-11 | Pend Oreille | Washington | 53051 | 2467 | 35 |
2294353 | 2294353 | 2022-03-10 | Pend Oreille | Washington | 53051 | 2463 | 33 |
2291101 | 2291101 | 2022-03-09 | Pend Oreille | Washington | 53051 | 2463 | 33 |
2287849 | 2287849 | 2022-03-08 | Pend Oreille | Washington | 53051 | 2460 | 32 |
2284597 | 2284597 | 2022-03-07 | Pend Oreille | Washington | 53051 | 2460 | 32 |
2281345 | 2281345 | 2022-03-06 | Pend Oreille | Washington | 53051 | 2458 | 32 |
2278092 | 2278092 | 2022-03-05 | Pend Oreille | Washington | 53051 | 2458 | 32 |
2274839 | 2274839 | 2022-03-04 | Pend Oreille | Washington | 53051 | 2458 | 32 |
2271586 | 2271586 | 2022-03-03 | Pend Oreille | Washington | 53051 | 2451 | 32 |
2268334 | 2268334 | 2022-03-02 | Pend Oreille | Washington | 53051 | 2451 | 32 |
2265081 | 2265081 | 2022-03-01 | Pend Oreille | Washington | 53051 | 2448 | 32 |
2261831 | 2261831 | 2022-02-28 | Pend Oreille | Washington | 53051 | 2448 | 32 |
2258580 | 2258580 | 2022-02-27 | Pend Oreille | Washington | 53051 | 2447 | 31 |
2255329 | 2255329 | 2022-02-26 | Pend Oreille | Washington | 53051 | 2447 | 31 |
2252078 | 2252078 | 2022-02-25 | Pend Oreille | Washington | 53051 | 2447 | 31 |
2248827 | 2248827 | 2022-02-24 | Pend Oreille | Washington | 53051 | 2469 | 31 |
2245576 | 2245576 | 2022-02-23 | Pend Oreille | Washington | 53051 | 2469 | 31 |
2242325 | 2242325 | 2022-02-22 | Pend Oreille | Washington | 53051 | 2457 | 30 |
2239074 | 2239074 | 2022-02-21 | Pend Oreille | Washington | 53051 | 2457 | 30 |
2235823 | 2235823 | 2022-02-20 | Pend Oreille | Washington | 53051 | 2457 | 30 |
2232572 | 2232572 | 2022-02-19 | Pend Oreille | Washington | 53051 | 2457 | 30 |
2229321 | 2229321 | 2022-02-18 | Pend Oreille | Washington | 53051 | 2457 | 30 |
2226070 | 2226070 | 2022-02-17 | Pend Oreille | Washington | 53051 | 2474 | 30 |
2222819 | 2222819 | 2022-02-16 | Pend Oreille | Washington | 53051 | 2474 | 30 |
2219568 | 2219568 | 2022-02-15 | Pend Oreille | Washington | 53051 | 2491 | 30 |
2216318 | 2216318 | 2022-02-14 | Pend Oreille | Washington | 53051 | 2491 | 30 |
2213067 | 2213067 | 2022-02-13 | Pend Oreille | Washington | 53051 | 2490 | 30 |
2209814 | 2209814 | 2022-02-12 | Pend Oreille | Washington | 53051 | 2490 | 30 |
2206561 | 2206561 | 2022-02-11 | Pend Oreille | Washington | 53051 | 2490 | 30 |
2203308 | 2203308 | 2022-02-10 | Pend Oreille | Washington | 53051 | 2424 | 30 |
2200054 | 2200054 | 2022-02-09 | Pend Oreille | Washington | 53051 | 2424 | 30 |
2196800 | 2196800 | 2022-02-08 | Pend Oreille | Washington | 53051 | 2421 | 29 |
2193545 | 2193545 | 2022-02-07 | Pend Oreille | Washington | 53051 | 2421 | 29 |
2190292 | 2190292 | 2022-02-06 | Pend Oreille | Washington | 53051 | 2403 | 29 |
2187039 | 2187039 | 2022-02-05 | Pend Oreille | Washington | 53051 | 2403 | 29 |
2183786 | 2183786 | 2022-02-04 | Pend Oreille | Washington | 53051 | 2403 | 29 |
2180534 | 2180534 | 2022-02-03 | Pend Oreille | Washington | 53051 | 2371 | 29 |
Advanced export
JSON shape: default, array, newline-delimited
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);