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

781 rows where fips = 23027 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 · 781 ✖

fips 1

  • 23027 · 781 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500778 2500778 2022-05-13 Waldo Maine 23027 6467 58
2497520 2497520 2022-05-12 Waldo Maine 23027 6447 58
2494262 2494262 2022-05-11 Waldo Maine 23027 6420 58
2491004 2491004 2022-05-10 Waldo Maine 23027 6399 57
2487747 2487747 2022-05-09 Waldo Maine 23027 6381 57
2484489 2484489 2022-05-08 Waldo Maine 23027 6368 57
2481231 2481231 2022-05-07 Waldo Maine 23027 6368 57
2477973 2477973 2022-05-06 Waldo Maine 23027 6353 57
2474715 2474715 2022-05-05 Waldo Maine 23027 6331 57
2471458 2471458 2022-05-04 Waldo Maine 23027 6312 57
2468202 2468202 2022-05-03 Waldo Maine 23027 6287 57
2464947 2464947 2022-05-02 Waldo Maine 23027 6240 57
2461691 2461691 2022-05-01 Waldo Maine 23027 6221 57
2458435 2458435 2022-04-30 Waldo Maine 23027 6221 57
2455179 2455179 2022-04-29 Waldo Maine 23027 6194 57
2451923 2451923 2022-04-28 Waldo Maine 23027 6193 57
2448667 2448667 2022-04-27 Waldo Maine 23027 6189 57
2445411 2445411 2022-04-26 Waldo Maine 23027 6181 57
2442155 2442155 2022-04-25 Waldo Maine 23027 6171 57
2438899 2438899 2022-04-24 Waldo Maine 23027 6171 57
2435643 2435643 2022-04-23 Waldo Maine 23027 6171 57
2432387 2432387 2022-04-22 Waldo Maine 23027 6159 57
2429131 2429131 2022-04-21 Waldo Maine 23027 6132 57
2425875 2425875 2022-04-20 Waldo Maine 23027 6119 57
2422619 2422619 2022-04-19 Waldo Maine 23027 6090 57
2419363 2419363 2022-04-18 Waldo Maine 23027 6090 57
2416107 2416107 2022-04-17 Waldo Maine 23027 6090 57
2412851 2412851 2022-04-16 Waldo Maine 23027 6090 57
2409595 2409595 2022-04-15 Waldo Maine 23027 6084 57
2406339 2406339 2022-04-14 Waldo Maine 23027 6074 57
2403083 2403083 2022-04-13 Waldo Maine 23027 6065 57
2399829 2399829 2022-04-12 Waldo Maine 23027 6045 57
2396573 2396573 2022-04-11 Waldo Maine 23027 6042 57
2393318 2393318 2022-04-10 Waldo Maine 23027 6042 57
2390062 2390062 2022-04-09 Waldo Maine 23027 6042 57
2386806 2386806 2022-04-08 Waldo Maine 23027 6038 57
2383551 2383551 2022-04-07 Waldo Maine 23027 6030 57
2380296 2380296 2022-04-06 Waldo Maine 23027 6026 57
2377041 2377041 2022-04-05 Waldo Maine 23027 6021 57
2373789 2373789 2022-04-04 Waldo Maine 23027 6012 57
2370536 2370536 2022-04-03 Waldo Maine 23027 6012 57
2367283 2367283 2022-04-02 Waldo Maine 23027 6012 57
2364030 2364030 2022-04-01 Waldo Maine 23027 6007 57
2360776 2360776 2022-03-31 Waldo Maine 23027 6003 57
2357522 2357522 2022-03-30 Waldo Maine 23027 5999 57
2354269 2354269 2022-03-29 Waldo Maine 23027 5989 57
2351017 2351017 2022-03-28 Waldo Maine 23027 5979 56
2347764 2347764 2022-03-27 Waldo Maine 23027 5979 56
2344511 2344511 2022-03-26 Waldo Maine 23027 5979 56
2341258 2341258 2022-03-25 Waldo Maine 23027 5977 56
2338005 2338005 2022-03-24 Waldo Maine 23027 5970 56
2334751 2334751 2022-03-23 Waldo Maine 23027 5964 56
2331497 2331497 2022-03-22 Waldo Maine 23027 5951 56
2328245 2328245 2022-03-21 Waldo Maine 23027 5939 56
2324992 2324992 2022-03-20 Waldo Maine 23027 5939 56
2321738 2321738 2022-03-19 Waldo Maine 23027 5939 56
2318484 2318484 2022-03-18 Waldo Maine 23027 5932 56
2315231 2315231 2022-03-17 Waldo Maine 23027 5925 56
2311978 2311978 2022-03-16 Waldo Maine 23027 5920 55
2308725 2308725 2022-03-15 Waldo Maine 23027 5917 55
2305474 2305474 2022-03-14 Waldo Maine 23027 5909 55
2302222 2302222 2022-03-13 Waldo Maine 23027 5909 55
2298970 2298970 2022-03-12 Waldo Maine 23027 5909 55
2295718 2295718 2022-03-11 Waldo Maine 23027 5902 55
2292466 2292466 2022-03-10 Waldo Maine 23027 5901 55
2289214 2289214 2022-03-09 Waldo Maine 23027 5889 55
2285963 2285963 2022-03-08 Waldo Maine 23027 5888 55
2282711 2282711 2022-03-07 Waldo Maine 23027 5877 55
2279458 2279458 2022-03-06 Waldo Maine 23027 5877 55
2276205 2276205 2022-03-05 Waldo Maine 23027 5877 55
2272952 2272952 2022-03-04 Waldo Maine 23027 5867 53
2269700 2269700 2022-03-03 Waldo Maine 23027 5828 52
2266447 2266447 2022-03-02 Waldo Maine 23027 5826 52
2263196 2263196 2022-03-01 Waldo Maine 23027 5797 52
2259945 2259945 2022-02-28 Waldo Maine 23027 5772 52
2256694 2256694 2022-02-27 Waldo Maine 23027 5772 52
2253443 2253443 2022-02-26 Waldo Maine 23027 5772 52
2250192 2250192 2022-02-25 Waldo Maine 23027 5752 52
2246941 2246941 2022-02-24 Waldo Maine 23027 5742 52
2243690 2243690 2022-02-23 Waldo Maine 23027 5725 52
2240439 2240439 2022-02-22 Waldo Maine 23027 5696 52
2237188 2237188 2022-02-21 Waldo Maine 23027 5676 52
2233937 2233937 2022-02-20 Waldo Maine 23027 5646 52
2230686 2230686 2022-02-19 Waldo Maine 23027 5428 52
2227435 2227435 2022-02-18 Waldo Maine 23027 5364 52
2224184 2224184 2022-02-17 Waldo Maine 23027 5218 52
2220933 2220933 2022-02-16 Waldo Maine 23027 5094 52
2217682 2217682 2022-02-15 Waldo Maine 23027 4970 52
2214431 2214431 2022-02-14 Waldo Maine 23027 4652 52
2211179 2211179 2022-02-13 Waldo Maine 23027 4652 52
2207926 2207926 2022-02-12 Waldo Maine 23027 4652 52
2204673 2204673 2022-02-11 Waldo Maine 23027 4604 52
2201420 2201420 2022-02-10 Waldo Maine 23027 4575 52
2198166 2198166 2022-02-09 Waldo Maine 23027 4537 52
2194912 2194912 2022-02-08 Waldo Maine 23027 4510 52
2191658 2191658 2022-02-07 Waldo Maine 23027 4473 51
2188405 2188405 2022-02-06 Waldo Maine 23027 4473 51
2185152 2185152 2022-02-05 Waldo Maine 23027 4473 51
2181900 2181900 2022-02-04 Waldo Maine 23027 4427 51
2178648 2178648 2022-02-03 Waldo Maine 23027 4415 50

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