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

439 rows where county = "Unknown" and state = "Ohio" sorted by date descending

✎ View and edit SQL

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

state 1

  • Ohio · 439 ✖

fips 1

  • - 439

county 1

  • Unknown · 439 ✖
Link rowid date ▲ county state fips cases deaths
2501724 2501724 2022-05-13 Unknown Ohio   0 5
2498466 2498466 2022-05-12 Unknown Ohio   0 5
2495208 2495208 2022-05-11 Unknown Ohio   0 7
2491950 2491950 2022-05-10 Unknown Ohio   0 7
2488692 2488692 2022-05-09 Unknown Ohio   0 7
2485435 2485435 2022-05-08 Unknown Ohio   0 7
2482177 2482177 2022-05-07 Unknown Ohio   0 7
2478919 2478919 2022-05-06 Unknown Ohio   0 7
2475661 2475661 2022-05-05 Unknown Ohio   0 7
2472404 2472404 2022-05-04 Unknown Ohio   0 5
2469148 2469148 2022-05-03 Unknown Ohio   0 5
2465892 2465892 2022-05-02 Unknown Ohio   0 5
2462637 2462637 2022-05-01 Unknown Ohio   0 5
2459381 2459381 2022-04-30 Unknown Ohio   0 5
2456125 2456125 2022-04-29 Unknown Ohio   0 5
2452869 2452869 2022-04-28 Unknown Ohio   0 5
2449613 2449613 2022-04-27 Unknown Ohio   0 5
2446356 2446356 2022-04-26 Unknown Ohio   0 5
2443101 2443101 2022-04-25 Unknown Ohio   0 5
2439845 2439845 2022-04-24 Unknown Ohio   0 5
2436589 2436589 2022-04-23 Unknown Ohio   0 5
2433333 2433333 2022-04-22 Unknown Ohio   0 5
2430077 2430077 2022-04-21 Unknown Ohio   0 5
2426821 2426821 2022-04-20 Unknown Ohio   0 5
2423565 2423565 2022-04-19 Unknown Ohio   0 5
2420308 2420308 2022-04-18 Unknown Ohio   0 5
2417053 2417053 2022-04-17 Unknown Ohio   0 5
2413797 2413797 2022-04-16 Unknown Ohio   0 5
2410541 2410541 2022-04-15 Unknown Ohio   0 5
2407285 2407285 2022-04-14 Unknown Ohio   0 5
2404029 2404029 2022-04-13 Unknown Ohio   0 5
2400774 2400774 2022-04-12 Unknown Ohio   0 5
2397519 2397519 2022-04-11 Unknown Ohio   0 5
2394264 2394264 2022-04-10 Unknown Ohio   0 5
2391008 2391008 2022-04-09 Unknown Ohio   0 5
2387752 2387752 2022-04-08 Unknown Ohio   0 5
2384497 2384497 2022-04-07 Unknown Ohio   0 5
2381242 2381242 2022-04-06 Unknown Ohio   0 5
2377987 2377987 2022-04-05 Unknown Ohio   0 5
2374733 2374733 2022-04-04 Unknown Ohio   0 5
2371481 2371481 2022-04-03 Unknown Ohio   0 5
2368228 2368228 2022-04-02 Unknown Ohio   0 5
2364975 2364975 2022-04-01 Unknown Ohio   0 5
2361722 2361722 2022-03-31 Unknown Ohio   0 5
2358468 2358468 2022-03-30 Unknown Ohio   0 5
2355214 2355214 2022-03-29 Unknown Ohio   0 5
2351961 2351961 2022-03-28 Unknown Ohio   0 5
2348709 2348709 2022-03-27 Unknown Ohio   0 5
2345456 2345456 2022-03-26 Unknown Ohio   0 5
2342203 2342203 2022-03-25 Unknown Ohio   0 5
2338950 2338950 2022-03-24 Unknown Ohio   0 5
2335696 2335696 2022-03-23 Unknown Ohio   0 5
2332442 2332442 2022-03-22 Unknown Ohio   0 5
2329189 2329189 2022-03-21 Unknown Ohio   0 5
2325937 2325937 2022-03-20 Unknown Ohio   0 5
2322684 2322684 2022-03-19 Unknown Ohio   0 5
2319430 2319430 2022-03-18 Unknown Ohio   0 5
2316176 2316176 2022-03-17 Unknown Ohio   0 5
2312923 2312923 2022-03-16 Unknown Ohio   0 5
2309670 2309670 2022-03-15 Unknown Ohio   0 5
2306417 2306417 2022-03-14 Unknown Ohio   0 5
2303166 2303166 2022-03-13 Unknown Ohio   0 5
2299914 2299914 2022-03-12 Unknown Ohio   0 5
2296662 2296662 2022-03-11 Unknown Ohio   0 5
2293410 2293410 2022-03-10 Unknown Ohio   0 5
2290158 2290158 2022-03-09 Unknown Ohio   0 5
2286906 2286906 2022-03-08 Unknown Ohio   0 5
2283654 2283654 2022-03-07 Unknown Ohio   0 5
2280402 2280402 2022-03-06 Unknown Ohio   0 5
2277149 2277149 2022-03-05 Unknown Ohio   0 5
2273896 2273896 2022-03-04 Unknown Ohio   0 5
2270643 2270643 2022-03-03 Unknown Ohio   0 5
2267391 2267391 2022-03-02 Unknown Ohio   0 5
2264138 2264138 2022-03-01 Unknown Ohio   0 5
2260888 2260888 2022-02-28 Unknown Ohio   0 5
2257637 2257637 2022-02-27 Unknown Ohio   0 5
2254386 2254386 2022-02-26 Unknown Ohio   0 5
2251135 2251135 2022-02-25 Unknown Ohio   0 5
2247884 2247884 2022-02-24 Unknown Ohio   0 5
2244633 2244633 2022-02-23 Unknown Ohio   0 5
2241382 2241382 2022-02-22 Unknown Ohio   0 5
2238131 2238131 2022-02-21 Unknown Ohio   0 5
2234880 2234880 2022-02-20 Unknown Ohio   0 5
2231629 2231629 2022-02-19 Unknown Ohio   0 5
2228378 2228378 2022-02-18 Unknown Ohio   0 5
2225127 2225127 2022-02-17 Unknown Ohio   0 5
2221876 2221876 2022-02-16 Unknown Ohio   0 5
2218625 2218625 2022-02-15 Unknown Ohio   0 5
2215374 2215374 2022-02-14 Unknown Ohio   0 5
2212123 2212123 2022-02-13 Unknown Ohio   0 5
2208870 2208870 2022-02-12 Unknown Ohio   0 5
2205617 2205617 2022-02-11 Unknown Ohio   0 5
2202364 2202364 2022-02-10 Unknown Ohio   0 5
2199110 2199110 2022-02-09 Unknown Ohio   0 5
2195856 2195856 2022-02-08 Unknown Ohio   0 5
2192602 2192602 2022-02-07 Unknown Ohio   0 5
2189348 2189348 2022-02-06 Unknown Ohio   0 5
2186095 2186095 2022-02-05 Unknown Ohio   0 5
2182843 2182843 2022-02-04 Unknown Ohio   0 5
2179591 2179591 2022-02-03 Unknown Ohio   0 5

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