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

785 rows where fips = 28037 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 · 785 ✖

fips 1

  • 28037 · 785 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501011 2501011 2022-05-13 Franklin Mississippi 28037 1927 38
2497753 2497753 2022-05-12 Franklin Mississippi 28037 1927 38
2494495 2494495 2022-05-11 Franklin Mississippi 28037 1927 38
2491237 2491237 2022-05-10 Franklin Mississippi 28037 1927 38
2487980 2487980 2022-05-09 Franklin Mississippi 28037 1927 38
2484722 2484722 2022-05-08 Franklin Mississippi 28037 1926 38
2481464 2481464 2022-05-07 Franklin Mississippi 28037 1926 38
2478206 2478206 2022-05-06 Franklin Mississippi 28037 1926 38
2474948 2474948 2022-05-05 Franklin Mississippi 28037 1926 38
2471691 2471691 2022-05-04 Franklin Mississippi 28037 1926 38
2468435 2468435 2022-05-03 Franklin Mississippi 28037 1926 38
2465180 2465180 2022-05-02 Franklin Mississippi 28037 1926 38
2461924 2461924 2022-05-01 Franklin Mississippi 28037 1926 38
2458668 2458668 2022-04-30 Franklin Mississippi 28037 1926 38
2455412 2455412 2022-04-29 Franklin Mississippi 28037 1926 38
2452156 2452156 2022-04-28 Franklin Mississippi 28037 1926 38
2448900 2448900 2022-04-27 Franklin Mississippi 28037 1926 38
2445644 2445644 2022-04-26 Franklin Mississippi 28037 1926 38
2442388 2442388 2022-04-25 Franklin Mississippi 28037 1925 38
2439132 2439132 2022-04-24 Franklin Mississippi 28037 1925 38
2435876 2435876 2022-04-23 Franklin Mississippi 28037 1925 38
2432620 2432620 2022-04-22 Franklin Mississippi 28037 1925 38
2429364 2429364 2022-04-21 Franklin Mississippi 28037 1925 38
2426108 2426108 2022-04-20 Franklin Mississippi 28037 1925 38
2422852 2422852 2022-04-19 Franklin Mississippi 28037 1925 38
2419596 2419596 2022-04-18 Franklin Mississippi 28037 1925 38
2416340 2416340 2022-04-17 Franklin Mississippi 28037 1924 38
2413084 2413084 2022-04-16 Franklin Mississippi 28037 1924 38
2409828 2409828 2022-04-15 Franklin Mississippi 28037 1924 38
2406572 2406572 2022-04-14 Franklin Mississippi 28037 1924 38
2403316 2403316 2022-04-13 Franklin Mississippi 28037 1924 38
2400062 2400062 2022-04-12 Franklin Mississippi 28037 1924 38
2396806 2396806 2022-04-11 Franklin Mississippi 28037 1924 38
2393551 2393551 2022-04-10 Franklin Mississippi 28037 1924 38
2390295 2390295 2022-04-09 Franklin Mississippi 28037 1924 38
2387039 2387039 2022-04-08 Franklin Mississippi 28037 1924 38
2383784 2383784 2022-04-07 Franklin Mississippi 28037 1924 38
2380529 2380529 2022-04-06 Franklin Mississippi 28037 1924 38
2377274 2377274 2022-04-05 Franklin Mississippi 28037 1924 38
2374022 2374022 2022-04-04 Franklin Mississippi 28037 1924 38
2370769 2370769 2022-04-03 Franklin Mississippi 28037 1923 38
2367516 2367516 2022-04-02 Franklin Mississippi 28037 1923 38
2364263 2364263 2022-04-01 Franklin Mississippi 28037 1923 38
2361009 2361009 2022-03-31 Franklin Mississippi 28037 1923 38
2357755 2357755 2022-03-30 Franklin Mississippi 28037 1923 38
2354502 2354502 2022-03-29 Franklin Mississippi 28037 1923 38
2351250 2351250 2022-03-28 Franklin Mississippi 28037 1923 38
2347997 2347997 2022-03-27 Franklin Mississippi 28037 1922 38
2344744 2344744 2022-03-26 Franklin Mississippi 28037 1922 38
2341491 2341491 2022-03-25 Franklin Mississippi 28037 1922 38
2338238 2338238 2022-03-24 Franklin Mississippi 28037 1922 38
2334984 2334984 2022-03-23 Franklin Mississippi 28037 1922 38
2331730 2331730 2022-03-22 Franklin Mississippi 28037 1922 38
2328478 2328478 2022-03-21 Franklin Mississippi 28037 1922 38
2325225 2325225 2022-03-20 Franklin Mississippi 28037 1923 38
2321971 2321971 2022-03-19 Franklin Mississippi 28037 1923 38
2318717 2318717 2022-03-18 Franklin Mississippi 28037 1923 38
2315464 2315464 2022-03-17 Franklin Mississippi 28037 1923 38
2312211 2312211 2022-03-16 Franklin Mississippi 28037 1923 38
2308958 2308958 2022-03-15 Franklin Mississippi 28037 1923 38
2305707 2305707 2022-03-14 Franklin Mississippi 28037 1923 38
2302455 2302455 2022-03-13 Franklin Mississippi 28037 1922 38
2299203 2299203 2022-03-12 Franklin Mississippi 28037 1922 38
2295951 2295951 2022-03-11 Franklin Mississippi 28037 1922 38
2292699 2292699 2022-03-10 Franklin Mississippi 28037 1922 38
2289447 2289447 2022-03-09 Franklin Mississippi 28037 1922 38
2286196 2286196 2022-03-08 Franklin Mississippi 28037 1922 38
2282944 2282944 2022-03-07 Franklin Mississippi 28037 1922 38
2279691 2279691 2022-03-06 Franklin Mississippi 28037 1922 38
2276438 2276438 2022-03-05 Franklin Mississippi 28037 1922 38
2273185 2273185 2022-03-04 Franklin Mississippi 28037 1922 38
2269933 2269933 2022-03-03 Franklin Mississippi 28037 1921 37
2266680 2266680 2022-03-02 Franklin Mississippi 28037 1920 37
2263429 2263429 2022-03-01 Franklin Mississippi 28037 1920 37
2260178 2260178 2022-02-28 Franklin Mississippi 28037 1919 37
2256927 2256927 2022-02-27 Franklin Mississippi 28037 1918 37
2253676 2253676 2022-02-26 Franklin Mississippi 28037 1918 37
2250425 2250425 2022-02-25 Franklin Mississippi 28037 1918 37
2247174 2247174 2022-02-24 Franklin Mississippi 28037 1917 37
2243923 2243923 2022-02-23 Franklin Mississippi 28037 1915 37
2240672 2240672 2022-02-22 Franklin Mississippi 28037 1914 36
2237421 2237421 2022-02-21 Franklin Mississippi 28037 1912 36
2234170 2234170 2022-02-20 Franklin Mississippi 28037 1912 36
2230919 2230919 2022-02-19 Franklin Mississippi 28037 1912 36
2227668 2227668 2022-02-18 Franklin Mississippi 28037 1912 36
2224417 2224417 2022-02-17 Franklin Mississippi 28037 1910 36
2221166 2221166 2022-02-16 Franklin Mississippi 28037 1909 36
2217915 2217915 2022-02-15 Franklin Mississippi 28037 1904 35
2214664 2214664 2022-02-14 Franklin Mississippi 28037 1898 35
2211412 2211412 2022-02-13 Franklin Mississippi 28037 1894 35
2208159 2208159 2022-02-12 Franklin Mississippi 28037 1894 35
2204906 2204906 2022-02-11 Franklin Mississippi 28037 1894 35
2201653 2201653 2022-02-10 Franklin Mississippi 28037 1893 35
2198399 2198399 2022-02-09 Franklin Mississippi 28037 1885 35
2195145 2195145 2022-02-08 Franklin Mississippi 28037 1876 35
2191891 2191891 2022-02-07 Franklin Mississippi 28037 1862 35
2188638 2188638 2022-02-06 Franklin Mississippi 28037 1823 35
2185385 2185385 2022-02-05 Franklin Mississippi 28037 1823 35
2182133 2182133 2022-02-04 Franklin Mississippi 28037 1823 35
2178881 2178881 2022-02-03 Franklin Mississippi 28037 1806 35

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