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

782 rows where county = "Madison" and fips = 39097 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

  • 39097 · 782 ✖

county 1

  • Madison · 782 ✖
Link rowid date ▲ county state cases deaths
2501692 2501692 2022-05-13 Madison Ohio 9754 136
2498434 2498434 2022-05-12 Madison Ohio 9754 136
2495176 2495176 2022-05-11 Madison Ohio 9728 134
2491918 2491918 2022-05-10 Madison Ohio 9728 134
2488660 2488660 2022-05-09 Madison Ohio 9728 134
2485403 2485403 2022-05-08 Madison Ohio 9728 134
2482145 2482145 2022-05-07 Madison Ohio 9728 134
2478887 2478887 2022-05-06 Madison Ohio 9728 134
2475629 2475629 2022-05-05 Madison Ohio 9728 134
2472372 2472372 2022-05-04 Madison Ohio 9708 133
2469116 2469116 2022-05-03 Madison Ohio 9708 133
2465860 2465860 2022-05-02 Madison Ohio 9708 133
2462605 2462605 2022-05-01 Madison Ohio 9708 133
2459349 2459349 2022-04-30 Madison Ohio 9708 133
2456093 2456093 2022-04-29 Madison Ohio 9708 133
2452837 2452837 2022-04-28 Madison Ohio 9708 133
2449581 2449581 2022-04-27 Madison Ohio 9691 132
2446324 2446324 2022-04-26 Madison Ohio 9691 132
2443069 2443069 2022-04-25 Madison Ohio 9691 132
2439813 2439813 2022-04-24 Madison Ohio 9691 132
2436557 2436557 2022-04-23 Madison Ohio 9691 132
2433301 2433301 2022-04-22 Madison Ohio 9691 132
2430045 2430045 2022-04-21 Madison Ohio 9691 132
2426789 2426789 2022-04-20 Madison Ohio 9670 131
2423533 2423533 2022-04-19 Madison Ohio 9670 131
2420276 2420276 2022-04-18 Madison Ohio 9670 131
2417021 2417021 2022-04-17 Madison Ohio 9670 131
2413765 2413765 2022-04-16 Madison Ohio 9670 131
2410509 2410509 2022-04-15 Madison Ohio 9670 131
2407253 2407253 2022-04-14 Madison Ohio 9670 131
2403997 2403997 2022-04-13 Madison Ohio 9660 130
2400742 2400742 2022-04-12 Madison Ohio 9660 130
2397487 2397487 2022-04-11 Madison Ohio 9660 130
2394232 2394232 2022-04-10 Madison Ohio 9660 130
2390976 2390976 2022-04-09 Madison Ohio 9660 130
2387720 2387720 2022-04-08 Madison Ohio 9660 130
2384465 2384465 2022-04-07 Madison Ohio 9660 130
2381210 2381210 2022-04-06 Madison Ohio 9649 128
2377955 2377955 2022-04-05 Madison Ohio 9649 128
2374701 2374701 2022-04-04 Madison Ohio 9649 128
2371449 2371449 2022-04-03 Madison Ohio 9649 128
2368196 2368196 2022-04-02 Madison Ohio 9649 128
2364943 2364943 2022-04-01 Madison Ohio 9649 128
2361690 2361690 2022-03-31 Madison Ohio 9649 128
2358436 2358436 2022-03-30 Madison Ohio 9641 128
2355182 2355182 2022-03-29 Madison Ohio 9641 128
2351929 2351929 2022-03-28 Madison Ohio 9641 128
2348677 2348677 2022-03-27 Madison Ohio 9641 128
2345424 2345424 2022-03-26 Madison Ohio 9641 128
2342171 2342171 2022-03-25 Madison Ohio 9641 128
2338918 2338918 2022-03-24 Madison Ohio 9641 128
2335664 2335664 2022-03-23 Madison Ohio 9639 126
2332410 2332410 2022-03-22 Madison Ohio 9639 126
2329157 2329157 2022-03-21 Madison Ohio 9639 126
2325905 2325905 2022-03-20 Madison Ohio 9639 126
2322652 2322652 2022-03-19 Madison Ohio 9639 126
2319398 2319398 2022-03-18 Madison Ohio 9639 126
2316144 2316144 2022-03-17 Madison Ohio 9639 126
2312891 2312891 2022-03-16 Madison Ohio 9631 126
2309638 2309638 2022-03-15 Madison Ohio 9631 126
2306385 2306385 2022-03-14 Madison Ohio 9631 126
2303134 2303134 2022-03-13 Madison Ohio 9631 126
2299882 2299882 2022-03-12 Madison Ohio 9631 126
2296630 2296630 2022-03-11 Madison Ohio 9629 126
2293378 2293378 2022-03-10 Madison Ohio 9625 126
2290126 2290126 2022-03-09 Madison Ohio 9624 126
2286874 2286874 2022-03-08 Madison Ohio 9622 126
2283622 2283622 2022-03-07 Madison Ohio 9622 126
2280370 2280370 2022-03-06 Madison Ohio 9620 126
2277117 2277117 2022-03-05 Madison Ohio 9619 126
2273864 2273864 2022-03-04 Madison Ohio 9615 126
2270611 2270611 2022-03-03 Madison Ohio 9614 125
2267359 2267359 2022-03-02 Madison Ohio 9614 125
2264106 2264106 2022-03-01 Madison Ohio 9611 125
2260856 2260856 2022-02-28 Madison Ohio 9607 125
2257605 2257605 2022-02-27 Madison Ohio 9606 125
2254354 2254354 2022-02-26 Madison Ohio 9606 125
2251103 2251103 2022-02-25 Madison Ohio 9604 125
2247852 2247852 2022-02-24 Madison Ohio 9595 124
2244601 2244601 2022-02-23 Madison Ohio 9593 124
2241350 2241350 2022-02-22 Madison Ohio 9589 124
2238099 2238099 2022-02-21 Madison Ohio 9585 121
2234848 2234848 2022-02-20 Madison Ohio 9580 121
2231597 2231597 2022-02-19 Madison Ohio 9578 121
2228346 2228346 2022-02-18 Madison Ohio 9571 121
2225095 2225095 2022-02-17 Madison Ohio 9561 121
2221844 2221844 2022-02-16 Madison Ohio 9554 121
2218593 2218593 2022-02-15 Madison Ohio 9545 121
2215342 2215342 2022-02-14 Madison Ohio 9533 121
2212091 2212091 2022-02-13 Madison Ohio 9527 121
2208838 2208838 2022-02-12 Madison Ohio 9524 121
2205585 2205585 2022-02-11 Madison Ohio 9517 121
2202332 2202332 2022-02-10 Madison Ohio 9498 121
2199078 2199078 2022-02-09 Madison Ohio 9481 121
2195824 2195824 2022-02-08 Madison Ohio 9468 121
2192570 2192570 2022-02-07 Madison Ohio 9446 121
2189316 2189316 2022-02-06 Madison Ohio 9440 121
2186063 2186063 2022-02-05 Madison Ohio 9435 121
2182811 2182811 2022-02-04 Madison Ohio 9418 121
2179559 2179559 2022-02-03 Madison Ohio 9402 116

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