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

715 rows where county = "Hughes", fips = 40063 and state = "Oklahoma" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Oklahoma · 715 ✖

fips 1

  • 40063 · 715 ✖

county 1

  • Hughes · 715 ✖
Link rowid date ▲ county state fips cases deaths
2501764 2501764 2022-05-13 Hughes Oklahoma 40063 2586 62
2498506 2498506 2022-05-12 Hughes Oklahoma 40063 2586 62
2495248 2495248 2022-05-11 Hughes Oklahoma 40063 2585 62
2491990 2491990 2022-05-10 Hughes Oklahoma 40063 2585 62
2488732 2488732 2022-05-09 Hughes Oklahoma 40063 2585 62
2485475 2485475 2022-05-08 Hughes Oklahoma 40063 2585 62
2482217 2482217 2022-05-07 Hughes Oklahoma 40063 2585 62
2478959 2478959 2022-05-06 Hughes Oklahoma 40063 2585 62
2475701 2475701 2022-05-05 Hughes Oklahoma 40063 2585 62
2472444 2472444 2022-05-04 Hughes Oklahoma 40063 2584 62
2469188 2469188 2022-05-03 Hughes Oklahoma 40063 2584 62
2465932 2465932 2022-05-02 Hughes Oklahoma 40063 2584 62
2462677 2462677 2022-05-01 Hughes Oklahoma 40063 2584 62
2459421 2459421 2022-04-30 Hughes Oklahoma 40063 2584 62
2456165 2456165 2022-04-29 Hughes Oklahoma 40063 2584 62
2452909 2452909 2022-04-28 Hughes Oklahoma 40063 2584 62
2449653 2449653 2022-04-27 Hughes Oklahoma 40063 2582 62
2446396 2446396 2022-04-26 Hughes Oklahoma 40063 2582 62
2443141 2443141 2022-04-25 Hughes Oklahoma 40063 2582 62
2439885 2439885 2022-04-24 Hughes Oklahoma 40063 2582 62
2436629 2436629 2022-04-23 Hughes Oklahoma 40063 2582 62
2433373 2433373 2022-04-22 Hughes Oklahoma 40063 2582 62
2430117 2430117 2022-04-21 Hughes Oklahoma 40063 2582 62
2426861 2426861 2022-04-20 Hughes Oklahoma 40063 2581 62
2423605 2423605 2022-04-19 Hughes Oklahoma 40063 2581 62
2420348 2420348 2022-04-18 Hughes Oklahoma 40063 2581 62
2417093 2417093 2022-04-17 Hughes Oklahoma 40063 2581 62
2413837 2413837 2022-04-16 Hughes Oklahoma 40063 2581 62
2410581 2410581 2022-04-15 Hughes Oklahoma 40063 2581 62
2407325 2407325 2022-04-14 Hughes Oklahoma 40063 2581 62
2404069 2404069 2022-04-13 Hughes Oklahoma 40063 2578 61
2400814 2400814 2022-04-12 Hughes Oklahoma 40063 2578 61
2397559 2397559 2022-04-11 Hughes Oklahoma 40063 2578 61
2394304 2394304 2022-04-10 Hughes Oklahoma 40063 2578 61
2391048 2391048 2022-04-09 Hughes Oklahoma 40063 2578 61
2387792 2387792 2022-04-08 Hughes Oklahoma 40063 2578 61
2384537 2384537 2022-04-07 Hughes Oklahoma 40063 2578 61
2381282 2381282 2022-04-06 Hughes Oklahoma 40063 2572 61
2378027 2378027 2022-04-05 Hughes Oklahoma 40063 2572 61
2374773 2374773 2022-04-04 Hughes Oklahoma 40063 2572 61
2371521 2371521 2022-04-03 Hughes Oklahoma 40063 2572 61
2368268 2368268 2022-04-02 Hughes Oklahoma 40063 2572 61
2365015 2365015 2022-04-01 Hughes Oklahoma 40063 2572 61
2361762 2361762 2022-03-31 Hughes Oklahoma 40063 2572 61
2358508 2358508 2022-03-30 Hughes Oklahoma 40063 2570 61
2355254 2355254 2022-03-29 Hughes Oklahoma 40063 2570 61
2352001 2352001 2022-03-28 Hughes Oklahoma 40063 2570 61
2348749 2348749 2022-03-27 Hughes Oklahoma 40063 2570 61
2345496 2345496 2022-03-26 Hughes Oklahoma 40063 2570 61
2342243 2342243 2022-03-25 Hughes Oklahoma 40063 2570 61
2338990 2338990 2022-03-24 Hughes Oklahoma 40063 2570 61
2335736 2335736 2022-03-23 Hughes Oklahoma 40063 2561 60
2332482 2332482 2022-03-22 Hughes Oklahoma 40063 2561 60
2329229 2329229 2022-03-21 Hughes Oklahoma 40063 2561 60
2325977 2325977 2022-03-20 Hughes Oklahoma 40063 2561 60
2322724 2322724 2022-03-19 Hughes Oklahoma 40063 2561 60
2319470 2319470 2022-03-18 Hughes Oklahoma 40063 2561 60
2316216 2316216 2022-03-17 Hughes Oklahoma 40063 2561 60
2312963 2312963 2022-03-16 Hughes Oklahoma 40063 2548 58
2309710 2309710 2022-03-15 Hughes Oklahoma 40063 2548 58
2306457 2306457 2022-03-14 Hughes Oklahoma 40063 2548 58
2303206 2303206 2022-03-13 Hughes Oklahoma 40063 2548 58
2299954 2299954 2022-03-12 Hughes Oklahoma 40063 2548 58
2296702 2296702 2022-03-11 Hughes Oklahoma 40063 2548 58
2293450 2293450 2022-03-10 Hughes Oklahoma 40063 2548 58
2290198 2290198 2022-03-09 Hughes Oklahoma 40063 2543 58
2286946 2286946 2022-03-08 Hughes Oklahoma 40063 2543 58
2283694 2283694 2022-03-07 Hughes Oklahoma 40063 2543 58
2280442 2280442 2022-03-06 Hughes Oklahoma 40063 2543 58
2277189 2277189 2022-03-05 Hughes Oklahoma 40063 2543 58
2273936 2273936 2022-03-04 Hughes Oklahoma 40063 2543 58
2270683 2270683 2022-03-03 Hughes Oklahoma 40063 2543 58
2267431 2267431 2022-03-02 Hughes Oklahoma 40063 2543 58
2264178 2264178 2022-03-01 Hughes Oklahoma 40063 2532 56
2260928 2260928 2022-02-28 Hughes Oklahoma 40063 2532 56
2257677 2257677 2022-02-27 Hughes Oklahoma 40063 2532 56
2254426 2254426 2022-02-26 Hughes Oklahoma 40063 2532 56
2251175 2251175 2022-02-25 Hughes Oklahoma 40063 2532 56
2247924 2247924 2022-02-24 Hughes Oklahoma 40063 2532 56
2244673 2244673 2022-02-23 Hughes Oklahoma 40063 2532 56
2241422 2241422 2022-02-22 Hughes Oklahoma 40063 2507 53
2238171 2238171 2022-02-21 Hughes Oklahoma 40063 2507 53
2234920 2234920 2022-02-20 Hughes Oklahoma 40063 2507 53
2231669 2231669 2022-02-19 Hughes Oklahoma 40063 2507 53
2228418 2228418 2022-02-18 Hughes Oklahoma 40063 2507 53
2225167 2225167 2022-02-17 Hughes Oklahoma 40063 2507 53
2221916 2221916 2022-02-16 Hughes Oklahoma 40063 2507 53
2218665 2218665 2022-02-15 Hughes Oklahoma 40063 2488 50
2215414 2215414 2022-02-14 Hughes Oklahoma 40063 2488 50
2212163 2212163 2022-02-13 Hughes Oklahoma 40063 2488 50
2208910 2208910 2022-02-12 Hughes Oklahoma 40063 2488 50
2205657 2205657 2022-02-11 Hughes Oklahoma 40063 2488 50
2202404 2202404 2022-02-10 Hughes Oklahoma 40063 2488 50
2199150 2199150 2022-02-09 Hughes Oklahoma 40063 2488 50
2195896 2195896 2022-02-08 Hughes Oklahoma 40063 2413 49
2192642 2192642 2022-02-07 Hughes Oklahoma 40063 2413 49
2189388 2189388 2022-02-06 Hughes Oklahoma 40063 2413 49
2186135 2186135 2022-02-05 Hughes Oklahoma 40063 2413 49
2182883 2182883 2022-02-04 Hughes Oklahoma 40063 2413 49
2179631 2179631 2022-02-03 Hughes Oklahoma 40063 2413 49

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