ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

781 rows where fips = 39021 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

fips 1

  • 39021 · 781 ✖

county 1

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);