ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 39025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 184 ✖
- 6 32
- 5 19
- 1 17
- 3 16
- 11 16
- 0 13
- 7 11
- 15 11
- 219 11
- 262 11
- 76 10
- 238 10
- 253 10
- 259 10
- 261 10
- 560 9
- 2 8
- 41 8
- 9 7
- 10 7
- 23 7
- 38 7
- 221 7
- 229 7
- 247 7
- 252 7
- 502 7
- 537 7
- 543 7
- 547 7
- 549 7
- 553 7
- 556 7
- 557 7
- 13 6
- 34 6
- 36 6
- 39 6
- 210 6
- 535 6
- 20 5
- 32 5
- 42 5
- 56 5
- 206 5
- 249 5
- 256 5
- 4 4
- 17 4
- 53 4
- 59 4
- 93 4
- 117 4
- 205 4
- 211 4
- 226 4
- 231 4
- 235 4
- 240 4
- 251 4
- 254 4
- 258 4
- 260 4
- 265 4
- 268 4
- 270 4
- 275 4
- 287 4
- 297 4
- 305 4
- 313 4
- 321 4
- 330 4
- 335 4
- 342 4
- 348 4
- 356 4
- 362 4
- 369 4
- 374 4
- 390 4
- 400 4
- 405 4
- 416 4
- 428 4
- 452 4
- 457 4
- 479 4
- 491 4
- 513 4
- 524 4
- 46 3
- 57 3
- 104 3
- 111 3
- 125 3
- 200 3
- 201 3
- 223 3
- 228 3
- 232 3
- 246 3
- 255 3
- 264 3
- 266 3
- 269 3
- 271 3
- 278 3
- 292 3
- 300 3
- 306 3
- 315 3
- 326 3
- 332 3
- 338 3
- 343 3
- 352 3
- 358 3
- 363 3
- 370 3
- 378 3
- 394 3
- 403 3
- 410 3
- 418 3
- 429 3
- 454 3
- 469 3
- 483 3
- 511 3
- 518 3
- 527 3
- 12 2
- 14 2
- 16 2
- 18 2
- 37 2
- 44 2
- 45 2
- 51 2
- 54 2
- 65 2
- 78 2
- 103 2
- 120 2
- 127 2
- 198 2
- 202 2
- 250 2
- 257 2
- 8 1
- 19 1
- 21 1
- 24 1
- 40 1
- 48 1
- 58 1
- 60 1
- 62 1
- 64 1
- 73 1
- 75 1
- 80 1
- 83 1
- 86 1
- 92 1
- 94 1
- 102 1
- 105 1
- 108 1
- 110 1
- 112 1
- 113 1
- 114 1
- 122 1
- 124 1
- 126 1
- 141 1
- 182 1
- 197 1
- 203 1
- 204 1
- 208 1
- 212 1
state 1
- Ohio 784
fips 1
- 39025 · 784 ✖
county 1
- Clermont 784
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501656 | 2501656 | 2022-05-13 | Clermont | Ohio | 39025 | 51997 | 560 |
2498398 | 2498398 | 2022-05-12 | Clermont | Ohio | 39025 | 51997 | 560 |
2495140 | 2495140 | 2022-05-11 | Clermont | Ohio | 39025 | 51741 | 560 |
2491882 | 2491882 | 2022-05-10 | Clermont | Ohio | 39025 | 51741 | 560 |
2488624 | 2488624 | 2022-05-09 | Clermont | Ohio | 39025 | 51741 | 560 |
2485367 | 2485367 | 2022-05-08 | Clermont | Ohio | 39025 | 51741 | 560 |
2482109 | 2482109 | 2022-05-07 | Clermont | Ohio | 39025 | 51741 | 560 |
2478851 | 2478851 | 2022-05-06 | Clermont | Ohio | 39025 | 51741 | 560 |
2475593 | 2475593 | 2022-05-05 | Clermont | Ohio | 39025 | 51741 | 560 |
2472336 | 2472336 | 2022-05-04 | Clermont | Ohio | 39025 | 51582 | 557 |
2469080 | 2469080 | 2022-05-03 | Clermont | Ohio | 39025 | 51582 | 557 |
2465824 | 2465824 | 2022-05-02 | Clermont | Ohio | 39025 | 51582 | 557 |
2462569 | 2462569 | 2022-05-01 | Clermont | Ohio | 39025 | 51582 | 557 |
2459313 | 2459313 | 2022-04-30 | Clermont | Ohio | 39025 | 51582 | 557 |
2456057 | 2456057 | 2022-04-29 | Clermont | Ohio | 39025 | 51582 | 557 |
2452801 | 2452801 | 2022-04-28 | Clermont | Ohio | 39025 | 51582 | 557 |
2449545 | 2449545 | 2022-04-27 | Clermont | Ohio | 39025 | 51453 | 556 |
2446288 | 2446288 | 2022-04-26 | Clermont | Ohio | 39025 | 51453 | 556 |
2443033 | 2443033 | 2022-04-25 | Clermont | Ohio | 39025 | 51453 | 556 |
2439777 | 2439777 | 2022-04-24 | Clermont | Ohio | 39025 | 51453 | 556 |
2436521 | 2436521 | 2022-04-23 | Clermont | Ohio | 39025 | 51453 | 556 |
2433265 | 2433265 | 2022-04-22 | Clermont | Ohio | 39025 | 51453 | 556 |
2430009 | 2430009 | 2022-04-21 | Clermont | Ohio | 39025 | 51453 | 556 |
2426753 | 2426753 | 2022-04-20 | Clermont | Ohio | 39025 | 51337 | 553 |
2423497 | 2423497 | 2022-04-19 | Clermont | Ohio | 39025 | 51337 | 553 |
2420240 | 2420240 | 2022-04-18 | Clermont | Ohio | 39025 | 51337 | 553 |
2416985 | 2416985 | 2022-04-17 | Clermont | Ohio | 39025 | 51337 | 553 |
2413729 | 2413729 | 2022-04-16 | Clermont | Ohio | 39025 | 51337 | 553 |
2410473 | 2410473 | 2022-04-15 | Clermont | Ohio | 39025 | 51337 | 553 |
2407217 | 2407217 | 2022-04-14 | Clermont | Ohio | 39025 | 51337 | 553 |
2403961 | 2403961 | 2022-04-13 | Clermont | Ohio | 39025 | 51283 | 549 |
2400706 | 2400706 | 2022-04-12 | Clermont | Ohio | 39025 | 51283 | 549 |
2397451 | 2397451 | 2022-04-11 | Clermont | Ohio | 39025 | 51283 | 549 |
2394196 | 2394196 | 2022-04-10 | Clermont | Ohio | 39025 | 51283 | 549 |
2390940 | 2390940 | 2022-04-09 | Clermont | Ohio | 39025 | 51283 | 549 |
2387684 | 2387684 | 2022-04-08 | Clermont | Ohio | 39025 | 51283 | 549 |
2384429 | 2384429 | 2022-04-07 | Clermont | Ohio | 39025 | 51283 | 549 |
2381174 | 2381174 | 2022-04-06 | Clermont | Ohio | 39025 | 51252 | 547 |
2377919 | 2377919 | 2022-04-05 | Clermont | Ohio | 39025 | 51252 | 547 |
2374665 | 2374665 | 2022-04-04 | Clermont | Ohio | 39025 | 51252 | 547 |
2371413 | 2371413 | 2022-04-03 | Clermont | Ohio | 39025 | 51252 | 547 |
2368160 | 2368160 | 2022-04-02 | Clermont | Ohio | 39025 | 51252 | 547 |
2364907 | 2364907 | 2022-04-01 | Clermont | Ohio | 39025 | 51252 | 547 |
2361654 | 2361654 | 2022-03-31 | Clermont | Ohio | 39025 | 51252 | 547 |
2358400 | 2358400 | 2022-03-30 | Clermont | Ohio | 39025 | 51212 | 543 |
2355146 | 2355146 | 2022-03-29 | Clermont | Ohio | 39025 | 51212 | 543 |
2351893 | 2351893 | 2022-03-28 | Clermont | Ohio | 39025 | 51212 | 543 |
2348641 | 2348641 | 2022-03-27 | Clermont | Ohio | 39025 | 51212 | 543 |
2345388 | 2345388 | 2022-03-26 | Clermont | Ohio | 39025 | 51212 | 543 |
2342135 | 2342135 | 2022-03-25 | Clermont | Ohio | 39025 | 51212 | 543 |
2338882 | 2338882 | 2022-03-24 | Clermont | Ohio | 39025 | 51212 | 543 |
2335628 | 2335628 | 2022-03-23 | Clermont | Ohio | 39025 | 51131 | 537 |
2332374 | 2332374 | 2022-03-22 | Clermont | Ohio | 39025 | 51131 | 537 |
2329121 | 2329121 | 2022-03-21 | Clermont | Ohio | 39025 | 51131 | 537 |
2325869 | 2325869 | 2022-03-20 | Clermont | Ohio | 39025 | 51131 | 537 |
2322616 | 2322616 | 2022-03-19 | Clermont | Ohio | 39025 | 51131 | 537 |
2319362 | 2319362 | 2022-03-18 | Clermont | Ohio | 39025 | 51131 | 537 |
2316108 | 2316108 | 2022-03-17 | Clermont | Ohio | 39025 | 51131 | 537 |
2312855 | 2312855 | 2022-03-16 | Clermont | Ohio | 39025 | 51094 | 535 |
2309602 | 2309602 | 2022-03-15 | Clermont | Ohio | 39025 | 51094 | 535 |
2306349 | 2306349 | 2022-03-14 | Clermont | Ohio | 39025 | 51094 | 535 |
2303098 | 2303098 | 2022-03-13 | Clermont | Ohio | 39025 | 51094 | 535 |
2299846 | 2299846 | 2022-03-12 | Clermont | Ohio | 39025 | 51090 | 535 |
2296594 | 2296594 | 2022-03-11 | Clermont | Ohio | 39025 | 51081 | 535 |
2293342 | 2293342 | 2022-03-10 | Clermont | Ohio | 39025 | 51066 | 527 |
2290090 | 2290090 | 2022-03-09 | Clermont | Ohio | 39025 | 51053 | 527 |
2286838 | 2286838 | 2022-03-08 | Clermont | Ohio | 39025 | 51036 | 527 |
2283586 | 2283586 | 2022-03-07 | Clermont | Ohio | 39025 | 51031 | 524 |
2280334 | 2280334 | 2022-03-06 | Clermont | Ohio | 39025 | 51028 | 524 |
2277081 | 2277081 | 2022-03-05 | Clermont | Ohio | 39025 | 51019 | 524 |
2273828 | 2273828 | 2022-03-04 | Clermont | Ohio | 39025 | 51006 | 524 |
2270575 | 2270575 | 2022-03-03 | Clermont | Ohio | 39025 | 50992 | 518 |
2267323 | 2267323 | 2022-03-02 | Clermont | Ohio | 39025 | 50970 | 518 |
2264070 | 2264070 | 2022-03-01 | Clermont | Ohio | 39025 | 50953 | 518 |
2260820 | 2260820 | 2022-02-28 | Clermont | Ohio | 39025 | 50923 | 513 |
2257569 | 2257569 | 2022-02-27 | Clermont | Ohio | 39025 | 50911 | 513 |
2254318 | 2254318 | 2022-02-26 | Clermont | Ohio | 39025 | 50897 | 513 |
2251067 | 2251067 | 2022-02-25 | Clermont | Ohio | 39025 | 50836 | 513 |
2247816 | 2247816 | 2022-02-24 | Clermont | Ohio | 39025 | 50801 | 511 |
2244565 | 2244565 | 2022-02-23 | Clermont | Ohio | 39025 | 50786 | 511 |
2241314 | 2241314 | 2022-02-22 | Clermont | Ohio | 39025 | 50765 | 511 |
2238063 | 2238063 | 2022-02-21 | Clermont | Ohio | 39025 | 50715 | 502 |
2234812 | 2234812 | 2022-02-20 | Clermont | Ohio | 39025 | 50698 | 502 |
2231561 | 2231561 | 2022-02-19 | Clermont | Ohio | 39025 | 50680 | 502 |
2228310 | 2228310 | 2022-02-18 | Clermont | Ohio | 39025 | 50651 | 502 |
2225059 | 2225059 | 2022-02-17 | Clermont | Ohio | 39025 | 50601 | 502 |
2221808 | 2221808 | 2022-02-16 | Clermont | Ohio | 39025 | 50554 | 502 |
2218557 | 2218557 | 2022-02-15 | Clermont | Ohio | 39025 | 50501 | 502 |
2215306 | 2215306 | 2022-02-14 | Clermont | Ohio | 39025 | 50449 | 491 |
2212055 | 2212055 | 2022-02-13 | Clermont | Ohio | 39025 | 50422 | 491 |
2208802 | 2208802 | 2022-02-12 | Clermont | Ohio | 39025 | 50386 | 491 |
2205549 | 2205549 | 2022-02-11 | Clermont | Ohio | 39025 | 50325 | 491 |
2202296 | 2202296 | 2022-02-10 | Clermont | Ohio | 39025 | 50245 | 483 |
2199042 | 2199042 | 2022-02-09 | Clermont | Ohio | 39025 | 50118 | 483 |
2195788 | 2195788 | 2022-02-08 | Clermont | Ohio | 39025 | 50014 | 483 |
2192534 | 2192534 | 2022-02-07 | Clermont | Ohio | 39025 | 49887 | 479 |
2189280 | 2189280 | 2022-02-06 | Clermont | Ohio | 39025 | 49832 | 479 |
2186027 | 2186027 | 2022-02-05 | Clermont | Ohio | 39025 | 49777 | 479 |
2182775 | 2182775 | 2022-02-04 | Clermont | Ohio | 39025 | 49716 | 479 |
2179523 | 2179523 | 2022-02-03 | Clermont | Ohio | 39025 | 49607 | 469 |
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);