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

786 rows where county = "Hamilton", fips = 39061 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 · 786 ✖

fips 1

  • 39061 · 786 ✖

county 1

  • Hamilton · 786 ✖
Link rowid date ▲ county state fips cases deaths
2501674 2501674 2022-05-13 Hamilton Ohio 39061 191030 2069
2498416 2498416 2022-05-12 Hamilton Ohio 39061 191030 2069
2495158 2495158 2022-05-11 Hamilton Ohio 39061 190031 2066
2491900 2491900 2022-05-10 Hamilton Ohio 39061 190031 2066
2488642 2488642 2022-05-09 Hamilton Ohio 39061 190031 2066
2485385 2485385 2022-05-08 Hamilton Ohio 39061 190031 2066
2482127 2482127 2022-05-07 Hamilton Ohio 39061 190031 2066
2478869 2478869 2022-05-06 Hamilton Ohio 39061 190031 2066
2475611 2475611 2022-05-05 Hamilton Ohio 39061 190031 2066
2472354 2472354 2022-05-04 Hamilton Ohio 39061 189247 2064
2469098 2469098 2022-05-03 Hamilton Ohio 39061 189247 2064
2465842 2465842 2022-05-02 Hamilton Ohio 39061 189247 2064
2462587 2462587 2022-05-01 Hamilton Ohio 39061 189247 2064
2459331 2459331 2022-04-30 Hamilton Ohio 39061 189247 2064
2456075 2456075 2022-04-29 Hamilton Ohio 39061 189247 2064
2452819 2452819 2022-04-28 Hamilton Ohio 39061 189247 2064
2449563 2449563 2022-04-27 Hamilton Ohio 39061 188603 2061
2446306 2446306 2022-04-26 Hamilton Ohio 39061 188603 2061
2443051 2443051 2022-04-25 Hamilton Ohio 39061 188603 2061
2439795 2439795 2022-04-24 Hamilton Ohio 39061 188603 2061
2436539 2436539 2022-04-23 Hamilton Ohio 39061 188603 2061
2433283 2433283 2022-04-22 Hamilton Ohio 39061 188603 2061
2430027 2430027 2022-04-21 Hamilton Ohio 39061 188603 2061
2426771 2426771 2022-04-20 Hamilton Ohio 39061 188020 2056
2423515 2423515 2022-04-19 Hamilton Ohio 39061 188020 2056
2420258 2420258 2022-04-18 Hamilton Ohio 39061 188020 2056
2417003 2417003 2022-04-17 Hamilton Ohio 39061 188020 2056
2413747 2413747 2022-04-16 Hamilton Ohio 39061 188020 2056
2410491 2410491 2022-04-15 Hamilton Ohio 39061 188020 2056
2407235 2407235 2022-04-14 Hamilton Ohio 39061 188020 2056
2403979 2403979 2022-04-13 Hamilton Ohio 39061 187652 2052
2400724 2400724 2022-04-12 Hamilton Ohio 39061 187652 2052
2397469 2397469 2022-04-11 Hamilton Ohio 39061 187652 2052
2394214 2394214 2022-04-10 Hamilton Ohio 39061 187652 2052
2390958 2390958 2022-04-09 Hamilton Ohio 39061 187652 2052
2387702 2387702 2022-04-08 Hamilton Ohio 39061 187652 2052
2384447 2384447 2022-04-07 Hamilton Ohio 39061 187652 2052
2381192 2381192 2022-04-06 Hamilton Ohio 39061 187340 2043
2377937 2377937 2022-04-05 Hamilton Ohio 39061 187340 2043
2374683 2374683 2022-04-04 Hamilton Ohio 39061 187340 2043
2371431 2371431 2022-04-03 Hamilton Ohio 39061 187340 2043
2368178 2368178 2022-04-02 Hamilton Ohio 39061 187340 2043
2364925 2364925 2022-04-01 Hamilton Ohio 39061 187340 2043
2361672 2361672 2022-03-31 Hamilton Ohio 39061 187340 2043
2358418 2358418 2022-03-30 Hamilton Ohio 39061 187117 2020
2355164 2355164 2022-03-29 Hamilton Ohio 39061 187117 2020
2351911 2351911 2022-03-28 Hamilton Ohio 39061 187117 2020
2348659 2348659 2022-03-27 Hamilton Ohio 39061 187117 2020
2345406 2345406 2022-03-26 Hamilton Ohio 39061 187117 2020
2342153 2342153 2022-03-25 Hamilton Ohio 39061 187117 2020
2338900 2338900 2022-03-24 Hamilton Ohio 39061 187117 2020
2335646 2335646 2022-03-23 Hamilton Ohio 39061 186696 2008
2332392 2332392 2022-03-22 Hamilton Ohio 39061 186696 2008
2329139 2329139 2022-03-21 Hamilton Ohio 39061 186696 2008
2325887 2325887 2022-03-20 Hamilton Ohio 39061 186696 2008
2322634 2322634 2022-03-19 Hamilton Ohio 39061 186696 2008
2319380 2319380 2022-03-18 Hamilton Ohio 39061 186696 2008
2316126 2316126 2022-03-17 Hamilton Ohio 39061 186696 2008
2312873 2312873 2022-03-16 Hamilton Ohio 39061 186546 2002
2309620 2309620 2022-03-15 Hamilton Ohio 39061 186546 2002
2306367 2306367 2022-03-14 Hamilton Ohio 39061 186546 2002
2303116 2303116 2022-03-13 Hamilton Ohio 39061 186546 2002
2299864 2299864 2022-03-12 Hamilton Ohio 39061 186524 2002
2296612 2296612 2022-03-11 Hamilton Ohio 39061 186454 2002
2293360 2293360 2022-03-10 Hamilton Ohio 39061 186385 1991
2290108 2290108 2022-03-09 Hamilton Ohio 39061 186297 1991
2286856 2286856 2022-03-08 Hamilton Ohio 39061 186207 1991
2283604 2283604 2022-03-07 Hamilton Ohio 39061 186172 1981
2280352 2280352 2022-03-06 Hamilton Ohio 39061 186151 1981
2277099 2277099 2022-03-05 Hamilton Ohio 39061 186138 1981
2273846 2273846 2022-03-04 Hamilton Ohio 39061 186082 1981
2270593 2270593 2022-03-03 Hamilton Ohio 39061 185991 1968
2267341 2267341 2022-03-02 Hamilton Ohio 39061 185931 1968
2264088 2264088 2022-03-01 Hamilton Ohio 39061 185879 1968
2260838 2260838 2022-02-28 Hamilton Ohio 39061 185836 1953
2257587 2257587 2022-02-27 Hamilton Ohio 39061 185804 1953
2254336 2254336 2022-02-26 Hamilton Ohio 39061 185765 1953
2251085 2251085 2022-02-25 Hamilton Ohio 39061 185663 1953
2247834 2247834 2022-02-24 Hamilton Ohio 39061 185527 1938
2244583 2244583 2022-02-23 Hamilton Ohio 39061 185454 1938
2241332 2241332 2022-02-22 Hamilton Ohio 39061 185367 1938
2238081 2238081 2022-02-21 Hamilton Ohio 39061 185294 1894
2234830 2234830 2022-02-20 Hamilton Ohio 39061 185240 1894
2231579 2231579 2022-02-19 Hamilton Ohio 39061 185169 1894
2228328 2228328 2022-02-18 Hamilton Ohio 39061 185072 1894
2225077 2225077 2022-02-17 Hamilton Ohio 39061 184925 1892
2221826 2221826 2022-02-16 Hamilton Ohio 39061 184793 1892
2218575 2218575 2022-02-15 Hamilton Ohio 39061 184652 1892
2215324 2215324 2022-02-14 Hamilton Ohio 39061 184514 1867
2212073 2212073 2022-02-13 Hamilton Ohio 39061 184441 1867
2208820 2208820 2022-02-12 Hamilton Ohio 39061 184335 1867
2205567 2205567 2022-02-11 Hamilton Ohio 39061 184216 1867
2202314 2202314 2022-02-10 Hamilton Ohio 39061 184019 1847
2199060 2199060 2022-02-09 Hamilton Ohio 39061 183727 1847
2195806 2195806 2022-02-08 Hamilton Ohio 39061 183421 1847
2192552 2192552 2022-02-07 Hamilton Ohio 39061 183112 1840
2189298 2189298 2022-02-06 Hamilton Ohio 39061 182955 1840
2186045 2186045 2022-02-05 Hamilton Ohio 39061 182818 1840
2182793 2182793 2022-02-04 Hamilton Ohio 39061 182640 1840
2179541 2179541 2022-02-03 Hamilton Ohio 39061 182296 1816

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