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

790 rows where county = "Lincoln" and fips = 23015 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 23015 · 790 ✖

county 1

  • Lincoln · 790 ✖
Link rowid date ▲ county state fips cases deaths
2500771 2500771 2022-05-13 Lincoln Maine 23015 5578 35
2497513 2497513 2022-05-12 Lincoln Maine 23015 5566 35
2494255 2494255 2022-05-11 Lincoln Maine 23015 5551 35
2490997 2490997 2022-05-10 Lincoln Maine 23015 5538 35
2487740 2487740 2022-05-09 Lincoln Maine 23015 5522 35
2484482 2484482 2022-05-08 Lincoln Maine 23015 5517 35
2481224 2481224 2022-05-07 Lincoln Maine 23015 5517 35
2477966 2477966 2022-05-06 Lincoln Maine 23015 5503 35
2474708 2474708 2022-05-05 Lincoln Maine 23015 5480 35
2471451 2471451 2022-05-04 Lincoln Maine 23015 5464 35
2468195 2468195 2022-05-03 Lincoln Maine 23015 5445 35
2464940 2464940 2022-05-02 Lincoln Maine 23015 5411 35
2461684 2461684 2022-05-01 Lincoln Maine 23015 5397 35
2458428 2458428 2022-04-30 Lincoln Maine 23015 5397 35
2455172 2455172 2022-04-29 Lincoln Maine 23015 5368 35
2451916 2451916 2022-04-28 Lincoln Maine 23015 5366 35
2448660 2448660 2022-04-27 Lincoln Maine 23015 5357 35
2445404 2445404 2022-04-26 Lincoln Maine 23015 5340 35
2442148 2442148 2022-04-25 Lincoln Maine 23015 5335 35
2438892 2438892 2022-04-24 Lincoln Maine 23015 5335 35
2435636 2435636 2022-04-23 Lincoln Maine 23015 5335 35
2432380 2432380 2022-04-22 Lincoln Maine 23015 5317 35
2429124 2429124 2022-04-21 Lincoln Maine 23015 5283 35
2425868 2425868 2022-04-20 Lincoln Maine 23015 5274 35
2422612 2422612 2022-04-19 Lincoln Maine 23015 5239 35
2419356 2419356 2022-04-18 Lincoln Maine 23015 5239 35
2416100 2416100 2022-04-17 Lincoln Maine 23015 5239 35
2412844 2412844 2022-04-16 Lincoln Maine 23015 5239 35
2409588 2409588 2022-04-15 Lincoln Maine 23015 5230 35
2406332 2406332 2022-04-14 Lincoln Maine 23015 5218 35
2403076 2403076 2022-04-13 Lincoln Maine 23015 5210 35
2399822 2399822 2022-04-12 Lincoln Maine 23015 5203 35
2396566 2396566 2022-04-11 Lincoln Maine 23015 5194 33
2393311 2393311 2022-04-10 Lincoln Maine 23015 5194 33
2390055 2390055 2022-04-09 Lincoln Maine 23015 5194 33
2386799 2386799 2022-04-08 Lincoln Maine 23015 5189 33
2383544 2383544 2022-04-07 Lincoln Maine 23015 5185 33
2380289 2380289 2022-04-06 Lincoln Maine 23015 5181 32
2377034 2377034 2022-04-05 Lincoln Maine 23015 5171 32
2373782 2373782 2022-04-04 Lincoln Maine 23015 5164 32
2370529 2370529 2022-04-03 Lincoln Maine 23015 5164 32
2367276 2367276 2022-04-02 Lincoln Maine 23015 5164 32
2364023 2364023 2022-04-01 Lincoln Maine 23015 5164 32
2360769 2360769 2022-03-31 Lincoln Maine 23015 5158 32
2357515 2357515 2022-03-30 Lincoln Maine 23015 5149 32
2354262 2354262 2022-03-29 Lincoln Maine 23015 5144 32
2351010 2351010 2022-03-28 Lincoln Maine 23015 5135 32
2347757 2347757 2022-03-27 Lincoln Maine 23015 5135 32
2344504 2344504 2022-03-26 Lincoln Maine 23015 5135 32
2341251 2341251 2022-03-25 Lincoln Maine 23015 5130 32
2337998 2337998 2022-03-24 Lincoln Maine 23015 5127 32
2334744 2334744 2022-03-23 Lincoln Maine 23015 5124 32
2331490 2331490 2022-03-22 Lincoln Maine 23015 5118 32
2328238 2328238 2022-03-21 Lincoln Maine 23015 5110 32
2324985 2324985 2022-03-20 Lincoln Maine 23015 5110 32
2321731 2321731 2022-03-19 Lincoln Maine 23015 5110 32
2318477 2318477 2022-03-18 Lincoln Maine 23015 5111 32
2315224 2315224 2022-03-17 Lincoln Maine 23015 5108 32
2311971 2311971 2022-03-16 Lincoln Maine 23015 5100 32
2308718 2308718 2022-03-15 Lincoln Maine 23015 5089 30
2305467 2305467 2022-03-14 Lincoln Maine 23015 5080 30
2302215 2302215 2022-03-13 Lincoln Maine 23015 5080 30
2298963 2298963 2022-03-12 Lincoln Maine 23015 5080 30
2295711 2295711 2022-03-11 Lincoln Maine 23015 5074 30
2292459 2292459 2022-03-10 Lincoln Maine 23015 5071 31
2289207 2289207 2022-03-09 Lincoln Maine 23015 5053 31
2285956 2285956 2022-03-08 Lincoln Maine 23015 5040 31
2282704 2282704 2022-03-07 Lincoln Maine 23015 5031 31
2279451 2279451 2022-03-06 Lincoln Maine 23015 5031 31
2276198 2276198 2022-03-05 Lincoln Maine 23015 5031 31
2272945 2272945 2022-03-04 Lincoln Maine 23015 5012 30
2269693 2269693 2022-03-03 Lincoln Maine 23015 4979 29
2266440 2266440 2022-03-02 Lincoln Maine 23015 4975 29
2263189 2263189 2022-03-01 Lincoln Maine 23015 4964 29
2259938 2259938 2022-02-28 Lincoln Maine 23015 4930 29
2256687 2256687 2022-02-27 Lincoln Maine 23015 4930 29
2253436 2253436 2022-02-26 Lincoln Maine 23015 4929 29
2250185 2250185 2022-02-25 Lincoln Maine 23015 4919 29
2246934 2246934 2022-02-24 Lincoln Maine 23015 4906 28
2243683 2243683 2022-02-23 Lincoln Maine 23015 4893 27
2240432 2240432 2022-02-22 Lincoln Maine 23015 4871 26
2237181 2237181 2022-02-21 Lincoln Maine 23015 4859 26
2233930 2233930 2022-02-20 Lincoln Maine 23015 4859 26
2230679 2230679 2022-02-19 Lincoln Maine 23015 4773 26
2227428 2227428 2022-02-18 Lincoln Maine 23015 4639 25
2224177 2224177 2022-02-17 Lincoln Maine 23015 4532 24
2220926 2220926 2022-02-16 Lincoln Maine 23015 4412 23
2217675 2217675 2022-02-15 Lincoln Maine 23015 4317 23
2214424 2214424 2022-02-14 Lincoln Maine 23015 4011 21
2211172 2211172 2022-02-13 Lincoln Maine 23015 4011 21
2207919 2207919 2022-02-12 Lincoln Maine 23015 4011 21
2204666 2204666 2022-02-11 Lincoln Maine 23015 3963 21
2201413 2201413 2022-02-10 Lincoln Maine 23015 3924 21
2198159 2198159 2022-02-09 Lincoln Maine 23015 3872 21
2194905 2194905 2022-02-08 Lincoln Maine 23015 3854 21
2191651 2191651 2022-02-07 Lincoln Maine 23015 3815 21
2188398 2188398 2022-02-06 Lincoln Maine 23015 3815 21
2185145 2185145 2022-02-05 Lincoln Maine 23015 3815 21
2181893 2181893 2022-02-04 Lincoln Maine 23015 3795 21
2178642 2178642 2022-02-03 Lincoln Maine 23015 3771 20

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