ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39165 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 193 ✖
- 303 32
- 584 30
- 20 26
- 0 23
- 313 18
- 21 14
- 312 14
- 42 13
- 291 10
- 11 9
- 13 9
- 59 9
- 48 8
- 298 8
- 306 8
- 28 7
- 66 7
- 72 7
- 288 7
- 290 7
- 293 7
- 300 7
- 305 7
- 310 7
- 317 7
- 377 7
- 408 7
- 412 7
- 536 7
- 558 7
- 571 7
- 573 7
- 579 7
- 581 7
- 35 6
- 39 6
- 40 6
- 41 6
- 49 6
- 70 6
- 568 6
- 10 5
- 15 5
- 19 5
- 46 5
- 58 5
- 60 5
- 140 5
- 25 4
- 75 4
- 77 4
- 95 4
- 149 4
- 155 4
- 275 4
- 281 4
- 287 4
- 294 4
- 308 4
- 316 4
- 323 4
- 328 4
- 338 4
- 345 4
- 361 4
- 369 4
- 384 4
- 393 4
- 401 4
- 417 4
- 423 4
- 433 4
- 441 4
- 449 4
- 458 4
- 468 4
- 489 4
- 503 4
- 517 4
- 532 4
- 553 4
- 27 3
- 30 3
- 67 3
- 116 3
- 121 3
- 124 3
- 128 3
- 139 3
- 264 3
- 271 3
- 277 3
- 283 3
- 295 3
- 297 3
- 301 3
- 309 3
- 314 3
- 322 3
- 326 3
- 331 3
- 341 3
- 350 3
- 365 3
- 373 3
- 389 3
- 398 3
- 404 3
- 418 3
- 425 3
- 436 3
- 444 3
- 453 3
- 465 3
- 475 3
- 493 3
- 508 3
- 526 3
- 550 3
- 561 3
- 1 2
- 3 2
- 9 2
- 12 2
- 26 2
- 33 2
- 68 2
- 74 2
- 76 2
- 79 2
- 86 2
- 100 2
- 105 2
- 109 2
- 113 2
- 122 2
- 135 2
- 160 2
- 256 2
- 270 2
- 276 2
- 307 2
- 4 1
- 5 1
- 8 1
- 14 1
- 18 1
- 24 1
- 31 1
- 34 1
- 36 1
- 38 1
- 43 1
- 44 1
- 45 1
- 55 1
- 56 1
- 63 1
- 64 1
- 69 1
- 73 1
- 81 1
- 87 1
- 88 1
- 89 1
- 90 1
- 92 1
- 101 1
- 103 1
- 106 1
- 119 1
- 120 1
- 127 1
- 130 1
- 138 1
- 141 1
- 142 1
- 144 1
- 147 1
- 148 1
- 150 1
- 152 1
- 154 1
- 173 1
- 226 1
- 257 1
- 259 1
- 260 1
- 266 1
- 267 1
- 269 1
- 272 1
- 274 1
state 1
- Ohio 785
fips 1
- 39165 · 785 ✖
county 1
- Warren 785
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501727 | 2501727 | 2022-05-13 | Warren | Ohio | 39165 | 58538 | 584 |
2498469 | 2498469 | 2022-05-12 | Warren | Ohio | 39165 | 58538 | 584 |
2495211 | 2495211 | 2022-05-11 | Warren | Ohio | 39165 | 58242 | 584 |
2491953 | 2491953 | 2022-05-10 | Warren | Ohio | 39165 | 58242 | 584 |
2488695 | 2488695 | 2022-05-09 | Warren | Ohio | 39165 | 58242 | 584 |
2485438 | 2485438 | 2022-05-08 | Warren | Ohio | 39165 | 58242 | 584 |
2482180 | 2482180 | 2022-05-07 | Warren | Ohio | 39165 | 58242 | 584 |
2478922 | 2478922 | 2022-05-06 | Warren | Ohio | 39165 | 58242 | 584 |
2475664 | 2475664 | 2022-05-05 | Warren | Ohio | 39165 | 58242 | 584 |
2472407 | 2472407 | 2022-05-04 | Warren | Ohio | 39165 | 58014 | 584 |
2469151 | 2469151 | 2022-05-03 | Warren | Ohio | 39165 | 58014 | 584 |
2465895 | 2465895 | 2022-05-02 | Warren | Ohio | 39165 | 58014 | 584 |
2462640 | 2462640 | 2022-05-01 | Warren | Ohio | 39165 | 58014 | 584 |
2459384 | 2459384 | 2022-04-30 | Warren | Ohio | 39165 | 58014 | 584 |
2456128 | 2456128 | 2022-04-29 | Warren | Ohio | 39165 | 58014 | 584 |
2452872 | 2452872 | 2022-04-28 | Warren | Ohio | 39165 | 58014 | 584 |
2449616 | 2449616 | 2022-04-27 | Warren | Ohio | 39165 | 57849 | 584 |
2446359 | 2446359 | 2022-04-26 | Warren | Ohio | 39165 | 57849 | 584 |
2443104 | 2443104 | 2022-04-25 | Warren | Ohio | 39165 | 57849 | 584 |
2439848 | 2439848 | 2022-04-24 | Warren | Ohio | 39165 | 57849 | 584 |
2436592 | 2436592 | 2022-04-23 | Warren | Ohio | 39165 | 57849 | 584 |
2433336 | 2433336 | 2022-04-22 | Warren | Ohio | 39165 | 57849 | 584 |
2430080 | 2430080 | 2022-04-21 | Warren | Ohio | 39165 | 57849 | 584 |
2426824 | 2426824 | 2022-04-20 | Warren | Ohio | 39165 | 57725 | 584 |
2423568 | 2423568 | 2022-04-19 | Warren | Ohio | 39165 | 57725 | 584 |
2420311 | 2420311 | 2022-04-18 | Warren | Ohio | 39165 | 57725 | 584 |
2417056 | 2417056 | 2022-04-17 | Warren | Ohio | 39165 | 57725 | 584 |
2413800 | 2413800 | 2022-04-16 | Warren | Ohio | 39165 | 57725 | 584 |
2410544 | 2410544 | 2022-04-15 | Warren | Ohio | 39165 | 57725 | 584 |
2407288 | 2407288 | 2022-04-14 | Warren | Ohio | 39165 | 57725 | 584 |
2404032 | 2404032 | 2022-04-13 | Warren | Ohio | 39165 | 57666 | 581 |
2400777 | 2400777 | 2022-04-12 | Warren | Ohio | 39165 | 57666 | 581 |
2397522 | 2397522 | 2022-04-11 | Warren | Ohio | 39165 | 57666 | 581 |
2394267 | 2394267 | 2022-04-10 | Warren | Ohio | 39165 | 57666 | 581 |
2391011 | 2391011 | 2022-04-09 | Warren | Ohio | 39165 | 57666 | 581 |
2387755 | 2387755 | 2022-04-08 | Warren | Ohio | 39165 | 57666 | 581 |
2384500 | 2384500 | 2022-04-07 | Warren | Ohio | 39165 | 57666 | 581 |
2381245 | 2381245 | 2022-04-06 | Warren | Ohio | 39165 | 57617 | 579 |
2377990 | 2377990 | 2022-04-05 | Warren | Ohio | 39165 | 57617 | 579 |
2374736 | 2374736 | 2022-04-04 | Warren | Ohio | 39165 | 57617 | 579 |
2371484 | 2371484 | 2022-04-03 | Warren | Ohio | 39165 | 57617 | 579 |
2368231 | 2368231 | 2022-04-02 | Warren | Ohio | 39165 | 57617 | 579 |
2364978 | 2364978 | 2022-04-01 | Warren | Ohio | 39165 | 57617 | 579 |
2361725 | 2361725 | 2022-03-31 | Warren | Ohio | 39165 | 57617 | 579 |
2358471 | 2358471 | 2022-03-30 | Warren | Ohio | 39165 | 57565 | 573 |
2355217 | 2355217 | 2022-03-29 | Warren | Ohio | 39165 | 57565 | 573 |
2351964 | 2351964 | 2022-03-28 | Warren | Ohio | 39165 | 57565 | 573 |
2348712 | 2348712 | 2022-03-27 | Warren | Ohio | 39165 | 57565 | 573 |
2345459 | 2345459 | 2022-03-26 | Warren | Ohio | 39165 | 57565 | 573 |
2342206 | 2342206 | 2022-03-25 | Warren | Ohio | 39165 | 57565 | 573 |
2338953 | 2338953 | 2022-03-24 | Warren | Ohio | 39165 | 57565 | 573 |
2335699 | 2335699 | 2022-03-23 | Warren | Ohio | 39165 | 57475 | 571 |
2332445 | 2332445 | 2022-03-22 | Warren | Ohio | 39165 | 57475 | 571 |
2329192 | 2329192 | 2022-03-21 | Warren | Ohio | 39165 | 57475 | 571 |
2325940 | 2325940 | 2022-03-20 | Warren | Ohio | 39165 | 57475 | 571 |
2322687 | 2322687 | 2022-03-19 | Warren | Ohio | 39165 | 57475 | 571 |
2319433 | 2319433 | 2022-03-18 | Warren | Ohio | 39165 | 57475 | 571 |
2316179 | 2316179 | 2022-03-17 | Warren | Ohio | 39165 | 57475 | 571 |
2312926 | 2312926 | 2022-03-16 | Warren | Ohio | 39165 | 57427 | 568 |
2309673 | 2309673 | 2022-03-15 | Warren | Ohio | 39165 | 57427 | 568 |
2306420 | 2306420 | 2022-03-14 | Warren | Ohio | 39165 | 57427 | 568 |
2303169 | 2303169 | 2022-03-13 | Warren | Ohio | 39165 | 57427 | 568 |
2299917 | 2299917 | 2022-03-12 | Warren | Ohio | 39165 | 57423 | 568 |
2296665 | 2296665 | 2022-03-11 | Warren | Ohio | 39165 | 57414 | 568 |
2293413 | 2293413 | 2022-03-10 | Warren | Ohio | 39165 | 57394 | 561 |
2290161 | 2290161 | 2022-03-09 | Warren | Ohio | 39165 | 57375 | 561 |
2286909 | 2286909 | 2022-03-08 | Warren | Ohio | 39165 | 57354 | 561 |
2283657 | 2283657 | 2022-03-07 | Warren | Ohio | 39165 | 57326 | 558 |
2280405 | 2280405 | 2022-03-06 | Warren | Ohio | 39165 | 57320 | 558 |
2277152 | 2277152 | 2022-03-05 | Warren | Ohio | 39165 | 57312 | 558 |
2273899 | 2273899 | 2022-03-04 | Warren | Ohio | 39165 | 57293 | 558 |
2270646 | 2270646 | 2022-03-03 | Warren | Ohio | 39165 | 57270 | 558 |
2267394 | 2267394 | 2022-03-02 | Warren | Ohio | 39165 | 57245 | 558 |
2264141 | 2264141 | 2022-03-01 | Warren | Ohio | 39165 | 57221 | 558 |
2260891 | 2260891 | 2022-02-28 | Warren | Ohio | 39165 | 57206 | 553 |
2257640 | 2257640 | 2022-02-27 | Warren | Ohio | 39165 | 57194 | 553 |
2254389 | 2254389 | 2022-02-26 | Warren | Ohio | 39165 | 57175 | 553 |
2251138 | 2251138 | 2022-02-25 | Warren | Ohio | 39165 | 57120 | 553 |
2247887 | 2247887 | 2022-02-24 | Warren | Ohio | 39165 | 57076 | 550 |
2244636 | 2244636 | 2022-02-23 | Warren | Ohio | 39165 | 57049 | 550 |
2241385 | 2241385 | 2022-02-22 | Warren | Ohio | 39165 | 57019 | 550 |
2238134 | 2238134 | 2022-02-21 | Warren | Ohio | 39165 | 56997 | 536 |
2234883 | 2234883 | 2022-02-20 | Warren | Ohio | 39165 | 56983 | 536 |
2231632 | 2231632 | 2022-02-19 | Warren | Ohio | 39165 | 56968 | 536 |
2228381 | 2228381 | 2022-02-18 | Warren | Ohio | 39165 | 56924 | 536 |
2225130 | 2225130 | 2022-02-17 | Warren | Ohio | 39165 | 56877 | 536 |
2221879 | 2221879 | 2022-02-16 | Warren | Ohio | 39165 | 56826 | 536 |
2218628 | 2218628 | 2022-02-15 | Warren | Ohio | 39165 | 56777 | 536 |
2215377 | 2215377 | 2022-02-14 | Warren | Ohio | 39165 | 56739 | 532 |
2212126 | 2212126 | 2022-02-13 | Warren | Ohio | 39165 | 56710 | 532 |
2208873 | 2208873 | 2022-02-12 | Warren | Ohio | 39165 | 56669 | 532 |
2205620 | 2205620 | 2022-02-11 | Warren | Ohio | 39165 | 56636 | 532 |
2202367 | 2202367 | 2022-02-10 | Warren | Ohio | 39165 | 56533 | 526 |
2199113 | 2199113 | 2022-02-09 | Warren | Ohio | 39165 | 56424 | 526 |
2195859 | 2195859 | 2022-02-08 | Warren | Ohio | 39165 | 56311 | 526 |
2192605 | 2192605 | 2022-02-07 | Warren | Ohio | 39165 | 56189 | 517 |
2189351 | 2189351 | 2022-02-06 | Warren | Ohio | 39165 | 56133 | 517 |
2186098 | 2186098 | 2022-02-05 | Warren | Ohio | 39165 | 56086 | 517 |
2182846 | 2182846 | 2022-02-04 | Warren | Ohio | 39165 | 56029 | 517 |
2179594 | 2179594 | 2022-02-03 | Warren | Ohio | 39165 | 55916 | 508 |
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);