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

640 rows where county = "Unknown" 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 · 640 ✖

fips 1

  • - 640

county 1

  • Unknown · 640 ✖
Link rowid date ▲ county state fips cases deaths
2501805 2501805 2022-05-13 Unknown Oklahoma   806 0
2498547 2498547 2022-05-12 Unknown Oklahoma   806 0
2495289 2495289 2022-05-11 Unknown Oklahoma   2310 0
2492031 2492031 2022-05-10 Unknown Oklahoma   2310 0
2488773 2488773 2022-05-09 Unknown Oklahoma   1408 0
2485516 2485516 2022-05-08 Unknown Oklahoma   1408 0
2482258 2482258 2022-05-07 Unknown Oklahoma   1408 0
2479000 2479000 2022-05-06 Unknown Oklahoma   907 0
2475742 2475742 2022-05-05 Unknown Oklahoma   907 0
2472485 2472485 2022-05-04 Unknown Oklahoma   1609 4
2469229 2469229 2022-05-03 Unknown Oklahoma   1609 4
2465973 2465973 2022-05-02 Unknown Oklahoma   1194 4
2462718 2462718 2022-05-01 Unknown Oklahoma   1194 4
2459462 2459462 2022-04-30 Unknown Oklahoma   1194 4
2456206 2456206 2022-04-29 Unknown Oklahoma   628 4
2452950 2452950 2022-04-28 Unknown Oklahoma   628 4
2449694 2449694 2022-04-27 Unknown Oklahoma   1893 0
2446437 2446437 2022-04-26 Unknown Oklahoma   1893 0
2443182 2443182 2022-04-25 Unknown Oklahoma   1356 0
2439926 2439926 2022-04-24 Unknown Oklahoma   1356 0
2436670 2436670 2022-04-23 Unknown Oklahoma   1356 0
2433414 2433414 2022-04-22 Unknown Oklahoma   742 0
2430158 2430158 2022-04-21 Unknown Oklahoma   742 0
2426902 2426902 2022-04-20 Unknown Oklahoma   1988 7
2423646 2423646 2022-04-19 Unknown Oklahoma   1988 7
2420389 2420389 2022-04-18 Unknown Oklahoma   1416 0
2417134 2417134 2022-04-17 Unknown Oklahoma   1416 0
2413878 2413878 2022-04-16 Unknown Oklahoma   1416 0
2410622 2410622 2022-04-15 Unknown Oklahoma   182 0
2407366 2407366 2022-04-14 Unknown Oklahoma   182 0
2404110 2404110 2022-04-13 Unknown Oklahoma   1379 1
2400855 2400855 2022-04-12 Unknown Oklahoma   1379 1
2397600 2397600 2022-04-11 Unknown Oklahoma   1017 1
2394345 2394345 2022-04-10 Unknown Oklahoma   1017 1
2391089 2391089 2022-04-09 Unknown Oklahoma   1017 1
2387833 2387833 2022-04-08 Unknown Oklahoma   185 1
2384578 2384578 2022-04-07 Unknown Oklahoma   185 1
2381323 2381323 2022-04-06 Unknown Oklahoma   2242 1
2378068 2378068 2022-04-05 Unknown Oklahoma   2242 1
2374814 2374814 2022-04-04 Unknown Oklahoma   1380 1
2371562 2371562 2022-04-03 Unknown Oklahoma   1380 1
2368309 2368309 2022-04-02 Unknown Oklahoma   1380 1
2365056 2365056 2022-04-01 Unknown Oklahoma   789 1
2361803 2361803 2022-03-31 Unknown Oklahoma   789 1
2358549 2358549 2022-03-30 Unknown Oklahoma   2007 1
2355295 2355295 2022-03-29 Unknown Oklahoma   2007 1
2352042 2352042 2022-03-28 Unknown Oklahoma   1271 1
2348790 2348790 2022-03-27 Unknown Oklahoma   1271 1
2345537 2345537 2022-03-26 Unknown Oklahoma   1271 1
2342284 2342284 2022-03-25 Unknown Oklahoma   647 1
2339031 2339031 2022-03-24 Unknown Oklahoma   647 1
2335777 2335777 2022-03-23 Unknown Oklahoma   1711 1
2332523 2332523 2022-03-22 Unknown Oklahoma   1711 1
2329270 2329270 2022-03-21 Unknown Oklahoma   543 1
2326018 2326018 2022-03-20 Unknown Oklahoma   543 1
2322765 2322765 2022-03-19 Unknown Oklahoma   543 1
2319511 2319511 2022-03-18 Unknown Oklahoma   543 1
2316257 2316257 2022-03-17 Unknown Oklahoma   543 1
2313004 2313004 2022-03-16 Unknown Oklahoma   1931 217
2309751 2309751 2022-03-15 Unknown Oklahoma   1931 217
2306498 2306498 2022-03-14 Unknown Oklahoma   1174 1
2303247 2303247 2022-03-13 Unknown Oklahoma   1174 1
2299995 2299995 2022-03-12 Unknown Oklahoma   1174 1
2296743 2296743 2022-03-11 Unknown Oklahoma   647 1
2293491 2293491 2022-03-10 Unknown Oklahoma   161 1
2290239 2290239 2022-03-09 Unknown Oklahoma   5034 1
2286987 2286987 2022-03-08 Unknown Oklahoma   5034 1
2283735 2283735 2022-03-07 Unknown Oklahoma   3033 1
2280483 2280483 2022-03-06 Unknown Oklahoma   3033 1
2277230 2277230 2022-03-05 Unknown Oklahoma   3033 1
2273977 2273977 2022-03-04 Unknown Oklahoma   3033 1
2270724 2270724 2022-03-03 Unknown Oklahoma   1920 1
2267472 2267472 2022-03-02 Unknown Oklahoma   1331 1
2264219 2264219 2022-03-01 Unknown Oklahoma   6465 0
2260969 2260969 2022-02-28 Unknown Oklahoma   6211 0
2257718 2257718 2022-02-27 Unknown Oklahoma   4105 0
2254467 2254467 2022-02-26 Unknown Oklahoma   4105 0
2251216 2251216 2022-02-25 Unknown Oklahoma   4105 0
2247965 2247965 2022-02-24 Unknown Oklahoma   2944 0
2244714 2244714 2022-02-23 Unknown Oklahoma   1561 0
2241463 2241463 2022-02-22 Unknown Oklahoma   6950 0
2238212 2238212 2022-02-21 Unknown Oklahoma   4302 0
2234961 2234961 2022-02-20 Unknown Oklahoma   4302 0
2231710 2231710 2022-02-19 Unknown Oklahoma   4302 0
2228459 2228459 2022-02-18 Unknown Oklahoma   4302 0
2225208 2225208 2022-02-17 Unknown Oklahoma   3183 0
2221957 2221957 2022-02-16 Unknown Oklahoma   1569 0
2218706 2218706 2022-02-15 Unknown Oklahoma   11865 0
2215455 2215455 2022-02-14 Unknown Oklahoma   11487 0
2212204 2212204 2022-02-13 Unknown Oklahoma   9204 0
2208951 2208951 2022-02-12 Unknown Oklahoma   9204 0
2205698 2205698 2022-02-11 Unknown Oklahoma   7746 0
2202445 2202445 2022-02-10 Unknown Oklahoma   5516 0
2199191 2199191 2022-02-09 Unknown Oklahoma   2838 0
2195937 2195937 2022-02-08 Unknown Oklahoma   21993 4
2192683 2192683 2022-02-07 Unknown Oklahoma   21007 4
2189429 2189429 2022-02-06 Unknown Oklahoma   18770 4
2186176 2186176 2022-02-05 Unknown Oklahoma   18770 4
2182924 2182924 2022-02-04 Unknown Oklahoma   16156 4
2179672 2179672 2022-02-03 Unknown Oklahoma   11414 4

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