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

738 rows where county = "Baker" and fips = 41001 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

  • 41001 · 738 ✖

county 1

  • Baker · 738 ✖
Link rowid date ▲ county state fips cases deaths
2501811 2501811 2022-05-13 Baker Oregon 41001 3231 48
2498553 2498553 2022-05-12 Baker Oregon 41001 3230 48
2495295 2495295 2022-05-11 Baker Oregon 41001 3226 48
2492037 2492037 2022-05-10 Baker Oregon 41001 3226 48
2488779 2488779 2022-05-09 Baker Oregon 41001 3226 48
2485522 2485522 2022-05-08 Baker Oregon 41001 3226 48
2482264 2482264 2022-05-07 Baker Oregon 41001 3226 48
2479006 2479006 2022-05-06 Baker Oregon 41001 3226 48
2475748 2475748 2022-05-05 Baker Oregon 41001 3220 48
2472491 2472491 2022-05-04 Baker Oregon 41001 3219 48
2469235 2469235 2022-05-03 Baker Oregon 41001 3217 48
2465979 2465979 2022-05-02 Baker Oregon 41001 3217 48
2462724 2462724 2022-05-01 Baker Oregon 41001 3215 48
2459468 2459468 2022-04-30 Baker Oregon 41001 3215 48
2456212 2456212 2022-04-29 Baker Oregon 41001 3215 48
2452956 2452956 2022-04-28 Baker Oregon 41001 3214 48
2449700 2449700 2022-04-27 Baker Oregon 41001 3214 48
2446443 2446443 2022-04-26 Baker Oregon 41001 3214 48
2443188 2443188 2022-04-25 Baker Oregon 41001 3214 48
2439932 2439932 2022-04-24 Baker Oregon 41001 3214 48
2436676 2436676 2022-04-23 Baker Oregon 41001 3214 48
2433420 2433420 2022-04-22 Baker Oregon 41001 3214 48
2430164 2430164 2022-04-21 Baker Oregon 41001 3214 48
2426908 2426908 2022-04-20 Baker Oregon 41001 3212 48
2423652 2423652 2022-04-19 Baker Oregon 41001 3210 48
2420395 2420395 2022-04-18 Baker Oregon 41001 3210 48
2417140 2417140 2022-04-17 Baker Oregon 41001 3210 48
2413884 2413884 2022-04-16 Baker Oregon 41001 3210 48
2410628 2410628 2022-04-15 Baker Oregon 41001 3210 48
2407372 2407372 2022-04-14 Baker Oregon 41001 3210 48
2404116 2404116 2022-04-13 Baker Oregon 41001 3210 48
2400861 2400861 2022-04-12 Baker Oregon 41001 3210 48
2397606 2397606 2022-04-11 Baker Oregon 41001 3210 48
2394351 2394351 2022-04-10 Baker Oregon 41001 3209 48
2391095 2391095 2022-04-09 Baker Oregon 41001 3209 48
2387839 2387839 2022-04-08 Baker Oregon 41001 3209 48
2384584 2384584 2022-04-07 Baker Oregon 41001 3209 48
2381329 2381329 2022-04-06 Baker Oregon 41001 3208 48
2378074 2378074 2022-04-05 Baker Oregon 41001 3208 48
2374820 2374820 2022-04-04 Baker Oregon 41001 3208 48
2371568 2371568 2022-04-03 Baker Oregon 41001 3204 46
2368315 2368315 2022-04-02 Baker Oregon 41001 3204 46
2365062 2365062 2022-04-01 Baker Oregon 41001 3204 46
2361809 2361809 2022-03-31 Baker Oregon 41001 3204 46
2358555 2358555 2022-03-30 Baker Oregon 41001 3204 46
2355301 2355301 2022-03-29 Baker Oregon 41001 3204 46
2352048 2352048 2022-03-28 Baker Oregon 41001 3204 46
2348796 2348796 2022-03-27 Baker Oregon 41001 3204 46
2345543 2345543 2022-03-26 Baker Oregon 41001 3204 46
2342290 2342290 2022-03-25 Baker Oregon 41001 3204 46
2339037 2339037 2022-03-24 Baker Oregon 41001 3204 46
2335783 2335783 2022-03-23 Baker Oregon 41001 3204 46
2332529 2332529 2022-03-22 Baker Oregon 41001 3204 46
2329276 2329276 2022-03-21 Baker Oregon 41001 3204 46
2326024 2326024 2022-03-20 Baker Oregon 41001 3204 46
2322771 2322771 2022-03-19 Baker Oregon 41001 3204 46
2319517 2319517 2022-03-18 Baker Oregon 41001 3204 46
2316263 2316263 2022-03-17 Baker Oregon 41001 3203 46
2313010 2313010 2022-03-16 Baker Oregon 41001 3203 46
2309757 2309757 2022-03-15 Baker Oregon 41001 3203 46
2306504 2306504 2022-03-14 Baker Oregon 41001 3203 46
2303253 2303253 2022-03-13 Baker Oregon 41001 3200 46
2300001 2300001 2022-03-12 Baker Oregon 41001 3200 46
2296749 2296749 2022-03-11 Baker Oregon 41001 3200 46
2293497 2293497 2022-03-10 Baker Oregon 41001 3200 46
2290245 2290245 2022-03-09 Baker Oregon 41001 3198 46
2286993 2286993 2022-03-08 Baker Oregon 41001 3197 46
2283741 2283741 2022-03-07 Baker Oregon 41001 3196 46
2280489 2280489 2022-03-06 Baker Oregon 41001 3194 46
2277236 2277236 2022-03-05 Baker Oregon 41001 3194 46
2273983 2273983 2022-03-04 Baker Oregon 41001 3194 46
2270730 2270730 2022-03-03 Baker Oregon 41001 3194 46
2267478 2267478 2022-03-02 Baker Oregon 41001 3193 46
2264225 2264225 2022-03-01 Baker Oregon 41001 3190 46
2260975 2260975 2022-02-28 Baker Oregon 41001 3186 46
2257724 2257724 2022-02-27 Baker Oregon 41001 3181 46
2254473 2254473 2022-02-26 Baker Oregon 41001 3181 46
2251222 2251222 2022-02-25 Baker Oregon 41001 3181 46
2247971 2247971 2022-02-24 Baker Oregon 41001 3176 46
2244720 2244720 2022-02-23 Baker Oregon 41001 3170 46
2241469 2241469 2022-02-22 Baker Oregon 41001 3168 45
2238218 2238218 2022-02-21 Baker Oregon 41001 3153 45
2234967 2234967 2022-02-20 Baker Oregon 41001 3153 45
2231716 2231716 2022-02-19 Baker Oregon 41001 3153 45
2228465 2228465 2022-02-18 Baker Oregon 41001 3153 45
2225214 2225214 2022-02-17 Baker Oregon 41001 3141 44
2221963 2221963 2022-02-16 Baker Oregon 41001 3138 44
2218712 2218712 2022-02-15 Baker Oregon 41001 3128 44
2215461 2215461 2022-02-14 Baker Oregon 41001 3126 44
2212210 2212210 2022-02-13 Baker Oregon 41001 3110 44
2208957 2208957 2022-02-12 Baker Oregon 41001 3110 44
2205704 2205704 2022-02-11 Baker Oregon 41001 3110 44
2202451 2202451 2022-02-10 Baker Oregon 41001 3099 43
2199197 2199197 2022-02-09 Baker Oregon 41001 3083 43
2195943 2195943 2022-02-08 Baker Oregon 41001 3064 43
2192689 2192689 2022-02-07 Baker Oregon 41001 3061 42
2189435 2189435 2022-02-06 Baker Oregon 41001 3039 42
2186182 2186182 2022-02-05 Baker Oregon 41001 3039 42
2182930 2182930 2022-02-04 Baker Oregon 41001 3039 42
2179678 2179678 2022-02-03 Baker Oregon 41001 3016 42

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