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

782 rows where county = "Hood River" and fips = 41027 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 41027 · 782 ✖

county 1

  • Hood River · 782 ✖
Link rowid date ▲ county state fips cases deaths
2501824 2501824 2022-05-13 Hood River Oregon 41027 3698 44
2498566 2498566 2022-05-12 Hood River Oregon 41027 3683 43
2495308 2495308 2022-05-11 Hood River Oregon 41027 3677 43
2492050 2492050 2022-05-10 Hood River Oregon 41027 3667 43
2488792 2488792 2022-05-09 Hood River Oregon 41027 3659 43
2485535 2485535 2022-05-08 Hood River Oregon 41027 3648 43
2482277 2482277 2022-05-07 Hood River Oregon 41027 3648 43
2479019 2479019 2022-05-06 Hood River Oregon 41027 3648 43
2475761 2475761 2022-05-05 Hood River Oregon 41027 3642 43
2472504 2472504 2022-05-04 Hood River Oregon 41027 3636 43
2469248 2469248 2022-05-03 Hood River Oregon 41027 3629 43
2465992 2465992 2022-05-02 Hood River Oregon 41027 3626 43
2462737 2462737 2022-05-01 Hood River Oregon 41027 3621 43
2459481 2459481 2022-04-30 Hood River Oregon 41027 3621 43
2456225 2456225 2022-04-29 Hood River Oregon 41027 3621 43
2452969 2452969 2022-04-28 Hood River Oregon 41027 3613 43
2449713 2449713 2022-04-27 Hood River Oregon 41027 3610 43
2446456 2446456 2022-04-26 Hood River Oregon 41027 3604 43
2443201 2443201 2022-04-25 Hood River Oregon 41027 3597 43
2439945 2439945 2022-04-24 Hood River Oregon 41027 3590 43
2436689 2436689 2022-04-23 Hood River Oregon 41027 3590 43
2433433 2433433 2022-04-22 Hood River Oregon 41027 3590 43
2430177 2430177 2022-04-21 Hood River Oregon 41027 3589 43
2426921 2426921 2022-04-20 Hood River Oregon 41027 3586 43
2423665 2423665 2022-04-19 Hood River Oregon 41027 3574 43
2420408 2420408 2022-04-18 Hood River Oregon 41027 3567 43
2417153 2417153 2022-04-17 Hood River Oregon 41027 3567 43
2413897 2413897 2022-04-16 Hood River Oregon 41027 3567 43
2410641 2410641 2022-04-15 Hood River Oregon 41027 3567 43
2407385 2407385 2022-04-14 Hood River Oregon 41027 3567 43
2404129 2404129 2022-04-13 Hood River Oregon 41027 3566 43
2400874 2400874 2022-04-12 Hood River Oregon 41027 3565 43
2397619 2397619 2022-04-11 Hood River Oregon 41027 3564 43
2394364 2394364 2022-04-10 Hood River Oregon 41027 3562 43
2391108 2391108 2022-04-09 Hood River Oregon 41027 3562 43
2387852 2387852 2022-04-08 Hood River Oregon 41027 3562 43
2384597 2384597 2022-04-07 Hood River Oregon 41027 3561 43
2381342 2381342 2022-04-06 Hood River Oregon 41027 3560 42
2378087 2378087 2022-04-05 Hood River Oregon 41027 3559 42
2374833 2374833 2022-04-04 Hood River Oregon 41027 3555 42
2371581 2371581 2022-04-03 Hood River Oregon 41027 3548 42
2368328 2368328 2022-04-02 Hood River Oregon 41027 3548 42
2365075 2365075 2022-04-01 Hood River Oregon 41027 3548 42
2361822 2361822 2022-03-31 Hood River Oregon 41027 3546 42
2358568 2358568 2022-03-30 Hood River Oregon 41027 3545 42
2355314 2355314 2022-03-29 Hood River Oregon 41027 3535 42
2352061 2352061 2022-03-28 Hood River Oregon 41027 3533 42
2348809 2348809 2022-03-27 Hood River Oregon 41027 3533 42
2345556 2345556 2022-03-26 Hood River Oregon 41027 3533 42
2342303 2342303 2022-03-25 Hood River Oregon 41027 3533 42
2339050 2339050 2022-03-24 Hood River Oregon 41027 3532 42
2335796 2335796 2022-03-23 Hood River Oregon 41027 3530 42
2332542 2332542 2022-03-22 Hood River Oregon 41027 3527 42
2329289 2329289 2022-03-21 Hood River Oregon 41027 3524 42
2326037 2326037 2022-03-20 Hood River Oregon 41027 3521 42
2322784 2322784 2022-03-19 Hood River Oregon 41027 3521 42
2319530 2319530 2022-03-18 Hood River Oregon 41027 3521 42
2316276 2316276 2022-03-17 Hood River Oregon 41027 3518 42
2313023 2313023 2022-03-16 Hood River Oregon 41027 3518 42
2309770 2309770 2022-03-15 Hood River Oregon 41027 3512 42
2306517 2306517 2022-03-14 Hood River Oregon 41027 3509 42
2303266 2303266 2022-03-13 Hood River Oregon 41027 3506 42
2300014 2300014 2022-03-12 Hood River Oregon 41027 3506 42
2296762 2296762 2022-03-11 Hood River Oregon 41027 3506 42
2293510 2293510 2022-03-10 Hood River Oregon 41027 3504 42
2290258 2290258 2022-03-09 Hood River Oregon 41027 3501 42
2287006 2287006 2022-03-08 Hood River Oregon 41027 3499 42
2283754 2283754 2022-03-07 Hood River Oregon 41027 3499 42
2280502 2280502 2022-03-06 Hood River Oregon 41027 3491 42
2277249 2277249 2022-03-05 Hood River Oregon 41027 3491 42
2273996 2273996 2022-03-04 Hood River Oregon 41027 3491 42
2270743 2270743 2022-03-03 Hood River Oregon 41027 3487 42
2267491 2267491 2022-03-02 Hood River Oregon 41027 3482 42
2264238 2264238 2022-03-01 Hood River Oregon 41027 3470 42
2260988 2260988 2022-02-28 Hood River Oregon 41027 3464 42
2257737 2257737 2022-02-27 Hood River Oregon 41027 3461 42
2254486 2254486 2022-02-26 Hood River Oregon 41027 3461 42
2251235 2251235 2022-02-25 Hood River Oregon 41027 3461 42
2247984 2247984 2022-02-24 Hood River Oregon 41027 3457 42
2244733 2244733 2022-02-23 Hood River Oregon 41027 3454 42
2241482 2241482 2022-02-22 Hood River Oregon 41027 3450 42
2238231 2238231 2022-02-21 Hood River Oregon 41027 3429 42
2234980 2234980 2022-02-20 Hood River Oregon 41027 3429 42
2231729 2231729 2022-02-19 Hood River Oregon 41027 3429 42
2228478 2228478 2022-02-18 Hood River Oregon 41027 3429 42
2225227 2225227 2022-02-17 Hood River Oregon 41027 3414 42
2221976 2221976 2022-02-16 Hood River Oregon 41027 3403 42
2218725 2218725 2022-02-15 Hood River Oregon 41027 3398 41
2215474 2215474 2022-02-14 Hood River Oregon 41027 3390 41
2212223 2212223 2022-02-13 Hood River Oregon 41027 3365 41
2208970 2208970 2022-02-12 Hood River Oregon 41027 3365 41
2205717 2205717 2022-02-11 Hood River Oregon 41027 3365 41
2202464 2202464 2022-02-10 Hood River Oregon 41027 3354 41
2199210 2199210 2022-02-09 Hood River Oregon 41027 3344 41
2195956 2195956 2022-02-08 Hood River Oregon 41027 3324 41
2192702 2192702 2022-02-07 Hood River Oregon 41027 3302 41
2189448 2189448 2022-02-06 Hood River Oregon 41027 3280 41
2186195 2186195 2022-02-05 Hood River Oregon 41027 3280 41
2182943 2182943 2022-02-04 Hood River Oregon 41027 3280 41
2179691 2179691 2022-02-03 Hood River Oregon 41027 3252 41

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