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 county = "McClain" 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

county 1

  • McClain · 786 ✖
Link rowid date ▲ county state fips cases deaths
2501779 2501779 2022-05-13 McClain Oklahoma 40087 11773 137
2498521 2498521 2022-05-12 McClain Oklahoma 40087 11773 137
2495263 2495263 2022-05-11 McClain Oklahoma 40087 11757 134
2492005 2492005 2022-05-10 McClain Oklahoma 40087 11757 134
2488747 2488747 2022-05-09 McClain Oklahoma 40087 11757 134
2485490 2485490 2022-05-08 McClain Oklahoma 40087 11757 134
2482232 2482232 2022-05-07 McClain Oklahoma 40087 11757 134
2478974 2478974 2022-05-06 McClain Oklahoma 40087 11757 134
2475716 2475716 2022-05-05 McClain Oklahoma 40087 11757 134
2472459 2472459 2022-05-04 McClain Oklahoma 40087 11655 133
2469203 2469203 2022-05-03 McClain Oklahoma 40087 11655 133
2465947 2465947 2022-05-02 McClain Oklahoma 40087 11655 133
2462692 2462692 2022-05-01 McClain Oklahoma 40087 11655 133
2459436 2459436 2022-04-30 McClain Oklahoma 40087 11655 133
2456180 2456180 2022-04-29 McClain Oklahoma 40087 11655 133
2452924 2452924 2022-04-28 McClain Oklahoma 40087 11655 133
2449668 2449668 2022-04-27 McClain Oklahoma 40087 11650 133
2446411 2446411 2022-04-26 McClain Oklahoma 40087 11650 133
2443156 2443156 2022-04-25 McClain Oklahoma 40087 11650 133
2439900 2439900 2022-04-24 McClain Oklahoma 40087 11650 133
2436644 2436644 2022-04-23 McClain Oklahoma 40087 11650 133
2433388 2433388 2022-04-22 McClain Oklahoma 40087 11650 133
2430132 2430132 2022-04-21 McClain Oklahoma 40087 11650 133
2426876 2426876 2022-04-20 McClain Oklahoma 40087 11638 132
2423620 2423620 2022-04-19 McClain Oklahoma 40087 11638 132
2420363 2420363 2022-04-18 McClain Oklahoma 40087 11638 132
2417108 2417108 2022-04-17 McClain Oklahoma 40087 11638 132
2413852 2413852 2022-04-16 McClain Oklahoma 40087 11638 132
2410596 2410596 2022-04-15 McClain Oklahoma 40087 11638 132
2407340 2407340 2022-04-14 McClain Oklahoma 40087 11638 132
2404084 2404084 2022-04-13 McClain Oklahoma 40087 11624 132
2400829 2400829 2022-04-12 McClain Oklahoma 40087 11624 132
2397574 2397574 2022-04-11 McClain Oklahoma 40087 11624 132
2394319 2394319 2022-04-10 McClain Oklahoma 40087 11624 132
2391063 2391063 2022-04-09 McClain Oklahoma 40087 11624 132
2387807 2387807 2022-04-08 McClain Oklahoma 40087 11624 132
2384552 2384552 2022-04-07 McClain Oklahoma 40087 11624 132
2381297 2381297 2022-04-06 McClain Oklahoma 40087 11601 132
2378042 2378042 2022-04-05 McClain Oklahoma 40087 11601 132
2374788 2374788 2022-04-04 McClain Oklahoma 40087 11601 132
2371536 2371536 2022-04-03 McClain Oklahoma 40087 11601 132
2368283 2368283 2022-04-02 McClain Oklahoma 40087 11601 132
2365030 2365030 2022-04-01 McClain Oklahoma 40087 11601 132
2361777 2361777 2022-03-31 McClain Oklahoma 40087 11601 132
2358523 2358523 2022-03-30 McClain Oklahoma 40087 11611 131
2355269 2355269 2022-03-29 McClain Oklahoma 40087 11611 131
2352016 2352016 2022-03-28 McClain Oklahoma 40087 11611 131
2348764 2348764 2022-03-27 McClain Oklahoma 40087 11611 131
2345511 2345511 2022-03-26 McClain Oklahoma 40087 11611 131
2342258 2342258 2022-03-25 McClain Oklahoma 40087 11611 131
2339005 2339005 2022-03-24 McClain Oklahoma 40087 11611 131
2335751 2335751 2022-03-23 McClain Oklahoma 40087 11589 131
2332497 2332497 2022-03-22 McClain Oklahoma 40087 11589 131
2329244 2329244 2022-03-21 McClain Oklahoma 40087 11589 131
2325992 2325992 2022-03-20 McClain Oklahoma 40087 11589 131
2322739 2322739 2022-03-19 McClain Oklahoma 40087 11589 131
2319485 2319485 2022-03-18 McClain Oklahoma 40087 11589 131
2316231 2316231 2022-03-17 McClain Oklahoma 40087 11589 131
2312978 2312978 2022-03-16 McClain Oklahoma 40087 11549 128
2309725 2309725 2022-03-15 McClain Oklahoma 40087 11549 128
2306472 2306472 2022-03-14 McClain Oklahoma 40087 11549 128
2303221 2303221 2022-03-13 McClain Oklahoma 40087 11549 128
2299969 2299969 2022-03-12 McClain Oklahoma 40087 11549 128
2296717 2296717 2022-03-11 McClain Oklahoma 40087 11549 128
2293465 2293465 2022-03-10 McClain Oklahoma 40087 11549 128
2290213 2290213 2022-03-09 McClain Oklahoma 40087 11523 125
2286961 2286961 2022-03-08 McClain Oklahoma 40087 11523 125
2283709 2283709 2022-03-07 McClain Oklahoma 40087 11523 125
2280457 2280457 2022-03-06 McClain Oklahoma 40087 11523 125
2277204 2277204 2022-03-05 McClain Oklahoma 40087 11523 125
2273951 2273951 2022-03-04 McClain Oklahoma 40087 11523 125
2270698 2270698 2022-03-03 McClain Oklahoma 40087 11523 125
2267446 2267446 2022-03-02 McClain Oklahoma 40087 11523 125
2264193 2264193 2022-03-01 McClain Oklahoma 40087 11474 122
2260943 2260943 2022-02-28 McClain Oklahoma 40087 11474 122
2257692 2257692 2022-02-27 McClain Oklahoma 40087 11474 122
2254441 2254441 2022-02-26 McClain Oklahoma 40087 11474 122
2251190 2251190 2022-02-25 McClain Oklahoma 40087 11474 122
2247939 2247939 2022-02-24 McClain Oklahoma 40087 11474 122
2244688 2244688 2022-02-23 McClain Oklahoma 40087 11474 122
2241437 2241437 2022-02-22 McClain Oklahoma 40087 11397 120
2238186 2238186 2022-02-21 McClain Oklahoma 40087 11397 120
2234935 2234935 2022-02-20 McClain Oklahoma 40087 11397 120
2231684 2231684 2022-02-19 McClain Oklahoma 40087 11397 120
2228433 2228433 2022-02-18 McClain Oklahoma 40087 11397 120
2225182 2225182 2022-02-17 McClain Oklahoma 40087 11397 120
2221931 2221931 2022-02-16 McClain Oklahoma 40087 11397 120
2218680 2218680 2022-02-15 McClain Oklahoma 40087 11297 117
2215429 2215429 2022-02-14 McClain Oklahoma 40087 11297 117
2212178 2212178 2022-02-13 McClain Oklahoma 40087 11297 117
2208925 2208925 2022-02-12 McClain Oklahoma 40087 11297 117
2205672 2205672 2022-02-11 McClain Oklahoma 40087 11297 117
2202419 2202419 2022-02-10 McClain Oklahoma 40087 11297 117
2199165 2199165 2022-02-09 McClain Oklahoma 40087 11297 117
2195911 2195911 2022-02-08 McClain Oklahoma 40087 11079 115
2192657 2192657 2022-02-07 McClain Oklahoma 40087 11079 115
2189403 2189403 2022-02-06 McClain Oklahoma 40087 11079 115
2186150 2186150 2022-02-05 McClain Oklahoma 40087 11079 115
2182898 2182898 2022-02-04 McClain Oklahoma 40087 11079 115
2179646 2179646 2022-02-03 McClain Oklahoma 40087 11079 115

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