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 = 41065 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

  • 41065 · 779 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501843 2501843 2022-05-13 Wasco Oregon 41065 5218 63
2498585 2498585 2022-05-12 Wasco Oregon 41065 5212 63
2495327 2495327 2022-05-11 Wasco Oregon 41065 5205 63
2492069 2492069 2022-05-10 Wasco Oregon 41065 5201 63
2488811 2488811 2022-05-09 Wasco Oregon 41065 5194 63
2485554 2485554 2022-05-08 Wasco Oregon 41065 5188 63
2482296 2482296 2022-05-07 Wasco Oregon 41065 5188 63
2479038 2479038 2022-05-06 Wasco Oregon 41065 5188 63
2475780 2475780 2022-05-05 Wasco Oregon 41065 5184 63
2472523 2472523 2022-05-04 Wasco Oregon 41065 5182 63
2469267 2469267 2022-05-03 Wasco Oregon 41065 5180 63
2466011 2466011 2022-05-02 Wasco Oregon 41065 5176 63
2462756 2462756 2022-05-01 Wasco Oregon 41065 5172 63
2459500 2459500 2022-04-30 Wasco Oregon 41065 5172 63
2456244 2456244 2022-04-29 Wasco Oregon 41065 5172 63
2452988 2452988 2022-04-28 Wasco Oregon 41065 5167 63
2449732 2449732 2022-04-27 Wasco Oregon 41065 5164 63
2446475 2446475 2022-04-26 Wasco Oregon 41065 5160 62
2443220 2443220 2022-04-25 Wasco Oregon 41065 5153 62
2439964 2439964 2022-04-24 Wasco Oregon 41065 5151 61
2436708 2436708 2022-04-23 Wasco Oregon 41065 5151 61
2433452 2433452 2022-04-22 Wasco Oregon 41065 5151 61
2430196 2430196 2022-04-21 Wasco Oregon 41065 5149 61
2426940 2426940 2022-04-20 Wasco Oregon 41065 5147 60
2423684 2423684 2022-04-19 Wasco Oregon 41065 5145 60
2420428 2420428 2022-04-18 Wasco Oregon 41065 5138 60
2417172 2417172 2022-04-17 Wasco Oregon 41065 5138 60
2413916 2413916 2022-04-16 Wasco Oregon 41065 5138 60
2410660 2410660 2022-04-15 Wasco Oregon 41065 5138 60
2407404 2407404 2022-04-14 Wasco Oregon 41065 5136 60
2404148 2404148 2022-04-13 Wasco Oregon 41065 5135 60
2400893 2400893 2022-04-12 Wasco Oregon 41065 5134 60
2397638 2397638 2022-04-11 Wasco Oregon 41065 5130 60
2394383 2394383 2022-04-10 Wasco Oregon 41065 5128 60
2391127 2391127 2022-04-09 Wasco Oregon 41065 5128 60
2387871 2387871 2022-04-08 Wasco Oregon 41065 5128 60
2384616 2384616 2022-04-07 Wasco Oregon 41065 5124 60
2381361 2381361 2022-04-06 Wasco Oregon 41065 5123 60
2378106 2378106 2022-04-05 Wasco Oregon 41065 5120 60
2374852 2374852 2022-04-04 Wasco Oregon 41065 5119 60
2371600 2371600 2022-04-03 Wasco Oregon 41065 5119 60
2368347 2368347 2022-04-02 Wasco Oregon 41065 5119 60
2365094 2365094 2022-04-01 Wasco Oregon 41065 5119 60
2361841 2361841 2022-03-31 Wasco Oregon 41065 5117 60
2358587 2358587 2022-03-30 Wasco Oregon 41065 5116 60
2355333 2355333 2022-03-29 Wasco Oregon 41065 5115 60
2352080 2352080 2022-03-28 Wasco Oregon 41065 5112 60
2348828 2348828 2022-03-27 Wasco Oregon 41065 5109 59
2345575 2345575 2022-03-26 Wasco Oregon 41065 5109 59
2342322 2342322 2022-03-25 Wasco Oregon 41065 5109 59
2339069 2339069 2022-03-24 Wasco Oregon 41065 5109 59
2335815 2335815 2022-03-23 Wasco Oregon 41065 5106 58
2332561 2332561 2022-03-22 Wasco Oregon 41065 5105 58
2329308 2329308 2022-03-21 Wasco Oregon 41065 5102 58
2326056 2326056 2022-03-20 Wasco Oregon 41065 5102 58
2322803 2322803 2022-03-19 Wasco Oregon 41065 5102 58
2319549 2319549 2022-03-18 Wasco Oregon 41065 5102 58
2316295 2316295 2022-03-17 Wasco Oregon 41065 5100 58
2313042 2313042 2022-03-16 Wasco Oregon 41065 5097 57
2309789 2309789 2022-03-15 Wasco Oregon 41065 5094 57
2306536 2306536 2022-03-14 Wasco Oregon 41065 5090 57
2303285 2303285 2022-03-13 Wasco Oregon 41065 5086 57
2300033 2300033 2022-03-12 Wasco Oregon 41065 5086 57
2296781 2296781 2022-03-11 Wasco Oregon 41065 5086 57
2293529 2293529 2022-03-10 Wasco Oregon 41065 5083 56
2290277 2290277 2022-03-09 Wasco Oregon 41065 5081 56
2287025 2287025 2022-03-08 Wasco Oregon 41065 5078 56
2283773 2283773 2022-03-07 Wasco Oregon 41065 5073 55
2280521 2280521 2022-03-06 Wasco Oregon 41065 5064 55
2277268 2277268 2022-03-05 Wasco Oregon 41065 5064 55
2274015 2274015 2022-03-04 Wasco Oregon 41065 5064 55
2270762 2270762 2022-03-03 Wasco Oregon 41065 5060 53
2267510 2267510 2022-03-02 Wasco Oregon 41065 5051 53
2264257 2264257 2022-03-01 Wasco Oregon 41065 5047 53
2261007 2261007 2022-02-28 Wasco Oregon 41065 5037 53
2257756 2257756 2022-02-27 Wasco Oregon 41065 5031 53
2254505 2254505 2022-02-26 Wasco Oregon 41065 5031 53
2251254 2251254 2022-02-25 Wasco Oregon 41065 5031 53
2248003 2248003 2022-02-24 Wasco Oregon 41065 5027 53
2244752 2244752 2022-02-23 Wasco Oregon 41065 5021 53
2241501 2241501 2022-02-22 Wasco Oregon 41065 4995 53
2238250 2238250 2022-02-21 Wasco Oregon 41065 4978 53
2234999 2234999 2022-02-20 Wasco Oregon 41065 4978 53
2231748 2231748 2022-02-19 Wasco Oregon 41065 4978 53
2228497 2228497 2022-02-18 Wasco Oregon 41065 4978 53
2225246 2225246 2022-02-17 Wasco Oregon 41065 4968 53
2221995 2221995 2022-02-16 Wasco Oregon 41065 4948 53
2218744 2218744 2022-02-15 Wasco Oregon 41065 4924 53
2215493 2215493 2022-02-14 Wasco Oregon 41065 4907 53
2212242 2212242 2022-02-13 Wasco Oregon 41065 4886 53
2208989 2208989 2022-02-12 Wasco Oregon 41065 4886 53
2205736 2205736 2022-02-11 Wasco Oregon 41065 4886 53
2202483 2202483 2022-02-10 Wasco Oregon 41065 4877 53
2199229 2199229 2022-02-09 Wasco Oregon 41065 4848 53
2195975 2195975 2022-02-08 Wasco Oregon 41065 4827 53
2192721 2192721 2022-02-07 Wasco Oregon 41065 4798 53
2189467 2189467 2022-02-06 Wasco Oregon 41065 4762 53
2186214 2186214 2022-02-05 Wasco Oregon 41065 4762 53
2182962 2182962 2022-02-04 Wasco Oregon 41065 4762 53
2179710 2179710 2022-02-03 Wasco Oregon 41065 4731 53

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