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

772 rows where county = "Monroe" and state = "Arkansas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Arkansas · 772 ✖

fips 1

county 1

  • Monroe · 772 ✖
Link rowid date ▲ county state fips cases deaths
2499733 2499733 2022-05-13 Monroe Arkansas 5095 1936 35
2496475 2496475 2022-05-12 Monroe Arkansas 5095 1936 35
2493217 2493217 2022-05-11 Monroe Arkansas 5095 1936 35
2489959 2489959 2022-05-10 Monroe Arkansas 5095 1935 35
2486702 2486702 2022-05-09 Monroe Arkansas 5095 1933 35
2483444 2483444 2022-05-08 Monroe Arkansas 5095 1933 35
2480186 2480186 2022-05-07 Monroe Arkansas 5095 1933 35
2476928 2476928 2022-05-06 Monroe Arkansas 5095 1933 35
2473670 2473670 2022-05-05 Monroe Arkansas 5095 1931 35
2470413 2470413 2022-05-04 Monroe Arkansas 5095 1929 35
2467157 2467157 2022-05-03 Monroe Arkansas 5095 1929 35
2463902 2463902 2022-05-02 Monroe Arkansas 5095 1929 35
2460646 2460646 2022-05-01 Monroe Arkansas 5095 1929 35
2457390 2457390 2022-04-30 Monroe Arkansas 5095 1929 35
2454134 2454134 2022-04-29 Monroe Arkansas 5095 1929 35
2450878 2450878 2022-04-28 Monroe Arkansas 5095 1929 35
2447622 2447622 2022-04-27 Monroe Arkansas 5095 1928 35
2444366 2444366 2022-04-26 Monroe Arkansas 5095 1928 35
2441110 2441110 2022-04-25 Monroe Arkansas 5095 1928 35
2437854 2437854 2022-04-24 Monroe Arkansas 5095 1928 35
2434598 2434598 2022-04-23 Monroe Arkansas 5095 1928 35
2431342 2431342 2022-04-22 Monroe Arkansas 5095 1928 35
2428086 2428086 2022-04-21 Monroe Arkansas 5095 1928 35
2424830 2424830 2022-04-20 Monroe Arkansas 5095 1927 35
2421574 2421574 2022-04-19 Monroe Arkansas 5095 1927 35
2418318 2418318 2022-04-18 Monroe Arkansas 5095 1927 35
2415062 2415062 2022-04-17 Monroe Arkansas 5095 1927 35
2411806 2411806 2022-04-16 Monroe Arkansas 5095 1927 35
2408550 2408550 2022-04-15 Monroe Arkansas 5095 1927 35
2405294 2405294 2022-04-14 Monroe Arkansas 5095 1927 35
2402039 2402039 2022-04-13 Monroe Arkansas 5095 1927 35
2398784 2398784 2022-04-12 Monroe Arkansas 5095 1927 35
2395529 2395529 2022-04-11 Monroe Arkansas 5095 1928 35
2392273 2392273 2022-04-10 Monroe Arkansas 5095 1928 35
2389017 2389017 2022-04-09 Monroe Arkansas 5095 1927 35
2385762 2385762 2022-04-08 Monroe Arkansas 5095 1927 35
2382507 2382507 2022-04-07 Monroe Arkansas 5095 1927 35
2379252 2379252 2022-04-06 Monroe Arkansas 5095 1927 34
2375998 2375998 2022-04-05 Monroe Arkansas 5095 1927 34
2372746 2372746 2022-04-04 Monroe Arkansas 5095 1927 34
2369493 2369493 2022-04-03 Monroe Arkansas 5095 1927 34
2366240 2366240 2022-04-02 Monroe Arkansas 5095 1927 33
2362987 2362987 2022-04-01 Monroe Arkansas 5095 1927 33
2359733 2359733 2022-03-31 Monroe Arkansas 5095 1925 33
2356479 2356479 2022-03-30 Monroe Arkansas 5095 1925 33
2353226 2353226 2022-03-29 Monroe Arkansas 5095 1925 33
2349974 2349974 2022-03-28 Monroe Arkansas 5095 1925 33
2346721 2346721 2022-03-27 Monroe Arkansas 5095 1924 33
2343468 2343468 2022-03-26 Monroe Arkansas 5095 1924 33
2340215 2340215 2022-03-25 Monroe Arkansas 5095 1924 33
2336962 2336962 2022-03-24 Monroe Arkansas 5095 1924 33
2333708 2333708 2022-03-23 Monroe Arkansas 5095 1924 33
2330454 2330454 2022-03-22 Monroe Arkansas 5095 1923 33
2327202 2327202 2022-03-21 Monroe Arkansas 5095 1922 33
2323949 2323949 2022-03-20 Monroe Arkansas 5095 1920 32
2320695 2320695 2022-03-19 Monroe Arkansas 5095 1919 32
2317441 2317441 2022-03-18 Monroe Arkansas 5095 1918 32
2314188 2314188 2022-03-17 Monroe Arkansas 5095 1917 31
2310935 2310935 2022-03-16 Monroe Arkansas 5095 1916 31
2307682 2307682 2022-03-15 Monroe Arkansas 5095 1915 31
2304431 2304431 2022-03-14 Monroe Arkansas 5095 1915 31
2301179 2301179 2022-03-13 Monroe Arkansas 5095 1916 31
2297927 2297927 2022-03-12 Monroe Arkansas 5095 1916 31
2294675 2294675 2022-03-11 Monroe Arkansas 5095 1916 31
2291423 2291423 2022-03-10 Monroe Arkansas 5095 1916 31
2288171 2288171 2022-03-09 Monroe Arkansas 5095 1915 31
2284920 2284920 2022-03-08 Monroe Arkansas 5095 1915 31
2281668 2281668 2022-03-07 Monroe Arkansas 5095 1915 31
2278415 2278415 2022-03-06 Monroe Arkansas 5095 1915 31
2275162 2275162 2022-03-05 Monroe Arkansas 5095 1915 31
2271909 2271909 2022-03-04 Monroe Arkansas 5095 1914 31
2268657 2268657 2022-03-03 Monroe Arkansas 5095 1914 31
2265404 2265404 2022-03-02 Monroe Arkansas 5095 1913 31
2262153 2262153 2022-03-01 Monroe Arkansas 5095 1914 31
2258902 2258902 2022-02-28 Monroe Arkansas 5095 1914 31
2255651 2255651 2022-02-27 Monroe Arkansas 5095 1913 31
2252400 2252400 2022-02-26 Monroe Arkansas 5095 1912 31
2249149 2249149 2022-02-25 Monroe Arkansas 5095 1912 31
2245898 2245898 2022-02-24 Monroe Arkansas 5095 1912 31
2242647 2242647 2022-02-23 Monroe Arkansas 5095 1909 31
2239396 2239396 2022-02-22 Monroe Arkansas 5095 1908 31
2236145 2236145 2022-02-21 Monroe Arkansas 5095 1906 31
2232894 2232894 2022-02-20 Monroe Arkansas 5095 1905 31
2229643 2229643 2022-02-19 Monroe Arkansas 5095 1905 31
2226392 2226392 2022-02-18 Monroe Arkansas 5095 1903 31
2223141 2223141 2022-02-17 Monroe Arkansas 5095 1901 30
2219890 2219890 2022-02-16 Monroe Arkansas 5095 1897 30
2216639 2216639 2022-02-15 Monroe Arkansas 5095 1895 30
2213388 2213388 2022-02-14 Monroe Arkansas 5095 1892 30
2210136 2210136 2022-02-13 Monroe Arkansas 5095 1891 29
2206883 2206883 2022-02-12 Monroe Arkansas 5095 1890 28
2203630 2203630 2022-02-11 Monroe Arkansas 5095 1884 28
2200377 2200377 2022-02-10 Monroe Arkansas 5095 1883 28
2197123 2197123 2022-02-09 Monroe Arkansas 5095 1882 28
2193868 2193868 2022-02-08 Monroe Arkansas 5095 1877 28
2190615 2190615 2022-02-07 Monroe Arkansas 5095 1875 28
2187362 2187362 2022-02-06 Monroe Arkansas 5095 1872 28
2184109 2184109 2022-02-05 Monroe Arkansas 5095 1872 28
2180857 2180857 2022-02-04 Monroe Arkansas 5095 1872 28
2177606 2177606 2022-02-03 Monroe Arkansas 5095 1871 28

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