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

770 rows where county = "Adams" 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 · 770 ✖

fips 1

county 1

  • Adams · 770 ✖
Link rowid date ▲ county state fips cases deaths
2501644 2501644 2022-05-13 Adams Ohio 39001 7022 148
2498386 2498386 2022-05-12 Adams Ohio 39001 7022 148
2495128 2495128 2022-05-11 Adams Ohio 39001 6999 148
2491870 2491870 2022-05-10 Adams Ohio 39001 6999 148
2488612 2488612 2022-05-09 Adams Ohio 39001 6999 148
2485355 2485355 2022-05-08 Adams Ohio 39001 6999 148
2482097 2482097 2022-05-07 Adams Ohio 39001 6999 148
2478839 2478839 2022-05-06 Adams Ohio 39001 6999 148
2475581 2475581 2022-05-05 Adams Ohio 39001 6999 148
2472324 2472324 2022-05-04 Adams Ohio 39001 6986 148
2469068 2469068 2022-05-03 Adams Ohio 39001 6986 148
2465812 2465812 2022-05-02 Adams Ohio 39001 6986 148
2462557 2462557 2022-05-01 Adams Ohio 39001 6986 148
2459301 2459301 2022-04-30 Adams Ohio 39001 6986 148
2456045 2456045 2022-04-29 Adams Ohio 39001 6986 148
2452789 2452789 2022-04-28 Adams Ohio 39001 6986 148
2449533 2449533 2022-04-27 Adams Ohio 39001 6980 148
2446276 2446276 2022-04-26 Adams Ohio 39001 6980 148
2443021 2443021 2022-04-25 Adams Ohio 39001 6980 148
2439765 2439765 2022-04-24 Adams Ohio 39001 6980 148
2436509 2436509 2022-04-23 Adams Ohio 39001 6980 148
2433253 2433253 2022-04-22 Adams Ohio 39001 6980 148
2429997 2429997 2022-04-21 Adams Ohio 39001 6980 148
2426741 2426741 2022-04-20 Adams Ohio 39001 6971 147
2423485 2423485 2022-04-19 Adams Ohio 39001 6971 147
2420228 2420228 2022-04-18 Adams Ohio 39001 6971 147
2416973 2416973 2022-04-17 Adams Ohio 39001 6971 147
2413717 2413717 2022-04-16 Adams Ohio 39001 6971 147
2410461 2410461 2022-04-15 Adams Ohio 39001 6971 147
2407205 2407205 2022-04-14 Adams Ohio 39001 6971 147
2403949 2403949 2022-04-13 Adams Ohio 39001 6966 146
2400694 2400694 2022-04-12 Adams Ohio 39001 6966 146
2397439 2397439 2022-04-11 Adams Ohio 39001 6966 146
2394184 2394184 2022-04-10 Adams Ohio 39001 6966 146
2390928 2390928 2022-04-09 Adams Ohio 39001 6966 146
2387672 2387672 2022-04-08 Adams Ohio 39001 6966 146
2384417 2384417 2022-04-07 Adams Ohio 39001 6966 146
2381162 2381162 2022-04-06 Adams Ohio 39001 6948 145
2377907 2377907 2022-04-05 Adams Ohio 39001 6948 145
2374653 2374653 2022-04-04 Adams Ohio 39001 6948 145
2371401 2371401 2022-04-03 Adams Ohio 39001 6948 145
2368148 2368148 2022-04-02 Adams Ohio 39001 6948 145
2364895 2364895 2022-04-01 Adams Ohio 39001 6948 145
2361642 2361642 2022-03-31 Adams Ohio 39001 6948 145
2358388 2358388 2022-03-30 Adams Ohio 39001 6931 142
2355134 2355134 2022-03-29 Adams Ohio 39001 6931 142
2351881 2351881 2022-03-28 Adams Ohio 39001 6931 142
2348629 2348629 2022-03-27 Adams Ohio 39001 6931 142
2345376 2345376 2022-03-26 Adams Ohio 39001 6931 142
2342123 2342123 2022-03-25 Adams Ohio 39001 6931 142
2338870 2338870 2022-03-24 Adams Ohio 39001 6931 142
2335616 2335616 2022-03-23 Adams Ohio 39001 6918 141
2332362 2332362 2022-03-22 Adams Ohio 39001 6918 141
2329109 2329109 2022-03-21 Adams Ohio 39001 6918 141
2325857 2325857 2022-03-20 Adams Ohio 39001 6918 141
2322604 2322604 2022-03-19 Adams Ohio 39001 6918 141
2319350 2319350 2022-03-18 Adams Ohio 39001 6918 141
2316096 2316096 2022-03-17 Adams Ohio 39001 6918 141
2312843 2312843 2022-03-16 Adams Ohio 39001 6915 141
2309590 2309590 2022-03-15 Adams Ohio 39001 6915 141
2306337 2306337 2022-03-14 Adams Ohio 39001 6915 141
2303086 2303086 2022-03-13 Adams Ohio 39001 6915 141
2299834 2299834 2022-03-12 Adams Ohio 39001 6915 141
2296582 2296582 2022-03-11 Adams Ohio 39001 6917 141
2293330 2293330 2022-03-10 Adams Ohio 39001 6917 139
2290078 2290078 2022-03-09 Adams Ohio 39001 6914 139
2286826 2286826 2022-03-08 Adams Ohio 39001 6910 139
2283574 2283574 2022-03-07 Adams Ohio 39001 6911 138
2280322 2280322 2022-03-06 Adams Ohio 39001 6911 138
2277069 2277069 2022-03-05 Adams Ohio 39001 6911 138
2273816 2273816 2022-03-04 Adams Ohio 39001 6906 138
2270563 2270563 2022-03-03 Adams Ohio 39001 6903 138
2267311 2267311 2022-03-02 Adams Ohio 39001 6899 138
2264058 2264058 2022-03-01 Adams Ohio 39001 6896 138
2260808 2260808 2022-02-28 Adams Ohio 39001 6891 138
2257557 2257557 2022-02-27 Adams Ohio 39001 6889 138
2254306 2254306 2022-02-26 Adams Ohio 39001 6887 138
2251055 2251055 2022-02-25 Adams Ohio 39001 6885 138
2247804 2247804 2022-02-24 Adams Ohio 39001 6872 137
2244553 2244553 2022-02-23 Adams Ohio 39001 6868 137
2241302 2241302 2022-02-22 Adams Ohio 39001 6864 137
2238051 2238051 2022-02-21 Adams Ohio 39001 6857 136
2234800 2234800 2022-02-20 Adams Ohio 39001 6855 136
2231549 2231549 2022-02-19 Adams Ohio 39001 6853 136
2228298 2228298 2022-02-18 Adams Ohio 39001 6850 136
2225047 2225047 2022-02-17 Adams Ohio 39001 6841 136
2221796 2221796 2022-02-16 Adams Ohio 39001 6837 136
2218545 2218545 2022-02-15 Adams Ohio 39001 6819 136
2215294 2215294 2022-02-14 Adams Ohio 39001 6809 134
2212043 2212043 2022-02-13 Adams Ohio 39001 6804 134
2208790 2208790 2022-02-12 Adams Ohio 39001 6796 134
2205537 2205537 2022-02-11 Adams Ohio 39001 6788 134
2202284 2202284 2022-02-10 Adams Ohio 39001 6775 133
2199030 2199030 2022-02-09 Adams Ohio 39001 6757 133
2195776 2195776 2022-02-08 Adams Ohio 39001 6732 133
2192522 2192522 2022-02-07 Adams Ohio 39001 6711 132
2189268 2189268 2022-02-06 Adams Ohio 39001 6690 132
2186015 2186015 2022-02-05 Adams Ohio 39001 6685 132
2182763 2182763 2022-02-04 Adams Ohio 39001 6675 132
2179511 2179511 2022-02-03 Adams Ohio 39001 6667 132

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