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

785 rows where county = "Union" and fips = 39159 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

  • 39159 · 785 ✖

county 1

  • Union · 785 ✖
Link rowid date ▲ county state fips cases deaths
2501723 2501723 2022-05-13 Union Ohio 39159 15952 102
2498465 2498465 2022-05-12 Union Ohio 39159 15952 102
2495207 2495207 2022-05-11 Union Ohio 39159 15823 102
2491949 2491949 2022-05-10 Union Ohio 39159 15823 102
2488691 2488691 2022-05-09 Union Ohio 39159 15823 102
2485434 2485434 2022-05-08 Union Ohio 39159 15823 102
2482176 2482176 2022-05-07 Union Ohio 39159 15823 102
2478918 2478918 2022-05-06 Union Ohio 39159 15823 102
2475660 2475660 2022-05-05 Union Ohio 39159 15823 102
2472403 2472403 2022-05-04 Union Ohio 39159 15737 102
2469147 2469147 2022-05-03 Union Ohio 39159 15737 102
2465891 2465891 2022-05-02 Union Ohio 39159 15737 102
2462636 2462636 2022-05-01 Union Ohio 39159 15737 102
2459380 2459380 2022-04-30 Union Ohio 39159 15737 102
2456124 2456124 2022-04-29 Union Ohio 39159 15737 102
2452868 2452868 2022-04-28 Union Ohio 39159 15737 102
2449612 2449612 2022-04-27 Union Ohio 39159 15676 102
2446355 2446355 2022-04-26 Union Ohio 39159 15676 102
2443100 2443100 2022-04-25 Union Ohio 39159 15676 102
2439844 2439844 2022-04-24 Union Ohio 39159 15676 102
2436588 2436588 2022-04-23 Union Ohio 39159 15676 102
2433332 2433332 2022-04-22 Union Ohio 39159 15676 102
2430076 2430076 2022-04-21 Union Ohio 39159 15676 102
2426820 2426820 2022-04-20 Union Ohio 39159 15632 102
2423564 2423564 2022-04-19 Union Ohio 39159 15632 102
2420307 2420307 2022-04-18 Union Ohio 39159 15632 102
2417052 2417052 2022-04-17 Union Ohio 39159 15632 102
2413796 2413796 2022-04-16 Union Ohio 39159 15632 102
2410540 2410540 2022-04-15 Union Ohio 39159 15632 102
2407284 2407284 2022-04-14 Union Ohio 39159 15632 102
2404028 2404028 2022-04-13 Union Ohio 39159 15610 102
2400773 2400773 2022-04-12 Union Ohio 39159 15610 102
2397518 2397518 2022-04-11 Union Ohio 39159 15610 102
2394263 2394263 2022-04-10 Union Ohio 39159 15610 102
2391007 2391007 2022-04-09 Union Ohio 39159 15610 102
2387751 2387751 2022-04-08 Union Ohio 39159 15610 102
2384496 2384496 2022-04-07 Union Ohio 39159 15610 102
2381241 2381241 2022-04-06 Union Ohio 39159 15597 102
2377986 2377986 2022-04-05 Union Ohio 39159 15597 102
2374732 2374732 2022-04-04 Union Ohio 39159 15597 102
2371480 2371480 2022-04-03 Union Ohio 39159 15597 102
2368227 2368227 2022-04-02 Union Ohio 39159 15597 102
2364974 2364974 2022-04-01 Union Ohio 39159 15597 102
2361721 2361721 2022-03-31 Union Ohio 39159 15597 102
2358467 2358467 2022-03-30 Union Ohio 39159 15581 102
2355213 2355213 2022-03-29 Union Ohio 39159 15581 102
2351960 2351960 2022-03-28 Union Ohio 39159 15581 102
2348708 2348708 2022-03-27 Union Ohio 39159 15581 102
2345455 2345455 2022-03-26 Union Ohio 39159 15581 102
2342202 2342202 2022-03-25 Union Ohio 39159 15581 102
2338949 2338949 2022-03-24 Union Ohio 39159 15581 102
2335695 2335695 2022-03-23 Union Ohio 39159 15557 99
2332441 2332441 2022-03-22 Union Ohio 39159 15557 99
2329188 2329188 2022-03-21 Union Ohio 39159 15557 99
2325936 2325936 2022-03-20 Union Ohio 39159 15557 99
2322683 2322683 2022-03-19 Union Ohio 39159 15557 99
2319429 2319429 2022-03-18 Union Ohio 39159 15557 99
2316175 2316175 2022-03-17 Union Ohio 39159 15557 99
2312922 2312922 2022-03-16 Union Ohio 39159 15535 99
2309669 2309669 2022-03-15 Union Ohio 39159 15535 99
2306416 2306416 2022-03-14 Union Ohio 39159 15535 99
2303165 2303165 2022-03-13 Union Ohio 39159 15535 99
2299913 2299913 2022-03-12 Union Ohio 39159 15534 99
2296661 2296661 2022-03-11 Union Ohio 39159 15529 99
2293409 2293409 2022-03-10 Union Ohio 39159 15526 98
2290157 2290157 2022-03-09 Union Ohio 39159 15520 98
2286905 2286905 2022-03-08 Union Ohio 39159 15519 98
2283653 2283653 2022-03-07 Union Ohio 39159 15510 97
2280401 2280401 2022-03-06 Union Ohio 39159 15508 97
2277148 2277148 2022-03-05 Union Ohio 39159 15508 97
2273895 2273895 2022-03-04 Union Ohio 39159 15500 97
2270642 2270642 2022-03-03 Union Ohio 39159 15495 95
2267390 2267390 2022-03-02 Union Ohio 39159 15491 95
2264137 2264137 2022-03-01 Union Ohio 39159 15492 95
2260887 2260887 2022-02-28 Union Ohio 39159 15475 93
2257636 2257636 2022-02-27 Union Ohio 39159 15463 93
2254385 2254385 2022-02-26 Union Ohio 39159 15461 93
2251134 2251134 2022-02-25 Union Ohio 39159 15459 93
2247883 2247883 2022-02-24 Union Ohio 39159 15456 92
2244632 2244632 2022-02-23 Union Ohio 39159 15449 92
2241381 2241381 2022-02-22 Union Ohio 39159 15443 92
2238130 2238130 2022-02-21 Union Ohio 39159 15430 90
2234879 2234879 2022-02-20 Union Ohio 39159 15425 90
2231628 2231628 2022-02-19 Union Ohio 39159 15419 90
2228377 2228377 2022-02-18 Union Ohio 39159 15409 90
2225126 2225126 2022-02-17 Union Ohio 39159 15384 89
2221875 2221875 2022-02-16 Union Ohio 39159 15353 89
2218624 2218624 2022-02-15 Union Ohio 39159 15328 89
2215373 2215373 2022-02-14 Union Ohio 39159 15295 88
2212122 2212122 2022-02-13 Union Ohio 39159 15290 88
2208869 2208869 2022-02-12 Union Ohio 39159 15277 88
2205616 2205616 2022-02-11 Union Ohio 39159 15247 88
2202363 2202363 2022-02-10 Union Ohio 39159 15230 88
2199109 2199109 2022-02-09 Union Ohio 39159 15179 88
2195855 2195855 2022-02-08 Union Ohio 39159 15156 88
2192601 2192601 2022-02-07 Union Ohio 39159 15114 87
2189347 2189347 2022-02-06 Union Ohio 39159 15082 87
2186094 2186094 2022-02-05 Union Ohio 39159 15064 87
2182842 2182842 2022-02-04 Union Ohio 39159 15044 87
2179590 2179590 2022-02-03 Union Ohio 39159 15013 85

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