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,559 rows where county = "Humphreys" 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

  • Humphreys · 1,559 ✖
Link rowid date ▲ county state fips cases deaths
2501019 2501019 2022-05-13 Humphreys Mississippi 28053 2030 46
2502153 2502153 2022-05-13 Humphreys Tennessee 47085 4855 74
2497761 2497761 2022-05-12 Humphreys Mississippi 28053 2030 46
2498895 2498895 2022-05-12 Humphreys Tennessee 47085 4855 74
2494503 2494503 2022-05-11 Humphreys Mississippi 28053 2030 46
2495637 2495637 2022-05-11 Humphreys Tennessee 47085 4855 74
2491245 2491245 2022-05-10 Humphreys Mississippi 28053 2030 46
2492379 2492379 2022-05-10 Humphreys Tennessee 47085 4849 74
2487988 2487988 2022-05-09 Humphreys Mississippi 28053 2030 46
2489121 2489121 2022-05-09 Humphreys Tennessee 47085 4849 74
2484730 2484730 2022-05-08 Humphreys Mississippi 28053 2030 46
2485864 2485864 2022-05-08 Humphreys Tennessee 47085 4849 74
2481472 2481472 2022-05-07 Humphreys Mississippi 28053 2030 46
2482606 2482606 2022-05-07 Humphreys Tennessee 47085 4849 74
2478214 2478214 2022-05-06 Humphreys Mississippi 28053 2030 46
2479348 2479348 2022-05-06 Humphreys Tennessee 47085 4849 74
2474956 2474956 2022-05-05 Humphreys Mississippi 28053 2030 46
2476090 2476090 2022-05-05 Humphreys Tennessee 47085 4849 74
2471699 2471699 2022-05-04 Humphreys Mississippi 28053 2030 46
2472833 2472833 2022-05-04 Humphreys Tennessee 47085 4849 74
2468443 2468443 2022-05-03 Humphreys Mississippi 28053 2030 46
2469577 2469577 2022-05-03 Humphreys Tennessee 47085 4846 74
2465188 2465188 2022-05-02 Humphreys Mississippi 28053 2030 46
2466321 2466321 2022-05-02 Humphreys Tennessee 47085 4846 74
2461932 2461932 2022-05-01 Humphreys Mississippi 28053 2030 45
2463066 2463066 2022-05-01 Humphreys Tennessee 47085 4846 74
2458676 2458676 2022-04-30 Humphreys Mississippi 28053 2030 45
2459810 2459810 2022-04-30 Humphreys Tennessee 47085 4846 74
2455420 2455420 2022-04-29 Humphreys Mississippi 28053 2030 45
2456554 2456554 2022-04-29 Humphreys Tennessee 47085 4846 74
2452164 2452164 2022-04-28 Humphreys Mississippi 28053 2030 45
2453298 2453298 2022-04-28 Humphreys Tennessee 47085 4846 74
2448908 2448908 2022-04-27 Humphreys Mississippi 28053 2030 45
2450042 2450042 2022-04-27 Humphreys Tennessee 47085 4846 74
2445652 2445652 2022-04-26 Humphreys Mississippi 28053 2030 45
2446785 2446785 2022-04-26 Humphreys Tennessee 47085 4841 74
2442396 2442396 2022-04-25 Humphreys Mississippi 28053 2030 45
2443530 2443530 2022-04-25 Humphreys Tennessee 47085 4841 74
2439140 2439140 2022-04-24 Humphreys Mississippi 28053 2030 45
2440274 2440274 2022-04-24 Humphreys Tennessee 47085 4841 74
2435884 2435884 2022-04-23 Humphreys Mississippi 28053 2030 45
2437018 2437018 2022-04-23 Humphreys Tennessee 47085 4841 74
2432628 2432628 2022-04-22 Humphreys Mississippi 28053 2030 45
2433762 2433762 2022-04-22 Humphreys Tennessee 47085 4841 74
2429372 2429372 2022-04-21 Humphreys Mississippi 28053 2030 45
2430506 2430506 2022-04-21 Humphreys Tennessee 47085 4841 74
2426116 2426116 2022-04-20 Humphreys Mississippi 28053 2030 45
2427250 2427250 2022-04-20 Humphreys Tennessee 47085 4841 74
2422860 2422860 2022-04-19 Humphreys Mississippi 28053 2030 45
2423994 2423994 2022-04-19 Humphreys Tennessee 47085 4840 74
2419604 2419604 2022-04-18 Humphreys Mississippi 28053 2030 45
2420738 2420738 2022-04-18 Humphreys Tennessee 47085 4840 74
2416348 2416348 2022-04-17 Humphreys Mississippi 28053 2030 45
2417482 2417482 2022-04-17 Humphreys Tennessee 47085 4840 74
2413092 2413092 2022-04-16 Humphreys Mississippi 28053 2030 45
2414226 2414226 2022-04-16 Humphreys Tennessee 47085 4840 74
2409836 2409836 2022-04-15 Humphreys Mississippi 28053 2030 45
2410970 2410970 2022-04-15 Humphreys Tennessee 47085 4840 74
2406580 2406580 2022-04-14 Humphreys Mississippi 28053 2030 45
2407714 2407714 2022-04-14 Humphreys Tennessee 47085 4840 74
2403324 2403324 2022-04-13 Humphreys Mississippi 28053 2030 45
2404458 2404458 2022-04-13 Humphreys Tennessee 47085 4840 74
2400070 2400070 2022-04-12 Humphreys Mississippi 28053 2030 45
2401203 2401203 2022-04-12 Humphreys Tennessee 47085 4839 72
2396814 2396814 2022-04-11 Humphreys Mississippi 28053 2029 45
2397948 2397948 2022-04-11 Humphreys Tennessee 47085 4839 72
2393559 2393559 2022-04-10 Humphreys Mississippi 28053 2029 45
2394693 2394693 2022-04-10 Humphreys Tennessee 47085 4839 72
2390303 2390303 2022-04-09 Humphreys Mississippi 28053 2029 45
2391437 2391437 2022-04-09 Humphreys Tennessee 47085 4839 72
2387047 2387047 2022-04-08 Humphreys Mississippi 28053 2029 45
2388181 2388181 2022-04-08 Humphreys Tennessee 47085 4839 72
2383792 2383792 2022-04-07 Humphreys Mississippi 28053 2029 45
2384926 2384926 2022-04-07 Humphreys Tennessee 47085 4839 72
2380537 2380537 2022-04-06 Humphreys Mississippi 28053 2029 45
2381671 2381671 2022-04-06 Humphreys Tennessee 47085 4839 72
2377282 2377282 2022-04-05 Humphreys Mississippi 28053 2029 45
2378416 2378416 2022-04-05 Humphreys Tennessee 47085 4840 70
2374030 2374030 2022-04-04 Humphreys Mississippi 28053 2029 45
2375162 2375162 2022-04-04 Humphreys Tennessee 47085 4840 70
2370777 2370777 2022-04-03 Humphreys Mississippi 28053 2019 45
2371910 2371910 2022-04-03 Humphreys Tennessee 47085 4840 70
2367524 2367524 2022-04-02 Humphreys Mississippi 28053 2019 45
2368657 2368657 2022-04-02 Humphreys Tennessee 47085 4840 70
2364271 2364271 2022-04-01 Humphreys Mississippi 28053 2019 45
2365404 2365404 2022-04-01 Humphreys Tennessee 47085 4840 70
2361017 2361017 2022-03-31 Humphreys Mississippi 28053 2019 45
2362151 2362151 2022-03-31 Humphreys Tennessee 47085 4840 70
2357763 2357763 2022-03-30 Humphreys Mississippi 28053 2019 45
2358897 2358897 2022-03-30 Humphreys Tennessee 47085 4840 70
2354510 2354510 2022-03-29 Humphreys Mississippi 28053 2019 45
2355643 2355643 2022-03-29 Humphreys Tennessee 47085 4837 70
2351258 2351258 2022-03-28 Humphreys Mississippi 28053 2019 45
2352390 2352390 2022-03-28 Humphreys Tennessee 47085 4837 70
2348005 2348005 2022-03-27 Humphreys Mississippi 28053 2014 44
2349138 2349138 2022-03-27 Humphreys Tennessee 47085 4837 70
2344752 2344752 2022-03-26 Humphreys Mississippi 28053 2014 44
2345885 2345885 2022-03-26 Humphreys Tennessee 47085 4837 70
2341499 2341499 2022-03-25 Humphreys Mississippi 28053 2014 44
2342632 2342632 2022-03-25 Humphreys Tennessee 47085 4837 70

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