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

1,497 rows where county = "Hughes" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 2

fips 2

county 1

  • Hughes · 1,497 ✖
Link rowid date ▲ county state fips cases deaths
2501764 2501764 2022-05-13 Hughes Oklahoma 40063 2586 62
2502076 2502076 2022-05-13 Hughes South Dakota 46065 4335 58
2498506 2498506 2022-05-12 Hughes Oklahoma 40063 2586 62
2498818 2498818 2022-05-12 Hughes South Dakota 46065 4335 58
2495248 2495248 2022-05-11 Hughes Oklahoma 40063 2585 62
2495560 2495560 2022-05-11 Hughes South Dakota 46065 4335 58
2491990 2491990 2022-05-10 Hughes Oklahoma 40063 2585 62
2492302 2492302 2022-05-10 Hughes South Dakota 46065 4330 58
2488732 2488732 2022-05-09 Hughes Oklahoma 40063 2585 62
2489044 2489044 2022-05-09 Hughes South Dakota 46065 4330 58
2485475 2485475 2022-05-08 Hughes Oklahoma 40063 2585 62
2485787 2485787 2022-05-08 Hughes South Dakota 46065 4330 58
2482217 2482217 2022-05-07 Hughes Oklahoma 40063 2585 62
2482529 2482529 2022-05-07 Hughes South Dakota 46065 4330 58
2478959 2478959 2022-05-06 Hughes Oklahoma 40063 2585 62
2479271 2479271 2022-05-06 Hughes South Dakota 46065 4330 58
2475701 2475701 2022-05-05 Hughes Oklahoma 40063 2585 62
2476013 2476013 2022-05-05 Hughes South Dakota 46065 4330 58
2472444 2472444 2022-05-04 Hughes Oklahoma 40063 2584 62
2472756 2472756 2022-05-04 Hughes South Dakota 46065 4330 58
2469188 2469188 2022-05-03 Hughes Oklahoma 40063 2584 62
2469500 2469500 2022-05-03 Hughes South Dakota 46065 4327 58
2465932 2465932 2022-05-02 Hughes Oklahoma 40063 2584 62
2466244 2466244 2022-05-02 Hughes South Dakota 46065 4327 58
2462677 2462677 2022-05-01 Hughes Oklahoma 40063 2584 62
2462989 2462989 2022-05-01 Hughes South Dakota 46065 4327 58
2459421 2459421 2022-04-30 Hughes Oklahoma 40063 2584 62
2459733 2459733 2022-04-30 Hughes South Dakota 46065 4327 58
2456165 2456165 2022-04-29 Hughes Oklahoma 40063 2584 62
2456477 2456477 2022-04-29 Hughes South Dakota 46065 4327 58
2452909 2452909 2022-04-28 Hughes Oklahoma 40063 2584 62
2453221 2453221 2022-04-28 Hughes South Dakota 46065 4327 58
2449653 2449653 2022-04-27 Hughes Oklahoma 40063 2582 62
2449965 2449965 2022-04-27 Hughes South Dakota 46065 4327 58
2446396 2446396 2022-04-26 Hughes Oklahoma 40063 2582 62
2446708 2446708 2022-04-26 Hughes South Dakota 46065 4315 58
2443141 2443141 2022-04-25 Hughes Oklahoma 40063 2582 62
2443453 2443453 2022-04-25 Hughes South Dakota 46065 4315 58
2439885 2439885 2022-04-24 Hughes Oklahoma 40063 2582 62
2440197 2440197 2022-04-24 Hughes South Dakota 46065 4315 58
2436629 2436629 2022-04-23 Hughes Oklahoma 40063 2582 62
2436941 2436941 2022-04-23 Hughes South Dakota 46065 4315 58
2433373 2433373 2022-04-22 Hughes Oklahoma 40063 2582 62
2433685 2433685 2022-04-22 Hughes South Dakota 46065 4315 58
2430117 2430117 2022-04-21 Hughes Oklahoma 40063 2582 62
2430429 2430429 2022-04-21 Hughes South Dakota 46065 4315 58
2426861 2426861 2022-04-20 Hughes Oklahoma 40063 2581 62
2427173 2427173 2022-04-20 Hughes South Dakota 46065 4315 58
2423605 2423605 2022-04-19 Hughes Oklahoma 40063 2581 62
2423917 2423917 2022-04-19 Hughes South Dakota 46065 4315 58
2420348 2420348 2022-04-18 Hughes Oklahoma 40063 2581 62
2420661 2420661 2022-04-18 Hughes South Dakota 46065 4315 58
2417093 2417093 2022-04-17 Hughes Oklahoma 40063 2581 62
2417405 2417405 2022-04-17 Hughes South Dakota 46065 4315 58
2413837 2413837 2022-04-16 Hughes Oklahoma 40063 2581 62
2414149 2414149 2022-04-16 Hughes South Dakota 46065 4315 58
2410581 2410581 2022-04-15 Hughes Oklahoma 40063 2581 62
2410893 2410893 2022-04-15 Hughes South Dakota 46065 4315 58
2407325 2407325 2022-04-14 Hughes Oklahoma 40063 2581 62
2407637 2407637 2022-04-14 Hughes South Dakota 46065 4315 58
2404069 2404069 2022-04-13 Hughes Oklahoma 40063 2578 61
2404381 2404381 2022-04-13 Hughes South Dakota 46065 4315 58
2400814 2400814 2022-04-12 Hughes Oklahoma 40063 2578 61
2401126 2401126 2022-04-12 Hughes South Dakota 46065 4313 58
2397559 2397559 2022-04-11 Hughes Oklahoma 40063 2578 61
2397871 2397871 2022-04-11 Hughes South Dakota 46065 4313 58
2394304 2394304 2022-04-10 Hughes Oklahoma 40063 2578 61
2394616 2394616 2022-04-10 Hughes South Dakota 46065 4313 58
2391048 2391048 2022-04-09 Hughes Oklahoma 40063 2578 61
2391360 2391360 2022-04-09 Hughes South Dakota 46065 4313 58
2387792 2387792 2022-04-08 Hughes Oklahoma 40063 2578 61
2388104 2388104 2022-04-08 Hughes South Dakota 46065 4313 58
2384537 2384537 2022-04-07 Hughes Oklahoma 40063 2578 61
2384849 2384849 2022-04-07 Hughes South Dakota 46065 4313 58
2381282 2381282 2022-04-06 Hughes Oklahoma 40063 2572 61
2381594 2381594 2022-04-06 Hughes South Dakota 46065 4313 58
2378027 2378027 2022-04-05 Hughes Oklahoma 40063 2572 61
2378339 2378339 2022-04-05 Hughes South Dakota 46065 4307 58
2374773 2374773 2022-04-04 Hughes Oklahoma 40063 2572 61
2375085 2375085 2022-04-04 Hughes South Dakota 46065 4307 58
2371521 2371521 2022-04-03 Hughes Oklahoma 40063 2572 61
2371833 2371833 2022-04-03 Hughes South Dakota 46065 4307 58
2368268 2368268 2022-04-02 Hughes Oklahoma 40063 2572 61
2368580 2368580 2022-04-02 Hughes South Dakota 46065 4307 58
2365015 2365015 2022-04-01 Hughes Oklahoma 40063 2572 61
2365327 2365327 2022-04-01 Hughes South Dakota 46065 4307 58
2361762 2361762 2022-03-31 Hughes Oklahoma 40063 2572 61
2362074 2362074 2022-03-31 Hughes South Dakota 46065 4307 58
2358508 2358508 2022-03-30 Hughes Oklahoma 40063 2570 61
2358820 2358820 2022-03-30 Hughes South Dakota 46065 4307 58
2355254 2355254 2022-03-29 Hughes Oklahoma 40063 2570 61
2355566 2355566 2022-03-29 Hughes South Dakota 46065 4304 58
2352001 2352001 2022-03-28 Hughes Oklahoma 40063 2570 61
2352313 2352313 2022-03-28 Hughes South Dakota 46065 4304 58
2348749 2348749 2022-03-27 Hughes Oklahoma 40063 2570 61
2349061 2349061 2022-03-27 Hughes South Dakota 46065 4304 58
2345496 2345496 2022-03-26 Hughes Oklahoma 40063 2570 61
2345808 2345808 2022-03-26 Hughes South Dakota 46065 4304 58
2342243 2342243 2022-03-25 Hughes Oklahoma 40063 2570 61
2342555 2342555 2022-03-25 Hughes South Dakota 46065 4304 58

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