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 fips = 40017 and state = "Oklahoma" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Oklahoma · 789 ✖

fips 1

  • 40017 · 789 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501741 2501741 2022-05-13 Canadian Oklahoma 40017 39889 390
2498483 2498483 2022-05-12 Canadian Oklahoma 40017 39889 390
2495225 2495225 2022-05-11 Canadian Oklahoma 40017 39776 390
2491967 2491967 2022-05-10 Canadian Oklahoma 40017 39776 390
2488709 2488709 2022-05-09 Canadian Oklahoma 40017 39776 390
2485452 2485452 2022-05-08 Canadian Oklahoma 40017 39776 390
2482194 2482194 2022-05-07 Canadian Oklahoma 40017 39776 390
2478936 2478936 2022-05-06 Canadian Oklahoma 40017 39776 390
2475678 2475678 2022-05-05 Canadian Oklahoma 40017 39776 390
2472421 2472421 2022-05-04 Canadian Oklahoma 40017 39719 388
2469165 2469165 2022-05-03 Canadian Oklahoma 40017 39719 388
2465909 2465909 2022-05-02 Canadian Oklahoma 40017 39719 388
2462654 2462654 2022-05-01 Canadian Oklahoma 40017 39719 388
2459398 2459398 2022-04-30 Canadian Oklahoma 40017 39719 388
2456142 2456142 2022-04-29 Canadian Oklahoma 40017 39719 388
2452886 2452886 2022-04-28 Canadian Oklahoma 40017 39719 388
2449630 2449630 2022-04-27 Canadian Oklahoma 40017 39614 386
2446373 2446373 2022-04-26 Canadian Oklahoma 40017 39614 386
2443118 2443118 2022-04-25 Canadian Oklahoma 40017 39614 386
2439862 2439862 2022-04-24 Canadian Oklahoma 40017 39614 386
2436606 2436606 2022-04-23 Canadian Oklahoma 40017 39614 386
2433350 2433350 2022-04-22 Canadian Oklahoma 40017 39614 386
2430094 2430094 2022-04-21 Canadian Oklahoma 40017 39614 386
2426838 2426838 2022-04-20 Canadian Oklahoma 40017 39499 386
2423582 2423582 2022-04-19 Canadian Oklahoma 40017 39499 386
2420325 2420325 2022-04-18 Canadian Oklahoma 40017 39499 386
2417070 2417070 2022-04-17 Canadian Oklahoma 40017 39499 386
2413814 2413814 2022-04-16 Canadian Oklahoma 40017 39499 386
2410558 2410558 2022-04-15 Canadian Oklahoma 40017 39499 386
2407302 2407302 2022-04-14 Canadian Oklahoma 40017 39499 386
2404046 2404046 2022-04-13 Canadian Oklahoma 40017 39383 385
2400791 2400791 2022-04-12 Canadian Oklahoma 40017 39383 385
2397536 2397536 2022-04-11 Canadian Oklahoma 40017 39383 385
2394281 2394281 2022-04-10 Canadian Oklahoma 40017 39383 385
2391025 2391025 2022-04-09 Canadian Oklahoma 40017 39383 385
2387769 2387769 2022-04-08 Canadian Oklahoma 40017 39383 385
2384514 2384514 2022-04-07 Canadian Oklahoma 40017 39383 385
2381259 2381259 2022-04-06 Canadian Oklahoma 40017 39259 382
2378004 2378004 2022-04-05 Canadian Oklahoma 40017 39259 382
2374750 2374750 2022-04-04 Canadian Oklahoma 40017 39259 382
2371498 2371498 2022-04-03 Canadian Oklahoma 40017 39259 382
2368245 2368245 2022-04-02 Canadian Oklahoma 40017 39259 382
2364992 2364992 2022-04-01 Canadian Oklahoma 40017 39259 382
2361739 2361739 2022-03-31 Canadian Oklahoma 40017 39259 382
2358485 2358485 2022-03-30 Canadian Oklahoma 40017 39163 381
2355231 2355231 2022-03-29 Canadian Oklahoma 40017 39163 381
2351978 2351978 2022-03-28 Canadian Oklahoma 40017 39163 381
2348726 2348726 2022-03-27 Canadian Oklahoma 40017 39163 381
2345473 2345473 2022-03-26 Canadian Oklahoma 40017 39163 381
2342220 2342220 2022-03-25 Canadian Oklahoma 40017 39163 381
2338967 2338967 2022-03-24 Canadian Oklahoma 40017 39163 381
2335713 2335713 2022-03-23 Canadian Oklahoma 40017 39029 374
2332459 2332459 2022-03-22 Canadian Oklahoma 40017 39029 374
2329206 2329206 2022-03-21 Canadian Oklahoma 40017 39029 374
2325954 2325954 2022-03-20 Canadian Oklahoma 40017 39029 374
2322701 2322701 2022-03-19 Canadian Oklahoma 40017 39029 374
2319447 2319447 2022-03-18 Canadian Oklahoma 40017 39029 374
2316193 2316193 2022-03-17 Canadian Oklahoma 40017 39029 374
2312940 2312940 2022-03-16 Canadian Oklahoma 40017 38944 371
2309687 2309687 2022-03-15 Canadian Oklahoma 40017 38944 371
2306434 2306434 2022-03-14 Canadian Oklahoma 40017 38944 371
2303183 2303183 2022-03-13 Canadian Oklahoma 40017 38944 371
2299931 2299931 2022-03-12 Canadian Oklahoma 40017 38944 371
2296679 2296679 2022-03-11 Canadian Oklahoma 40017 38944 371
2293427 2293427 2022-03-10 Canadian Oklahoma 40017 38944 371
2290175 2290175 2022-03-09 Canadian Oklahoma 40017 38719 365
2286923 2286923 2022-03-08 Canadian Oklahoma 40017 38719 365
2283671 2283671 2022-03-07 Canadian Oklahoma 40017 38719 365
2280419 2280419 2022-03-06 Canadian Oklahoma 40017 38719 365
2277166 2277166 2022-03-05 Canadian Oklahoma 40017 38719 365
2273913 2273913 2022-03-04 Canadian Oklahoma 40017 38719 365
2270660 2270660 2022-03-03 Canadian Oklahoma 40017 38719 365
2267408 2267408 2022-03-02 Canadian Oklahoma 40017 38719 365
2264155 2264155 2022-03-01 Canadian Oklahoma 40017 38506 358
2260905 2260905 2022-02-28 Canadian Oklahoma 40017 38506 358
2257654 2257654 2022-02-27 Canadian Oklahoma 40017 38506 358
2254403 2254403 2022-02-26 Canadian Oklahoma 40017 38506 358
2251152 2251152 2022-02-25 Canadian Oklahoma 40017 38506 358
2247901 2247901 2022-02-24 Canadian Oklahoma 40017 38506 358
2244650 2244650 2022-02-23 Canadian Oklahoma 40017 38506 358
2241399 2241399 2022-02-22 Canadian Oklahoma 40017 38287 352
2238148 2238148 2022-02-21 Canadian Oklahoma 40017 38287 352
2234897 2234897 2022-02-20 Canadian Oklahoma 40017 38287 352
2231646 2231646 2022-02-19 Canadian Oklahoma 40017 38287 352
2228395 2228395 2022-02-18 Canadian Oklahoma 40017 38287 352
2225144 2225144 2022-02-17 Canadian Oklahoma 40017 38287 352
2221893 2221893 2022-02-16 Canadian Oklahoma 40017 38287 352
2218642 2218642 2022-02-15 Canadian Oklahoma 40017 37939 346
2215391 2215391 2022-02-14 Canadian Oklahoma 40017 37939 346
2212140 2212140 2022-02-13 Canadian Oklahoma 40017 37939 346
2208887 2208887 2022-02-12 Canadian Oklahoma 40017 37939 346
2205634 2205634 2022-02-11 Canadian Oklahoma 40017 37939 346
2202381 2202381 2022-02-10 Canadian Oklahoma 40017 37939 346
2199127 2199127 2022-02-09 Canadian Oklahoma 40017 37939 346
2195873 2195873 2022-02-08 Canadian Oklahoma 40017 37338 331
2192619 2192619 2022-02-07 Canadian Oklahoma 40017 37338 331
2189365 2189365 2022-02-06 Canadian Oklahoma 40017 37338 331
2186112 2186112 2022-02-05 Canadian Oklahoma 40017 37338 331
2182860 2182860 2022-02-04 Canadian Oklahoma 40017 37338 331
2179608 2179608 2022-02-03 Canadian Oklahoma 40017 37338 331

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