ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Preble", fips = 39135 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501711 | 2501711 | 2022-05-13 | Preble | Ohio | 39135 | 9494 | 201 |
2498453 | 2498453 | 2022-05-12 | Preble | Ohio | 39135 | 9494 | 201 |
2495195 | 2495195 | 2022-05-11 | Preble | Ohio | 39135 | 9476 | 199 |
2491937 | 2491937 | 2022-05-10 | Preble | Ohio | 39135 | 9476 | 199 |
2488679 | 2488679 | 2022-05-09 | Preble | Ohio | 39135 | 9476 | 199 |
2485422 | 2485422 | 2022-05-08 | Preble | Ohio | 39135 | 9476 | 199 |
2482164 | 2482164 | 2022-05-07 | Preble | Ohio | 39135 | 9476 | 199 |
2478906 | 2478906 | 2022-05-06 | Preble | Ohio | 39135 | 9476 | 199 |
2475648 | 2475648 | 2022-05-05 | Preble | Ohio | 39135 | 9476 | 199 |
2472391 | 2472391 | 2022-05-04 | Preble | Ohio | 39135 | 9472 | 198 |
2469135 | 2469135 | 2022-05-03 | Preble | Ohio | 39135 | 9472 | 198 |
2465879 | 2465879 | 2022-05-02 | Preble | Ohio | 39135 | 9472 | 198 |
2462624 | 2462624 | 2022-05-01 | Preble | Ohio | 39135 | 9472 | 198 |
2459368 | 2459368 | 2022-04-30 | Preble | Ohio | 39135 | 9472 | 198 |
2456112 | 2456112 | 2022-04-29 | Preble | Ohio | 39135 | 9472 | 198 |
2452856 | 2452856 | 2022-04-28 | Preble | Ohio | 39135 | 9472 | 198 |
2449600 | 2449600 | 2022-04-27 | Preble | Ohio | 39135 | 9459 | 197 |
2446343 | 2446343 | 2022-04-26 | Preble | Ohio | 39135 | 9459 | 197 |
2443088 | 2443088 | 2022-04-25 | Preble | Ohio | 39135 | 9459 | 197 |
2439832 | 2439832 | 2022-04-24 | Preble | Ohio | 39135 | 9459 | 197 |
2436576 | 2436576 | 2022-04-23 | Preble | Ohio | 39135 | 9459 | 197 |
2433320 | 2433320 | 2022-04-22 | Preble | Ohio | 39135 | 9459 | 197 |
2430064 | 2430064 | 2022-04-21 | Preble | Ohio | 39135 | 9459 | 197 |
2426808 | 2426808 | 2022-04-20 | Preble | Ohio | 39135 | 9455 | 197 |
2423552 | 2423552 | 2022-04-19 | Preble | Ohio | 39135 | 9455 | 197 |
2420295 | 2420295 | 2022-04-18 | Preble | Ohio | 39135 | 9455 | 197 |
2417040 | 2417040 | 2022-04-17 | Preble | Ohio | 39135 | 9455 | 197 |
2413784 | 2413784 | 2022-04-16 | Preble | Ohio | 39135 | 9455 | 197 |
2410528 | 2410528 | 2022-04-15 | Preble | Ohio | 39135 | 9455 | 197 |
2407272 | 2407272 | 2022-04-14 | Preble | Ohio | 39135 | 9455 | 197 |
2404016 | 2404016 | 2022-04-13 | Preble | Ohio | 39135 | 9453 | 197 |
2400761 | 2400761 | 2022-04-12 | Preble | Ohio | 39135 | 9453 | 197 |
2397506 | 2397506 | 2022-04-11 | Preble | Ohio | 39135 | 9453 | 197 |
2394251 | 2394251 | 2022-04-10 | Preble | Ohio | 39135 | 9453 | 197 |
2390995 | 2390995 | 2022-04-09 | Preble | Ohio | 39135 | 9453 | 197 |
2387739 | 2387739 | 2022-04-08 | Preble | Ohio | 39135 | 9453 | 197 |
2384484 | 2384484 | 2022-04-07 | Preble | Ohio | 39135 | 9453 | 197 |
2381229 | 2381229 | 2022-04-06 | Preble | Ohio | 39135 | 9449 | 196 |
2377974 | 2377974 | 2022-04-05 | Preble | Ohio | 39135 | 9449 | 196 |
2374720 | 2374720 | 2022-04-04 | Preble | Ohio | 39135 | 9449 | 196 |
2371468 | 2371468 | 2022-04-03 | Preble | Ohio | 39135 | 9449 | 196 |
2368215 | 2368215 | 2022-04-02 | Preble | Ohio | 39135 | 9449 | 196 |
2364962 | 2364962 | 2022-04-01 | Preble | Ohio | 39135 | 9449 | 196 |
2361709 | 2361709 | 2022-03-31 | Preble | Ohio | 39135 | 9449 | 196 |
2358455 | 2358455 | 2022-03-30 | Preble | Ohio | 39135 | 9445 | 195 |
2355201 | 2355201 | 2022-03-29 | Preble | Ohio | 39135 | 9445 | 195 |
2351948 | 2351948 | 2022-03-28 | Preble | Ohio | 39135 | 9445 | 195 |
2348696 | 2348696 | 2022-03-27 | Preble | Ohio | 39135 | 9445 | 195 |
2345443 | 2345443 | 2022-03-26 | Preble | Ohio | 39135 | 9445 | 195 |
2342190 | 2342190 | 2022-03-25 | Preble | Ohio | 39135 | 9445 | 195 |
2338937 | 2338937 | 2022-03-24 | Preble | Ohio | 39135 | 9445 | 195 |
2335683 | 2335683 | 2022-03-23 | Preble | Ohio | 39135 | 9437 | 194 |
2332429 | 2332429 | 2022-03-22 | Preble | Ohio | 39135 | 9437 | 194 |
2329176 | 2329176 | 2022-03-21 | Preble | Ohio | 39135 | 9437 | 194 |
2325924 | 2325924 | 2022-03-20 | Preble | Ohio | 39135 | 9437 | 194 |
2322671 | 2322671 | 2022-03-19 | Preble | Ohio | 39135 | 9437 | 194 |
2319417 | 2319417 | 2022-03-18 | Preble | Ohio | 39135 | 9437 | 194 |
2316163 | 2316163 | 2022-03-17 | Preble | Ohio | 39135 | 9437 | 194 |
2312910 | 2312910 | 2022-03-16 | Preble | Ohio | 39135 | 9435 | 195 |
2309657 | 2309657 | 2022-03-15 | Preble | Ohio | 39135 | 9435 | 195 |
2306404 | 2306404 | 2022-03-14 | Preble | Ohio | 39135 | 9435 | 195 |
2303153 | 2303153 | 2022-03-13 | Preble | Ohio | 39135 | 9435 | 195 |
2299901 | 2299901 | 2022-03-12 | Preble | Ohio | 39135 | 9434 | 195 |
2296649 | 2296649 | 2022-03-11 | Preble | Ohio | 39135 | 9434 | 195 |
2293397 | 2293397 | 2022-03-10 | Preble | Ohio | 39135 | 9434 | 193 |
2290145 | 2290145 | 2022-03-09 | Preble | Ohio | 39135 | 9427 | 193 |
2286893 | 2286893 | 2022-03-08 | Preble | Ohio | 39135 | 9423 | 193 |
2283641 | 2283641 | 2022-03-07 | Preble | Ohio | 39135 | 9421 | 192 |
2280389 | 2280389 | 2022-03-06 | Preble | Ohio | 39135 | 9420 | 192 |
2277136 | 2277136 | 2022-03-05 | Preble | Ohio | 39135 | 9419 | 192 |
2273883 | 2273883 | 2022-03-04 | Preble | Ohio | 39135 | 9416 | 192 |
2270630 | 2270630 | 2022-03-03 | Preble | Ohio | 39135 | 9408 | 191 |
2267378 | 2267378 | 2022-03-02 | Preble | Ohio | 39135 | 9398 | 191 |
2264125 | 2264125 | 2022-03-01 | Preble | Ohio | 39135 | 9395 | 191 |
2260875 | 2260875 | 2022-02-28 | Preble | Ohio | 39135 | 9391 | 189 |
2257624 | 2257624 | 2022-02-27 | Preble | Ohio | 39135 | 9388 | 189 |
2254373 | 2254373 | 2022-02-26 | Preble | Ohio | 39135 | 9386 | 189 |
2251122 | 2251122 | 2022-02-25 | Preble | Ohio | 39135 | 9380 | 189 |
2247871 | 2247871 | 2022-02-24 | Preble | Ohio | 39135 | 9374 | 189 |
2244620 | 2244620 | 2022-02-23 | Preble | Ohio | 39135 | 9363 | 189 |
2241369 | 2241369 | 2022-02-22 | Preble | Ohio | 39135 | 9348 | 189 |
2238118 | 2238118 | 2022-02-21 | Preble | Ohio | 39135 | 9345 | 183 |
2234867 | 2234867 | 2022-02-20 | Preble | Ohio | 39135 | 9343 | 183 |
2231616 | 2231616 | 2022-02-19 | Preble | Ohio | 39135 | 9341 | 183 |
2228365 | 2228365 | 2022-02-18 | Preble | Ohio | 39135 | 9331 | 183 |
2225114 | 2225114 | 2022-02-17 | Preble | Ohio | 39135 | 9323 | 183 |
2221863 | 2221863 | 2022-02-16 | Preble | Ohio | 39135 | 9314 | 183 |
2218612 | 2218612 | 2022-02-15 | Preble | Ohio | 39135 | 9305 | 183 |
2215361 | 2215361 | 2022-02-14 | Preble | Ohio | 39135 | 9299 | 182 |
2212110 | 2212110 | 2022-02-13 | Preble | Ohio | 39135 | 9291 | 182 |
2208857 | 2208857 | 2022-02-12 | Preble | Ohio | 39135 | 9287 | 182 |
2205604 | 2205604 | 2022-02-11 | Preble | Ohio | 39135 | 9287 | 182 |
2202351 | 2202351 | 2022-02-10 | Preble | Ohio | 39135 | 9263 | 179 |
2199097 | 2199097 | 2022-02-09 | Preble | Ohio | 39135 | 9223 | 179 |
2195843 | 2195843 | 2022-02-08 | Preble | Ohio | 39135 | 9183 | 179 |
2192589 | 2192589 | 2022-02-07 | Preble | Ohio | 39135 | 9148 | 179 |
2189335 | 2189335 | 2022-02-06 | Preble | Ohio | 39135 | 9136 | 179 |
2186082 | 2186082 | 2022-02-05 | Preble | Ohio | 39135 | 9123 | 179 |
2182830 | 2182830 | 2022-02-04 | Preble | Ohio | 39135 | 9095 | 179 |
2179578 | 2179578 | 2022-02-03 | Preble | Ohio | 39135 | 9041 | 178 |
Advanced export
JSON shape: default, array, newline-delimited
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);