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

784 rows where county = "Lincoln" and state = "Mississippi" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Mississippi · 784 ✖

fips 1

county 1

  • Lincoln · 784 ✖
Link rowid date ▲ county state fips cases deaths
2501035 2501035 2022-05-13 Lincoln Mississippi 28085 8324 157
2497777 2497777 2022-05-12 Lincoln Mississippi 28085 8324 157
2494519 2494519 2022-05-11 Lincoln Mississippi 28085 8324 157
2491261 2491261 2022-05-10 Lincoln Mississippi 28085 8324 157
2488004 2488004 2022-05-09 Lincoln Mississippi 28085 8324 157
2484746 2484746 2022-05-08 Lincoln Mississippi 28085 8318 157
2481488 2481488 2022-05-07 Lincoln Mississippi 28085 8318 157
2478230 2478230 2022-05-06 Lincoln Mississippi 28085 8318 157
2474972 2474972 2022-05-05 Lincoln Mississippi 28085 8318 157
2471715 2471715 2022-05-04 Lincoln Mississippi 28085 8318 157
2468459 2468459 2022-05-03 Lincoln Mississippi 28085 8318 157
2465204 2465204 2022-05-02 Lincoln Mississippi 28085 8318 157
2461948 2461948 2022-05-01 Lincoln Mississippi 28085 8315 157
2458692 2458692 2022-04-30 Lincoln Mississippi 28085 8315 157
2455436 2455436 2022-04-29 Lincoln Mississippi 28085 8315 157
2452180 2452180 2022-04-28 Lincoln Mississippi 28085 8315 157
2448924 2448924 2022-04-27 Lincoln Mississippi 28085 8315 157
2445668 2445668 2022-04-26 Lincoln Mississippi 28085 8315 157
2442412 2442412 2022-04-25 Lincoln Mississippi 28085 8310 157
2439156 2439156 2022-04-24 Lincoln Mississippi 28085 8310 157
2435900 2435900 2022-04-23 Lincoln Mississippi 28085 8310 157
2432644 2432644 2022-04-22 Lincoln Mississippi 28085 8310 157
2429388 2429388 2022-04-21 Lincoln Mississippi 28085 8310 157
2426132 2426132 2022-04-20 Lincoln Mississippi 28085 8310 157
2422876 2422876 2022-04-19 Lincoln Mississippi 28085 8310 157
2419620 2419620 2022-04-18 Lincoln Mississippi 28085 8310 157
2416364 2416364 2022-04-17 Lincoln Mississippi 28085 8308 156
2413108 2413108 2022-04-16 Lincoln Mississippi 28085 8308 156
2409852 2409852 2022-04-15 Lincoln Mississippi 28085 8308 156
2406596 2406596 2022-04-14 Lincoln Mississippi 28085 8308 156
2403340 2403340 2022-04-13 Lincoln Mississippi 28085 8308 156
2400086 2400086 2022-04-12 Lincoln Mississippi 28085 8308 156
2396830 2396830 2022-04-11 Lincoln Mississippi 28085 8304 156
2393575 2393575 2022-04-10 Lincoln Mississippi 28085 8304 156
2390319 2390319 2022-04-09 Lincoln Mississippi 28085 8304 156
2387063 2387063 2022-04-08 Lincoln Mississippi 28085 8304 156
2383808 2383808 2022-04-07 Lincoln Mississippi 28085 8304 156
2380553 2380553 2022-04-06 Lincoln Mississippi 28085 8304 156
2377298 2377298 2022-04-05 Lincoln Mississippi 28085 8304 156
2374046 2374046 2022-04-04 Lincoln Mississippi 28085 8304 156
2370793 2370793 2022-04-03 Lincoln Mississippi 28085 8301 156
2367540 2367540 2022-04-02 Lincoln Mississippi 28085 8301 156
2364287 2364287 2022-04-01 Lincoln Mississippi 28085 8301 156
2361033 2361033 2022-03-31 Lincoln Mississippi 28085 8301 156
2357779 2357779 2022-03-30 Lincoln Mississippi 28085 8301 156
2354526 2354526 2022-03-29 Lincoln Mississippi 28085 8301 156
2351274 2351274 2022-03-28 Lincoln Mississippi 28085 8301 156
2348021 2348021 2022-03-27 Lincoln Mississippi 28085 8291 156
2344768 2344768 2022-03-26 Lincoln Mississippi 28085 8291 156
2341515 2341515 2022-03-25 Lincoln Mississippi 28085 8291 156
2338262 2338262 2022-03-24 Lincoln Mississippi 28085 8291 156
2335008 2335008 2022-03-23 Lincoln Mississippi 28085 8291 156
2331754 2331754 2022-03-22 Lincoln Mississippi 28085 8291 156
2328502 2328502 2022-03-21 Lincoln Mississippi 28085 8291 156
2325249 2325249 2022-03-20 Lincoln Mississippi 28085 8283 156
2321995 2321995 2022-03-19 Lincoln Mississippi 28085 8283 156
2318741 2318741 2022-03-18 Lincoln Mississippi 28085 8283 156
2315488 2315488 2022-03-17 Lincoln Mississippi 28085 8283 156
2312235 2312235 2022-03-16 Lincoln Mississippi 28085 8283 156
2308982 2308982 2022-03-15 Lincoln Mississippi 28085 8283 156
2305731 2305731 2022-03-14 Lincoln Mississippi 28085 8283 156
2302479 2302479 2022-03-13 Lincoln Mississippi 28085 8269 156
2299227 2299227 2022-03-12 Lincoln Mississippi 28085 8269 156
2295975 2295975 2022-03-11 Lincoln Mississippi 28085 8269 156
2292723 2292723 2022-03-10 Lincoln Mississippi 28085 8269 156
2289471 2289471 2022-03-09 Lincoln Mississippi 28085 8269 156
2286220 2286220 2022-03-08 Lincoln Mississippi 28085 8269 156
2282968 2282968 2022-03-07 Lincoln Mississippi 28085 8268 156
2279715 2279715 2022-03-06 Lincoln Mississippi 28085 8255 156
2276462 2276462 2022-03-05 Lincoln Mississippi 28085 8255 156
2273209 2273209 2022-03-04 Lincoln Mississippi 28085 8255 156
2269957 2269957 2022-03-03 Lincoln Mississippi 28085 8249 155
2266704 2266704 2022-03-02 Lincoln Mississippi 28085 8247 155
2263453 2263453 2022-03-01 Lincoln Mississippi 28085 8245 155
2260202 2260202 2022-02-28 Lincoln Mississippi 28085 8242 155
2256951 2256951 2022-02-27 Lincoln Mississippi 28085 8235 155
2253700 2253700 2022-02-26 Lincoln Mississippi 28085 8235 155
2250449 2250449 2022-02-25 Lincoln Mississippi 28085 8235 155
2247198 2247198 2022-02-24 Lincoln Mississippi 28085 8231 155
2243947 2243947 2022-02-23 Lincoln Mississippi 28085 8229 155
2240696 2240696 2022-02-22 Lincoln Mississippi 28085 8218 154
2237445 2237445 2022-02-21 Lincoln Mississippi 28085 8203 154
2234194 2234194 2022-02-20 Lincoln Mississippi 28085 8203 154
2230943 2230943 2022-02-19 Lincoln Mississippi 28085 8203 154
2227692 2227692 2022-02-18 Lincoln Mississippi 28085 8203 154
2224441 2224441 2022-02-17 Lincoln Mississippi 28085 8195 154
2221190 2221190 2022-02-16 Lincoln Mississippi 28085 8183 154
2217939 2217939 2022-02-15 Lincoln Mississippi 28085 8164 154
2214688 2214688 2022-02-14 Lincoln Mississippi 28085 8155 153
2211436 2211436 2022-02-13 Lincoln Mississippi 28085 8108 153
2208183 2208183 2022-02-12 Lincoln Mississippi 28085 8108 153
2204930 2204930 2022-02-11 Lincoln Mississippi 28085 8108 153
2201677 2201677 2022-02-10 Lincoln Mississippi 28085 8087 153
2198423 2198423 2022-02-09 Lincoln Mississippi 28085 8059 152
2195169 2195169 2022-02-08 Lincoln Mississippi 28085 8036 150
2191915 2191915 2022-02-07 Lincoln Mississippi 28085 8018 150
2188662 2188662 2022-02-06 Lincoln Mississippi 28085 7711 147
2185409 2185409 2022-02-05 Lincoln Mississippi 28085 7711 147
2182157 2182157 2022-02-04 Lincoln Mississippi 28085 7711 147
2178905 2178905 2022-02-03 Lincoln Mississippi 28085 7615 146

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