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

781 rows where county = "Ohio", fips = 18115 and state = "Indiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Indiana · 781 ✖

fips 1

  • 18115 · 781 ✖

county 1

  • Ohio · 781 ✖
Link rowid date ▲ county state fips cases deaths
2500337 2500337 2022-05-13 Ohio Indiana 18115 1458 19
2497079 2497079 2022-05-12 Ohio Indiana 18115 1456 19
2493821 2493821 2022-05-11 Ohio Indiana 18115 1456 19
2490563 2490563 2022-05-10 Ohio Indiana 18115 1455 19
2487306 2487306 2022-05-09 Ohio Indiana 18115 1455 19
2484048 2484048 2022-05-08 Ohio Indiana 18115 1451 19
2480790 2480790 2022-05-07 Ohio Indiana 18115 1451 19
2477532 2477532 2022-05-06 Ohio Indiana 18115 1451 19
2474274 2474274 2022-05-05 Ohio Indiana 18115 1451 19
2471017 2471017 2022-05-04 Ohio Indiana 18115 1451 19
2467761 2467761 2022-05-03 Ohio Indiana 18115 1448 19
2464506 2464506 2022-05-02 Ohio Indiana 18115 1448 19
2461250 2461250 2022-05-01 Ohio Indiana 18115 1448 19
2457994 2457994 2022-04-30 Ohio Indiana 18115 1448 19
2454738 2454738 2022-04-29 Ohio Indiana 18115 1448 19
2451482 2451482 2022-04-28 Ohio Indiana 18115 1448 19
2448226 2448226 2022-04-27 Ohio Indiana 18115 1448 19
2444970 2444970 2022-04-26 Ohio Indiana 18115 1445 19
2441714 2441714 2022-04-25 Ohio Indiana 18115 1445 19
2438458 2438458 2022-04-24 Ohio Indiana 18115 1444 19
2435202 2435202 2022-04-23 Ohio Indiana 18115 1444 19
2431946 2431946 2022-04-22 Ohio Indiana 18115 1444 19
2428690 2428690 2022-04-21 Ohio Indiana 18115 1444 19
2425434 2425434 2022-04-20 Ohio Indiana 18115 1444 19
2422178 2422178 2022-04-19 Ohio Indiana 18115 1444 19
2418922 2418922 2022-04-18 Ohio Indiana 18115 1444 19
2415666 2415666 2022-04-17 Ohio Indiana 18115 1444 19
2412410 2412410 2022-04-16 Ohio Indiana 18115 1444 19
2409154 2409154 2022-04-15 Ohio Indiana 18115 1444 19
2405898 2405898 2022-04-14 Ohio Indiana 18115 1444 19
2402643 2402643 2022-04-13 Ohio Indiana 18115 1444 19
2399388 2399388 2022-04-12 Ohio Indiana 18115 1443 19
2396133 2396133 2022-04-11 Ohio Indiana 18115 1443 19
2392877 2392877 2022-04-10 Ohio Indiana 18115 1443 19
2389621 2389621 2022-04-09 Ohio Indiana 18115 1443 19
2386366 2386366 2022-04-08 Ohio Indiana 18115 1443 19
2383111 2383111 2022-04-07 Ohio Indiana 18115 1442 19
2379856 2379856 2022-04-06 Ohio Indiana 18115 1442 19
2376602 2376602 2022-04-05 Ohio Indiana 18115 1443 19
2373350 2373350 2022-04-04 Ohio Indiana 18115 1443 19
2370097 2370097 2022-04-03 Ohio Indiana 18115 1443 19
2366844 2366844 2022-04-02 Ohio Indiana 18115 1443 19
2363591 2363591 2022-04-01 Ohio Indiana 18115 1443 19
2360337 2360337 2022-03-31 Ohio Indiana 18115 1443 19
2357083 2357083 2022-03-30 Ohio Indiana 18115 1443 19
2353830 2353830 2022-03-29 Ohio Indiana 18115 1444 19
2350578 2350578 2022-03-28 Ohio Indiana 18115 1444 19
2347325 2347325 2022-03-27 Ohio Indiana 18115 1443 19
2344072 2344072 2022-03-26 Ohio Indiana 18115 1443 19
2340819 2340819 2022-03-25 Ohio Indiana 18115 1443 19
2337566 2337566 2022-03-24 Ohio Indiana 18115 1443 19
2334312 2334312 2022-03-23 Ohio Indiana 18115 1443 19
2331058 2331058 2022-03-22 Ohio Indiana 18115 1443 19
2327806 2327806 2022-03-21 Ohio Indiana 18115 1442 19
2324553 2324553 2022-03-20 Ohio Indiana 18115 1442 19
2321299 2321299 2022-03-19 Ohio Indiana 18115 1442 19
2318045 2318045 2022-03-18 Ohio Indiana 18115 1442 19
2314792 2314792 2022-03-17 Ohio Indiana 18115 1443 19
2311539 2311539 2022-03-16 Ohio Indiana 18115 1443 19
2308286 2308286 2022-03-15 Ohio Indiana 18115 1442 19
2305035 2305035 2022-03-14 Ohio Indiana 18115 1442 19
2301783 2301783 2022-03-13 Ohio Indiana 18115 1442 19
2298531 2298531 2022-03-12 Ohio Indiana 18115 1442 19
2295279 2295279 2022-03-11 Ohio Indiana 18115 1442 19
2292027 2292027 2022-03-10 Ohio Indiana 18115 1442 19
2288775 2288775 2022-03-09 Ohio Indiana 18115 1442 19
2285524 2285524 2022-03-08 Ohio Indiana 18115 1442 19
2282272 2282272 2022-03-07 Ohio Indiana 18115 1442 19
2279019 2279019 2022-03-06 Ohio Indiana 18115 1442 19
2275766 2275766 2022-03-05 Ohio Indiana 18115 1442 19
2272513 2272513 2022-03-04 Ohio Indiana 18115 1442 19
2269261 2269261 2022-03-03 Ohio Indiana 18115 1441 19
2266008 2266008 2022-03-02 Ohio Indiana 18115 1441 19
2262757 2262757 2022-03-01 Ohio Indiana 18115 1440 19
2259506 2259506 2022-02-28 Ohio Indiana 18115 1440 19
2256255 2256255 2022-02-27 Ohio Indiana 18115 1439 19
2253004 2253004 2022-02-26 Ohio Indiana 18115 1439 19
2249753 2249753 2022-02-25 Ohio Indiana 18115 1439 19
2246502 2246502 2022-02-24 Ohio Indiana 18115 1437 18
2243251 2243251 2022-02-23 Ohio Indiana 18115 1437 18
2240000 2240000 2022-02-22 Ohio Indiana 18115 1437 18
2236749 2236749 2022-02-21 Ohio Indiana 18115 1437 18
2233498 2233498 2022-02-20 Ohio Indiana 18115 1436 18
2230247 2230247 2022-02-19 Ohio Indiana 18115 1436 18
2226996 2226996 2022-02-18 Ohio Indiana 18115 1436 18
2223745 2223745 2022-02-17 Ohio Indiana 18115 1435 18
2220494 2220494 2022-02-16 Ohio Indiana 18115 1434 18
2217243 2217243 2022-02-15 Ohio Indiana 18115 1434 17
2213992 2213992 2022-02-14 Ohio Indiana 18115 1432 17
2210740 2210740 2022-02-13 Ohio Indiana 18115 1428 17
2207487 2207487 2022-02-12 Ohio Indiana 18115 1428 17
2204234 2204234 2022-02-11 Ohio Indiana 18115 1428 17
2200981 2200981 2022-02-10 Ohio Indiana 18115 1423 17
2197727 2197727 2022-02-09 Ohio Indiana 18115 1416 17
2194473 2194473 2022-02-08 Ohio Indiana 18115 1416 17
2191219 2191219 2022-02-07 Ohio Indiana 18115 1412 17
2187966 2187966 2022-02-06 Ohio Indiana 18115 1408 17
2184713 2184713 2022-02-05 Ohio Indiana 18115 1408 17
2181461 2181461 2022-02-04 Ohio Indiana 18115 1408 17
2178210 2178210 2022-02-03 Ohio Indiana 18115 1404 17

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