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

785 rows where county = "Marion" and state = "Ohio" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Ohio · 785 ✖

fips 1

  • 39101 785

county 1

  • Marion · 785 ✖
Link rowid date ▲ county state fips cases deaths
2501694 2501694 2022-05-13 Marion Ohio 39101 20070 268
2498436 2498436 2022-05-12 Marion Ohio 39101 20070 268
2495178 2495178 2022-05-11 Marion Ohio 39101 19996 268
2491920 2491920 2022-05-10 Marion Ohio 39101 19996 268
2488662 2488662 2022-05-09 Marion Ohio 39101 19996 268
2485405 2485405 2022-05-08 Marion Ohio 39101 19996 268
2482147 2482147 2022-05-07 Marion Ohio 39101 19996 268
2478889 2478889 2022-05-06 Marion Ohio 39101 19996 268
2475631 2475631 2022-05-05 Marion Ohio 39101 19996 268
2472374 2472374 2022-05-04 Marion Ohio 39101 19929 268
2469118 2469118 2022-05-03 Marion Ohio 39101 19929 268
2465862 2465862 2022-05-02 Marion Ohio 39101 19929 268
2462607 2462607 2022-05-01 Marion Ohio 39101 19929 268
2459351 2459351 2022-04-30 Marion Ohio 39101 19929 268
2456095 2456095 2022-04-29 Marion Ohio 39101 19929 268
2452839 2452839 2022-04-28 Marion Ohio 39101 19929 268
2449583 2449583 2022-04-27 Marion Ohio 39101 19874 267
2446326 2446326 2022-04-26 Marion Ohio 39101 19874 267
2443071 2443071 2022-04-25 Marion Ohio 39101 19874 267
2439815 2439815 2022-04-24 Marion Ohio 39101 19874 267
2436559 2436559 2022-04-23 Marion Ohio 39101 19874 267
2433303 2433303 2022-04-22 Marion Ohio 39101 19874 267
2430047 2430047 2022-04-21 Marion Ohio 39101 19874 267
2426791 2426791 2022-04-20 Marion Ohio 39101 19854 266
2423535 2423535 2022-04-19 Marion Ohio 39101 19854 266
2420278 2420278 2022-04-18 Marion Ohio 39101 19854 266
2417023 2417023 2022-04-17 Marion Ohio 39101 19854 266
2413767 2413767 2022-04-16 Marion Ohio 39101 19854 266
2410511 2410511 2022-04-15 Marion Ohio 39101 19854 266
2407255 2407255 2022-04-14 Marion Ohio 39101 19854 266
2403999 2403999 2022-04-13 Marion Ohio 39101 19841 266
2400744 2400744 2022-04-12 Marion Ohio 39101 19841 266
2397489 2397489 2022-04-11 Marion Ohio 39101 19841 266
2394234 2394234 2022-04-10 Marion Ohio 39101 19841 266
2390978 2390978 2022-04-09 Marion Ohio 39101 19841 266
2387722 2387722 2022-04-08 Marion Ohio 39101 19841 266
2384467 2384467 2022-04-07 Marion Ohio 39101 19841 266
2381212 2381212 2022-04-06 Marion Ohio 39101 19830 265
2377957 2377957 2022-04-05 Marion Ohio 39101 19830 265
2374703 2374703 2022-04-04 Marion Ohio 39101 19830 265
2371451 2371451 2022-04-03 Marion Ohio 39101 19830 265
2368198 2368198 2022-04-02 Marion Ohio 39101 19830 265
2364945 2364945 2022-04-01 Marion Ohio 39101 19830 265
2361692 2361692 2022-03-31 Marion Ohio 39101 19830 265
2358438 2358438 2022-03-30 Marion Ohio 39101 19819 263
2355184 2355184 2022-03-29 Marion Ohio 39101 19819 263
2351931 2351931 2022-03-28 Marion Ohio 39101 19819 263
2348679 2348679 2022-03-27 Marion Ohio 39101 19819 263
2345426 2345426 2022-03-26 Marion Ohio 39101 19819 263
2342173 2342173 2022-03-25 Marion Ohio 39101 19819 263
2338920 2338920 2022-03-24 Marion Ohio 39101 19819 263
2335666 2335666 2022-03-23 Marion Ohio 39101 19805 262
2332412 2332412 2022-03-22 Marion Ohio 39101 19805 262
2329159 2329159 2022-03-21 Marion Ohio 39101 19805 262
2325907 2325907 2022-03-20 Marion Ohio 39101 19805 262
2322654 2322654 2022-03-19 Marion Ohio 39101 19805 262
2319400 2319400 2022-03-18 Marion Ohio 39101 19805 262
2316146 2316146 2022-03-17 Marion Ohio 39101 19805 262
2312893 2312893 2022-03-16 Marion Ohio 39101 19788 262
2309640 2309640 2022-03-15 Marion Ohio 39101 19788 262
2306387 2306387 2022-03-14 Marion Ohio 39101 19788 262
2303136 2303136 2022-03-13 Marion Ohio 39101 19788 262
2299884 2299884 2022-03-12 Marion Ohio 39101 19786 262
2296632 2296632 2022-03-11 Marion Ohio 39101 19782 262
2293380 2293380 2022-03-10 Marion Ohio 39101 19781 262
2290128 2290128 2022-03-09 Marion Ohio 39101 19779 262
2286876 2286876 2022-03-08 Marion Ohio 39101 19776 262
2283624 2283624 2022-03-07 Marion Ohio 39101 19773 262
2280372 2280372 2022-03-06 Marion Ohio 39101 19770 262
2277119 2277119 2022-03-05 Marion Ohio 39101 19766 262
2273866 2273866 2022-03-04 Marion Ohio 39101 19763 262
2270613 2270613 2022-03-03 Marion Ohio 39101 19756 261
2267361 2267361 2022-03-02 Marion Ohio 39101 19749 261
2264108 2264108 2022-03-01 Marion Ohio 39101 19735 261
2260858 2260858 2022-02-28 Marion Ohio 39101 19730 256
2257607 2257607 2022-02-27 Marion Ohio 39101 19722 256
2254356 2254356 2022-02-26 Marion Ohio 39101 19719 256
2251105 2251105 2022-02-25 Marion Ohio 39101 19710 256
2247854 2247854 2022-02-24 Marion Ohio 39101 19696 253
2244603 2244603 2022-02-23 Marion Ohio 39101 19689 253
2241352 2241352 2022-02-22 Marion Ohio 39101 19674 253
2238101 2238101 2022-02-21 Marion Ohio 39101 19663 251
2234850 2234850 2022-02-20 Marion Ohio 39101 19658 251
2231599 2231599 2022-02-19 Marion Ohio 39101 19648 251
2228348 2228348 2022-02-18 Marion Ohio 39101 19636 251
2225097 2225097 2022-02-17 Marion Ohio 39101 19619 250
2221846 2221846 2022-02-16 Marion Ohio 39101 19586 250
2218595 2218595 2022-02-15 Marion Ohio 39101 19568 250
2215344 2215344 2022-02-14 Marion Ohio 39101 19546 247
2212093 2212093 2022-02-13 Marion Ohio 39101 19532 247
2208840 2208840 2022-02-12 Marion Ohio 39101 19525 247
2205587 2205587 2022-02-11 Marion Ohio 39101 19505 247
2202334 2202334 2022-02-10 Marion Ohio 39101 19482 244
2199080 2199080 2022-02-09 Marion Ohio 39101 19459 244
2195826 2195826 2022-02-08 Marion Ohio 39101 19433 244
2192572 2192572 2022-02-07 Marion Ohio 39101 19401 244
2189318 2189318 2022-02-06 Marion Ohio 39101 19376 244
2186065 2186065 2022-02-05 Marion Ohio 39101 19359 244
2182813 2182813 2022-02-04 Marion Ohio 39101 19349 244
2179561 2179561 2022-02-03 Marion Ohio 39101 19332 242

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 1170.574ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette