ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 39021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501654 | 2501654 | 2022-05-13 | Champaign | Ohio | 39021 | 8819 | 147 |
2498396 | 2498396 | 2022-05-12 | Champaign | Ohio | 39021 | 8819 | 147 |
2495138 | 2495138 | 2022-05-11 | Champaign | Ohio | 39021 | 8789 | 147 |
2491880 | 2491880 | 2022-05-10 | Champaign | Ohio | 39021 | 8789 | 147 |
2488622 | 2488622 | 2022-05-09 | Champaign | Ohio | 39021 | 8789 | 147 |
2485365 | 2485365 | 2022-05-08 | Champaign | Ohio | 39021 | 8789 | 147 |
2482107 | 2482107 | 2022-05-07 | Champaign | Ohio | 39021 | 8789 | 147 |
2478849 | 2478849 | 2022-05-06 | Champaign | Ohio | 39021 | 8789 | 147 |
2475591 | 2475591 | 2022-05-05 | Champaign | Ohio | 39021 | 8789 | 147 |
2472334 | 2472334 | 2022-05-04 | Champaign | Ohio | 39021 | 8759 | 147 |
2469078 | 2469078 | 2022-05-03 | Champaign | Ohio | 39021 | 8759 | 147 |
2465822 | 2465822 | 2022-05-02 | Champaign | Ohio | 39021 | 8759 | 147 |
2462567 | 2462567 | 2022-05-01 | Champaign | Ohio | 39021 | 8759 | 147 |
2459311 | 2459311 | 2022-04-30 | Champaign | Ohio | 39021 | 8759 | 147 |
2456055 | 2456055 | 2022-04-29 | Champaign | Ohio | 39021 | 8759 | 147 |
2452799 | 2452799 | 2022-04-28 | Champaign | Ohio | 39021 | 8759 | 147 |
2449543 | 2449543 | 2022-04-27 | Champaign | Ohio | 39021 | 8738 | 147 |
2446286 | 2446286 | 2022-04-26 | Champaign | Ohio | 39021 | 8738 | 147 |
2443031 | 2443031 | 2022-04-25 | Champaign | Ohio | 39021 | 8738 | 147 |
2439775 | 2439775 | 2022-04-24 | Champaign | Ohio | 39021 | 8738 | 147 |
2436519 | 2436519 | 2022-04-23 | Champaign | Ohio | 39021 | 8738 | 147 |
2433263 | 2433263 | 2022-04-22 | Champaign | Ohio | 39021 | 8738 | 147 |
2430007 | 2430007 | 2022-04-21 | Champaign | Ohio | 39021 | 8738 | 147 |
2426751 | 2426751 | 2022-04-20 | Champaign | Ohio | 39021 | 8728 | 145 |
2423495 | 2423495 | 2022-04-19 | Champaign | Ohio | 39021 | 8728 | 145 |
2420238 | 2420238 | 2022-04-18 | Champaign | Ohio | 39021 | 8728 | 145 |
2416983 | 2416983 | 2022-04-17 | Champaign | Ohio | 39021 | 8728 | 145 |
2413727 | 2413727 | 2022-04-16 | Champaign | Ohio | 39021 | 8728 | 145 |
2410471 | 2410471 | 2022-04-15 | Champaign | Ohio | 39021 | 8728 | 145 |
2407215 | 2407215 | 2022-04-14 | Champaign | Ohio | 39021 | 8728 | 145 |
2403959 | 2403959 | 2022-04-13 | Champaign | Ohio | 39021 | 8715 | 145 |
2400704 | 2400704 | 2022-04-12 | Champaign | Ohio | 39021 | 8715 | 145 |
2397449 | 2397449 | 2022-04-11 | Champaign | Ohio | 39021 | 8715 | 145 |
2394194 | 2394194 | 2022-04-10 | Champaign | Ohio | 39021 | 8715 | 145 |
2390938 | 2390938 | 2022-04-09 | Champaign | Ohio | 39021 | 8715 | 145 |
2387682 | 2387682 | 2022-04-08 | Champaign | Ohio | 39021 | 8715 | 145 |
2384427 | 2384427 | 2022-04-07 | Champaign | Ohio | 39021 | 8715 | 145 |
2381172 | 2381172 | 2022-04-06 | Champaign | Ohio | 39021 | 8709 | 145 |
2377917 | 2377917 | 2022-04-05 | Champaign | Ohio | 39021 | 8709 | 145 |
2374663 | 2374663 | 2022-04-04 | Champaign | Ohio | 39021 | 8709 | 145 |
2371411 | 2371411 | 2022-04-03 | Champaign | Ohio | 39021 | 8709 | 145 |
2368158 | 2368158 | 2022-04-02 | Champaign | Ohio | 39021 | 8709 | 145 |
2364905 | 2364905 | 2022-04-01 | Champaign | Ohio | 39021 | 8709 | 145 |
2361652 | 2361652 | 2022-03-31 | Champaign | Ohio | 39021 | 8709 | 145 |
2358398 | 2358398 | 2022-03-30 | Champaign | Ohio | 39021 | 8701 | 146 |
2355144 | 2355144 | 2022-03-29 | Champaign | Ohio | 39021 | 8701 | 146 |
2351891 | 2351891 | 2022-03-28 | Champaign | Ohio | 39021 | 8701 | 146 |
2348639 | 2348639 | 2022-03-27 | Champaign | Ohio | 39021 | 8701 | 146 |
2345386 | 2345386 | 2022-03-26 | Champaign | Ohio | 39021 | 8701 | 146 |
2342133 | 2342133 | 2022-03-25 | Champaign | Ohio | 39021 | 8701 | 146 |
2338880 | 2338880 | 2022-03-24 | Champaign | Ohio | 39021 | 8701 | 146 |
2335626 | 2335626 | 2022-03-23 | Champaign | Ohio | 39021 | 8696 | 145 |
2332372 | 2332372 | 2022-03-22 | Champaign | Ohio | 39021 | 8696 | 145 |
2329119 | 2329119 | 2022-03-21 | Champaign | Ohio | 39021 | 8696 | 145 |
2325867 | 2325867 | 2022-03-20 | Champaign | Ohio | 39021 | 8696 | 145 |
2322614 | 2322614 | 2022-03-19 | Champaign | Ohio | 39021 | 8696 | 145 |
2319360 | 2319360 | 2022-03-18 | Champaign | Ohio | 39021 | 8696 | 145 |
2316106 | 2316106 | 2022-03-17 | Champaign | Ohio | 39021 | 8696 | 145 |
2312853 | 2312853 | 2022-03-16 | Champaign | Ohio | 39021 | 8692 | 144 |
2309600 | 2309600 | 2022-03-15 | Champaign | Ohio | 39021 | 8692 | 144 |
2306347 | 2306347 | 2022-03-14 | Champaign | Ohio | 39021 | 8692 | 144 |
2303096 | 2303096 | 2022-03-13 | Champaign | Ohio | 39021 | 8692 | 144 |
2299844 | 2299844 | 2022-03-12 | Champaign | Ohio | 39021 | 8692 | 144 |
2296592 | 2296592 | 2022-03-11 | Champaign | Ohio | 39021 | 8692 | 144 |
2293340 | 2293340 | 2022-03-10 | Champaign | Ohio | 39021 | 8691 | 144 |
2290088 | 2290088 | 2022-03-09 | Champaign | Ohio | 39021 | 8688 | 144 |
2286836 | 2286836 | 2022-03-08 | Champaign | Ohio | 39021 | 8687 | 144 |
2283584 | 2283584 | 2022-03-07 | Champaign | Ohio | 39021 | 8683 | 142 |
2280332 | 2280332 | 2022-03-06 | Champaign | Ohio | 39021 | 8684 | 142 |
2277079 | 2277079 | 2022-03-05 | Champaign | Ohio | 39021 | 8682 | 142 |
2273826 | 2273826 | 2022-03-04 | Champaign | Ohio | 39021 | 8677 | 142 |
2270573 | 2270573 | 2022-03-03 | Champaign | Ohio | 39021 | 8675 | 142 |
2267321 | 2267321 | 2022-03-02 | Champaign | Ohio | 39021 | 8668 | 142 |
2264068 | 2264068 | 2022-03-01 | Champaign | Ohio | 39021 | 8664 | 142 |
2260818 | 2260818 | 2022-02-28 | Champaign | Ohio | 39021 | 8658 | 140 |
2257567 | 2257567 | 2022-02-27 | Champaign | Ohio | 39021 | 8656 | 140 |
2254316 | 2254316 | 2022-02-26 | Champaign | Ohio | 39021 | 8653 | 140 |
2251065 | 2251065 | 2022-02-25 | Champaign | Ohio | 39021 | 8652 | 140 |
2247814 | 2247814 | 2022-02-24 | Champaign | Ohio | 39021 | 8648 | 139 |
2244563 | 2244563 | 2022-02-23 | Champaign | Ohio | 39021 | 8642 | 139 |
2241312 | 2241312 | 2022-02-22 | Champaign | Ohio | 39021 | 8640 | 139 |
2238061 | 2238061 | 2022-02-21 | Champaign | Ohio | 39021 | 8638 | 133 |
2234810 | 2234810 | 2022-02-20 | Champaign | Ohio | 39021 | 8635 | 133 |
2231559 | 2231559 | 2022-02-19 | Champaign | Ohio | 39021 | 8629 | 133 |
2228308 | 2228308 | 2022-02-18 | Champaign | Ohio | 39021 | 8624 | 133 |
2225057 | 2225057 | 2022-02-17 | Champaign | Ohio | 39021 | 8615 | 132 |
2221806 | 2221806 | 2022-02-16 | Champaign | Ohio | 39021 | 8610 | 132 |
2218555 | 2218555 | 2022-02-15 | Champaign | Ohio | 39021 | 8609 | 132 |
2215304 | 2215304 | 2022-02-14 | Champaign | Ohio | 39021 | 8603 | 130 |
2212053 | 2212053 | 2022-02-13 | Champaign | Ohio | 39021 | 8597 | 130 |
2208800 | 2208800 | 2022-02-12 | Champaign | Ohio | 39021 | 8590 | 130 |
2205547 | 2205547 | 2022-02-11 | Champaign | Ohio | 39021 | 8580 | 130 |
2202294 | 2202294 | 2022-02-10 | Champaign | Ohio | 39021 | 8564 | 126 |
2199040 | 2199040 | 2022-02-09 | Champaign | Ohio | 39021 | 8550 | 126 |
2195786 | 2195786 | 2022-02-08 | Champaign | Ohio | 39021 | 8527 | 126 |
2192532 | 2192532 | 2022-02-07 | Champaign | Ohio | 39021 | 8511 | 124 |
2189278 | 2189278 | 2022-02-06 | Champaign | Ohio | 39021 | 8504 | 124 |
2186025 | 2186025 | 2022-02-05 | Champaign | Ohio | 39021 | 8494 | 124 |
2182773 | 2182773 | 2022-02-04 | Champaign | Ohio | 39021 | 8485 | 124 |
2179521 | 2179521 | 2022-02-03 | Champaign | Ohio | 39021 | 8459 | 122 |
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);