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: cases, deaths, date (date)
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);