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

773 rows where county = "Hancock", fips = 23009 and state = "Maine" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Maine · 773 ✖

fips 1

  • 23009 · 773 ✖

county 1

  • Hancock · 773 ✖
Link rowid date ▲ county state fips cases deaths
2500768 2500768 2022-05-13 Hancock Maine 23009 7983 87
2497510 2497510 2022-05-12 Hancock Maine 23009 7954 87
2494252 2494252 2022-05-11 Hancock Maine 23009 7895 87
2490994 2490994 2022-05-10 Hancock Maine 23009 7843 87
2487737 2487737 2022-05-09 Hancock Maine 23009 7812 87
2484479 2484479 2022-05-08 Hancock Maine 23009 7793 87
2481221 2481221 2022-05-07 Hancock Maine 23009 7793 87
2477963 2477963 2022-05-06 Hancock Maine 23009 7757 87
2474705 2474705 2022-05-05 Hancock Maine 23009 7723 87
2471448 2471448 2022-05-04 Hancock Maine 23009 7702 85
2468192 2468192 2022-05-03 Hancock Maine 23009 7653 85
2464937 2464937 2022-05-02 Hancock Maine 23009 7613 85
2461681 2461681 2022-05-01 Hancock Maine 23009 7585 85
2458425 2458425 2022-04-30 Hancock Maine 23009 7585 85
2455169 2455169 2022-04-29 Hancock Maine 23009 7558 85
2451913 2451913 2022-04-28 Hancock Maine 23009 7540 85
2448657 2448657 2022-04-27 Hancock Maine 23009 7531 85
2445401 2445401 2022-04-26 Hancock Maine 23009 7506 85
2442145 2442145 2022-04-25 Hancock Maine 23009 7497 85
2438889 2438889 2022-04-24 Hancock Maine 23009 7497 85
2435633 2435633 2022-04-23 Hancock Maine 23009 7497 85
2432377 2432377 2022-04-22 Hancock Maine 23009 7490 85
2429121 2429121 2022-04-21 Hancock Maine 23009 7484 84
2425865 2425865 2022-04-20 Hancock Maine 23009 7474 84
2422609 2422609 2022-04-19 Hancock Maine 23009 7460 84
2419353 2419353 2022-04-18 Hancock Maine 23009 7460 84
2416097 2416097 2022-04-17 Hancock Maine 23009 7460 84
2412841 2412841 2022-04-16 Hancock Maine 23009 7460 84
2409585 2409585 2022-04-15 Hancock Maine 23009 7445 84
2406329 2406329 2022-04-14 Hancock Maine 23009 7429 84
2403073 2403073 2022-04-13 Hancock Maine 23009 7424 84
2399819 2399819 2022-04-12 Hancock Maine 23009 7403 84
2396563 2396563 2022-04-11 Hancock Maine 23009 7392 81
2393308 2393308 2022-04-10 Hancock Maine 23009 7392 81
2390052 2390052 2022-04-09 Hancock Maine 23009 7392 81
2386796 2386796 2022-04-08 Hancock Maine 23009 7390 81
2383541 2383541 2022-04-07 Hancock Maine 23009 7381 81
2380286 2380286 2022-04-06 Hancock Maine 23009 7375 81
2377031 2377031 2022-04-05 Hancock Maine 23009 7369 81
2373779 2373779 2022-04-04 Hancock Maine 23009 7358 81
2370526 2370526 2022-04-03 Hancock Maine 23009 7358 81
2367273 2367273 2022-04-02 Hancock Maine 23009 7358 81
2364020 2364020 2022-04-01 Hancock Maine 23009 7357 81
2360766 2360766 2022-03-31 Hancock Maine 23009 7349 81
2357512 2357512 2022-03-30 Hancock Maine 23009 7340 81
2354259 2354259 2022-03-29 Hancock Maine 23009 7326 81
2351007 2351007 2022-03-28 Hancock Maine 23009 7308 81
2347754 2347754 2022-03-27 Hancock Maine 23009 7308 81
2344501 2344501 2022-03-26 Hancock Maine 23009 7308 81
2341248 2341248 2022-03-25 Hancock Maine 23009 7302 81
2337995 2337995 2022-03-24 Hancock Maine 23009 7296 81
2334741 2334741 2022-03-23 Hancock Maine 23009 7291 81
2331487 2331487 2022-03-22 Hancock Maine 23009 7298 81
2328235 2328235 2022-03-21 Hancock Maine 23009 7298 81
2324982 2324982 2022-03-20 Hancock Maine 23009 7298 81
2321728 2321728 2022-03-19 Hancock Maine 23009 7298 81
2318474 2318474 2022-03-18 Hancock Maine 23009 7294 81
2315221 2315221 2022-03-17 Hancock Maine 23009 7187 81
2311968 2311968 2022-03-16 Hancock Maine 23009 7186 81
2308715 2308715 2022-03-15 Hancock Maine 23009 7172 79
2305464 2305464 2022-03-14 Hancock Maine 23009 7155 78
2302212 2302212 2022-03-13 Hancock Maine 23009 7155 78
2298960 2298960 2022-03-12 Hancock Maine 23009 7155 78
2295708 2295708 2022-03-11 Hancock Maine 23009 7146 78
2292456 2292456 2022-03-10 Hancock Maine 23009 7133 78
2289204 2289204 2022-03-09 Hancock Maine 23009 7132 77
2285953 2285953 2022-03-08 Hancock Maine 23009 7138 77
2282701 2282701 2022-03-07 Hancock Maine 23009 7088 77
2279448 2279448 2022-03-06 Hancock Maine 23009 7088 77
2276195 2276195 2022-03-05 Hancock Maine 23009 7088 77
2272942 2272942 2022-03-04 Hancock Maine 23009 7083 77
2269690 2269690 2022-03-03 Hancock Maine 23009 7029 76
2266437 2266437 2022-03-02 Hancock Maine 23009 6996 76
2263186 2263186 2022-03-01 Hancock Maine 23009 6952 76
2259935 2259935 2022-02-28 Hancock Maine 23009 6932 76
2256684 2256684 2022-02-27 Hancock Maine 23009 6931 76
2253433 2253433 2022-02-26 Hancock Maine 23009 6930 76
2250182 2250182 2022-02-25 Hancock Maine 23009 6915 76
2246931 2246931 2022-02-24 Hancock Maine 23009 6885 76
2243680 2243680 2022-02-23 Hancock Maine 23009 6832 76
2240429 2240429 2022-02-22 Hancock Maine 23009 6780 76
2237178 2237178 2022-02-21 Hancock Maine 23009 6519 76
2233927 2233927 2022-02-20 Hancock Maine 23009 6519 76
2230676 2230676 2022-02-19 Hancock Maine 23009 6440 76
2227425 2227425 2022-02-18 Hancock Maine 23009 6295 76
2224174 2224174 2022-02-17 Hancock Maine 23009 6175 75
2220923 2220923 2022-02-16 Hancock Maine 23009 6048 73
2217672 2217672 2022-02-15 Hancock Maine 23009 5903 73
2214421 2214421 2022-02-14 Hancock Maine 23009 5446 73
2211169 2211169 2022-02-13 Hancock Maine 23009 5446 73
2207916 2207916 2022-02-12 Hancock Maine 23009 5446 73
2204663 2204663 2022-02-11 Hancock Maine 23009 5408 72
2201410 2201410 2022-02-10 Hancock Maine 23009 5395 72
2198156 2198156 2022-02-09 Hancock Maine 23009 5374 72
2194902 2194902 2022-02-08 Hancock Maine 23009 5320 72
2191648 2191648 2022-02-07 Hancock Maine 23009 5296 72
2188395 2188395 2022-02-06 Hancock Maine 23009 5296 72
2185142 2185142 2022-02-05 Hancock Maine 23009 5296 72
2181890 2181890 2022-02-04 Hancock Maine 23009 5282 72
2178639 2178639 2022-02-03 Hancock Maine 23009 5206 71

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