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

723 rows where county = "Platte", fips = 56031 and state = "Wyoming" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Wyoming · 723 ✖

fips 1

  • 56031 · 723 ✖

county 1

  • Platte · 723 ✖
Link rowid date ▲ county state fips cases deaths
2502825 2502825 2022-05-13 Platte Wyoming 56031 1911 41
2499567 2499567 2022-05-12 Platte Wyoming 56031 1911 41
2496309 2496309 2022-05-11 Platte Wyoming 56031 1911 41
2493051 2493051 2022-05-10 Platte Wyoming 56031 1911 41
2489793 2489793 2022-05-09 Platte Wyoming 56031 1911 41
2486536 2486536 2022-05-08 Platte Wyoming 56031 1911 41
2483278 2483278 2022-05-07 Platte Wyoming 56031 1911 41
2480020 2480020 2022-05-06 Platte Wyoming 56031 1911 41
2476762 2476762 2022-05-05 Platte Wyoming 56031 1911 41
2473504 2473504 2022-05-04 Platte Wyoming 56031 1911 41
2470247 2470247 2022-05-03 Platte Wyoming 56031 1911 41
2466991 2466991 2022-05-02 Platte Wyoming 56031 1909 41
2463736 2463736 2022-05-01 Platte Wyoming 56031 1909 41
2460480 2460480 2022-04-30 Platte Wyoming 56031 1909 41
2457224 2457224 2022-04-29 Platte Wyoming 56031 1909 41
2453968 2453968 2022-04-28 Platte Wyoming 56031 1909 41
2450712 2450712 2022-04-27 Platte Wyoming 56031 1909 41
2447456 2447456 2022-04-26 Platte Wyoming 56031 1909 41
2444200 2444200 2022-04-25 Platte Wyoming 56031 1908 41
2440944 2440944 2022-04-24 Platte Wyoming 56031 1908 41
2437688 2437688 2022-04-23 Platte Wyoming 56031 1908 41
2434432 2434432 2022-04-22 Platte Wyoming 56031 1908 41
2431176 2431176 2022-04-21 Platte Wyoming 56031 1908 41
2427920 2427920 2022-04-20 Platte Wyoming 56031 1908 41
2424664 2424664 2022-04-19 Platte Wyoming 56031 1908 41
2421408 2421408 2022-04-18 Platte Wyoming 56031 1908 39
2418152 2418152 2022-04-17 Platte Wyoming 56031 1908 39
2414896 2414896 2022-04-16 Platte Wyoming 56031 1908 39
2411640 2411640 2022-04-15 Platte Wyoming 56031 1908 39
2408384 2408384 2022-04-14 Platte Wyoming 56031 1908 39
2405128 2405128 2022-04-13 Platte Wyoming 56031 1908 39
2401873 2401873 2022-04-12 Platte Wyoming 56031 1908 39
2398618 2398618 2022-04-11 Platte Wyoming 56031 1907 39
2395363 2395363 2022-04-10 Platte Wyoming 56031 1907 39
2392107 2392107 2022-04-09 Platte Wyoming 56031 1907 39
2388851 2388851 2022-04-08 Platte Wyoming 56031 1907 39
2385596 2385596 2022-04-07 Platte Wyoming 56031 1905 39
2382341 2382341 2022-04-06 Platte Wyoming 56031 1905 39
2379086 2379086 2022-04-05 Platte Wyoming 56031 1905 39
2375832 2375832 2022-04-04 Platte Wyoming 56031 1903 39
2372580 2372580 2022-04-03 Platte Wyoming 56031 1903 39
2369327 2369327 2022-04-02 Platte Wyoming 56031 1903 39
2366074 2366074 2022-04-01 Platte Wyoming 56031 1903 39
2362821 2362821 2022-03-31 Platte Wyoming 56031 1902 39
2359567 2359567 2022-03-30 Platte Wyoming 56031 1902 39
2356313 2356313 2022-03-29 Platte Wyoming 56031 1902 39
2353060 2353060 2022-03-28 Platte Wyoming 56031 1901 39
2349808 2349808 2022-03-27 Platte Wyoming 56031 1901 39
2346555 2346555 2022-03-26 Platte Wyoming 56031 1901 39
2343302 2343302 2022-03-25 Platte Wyoming 56031 1901 39
2340049 2340049 2022-03-24 Platte Wyoming 56031 1901 39
2336796 2336796 2022-03-23 Platte Wyoming 56031 1901 39
2333542 2333542 2022-03-22 Platte Wyoming 56031 1901 39
2330288 2330288 2022-03-21 Platte Wyoming 56031 1900 39
2327036 2327036 2022-03-20 Platte Wyoming 56031 1900 39
2323783 2323783 2022-03-19 Platte Wyoming 56031 1900 39
2320529 2320529 2022-03-18 Platte Wyoming 56031 1900 39
2317275 2317275 2022-03-17 Platte Wyoming 56031 1900 39
2314022 2314022 2022-03-16 Platte Wyoming 56031 1900 39
2310769 2310769 2022-03-15 Platte Wyoming 56031 1900 39
2307516 2307516 2022-03-14 Platte Wyoming 56031 1900 39
2304265 2304265 2022-03-13 Platte Wyoming 56031 1900 39
2301013 2301013 2022-03-12 Platte Wyoming 56031 1900 39
2297761 2297761 2022-03-11 Platte Wyoming 56031 1900 39
2294509 2294509 2022-03-10 Platte Wyoming 56031 1898 39
2291257 2291257 2022-03-09 Platte Wyoming 56031 1898 39
2288005 2288005 2022-03-08 Platte Wyoming 56031 1898 39
2284753 2284753 2022-03-07 Platte Wyoming 56031 1896 39
2281501 2281501 2022-03-06 Platte Wyoming 56031 1894 39
2278248 2278248 2022-03-05 Platte Wyoming 56031 1894 39
2274995 2274995 2022-03-04 Platte Wyoming 56031 1894 39
2271742 2271742 2022-03-03 Platte Wyoming 56031 1892 39
2268490 2268490 2022-03-02 Platte Wyoming 56031 1892 39
2265237 2265237 2022-03-01 Platte Wyoming 56031 1892 39
2261987 2261987 2022-02-28 Platte Wyoming 56031 1892 39
2258736 2258736 2022-02-27 Platte Wyoming 56031 1888 39
2255485 2255485 2022-02-26 Platte Wyoming 56031 1888 39
2252234 2252234 2022-02-25 Platte Wyoming 56031 1888 39
2248983 2248983 2022-02-24 Platte Wyoming 56031 1887 39
2245732 2245732 2022-02-23 Platte Wyoming 56031 1885 39
2242481 2242481 2022-02-22 Platte Wyoming 56031 1885 39
2239230 2239230 2022-02-21 Platte Wyoming 56031 1880 39
2235979 2235979 2022-02-20 Platte Wyoming 56031 1880 39
2232728 2232728 2022-02-19 Platte Wyoming 56031 1880 39
2229477 2229477 2022-02-18 Platte Wyoming 56031 1880 39
2226226 2226226 2022-02-17 Platte Wyoming 56031 1876 39
2222975 2222975 2022-02-16 Platte Wyoming 56031 1871 39
2219724 2219724 2022-02-15 Platte Wyoming 56031 1872 39
2216474 2216474 2022-02-14 Platte Wyoming 56031 1871 39
2213223 2213223 2022-02-13 Platte Wyoming 56031 1865 39
2209970 2209970 2022-02-12 Platte Wyoming 56031 1865 39
2206717 2206717 2022-02-11 Platte Wyoming 56031 1865 39
2203464 2203464 2022-02-10 Platte Wyoming 56031 1863 39
2200210 2200210 2022-02-09 Platte Wyoming 56031 1862 39
2196956 2196956 2022-02-08 Platte Wyoming 56031 1854 39
2193701 2193701 2022-02-07 Platte Wyoming 56031 1850 38
2190448 2190448 2022-02-06 Platte Wyoming 56031 1830 38
2187195 2187195 2022-02-05 Platte Wyoming 56031 1830 38
2183942 2183942 2022-02-04 Platte Wyoming 56031 1830 38
2180690 2180690 2022-02-03 Platte Wyoming 56031 1822 38

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