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

791 rows where county = "Belmont" and state = "Ohio" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Ohio · 791 ✖

fips 1

county 1

  • Belmont · 791 ✖
Link rowid date ▲ county state fips cases deaths
2501650 2501650 2022-05-13 Belmont Ohio 39013 15805 309
2498392 2498392 2022-05-12 Belmont Ohio 39013 15805 309
2495134 2495134 2022-05-11 Belmont Ohio 39013 15762 309
2491876 2491876 2022-05-10 Belmont Ohio 39013 15762 309
2488618 2488618 2022-05-09 Belmont Ohio 39013 15762 309
2485361 2485361 2022-05-08 Belmont Ohio 39013 15762 309
2482103 2482103 2022-05-07 Belmont Ohio 39013 15762 309
2478845 2478845 2022-05-06 Belmont Ohio 39013 15762 309
2475587 2475587 2022-05-05 Belmont Ohio 39013 15762 309
2472330 2472330 2022-05-04 Belmont Ohio 39013 15736 307
2469074 2469074 2022-05-03 Belmont Ohio 39013 15736 307
2465818 2465818 2022-05-02 Belmont Ohio 39013 15736 307
2462563 2462563 2022-05-01 Belmont Ohio 39013 15736 307
2459307 2459307 2022-04-30 Belmont Ohio 39013 15736 307
2456051 2456051 2022-04-29 Belmont Ohio 39013 15736 307
2452795 2452795 2022-04-28 Belmont Ohio 39013 15736 307
2449539 2449539 2022-04-27 Belmont Ohio 39013 15706 307
2446282 2446282 2022-04-26 Belmont Ohio 39013 15706 307
2443027 2443027 2022-04-25 Belmont Ohio 39013 15706 307
2439771 2439771 2022-04-24 Belmont Ohio 39013 15706 307
2436515 2436515 2022-04-23 Belmont Ohio 39013 15706 307
2433259 2433259 2022-04-22 Belmont Ohio 39013 15706 307
2430003 2430003 2022-04-21 Belmont Ohio 39013 15706 307
2426747 2426747 2022-04-20 Belmont Ohio 39013 15688 305
2423491 2423491 2022-04-19 Belmont Ohio 39013 15688 305
2420234 2420234 2022-04-18 Belmont Ohio 39013 15688 305
2416979 2416979 2022-04-17 Belmont Ohio 39013 15688 305
2413723 2413723 2022-04-16 Belmont Ohio 39013 15688 305
2410467 2410467 2022-04-15 Belmont Ohio 39013 15688 305
2407211 2407211 2022-04-14 Belmont Ohio 39013 15688 305
2403955 2403955 2022-04-13 Belmont Ohio 39013 15667 303
2400700 2400700 2022-04-12 Belmont Ohio 39013 15667 303
2397445 2397445 2022-04-11 Belmont Ohio 39013 15667 303
2394190 2394190 2022-04-10 Belmont Ohio 39013 15667 303
2390934 2390934 2022-04-09 Belmont Ohio 39013 15667 303
2387678 2387678 2022-04-08 Belmont Ohio 39013 15667 303
2384423 2384423 2022-04-07 Belmont Ohio 39013 15667 303
2381168 2381168 2022-04-06 Belmont Ohio 39013 15642 301
2377913 2377913 2022-04-05 Belmont Ohio 39013 15642 301
2374659 2374659 2022-04-04 Belmont Ohio 39013 15642 301
2371407 2371407 2022-04-03 Belmont Ohio 39013 15642 301
2368154 2368154 2022-04-02 Belmont Ohio 39013 15642 301
2364901 2364901 2022-04-01 Belmont Ohio 39013 15642 301
2361648 2361648 2022-03-31 Belmont Ohio 39013 15642 301
2358394 2358394 2022-03-30 Belmont Ohio 39013 15620 297
2355140 2355140 2022-03-29 Belmont Ohio 39013 15620 297
2351887 2351887 2022-03-28 Belmont Ohio 39013 15620 297
2348635 2348635 2022-03-27 Belmont Ohio 39013 15620 297
2345382 2345382 2022-03-26 Belmont Ohio 39013 15620 297
2342129 2342129 2022-03-25 Belmont Ohio 39013 15620 297
2338876 2338876 2022-03-24 Belmont Ohio 39013 15620 297
2335622 2335622 2022-03-23 Belmont Ohio 39013 15600 291
2332368 2332368 2022-03-22 Belmont Ohio 39013 15600 291
2329115 2329115 2022-03-21 Belmont Ohio 39013 15600 291
2325863 2325863 2022-03-20 Belmont Ohio 39013 15600 291
2322610 2322610 2022-03-19 Belmont Ohio 39013 15600 291
2319356 2319356 2022-03-18 Belmont Ohio 39013 15600 291
2316102 2316102 2022-03-17 Belmont Ohio 39013 15600 291
2312849 2312849 2022-03-16 Belmont Ohio 39013 15590 290
2309596 2309596 2022-03-15 Belmont Ohio 39013 15590 290
2306343 2306343 2022-03-14 Belmont Ohio 39013 15590 290
2303092 2303092 2022-03-13 Belmont Ohio 39013 15590 290
2299840 2299840 2022-03-12 Belmont Ohio 39013 15590 290
2296588 2296588 2022-03-11 Belmont Ohio 39013 15590 290
2293336 2293336 2022-03-10 Belmont Ohio 39013 15585 288
2290084 2290084 2022-03-09 Belmont Ohio 39013 15578 288
2286832 2286832 2022-03-08 Belmont Ohio 39013 15572 288
2283580 2283580 2022-03-07 Belmont Ohio 39013 15565 284
2280328 2280328 2022-03-06 Belmont Ohio 39013 15560 284
2277075 2277075 2022-03-05 Belmont Ohio 39013 15555 284
2273822 2273822 2022-03-04 Belmont Ohio 39013 15555 284
2270569 2270569 2022-03-03 Belmont Ohio 39013 15549 283
2267317 2267317 2022-03-02 Belmont Ohio 39013 15538 283
2264064 2264064 2022-03-01 Belmont Ohio 39013 15534 283
2260814 2260814 2022-02-28 Belmont Ohio 39013 15515 283
2257563 2257563 2022-02-27 Belmont Ohio 39013 15508 283
2254312 2254312 2022-02-26 Belmont Ohio 39013 15505 283
2251061 2251061 2022-02-25 Belmont Ohio 39013 15501 283
2247810 2247810 2022-02-24 Belmont Ohio 39013 15491 279
2244559 2244559 2022-02-23 Belmont Ohio 39013 15478 279
2241308 2241308 2022-02-22 Belmont Ohio 39013 15463 279
2238057 2238057 2022-02-21 Belmont Ohio 39013 15436 276
2234806 2234806 2022-02-20 Belmont Ohio 39013 15427 276
2231555 2231555 2022-02-19 Belmont Ohio 39013 15426 276
2228304 2228304 2022-02-18 Belmont Ohio 39013 15417 276
2225053 2225053 2022-02-17 Belmont Ohio 39013 15403 267
2221802 2221802 2022-02-16 Belmont Ohio 39013 15379 267
2218551 2218551 2022-02-15 Belmont Ohio 39013 15354 267
2215300 2215300 2022-02-14 Belmont Ohio 39013 15347 263
2212049 2212049 2022-02-13 Belmont Ohio 39013 15334 263
2208796 2208796 2022-02-12 Belmont Ohio 39013 15322 263
2205543 2205543 2022-02-11 Belmont Ohio 39013 15313 263
2202290 2202290 2022-02-10 Belmont Ohio 39013 15290 263
2199036 2199036 2022-02-09 Belmont Ohio 39013 15257 263
2195782 2195782 2022-02-08 Belmont Ohio 39013 15227 263
2192528 2192528 2022-02-07 Belmont Ohio 39013 15176 258
2189274 2189274 2022-02-06 Belmont Ohio 39013 15168 258
2186021 2186021 2022-02-05 Belmont Ohio 39013 15143 258
2182769 2182769 2022-02-04 Belmont Ohio 39013 15137 258
2179517 2179517 2022-02-03 Belmont Ohio 39013 15093 257

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