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

783 rows where county = "Webster" 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 · 783 ✖

fips 1

county 1

  • Webster · 783 ✖
Link rowid date ▲ county state fips cases deaths
2501071 2501071 2022-05-13 Webster Mississippi 28155 3388 70
2497813 2497813 2022-05-12 Webster Mississippi 28155 3388 70
2494555 2494555 2022-05-11 Webster Mississippi 28155 3388 70
2491297 2491297 2022-05-10 Webster Mississippi 28155 3388 70
2488039 2488039 2022-05-09 Webster Mississippi 28155 3388 70
2484782 2484782 2022-05-08 Webster Mississippi 28155 3387 70
2481524 2481524 2022-05-07 Webster Mississippi 28155 3387 70
2478266 2478266 2022-05-06 Webster Mississippi 28155 3387 70
2475008 2475008 2022-05-05 Webster Mississippi 28155 3387 70
2471751 2471751 2022-05-04 Webster Mississippi 28155 3387 70
2468495 2468495 2022-05-03 Webster Mississippi 28155 3387 70
2465239 2465239 2022-05-02 Webster Mississippi 28155 3387 70
2461984 2461984 2022-05-01 Webster Mississippi 28155 3387 70
2458728 2458728 2022-04-30 Webster Mississippi 28155 3387 70
2455472 2455472 2022-04-29 Webster Mississippi 28155 3387 70
2452216 2452216 2022-04-28 Webster Mississippi 28155 3387 70
2448960 2448960 2022-04-27 Webster Mississippi 28155 3387 70
2445703 2445703 2022-04-26 Webster Mississippi 28155 3387 70
2442448 2442448 2022-04-25 Webster Mississippi 28155 3387 70
2439192 2439192 2022-04-24 Webster Mississippi 28155 3387 70
2435936 2435936 2022-04-23 Webster Mississippi 28155 3387 70
2432680 2432680 2022-04-22 Webster Mississippi 28155 3387 70
2429424 2429424 2022-04-21 Webster Mississippi 28155 3387 70
2426168 2426168 2022-04-20 Webster Mississippi 28155 3387 70
2422912 2422912 2022-04-19 Webster Mississippi 28155 3387 70
2419655 2419655 2022-04-18 Webster Mississippi 28155 3387 70
2416400 2416400 2022-04-17 Webster Mississippi 28155 3387 70
2413144 2413144 2022-04-16 Webster Mississippi 28155 3387 70
2409888 2409888 2022-04-15 Webster Mississippi 28155 3387 70
2406632 2406632 2022-04-14 Webster Mississippi 28155 3387 70
2403376 2403376 2022-04-13 Webster Mississippi 28155 3387 70
2400121 2400121 2022-04-12 Webster Mississippi 28155 3387 70
2396866 2396866 2022-04-11 Webster Mississippi 28155 3386 70
2393611 2393611 2022-04-10 Webster Mississippi 28155 3386 70
2390355 2390355 2022-04-09 Webster Mississippi 28155 3386 70
2387099 2387099 2022-04-08 Webster Mississippi 28155 3386 70
2383844 2383844 2022-04-07 Webster Mississippi 28155 3386 70
2380589 2380589 2022-04-06 Webster Mississippi 28155 3386 70
2377334 2377334 2022-04-05 Webster Mississippi 28155 3386 70
2374081 2374081 2022-04-04 Webster Mississippi 28155 3386 70
2370829 2370829 2022-04-03 Webster Mississippi 28155 3385 69
2367576 2367576 2022-04-02 Webster Mississippi 28155 3385 69
2364323 2364323 2022-04-01 Webster Mississippi 28155 3385 69
2361069 2361069 2022-03-31 Webster Mississippi 28155 3385 69
2357815 2357815 2022-03-30 Webster Mississippi 28155 3385 69
2354562 2354562 2022-03-29 Webster Mississippi 28155 3385 69
2351309 2351309 2022-03-28 Webster Mississippi 28155 3385 69
2348057 2348057 2022-03-27 Webster Mississippi 28155 3385 69
2344804 2344804 2022-03-26 Webster Mississippi 28155 3385 69
2341551 2341551 2022-03-25 Webster Mississippi 28155 3385 69
2338298 2338298 2022-03-24 Webster Mississippi 28155 3385 69
2335044 2335044 2022-03-23 Webster Mississippi 28155 3385 69
2331790 2331790 2022-03-22 Webster Mississippi 28155 3385 69
2328537 2328537 2022-03-21 Webster Mississippi 28155 3385 69
2325285 2325285 2022-03-20 Webster Mississippi 28155 3380 69
2322031 2322031 2022-03-19 Webster Mississippi 28155 3380 69
2318777 2318777 2022-03-18 Webster Mississippi 28155 3380 69
2315524 2315524 2022-03-17 Webster Mississippi 28155 3380 69
2312271 2312271 2022-03-16 Webster Mississippi 28155 3380 69
2309018 2309018 2022-03-15 Webster Mississippi 28155 3380 69
2305766 2305766 2022-03-14 Webster Mississippi 28155 3380 69
2302515 2302515 2022-03-13 Webster Mississippi 28155 3377 69
2299263 2299263 2022-03-12 Webster Mississippi 28155 3377 69
2296011 2296011 2022-03-11 Webster Mississippi 28155 3377 69
2292759 2292759 2022-03-10 Webster Mississippi 28155 3377 69
2289507 2289507 2022-03-09 Webster Mississippi 28155 3377 69
2286255 2286255 2022-03-08 Webster Mississippi 28155 3377 69
2283003 2283003 2022-03-07 Webster Mississippi 28155 3376 68
2279750 2279750 2022-03-06 Webster Mississippi 28155 3374 68
2276497 2276497 2022-03-05 Webster Mississippi 28155 3374 68
2273244 2273244 2022-03-04 Webster Mississippi 28155 3374 68
2269992 2269992 2022-03-03 Webster Mississippi 28155 3374 68
2266739 2266739 2022-03-02 Webster Mississippi 28155 3372 68
2263488 2263488 2022-03-01 Webster Mississippi 28155 3371 68
2260237 2260237 2022-02-28 Webster Mississippi 28155 3370 66
2256986 2256986 2022-02-27 Webster Mississippi 28155 3322 66
2253735 2253735 2022-02-26 Webster Mississippi 28155 3322 66
2250484 2250484 2022-02-25 Webster Mississippi 28155 3322 66
2247233 2247233 2022-02-24 Webster Mississippi 28155 3317 66
2243982 2243982 2022-02-23 Webster Mississippi 28155 3286 66
2240731 2240731 2022-02-22 Webster Mississippi 28155 3263 65
2237480 2237480 2022-02-21 Webster Mississippi 28155 3193 65
2234229 2234229 2022-02-20 Webster Mississippi 28155 3193 65
2230978 2230978 2022-02-19 Webster Mississippi 28155 3193 65
2227727 2227727 2022-02-18 Webster Mississippi 28155 3193 65
2224476 2224476 2022-02-17 Webster Mississippi 28155 3188 65
2221225 2221225 2022-02-16 Webster Mississippi 28155 3178 64
2217974 2217974 2022-02-15 Webster Mississippi 28155 3147 60
2214723 2214723 2022-02-14 Webster Mississippi 28155 3140 60
2211471 2211471 2022-02-13 Webster Mississippi 28155 3077 59
2208218 2208218 2022-02-12 Webster Mississippi 28155 3077 59
2204965 2204965 2022-02-11 Webster Mississippi 28155 3077 59
2201712 2201712 2022-02-10 Webster Mississippi 28155 3055 59
2198458 2198458 2022-02-09 Webster Mississippi 28155 3046 58
2195204 2195204 2022-02-08 Webster Mississippi 28155 3037 58
2191950 2191950 2022-02-07 Webster Mississippi 28155 3020 58
2188697 2188697 2022-02-06 Webster Mississippi 28155 2970 58
2185444 2185444 2022-02-05 Webster Mississippi 28155 2970 58
2182192 2182192 2022-02-04 Webster Mississippi 28155 2970 58
2178940 2178940 2022-02-03 Webster Mississippi 28155 2918 57

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