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

769 rows where county = "Monroe" and state = "Ohio" sorted by date descending

✎ View and edit SQL

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

state 1

  • Ohio · 769 ✖

fips 1

county 1

  • Monroe · 769 ✖
Link rowid date ▲ county state fips cases deaths
2501699 2501699 2022-05-13 Monroe Ohio 39111 3499 82
2498441 2498441 2022-05-12 Monroe Ohio 39111 3499 82
2495183 2495183 2022-05-11 Monroe Ohio 39111 3488 82
2491925 2491925 2022-05-10 Monroe Ohio 39111 3488 82
2488667 2488667 2022-05-09 Monroe Ohio 39111 3488 82
2485410 2485410 2022-05-08 Monroe Ohio 39111 3488 82
2482152 2482152 2022-05-07 Monroe Ohio 39111 3488 82
2478894 2478894 2022-05-06 Monroe Ohio 39111 3488 82
2475636 2475636 2022-05-05 Monroe Ohio 39111 3488 82
2472379 2472379 2022-05-04 Monroe Ohio 39111 3484 82
2469123 2469123 2022-05-03 Monroe Ohio 39111 3484 82
2465867 2465867 2022-05-02 Monroe Ohio 39111 3484 82
2462612 2462612 2022-05-01 Monroe Ohio 39111 3484 82
2459356 2459356 2022-04-30 Monroe Ohio 39111 3484 82
2456100 2456100 2022-04-29 Monroe Ohio 39111 3484 82
2452844 2452844 2022-04-28 Monroe Ohio 39111 3484 82
2449588 2449588 2022-04-27 Monroe Ohio 39111 3477 82
2446331 2446331 2022-04-26 Monroe Ohio 39111 3477 82
2443076 2443076 2022-04-25 Monroe Ohio 39111 3477 82
2439820 2439820 2022-04-24 Monroe Ohio 39111 3477 82
2436564 2436564 2022-04-23 Monroe Ohio 39111 3477 82
2433308 2433308 2022-04-22 Monroe Ohio 39111 3477 82
2430052 2430052 2022-04-21 Monroe Ohio 39111 3477 82
2426796 2426796 2022-04-20 Monroe Ohio 39111 3472 82
2423540 2423540 2022-04-19 Monroe Ohio 39111 3472 82
2420283 2420283 2022-04-18 Monroe Ohio 39111 3472 82
2417028 2417028 2022-04-17 Monroe Ohio 39111 3472 82
2413772 2413772 2022-04-16 Monroe Ohio 39111 3472 82
2410516 2410516 2022-04-15 Monroe Ohio 39111 3472 82
2407260 2407260 2022-04-14 Monroe Ohio 39111 3472 82
2404004 2404004 2022-04-13 Monroe Ohio 39111 3471 81
2400749 2400749 2022-04-12 Monroe Ohio 39111 3471 81
2397494 2397494 2022-04-11 Monroe Ohio 39111 3471 81
2394239 2394239 2022-04-10 Monroe Ohio 39111 3471 81
2390983 2390983 2022-04-09 Monroe Ohio 39111 3471 81
2387727 2387727 2022-04-08 Monroe Ohio 39111 3471 81
2384472 2384472 2022-04-07 Monroe Ohio 39111 3471 81
2381217 2381217 2022-04-06 Monroe Ohio 39111 3469 81
2377962 2377962 2022-04-05 Monroe Ohio 39111 3469 81
2374708 2374708 2022-04-04 Monroe Ohio 39111 3469 81
2371456 2371456 2022-04-03 Monroe Ohio 39111 3469 81
2368203 2368203 2022-04-02 Monroe Ohio 39111 3469 81
2364950 2364950 2022-04-01 Monroe Ohio 39111 3469 81
2361697 2361697 2022-03-31 Monroe Ohio 39111 3469 81
2358443 2358443 2022-03-30 Monroe Ohio 39111 3466 81
2355189 2355189 2022-03-29 Monroe Ohio 39111 3466 81
2351936 2351936 2022-03-28 Monroe Ohio 39111 3466 81
2348684 2348684 2022-03-27 Monroe Ohio 39111 3466 81
2345431 2345431 2022-03-26 Monroe Ohio 39111 3466 81
2342178 2342178 2022-03-25 Monroe Ohio 39111 3466 81
2338925 2338925 2022-03-24 Monroe Ohio 39111 3466 81
2335671 2335671 2022-03-23 Monroe Ohio 39111 3454 80
2332417 2332417 2022-03-22 Monroe Ohio 39111 3454 80
2329164 2329164 2022-03-21 Monroe Ohio 39111 3454 80
2325912 2325912 2022-03-20 Monroe Ohio 39111 3454 80
2322659 2322659 2022-03-19 Monroe Ohio 39111 3454 80
2319405 2319405 2022-03-18 Monroe Ohio 39111 3454 80
2316151 2316151 2022-03-17 Monroe Ohio 39111 3454 80
2312898 2312898 2022-03-16 Monroe Ohio 39111 3450 79
2309645 2309645 2022-03-15 Monroe Ohio 39111 3450 79
2306392 2306392 2022-03-14 Monroe Ohio 39111 3450 79
2303141 2303141 2022-03-13 Monroe Ohio 39111 3450 79
2299889 2299889 2022-03-12 Monroe Ohio 39111 3450 79
2296637 2296637 2022-03-11 Monroe Ohio 39111 3450 79
2293385 2293385 2022-03-10 Monroe Ohio 39111 3447 79
2290133 2290133 2022-03-09 Monroe Ohio 39111 3444 79
2286881 2286881 2022-03-08 Monroe Ohio 39111 3440 79
2283629 2283629 2022-03-07 Monroe Ohio 39111 3440 77
2280377 2280377 2022-03-06 Monroe Ohio 39111 3440 77
2277124 2277124 2022-03-05 Monroe Ohio 39111 3440 77
2273871 2273871 2022-03-04 Monroe Ohio 39111 3439 77
2270618 2270618 2022-03-03 Monroe Ohio 39111 3439 77
2267366 2267366 2022-03-02 Monroe Ohio 39111 3435 77
2264113 2264113 2022-03-01 Monroe Ohio 39111 3431 77
2260863 2260863 2022-02-28 Monroe Ohio 39111 3429 75
2257612 2257612 2022-02-27 Monroe Ohio 39111 3429 75
2254361 2254361 2022-02-26 Monroe Ohio 39111 3429 75
2251110 2251110 2022-02-25 Monroe Ohio 39111 3427 75
2247859 2247859 2022-02-24 Monroe Ohio 39111 3422 75
2244608 2244608 2022-02-23 Monroe Ohio 39111 3417 75
2241357 2241357 2022-02-22 Monroe Ohio 39111 3416 75
2238106 2238106 2022-02-21 Monroe Ohio 39111 3411 73
2234855 2234855 2022-02-20 Monroe Ohio 39111 3412 73
2231604 2231604 2022-02-19 Monroe Ohio 39111 3412 73
2228353 2228353 2022-02-18 Monroe Ohio 39111 3409 73
2225102 2225102 2022-02-17 Monroe Ohio 39111 3404 72
2221851 2221851 2022-02-16 Monroe Ohio 39111 3402 72
2218600 2218600 2022-02-15 Monroe Ohio 39111 3399 72
2215349 2215349 2022-02-14 Monroe Ohio 39111 3391 70
2212098 2212098 2022-02-13 Monroe Ohio 39111 3389 70
2208845 2208845 2022-02-12 Monroe Ohio 39111 3389 70
2205592 2205592 2022-02-11 Monroe Ohio 39111 3385 70
2202339 2202339 2022-02-10 Monroe Ohio 39111 3380 69
2199085 2199085 2022-02-09 Monroe Ohio 39111 3374 69
2195831 2195831 2022-02-08 Monroe Ohio 39111 3367 69
2192577 2192577 2022-02-07 Monroe Ohio 39111 3361 69
2189323 2189323 2022-02-06 Monroe Ohio 39111 3358 69
2186070 2186070 2022-02-05 Monroe Ohio 39111 3357 69
2182818 2182818 2022-02-04 Monroe Ohio 39111 3353 69
2179566 2179566 2022-02-03 Monroe Ohio 39111 3344 69

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