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

782 rows where county = "Lincoln" and fips = 22061 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

  • 22061 · 782 ✖

county 1

  • Lincoln · 782 ✖
Link rowid date ▲ county state fips cases deaths
2500729 2500729 2022-05-13 Lincoln Louisiana 22061 12269 144
2497471 2497471 2022-05-12 Lincoln Louisiana 22061 12266 144
2494213 2494213 2022-05-11 Lincoln Louisiana 22061 12264 144
2490955 2490955 2022-05-10 Lincoln Louisiana 22061 12259 144
2487698 2487698 2022-05-09 Lincoln Louisiana 22061 12253 144
2484440 2484440 2022-05-08 Lincoln Louisiana 22061 12252 144
2481182 2481182 2022-05-07 Lincoln Louisiana 22061 12252 144
2477924 2477924 2022-05-06 Lincoln Louisiana 22061 12252 144
2474666 2474666 2022-05-05 Lincoln Louisiana 22061 12249 144
2471409 2471409 2022-05-04 Lincoln Louisiana 22061 12245 144
2468153 2468153 2022-05-03 Lincoln Louisiana 22061 12245 144
2464898 2464898 2022-05-02 Lincoln Louisiana 22061 12237 145
2461642 2461642 2022-05-01 Lincoln Louisiana 22061 12236 145
2458386 2458386 2022-04-30 Lincoln Louisiana 22061 12236 145
2455130 2455130 2022-04-29 Lincoln Louisiana 22061 12236 145
2451874 2451874 2022-04-28 Lincoln Louisiana 22061 12231 145
2448618 2448618 2022-04-27 Lincoln Louisiana 22061 12229 145
2445362 2445362 2022-04-26 Lincoln Louisiana 22061 12229 145
2442106 2442106 2022-04-25 Lincoln Louisiana 22061 12222 145
2438850 2438850 2022-04-24 Lincoln Louisiana 22061 12220 145
2435594 2435594 2022-04-23 Lincoln Louisiana 22061 12220 145
2432338 2432338 2022-04-22 Lincoln Louisiana 22061 12220 145
2429082 2429082 2022-04-21 Lincoln Louisiana 22061 12219 145
2425826 2425826 2022-04-20 Lincoln Louisiana 22061 12219 145
2422570 2422570 2022-04-19 Lincoln Louisiana 22061 12219 145
2419314 2419314 2022-04-18 Lincoln Louisiana 22061 12216 144
2416058 2416058 2022-04-17 Lincoln Louisiana 22061 12214 144
2412802 2412802 2022-04-16 Lincoln Louisiana 22061 12214 144
2409546 2409546 2022-04-15 Lincoln Louisiana 22061 12214 144
2406290 2406290 2022-04-14 Lincoln Louisiana 22061 12214 144
2403034 2403034 2022-04-13 Lincoln Louisiana 22061 12212 144
2399780 2399780 2022-04-12 Lincoln Louisiana 22061 12209 144
2396524 2396524 2022-04-11 Lincoln Louisiana 22061 12209 144
2393269 2393269 2022-04-10 Lincoln Louisiana 22061 12209 144
2390013 2390013 2022-04-09 Lincoln Louisiana 22061 12209 144
2386757 2386757 2022-04-08 Lincoln Louisiana 22061 12209 144
2383502 2383502 2022-04-07 Lincoln Louisiana 22061 12208 144
2380247 2380247 2022-04-06 Lincoln Louisiana 22061 12208 144
2376992 2376992 2022-04-05 Lincoln Louisiana 22061 12207 144
2373740 2373740 2022-04-04 Lincoln Louisiana 22061 12204 144
2370487 2370487 2022-04-03 Lincoln Louisiana 22061 12204 144
2367234 2367234 2022-04-02 Lincoln Louisiana 22061 12204 144
2363981 2363981 2022-04-01 Lincoln Louisiana 22061 12204 144
2360727 2360727 2022-03-31 Lincoln Louisiana 22061 12204 144
2357473 2357473 2022-03-30 Lincoln Louisiana 22061 12201 144
2354220 2354220 2022-03-29 Lincoln Louisiana 22061 12198 144
2350968 2350968 2022-03-28 Lincoln Louisiana 22061 12198 143
2347715 2347715 2022-03-27 Lincoln Louisiana 22061 12198 143
2344462 2344462 2022-03-26 Lincoln Louisiana 22061 12198 143
2341209 2341209 2022-03-25 Lincoln Louisiana 22061 12198 143
2337956 2337956 2022-03-24 Lincoln Louisiana 22061 12198 143
2334702 2334702 2022-03-23 Lincoln Louisiana 22061 12198 143
2331448 2331448 2022-03-22 Lincoln Louisiana 22061 12198 143
2328196 2328196 2022-03-21 Lincoln Louisiana 22061 12198 142
2324943 2324943 2022-03-20 Lincoln Louisiana 22061 12197 142
2321689 2321689 2022-03-19 Lincoln Louisiana 22061 12197 142
2318435 2318435 2022-03-18 Lincoln Louisiana 22061 12197 142
2315182 2315182 2022-03-17 Lincoln Louisiana 22061 12197 141
2311929 2311929 2022-03-16 Lincoln Louisiana 22061 12196 140
2308676 2308676 2022-03-15 Lincoln Louisiana 22061 12194 139
2305425 2305425 2022-03-14 Lincoln Louisiana 22061 12190 138
2302173 2302173 2022-03-13 Lincoln Louisiana 22061 12187 138
2298921 2298921 2022-03-12 Lincoln Louisiana 22061 12187 138
2295669 2295669 2022-03-11 Lincoln Louisiana 22061 12187 138
2292417 2292417 2022-03-10 Lincoln Louisiana 22061 12186 137
2289165 2289165 2022-03-09 Lincoln Louisiana 22061 12185 137
2285914 2285914 2022-03-08 Lincoln Louisiana 22061 12184 137
2282662 2282662 2022-03-07 Lincoln Louisiana 22061 12172 137
2279409 2279409 2022-03-06 Lincoln Louisiana 22061 12170 137
2276156 2276156 2022-03-05 Lincoln Louisiana 22061 12170 137
2272903 2272903 2022-03-04 Lincoln Louisiana 22061 12170 137
2269651 2269651 2022-03-03 Lincoln Louisiana 22061 12168 135
2266398 2266398 2022-03-02 Lincoln Louisiana 22061 12157 133
2263147 2263147 2022-03-01 Lincoln Louisiana 22061 12141 133
2259896 2259896 2022-02-28 Lincoln Louisiana 22061 12141 133
2256645 2256645 2022-02-27 Lincoln Louisiana 22061 12141 133
2253394 2253394 2022-02-26 Lincoln Louisiana 22061 12141 133
2250143 2250143 2022-02-25 Lincoln Louisiana 22061 12141 133
2246892 2246892 2022-02-24 Lincoln Louisiana 22061 12138 131
2243641 2243641 2022-02-23 Lincoln Louisiana 22061 12130 131
2240390 2240390 2022-02-22 Lincoln Louisiana 22061 12114 131
2237139 2237139 2022-02-21 Lincoln Louisiana 22061 12096 131
2233888 2233888 2022-02-20 Lincoln Louisiana 22061 12061 131
2230637 2230637 2022-02-19 Lincoln Louisiana 22061 12061 131
2227386 2227386 2022-02-18 Lincoln Louisiana 22061 12061 131
2224135 2224135 2022-02-17 Lincoln Louisiana 22061 12043 131
2220884 2220884 2022-02-16 Lincoln Louisiana 22061 12026 131
2217633 2217633 2022-02-15 Lincoln Louisiana 22061 12015 130
2214382 2214382 2022-02-14 Lincoln Louisiana 22061 11983 130
2211130 2211130 2022-02-13 Lincoln Louisiana 22061 11940 129
2207877 2207877 2022-02-12 Lincoln Louisiana 22061 11940 129
2204624 2204624 2022-02-11 Lincoln Louisiana 22061 11940 129
2201371 2201371 2022-02-10 Lincoln Louisiana 22061 11912 129
2198117 2198117 2022-02-09 Lincoln Louisiana 22061 11875 129
2194863 2194863 2022-02-08 Lincoln Louisiana 22061 11842 127
2191609 2191609 2022-02-07 Lincoln Louisiana 22061 11775 127
2188356 2188356 2022-02-06 Lincoln Louisiana 22061 11712 127
2185103 2185103 2022-02-05 Lincoln Louisiana 22061 11712 127
2181851 2181851 2022-02-04 Lincoln Louisiana 22061 11712 127
2178600 2178600 2022-02-03 Lincoln Louisiana 22061 11684 126

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