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 fips = 28025 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

  • 28025 · 784 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501005 2501005 2022-05-13 Clay Mississippi 28025 4974 98
2497747 2497747 2022-05-12 Clay Mississippi 28025 4974 98
2494489 2494489 2022-05-11 Clay Mississippi 28025 4974 98
2491231 2491231 2022-05-10 Clay Mississippi 28025 4974 98
2487974 2487974 2022-05-09 Clay Mississippi 28025 4974 98
2484716 2484716 2022-05-08 Clay Mississippi 28025 4968 98
2481458 2481458 2022-05-07 Clay Mississippi 28025 4968 98
2478200 2478200 2022-05-06 Clay Mississippi 28025 4968 98
2474942 2474942 2022-05-05 Clay Mississippi 28025 4968 98
2471685 2471685 2022-05-04 Clay Mississippi 28025 4968 98
2468429 2468429 2022-05-03 Clay Mississippi 28025 4968 98
2465174 2465174 2022-05-02 Clay Mississippi 28025 4968 98
2461918 2461918 2022-05-01 Clay Mississippi 28025 4965 98
2458662 2458662 2022-04-30 Clay Mississippi 28025 4965 98
2455406 2455406 2022-04-29 Clay Mississippi 28025 4965 98
2452150 2452150 2022-04-28 Clay Mississippi 28025 4965 98
2448894 2448894 2022-04-27 Clay Mississippi 28025 4965 98
2445638 2445638 2022-04-26 Clay Mississippi 28025 4965 98
2442382 2442382 2022-04-25 Clay Mississippi 28025 4964 98
2439126 2439126 2022-04-24 Clay Mississippi 28025 4964 98
2435870 2435870 2022-04-23 Clay Mississippi 28025 4964 98
2432614 2432614 2022-04-22 Clay Mississippi 28025 4964 98
2429358 2429358 2022-04-21 Clay Mississippi 28025 4964 98
2426102 2426102 2022-04-20 Clay Mississippi 28025 4964 98
2422846 2422846 2022-04-19 Clay Mississippi 28025 4964 98
2419590 2419590 2022-04-18 Clay Mississippi 28025 4964 98
2416334 2416334 2022-04-17 Clay Mississippi 28025 4962 98
2413078 2413078 2022-04-16 Clay Mississippi 28025 4962 98
2409822 2409822 2022-04-15 Clay Mississippi 28025 4962 98
2406566 2406566 2022-04-14 Clay Mississippi 28025 4962 98
2403310 2403310 2022-04-13 Clay Mississippi 28025 4962 98
2400056 2400056 2022-04-12 Clay Mississippi 28025 4962 98
2396800 2396800 2022-04-11 Clay Mississippi 28025 4956 98
2393545 2393545 2022-04-10 Clay Mississippi 28025 4956 98
2390289 2390289 2022-04-09 Clay Mississippi 28025 4956 98
2387033 2387033 2022-04-08 Clay Mississippi 28025 4956 98
2383778 2383778 2022-04-07 Clay Mississippi 28025 4956 98
2380523 2380523 2022-04-06 Clay Mississippi 28025 4956 98
2377268 2377268 2022-04-05 Clay Mississippi 28025 4956 98
2374016 2374016 2022-04-04 Clay Mississippi 28025 4956 98
2370763 2370763 2022-04-03 Clay Mississippi 28025 4954 98
2367510 2367510 2022-04-02 Clay Mississippi 28025 4954 98
2364257 2364257 2022-04-01 Clay Mississippi 28025 4954 98
2361003 2361003 2022-03-31 Clay Mississippi 28025 4954 98
2357749 2357749 2022-03-30 Clay Mississippi 28025 4954 98
2354496 2354496 2022-03-29 Clay Mississippi 28025 4954 98
2351244 2351244 2022-03-28 Clay Mississippi 28025 4954 98
2347991 2347991 2022-03-27 Clay Mississippi 28025 4949 98
2344738 2344738 2022-03-26 Clay Mississippi 28025 4949 98
2341485 2341485 2022-03-25 Clay Mississippi 28025 4949 98
2338232 2338232 2022-03-24 Clay Mississippi 28025 4949 98
2334978 2334978 2022-03-23 Clay Mississippi 28025 4949 98
2331724 2331724 2022-03-22 Clay Mississippi 28025 4949 98
2328472 2328472 2022-03-21 Clay Mississippi 28025 4949 98
2325219 2325219 2022-03-20 Clay Mississippi 28025 4944 98
2321965 2321965 2022-03-19 Clay Mississippi 28025 4944 98
2318711 2318711 2022-03-18 Clay Mississippi 28025 4944 98
2315458 2315458 2022-03-17 Clay Mississippi 28025 4944 98
2312205 2312205 2022-03-16 Clay Mississippi 28025 4944 98
2308952 2308952 2022-03-15 Clay Mississippi 28025 4944 98
2305701 2305701 2022-03-14 Clay Mississippi 28025 4944 98
2302449 2302449 2022-03-13 Clay Mississippi 28025 4936 98
2299197 2299197 2022-03-12 Clay Mississippi 28025 4936 98
2295945 2295945 2022-03-11 Clay Mississippi 28025 4936 98
2292693 2292693 2022-03-10 Clay Mississippi 28025 4936 98
2289441 2289441 2022-03-09 Clay Mississippi 28025 4936 98
2286190 2286190 2022-03-08 Clay Mississippi 28025 4936 98
2282938 2282938 2022-03-07 Clay Mississippi 28025 4935 98
2279685 2279685 2022-03-06 Clay Mississippi 28025 4934 97
2276432 2276432 2022-03-05 Clay Mississippi 28025 4934 97
2273179 2273179 2022-03-04 Clay Mississippi 28025 4934 97
2269927 2269927 2022-03-03 Clay Mississippi 28025 4933 97
2266674 2266674 2022-03-02 Clay Mississippi 28025 4932 96
2263423 2263423 2022-03-01 Clay Mississippi 28025 4932 96
2260172 2260172 2022-02-28 Clay Mississippi 28025 4932 93
2256921 2256921 2022-02-27 Clay Mississippi 28025 4929 93
2253670 2253670 2022-02-26 Clay Mississippi 28025 4929 93
2250419 2250419 2022-02-25 Clay Mississippi 28025 4929 93
2247168 2247168 2022-02-24 Clay Mississippi 28025 4925 92
2243917 2243917 2022-02-23 Clay Mississippi 28025 4924 92
2240666 2240666 2022-02-22 Clay Mississippi 28025 4922 92
2237415 2237415 2022-02-21 Clay Mississippi 28025 4917 92
2234164 2234164 2022-02-20 Clay Mississippi 28025 4917 92
2230913 2230913 2022-02-19 Clay Mississippi 28025 4917 92
2227662 2227662 2022-02-18 Clay Mississippi 28025 4917 92
2224411 2224411 2022-02-17 Clay Mississippi 28025 4916 92
2221160 2221160 2022-02-16 Clay Mississippi 28025 4915 92
2217909 2217909 2022-02-15 Clay Mississippi 28025 4913 91
2214658 2214658 2022-02-14 Clay Mississippi 28025 4913 91
2211406 2211406 2022-02-13 Clay Mississippi 28025 4902 90
2208153 2208153 2022-02-12 Clay Mississippi 28025 4902 90
2204900 2204900 2022-02-11 Clay Mississippi 28025 4902 90
2201647 2201647 2022-02-10 Clay Mississippi 28025 4898 90
2198393 2198393 2022-02-09 Clay Mississippi 28025 4890 90
2195139 2195139 2022-02-08 Clay Mississippi 28025 4880 89
2191885 2191885 2022-02-07 Clay Mississippi 28025 4869 89
2188632 2188632 2022-02-06 Clay Mississippi 28025 4806 89
2185379 2185379 2022-02-05 Clay Mississippi 28025 4806 89
2182127 2182127 2022-02-04 Clay Mississippi 28025 4806 89
2178875 2178875 2022-02-03 Clay Mississippi 28025 4760 89

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