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

  • 28157 · 786 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501072 2501072 2022-05-13 Wilkinson Mississippi 28157 1804 46
2497814 2497814 2022-05-12 Wilkinson Mississippi 28157 1804 46
2494556 2494556 2022-05-11 Wilkinson Mississippi 28157 1804 46
2491298 2491298 2022-05-10 Wilkinson Mississippi 28157 1804 46
2488040 2488040 2022-05-09 Wilkinson Mississippi 28157 1804 46
2484783 2484783 2022-05-08 Wilkinson Mississippi 28157 1799 46
2481525 2481525 2022-05-07 Wilkinson Mississippi 28157 1799 46
2478267 2478267 2022-05-06 Wilkinson Mississippi 28157 1799 46
2475009 2475009 2022-05-05 Wilkinson Mississippi 28157 1799 46
2471752 2471752 2022-05-04 Wilkinson Mississippi 28157 1799 46
2468496 2468496 2022-05-03 Wilkinson Mississippi 28157 1799 46
2465240 2465240 2022-05-02 Wilkinson Mississippi 28157 1799 46
2461985 2461985 2022-05-01 Wilkinson Mississippi 28157 1797 46
2458729 2458729 2022-04-30 Wilkinson Mississippi 28157 1797 46
2455473 2455473 2022-04-29 Wilkinson Mississippi 28157 1797 46
2452217 2452217 2022-04-28 Wilkinson Mississippi 28157 1797 46
2448961 2448961 2022-04-27 Wilkinson Mississippi 28157 1797 46
2445704 2445704 2022-04-26 Wilkinson Mississippi 28157 1797 46
2442449 2442449 2022-04-25 Wilkinson Mississippi 28157 1797 46
2439193 2439193 2022-04-24 Wilkinson Mississippi 28157 1797 46
2435937 2435937 2022-04-23 Wilkinson Mississippi 28157 1797 46
2432681 2432681 2022-04-22 Wilkinson Mississippi 28157 1797 46
2429425 2429425 2022-04-21 Wilkinson Mississippi 28157 1797 46
2426169 2426169 2022-04-20 Wilkinson Mississippi 28157 1797 46
2422913 2422913 2022-04-19 Wilkinson Mississippi 28157 1797 46
2419656 2419656 2022-04-18 Wilkinson Mississippi 28157 1797 46
2416401 2416401 2022-04-17 Wilkinson Mississippi 28157 1797 46
2413145 2413145 2022-04-16 Wilkinson Mississippi 28157 1797 46
2409889 2409889 2022-04-15 Wilkinson Mississippi 28157 1797 46
2406633 2406633 2022-04-14 Wilkinson Mississippi 28157 1797 46
2403377 2403377 2022-04-13 Wilkinson Mississippi 28157 1797 46
2400122 2400122 2022-04-12 Wilkinson Mississippi 28157 1797 46
2396867 2396867 2022-04-11 Wilkinson Mississippi 28157 1796 46
2393612 2393612 2022-04-10 Wilkinson Mississippi 28157 1796 46
2390356 2390356 2022-04-09 Wilkinson Mississippi 28157 1796 46
2387100 2387100 2022-04-08 Wilkinson Mississippi 28157 1796 46
2383845 2383845 2022-04-07 Wilkinson Mississippi 28157 1796 46
2380590 2380590 2022-04-06 Wilkinson Mississippi 28157 1796 46
2377335 2377335 2022-04-05 Wilkinson Mississippi 28157 1796 46
2374082 2374082 2022-04-04 Wilkinson Mississippi 28157 1796 46
2370830 2370830 2022-04-03 Wilkinson Mississippi 28157 1795 46
2367577 2367577 2022-04-02 Wilkinson Mississippi 28157 1795 46
2364324 2364324 2022-04-01 Wilkinson Mississippi 28157 1795 46
2361070 2361070 2022-03-31 Wilkinson Mississippi 28157 1795 46
2357816 2357816 2022-03-30 Wilkinson Mississippi 28157 1795 46
2354563 2354563 2022-03-29 Wilkinson Mississippi 28157 1795 46
2351310 2351310 2022-03-28 Wilkinson Mississippi 28157 1795 46
2348058 2348058 2022-03-27 Wilkinson Mississippi 28157 1795 46
2344805 2344805 2022-03-26 Wilkinson Mississippi 28157 1795 46
2341552 2341552 2022-03-25 Wilkinson Mississippi 28157 1795 46
2338299 2338299 2022-03-24 Wilkinson Mississippi 28157 1795 46
2335045 2335045 2022-03-23 Wilkinson Mississippi 28157 1795 46
2331791 2331791 2022-03-22 Wilkinson Mississippi 28157 1795 46
2328538 2328538 2022-03-21 Wilkinson Mississippi 28157 1795 46
2325286 2325286 2022-03-20 Wilkinson Mississippi 28157 1794 46
2322032 2322032 2022-03-19 Wilkinson Mississippi 28157 1794 46
2318778 2318778 2022-03-18 Wilkinson Mississippi 28157 1794 46
2315525 2315525 2022-03-17 Wilkinson Mississippi 28157 1794 46
2312272 2312272 2022-03-16 Wilkinson Mississippi 28157 1794 46
2309019 2309019 2022-03-15 Wilkinson Mississippi 28157 1794 46
2305767 2305767 2022-03-14 Wilkinson Mississippi 28157 1794 46
2302516 2302516 2022-03-13 Wilkinson Mississippi 28157 1792 46
2299264 2299264 2022-03-12 Wilkinson Mississippi 28157 1792 46
2296012 2296012 2022-03-11 Wilkinson Mississippi 28157 1792 46
2292760 2292760 2022-03-10 Wilkinson Mississippi 28157 1792 46
2289508 2289508 2022-03-09 Wilkinson Mississippi 28157 1792 46
2286256 2286256 2022-03-08 Wilkinson Mississippi 28157 1792 46
2283004 2283004 2022-03-07 Wilkinson Mississippi 28157 1792 46
2279751 2279751 2022-03-06 Wilkinson Mississippi 28157 1792 46
2276498 2276498 2022-03-05 Wilkinson Mississippi 28157 1792 46
2273245 2273245 2022-03-04 Wilkinson Mississippi 28157 1792 46
2269993 2269993 2022-03-03 Wilkinson Mississippi 28157 1790 45
2266740 2266740 2022-03-02 Wilkinson Mississippi 28157 1790 45
2263489 2263489 2022-03-01 Wilkinson Mississippi 28157 1790 45
2260238 2260238 2022-02-28 Wilkinson Mississippi 28157 1790 45
2256987 2256987 2022-02-27 Wilkinson Mississippi 28157 1790 45
2253736 2253736 2022-02-26 Wilkinson Mississippi 28157 1790 45
2250485 2250485 2022-02-25 Wilkinson Mississippi 28157 1790 45
2247234 2247234 2022-02-24 Wilkinson Mississippi 28157 1790 45
2243983 2243983 2022-02-23 Wilkinson Mississippi 28157 1790 44
2240732 2240732 2022-02-22 Wilkinson Mississippi 28157 1790 44
2237481 2237481 2022-02-21 Wilkinson Mississippi 28157 1788 44
2234230 2234230 2022-02-20 Wilkinson Mississippi 28157 1788 44
2230979 2230979 2022-02-19 Wilkinson Mississippi 28157 1788 44
2227728 2227728 2022-02-18 Wilkinson Mississippi 28157 1788 44
2224477 2224477 2022-02-17 Wilkinson Mississippi 28157 1786 44
2221226 2221226 2022-02-16 Wilkinson Mississippi 28157 1786 44
2217975 2217975 2022-02-15 Wilkinson Mississippi 28157 1783 44
2214724 2214724 2022-02-14 Wilkinson Mississippi 28157 1774 44
2211472 2211472 2022-02-13 Wilkinson Mississippi 28157 1771 44
2208219 2208219 2022-02-12 Wilkinson Mississippi 28157 1771 44
2204966 2204966 2022-02-11 Wilkinson Mississippi 28157 1771 44
2201713 2201713 2022-02-10 Wilkinson Mississippi 28157 1770 44
2198459 2198459 2022-02-09 Wilkinson Mississippi 28157 1760 43
2195205 2195205 2022-02-08 Wilkinson Mississippi 28157 1757 43
2191951 2191951 2022-02-07 Wilkinson Mississippi 28157 1756 43
2188698 2188698 2022-02-06 Wilkinson Mississippi 28157 1748 42
2185445 2185445 2022-02-05 Wilkinson Mississippi 28157 1748 42
2182193 2182193 2022-02-04 Wilkinson Mississippi 28157 1748 42
2178941 2178941 2022-02-03 Wilkinson Mississippi 28157 1737 41

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