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

774 rows where county = "Malheur" and state = "Oregon" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Oregon · 774 ✖

fips 1

county 1

  • Malheur · 774 ✖
Link rowid date ▲ county state fips cases deaths
2501833 2501833 2022-05-13 Malheur Oregon 41045 8251 108
2498575 2498575 2022-05-12 Malheur Oregon 41045 8251 108
2495317 2495317 2022-05-11 Malheur Oregon 41045 8250 108
2492059 2492059 2022-05-10 Malheur Oregon 41045 8244 108
2488801 2488801 2022-05-09 Malheur Oregon 41045 8240 108
2485544 2485544 2022-05-08 Malheur Oregon 41045 8240 108
2482286 2482286 2022-05-07 Malheur Oregon 41045 8240 108
2479028 2479028 2022-05-06 Malheur Oregon 41045 8240 108
2475770 2475770 2022-05-05 Malheur Oregon 41045 8240 108
2472513 2472513 2022-05-04 Malheur Oregon 41045 8240 108
2469257 2469257 2022-05-03 Malheur Oregon 41045 8239 108
2466001 2466001 2022-05-02 Malheur Oregon 41045 8234 108
2462746 2462746 2022-05-01 Malheur Oregon 41045 8234 108
2459490 2459490 2022-04-30 Malheur Oregon 41045 8234 108
2456234 2456234 2022-04-29 Malheur Oregon 41045 8234 108
2452978 2452978 2022-04-28 Malheur Oregon 41045 8233 108
2449722 2449722 2022-04-27 Malheur Oregon 41045 8222 108
2446465 2446465 2022-04-26 Malheur Oregon 41045 8222 108
2443210 2443210 2022-04-25 Malheur Oregon 41045 8215 108
2439954 2439954 2022-04-24 Malheur Oregon 41045 8216 108
2436698 2436698 2022-04-23 Malheur Oregon 41045 8216 108
2433442 2433442 2022-04-22 Malheur Oregon 41045 8216 108
2430186 2430186 2022-04-21 Malheur Oregon 41045 8216 108
2426930 2426930 2022-04-20 Malheur Oregon 41045 8214 108
2423674 2423674 2022-04-19 Malheur Oregon 41045 8214 108
2420417 2420417 2022-04-18 Malheur Oregon 41045 8213 108
2417162 2417162 2022-04-17 Malheur Oregon 41045 8213 108
2413906 2413906 2022-04-16 Malheur Oregon 41045 8213 108
2410650 2410650 2022-04-15 Malheur Oregon 41045 8213 108
2407394 2407394 2022-04-14 Malheur Oregon 41045 8213 108
2404138 2404138 2022-04-13 Malheur Oregon 41045 8211 108
2400883 2400883 2022-04-12 Malheur Oregon 41045 8210 108
2397628 2397628 2022-04-11 Malheur Oregon 41045 8207 108
2394373 2394373 2022-04-10 Malheur Oregon 41045 8207 108
2391117 2391117 2022-04-09 Malheur Oregon 41045 8207 108
2387861 2387861 2022-04-08 Malheur Oregon 41045 8207 108
2384606 2384606 2022-04-07 Malheur Oregon 41045 8207 108
2381351 2381351 2022-04-06 Malheur Oregon 41045 8205 108
2378096 2378096 2022-04-05 Malheur Oregon 41045 8203 108
2374842 2374842 2022-04-04 Malheur Oregon 41045 8203 108
2371590 2371590 2022-04-03 Malheur Oregon 41045 8203 108
2368337 2368337 2022-04-02 Malheur Oregon 41045 8203 108
2365084 2365084 2022-04-01 Malheur Oregon 41045 8203 108
2361831 2361831 2022-03-31 Malheur Oregon 41045 8202 108
2358577 2358577 2022-03-30 Malheur Oregon 41045 8202 108
2355323 2355323 2022-03-29 Malheur Oregon 41045 8200 108
2352070 2352070 2022-03-28 Malheur Oregon 41045 8199 108
2348818 2348818 2022-03-27 Malheur Oregon 41045 8199 106
2345565 2345565 2022-03-26 Malheur Oregon 41045 8199 106
2342312 2342312 2022-03-25 Malheur Oregon 41045 8199 106
2339059 2339059 2022-03-24 Malheur Oregon 41045 8199 106
2335805 2335805 2022-03-23 Malheur Oregon 41045 8198 105
2332551 2332551 2022-03-22 Malheur Oregon 41045 8196 105
2329298 2329298 2022-03-21 Malheur Oregon 41045 8194 105
2326046 2326046 2022-03-20 Malheur Oregon 41045 8194 105
2322793 2322793 2022-03-19 Malheur Oregon 41045 8194 105
2319539 2319539 2022-03-18 Malheur Oregon 41045 8194 105
2316285 2316285 2022-03-17 Malheur Oregon 41045 8193 105
2313032 2313032 2022-03-16 Malheur Oregon 41045 8193 105
2309779 2309779 2022-03-15 Malheur Oregon 41045 8190 103
2306526 2306526 2022-03-14 Malheur Oregon 41045 8191 101
2303275 2303275 2022-03-13 Malheur Oregon 41045 8190 101
2300023 2300023 2022-03-12 Malheur Oregon 41045 8190 101
2296771 2296771 2022-03-11 Malheur Oregon 41045 8190 101
2293519 2293519 2022-03-10 Malheur Oregon 41045 8190 101
2290267 2290267 2022-03-09 Malheur Oregon 41045 8187 101
2287015 2287015 2022-03-08 Malheur Oregon 41045 8187 101
2283763 2283763 2022-03-07 Malheur Oregon 41045 8181 101
2280511 2280511 2022-03-06 Malheur Oregon 41045 8176 101
2277258 2277258 2022-03-05 Malheur Oregon 41045 8176 101
2274005 2274005 2022-03-04 Malheur Oregon 41045 8176 101
2270752 2270752 2022-03-03 Malheur Oregon 41045 8174 101
2267500 2267500 2022-03-02 Malheur Oregon 41045 8170 101
2264247 2264247 2022-03-01 Malheur Oregon 41045 8170 101
2260997 2260997 2022-02-28 Malheur Oregon 41045 8161 101
2257746 2257746 2022-02-27 Malheur Oregon 41045 8154 101
2254495 2254495 2022-02-26 Malheur Oregon 41045 8154 101
2251244 2251244 2022-02-25 Malheur Oregon 41045 8154 101
2247993 2247993 2022-02-24 Malheur Oregon 41045 8148 101
2244742 2244742 2022-02-23 Malheur Oregon 41045 8130 101
2241491 2241491 2022-02-22 Malheur Oregon 41045 8117 101
2238240 2238240 2022-02-21 Malheur Oregon 41045 8109 101
2234989 2234989 2022-02-20 Malheur Oregon 41045 8109 101
2231738 2231738 2022-02-19 Malheur Oregon 41045 8109 101
2228487 2228487 2022-02-18 Malheur Oregon 41045 8109 101
2225236 2225236 2022-02-17 Malheur Oregon 41045 8099 101
2221985 2221985 2022-02-16 Malheur Oregon 41045 8082 101
2218734 2218734 2022-02-15 Malheur Oregon 41045 8068 100
2215483 2215483 2022-02-14 Malheur Oregon 41045 8044 100
2212232 2212232 2022-02-13 Malheur Oregon 41045 8027 100
2208979 2208979 2022-02-12 Malheur Oregon 41045 8027 100
2205726 2205726 2022-02-11 Malheur Oregon 41045 8027 100
2202473 2202473 2022-02-10 Malheur Oregon 41045 8022 100
2199219 2199219 2022-02-09 Malheur Oregon 41045 8004 100
2195965 2195965 2022-02-08 Malheur Oregon 41045 7977 100
2192711 2192711 2022-02-07 Malheur Oregon 41045 7928 100
2189457 2189457 2022-02-06 Malheur Oregon 41045 7885 100
2186204 2186204 2022-02-05 Malheur Oregon 41045 7885 100
2182952 2182952 2022-02-04 Malheur Oregon 41045 7885 100
2179700 2179700 2022-02-03 Malheur Oregon 41045 7839 100

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