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 county = "Ottawa" and fips = 40115 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

  • 40115 · 779 ✖

county 1

  • Ottawa · 779 ✖
Link rowid date ▲ county state fips cases deaths
2501790 2501790 2022-05-13 Ottawa Oklahoma 40115 9204 127
2498532 2498532 2022-05-12 Ottawa Oklahoma 40115 9204 127
2495274 2495274 2022-05-11 Ottawa Oklahoma 40115 9199 127
2492016 2492016 2022-05-10 Ottawa Oklahoma 40115 9199 127
2488758 2488758 2022-05-09 Ottawa Oklahoma 40115 9199 127
2485501 2485501 2022-05-08 Ottawa Oklahoma 40115 9199 127
2482243 2482243 2022-05-07 Ottawa Oklahoma 40115 9199 127
2478985 2478985 2022-05-06 Ottawa Oklahoma 40115 9199 127
2475727 2475727 2022-05-05 Ottawa Oklahoma 40115 9199 127
2472470 2472470 2022-05-04 Ottawa Oklahoma 40115 9191 127
2469214 2469214 2022-05-03 Ottawa Oklahoma 40115 9191 127
2465958 2465958 2022-05-02 Ottawa Oklahoma 40115 9191 127
2462703 2462703 2022-05-01 Ottawa Oklahoma 40115 9191 127
2459447 2459447 2022-04-30 Ottawa Oklahoma 40115 9191 127
2456191 2456191 2022-04-29 Ottawa Oklahoma 40115 9191 127
2452935 2452935 2022-04-28 Ottawa Oklahoma 40115 9191 127
2449679 2449679 2022-04-27 Ottawa Oklahoma 40115 9189 126
2446422 2446422 2022-04-26 Ottawa Oklahoma 40115 9189 126
2443167 2443167 2022-04-25 Ottawa Oklahoma 40115 9189 126
2439911 2439911 2022-04-24 Ottawa Oklahoma 40115 9189 126
2436655 2436655 2022-04-23 Ottawa Oklahoma 40115 9189 126
2433399 2433399 2022-04-22 Ottawa Oklahoma 40115 9189 126
2430143 2430143 2022-04-21 Ottawa Oklahoma 40115 9189 126
2426887 2426887 2022-04-20 Ottawa Oklahoma 40115 9140 126
2423631 2423631 2022-04-19 Ottawa Oklahoma 40115 9140 126
2420374 2420374 2022-04-18 Ottawa Oklahoma 40115 9140 126
2417119 2417119 2022-04-17 Ottawa Oklahoma 40115 9140 126
2413863 2413863 2022-04-16 Ottawa Oklahoma 40115 9140 126
2410607 2410607 2022-04-15 Ottawa Oklahoma 40115 9140 126
2407351 2407351 2022-04-14 Ottawa Oklahoma 40115 9140 126
2404095 2404095 2022-04-13 Ottawa Oklahoma 40115 9123 124
2400840 2400840 2022-04-12 Ottawa Oklahoma 40115 9123 124
2397585 2397585 2022-04-11 Ottawa Oklahoma 40115 9123 124
2394330 2394330 2022-04-10 Ottawa Oklahoma 40115 9123 124
2391074 2391074 2022-04-09 Ottawa Oklahoma 40115 9123 124
2387818 2387818 2022-04-08 Ottawa Oklahoma 40115 9123 124
2384563 2384563 2022-04-07 Ottawa Oklahoma 40115 9123 124
2381308 2381308 2022-04-06 Ottawa Oklahoma 40115 9121 124
2378053 2378053 2022-04-05 Ottawa Oklahoma 40115 9121 124
2374799 2374799 2022-04-04 Ottawa Oklahoma 40115 9121 124
2371547 2371547 2022-04-03 Ottawa Oklahoma 40115 9121 124
2368294 2368294 2022-04-02 Ottawa Oklahoma 40115 9121 124
2365041 2365041 2022-04-01 Ottawa Oklahoma 40115 9121 124
2361788 2361788 2022-03-31 Ottawa Oklahoma 40115 9121 124
2358534 2358534 2022-03-30 Ottawa Oklahoma 40115 9119 123
2355280 2355280 2022-03-29 Ottawa Oklahoma 40115 9119 123
2352027 2352027 2022-03-28 Ottawa Oklahoma 40115 9119 123
2348775 2348775 2022-03-27 Ottawa Oklahoma 40115 9119 123
2345522 2345522 2022-03-26 Ottawa Oklahoma 40115 9119 123
2342269 2342269 2022-03-25 Ottawa Oklahoma 40115 9119 123
2339016 2339016 2022-03-24 Ottawa Oklahoma 40115 9119 123
2335762 2335762 2022-03-23 Ottawa Oklahoma 40115 9120 122
2332508 2332508 2022-03-22 Ottawa Oklahoma 40115 9120 122
2329255 2329255 2022-03-21 Ottawa Oklahoma 40115 9120 122
2326003 2326003 2022-03-20 Ottawa Oklahoma 40115 9120 122
2322750 2322750 2022-03-19 Ottawa Oklahoma 40115 9120 122
2319496 2319496 2022-03-18 Ottawa Oklahoma 40115 9120 122
2316242 2316242 2022-03-17 Ottawa Oklahoma 40115 9120 122
2312989 2312989 2022-03-16 Ottawa Oklahoma 40115 9116 121
2309736 2309736 2022-03-15 Ottawa Oklahoma 40115 9116 121
2306483 2306483 2022-03-14 Ottawa Oklahoma 40115 9116 121
2303232 2303232 2022-03-13 Ottawa Oklahoma 40115 9116 121
2299980 2299980 2022-03-12 Ottawa Oklahoma 40115 9116 121
2296728 2296728 2022-03-11 Ottawa Oklahoma 40115 9116 121
2293476 2293476 2022-03-10 Ottawa Oklahoma 40115 9116 121
2290224 2290224 2022-03-09 Ottawa Oklahoma 40115 9074 121
2286972 2286972 2022-03-08 Ottawa Oklahoma 40115 9074 121
2283720 2283720 2022-03-07 Ottawa Oklahoma 40115 9074 121
2280468 2280468 2022-03-06 Ottawa Oklahoma 40115 9074 121
2277215 2277215 2022-03-05 Ottawa Oklahoma 40115 9074 121
2273962 2273962 2022-03-04 Ottawa Oklahoma 40115 9074 121
2270709 2270709 2022-03-03 Ottawa Oklahoma 40115 9074 121
2267457 2267457 2022-03-02 Ottawa Oklahoma 40115 9074 121
2264204 2264204 2022-03-01 Ottawa Oklahoma 40115 9025 115
2260954 2260954 2022-02-28 Ottawa Oklahoma 40115 9025 115
2257703 2257703 2022-02-27 Ottawa Oklahoma 40115 9025 115
2254452 2254452 2022-02-26 Ottawa Oklahoma 40115 9025 115
2251201 2251201 2022-02-25 Ottawa Oklahoma 40115 9025 115
2247950 2247950 2022-02-24 Ottawa Oklahoma 40115 9025 115
2244699 2244699 2022-02-23 Ottawa Oklahoma 40115 9025 115
2241448 2241448 2022-02-22 Ottawa Oklahoma 40115 8976 112
2238197 2238197 2022-02-21 Ottawa Oklahoma 40115 8976 112
2234946 2234946 2022-02-20 Ottawa Oklahoma 40115 8976 112
2231695 2231695 2022-02-19 Ottawa Oklahoma 40115 8976 112
2228444 2228444 2022-02-18 Ottawa Oklahoma 40115 8976 112
2225193 2225193 2022-02-17 Ottawa Oklahoma 40115 8976 112
2221942 2221942 2022-02-16 Ottawa Oklahoma 40115 8976 112
2218691 2218691 2022-02-15 Ottawa Oklahoma 40115 8838 112
2215440 2215440 2022-02-14 Ottawa Oklahoma 40115 8838 112
2212189 2212189 2022-02-13 Ottawa Oklahoma 40115 8838 112
2208936 2208936 2022-02-12 Ottawa Oklahoma 40115 8838 112
2205683 2205683 2022-02-11 Ottawa Oklahoma 40115 8838 112
2202430 2202430 2022-02-10 Ottawa Oklahoma 40115 8838 112
2199176 2199176 2022-02-09 Ottawa Oklahoma 40115 8838 112
2195922 2195922 2022-02-08 Ottawa Oklahoma 40115 8588 111
2192668 2192668 2022-02-07 Ottawa Oklahoma 40115 8588 111
2189414 2189414 2022-02-06 Ottawa Oklahoma 40115 8588 111
2186161 2186161 2022-02-05 Ottawa Oklahoma 40115 8588 111
2182909 2182909 2022-02-04 Ottawa Oklahoma 40115 8588 111
2179657 2179657 2022-02-03 Ottawa Oklahoma 40115 8588 111

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