ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Gallia" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 553 ✖
- 6 32
- 9 21
- 7 13
- 1 11
- 4 9
- 8 8
- 7462 7
- 7472 7
- 7475 7
- 7481 7
- 7488 7
- 7499 7
- 7513 7
- 7534 7
- 2413 6
- 2333 5
- 14 4
- 20 4
- 2407 4
- 2408 4
- 7449 4
- 10 3
- 21 3
- 24 3
- 49 3
- 58 3
- 62 3
- 65 3
- 179 3
- 2264 3
- 2334 3
- 2388 3
- 2404 3
- 18 2
- 29 2
- 89 2
- 130 2
- 140 2
- 152 2
- 153 2
- 189 2
- 191 2
- 220 2
- 248 2
- 274 2
- 334 2
- 765 2
- 1552 2
- 1668 2
- 2185 2
- 2213 2
- 2239 2
- 2253 2
- 2254 2
- 2307 2
- 2319 2
- 2321 2
- 2338 2
- 2339 2
- 2350 2
- 2351 2
- 2353 2
- 2363 2
- 2367 2
- 2381 2
- 2389 2
- 2396 2
- 2397 2
- 2403 2
- 2405 2
- 2409 2
- 2412 2
- 2416 2
- 2419 2
- 4575 2
- 5064 2
- 5155 2
- 7408 2
- 7565 2
- 3 1
- 5 1
- 11 1
- 16 1
- 17 1
- 30 1
- 33 1
- 37 1
- 39 1
- 40 1
- 41 1
- 43 1
- 44 1
- 46 1
- 57 1
- 70 1
- 74 1
- 78 1
- 85 1
- 88 1
- 90 1
- 92 1
- 100 1
- 101 1
- 106 1
- 114 1
- 121 1
- 129 1
- 134 1
- 144 1
- 147 1
- 150 1
- 156 1
- 158 1
- 160 1
- 163 1
- 167 1
- 168 1
- 169 1
- 170 1
- 174 1
- 176 1
- 180 1
- 184 1
- 186 1
- 188 1
- 196 1
- 197 1
- 208 1
- 212 1
- 213 1
- 218 1
- 226 1
- 232 1
- 235 1
- 240 1
- 244 1
- 247 1
- 252 1
- 266 1
- 269 1
- 272 1
- 279 1
- 282 1
- 291 1
- 292 1
- 300 1
- 304 1
- 306 1
- 310 1
- 316 1
- 321 1
- 329 1
- 340 1
- 350 1
- 361 1
- 373 1
- 379 1
- 394 1
- 404 1
- 411 1
- 443 1
- 459 1
- 471 1
- 490 1
- 513 1
- 519 1
- 529 1
- 562 1
- 575 1
- 578 1
- 601 1
- 671 1
- 681 1
- 704 1
- 735 1
- 816 1
- 822 1
- 847 1
- 862 1
- 880 1
- 924 1
- 956 1
- 978 1
- 1034 1
- 1046 1
- 1062 1
- 1118 1
- 1166 1
- 1195 1
- 1230 1
- 1269 1
- 1284 1
- 1294 1
- 1343 1
- 1363 1
- 1405 1
- 1416 1
- 1441 1
- 1455 1
- 1467 1
- 1494 1
- 1522 1
- 1570 1
- 1573 1
- 1585 1
- 1613 1
- 1639 1
- 1702 1
- 1713 1
- 1723 1
- 1747 1
- 1781 1
- 1799 1
- 1808 1
- 1815 1
- 1823 1
- 1825 1
- 1843 1
- 1856 1
- 1862 1
- 1874 1
- 1891 1
- 1909 1
- 1916 1
- 1921 1
- 1934 1
- 1947 1
- 1954 1
- 1967 1
- 1988 1
- 1998 1
- 2001 1
- 2019 1
- 2029 1
- 2036 1
- 2043 1
- 2045 1
- 2051 1
- 2064 1
- 2069 1
- 2082 1
- 2093 1
- 2100 1
- 2104 1
- 2108 1
- 2111 1
- 2127 1
- 2135 1
- 2137 1
- 2145 1
- 2149 1
- 2152 1
- 2158 1
- 2163 1
- 2166 1
- 2172 1
- 2191 1
- 2194 1
- 2198 1
- 2202 1
- 2207 1
- 2218 1
- 2225 1
- 2226 1
- 2231 1
- 2235 1
- 2242 1
- 2245 1
- 2247 1
- 2250 1
- 2256 1
- 2258 1
- 2262 1
- 2265 1
- 2268 1
- 2272 1
- 2275 1
- 2277 1
- 2285 1
- 2287 1
- 2291 1
- 2294 1
- 2297 1
- 2301 1
- 2304 1
- 2312 1
- 2313 1
- 2314 1
- 2323 1
- 2324 1
- 2329 1
- 2332 1
- 2337 1
- 2341 1
- 2344 1
- 2345 1
- 2348 1
- 2356 1
- 2358 1
- 2359 1
- 2364 1
- 2365 1
- 2370 1
- 2374 1
- 2377 1
- 2378 1
- 2380 1
- 2382 1
- 2384 1
- 2390 1
- 2391 1
- 2393 1
- 2401 1
- 2406 1
- 2411 1
- 2414 1
- 2415 1
- 2417 1
- 2418 1
- 2427 1
- 2433 1
- 2446 1
- 2452 1
- 2454 1
- 2458 1
- 2468 1
- 2472 1
- 2479 1
- 2484 1
- 2486 1
- 2489 1
- 2492 1
- 2498 1
- 2511 1
- 2514 1
- 2517 1
- 2521 1
- 2524 1
- 2527 1
- 2541 1
- 2561 1
- 2566 1
- 2572 1
- 2574 1
- 2579 1
- 2580 1
- 2589 1
- 2596 1
- 2605 1
- 2612 1
- 2620 1
- 2626 1
- 2635 1
- 2655 1
- 2672 1
- 2688 1
- 2702 1
- 2733 1
- 2743 1
- 2750 1
- 2781 1
- 2804 1
- 2821 1
- 2855 1
- 2883 1
- 2892 1
- 2902 1
- 2921 1
- 2961 1
- 2982 1
- 3001 1
- 3017 1
- 3033 1
- 3051 1
- 3060 1
- 3094 1
- 3126 1
- 3145 1
- 3184 1
- 3199 1
- 3211 1
- 3254 1
- 3292 1
- 3335 1
- 3360 1
- 3380 1
- 3404 1
- 3415 1
- 3447 1
- 3473 1
- 3498 1
- 3528 1
- 3554 1
- 3566 1
- 3578 1
- 3616 1
- 3653 1
- 3698 1
- 3734 1
- 3764 1
- 3781 1
- 3794 1
- 3831 1
- 3868 1
- 3913 1
- 3945 1
- 3961 1
- 3974 1
- 3978 1
- 3985 1
- 4024 1
- 4052 1
- 4081 1
- 4098 1
- 4104 1
- 4112 1
- 4128 1
- 4143 1
- 4162 1
- 4172 1
- 4184 1
- 4187 1
- 4193 1
- 4207 1
- 4230 1
- 4249 1
- 4259 1
- 4271 1
- 4274 1
- 4276 1
- 4294 1
- 4305 1
- 4323 1
- 4336 1
- 4341 1
- 4349 1
- 4359 1
- 4370 1
- 4384 1
- 4401 1
- 4413 1
- 4430 1
- 4434 1
- 4439 1
- 4465 1
- 4486 1
- 4504 1
- 4517 1
- 4530 1
- 4533 1
- 4539 1
- 4556 1
- 4596 1
- 4602 1
- 4611 1
- 4629 1
- 4654 1
- 4676 1
- 4696 1
- 4714 1
- 4734 1
- 4742 1
- 4758 1
- 4769 1
- 4802 1
- 4812 1
- 4833 1
- 4853 1
- 4863 1
- 4875 1
- 4898 1
- 4917 1
- 4950 1
- 4963 1
- 4980 1
- 4987 1
- 4990 1
- 5008 1
- 5036 1
- 5058 1
- 5079 1
- 5082 1
- 5105 1
- 5115 1
- 5134 1
- 5185 1
- 5204 1
- 5243 1
- 5305 1
- 5346 1
- 5371 1
- 5414 1
- 5417 1
- 5462 1
- 5514 1
- 5569 1
- 5612 1
- 5694 1
- 5834 1
- 5910 1
- 5949 1
- 5981 1
- 6058 1
- 6147 1
- 6269 1
- 6343 1
- 6358 1
- 6388 1
- 6430 1
- 6543 1
- 6605 1
- 6668 1
- 6723 1
- 6738 1
- 6762 1
- 6807 1
- 6865 1
- 6917 1
- 6940 1
- 6944 1
- 6954 1
- 6972 1
- 7022 1
- 7077 1
- 7113 1
- 7138 1
- 7159 1
- 7164 1
- 7170 1
- 7185 1
- 7229 1
- 7243 1
- 7264 1
- 7275 1
- 7285 1
- 7288 1
- 7299 1
- 7317 1
- 7332 1
- 7346 1
- 7355 1
- 7357 1
- 7359 1
- 7369 1
- 7382 1
- 7388 1
- 7401 1
- 7412 1
- 7419 1
- 7430 1
- 7439 1
- 7443 1
- 7446 1
state 1
- Ohio · 783 ✖
fips 1
- 39053 783
county 1
- Gallia · 783 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501670 | 2501670 | 2022-05-13 | Gallia | Ohio | 39053 | 7565 | 127 |
2498412 | 2498412 | 2022-05-12 | Gallia | Ohio | 39053 | 7565 | 127 |
2495154 | 2495154 | 2022-05-11 | Gallia | Ohio | 39053 | 7534 | 126 |
2491896 | 2491896 | 2022-05-10 | Gallia | Ohio | 39053 | 7534 | 126 |
2488638 | 2488638 | 2022-05-09 | Gallia | Ohio | 39053 | 7534 | 126 |
2485381 | 2485381 | 2022-05-08 | Gallia | Ohio | 39053 | 7534 | 126 |
2482123 | 2482123 | 2022-05-07 | Gallia | Ohio | 39053 | 7534 | 126 |
2478865 | 2478865 | 2022-05-06 | Gallia | Ohio | 39053 | 7534 | 126 |
2475607 | 2475607 | 2022-05-05 | Gallia | Ohio | 39053 | 7534 | 126 |
2472350 | 2472350 | 2022-05-04 | Gallia | Ohio | 39053 | 7513 | 126 |
2469094 | 2469094 | 2022-05-03 | Gallia | Ohio | 39053 | 7513 | 126 |
2465838 | 2465838 | 2022-05-02 | Gallia | Ohio | 39053 | 7513 | 126 |
2462583 | 2462583 | 2022-05-01 | Gallia | Ohio | 39053 | 7513 | 126 |
2459327 | 2459327 | 2022-04-30 | Gallia | Ohio | 39053 | 7513 | 126 |
2456071 | 2456071 | 2022-04-29 | Gallia | Ohio | 39053 | 7513 | 126 |
2452815 | 2452815 | 2022-04-28 | Gallia | Ohio | 39053 | 7513 | 126 |
2449559 | 2449559 | 2022-04-27 | Gallia | Ohio | 39053 | 7499 | 126 |
2446302 | 2446302 | 2022-04-26 | Gallia | Ohio | 39053 | 7499 | 126 |
2443047 | 2443047 | 2022-04-25 | Gallia | Ohio | 39053 | 7499 | 126 |
2439791 | 2439791 | 2022-04-24 | Gallia | Ohio | 39053 | 7499 | 126 |
2436535 | 2436535 | 2022-04-23 | Gallia | Ohio | 39053 | 7499 | 126 |
2433279 | 2433279 | 2022-04-22 | Gallia | Ohio | 39053 | 7499 | 126 |
2430023 | 2430023 | 2022-04-21 | Gallia | Ohio | 39053 | 7499 | 126 |
2426767 | 2426767 | 2022-04-20 | Gallia | Ohio | 39053 | 7488 | 125 |
2423511 | 2423511 | 2022-04-19 | Gallia | Ohio | 39053 | 7488 | 125 |
2420254 | 2420254 | 2022-04-18 | Gallia | Ohio | 39053 | 7488 | 125 |
2416999 | 2416999 | 2022-04-17 | Gallia | Ohio | 39053 | 7488 | 125 |
2413743 | 2413743 | 2022-04-16 | Gallia | Ohio | 39053 | 7488 | 125 |
2410487 | 2410487 | 2022-04-15 | Gallia | Ohio | 39053 | 7488 | 125 |
2407231 | 2407231 | 2022-04-14 | Gallia | Ohio | 39053 | 7488 | 125 |
2403975 | 2403975 | 2022-04-13 | Gallia | Ohio | 39053 | 7481 | 124 |
2400720 | 2400720 | 2022-04-12 | Gallia | Ohio | 39053 | 7481 | 124 |
2397465 | 2397465 | 2022-04-11 | Gallia | Ohio | 39053 | 7481 | 124 |
2394210 | 2394210 | 2022-04-10 | Gallia | Ohio | 39053 | 7481 | 124 |
2390954 | 2390954 | 2022-04-09 | Gallia | Ohio | 39053 | 7481 | 124 |
2387698 | 2387698 | 2022-04-08 | Gallia | Ohio | 39053 | 7481 | 124 |
2384443 | 2384443 | 2022-04-07 | Gallia | Ohio | 39053 | 7481 | 124 |
2381188 | 2381188 | 2022-04-06 | Gallia | Ohio | 39053 | 7475 | 124 |
2377933 | 2377933 | 2022-04-05 | Gallia | Ohio | 39053 | 7475 | 124 |
2374679 | 2374679 | 2022-04-04 | Gallia | Ohio | 39053 | 7475 | 124 |
2371427 | 2371427 | 2022-04-03 | Gallia | Ohio | 39053 | 7475 | 124 |
2368174 | 2368174 | 2022-04-02 | Gallia | Ohio | 39053 | 7475 | 124 |
2364921 | 2364921 | 2022-04-01 | Gallia | Ohio | 39053 | 7475 | 124 |
2361668 | 2361668 | 2022-03-31 | Gallia | Ohio | 39053 | 7475 | 124 |
2358414 | 2358414 | 2022-03-30 | Gallia | Ohio | 39053 | 7472 | 122 |
2355160 | 2355160 | 2022-03-29 | Gallia | Ohio | 39053 | 7472 | 122 |
2351907 | 2351907 | 2022-03-28 | Gallia | Ohio | 39053 | 7472 | 122 |
2348655 | 2348655 | 2022-03-27 | Gallia | Ohio | 39053 | 7472 | 122 |
2345402 | 2345402 | 2022-03-26 | Gallia | Ohio | 39053 | 7472 | 122 |
2342149 | 2342149 | 2022-03-25 | Gallia | Ohio | 39053 | 7472 | 122 |
2338896 | 2338896 | 2022-03-24 | Gallia | Ohio | 39053 | 7472 | 122 |
2335642 | 2335642 | 2022-03-23 | Gallia | Ohio | 39053 | 7462 | 121 |
2332388 | 2332388 | 2022-03-22 | Gallia | Ohio | 39053 | 7462 | 121 |
2329135 | 2329135 | 2022-03-21 | Gallia | Ohio | 39053 | 7462 | 121 |
2325883 | 2325883 | 2022-03-20 | Gallia | Ohio | 39053 | 7462 | 121 |
2322630 | 2322630 | 2022-03-19 | Gallia | Ohio | 39053 | 7462 | 121 |
2319376 | 2319376 | 2022-03-18 | Gallia | Ohio | 39053 | 7462 | 121 |
2316122 | 2316122 | 2022-03-17 | Gallia | Ohio | 39053 | 7462 | 121 |
2312869 | 2312869 | 2022-03-16 | Gallia | Ohio | 39053 | 7449 | 121 |
2309616 | 2309616 | 2022-03-15 | Gallia | Ohio | 39053 | 7449 | 121 |
2306363 | 2306363 | 2022-03-14 | Gallia | Ohio | 39053 | 7449 | 121 |
2303112 | 2303112 | 2022-03-13 | Gallia | Ohio | 39053 | 7449 | 121 |
2299860 | 2299860 | 2022-03-12 | Gallia | Ohio | 39053 | 7446 | 121 |
2296608 | 2296608 | 2022-03-11 | Gallia | Ohio | 39053 | 7443 | 121 |
2293356 | 2293356 | 2022-03-10 | Gallia | Ohio | 39053 | 7439 | 118 |
2290104 | 2290104 | 2022-03-09 | Gallia | Ohio | 39053 | 7430 | 118 |
2286852 | 2286852 | 2022-03-08 | Gallia | Ohio | 39053 | 7419 | 118 |
2283600 | 2283600 | 2022-03-07 | Gallia | Ohio | 39053 | 7412 | 116 |
2280348 | 2280348 | 2022-03-06 | Gallia | Ohio | 39053 | 7408 | 116 |
2277095 | 2277095 | 2022-03-05 | Gallia | Ohio | 39053 | 7408 | 116 |
2273842 | 2273842 | 2022-03-04 | Gallia | Ohio | 39053 | 7401 | 116 |
2270589 | 2270589 | 2022-03-03 | Gallia | Ohio | 39053 | 7388 | 116 |
2267337 | 2267337 | 2022-03-02 | Gallia | Ohio | 39053 | 7382 | 116 |
2264084 | 2264084 | 2022-03-01 | Gallia | Ohio | 39053 | 7369 | 116 |
2260834 | 2260834 | 2022-02-28 | Gallia | Ohio | 39053 | 7359 | 115 |
2257583 | 2257583 | 2022-02-27 | Gallia | Ohio | 39053 | 7357 | 115 |
2254332 | 2254332 | 2022-02-26 | Gallia | Ohio | 39053 | 7355 | 115 |
2251081 | 2251081 | 2022-02-25 | Gallia | Ohio | 39053 | 7346 | 115 |
2247830 | 2247830 | 2022-02-24 | Gallia | Ohio | 39053 | 7332 | 114 |
2244579 | 2244579 | 2022-02-23 | Gallia | Ohio | 39053 | 7317 | 114 |
2241328 | 2241328 | 2022-02-22 | Gallia | Ohio | 39053 | 7299 | 114 |
2238077 | 2238077 | 2022-02-21 | Gallia | Ohio | 39053 | 7288 | 109 |
2234826 | 2234826 | 2022-02-20 | Gallia | Ohio | 39053 | 7285 | 109 |
2231575 | 2231575 | 2022-02-19 | Gallia | Ohio | 39053 | 7275 | 109 |
2228324 | 2228324 | 2022-02-18 | Gallia | Ohio | 39053 | 7264 | 109 |
2225073 | 2225073 | 2022-02-17 | Gallia | Ohio | 39053 | 7243 | 106 |
2221822 | 2221822 | 2022-02-16 | Gallia | Ohio | 39053 | 7229 | 106 |
2218571 | 2218571 | 2022-02-15 | Gallia | Ohio | 39053 | 7185 | 106 |
2215320 | 2215320 | 2022-02-14 | Gallia | Ohio | 39053 | 7170 | 105 |
2212069 | 2212069 | 2022-02-13 | Gallia | Ohio | 39053 | 7164 | 105 |
2208816 | 2208816 | 2022-02-12 | Gallia | Ohio | 39053 | 7159 | 105 |
2205563 | 2205563 | 2022-02-11 | Gallia | Ohio | 39053 | 7138 | 105 |
2202310 | 2202310 | 2022-02-10 | Gallia | Ohio | 39053 | 7113 | 105 |
2199056 | 2199056 | 2022-02-09 | Gallia | Ohio | 39053 | 7077 | 105 |
2195802 | 2195802 | 2022-02-08 | Gallia | Ohio | 39053 | 7022 | 105 |
2192548 | 2192548 | 2022-02-07 | Gallia | Ohio | 39053 | 6972 | 102 |
2189294 | 2189294 | 2022-02-06 | Gallia | Ohio | 39053 | 6954 | 102 |
2186041 | 2186041 | 2022-02-05 | Gallia | Ohio | 39053 | 6944 | 102 |
2182789 | 2182789 | 2022-02-04 | Gallia | Ohio | 39053 | 6940 | 102 |
2179537 | 2179537 | 2022-02-03 | Gallia | Ohio | 39053 | 6917 | 95 |
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);