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

786 rows where county = "Walthall", fips = 28147 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 · 786 ✖

fips 1

  • 28147 · 786 ✖

county 1

  • Walthall · 786 ✖
Link rowid date ▲ county state fips cases deaths
2501067 2501067 2022-05-13 Walthall Mississippi 28147 3622 79
2497809 2497809 2022-05-12 Walthall Mississippi 28147 3622 79
2494551 2494551 2022-05-11 Walthall Mississippi 28147 3622 79
2491293 2491293 2022-05-10 Walthall Mississippi 28147 3622 79
2488035 2488035 2022-05-09 Walthall Mississippi 28147 3622 79
2484778 2484778 2022-05-08 Walthall Mississippi 28147 3617 79
2481520 2481520 2022-05-07 Walthall Mississippi 28147 3617 79
2478262 2478262 2022-05-06 Walthall Mississippi 28147 3617 79
2475004 2475004 2022-05-05 Walthall Mississippi 28147 3617 79
2471747 2471747 2022-05-04 Walthall Mississippi 28147 3617 79
2468491 2468491 2022-05-03 Walthall Mississippi 28147 3617 79
2465235 2465235 2022-05-02 Walthall Mississippi 28147 3617 79
2461980 2461980 2022-05-01 Walthall Mississippi 28147 3613 79
2458724 2458724 2022-04-30 Walthall Mississippi 28147 3613 79
2455468 2455468 2022-04-29 Walthall Mississippi 28147 3613 79
2452212 2452212 2022-04-28 Walthall Mississippi 28147 3613 79
2448956 2448956 2022-04-27 Walthall Mississippi 28147 3613 79
2445699 2445699 2022-04-26 Walthall Mississippi 28147 3613 79
2442444 2442444 2022-04-25 Walthall Mississippi 28147 3610 79
2439188 2439188 2022-04-24 Walthall Mississippi 28147 3610 79
2435932 2435932 2022-04-23 Walthall Mississippi 28147 3610 79
2432676 2432676 2022-04-22 Walthall Mississippi 28147 3610 79
2429420 2429420 2022-04-21 Walthall Mississippi 28147 3610 79
2426164 2426164 2022-04-20 Walthall Mississippi 28147 3610 79
2422908 2422908 2022-04-19 Walthall Mississippi 28147 3610 79
2419651 2419651 2022-04-18 Walthall Mississippi 28147 3610 79
2416396 2416396 2022-04-17 Walthall Mississippi 28147 3610 79
2413140 2413140 2022-04-16 Walthall Mississippi 28147 3610 79
2409884 2409884 2022-04-15 Walthall Mississippi 28147 3610 79
2406628 2406628 2022-04-14 Walthall Mississippi 28147 3610 79
2403372 2403372 2022-04-13 Walthall Mississippi 28147 3610 79
2400117 2400117 2022-04-12 Walthall Mississippi 28147 3610 79
2396862 2396862 2022-04-11 Walthall Mississippi 28147 3608 79
2393607 2393607 2022-04-10 Walthall Mississippi 28147 3608 79
2390351 2390351 2022-04-09 Walthall Mississippi 28147 3608 79
2387095 2387095 2022-04-08 Walthall Mississippi 28147 3608 79
2383840 2383840 2022-04-07 Walthall Mississippi 28147 3608 79
2380585 2380585 2022-04-06 Walthall Mississippi 28147 3608 79
2377330 2377330 2022-04-05 Walthall Mississippi 28147 3608 79
2374077 2374077 2022-04-04 Walthall Mississippi 28147 3608 79
2370825 2370825 2022-04-03 Walthall Mississippi 28147 3604 79
2367572 2367572 2022-04-02 Walthall Mississippi 28147 3604 79
2364319 2364319 2022-04-01 Walthall Mississippi 28147 3604 79
2361065 2361065 2022-03-31 Walthall Mississippi 28147 3604 79
2357811 2357811 2022-03-30 Walthall Mississippi 28147 3604 79
2354558 2354558 2022-03-29 Walthall Mississippi 28147 3604 79
2351305 2351305 2022-03-28 Walthall Mississippi 28147 3604 79
2348053 2348053 2022-03-27 Walthall Mississippi 28147 3595 79
2344800 2344800 2022-03-26 Walthall Mississippi 28147 3595 79
2341547 2341547 2022-03-25 Walthall Mississippi 28147 3595 79
2338294 2338294 2022-03-24 Walthall Mississippi 28147 3595 79
2335040 2335040 2022-03-23 Walthall Mississippi 28147 3595 79
2331786 2331786 2022-03-22 Walthall Mississippi 28147 3595 79
2328533 2328533 2022-03-21 Walthall Mississippi 28147 3595 79
2325281 2325281 2022-03-20 Walthall Mississippi 28147 3593 79
2322027 2322027 2022-03-19 Walthall Mississippi 28147 3593 79
2318773 2318773 2022-03-18 Walthall Mississippi 28147 3593 79
2315520 2315520 2022-03-17 Walthall Mississippi 28147 3593 79
2312267 2312267 2022-03-16 Walthall Mississippi 28147 3593 79
2309014 2309014 2022-03-15 Walthall Mississippi 28147 3593 79
2305762 2305762 2022-03-14 Walthall Mississippi 28147 3593 79
2302511 2302511 2022-03-13 Walthall Mississippi 28147 3580 79
2299259 2299259 2022-03-12 Walthall Mississippi 28147 3580 79
2296007 2296007 2022-03-11 Walthall Mississippi 28147 3580 79
2292755 2292755 2022-03-10 Walthall Mississippi 28147 3580 79
2289503 2289503 2022-03-09 Walthall Mississippi 28147 3580 79
2286251 2286251 2022-03-08 Walthall Mississippi 28147 3580 79
2282999 2282999 2022-03-07 Walthall Mississippi 28147 3579 78
2279746 2279746 2022-03-06 Walthall Mississippi 28147 3574 78
2276493 2276493 2022-03-05 Walthall Mississippi 28147 3574 78
2273240 2273240 2022-03-04 Walthall Mississippi 28147 3574 78
2269988 2269988 2022-03-03 Walthall Mississippi 28147 3572 78
2266735 2266735 2022-03-02 Walthall Mississippi 28147 3571 78
2263484 2263484 2022-03-01 Walthall Mississippi 28147 3570 78
2260233 2260233 2022-02-28 Walthall Mississippi 28147 3570 78
2256982 2256982 2022-02-27 Walthall Mississippi 28147 3568 78
2253731 2253731 2022-02-26 Walthall Mississippi 28147 3568 78
2250480 2250480 2022-02-25 Walthall Mississippi 28147 3568 78
2247229 2247229 2022-02-24 Walthall Mississippi 28147 3566 78
2243978 2243978 2022-02-23 Walthall Mississippi 28147 3564 78
2240727 2240727 2022-02-22 Walthall Mississippi 28147 3562 78
2237476 2237476 2022-02-21 Walthall Mississippi 28147 3560 78
2234225 2234225 2022-02-20 Walthall Mississippi 28147 3560 78
2230974 2230974 2022-02-19 Walthall Mississippi 28147 3560 78
2227723 2227723 2022-02-18 Walthall Mississippi 28147 3560 78
2224472 2224472 2022-02-17 Walthall Mississippi 28147 3553 78
2221221 2221221 2022-02-16 Walthall Mississippi 28147 3549 78
2217970 2217970 2022-02-15 Walthall Mississippi 28147 3544 77
2214719 2214719 2022-02-14 Walthall Mississippi 28147 3538 77
2211467 2211467 2022-02-13 Walthall Mississippi 28147 3499 77
2208214 2208214 2022-02-12 Walthall Mississippi 28147 3499 77
2204961 2204961 2022-02-11 Walthall Mississippi 28147 3499 77
2201708 2201708 2022-02-10 Walthall Mississippi 28147 3486 75
2198454 2198454 2022-02-09 Walthall Mississippi 28147 3483 74
2195200 2195200 2022-02-08 Walthall Mississippi 28147 3466 74
2191946 2191946 2022-02-07 Walthall Mississippi 28147 3448 72
2188693 2188693 2022-02-06 Walthall Mississippi 28147 3362 72
2185440 2185440 2022-02-05 Walthall Mississippi 28147 3362 72
2182188 2182188 2022-02-04 Walthall Mississippi 28147 3362 72
2178936 2178936 2022-02-03 Walthall Mississippi 28147 3343 72

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