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

792 rows where county = "Oklahoma" 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 · 792 ✖

fips 1

county 1

  • Oklahoma · 792 ✖
Link rowid date ▲ county state fips cases deaths
2501787 2501787 2022-05-13 Oklahoma Oklahoma 40109 199990 2467
2498529 2498529 2022-05-12 Oklahoma Oklahoma 40109 199990 2467
2495271 2495271 2022-05-11 Oklahoma Oklahoma 40109 199453 2460
2492013 2492013 2022-05-10 Oklahoma Oklahoma 40109 199453 2460
2488755 2488755 2022-05-09 Oklahoma Oklahoma 40109 199453 2460
2485498 2485498 2022-05-08 Oklahoma Oklahoma 40109 199453 2460
2482240 2482240 2022-05-07 Oklahoma Oklahoma 40109 199453 2460
2478982 2478982 2022-05-06 Oklahoma Oklahoma 40109 199453 2460
2475724 2475724 2022-05-05 Oklahoma Oklahoma 40109 199453 2460
2472467 2472467 2022-05-04 Oklahoma Oklahoma 40109 199255 2452
2469211 2469211 2022-05-03 Oklahoma Oklahoma 40109 199255 2452
2465955 2465955 2022-05-02 Oklahoma Oklahoma 40109 199255 2452
2462700 2462700 2022-05-01 Oklahoma Oklahoma 40109 199255 2452
2459444 2459444 2022-04-30 Oklahoma Oklahoma 40109 199255 2452
2456188 2456188 2022-04-29 Oklahoma Oklahoma 40109 199255 2452
2452932 2452932 2022-04-28 Oklahoma Oklahoma 40109 199255 2452
2449676 2449676 2022-04-27 Oklahoma Oklahoma 40109 199022 2445
2446419 2446419 2022-04-26 Oklahoma Oklahoma 40109 199022 2445
2443164 2443164 2022-04-25 Oklahoma Oklahoma 40109 199022 2445
2439908 2439908 2022-04-24 Oklahoma Oklahoma 40109 199022 2445
2436652 2436652 2022-04-23 Oklahoma Oklahoma 40109 199022 2445
2433396 2433396 2022-04-22 Oklahoma Oklahoma 40109 199022 2445
2430140 2430140 2022-04-21 Oklahoma Oklahoma 40109 199022 2445
2426884 2426884 2022-04-20 Oklahoma Oklahoma 40109 198551 2433
2423628 2423628 2022-04-19 Oklahoma Oklahoma 40109 198551 2433
2420371 2420371 2022-04-18 Oklahoma Oklahoma 40109 198551 2433
2417116 2417116 2022-04-17 Oklahoma Oklahoma 40109 198551 2433
2413860 2413860 2022-04-16 Oklahoma Oklahoma 40109 198551 2433
2410604 2410604 2022-04-15 Oklahoma Oklahoma 40109 198551 2433
2407348 2407348 2022-04-14 Oklahoma Oklahoma 40109 198551 2433
2404092 2404092 2022-04-13 Oklahoma Oklahoma 40109 198164 2406
2400837 2400837 2022-04-12 Oklahoma Oklahoma 40109 198164 2406
2397582 2397582 2022-04-11 Oklahoma Oklahoma 40109 198164 2406
2394327 2394327 2022-04-10 Oklahoma Oklahoma 40109 198164 2406
2391071 2391071 2022-04-09 Oklahoma Oklahoma 40109 198164 2406
2387815 2387815 2022-04-08 Oklahoma Oklahoma 40109 198164 2406
2384560 2384560 2022-04-07 Oklahoma Oklahoma 40109 198164 2406
2381305 2381305 2022-04-06 Oklahoma Oklahoma 40109 197490 2393
2378050 2378050 2022-04-05 Oklahoma Oklahoma 40109 197490 2393
2374796 2374796 2022-04-04 Oklahoma Oklahoma 40109 197490 2393
2371544 2371544 2022-04-03 Oklahoma Oklahoma 40109 197490 2393
2368291 2368291 2022-04-02 Oklahoma Oklahoma 40109 197490 2393
2365038 2365038 2022-04-01 Oklahoma Oklahoma 40109 197490 2393
2361785 2361785 2022-03-31 Oklahoma Oklahoma 40109 197490 2393
2358531 2358531 2022-03-30 Oklahoma Oklahoma 40109 197012 2364
2355277 2355277 2022-03-29 Oklahoma Oklahoma 40109 197012 2364
2352024 2352024 2022-03-28 Oklahoma Oklahoma 40109 197012 2364
2348772 2348772 2022-03-27 Oklahoma Oklahoma 40109 197012 2364
2345519 2345519 2022-03-26 Oklahoma Oklahoma 40109 197012 2364
2342266 2342266 2022-03-25 Oklahoma Oklahoma 40109 197012 2364
2339013 2339013 2022-03-24 Oklahoma Oklahoma 40109 197012 2364
2335759 2335759 2022-03-23 Oklahoma Oklahoma 40109 196413 2333
2332505 2332505 2022-03-22 Oklahoma Oklahoma 40109 196413 2333
2329252 2329252 2022-03-21 Oklahoma Oklahoma 40109 196413 2333
2326000 2326000 2022-03-20 Oklahoma Oklahoma 40109 196413 2333
2322747 2322747 2022-03-19 Oklahoma Oklahoma 40109 196413 2333
2319493 2319493 2022-03-18 Oklahoma Oklahoma 40109 196413 2333
2316239 2316239 2022-03-17 Oklahoma Oklahoma 40109 196413 2333
2312986 2312986 2022-03-16 Oklahoma Oklahoma 40109 195855 2301
2309733 2309733 2022-03-15 Oklahoma Oklahoma 40109 195855 2301
2306480 2306480 2022-03-14 Oklahoma Oklahoma 40109 195855 2301
2303229 2303229 2022-03-13 Oklahoma Oklahoma 40109 195855 2301
2299977 2299977 2022-03-12 Oklahoma Oklahoma 40109 195855 2301
2296725 2296725 2022-03-11 Oklahoma Oklahoma 40109 195855 2301
2293473 2293473 2022-03-10 Oklahoma Oklahoma 40109 195855 2301
2290221 2290221 2022-03-09 Oklahoma Oklahoma 40109 194092 2272
2286969 2286969 2022-03-08 Oklahoma Oklahoma 40109 194092 2272
2283717 2283717 2022-03-07 Oklahoma Oklahoma 40109 194092 2272
2280465 2280465 2022-03-06 Oklahoma Oklahoma 40109 194092 2272
2277212 2277212 2022-03-05 Oklahoma Oklahoma 40109 194092 2272
2273959 2273959 2022-03-04 Oklahoma Oklahoma 40109 194092 2272
2270706 2270706 2022-03-03 Oklahoma Oklahoma 40109 194092 2272
2267454 2267454 2022-03-02 Oklahoma Oklahoma 40109 194092 2272
2264201 2264201 2022-03-01 Oklahoma Oklahoma 40109 192433 2230
2260951 2260951 2022-02-28 Oklahoma Oklahoma 40109 192433 2230
2257700 2257700 2022-02-27 Oklahoma Oklahoma 40109 192433 2230
2254449 2254449 2022-02-26 Oklahoma Oklahoma 40109 192433 2230
2251198 2251198 2022-02-25 Oklahoma Oklahoma 40109 192433 2230
2247947 2247947 2022-02-24 Oklahoma Oklahoma 40109 192433 2230
2244696 2244696 2022-02-23 Oklahoma Oklahoma 40109 192433 2230
2241445 2241445 2022-02-22 Oklahoma Oklahoma 40109 190981 2192
2238194 2238194 2022-02-21 Oklahoma Oklahoma 40109 190981 2192
2234943 2234943 2022-02-20 Oklahoma Oklahoma 40109 190981 2192
2231692 2231692 2022-02-19 Oklahoma Oklahoma 40109 190981 2192
2228441 2228441 2022-02-18 Oklahoma Oklahoma 40109 190981 2192
2225190 2225190 2022-02-17 Oklahoma Oklahoma 40109 190981 2192
2221939 2221939 2022-02-16 Oklahoma Oklahoma 40109 190981 2192
2218688 2218688 2022-02-15 Oklahoma Oklahoma 40109 188647 2117
2215437 2215437 2022-02-14 Oklahoma Oklahoma 40109 188647 2117
2212186 2212186 2022-02-13 Oklahoma Oklahoma 40109 188647 2117
2208933 2208933 2022-02-12 Oklahoma Oklahoma 40109 188647 2117
2205680 2205680 2022-02-11 Oklahoma Oklahoma 40109 188647 2117
2202427 2202427 2022-02-10 Oklahoma Oklahoma 40109 188647 2117
2199173 2199173 2022-02-09 Oklahoma Oklahoma 40109 188647 2117
2195919 2195919 2022-02-08 Oklahoma Oklahoma 40109 185532 2065
2192665 2192665 2022-02-07 Oklahoma Oklahoma 40109 185532 2065
2189411 2189411 2022-02-06 Oklahoma Oklahoma 40109 185532 2065
2186158 2186158 2022-02-05 Oklahoma Oklahoma 40109 185532 2065
2182906 2182906 2022-02-04 Oklahoma Oklahoma 40109 185532 2065
2179654 2179654 2022-02-03 Oklahoma Oklahoma 40109 185532 2065

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