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

788 rows where fips = 23017 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 · 788 ✖

fips 1

  • 23017 · 788 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500772 2500772 2022-05-13 Oxford Maine 23017 11799 148
2497514 2497514 2022-05-12 Oxford Maine 23017 11773 148
2494256 2494256 2022-05-11 Oxford Maine 23017 11730 148
2490998 2490998 2022-05-10 Oxford Maine 23017 11711 148
2487741 2487741 2022-05-09 Oxford Maine 23017 11694 148
2484483 2484483 2022-05-08 Oxford Maine 23017 11687 148
2481225 2481225 2022-05-07 Oxford Maine 23017 11687 148
2477967 2477967 2022-05-06 Oxford Maine 23017 11660 146
2474709 2474709 2022-05-05 Oxford Maine 23017 11641 146
2471452 2471452 2022-05-04 Oxford Maine 23017 11611 146
2468196 2468196 2022-05-03 Oxford Maine 23017 11588 146
2464941 2464941 2022-05-02 Oxford Maine 23017 11558 146
2461685 2461685 2022-05-01 Oxford Maine 23017 11539 146
2458429 2458429 2022-04-30 Oxford Maine 23017 11539 146
2455173 2455173 2022-04-29 Oxford Maine 23017 11518 146
2451917 2451917 2022-04-28 Oxford Maine 23017 11511 145
2448661 2448661 2022-04-27 Oxford Maine 23017 11492 145
2445405 2445405 2022-04-26 Oxford Maine 23017 11470 145
2442149 2442149 2022-04-25 Oxford Maine 23017 11444 145
2438893 2438893 2022-04-24 Oxford Maine 23017 11444 145
2435637 2435637 2022-04-23 Oxford Maine 23017 11444 145
2432381 2432381 2022-04-22 Oxford Maine 23017 11435 145
2429125 2429125 2022-04-21 Oxford Maine 23017 11421 145
2425869 2425869 2022-04-20 Oxford Maine 23017 11411 145
2422613 2422613 2022-04-19 Oxford Maine 23017 11388 145
2419357 2419357 2022-04-18 Oxford Maine 23017 11388 145
2416101 2416101 2022-04-17 Oxford Maine 23017 11388 145
2412845 2412845 2022-04-16 Oxford Maine 23017 11388 145
2409589 2409589 2022-04-15 Oxford Maine 23017 11361 145
2406333 2406333 2022-04-14 Oxford Maine 23017 11345 145
2403077 2403077 2022-04-13 Oxford Maine 23017 11326 145
2399823 2399823 2022-04-12 Oxford Maine 23017 11310 144
2396567 2396567 2022-04-11 Oxford Maine 23017 11294 144
2393312 2393312 2022-04-10 Oxford Maine 23017 11294 144
2390056 2390056 2022-04-09 Oxford Maine 23017 11294 144
2386800 2386800 2022-04-08 Oxford Maine 23017 11280 143
2383545 2383545 2022-04-07 Oxford Maine 23017 11264 143
2380290 2380290 2022-04-06 Oxford Maine 23017 11254 142
2377035 2377035 2022-04-05 Oxford Maine 23017 11250 142
2373783 2373783 2022-04-04 Oxford Maine 23017 11242 143
2370530 2370530 2022-04-03 Oxford Maine 23017 11242 143
2367277 2367277 2022-04-02 Oxford Maine 23017 11242 143
2364024 2364024 2022-04-01 Oxford Maine 23017 11236 143
2360770 2360770 2022-03-31 Oxford Maine 23017 11226 143
2357516 2357516 2022-03-30 Oxford Maine 23017 11211 143
2354263 2354263 2022-03-29 Oxford Maine 23017 11186 143
2351011 2351011 2022-03-28 Oxford Maine 23017 11159 143
2347758 2347758 2022-03-27 Oxford Maine 23017 11159 143
2344505 2344505 2022-03-26 Oxford Maine 23017 11159 143
2341252 2341252 2022-03-25 Oxford Maine 23017 11155 143
2337999 2337999 2022-03-24 Oxford Maine 23017 11146 143
2334745 2334745 2022-03-23 Oxford Maine 23017 11125 143
2331491 2331491 2022-03-22 Oxford Maine 23017 11118 143
2328239 2328239 2022-03-21 Oxford Maine 23017 11098 143
2324986 2324986 2022-03-20 Oxford Maine 23017 11098 143
2321732 2321732 2022-03-19 Oxford Maine 23017 11098 143
2318478 2318478 2022-03-18 Oxford Maine 23017 11083 143
2315225 2315225 2022-03-17 Oxford Maine 23017 11066 143
2311972 2311972 2022-03-16 Oxford Maine 23017 11058 142
2308719 2308719 2022-03-15 Oxford Maine 23017 11027 140
2305468 2305468 2022-03-14 Oxford Maine 23017 11006 140
2302216 2302216 2022-03-13 Oxford Maine 23017 11006 140
2298964 2298964 2022-03-12 Oxford Maine 23017 11006 140
2295712 2295712 2022-03-11 Oxford Maine 23017 10990 140
2292460 2292460 2022-03-10 Oxford Maine 23017 10973 140
2289208 2289208 2022-03-09 Oxford Maine 23017 10959 140
2285957 2285957 2022-03-08 Oxford Maine 23017 10951 140
2282705 2282705 2022-03-07 Oxford Maine 23017 10918 139
2279452 2279452 2022-03-06 Oxford Maine 23017 10918 139
2276199 2276199 2022-03-05 Oxford Maine 23017 10918 139
2272946 2272946 2022-03-04 Oxford Maine 23017 10911 138
2269694 2269694 2022-03-03 Oxford Maine 23017 10868 138
2266441 2266441 2022-03-02 Oxford Maine 23017 10819 138
2263190 2263190 2022-03-01 Oxford Maine 23017 10774 137
2259939 2259939 2022-02-28 Oxford Maine 23017 10756 137
2256688 2256688 2022-02-27 Oxford Maine 23017 10755 137
2253437 2253437 2022-02-26 Oxford Maine 23017 10755 137
2250186 2250186 2022-02-25 Oxford Maine 23017 10732 134
2246935 2246935 2022-02-24 Oxford Maine 23017 10705 134
2243684 2243684 2022-02-23 Oxford Maine 23017 10689 131
2240433 2240433 2022-02-22 Oxford Maine 23017 10522 131
2237182 2237182 2022-02-21 Oxford Maine 23017 10509 131
2233931 2233931 2022-02-20 Oxford Maine 23017 10509 131
2230680 2230680 2022-02-19 Oxford Maine 23017 10239 131
2227429 2227429 2022-02-18 Oxford Maine 23017 9980 128
2224178 2224178 2022-02-17 Oxford Maine 23017 9770 126
2220927 2220927 2022-02-16 Oxford Maine 23017 9593 123
2217676 2217676 2022-02-15 Oxford Maine 23017 9481 123
2214425 2214425 2022-02-14 Oxford Maine 23017 9141 123
2211173 2211173 2022-02-13 Oxford Maine 23017 9141 123
2207920 2207920 2022-02-12 Oxford Maine 23017 9141 123
2204667 2204667 2022-02-11 Oxford Maine 23017 9047 122
2201414 2201414 2022-02-10 Oxford Maine 23017 8976 122
2198160 2198160 2022-02-09 Oxford Maine 23017 8942 122
2194906 2194906 2022-02-08 Oxford Maine 23017 8884 122
2191652 2191652 2022-02-07 Oxford Maine 23017 8849 121
2188399 2188399 2022-02-06 Oxford Maine 23017 8849 121
2185146 2185146 2022-02-05 Oxford Maine 23017 8849 121
2181894 2181894 2022-02-04 Oxford Maine 23017 8838 121
2178643 2178643 2022-02-03 Oxford Maine 23017 8817 118

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