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 = "Holmes" 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

county 1

  • Holmes · 786 ✖
Link rowid date ▲ county state fips cases deaths
2501018 2501018 2022-05-13 Holmes Mississippi 28051 4455 104
2497760 2497760 2022-05-12 Holmes Mississippi 28051 4455 104
2494502 2494502 2022-05-11 Holmes Mississippi 28051 4455 104
2491244 2491244 2022-05-10 Holmes Mississippi 28051 4455 104
2487987 2487987 2022-05-09 Holmes Mississippi 28051 4455 104
2484729 2484729 2022-05-08 Holmes Mississippi 28051 4447 104
2481471 2481471 2022-05-07 Holmes Mississippi 28051 4447 104
2478213 2478213 2022-05-06 Holmes Mississippi 28051 4447 104
2474955 2474955 2022-05-05 Holmes Mississippi 28051 4447 104
2471698 2471698 2022-05-04 Holmes Mississippi 28051 4447 104
2468442 2468442 2022-05-03 Holmes Mississippi 28051 4447 104
2465187 2465187 2022-05-02 Holmes Mississippi 28051 4447 104
2461931 2461931 2022-05-01 Holmes Mississippi 28051 4446 104
2458675 2458675 2022-04-30 Holmes Mississippi 28051 4446 104
2455419 2455419 2022-04-29 Holmes Mississippi 28051 4446 104
2452163 2452163 2022-04-28 Holmes Mississippi 28051 4446 104
2448907 2448907 2022-04-27 Holmes Mississippi 28051 4446 104
2445651 2445651 2022-04-26 Holmes Mississippi 28051 4446 104
2442395 2442395 2022-04-25 Holmes Mississippi 28051 4446 104
2439139 2439139 2022-04-24 Holmes Mississippi 28051 4446 104
2435883 2435883 2022-04-23 Holmes Mississippi 28051 4446 104
2432627 2432627 2022-04-22 Holmes Mississippi 28051 4446 104
2429371 2429371 2022-04-21 Holmes Mississippi 28051 4446 104
2426115 2426115 2022-04-20 Holmes Mississippi 28051 4446 104
2422859 2422859 2022-04-19 Holmes Mississippi 28051 4446 104
2419603 2419603 2022-04-18 Holmes Mississippi 28051 4446 104
2416347 2416347 2022-04-17 Holmes Mississippi 28051 4445 104
2413091 2413091 2022-04-16 Holmes Mississippi 28051 4445 104
2409835 2409835 2022-04-15 Holmes Mississippi 28051 4445 104
2406579 2406579 2022-04-14 Holmes Mississippi 28051 4445 104
2403323 2403323 2022-04-13 Holmes Mississippi 28051 4445 104
2400069 2400069 2022-04-12 Holmes Mississippi 28051 4445 104
2396813 2396813 2022-04-11 Holmes Mississippi 28051 4445 104
2393558 2393558 2022-04-10 Holmes Mississippi 28051 4445 104
2390302 2390302 2022-04-09 Holmes Mississippi 28051 4445 104
2387046 2387046 2022-04-08 Holmes Mississippi 28051 4445 104
2383791 2383791 2022-04-07 Holmes Mississippi 28051 4445 104
2380536 2380536 2022-04-06 Holmes Mississippi 28051 4445 104
2377281 2377281 2022-04-05 Holmes Mississippi 28051 4445 104
2374029 2374029 2022-04-04 Holmes Mississippi 28051 4445 104
2370776 2370776 2022-04-03 Holmes Mississippi 28051 4444 104
2367523 2367523 2022-04-02 Holmes Mississippi 28051 4444 104
2364270 2364270 2022-04-01 Holmes Mississippi 28051 4444 104
2361016 2361016 2022-03-31 Holmes Mississippi 28051 4444 104
2357762 2357762 2022-03-30 Holmes Mississippi 28051 4444 104
2354509 2354509 2022-03-29 Holmes Mississippi 28051 4444 104
2351257 2351257 2022-03-28 Holmes Mississippi 28051 4444 104
2348004 2348004 2022-03-27 Holmes Mississippi 28051 4444 104
2344751 2344751 2022-03-26 Holmes Mississippi 28051 4444 104
2341498 2341498 2022-03-25 Holmes Mississippi 28051 4444 104
2338245 2338245 2022-03-24 Holmes Mississippi 28051 4444 104
2334991 2334991 2022-03-23 Holmes Mississippi 28051 4444 104
2331737 2331737 2022-03-22 Holmes Mississippi 28051 4444 104
2328485 2328485 2022-03-21 Holmes Mississippi 28051 4444 104
2325232 2325232 2022-03-20 Holmes Mississippi 28051 4442 104
2321978 2321978 2022-03-19 Holmes Mississippi 28051 4442 104
2318724 2318724 2022-03-18 Holmes Mississippi 28051 4442 104
2315471 2315471 2022-03-17 Holmes Mississippi 28051 4442 104
2312218 2312218 2022-03-16 Holmes Mississippi 28051 4442 104
2308965 2308965 2022-03-15 Holmes Mississippi 28051 4442 104
2305714 2305714 2022-03-14 Holmes Mississippi 28051 4442 104
2302462 2302462 2022-03-13 Holmes Mississippi 28051 4440 104
2299210 2299210 2022-03-12 Holmes Mississippi 28051 4440 104
2295958 2295958 2022-03-11 Holmes Mississippi 28051 4440 104
2292706 2292706 2022-03-10 Holmes Mississippi 28051 4440 104
2289454 2289454 2022-03-09 Holmes Mississippi 28051 4440 104
2286203 2286203 2022-03-08 Holmes Mississippi 28051 4440 104
2282951 2282951 2022-03-07 Holmes Mississippi 28051 4439 104
2279698 2279698 2022-03-06 Holmes Mississippi 28051 4436 104
2276445 2276445 2022-03-05 Holmes Mississippi 28051 4436 104
2273192 2273192 2022-03-04 Holmes Mississippi 28051 4436 104
2269940 2269940 2022-03-03 Holmes Mississippi 28051 4436 104
2266687 2266687 2022-03-02 Holmes Mississippi 28051 4432 104
2263436 2263436 2022-03-01 Holmes Mississippi 28051 4429 104
2260185 2260185 2022-02-28 Holmes Mississippi 28051 4430 104
2256934 2256934 2022-02-27 Holmes Mississippi 28051 4415 104
2253683 2253683 2022-02-26 Holmes Mississippi 28051 4415 104
2250432 2250432 2022-02-25 Holmes Mississippi 28051 4415 104
2247181 2247181 2022-02-24 Holmes Mississippi 28051 4412 104
2243930 2243930 2022-02-23 Holmes Mississippi 28051 4408 104
2240679 2240679 2022-02-22 Holmes Mississippi 28051 4407 104
2237428 2237428 2022-02-21 Holmes Mississippi 28051 4397 104
2234177 2234177 2022-02-20 Holmes Mississippi 28051 4397 104
2230926 2230926 2022-02-19 Holmes Mississippi 28051 4397 104
2227675 2227675 2022-02-18 Holmes Mississippi 28051 4397 104
2224424 2224424 2022-02-17 Holmes Mississippi 28051 4391 104
2221173 2221173 2022-02-16 Holmes Mississippi 28051 4390 104
2217922 2217922 2022-02-15 Holmes Mississippi 28051 4385 104
2214671 2214671 2022-02-14 Holmes Mississippi 28051 4385 104
2211419 2211419 2022-02-13 Holmes Mississippi 28051 4327 103
2208166 2208166 2022-02-12 Holmes Mississippi 28051 4327 103
2204913 2204913 2022-02-11 Holmes Mississippi 28051 4327 103
2201660 2201660 2022-02-10 Holmes Mississippi 28051 4311 103
2198406 2198406 2022-02-09 Holmes Mississippi 28051 4309 101
2195152 2195152 2022-02-08 Holmes Mississippi 28051 4304 101
2191898 2191898 2022-02-07 Holmes Mississippi 28051 4298 98
2188645 2188645 2022-02-06 Holmes Mississippi 28051 4242 98
2185392 2185392 2022-02-05 Holmes Mississippi 28051 4242 98
2182140 2182140 2022-02-04 Holmes Mississippi 28051 4242 98
2178888 2178888 2022-02-03 Holmes Mississippi 28051 4213 98

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