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

782 rows where county = "Washington" 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 · 782 ✖

fips 1

county 1

  • Washington · 782 ✖
Link rowid date ▲ county state fips cases deaths
2501728 2501728 2022-05-13 Washington Ohio 39167 12409 207
2498470 2498470 2022-05-12 Washington Ohio 39167 12409 207
2495212 2495212 2022-05-11 Washington Ohio 39167 12384 207
2491954 2491954 2022-05-10 Washington Ohio 39167 12384 207
2488696 2488696 2022-05-09 Washington Ohio 39167 12384 207
2485439 2485439 2022-05-08 Washington Ohio 39167 12384 207
2482181 2482181 2022-05-07 Washington Ohio 39167 12384 207
2478923 2478923 2022-05-06 Washington Ohio 39167 12384 207
2475665 2475665 2022-05-05 Washington Ohio 39167 12384 207
2472408 2472408 2022-05-04 Washington Ohio 39167 12369 207
2469152 2469152 2022-05-03 Washington Ohio 39167 12369 207
2465896 2465896 2022-05-02 Washington Ohio 39167 12369 207
2462641 2462641 2022-05-01 Washington Ohio 39167 12369 207
2459385 2459385 2022-04-30 Washington Ohio 39167 12369 207
2456129 2456129 2022-04-29 Washington Ohio 39167 12369 207
2452873 2452873 2022-04-28 Washington Ohio 39167 12369 207
2449617 2449617 2022-04-27 Washington Ohio 39167 12352 206
2446360 2446360 2022-04-26 Washington Ohio 39167 12352 206
2443105 2443105 2022-04-25 Washington Ohio 39167 12352 206
2439849 2439849 2022-04-24 Washington Ohio 39167 12352 206
2436593 2436593 2022-04-23 Washington Ohio 39167 12352 206
2433337 2433337 2022-04-22 Washington Ohio 39167 12352 206
2430081 2430081 2022-04-21 Washington Ohio 39167 12352 206
2426825 2426825 2022-04-20 Washington Ohio 39167 12337 206
2423569 2423569 2022-04-19 Washington Ohio 39167 12337 206
2420312 2420312 2022-04-18 Washington Ohio 39167 12337 206
2417057 2417057 2022-04-17 Washington Ohio 39167 12337 206
2413801 2413801 2022-04-16 Washington Ohio 39167 12337 206
2410545 2410545 2022-04-15 Washington Ohio 39167 12337 206
2407289 2407289 2022-04-14 Washington Ohio 39167 12337 206
2404033 2404033 2022-04-13 Washington Ohio 39167 12339 206
2400778 2400778 2022-04-12 Washington Ohio 39167 12339 206
2397523 2397523 2022-04-11 Washington Ohio 39167 12339 206
2394268 2394268 2022-04-10 Washington Ohio 39167 12339 206
2391012 2391012 2022-04-09 Washington Ohio 39167 12339 206
2387756 2387756 2022-04-08 Washington Ohio 39167 12339 206
2384501 2384501 2022-04-07 Washington Ohio 39167 12339 206
2381246 2381246 2022-04-06 Washington Ohio 39167 12341 206
2377991 2377991 2022-04-05 Washington Ohio 39167 12341 206
2374737 2374737 2022-04-04 Washington Ohio 39167 12341 206
2371485 2371485 2022-04-03 Washington Ohio 39167 12341 206
2368232 2368232 2022-04-02 Washington Ohio 39167 12341 206
2364979 2364979 2022-04-01 Washington Ohio 39167 12341 206
2361726 2361726 2022-03-31 Washington Ohio 39167 12341 206
2358472 2358472 2022-03-30 Washington Ohio 39167 12338 204
2355218 2355218 2022-03-29 Washington Ohio 39167 12338 204
2351965 2351965 2022-03-28 Washington Ohio 39167 12338 204
2348713 2348713 2022-03-27 Washington Ohio 39167 12338 204
2345460 2345460 2022-03-26 Washington Ohio 39167 12338 204
2342207 2342207 2022-03-25 Washington Ohio 39167 12338 204
2338954 2338954 2022-03-24 Washington Ohio 39167 12338 204
2335700 2335700 2022-03-23 Washington Ohio 39167 12327 203
2332446 2332446 2022-03-22 Washington Ohio 39167 12327 203
2329193 2329193 2022-03-21 Washington Ohio 39167 12327 203
2325941 2325941 2022-03-20 Washington Ohio 39167 12327 203
2322688 2322688 2022-03-19 Washington Ohio 39167 12327 203
2319434 2319434 2022-03-18 Washington Ohio 39167 12327 203
2316180 2316180 2022-03-17 Washington Ohio 39167 12327 203
2312927 2312927 2022-03-16 Washington Ohio 39167 12321 198
2309674 2309674 2022-03-15 Washington Ohio 39167 12321 198
2306421 2306421 2022-03-14 Washington Ohio 39167 12321 198
2303170 2303170 2022-03-13 Washington Ohio 39167 12321 198
2299918 2299918 2022-03-12 Washington Ohio 39167 12321 198
2296666 2296666 2022-03-11 Washington Ohio 39167 12317 198
2293414 2293414 2022-03-10 Washington Ohio 39167 12314 197
2290162 2290162 2022-03-09 Washington Ohio 39167 12310 197
2286910 2286910 2022-03-08 Washington Ohio 39167 12305 197
2283658 2283658 2022-03-07 Washington Ohio 39167 12297 196
2280406 2280406 2022-03-06 Washington Ohio 39167 12295 196
2277153 2277153 2022-03-05 Washington Ohio 39167 12290 196
2273900 2273900 2022-03-04 Washington Ohio 39167 12286 196
2270647 2270647 2022-03-03 Washington Ohio 39167 12275 195
2267395 2267395 2022-03-02 Washington Ohio 39167 12271 195
2264142 2264142 2022-03-01 Washington Ohio 39167 12265 195
2260892 2260892 2022-02-28 Washington Ohio 39167 12260 194
2257641 2257641 2022-02-27 Washington Ohio 39167 12256 194
2254390 2254390 2022-02-26 Washington Ohio 39167 12253 194
2251139 2251139 2022-02-25 Washington Ohio 39167 12244 194
2247888 2247888 2022-02-24 Washington Ohio 39167 12232 191
2244637 2244637 2022-02-23 Washington Ohio 39167 12229 191
2241386 2241386 2022-02-22 Washington Ohio 39167 12215 191
2238135 2238135 2022-02-21 Washington Ohio 39167 12199 186
2234884 2234884 2022-02-20 Washington Ohio 39167 12187 186
2231633 2231633 2022-02-19 Washington Ohio 39167 12174 186
2228382 2228382 2022-02-18 Washington Ohio 39167 12163 186
2225131 2225131 2022-02-17 Washington Ohio 39167 12149 183
2221880 2221880 2022-02-16 Washington Ohio 39167 12136 183
2218629 2218629 2022-02-15 Washington Ohio 39167 12135 183
2215378 2215378 2022-02-14 Washington Ohio 39167 12122 181
2212127 2212127 2022-02-13 Washington Ohio 39167 12096 181
2208874 2208874 2022-02-12 Washington Ohio 39167 12086 181
2205621 2205621 2022-02-11 Washington Ohio 39167 12075 181
2202368 2202368 2022-02-10 Washington Ohio 39167 12045 176
2199114 2199114 2022-02-09 Washington Ohio 39167 12014 176
2195860 2195860 2022-02-08 Washington Ohio 39167 11987 176
2192606 2192606 2022-02-07 Washington Ohio 39167 11968 176
2189352 2189352 2022-02-06 Washington Ohio 39167 11951 176
2186099 2186099 2022-02-05 Washington Ohio 39167 11933 176
2182847 2182847 2022-02-04 Washington Ohio 39167 11915 176
2179595 2179595 2022-02-03 Washington Ohio 39167 11879 173

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