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 = "Lowndes" and fips = 28087 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

  • 28087 · 784 ✖

county 1

  • Lowndes · 784 ✖
Link rowid date ▲ county state fips cases deaths
2501036 2501036 2022-05-13 Lowndes Mississippi 28087 17528 238
2497778 2497778 2022-05-12 Lowndes Mississippi 28087 17528 238
2494520 2494520 2022-05-11 Lowndes Mississippi 28087 17528 238
2491262 2491262 2022-05-10 Lowndes Mississippi 28087 17528 238
2488005 2488005 2022-05-09 Lowndes Mississippi 28087 17528 238
2484747 2484747 2022-05-08 Lowndes Mississippi 28087 17514 237
2481489 2481489 2022-05-07 Lowndes Mississippi 28087 17514 237
2478231 2478231 2022-05-06 Lowndes Mississippi 28087 17514 237
2474973 2474973 2022-05-05 Lowndes Mississippi 28087 17514 237
2471716 2471716 2022-05-04 Lowndes Mississippi 28087 17514 237
2468460 2468460 2022-05-03 Lowndes Mississippi 28087 17514 237
2465205 2465205 2022-05-02 Lowndes Mississippi 28087 17514 237
2461949 2461949 2022-05-01 Lowndes Mississippi 28087 17505 237
2458693 2458693 2022-04-30 Lowndes Mississippi 28087 17505 237
2455437 2455437 2022-04-29 Lowndes Mississippi 28087 17505 237
2452181 2452181 2022-04-28 Lowndes Mississippi 28087 17505 237
2448925 2448925 2022-04-27 Lowndes Mississippi 28087 17505 237
2445669 2445669 2022-04-26 Lowndes Mississippi 28087 17505 237
2442413 2442413 2022-04-25 Lowndes Mississippi 28087 17497 237
2439157 2439157 2022-04-24 Lowndes Mississippi 28087 17497 237
2435901 2435901 2022-04-23 Lowndes Mississippi 28087 17497 237
2432645 2432645 2022-04-22 Lowndes Mississippi 28087 17497 237
2429389 2429389 2022-04-21 Lowndes Mississippi 28087 17497 237
2426133 2426133 2022-04-20 Lowndes Mississippi 28087 17497 237
2422877 2422877 2022-04-19 Lowndes Mississippi 28087 17497 237
2419621 2419621 2022-04-18 Lowndes Mississippi 28087 17497 237
2416365 2416365 2022-04-17 Lowndes Mississippi 28087 17493 237
2413109 2413109 2022-04-16 Lowndes Mississippi 28087 17493 237
2409853 2409853 2022-04-15 Lowndes Mississippi 28087 17493 237
2406597 2406597 2022-04-14 Lowndes Mississippi 28087 17493 237
2403341 2403341 2022-04-13 Lowndes Mississippi 28087 17493 237
2400087 2400087 2022-04-12 Lowndes Mississippi 28087 17493 237
2396831 2396831 2022-04-11 Lowndes Mississippi 28087 17487 237
2393576 2393576 2022-04-10 Lowndes Mississippi 28087 17487 237
2390320 2390320 2022-04-09 Lowndes Mississippi 28087 17487 237
2387064 2387064 2022-04-08 Lowndes Mississippi 28087 17487 237
2383809 2383809 2022-04-07 Lowndes Mississippi 28087 17487 237
2380554 2380554 2022-04-06 Lowndes Mississippi 28087 17487 237
2377299 2377299 2022-04-05 Lowndes Mississippi 28087 17487 237
2374047 2374047 2022-04-04 Lowndes Mississippi 28087 17487 237
2370794 2370794 2022-04-03 Lowndes Mississippi 28087 17482 237
2367541 2367541 2022-04-02 Lowndes Mississippi 28087 17482 237
2364288 2364288 2022-04-01 Lowndes Mississippi 28087 17482 237
2361034 2361034 2022-03-31 Lowndes Mississippi 28087 17482 237
2357780 2357780 2022-03-30 Lowndes Mississippi 28087 17482 237
2354527 2354527 2022-03-29 Lowndes Mississippi 28087 17482 237
2351275 2351275 2022-03-28 Lowndes Mississippi 28087 17482 237
2348022 2348022 2022-03-27 Lowndes Mississippi 28087 17478 237
2344769 2344769 2022-03-26 Lowndes Mississippi 28087 17478 237
2341516 2341516 2022-03-25 Lowndes Mississippi 28087 17478 237
2338263 2338263 2022-03-24 Lowndes Mississippi 28087 17478 237
2335009 2335009 2022-03-23 Lowndes Mississippi 28087 17478 237
2331755 2331755 2022-03-22 Lowndes Mississippi 28087 17478 237
2328503 2328503 2022-03-21 Lowndes Mississippi 28087 17478 237
2325250 2325250 2022-03-20 Lowndes Mississippi 28087 17474 235
2321996 2321996 2022-03-19 Lowndes Mississippi 28087 17474 235
2318742 2318742 2022-03-18 Lowndes Mississippi 28087 17474 235
2315489 2315489 2022-03-17 Lowndes Mississippi 28087 17474 235
2312236 2312236 2022-03-16 Lowndes Mississippi 28087 17474 235
2308983 2308983 2022-03-15 Lowndes Mississippi 28087 17474 235
2305732 2305732 2022-03-14 Lowndes Mississippi 28087 17474 235
2302480 2302480 2022-03-13 Lowndes Mississippi 28087 17463 234
2299228 2299228 2022-03-12 Lowndes Mississippi 28087 17463 234
2295976 2295976 2022-03-11 Lowndes Mississippi 28087 17463 234
2292724 2292724 2022-03-10 Lowndes Mississippi 28087 17463 234
2289472 2289472 2022-03-09 Lowndes Mississippi 28087 17463 234
2286221 2286221 2022-03-08 Lowndes Mississippi 28087 17463 234
2282969 2282969 2022-03-07 Lowndes Mississippi 28087 17462 233
2279716 2279716 2022-03-06 Lowndes Mississippi 28087 17459 233
2276463 2276463 2022-03-05 Lowndes Mississippi 28087 17459 233
2273210 2273210 2022-03-04 Lowndes Mississippi 28087 17459 233
2269958 2269958 2022-03-03 Lowndes Mississippi 28087 17455 233
2266705 2266705 2022-03-02 Lowndes Mississippi 28087 17453 233
2263454 2263454 2022-03-01 Lowndes Mississippi 28087 17448 232
2260203 2260203 2022-02-28 Lowndes Mississippi 28087 17448 229
2256952 2256952 2022-02-27 Lowndes Mississippi 28087 17444 229
2253701 2253701 2022-02-26 Lowndes Mississippi 28087 17444 229
2250450 2250450 2022-02-25 Lowndes Mississippi 28087 17444 229
2247199 2247199 2022-02-24 Lowndes Mississippi 28087 17430 229
2243948 2243948 2022-02-23 Lowndes Mississippi 28087 17422 229
2240697 2240697 2022-02-22 Lowndes Mississippi 28087 17417 225
2237446 2237446 2022-02-21 Lowndes Mississippi 28087 17379 224
2234195 2234195 2022-02-20 Lowndes Mississippi 28087 17379 224
2230944 2230944 2022-02-19 Lowndes Mississippi 28087 17379 224
2227693 2227693 2022-02-18 Lowndes Mississippi 28087 17379 224
2224442 2224442 2022-02-17 Lowndes Mississippi 28087 17365 222
2221191 2221191 2022-02-16 Lowndes Mississippi 28087 17359 222
2217940 2217940 2022-02-15 Lowndes Mississippi 28087 17343 221
2214689 2214689 2022-02-14 Lowndes Mississippi 28087 17315 221
2211437 2211437 2022-02-13 Lowndes Mississippi 28087 17239 219
2208184 2208184 2022-02-12 Lowndes Mississippi 28087 17239 219
2204931 2204931 2022-02-11 Lowndes Mississippi 28087 17239 219
2201678 2201678 2022-02-10 Lowndes Mississippi 28087 17213 218
2198424 2198424 2022-02-09 Lowndes Mississippi 28087 17184 218
2195170 2195170 2022-02-08 Lowndes Mississippi 28087 17130 218
2191916 2191916 2022-02-07 Lowndes Mississippi 28087 17070 216
2188663 2188663 2022-02-06 Lowndes Mississippi 28087 16628 216
2185410 2185410 2022-02-05 Lowndes Mississippi 28087 16628 216
2182158 2182158 2022-02-04 Lowndes Mississippi 28087 16628 216
2178906 2178906 2022-02-03 Lowndes Mississippi 28087 16433 216

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