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

779 rows where fips = 41057 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

  • 41057 · 779 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501839 2501839 2022-05-13 Tillamook Oregon 41057 3827 64
2498581 2498581 2022-05-12 Tillamook Oregon 41057 3819 64
2495323 2495323 2022-05-11 Tillamook Oregon 41057 3811 64
2492065 2492065 2022-05-10 Tillamook Oregon 41057 3805 64
2488807 2488807 2022-05-09 Tillamook Oregon 41057 3800 64
2485550 2485550 2022-05-08 Tillamook Oregon 41057 3792 64
2482292 2482292 2022-05-07 Tillamook Oregon 41057 3792 64
2479034 2479034 2022-05-06 Tillamook Oregon 41057 3792 64
2475776 2475776 2022-05-05 Tillamook Oregon 41057 3780 64
2472519 2472519 2022-05-04 Tillamook Oregon 41057 3773 64
2469263 2469263 2022-05-03 Tillamook Oregon 41057 3763 64
2466007 2466007 2022-05-02 Tillamook Oregon 41057 3747 64
2462752 2462752 2022-05-01 Tillamook Oregon 41057 3735 64
2459496 2459496 2022-04-30 Tillamook Oregon 41057 3735 64
2456240 2456240 2022-04-29 Tillamook Oregon 41057 3735 64
2452984 2452984 2022-04-28 Tillamook Oregon 41057 3726 64
2449728 2449728 2022-04-27 Tillamook Oregon 41057 3721 64
2446471 2446471 2022-04-26 Tillamook Oregon 41057 3716 64
2443216 2443216 2022-04-25 Tillamook Oregon 41057 3713 64
2439960 2439960 2022-04-24 Tillamook Oregon 41057 3704 64
2436704 2436704 2022-04-23 Tillamook Oregon 41057 3704 64
2433448 2433448 2022-04-22 Tillamook Oregon 41057 3704 64
2430192 2430192 2022-04-21 Tillamook Oregon 41057 3703 64
2426936 2426936 2022-04-20 Tillamook Oregon 41057 3700 64
2423680 2423680 2022-04-19 Tillamook Oregon 41057 3697 64
2420423 2420423 2022-04-18 Tillamook Oregon 41057 3684 64
2417168 2417168 2022-04-17 Tillamook Oregon 41057 3684 64
2413912 2413912 2022-04-16 Tillamook Oregon 41057 3684 64
2410656 2410656 2022-04-15 Tillamook Oregon 41057 3684 64
2407400 2407400 2022-04-14 Tillamook Oregon 41057 3681 64
2404144 2404144 2022-04-13 Tillamook Oregon 41057 3675 64
2400889 2400889 2022-04-12 Tillamook Oregon 41057 3671 64
2397634 2397634 2022-04-11 Tillamook Oregon 41057 3668 64
2394379 2394379 2022-04-10 Tillamook Oregon 41057 3663 63
2391123 2391123 2022-04-09 Tillamook Oregon 41057 3663 63
2387867 2387867 2022-04-08 Tillamook Oregon 41057 3663 63
2384612 2384612 2022-04-07 Tillamook Oregon 41057 3659 62
2381357 2381357 2022-04-06 Tillamook Oregon 41057 3657 62
2378102 2378102 2022-04-05 Tillamook Oregon 41057 3648 61
2374848 2374848 2022-04-04 Tillamook Oregon 41057 3645 60
2371596 2371596 2022-04-03 Tillamook Oregon 41057 3645 60
2368343 2368343 2022-04-02 Tillamook Oregon 41057 3645 60
2365090 2365090 2022-04-01 Tillamook Oregon 41057 3645 60
2361837 2361837 2022-03-31 Tillamook Oregon 41057 3642 60
2358583 2358583 2022-03-30 Tillamook Oregon 41057 3642 60
2355329 2355329 2022-03-29 Tillamook Oregon 41057 3638 60
2352076 2352076 2022-03-28 Tillamook Oregon 41057 3638 60
2348824 2348824 2022-03-27 Tillamook Oregon 41057 3633 60
2345571 2345571 2022-03-26 Tillamook Oregon 41057 3633 60
2342318 2342318 2022-03-25 Tillamook Oregon 41057 3633 60
2339065 2339065 2022-03-24 Tillamook Oregon 41057 3632 60
2335811 2335811 2022-03-23 Tillamook Oregon 41057 3631 60
2332557 2332557 2022-03-22 Tillamook Oregon 41057 3626 60
2329304 2329304 2022-03-21 Tillamook Oregon 41057 3625 60
2326052 2326052 2022-03-20 Tillamook Oregon 41057 3622 59
2322799 2322799 2022-03-19 Tillamook Oregon 41057 3622 59
2319545 2319545 2022-03-18 Tillamook Oregon 41057 3622 59
2316291 2316291 2022-03-17 Tillamook Oregon 41057 3613 59
2313038 2313038 2022-03-16 Tillamook Oregon 41057 3613 59
2309785 2309785 2022-03-15 Tillamook Oregon 41057 3611 58
2306532 2306532 2022-03-14 Tillamook Oregon 41057 3608 58
2303281 2303281 2022-03-13 Tillamook Oregon 41057 3606 58
2300029 2300029 2022-03-12 Tillamook Oregon 41057 3606 58
2296777 2296777 2022-03-11 Tillamook Oregon 41057 3606 58
2293525 2293525 2022-03-10 Tillamook Oregon 41057 3605 58
2290273 2290273 2022-03-09 Tillamook Oregon 41057 3605 58
2287021 2287021 2022-03-08 Tillamook Oregon 41057 3605 57
2283769 2283769 2022-03-07 Tillamook Oregon 41057 3604 57
2280517 2280517 2022-03-06 Tillamook Oregon 41057 3596 57
2277264 2277264 2022-03-05 Tillamook Oregon 41057 3596 57
2274011 2274011 2022-03-04 Tillamook Oregon 41057 3596 57
2270758 2270758 2022-03-03 Tillamook Oregon 41057 3594 57
2267506 2267506 2022-03-02 Tillamook Oregon 41057 3594 57
2264253 2264253 2022-03-01 Tillamook Oregon 41057 3592 57
2261003 2261003 2022-02-28 Tillamook Oregon 41057 3592 57
2257752 2257752 2022-02-27 Tillamook Oregon 41057 3583 57
2254501 2254501 2022-02-26 Tillamook Oregon 41057 3583 57
2251250 2251250 2022-02-25 Tillamook Oregon 41057 3583 57
2247999 2247999 2022-02-24 Tillamook Oregon 41057 3579 57
2244748 2244748 2022-02-23 Tillamook Oregon 41057 3578 57
2241497 2241497 2022-02-22 Tillamook Oregon 41057 3566 57
2238246 2238246 2022-02-21 Tillamook Oregon 41057 3551 57
2234995 2234995 2022-02-20 Tillamook Oregon 41057 3551 57
2231744 2231744 2022-02-19 Tillamook Oregon 41057 3551 57
2228493 2228493 2022-02-18 Tillamook Oregon 41057 3551 57
2225242 2225242 2022-02-17 Tillamook Oregon 41057 3535 57
2221991 2221991 2022-02-16 Tillamook Oregon 41057 3523 57
2218740 2218740 2022-02-15 Tillamook Oregon 41057 3515 57
2215489 2215489 2022-02-14 Tillamook Oregon 41057 3507 57
2212238 2212238 2022-02-13 Tillamook Oregon 41057 3474 57
2208985 2208985 2022-02-12 Tillamook Oregon 41057 3474 57
2205732 2205732 2022-02-11 Tillamook Oregon 41057 3474 57
2202479 2202479 2022-02-10 Tillamook Oregon 41057 3460 57
2199225 2199225 2022-02-09 Tillamook Oregon 41057 3439 57
2195971 2195971 2022-02-08 Tillamook Oregon 41057 3423 56
2192717 2192717 2022-02-07 Tillamook Oregon 41057 3401 55
2189463 2189463 2022-02-06 Tillamook Oregon 41057 3367 55
2186210 2186210 2022-02-05 Tillamook Oregon 41057 3367 55
2182958 2182958 2022-02-04 Tillamook Oregon 41057 3367 55
2179706 2179706 2022-02-03 Tillamook Oregon 41057 3327 55

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