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 = "Huron" 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

  • Huron · 787 ✖
Link rowid date ▲ county state fips cases deaths
2501682 2501682 2022-05-13 Huron Ohio 39077 14626 222
2498424 2498424 2022-05-12 Huron Ohio 39077 14626 222
2495166 2495166 2022-05-11 Huron Ohio 39077 14567 222
2491908 2491908 2022-05-10 Huron Ohio 39077 14567 222
2488650 2488650 2022-05-09 Huron Ohio 39077 14567 222
2485393 2485393 2022-05-08 Huron Ohio 39077 14567 222
2482135 2482135 2022-05-07 Huron Ohio 39077 14567 222
2478877 2478877 2022-05-06 Huron Ohio 39077 14567 222
2475619 2475619 2022-05-05 Huron Ohio 39077 14567 222
2472362 2472362 2022-05-04 Huron Ohio 39077 14535 222
2469106 2469106 2022-05-03 Huron Ohio 39077 14535 222
2465850 2465850 2022-05-02 Huron Ohio 39077 14535 222
2462595 2462595 2022-05-01 Huron Ohio 39077 14535 222
2459339 2459339 2022-04-30 Huron Ohio 39077 14535 222
2456083 2456083 2022-04-29 Huron Ohio 39077 14535 222
2452827 2452827 2022-04-28 Huron Ohio 39077 14535 222
2449571 2449571 2022-04-27 Huron Ohio 39077 14520 221
2446314 2446314 2022-04-26 Huron Ohio 39077 14520 221
2443059 2443059 2022-04-25 Huron Ohio 39077 14520 221
2439803 2439803 2022-04-24 Huron Ohio 39077 14520 221
2436547 2436547 2022-04-23 Huron Ohio 39077 14520 221
2433291 2433291 2022-04-22 Huron Ohio 39077 14520 221
2430035 2430035 2022-04-21 Huron Ohio 39077 14520 221
2426779 2426779 2022-04-20 Huron Ohio 39077 14494 221
2423523 2423523 2022-04-19 Huron Ohio 39077 14494 221
2420266 2420266 2022-04-18 Huron Ohio 39077 14494 221
2417011 2417011 2022-04-17 Huron Ohio 39077 14494 221
2413755 2413755 2022-04-16 Huron Ohio 39077 14494 221
2410499 2410499 2022-04-15 Huron Ohio 39077 14494 221
2407243 2407243 2022-04-14 Huron Ohio 39077 14494 221
2403987 2403987 2022-04-13 Huron Ohio 39077 14484 220
2400732 2400732 2022-04-12 Huron Ohio 39077 14484 220
2397477 2397477 2022-04-11 Huron Ohio 39077 14484 220
2394222 2394222 2022-04-10 Huron Ohio 39077 14484 220
2390966 2390966 2022-04-09 Huron Ohio 39077 14484 220
2387710 2387710 2022-04-08 Huron Ohio 39077 14484 220
2384455 2384455 2022-04-07 Huron Ohio 39077 14484 220
2381200 2381200 2022-04-06 Huron Ohio 39077 14468 221
2377945 2377945 2022-04-05 Huron Ohio 39077 14468 221
2374691 2374691 2022-04-04 Huron Ohio 39077 14468 221
2371439 2371439 2022-04-03 Huron Ohio 39077 14468 221
2368186 2368186 2022-04-02 Huron Ohio 39077 14468 221
2364933 2364933 2022-04-01 Huron Ohio 39077 14468 221
2361680 2361680 2022-03-31 Huron Ohio 39077 14468 221
2358426 2358426 2022-03-30 Huron Ohio 39077 14454 221
2355172 2355172 2022-03-29 Huron Ohio 39077 14454 221
2351919 2351919 2022-03-28 Huron Ohio 39077 14454 221
2348667 2348667 2022-03-27 Huron Ohio 39077 14454 221
2345414 2345414 2022-03-26 Huron Ohio 39077 14454 221
2342161 2342161 2022-03-25 Huron Ohio 39077 14454 221
2338908 2338908 2022-03-24 Huron Ohio 39077 14454 221
2335654 2335654 2022-03-23 Huron Ohio 39077 14439 221
2332400 2332400 2022-03-22 Huron Ohio 39077 14439 221
2329147 2329147 2022-03-21 Huron Ohio 39077 14439 221
2325895 2325895 2022-03-20 Huron Ohio 39077 14439 221
2322642 2322642 2022-03-19 Huron Ohio 39077 14439 221
2319388 2319388 2022-03-18 Huron Ohio 39077 14439 221
2316134 2316134 2022-03-17 Huron Ohio 39077 14439 221
2312881 2312881 2022-03-16 Huron Ohio 39077 14432 220
2309628 2309628 2022-03-15 Huron Ohio 39077 14432 220
2306375 2306375 2022-03-14 Huron Ohio 39077 14432 220
2303124 2303124 2022-03-13 Huron Ohio 39077 14432 220
2299872 2299872 2022-03-12 Huron Ohio 39077 14430 220
2296620 2296620 2022-03-11 Huron Ohio 39077 14429 220
2293368 2293368 2022-03-10 Huron Ohio 39077 14428 219
2290116 2290116 2022-03-09 Huron Ohio 39077 14424 219
2286864 2286864 2022-03-08 Huron Ohio 39077 14420 219
2283612 2283612 2022-03-07 Huron Ohio 39077 14404 219
2280360 2280360 2022-03-06 Huron Ohio 39077 14404 219
2277107 2277107 2022-03-05 Huron Ohio 39077 14401 219
2273854 2273854 2022-03-04 Huron Ohio 39077 14397 219
2270601 2270601 2022-03-03 Huron Ohio 39077 14394 218
2267349 2267349 2022-03-02 Huron Ohio 39077 14391 218
2264096 2264096 2022-03-01 Huron Ohio 39077 14388 218
2260846 2260846 2022-02-28 Huron Ohio 39077 14382 217
2257595 2257595 2022-02-27 Huron Ohio 39077 14379 217
2254344 2254344 2022-02-26 Huron Ohio 39077 14371 217
2251093 2251093 2022-02-25 Huron Ohio 39077 14370 217
2247842 2247842 2022-02-24 Huron Ohio 39077 14364 217
2244591 2244591 2022-02-23 Huron Ohio 39077 14360 217
2241340 2241340 2022-02-22 Huron Ohio 39077 14348 217
2238089 2238089 2022-02-21 Huron Ohio 39077 14343 211
2234838 2234838 2022-02-20 Huron Ohio 39077 14343 211
2231587 2231587 2022-02-19 Huron Ohio 39077 14338 211
2228336 2228336 2022-02-18 Huron Ohio 39077 14333 211
2225085 2225085 2022-02-17 Huron Ohio 39077 14327 211
2221834 2221834 2022-02-16 Huron Ohio 39077 14321 211
2218583 2218583 2022-02-15 Huron Ohio 39077 14313 211
2215332 2215332 2022-02-14 Huron Ohio 39077 14309 210
2212081 2212081 2022-02-13 Huron Ohio 39077 14300 210
2208828 2208828 2022-02-12 Huron Ohio 39077 14297 210
2205575 2205575 2022-02-11 Huron Ohio 39077 14295 210
2202322 2202322 2022-02-10 Huron Ohio 39077 14270 210
2199068 2199068 2022-02-09 Huron Ohio 39077 14250 210
2195814 2195814 2022-02-08 Huron Ohio 39077 14257 210
2192560 2192560 2022-02-07 Huron Ohio 39077 14250 210
2189306 2189306 2022-02-06 Huron Ohio 39077 14242 210
2186053 2186053 2022-02-05 Huron Ohio 39077 14239 210
2182801 2182801 2022-02-04 Huron Ohio 39077 14230 210
2179549 2179549 2022-02-03 Huron Ohio 39077 14213 201

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