home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

786 rows where county = "Montgomery" and fips = 39113 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Ohio 786

fips 1

  • 39113 · 786 ✖

county 1

  • Montgomery · 786 ✖
Link rowid date ▲ county state fips cases deaths
2501700 2501700 2022-05-13 Montgomery Ohio 39113 128090 2019
2498442 2498442 2022-05-12 Montgomery Ohio 39113 128090 2019
2495184 2495184 2022-05-11 Montgomery Ohio 39113 127624 2018
2491926 2491926 2022-05-10 Montgomery Ohio 39113 127624 2018
2488668 2488668 2022-05-09 Montgomery Ohio 39113 127624 2018
2485411 2485411 2022-05-08 Montgomery Ohio 39113 127624 2018
2482153 2482153 2022-05-07 Montgomery Ohio 39113 127624 2018
2478895 2478895 2022-05-06 Montgomery Ohio 39113 127624 2018
2475637 2475637 2022-05-05 Montgomery Ohio 39113 127624 2018
2472380 2472380 2022-05-04 Montgomery Ohio 39113 127316 2017
2469124 2469124 2022-05-03 Montgomery Ohio 39113 127316 2017
2465868 2465868 2022-05-02 Montgomery Ohio 39113 127316 2017
2462613 2462613 2022-05-01 Montgomery Ohio 39113 127316 2017
2459357 2459357 2022-04-30 Montgomery Ohio 39113 127316 2017
2456101 2456101 2022-04-29 Montgomery Ohio 39113 127316 2017
2452845 2452845 2022-04-28 Montgomery Ohio 39113 127316 2017
2449589 2449589 2022-04-27 Montgomery Ohio 39113 127061 2010
2446332 2446332 2022-04-26 Montgomery Ohio 39113 127061 2010
2443077 2443077 2022-04-25 Montgomery Ohio 39113 127061 2010
2439821 2439821 2022-04-24 Montgomery Ohio 39113 127061 2010
2436565 2436565 2022-04-23 Montgomery Ohio 39113 127061 2010
2433309 2433309 2022-04-22 Montgomery Ohio 39113 127061 2010
2430053 2430053 2022-04-21 Montgomery Ohio 39113 127061 2010
2426797 2426797 2022-04-20 Montgomery Ohio 39113 126836 2004
2423541 2423541 2022-04-19 Montgomery Ohio 39113 126836 2004
2420284 2420284 2022-04-18 Montgomery Ohio 39113 126836 2004
2417029 2417029 2022-04-17 Montgomery Ohio 39113 126836 2004
2413773 2413773 2022-04-16 Montgomery Ohio 39113 126836 2004
2410517 2410517 2022-04-15 Montgomery Ohio 39113 126836 2004
2407261 2407261 2022-04-14 Montgomery Ohio 39113 126836 2004
2404005 2404005 2022-04-13 Montgomery Ohio 39113 126726 1998
2400750 2400750 2022-04-12 Montgomery Ohio 39113 126726 1998
2397495 2397495 2022-04-11 Montgomery Ohio 39113 126726 1998
2394240 2394240 2022-04-10 Montgomery Ohio 39113 126726 1998
2390984 2390984 2022-04-09 Montgomery Ohio 39113 126726 1998
2387728 2387728 2022-04-08 Montgomery Ohio 39113 126726 1998
2384473 2384473 2022-04-07 Montgomery Ohio 39113 126726 1998
2381218 2381218 2022-04-06 Montgomery Ohio 39113 126644 1995
2377963 2377963 2022-04-05 Montgomery Ohio 39113 126644 1995
2374709 2374709 2022-04-04 Montgomery Ohio 39113 126644 1995
2371457 2371457 2022-04-03 Montgomery Ohio 39113 126644 1995
2368204 2368204 2022-04-02 Montgomery Ohio 39113 126644 1995
2364951 2364951 2022-04-01 Montgomery Ohio 39113 126644 1995
2361698 2361698 2022-03-31 Montgomery Ohio 39113 126644 1995
2358444 2358444 2022-03-30 Montgomery Ohio 39113 126568 1973
2355190 2355190 2022-03-29 Montgomery Ohio 39113 126568 1973
2351937 2351937 2022-03-28 Montgomery Ohio 39113 126568 1973
2348685 2348685 2022-03-27 Montgomery Ohio 39113 126568 1973
2345432 2345432 2022-03-26 Montgomery Ohio 39113 126568 1973
2342179 2342179 2022-03-25 Montgomery Ohio 39113 126568 1973
2338926 2338926 2022-03-24 Montgomery Ohio 39113 126568 1973
2335672 2335672 2022-03-23 Montgomery Ohio 39113 126462 1963
2332418 2332418 2022-03-22 Montgomery Ohio 39113 126462 1963
2329165 2329165 2022-03-21 Montgomery Ohio 39113 126462 1963
2325913 2325913 2022-03-20 Montgomery Ohio 39113 126462 1963
2322660 2322660 2022-03-19 Montgomery Ohio 39113 126462 1963
2319406 2319406 2022-03-18 Montgomery Ohio 39113 126462 1963
2316152 2316152 2022-03-17 Montgomery Ohio 39113 126462 1963
2312899 2312899 2022-03-16 Montgomery Ohio 39113 126396 1955
2309646 2309646 2022-03-15 Montgomery Ohio 39113 126396 1955
2306393 2306393 2022-03-14 Montgomery Ohio 39113 126396 1955
2303142 2303142 2022-03-13 Montgomery Ohio 39113 126396 1955
2299890 2299890 2022-03-12 Montgomery Ohio 39113 126376 1955
2296638 2296638 2022-03-11 Montgomery Ohio 39113 126364 1955
2293386 2293386 2022-03-10 Montgomery Ohio 39113 126343 1936
2290134 2290134 2022-03-09 Montgomery Ohio 39113 126315 1936
2286882 2286882 2022-03-08 Montgomery Ohio 39113 126274 1936
2283630 2283630 2022-03-07 Montgomery Ohio 39113 126261 1930
2280378 2280378 2022-03-06 Montgomery Ohio 39113 126245 1930
2277125 2277125 2022-03-05 Montgomery Ohio 39113 126238 1930
2273872 2273872 2022-03-04 Montgomery Ohio 39113 126208 1930
2270619 2270619 2022-03-03 Montgomery Ohio 39113 126181 1915
2267367 2267367 2022-03-02 Montgomery Ohio 39113 126123 1915
2264114 2264114 2022-03-01 Montgomery Ohio 39113 126077 1915
2260864 2260864 2022-02-28 Montgomery Ohio 39113 126019 1897
2257613 2257613 2022-02-27 Montgomery Ohio 39113 125997 1897
2254362 2254362 2022-02-26 Montgomery Ohio 39113 125970 1897
2251111 2251111 2022-02-25 Montgomery Ohio 39113 125903 1897
2247860 2247860 2022-02-24 Montgomery Ohio 39113 125830 1875
2244609 2244609 2022-02-23 Montgomery Ohio 39113 125776 1875
2241358 2241358 2022-02-22 Montgomery Ohio 39113 125692 1875
2238107 2238107 2022-02-21 Montgomery Ohio 39113 125641 1841
2234856 2234856 2022-02-20 Montgomery Ohio 39113 125587 1841
2231605 2231605 2022-02-19 Montgomery Ohio 39113 125544 1841
2228354 2228354 2022-02-18 Montgomery Ohio 39113 125492 1841
2225103 2225103 2022-02-17 Montgomery Ohio 39113 125404 1835
2221852 2221852 2022-02-16 Montgomery Ohio 39113 125331 1835
2218601 2218601 2022-02-15 Montgomery Ohio 39113 125221 1835
2215350 2215350 2022-02-14 Montgomery Ohio 39113 125140 1818
2212099 2212099 2022-02-13 Montgomery Ohio 39113 125068 1818
2208846 2208846 2022-02-12 Montgomery Ohio 39113 124985 1818
2205593 2205593 2022-02-11 Montgomery Ohio 39113 124923 1818
2202340 2202340 2022-02-10 Montgomery Ohio 39113 124706 1775
2199086 2199086 2022-02-09 Montgomery Ohio 39113 124511 1775
2195832 2195832 2022-02-08 Montgomery Ohio 39113 124263 1775
2192578 2192578 2022-02-07 Montgomery Ohio 39113 124004 1762
2189324 2189324 2022-02-06 Montgomery Ohio 39113 123872 1762
2186071 2186071 2022-02-05 Montgomery Ohio 39113 123767 1762
2182819 2182819 2022-02-04 Montgomery Ohio 39113 123590 1762
2179567 2179567 2022-02-03 Montgomery Ohio 39113 123292 1726

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);
Powered by Datasette · Queries took 201.275ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette