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

780 rows where county = "Lincoln" 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 · 780 ✖

fips 1

county 1

  • Lincoln · 780 ✖
Link rowid date ▲ county state fips cases deaths
2501831 2501831 2022-05-13 Lincoln Oregon 41041 7223 85
2498573 2498573 2022-05-12 Lincoln Oregon 41041 7211 85
2495315 2495315 2022-05-11 Lincoln Oregon 41041 7196 85
2492057 2492057 2022-05-10 Lincoln Oregon 41041 7182 85
2488799 2488799 2022-05-09 Lincoln Oregon 41041 7168 85
2485542 2485542 2022-05-08 Lincoln Oregon 41041 7145 85
2482284 2482284 2022-05-07 Lincoln Oregon 41041 7145 85
2479026 2479026 2022-05-06 Lincoln Oregon 41041 7145 85
2475768 2475768 2022-05-05 Lincoln Oregon 41041 7135 85
2472511 2472511 2022-05-04 Lincoln Oregon 41041 7124 85
2469255 2469255 2022-05-03 Lincoln Oregon 41041 7121 85
2465999 2465999 2022-05-02 Lincoln Oregon 41041 7111 85
2462744 2462744 2022-05-01 Lincoln Oregon 41041 7091 85
2459488 2459488 2022-04-30 Lincoln Oregon 41041 7091 85
2456232 2456232 2022-04-29 Lincoln Oregon 41041 7091 85
2452976 2452976 2022-04-28 Lincoln Oregon 41041 7083 85
2449720 2449720 2022-04-27 Lincoln Oregon 41041 7073 85
2446463 2446463 2022-04-26 Lincoln Oregon 41041 7070 86
2443208 2443208 2022-04-25 Lincoln Oregon 41041 7070 86
2439952 2439952 2022-04-24 Lincoln Oregon 41041 7061 86
2436696 2436696 2022-04-23 Lincoln Oregon 41041 7061 86
2433440 2433440 2022-04-22 Lincoln Oregon 41041 7061 86
2430184 2430184 2022-04-21 Lincoln Oregon 41041 7057 86
2426928 2426928 2022-04-20 Lincoln Oregon 41041 7052 86
2423672 2423672 2022-04-19 Lincoln Oregon 41041 7048 86
2420415 2420415 2022-04-18 Lincoln Oregon 41041 7038 84
2417160 2417160 2022-04-17 Lincoln Oregon 41041 7038 84
2413904 2413904 2022-04-16 Lincoln Oregon 41041 7038 84
2410648 2410648 2022-04-15 Lincoln Oregon 41041 7038 84
2407392 2407392 2022-04-14 Lincoln Oregon 41041 7034 84
2404136 2404136 2022-04-13 Lincoln Oregon 41041 7032 84
2400881 2400881 2022-04-12 Lincoln Oregon 41041 7027 84
2397626 2397626 2022-04-11 Lincoln Oregon 41041 7027 83
2394371 2394371 2022-04-10 Lincoln Oregon 41041 7017 83
2391115 2391115 2022-04-09 Lincoln Oregon 41041 7017 83
2387859 2387859 2022-04-08 Lincoln Oregon 41041 7017 83
2384604 2384604 2022-04-07 Lincoln Oregon 41041 7013 82
2381349 2381349 2022-04-06 Lincoln Oregon 41041 7009 82
2378094 2378094 2022-04-05 Lincoln Oregon 41041 7006 82
2374840 2374840 2022-04-04 Lincoln Oregon 41041 7006 82
2371588 2371588 2022-04-03 Lincoln Oregon 41041 7000 81
2368335 2368335 2022-04-02 Lincoln Oregon 41041 7000 81
2365082 2365082 2022-04-01 Lincoln Oregon 41041 7000 81
2361829 2361829 2022-03-31 Lincoln Oregon 41041 6995 81
2358575 2358575 2022-03-30 Lincoln Oregon 41041 6995 81
2355321 2355321 2022-03-29 Lincoln Oregon 41041 6992 80
2352068 2352068 2022-03-28 Lincoln Oregon 41041 6992 79
2348816 2348816 2022-03-27 Lincoln Oregon 41041 6989 79
2345563 2345563 2022-03-26 Lincoln Oregon 41041 6989 79
2342310 2342310 2022-03-25 Lincoln Oregon 41041 6989 79
2339057 2339057 2022-03-24 Lincoln Oregon 41041 6989 79
2335803 2335803 2022-03-23 Lincoln Oregon 41041 6988 79
2332549 2332549 2022-03-22 Lincoln Oregon 41041 6988 79
2329296 2329296 2022-03-21 Lincoln Oregon 41041 6987 79
2326044 2326044 2022-03-20 Lincoln Oregon 41041 6984 79
2322791 2322791 2022-03-19 Lincoln Oregon 41041 6984 79
2319537 2319537 2022-03-18 Lincoln Oregon 41041 6984 79
2316283 2316283 2022-03-17 Lincoln Oregon 41041 6982 79
2313030 2313030 2022-03-16 Lincoln Oregon 41041 6981 79
2309777 2309777 2022-03-15 Lincoln Oregon 41041 6976 78
2306524 2306524 2022-03-14 Lincoln Oregon 41041 6972 78
2303273 2303273 2022-03-13 Lincoln Oregon 41041 6969 78
2300021 2300021 2022-03-12 Lincoln Oregon 41041 6969 78
2296769 2296769 2022-03-11 Lincoln Oregon 41041 6969 78
2293517 2293517 2022-03-10 Lincoln Oregon 41041 6959 78
2290265 2290265 2022-03-09 Lincoln Oregon 41041 6956 76
2287013 2287013 2022-03-08 Lincoln Oregon 41041 6947 75
2283761 2283761 2022-03-07 Lincoln Oregon 41041 6944 74
2280509 2280509 2022-03-06 Lincoln Oregon 41041 6931 73
2277256 2277256 2022-03-05 Lincoln Oregon 41041 6931 73
2274003 2274003 2022-03-04 Lincoln Oregon 41041 6931 73
2270750 2270750 2022-03-03 Lincoln Oregon 41041 6924 73
2267498 2267498 2022-03-02 Lincoln Oregon 41041 6919 73
2264245 2264245 2022-03-01 Lincoln Oregon 41041 6914 72
2260995 2260995 2022-02-28 Lincoln Oregon 41041 6904 71
2257744 2257744 2022-02-27 Lincoln Oregon 41041 6877 70
2254493 2254493 2022-02-26 Lincoln Oregon 41041 6877 70
2251242 2251242 2022-02-25 Lincoln Oregon 41041 6877 70
2247991 2247991 2022-02-24 Lincoln Oregon 41041 6860 70
2244740 2244740 2022-02-23 Lincoln Oregon 41041 6842 69
2241489 2241489 2022-02-22 Lincoln Oregon 41041 6828 69
2238238 2238238 2022-02-21 Lincoln Oregon 41041 6791 66
2234987 2234987 2022-02-20 Lincoln Oregon 41041 6791 66
2231736 2231736 2022-02-19 Lincoln Oregon 41041 6791 66
2228485 2228485 2022-02-18 Lincoln Oregon 41041 6791 66
2225234 2225234 2022-02-17 Lincoln Oregon 41041 6766 66
2221983 2221983 2022-02-16 Lincoln Oregon 41041 6733 66
2218732 2218732 2022-02-15 Lincoln Oregon 41041 6705 66
2215481 2215481 2022-02-14 Lincoln Oregon 41041 6683 66
2212230 2212230 2022-02-13 Lincoln Oregon 41041 6621 66
2208977 2208977 2022-02-12 Lincoln Oregon 41041 6621 66
2205724 2205724 2022-02-11 Lincoln Oregon 41041 6621 66
2202471 2202471 2022-02-10 Lincoln Oregon 41041 6584 66
2199217 2199217 2022-02-09 Lincoln Oregon 41041 6540 65
2195963 2195963 2022-02-08 Lincoln Oregon 41041 6486 65
2192709 2192709 2022-02-07 Lincoln Oregon 41041 6433 65
2189455 2189455 2022-02-06 Lincoln Oregon 41041 6324 65
2186202 2186202 2022-02-05 Lincoln Oregon 41041 6324 65
2182950 2182950 2022-02-04 Lincoln Oregon 41041 6324 65
2179698 2179698 2022-02-03 Lincoln Oregon 41041 6206 65

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