ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 169 ✖
- 0 36
- 306 32
- 8 25
- 57 14
- 299 14
- 315 14
- 585 14
- 2 13
- 11 12
- 308 11
- 3 10
- 297 10
- 307 10
- 6 9
- 304 9
- 9 8
- 52 8
- 62 8
- 293 8
- 301 8
- 10 7
- 14 7
- 279 7
- 282 7
- 320 7
- 382 7
- 387 7
- 406 7
- 514 7
- 566 7
- 568 7
- 575 7
- 580 7
- 581 7
- 584 7
- 13 6
- 16 6
- 36 6
- 64 6
- 150 6
- 179 6
- 266 6
- 288 6
- 303 6
- 335 6
- 559 6
- 38 5
- 40 5
- 58 5
- 186 5
- 260 5
- 264 5
- 265 5
- 318 5
- 332 5
- 7 4
- 27 4
- 41 4
- 54 4
- 248 4
- 256 4
- 280 4
- 287 4
- 294 4
- 310 4
- 314 4
- 321 4
- 325 4
- 328 4
- 333 4
- 334 4
- 341 4
- 349 4
- 354 4
- 364 4
- 369 4
- 379 4
- 390 4
- 400 4
- 402 4
- 412 4
- 424 4
- 440 4
- 453 4
- 469 4
- 488 4
- 508 4
- 535 4
- 547 4
- 1 3
- 4 3
- 15 3
- 19 3
- 31 3
- 42 3
- 147 3
- 272 3
- 286 3
- 295 3
- 302 3
- 309 3
- 312 3
- 316 3
- 319 3
- 346 3
- 351 3
- 360 3
- 367 3
- 371 3
- 380 3
- 391 3
- 401 3
- 403 3
- 416 3
- 430 3
- 445 3
- 463 3
- 479 3
- 497 3
- 527 3
- 543 3
- 555 3
- 5 2
- 21 2
- 28 2
- 29 2
- 30 2
- 56 2
- 101 2
- 129 2
- 131 2
- 144 2
- 172 2
- 173 2
- 247 2
- 317 2
- 336 2
- 586 2
- 12 1
- 17 1
- 20 1
- 23 1
- 33 1
- 37 1
- 39 1
- 47 1
- 49 1
- 53 1
- 137 1
- 140 1
- 142 1
- 143 1
- 146 1
- 148 1
- 152 1
- 184 1
- 189 1
- 207 1
- 240 1
- 244 1
- 251 1
- 261 1
- 263 1
- 281 1
- 289 1
- 300 1
- 329 1
- 330 1
- 331 1
state 1
- Ohio 787
fips 1
- 39023 · 787 ✖
county 1
- Clark 787
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501655 | 2501655 | 2022-05-13 | Clark | Ohio | 39023 | 35217 | 586 |
2498397 | 2498397 | 2022-05-12 | Clark | Ohio | 39023 | 35217 | 586 |
2495139 | 2495139 | 2022-05-11 | Clark | Ohio | 39023 | 35090 | 585 |
2491881 | 2491881 | 2022-05-10 | Clark | Ohio | 39023 | 35090 | 585 |
2488623 | 2488623 | 2022-05-09 | Clark | Ohio | 39023 | 35090 | 585 |
2485366 | 2485366 | 2022-05-08 | Clark | Ohio | 39023 | 35090 | 585 |
2482108 | 2482108 | 2022-05-07 | Clark | Ohio | 39023 | 35090 | 585 |
2478850 | 2478850 | 2022-05-06 | Clark | Ohio | 39023 | 35090 | 585 |
2475592 | 2475592 | 2022-05-05 | Clark | Ohio | 39023 | 35090 | 585 |
2472335 | 2472335 | 2022-05-04 | Clark | Ohio | 39023 | 35039 | 585 |
2469079 | 2469079 | 2022-05-03 | Clark | Ohio | 39023 | 35039 | 585 |
2465823 | 2465823 | 2022-05-02 | Clark | Ohio | 39023 | 35039 | 585 |
2462568 | 2462568 | 2022-05-01 | Clark | Ohio | 39023 | 35039 | 585 |
2459312 | 2459312 | 2022-04-30 | Clark | Ohio | 39023 | 35039 | 585 |
2456056 | 2456056 | 2022-04-29 | Clark | Ohio | 39023 | 35039 | 585 |
2452800 | 2452800 | 2022-04-28 | Clark | Ohio | 39023 | 35039 | 585 |
2449544 | 2449544 | 2022-04-27 | Clark | Ohio | 39023 | 34986 | 584 |
2446287 | 2446287 | 2022-04-26 | Clark | Ohio | 39023 | 34986 | 584 |
2443032 | 2443032 | 2022-04-25 | Clark | Ohio | 39023 | 34986 | 584 |
2439776 | 2439776 | 2022-04-24 | Clark | Ohio | 39023 | 34986 | 584 |
2436520 | 2436520 | 2022-04-23 | Clark | Ohio | 39023 | 34986 | 584 |
2433264 | 2433264 | 2022-04-22 | Clark | Ohio | 39023 | 34986 | 584 |
2430008 | 2430008 | 2022-04-21 | Clark | Ohio | 39023 | 34986 | 584 |
2426752 | 2426752 | 2022-04-20 | Clark | Ohio | 39023 | 34957 | 581 |
2423496 | 2423496 | 2022-04-19 | Clark | Ohio | 39023 | 34957 | 581 |
2420239 | 2420239 | 2022-04-18 | Clark | Ohio | 39023 | 34957 | 581 |
2416984 | 2416984 | 2022-04-17 | Clark | Ohio | 39023 | 34957 | 581 |
2413728 | 2413728 | 2022-04-16 | Clark | Ohio | 39023 | 34957 | 581 |
2410472 | 2410472 | 2022-04-15 | Clark | Ohio | 39023 | 34957 | 581 |
2407216 | 2407216 | 2022-04-14 | Clark | Ohio | 39023 | 34957 | 581 |
2403960 | 2403960 | 2022-04-13 | Clark | Ohio | 39023 | 34938 | 580 |
2400705 | 2400705 | 2022-04-12 | Clark | Ohio | 39023 | 34938 | 580 |
2397450 | 2397450 | 2022-04-11 | Clark | Ohio | 39023 | 34938 | 580 |
2394195 | 2394195 | 2022-04-10 | Clark | Ohio | 39023 | 34938 | 580 |
2390939 | 2390939 | 2022-04-09 | Clark | Ohio | 39023 | 34938 | 580 |
2387683 | 2387683 | 2022-04-08 | Clark | Ohio | 39023 | 34938 | 580 |
2384428 | 2384428 | 2022-04-07 | Clark | Ohio | 39023 | 34938 | 580 |
2381173 | 2381173 | 2022-04-06 | Clark | Ohio | 39023 | 34930 | 575 |
2377918 | 2377918 | 2022-04-05 | Clark | Ohio | 39023 | 34930 | 575 |
2374664 | 2374664 | 2022-04-04 | Clark | Ohio | 39023 | 34930 | 575 |
2371412 | 2371412 | 2022-04-03 | Clark | Ohio | 39023 | 34930 | 575 |
2368159 | 2368159 | 2022-04-02 | Clark | Ohio | 39023 | 34930 | 575 |
2364906 | 2364906 | 2022-04-01 | Clark | Ohio | 39023 | 34930 | 575 |
2361653 | 2361653 | 2022-03-31 | Clark | Ohio | 39023 | 34930 | 575 |
2358399 | 2358399 | 2022-03-30 | Clark | Ohio | 39023 | 34913 | 568 |
2355145 | 2355145 | 2022-03-29 | Clark | Ohio | 39023 | 34913 | 568 |
2351892 | 2351892 | 2022-03-28 | Clark | Ohio | 39023 | 34913 | 568 |
2348640 | 2348640 | 2022-03-27 | Clark | Ohio | 39023 | 34913 | 568 |
2345387 | 2345387 | 2022-03-26 | Clark | Ohio | 39023 | 34913 | 568 |
2342134 | 2342134 | 2022-03-25 | Clark | Ohio | 39023 | 34913 | 568 |
2338881 | 2338881 | 2022-03-24 | Clark | Ohio | 39023 | 34913 | 568 |
2335627 | 2335627 | 2022-03-23 | Clark | Ohio | 39023 | 34903 | 566 |
2332373 | 2332373 | 2022-03-22 | Clark | Ohio | 39023 | 34903 | 566 |
2329120 | 2329120 | 2022-03-21 | Clark | Ohio | 39023 | 34903 | 566 |
2325868 | 2325868 | 2022-03-20 | Clark | Ohio | 39023 | 34903 | 566 |
2322615 | 2322615 | 2022-03-19 | Clark | Ohio | 39023 | 34903 | 566 |
2319361 | 2319361 | 2022-03-18 | Clark | Ohio | 39023 | 34903 | 566 |
2316107 | 2316107 | 2022-03-17 | Clark | Ohio | 39023 | 34903 | 566 |
2312854 | 2312854 | 2022-03-16 | Clark | Ohio | 39023 | 34893 | 559 |
2309601 | 2309601 | 2022-03-15 | Clark | Ohio | 39023 | 34893 | 559 |
2306348 | 2306348 | 2022-03-14 | Clark | Ohio | 39023 | 34893 | 559 |
2303097 | 2303097 | 2022-03-13 | Clark | Ohio | 39023 | 34893 | 559 |
2299845 | 2299845 | 2022-03-12 | Clark | Ohio | 39023 | 34890 | 559 |
2296593 | 2296593 | 2022-03-11 | Clark | Ohio | 39023 | 34886 | 559 |
2293341 | 2293341 | 2022-03-10 | Clark | Ohio | 39023 | 34880 | 555 |
2290089 | 2290089 | 2022-03-09 | Clark | Ohio | 39023 | 34875 | 555 |
2286837 | 2286837 | 2022-03-08 | Clark | Ohio | 39023 | 34869 | 555 |
2283585 | 2283585 | 2022-03-07 | Clark | Ohio | 39023 | 34864 | 547 |
2280333 | 2280333 | 2022-03-06 | Clark | Ohio | 39023 | 34863 | 547 |
2277080 | 2277080 | 2022-03-05 | Clark | Ohio | 39023 | 34858 | 547 |
2273827 | 2273827 | 2022-03-04 | Clark | Ohio | 39023 | 34849 | 547 |
2270574 | 2270574 | 2022-03-03 | Clark | Ohio | 39023 | 34837 | 543 |
2267322 | 2267322 | 2022-03-02 | Clark | Ohio | 39023 | 34825 | 543 |
2264069 | 2264069 | 2022-03-01 | Clark | Ohio | 39023 | 34817 | 543 |
2260819 | 2260819 | 2022-02-28 | Clark | Ohio | 39023 | 34800 | 535 |
2257568 | 2257568 | 2022-02-27 | Clark | Ohio | 39023 | 34796 | 535 |
2254317 | 2254317 | 2022-02-26 | Clark | Ohio | 39023 | 34788 | 535 |
2251066 | 2251066 | 2022-02-25 | Clark | Ohio | 39023 | 34774 | 535 |
2247815 | 2247815 | 2022-02-24 | Clark | Ohio | 39023 | 34766 | 527 |
2244564 | 2244564 | 2022-02-23 | Clark | Ohio | 39023 | 34751 | 527 |
2241313 | 2241313 | 2022-02-22 | Clark | Ohio | 39023 | 34726 | 527 |
2238062 | 2238062 | 2022-02-21 | Clark | Ohio | 39023 | 34702 | 514 |
2234811 | 2234811 | 2022-02-20 | Clark | Ohio | 39023 | 34694 | 514 |
2231560 | 2231560 | 2022-02-19 | Clark | Ohio | 39023 | 34667 | 514 |
2228309 | 2228309 | 2022-02-18 | Clark | Ohio | 39023 | 34643 | 514 |
2225058 | 2225058 | 2022-02-17 | Clark | Ohio | 39023 | 34617 | 514 |
2221807 | 2221807 | 2022-02-16 | Clark | Ohio | 39023 | 34579 | 514 |
2218556 | 2218556 | 2022-02-15 | Clark | Ohio | 39023 | 34560 | 514 |
2215305 | 2215305 | 2022-02-14 | Clark | Ohio | 39023 | 34527 | 508 |
2212054 | 2212054 | 2022-02-13 | Clark | Ohio | 39023 | 34504 | 508 |
2208801 | 2208801 | 2022-02-12 | Clark | Ohio | 39023 | 34480 | 508 |
2205548 | 2205548 | 2022-02-11 | Clark | Ohio | 39023 | 34440 | 508 |
2202295 | 2202295 | 2022-02-10 | Clark | Ohio | 39023 | 34393 | 497 |
2199041 | 2199041 | 2022-02-09 | Clark | Ohio | 39023 | 34328 | 497 |
2195787 | 2195787 | 2022-02-08 | Clark | Ohio | 39023 | 34254 | 497 |
2192533 | 2192533 | 2022-02-07 | Clark | Ohio | 39023 | 34195 | 488 |
2189279 | 2189279 | 2022-02-06 | Clark | Ohio | 39023 | 34168 | 488 |
2186026 | 2186026 | 2022-02-05 | Clark | Ohio | 39023 | 34121 | 488 |
2182774 | 2182774 | 2022-02-04 | Clark | Ohio | 39023 | 34066 | 488 |
2179522 | 2179522 | 2022-02-03 | Clark | Ohio | 39023 | 34005 | 479 |
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);