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

789 rows where county = "Benton" 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 · 789 ✖

fips 1

county 1

  • Benton · 789 ✖
Link rowid date ▲ county state fips cases deaths
2501812 2501812 2022-05-13 Benton Oregon 41003 16301 71
2498554 2498554 2022-05-12 Benton Oregon 41003 16234 71
2495296 2495296 2022-05-11 Benton Oregon 41003 16183 71
2492038 2492038 2022-05-10 Benton Oregon 41003 16149 71
2488780 2488780 2022-05-09 Benton Oregon 41003 16078 70
2485523 2485523 2022-05-08 Benton Oregon 41003 15993 70
2482265 2482265 2022-05-07 Benton Oregon 41003 15993 70
2479007 2479007 2022-05-06 Benton Oregon 41003 15993 70
2475749 2475749 2022-05-05 Benton Oregon 41003 15978 70
2472492 2472492 2022-05-04 Benton Oregon 41003 15931 70
2469236 2469236 2022-05-03 Benton Oregon 41003 15902 70
2465980 2465980 2022-05-02 Benton Oregon 41003 15863 70
2462725 2462725 2022-05-01 Benton Oregon 41003 15795 70
2459469 2459469 2022-04-30 Benton Oregon 41003 15795 70
2456213 2456213 2022-04-29 Benton Oregon 41003 15795 70
2452957 2452957 2022-04-28 Benton Oregon 41003 15750 70
2449701 2449701 2022-04-27 Benton Oregon 41003 15711 70
2446444 2446444 2022-04-26 Benton Oregon 41003 15654 70
2443189 2443189 2022-04-25 Benton Oregon 41003 15601 70
2439933 2439933 2022-04-24 Benton Oregon 41003 15530 69
2436677 2436677 2022-04-23 Benton Oregon 41003 15530 69
2433421 2433421 2022-04-22 Benton Oregon 41003 15530 69
2430165 2430165 2022-04-21 Benton Oregon 41003 15518 69
2426909 2426909 2022-04-20 Benton Oregon 41003 15452 69
2423653 2423653 2022-04-19 Benton Oregon 41003 15434 69
2420396 2420396 2022-04-18 Benton Oregon 41003 15344 69
2417141 2417141 2022-04-17 Benton Oregon 41003 15344 69
2413885 2413885 2022-04-16 Benton Oregon 41003 15344 69
2410629 2410629 2022-04-15 Benton Oregon 41003 15344 69
2407373 2407373 2022-04-14 Benton Oregon 41003 15330 69
2404117 2404117 2022-04-13 Benton Oregon 41003 15296 69
2400862 2400862 2022-04-12 Benton Oregon 41003 15268 69
2397607 2397607 2022-04-11 Benton Oregon 41003 15243 69
2394352 2394352 2022-04-10 Benton Oregon 41003 15208 68
2391096 2391096 2022-04-09 Benton Oregon 41003 15208 68
2387840 2387840 2022-04-08 Benton Oregon 41003 15208 68
2384585 2384585 2022-04-07 Benton Oregon 41003 15191 68
2381330 2381330 2022-04-06 Benton Oregon 41003 15171 68
2378075 2378075 2022-04-05 Benton Oregon 41003 15158 68
2374821 2374821 2022-04-04 Benton Oregon 41003 15129 66
2371569 2371569 2022-04-03 Benton Oregon 41003 15102 66
2368316 2368316 2022-04-02 Benton Oregon 41003 15102 66
2365063 2365063 2022-04-01 Benton Oregon 41003 15102 66
2361810 2361810 2022-03-31 Benton Oregon 41003 15080 66
2358556 2358556 2022-03-30 Benton Oregon 41003 15065 66
2355302 2355302 2022-03-29 Benton Oregon 41003 15056 66
2352049 2352049 2022-03-28 Benton Oregon 41003 15046 66
2348797 2348797 2022-03-27 Benton Oregon 41003 15023 66
2345544 2345544 2022-03-26 Benton Oregon 41003 15023 66
2342291 2342291 2022-03-25 Benton Oregon 41003 15023 66
2339038 2339038 2022-03-24 Benton Oregon 41003 15019 66
2335784 2335784 2022-03-23 Benton Oregon 41003 15003 66
2332530 2332530 2022-03-22 Benton Oregon 41003 14994 65
2329277 2329277 2022-03-21 Benton Oregon 41003 14989 65
2326025 2326025 2022-03-20 Benton Oregon 41003 14976 65
2322772 2322772 2022-03-19 Benton Oregon 41003 14976 65
2319518 2319518 2022-03-18 Benton Oregon 41003 14976 65
2316264 2316264 2022-03-17 Benton Oregon 41003 14974 65
2313011 2313011 2022-03-16 Benton Oregon 41003 14963 65
2309758 2309758 2022-03-15 Benton Oregon 41003 14956 65
2306505 2306505 2022-03-14 Benton Oregon 41003 14950 65
2303254 2303254 2022-03-13 Benton Oregon 41003 14946 64
2300002 2300002 2022-03-12 Benton Oregon 41003 14946 64
2296750 2296750 2022-03-11 Benton Oregon 41003 14946 64
2293498 2293498 2022-03-10 Benton Oregon 41003 14942 64
2290246 2290246 2022-03-09 Benton Oregon 41003 14917 63
2286994 2286994 2022-03-08 Benton Oregon 41003 14903 62
2283742 2283742 2022-03-07 Benton Oregon 41003 14887 62
2280490 2280490 2022-03-06 Benton Oregon 41003 14865 62
2277237 2277237 2022-03-05 Benton Oregon 41003 14865 62
2273984 2273984 2022-03-04 Benton Oregon 41003 14865 62
2270731 2270731 2022-03-03 Benton Oregon 41003 14840 62
2267479 2267479 2022-03-02 Benton Oregon 41003 14817 62
2264226 2264226 2022-03-01 Benton Oregon 41003 14792 61
2260976 2260976 2022-02-28 Benton Oregon 41003 14777 61
2257725 2257725 2022-02-27 Benton Oregon 41003 14727 61
2254474 2254474 2022-02-26 Benton Oregon 41003 14727 61
2251223 2251223 2022-02-25 Benton Oregon 41003 14727 61
2247972 2247972 2022-02-24 Benton Oregon 41003 14705 61
2244721 2244721 2022-02-23 Benton Oregon 41003 14677 61
2241470 2241470 2022-02-22 Benton Oregon 41003 14643 61
2238219 2238219 2022-02-21 Benton Oregon 41003 14548 60
2234968 2234968 2022-02-20 Benton Oregon 41003 14548 60
2231717 2231717 2022-02-19 Benton Oregon 41003 14548 60
2228466 2228466 2022-02-18 Benton Oregon 41003 14548 60
2225215 2225215 2022-02-17 Benton Oregon 41003 14498 60
2221964 2221964 2022-02-16 Benton Oregon 41003 14471 59
2218713 2218713 2022-02-15 Benton Oregon 41003 14408 59
2215462 2215462 2022-02-14 Benton Oregon 41003 14377 59
2212211 2212211 2022-02-13 Benton Oregon 41003 14218 59
2208958 2208958 2022-02-12 Benton Oregon 41003 14218 59
2205705 2205705 2022-02-11 Benton Oregon 41003 14218 59
2202452 2202452 2022-02-10 Benton Oregon 41003 14159 59
2199198 2199198 2022-02-09 Benton Oregon 41003 14056 59
2195944 2195944 2022-02-08 Benton Oregon 41003 13949 56
2192690 2192690 2022-02-07 Benton Oregon 41003 13829 55
2189436 2189436 2022-02-06 Benton Oregon 41003 13582 54
2186183 2186183 2022-02-05 Benton Oregon 41003 13582 54
2182931 2182931 2022-02-04 Benton Oregon 41003 13582 54
2179679 2179679 2022-02-03 Benton Oregon 41003 13478 54

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