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

787 rows where county = "Delaware" 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 · 787 ✖

fips 1

county 1

  • Delaware · 787 ✖
Link rowid date ▲ county state fips cases deaths
2501664 2501664 2022-05-13 Delaware Ohio 39041 45538 272
2498406 2498406 2022-05-12 Delaware Ohio 39041 45538 272
2495148 2495148 2022-05-11 Delaware Ohio 39041 45100 272
2491890 2491890 2022-05-10 Delaware Ohio 39041 45100 272
2488632 2488632 2022-05-09 Delaware Ohio 39041 45100 272
2485375 2485375 2022-05-08 Delaware Ohio 39041 45100 272
2482117 2482117 2022-05-07 Delaware Ohio 39041 45100 272
2478859 2478859 2022-05-06 Delaware Ohio 39041 45100 272
2475601 2475601 2022-05-05 Delaware Ohio 39041 45100 272
2472344 2472344 2022-05-04 Delaware Ohio 39041 44808 272
2469088 2469088 2022-05-03 Delaware Ohio 39041 44808 272
2465832 2465832 2022-05-02 Delaware Ohio 39041 44808 272
2462577 2462577 2022-05-01 Delaware Ohio 39041 44808 272
2459321 2459321 2022-04-30 Delaware Ohio 39041 44808 272
2456065 2456065 2022-04-29 Delaware Ohio 39041 44808 272
2452809 2452809 2022-04-28 Delaware Ohio 39041 44808 272
2449553 2449553 2022-04-27 Delaware Ohio 39041 44574 272
2446296 2446296 2022-04-26 Delaware Ohio 39041 44574 272
2443041 2443041 2022-04-25 Delaware Ohio 39041 44574 272
2439785 2439785 2022-04-24 Delaware Ohio 39041 44574 272
2436529 2436529 2022-04-23 Delaware Ohio 39041 44574 272
2433273 2433273 2022-04-22 Delaware Ohio 39041 44574 272
2430017 2430017 2022-04-21 Delaware Ohio 39041 44574 272
2426761 2426761 2022-04-20 Delaware Ohio 39041 44373 272
2423505 2423505 2022-04-19 Delaware Ohio 39041 44373 272
2420248 2420248 2022-04-18 Delaware Ohio 39041 44373 272
2416993 2416993 2022-04-17 Delaware Ohio 39041 44373 272
2413737 2413737 2022-04-16 Delaware Ohio 39041 44373 272
2410481 2410481 2022-04-15 Delaware Ohio 39041 44373 272
2407225 2407225 2022-04-14 Delaware Ohio 39041 44373 272
2403969 2403969 2022-04-13 Delaware Ohio 39041 44255 271
2400714 2400714 2022-04-12 Delaware Ohio 39041 44255 271
2397459 2397459 2022-04-11 Delaware Ohio 39041 44255 271
2394204 2394204 2022-04-10 Delaware Ohio 39041 44255 271
2390948 2390948 2022-04-09 Delaware Ohio 39041 44255 271
2387692 2387692 2022-04-08 Delaware Ohio 39041 44255 271
2384437 2384437 2022-04-07 Delaware Ohio 39041 44255 271
2381182 2381182 2022-04-06 Delaware Ohio 39041 44162 271
2377927 2377927 2022-04-05 Delaware Ohio 39041 44162 271
2374673 2374673 2022-04-04 Delaware Ohio 39041 44162 271
2371421 2371421 2022-04-03 Delaware Ohio 39041 44162 271
2368168 2368168 2022-04-02 Delaware Ohio 39041 44162 271
2364915 2364915 2022-04-01 Delaware Ohio 39041 44162 271
2361662 2361662 2022-03-31 Delaware Ohio 39041 44162 271
2358408 2358408 2022-03-30 Delaware Ohio 39041 44087 269
2355154 2355154 2022-03-29 Delaware Ohio 39041 44087 269
2351901 2351901 2022-03-28 Delaware Ohio 39041 44087 269
2348649 2348649 2022-03-27 Delaware Ohio 39041 44087 269
2345396 2345396 2022-03-26 Delaware Ohio 39041 44087 269
2342143 2342143 2022-03-25 Delaware Ohio 39041 44087 269
2338890 2338890 2022-03-24 Delaware Ohio 39041 44087 269
2335636 2335636 2022-03-23 Delaware Ohio 39041 44023 269
2332382 2332382 2022-03-22 Delaware Ohio 39041 44023 269
2329129 2329129 2022-03-21 Delaware Ohio 39041 44023 269
2325877 2325877 2022-03-20 Delaware Ohio 39041 44023 269
2322624 2322624 2022-03-19 Delaware Ohio 39041 44023 269
2319370 2319370 2022-03-18 Delaware Ohio 39041 44023 269
2316116 2316116 2022-03-17 Delaware Ohio 39041 44023 269
2312863 2312863 2022-03-16 Delaware Ohio 39041 43991 267
2309610 2309610 2022-03-15 Delaware Ohio 39041 43991 267
2306357 2306357 2022-03-14 Delaware Ohio 39041 43991 267
2303106 2303106 2022-03-13 Delaware Ohio 39041 43991 267
2299854 2299854 2022-03-12 Delaware Ohio 39041 43988 267
2296602 2296602 2022-03-11 Delaware Ohio 39041 43980 267
2293350 2293350 2022-03-10 Delaware Ohio 39041 43971 264
2290098 2290098 2022-03-09 Delaware Ohio 39041 43966 264
2286846 2286846 2022-03-08 Delaware Ohio 39041 43955 264
2283594 2283594 2022-03-07 Delaware Ohio 39041 43941 263
2280342 2280342 2022-03-06 Delaware Ohio 39041 43934 263
2277089 2277089 2022-03-05 Delaware Ohio 39041 43932 263
2273836 2273836 2022-03-04 Delaware Ohio 39041 43910 263
2270583 2270583 2022-03-03 Delaware Ohio 39041 43899 262
2267331 2267331 2022-03-02 Delaware Ohio 39041 43883 262
2264078 2264078 2022-03-01 Delaware Ohio 39041 43873 262
2260828 2260828 2022-02-28 Delaware Ohio 39041 43858 260
2257577 2257577 2022-02-27 Delaware Ohio 39041 43830 260
2254326 2254326 2022-02-26 Delaware Ohio 39041 43821 260
2251075 2251075 2022-02-25 Delaware Ohio 39041 43804 260
2247824 2247824 2022-02-24 Delaware Ohio 39041 43796 259
2244573 2244573 2022-02-23 Delaware Ohio 39041 43778 259
2241322 2241322 2022-02-22 Delaware Ohio 39041 43763 259
2238071 2238071 2022-02-21 Delaware Ohio 39041 43733 251
2234820 2234820 2022-02-20 Delaware Ohio 39041 43720 251
2231569 2231569 2022-02-19 Delaware Ohio 39041 43697 251
2228318 2228318 2022-02-18 Delaware Ohio 39041 43672 251
2225067 2225067 2022-02-17 Delaware Ohio 39041 43643 250
2221816 2221816 2022-02-16 Delaware Ohio 39041 43614 250
2218565 2218565 2022-02-15 Delaware Ohio 39041 43580 250
2215314 2215314 2022-02-14 Delaware Ohio 39041 43541 248
2212063 2212063 2022-02-13 Delaware Ohio 39041 43508 248
2208810 2208810 2022-02-12 Delaware Ohio 39041 43476 248
2205557 2205557 2022-02-11 Delaware Ohio 39041 43447 248
2202304 2202304 2022-02-10 Delaware Ohio 39041 43409 245
2199050 2199050 2022-02-09 Delaware Ohio 39041 43350 245
2195796 2195796 2022-02-08 Delaware Ohio 39041 43320 245
2192542 2192542 2022-02-07 Delaware Ohio 39041 43207 241
2189288 2189288 2022-02-06 Delaware Ohio 39041 43161 241
2186035 2186035 2022-02-05 Delaware Ohio 39041 43120 241
2182783 2182783 2022-02-04 Delaware Ohio 39041 43075 241
2179531 2179531 2022-02-03 Delaware Ohio 39041 43013 234

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