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

786 rows where fips = 40147 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 · 786 ✖

fips 1

  • 40147 · 786 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501807 2501807 2022-05-13 Washington Oklahoma 40147 12718 262
2498549 2498549 2022-05-12 Washington Oklahoma 40147 12718 262
2495291 2495291 2022-05-11 Washington Oklahoma 40147 12698 261
2492033 2492033 2022-05-10 Washington Oklahoma 40147 12698 261
2488775 2488775 2022-05-09 Washington Oklahoma 40147 12698 261
2485518 2485518 2022-05-08 Washington Oklahoma 40147 12698 261
2482260 2482260 2022-05-07 Washington Oklahoma 40147 12698 261
2479002 2479002 2022-05-06 Washington Oklahoma 40147 12698 261
2475744 2475744 2022-05-05 Washington Oklahoma 40147 12698 261
2472487 2472487 2022-05-04 Washington Oklahoma 40147 12690 261
2469231 2469231 2022-05-03 Washington Oklahoma 40147 12690 261
2465975 2465975 2022-05-02 Washington Oklahoma 40147 12690 261
2462720 2462720 2022-05-01 Washington Oklahoma 40147 12690 261
2459464 2459464 2022-04-30 Washington Oklahoma 40147 12690 261
2456208 2456208 2022-04-29 Washington Oklahoma 40147 12690 261
2452952 2452952 2022-04-28 Washington Oklahoma 40147 12690 261
2449696 2449696 2022-04-27 Washington Oklahoma 40147 12677 260
2446439 2446439 2022-04-26 Washington Oklahoma 40147 12677 260
2443184 2443184 2022-04-25 Washington Oklahoma 40147 12677 260
2439928 2439928 2022-04-24 Washington Oklahoma 40147 12677 260
2436672 2436672 2022-04-23 Washington Oklahoma 40147 12677 260
2433416 2433416 2022-04-22 Washington Oklahoma 40147 12677 260
2430160 2430160 2022-04-21 Washington Oklahoma 40147 12677 260
2426904 2426904 2022-04-20 Washington Oklahoma 40147 12673 257
2423648 2423648 2022-04-19 Washington Oklahoma 40147 12673 257
2420391 2420391 2022-04-18 Washington Oklahoma 40147 12673 257
2417136 2417136 2022-04-17 Washington Oklahoma 40147 12673 257
2413880 2413880 2022-04-16 Washington Oklahoma 40147 12673 257
2410624 2410624 2022-04-15 Washington Oklahoma 40147 12673 257
2407368 2407368 2022-04-14 Washington Oklahoma 40147 12673 257
2404112 2404112 2022-04-13 Washington Oklahoma 40147 12669 256
2400857 2400857 2022-04-12 Washington Oklahoma 40147 12669 256
2397602 2397602 2022-04-11 Washington Oklahoma 40147 12669 256
2394347 2394347 2022-04-10 Washington Oklahoma 40147 12669 256
2391091 2391091 2022-04-09 Washington Oklahoma 40147 12669 256
2387835 2387835 2022-04-08 Washington Oklahoma 40147 12669 256
2384580 2384580 2022-04-07 Washington Oklahoma 40147 12669 256
2381325 2381325 2022-04-06 Washington Oklahoma 40147 12658 256
2378070 2378070 2022-04-05 Washington Oklahoma 40147 12658 256
2374816 2374816 2022-04-04 Washington Oklahoma 40147 12658 256
2371564 2371564 2022-04-03 Washington Oklahoma 40147 12658 256
2368311 2368311 2022-04-02 Washington Oklahoma 40147 12658 256
2365058 2365058 2022-04-01 Washington Oklahoma 40147 12658 256
2361805 2361805 2022-03-31 Washington Oklahoma 40147 12658 256
2358551 2358551 2022-03-30 Washington Oklahoma 40147 12648 255
2355297 2355297 2022-03-29 Washington Oklahoma 40147 12648 255
2352044 2352044 2022-03-28 Washington Oklahoma 40147 12648 255
2348792 2348792 2022-03-27 Washington Oklahoma 40147 12648 255
2345539 2345539 2022-03-26 Washington Oklahoma 40147 12648 255
2342286 2342286 2022-03-25 Washington Oklahoma 40147 12648 255
2339033 2339033 2022-03-24 Washington Oklahoma 40147 12648 255
2335779 2335779 2022-03-23 Washington Oklahoma 40147 12640 248
2332525 2332525 2022-03-22 Washington Oklahoma 40147 12640 248
2329272 2329272 2022-03-21 Washington Oklahoma 40147 12640 248
2326020 2326020 2022-03-20 Washington Oklahoma 40147 12640 248
2322767 2322767 2022-03-19 Washington Oklahoma 40147 12640 248
2319513 2319513 2022-03-18 Washington Oklahoma 40147 12640 248
2316259 2316259 2022-03-17 Washington Oklahoma 40147 12640 248
2313006 2313006 2022-03-16 Washington Oklahoma 40147 12631 242
2309753 2309753 2022-03-15 Washington Oklahoma 40147 12631 242
2306500 2306500 2022-03-14 Washington Oklahoma 40147 12631 242
2303249 2303249 2022-03-13 Washington Oklahoma 40147 12631 242
2299997 2299997 2022-03-12 Washington Oklahoma 40147 12631 242
2296745 2296745 2022-03-11 Washington Oklahoma 40147 12631 242
2293493 2293493 2022-03-10 Washington Oklahoma 40147 12631 242
2290241 2290241 2022-03-09 Washington Oklahoma 40147 12590 239
2286989 2286989 2022-03-08 Washington Oklahoma 40147 12590 239
2283737 2283737 2022-03-07 Washington Oklahoma 40147 12590 239
2280485 2280485 2022-03-06 Washington Oklahoma 40147 12590 239
2277232 2277232 2022-03-05 Washington Oklahoma 40147 12590 239
2273979 2273979 2022-03-04 Washington Oklahoma 40147 12590 239
2270726 2270726 2022-03-03 Washington Oklahoma 40147 12590 239
2267474 2267474 2022-03-02 Washington Oklahoma 40147 12590 239
2264221 2264221 2022-03-01 Washington Oklahoma 40147 12553 236
2260971 2260971 2022-02-28 Washington Oklahoma 40147 12553 236
2257720 2257720 2022-02-27 Washington Oklahoma 40147 12553 236
2254469 2254469 2022-02-26 Washington Oklahoma 40147 12553 236
2251218 2251218 2022-02-25 Washington Oklahoma 40147 12553 236
2247967 2247967 2022-02-24 Washington Oklahoma 40147 12553 236
2244716 2244716 2022-02-23 Washington Oklahoma 40147 12553 236
2241465 2241465 2022-02-22 Washington Oklahoma 40147 12466 231
2238214 2238214 2022-02-21 Washington Oklahoma 40147 12466 231
2234963 2234963 2022-02-20 Washington Oklahoma 40147 12466 231
2231712 2231712 2022-02-19 Washington Oklahoma 40147 12466 231
2228461 2228461 2022-02-18 Washington Oklahoma 40147 12466 231
2225210 2225210 2022-02-17 Washington Oklahoma 40147 12466 231
2221959 2221959 2022-02-16 Washington Oklahoma 40147 12466 231
2218708 2218708 2022-02-15 Washington Oklahoma 40147 12246 225
2215457 2215457 2022-02-14 Washington Oklahoma 40147 12246 225
2212206 2212206 2022-02-13 Washington Oklahoma 40147 12246 225
2208953 2208953 2022-02-12 Washington Oklahoma 40147 12246 225
2205700 2205700 2022-02-11 Washington Oklahoma 40147 12246 225
2202447 2202447 2022-02-10 Washington Oklahoma 40147 12246 225
2199193 2199193 2022-02-09 Washington Oklahoma 40147 12246 225
2195939 2195939 2022-02-08 Washington Oklahoma 40147 11939 224
2192685 2192685 2022-02-07 Washington Oklahoma 40147 11939 224
2189431 2189431 2022-02-06 Washington Oklahoma 40147 11939 224
2186178 2186178 2022-02-05 Washington Oklahoma 40147 11939 224
2182926 2182926 2022-02-04 Washington Oklahoma 40147 11939 224
2179674 2179674 2022-02-03 Washington Oklahoma 40147 11939 224

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