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

667 rows where fips = 30005 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 30005 · 667 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501195 2501195 2022-05-13 Blaine Montana 30005 2077 32
2497937 2497937 2022-05-12 Blaine Montana 30005 2073 32
2494679 2494679 2022-05-11 Blaine Montana 30005 2073 32
2491421 2491421 2022-05-10 Blaine Montana 30005 2073 32
2488163 2488163 2022-05-09 Blaine Montana 30005 2073 32
2484906 2484906 2022-05-08 Blaine Montana 30005 2073 32
2481648 2481648 2022-05-07 Blaine Montana 30005 2073 32
2478390 2478390 2022-05-06 Blaine Montana 30005 2073 32
2475132 2475132 2022-05-05 Blaine Montana 30005 2073 32
2471875 2471875 2022-05-04 Blaine Montana 30005 2073 32
2468619 2468619 2022-05-03 Blaine Montana 30005 2072 32
2465363 2465363 2022-05-02 Blaine Montana 30005 2072 32
2462108 2462108 2022-05-01 Blaine Montana 30005 2071 32
2458852 2458852 2022-04-30 Blaine Montana 30005 2071 32
2455596 2455596 2022-04-29 Blaine Montana 30005 2071 32
2452340 2452340 2022-04-28 Blaine Montana 30005 2071 32
2449084 2449084 2022-04-27 Blaine Montana 30005 2070 32
2445827 2445827 2022-04-26 Blaine Montana 30005 2070 32
2442572 2442572 2022-04-25 Blaine Montana 30005 2068 32
2439316 2439316 2022-04-24 Blaine Montana 30005 2068 32
2436060 2436060 2022-04-23 Blaine Montana 30005 2068 32
2432804 2432804 2022-04-22 Blaine Montana 30005 2068 32
2429548 2429548 2022-04-21 Blaine Montana 30005 2068 32
2426292 2426292 2022-04-20 Blaine Montana 30005 2068 32
2423036 2423036 2022-04-19 Blaine Montana 30005 2066 32
2419779 2419779 2022-04-18 Blaine Montana 30005 2065 32
2416524 2416524 2022-04-17 Blaine Montana 30005 2065 32
2413268 2413268 2022-04-16 Blaine Montana 30005 2065 32
2410012 2410012 2022-04-15 Blaine Montana 30005 2065 32
2406756 2406756 2022-04-14 Blaine Montana 30005 2064 32
2403500 2403500 2022-04-13 Blaine Montana 30005 2064 32
2400245 2400245 2022-04-12 Blaine Montana 30005 2064 32
2396990 2396990 2022-04-11 Blaine Montana 30005 2064 32
2393735 2393735 2022-04-10 Blaine Montana 30005 2064 32
2390479 2390479 2022-04-09 Blaine Montana 30005 2064 32
2387223 2387223 2022-04-08 Blaine Montana 30005 2064 32
2383968 2383968 2022-04-07 Blaine Montana 30005 2064 32
2380713 2380713 2022-04-06 Blaine Montana 30005 2064 31
2377458 2377458 2022-04-05 Blaine Montana 30005 2064 31
2374205 2374205 2022-04-04 Blaine Montana 30005 2064 31
2370953 2370953 2022-04-03 Blaine Montana 30005 2063 31
2367700 2367700 2022-04-02 Blaine Montana 30005 2063 31
2364447 2364447 2022-04-01 Blaine Montana 30005 2063 31
2361193 2361193 2022-03-31 Blaine Montana 30005 2063 31
2357939 2357939 2022-03-30 Blaine Montana 30005 2063 31
2354686 2354686 2022-03-29 Blaine Montana 30005 2062 31
2351433 2351433 2022-03-28 Blaine Montana 30005 2062 31
2348181 2348181 2022-03-27 Blaine Montana 30005 2062 31
2344928 2344928 2022-03-26 Blaine Montana 30005 2062 31
2341675 2341675 2022-03-25 Blaine Montana 30005 2062 31
2338422 2338422 2022-03-24 Blaine Montana 30005 2061 31
2335168 2335168 2022-03-23 Blaine Montana 30005 2061 31
2331914 2331914 2022-03-22 Blaine Montana 30005 2061 31
2328661 2328661 2022-03-21 Blaine Montana 30005 2061 31
2325409 2325409 2022-03-20 Blaine Montana 30005 2061 31
2322155 2322155 2022-03-19 Blaine Montana 30005 2061 31
2318901 2318901 2022-03-18 Blaine Montana 30005 2061 31
2315648 2315648 2022-03-17 Blaine Montana 30005 2061 31
2312395 2312395 2022-03-16 Blaine Montana 30005 2061 31
2309142 2309142 2022-03-15 Blaine Montana 30005 2061 31
2305890 2305890 2022-03-14 Blaine Montana 30005 2060 31
2302639 2302639 2022-03-13 Blaine Montana 30005 2060 31
2299387 2299387 2022-03-12 Blaine Montana 30005 2060 31
2296135 2296135 2022-03-11 Blaine Montana 30005 2060 31
2292883 2292883 2022-03-10 Blaine Montana 30005 2059 31
2289631 2289631 2022-03-09 Blaine Montana 30005 2056 31
2286379 2286379 2022-03-08 Blaine Montana 30005 2056 31
2283127 2283127 2022-03-07 Blaine Montana 30005 2052 31
2279874 2279874 2022-03-06 Blaine Montana 30005 2049 31
2276621 2276621 2022-03-05 Blaine Montana 30005 2049 31
2273368 2273368 2022-03-04 Blaine Montana 30005 2049 31
2270116 2270116 2022-03-03 Blaine Montana 30005 2001 31
2266863 2266863 2022-03-02 Blaine Montana 30005 1997 31
2263612 2263612 2022-03-01 Blaine Montana 30005 1990 31
2260361 2260361 2022-02-28 Blaine Montana 30005 1988 31
2257110 2257110 2022-02-27 Blaine Montana 30005 1987 31
2253859 2253859 2022-02-26 Blaine Montana 30005 1987 31
2250608 2250608 2022-02-25 Blaine Montana 30005 1987 31
2247357 2247357 2022-02-24 Blaine Montana 30005 1985 30
2244106 2244106 2022-02-23 Blaine Montana 30005 1983 30
2240855 2240855 2022-02-22 Blaine Montana 30005 1958 30
2237604 2237604 2022-02-21 Blaine Montana 30005 1955 30
2234353 2234353 2022-02-20 Blaine Montana 30005 1955 30
2231102 2231102 2022-02-19 Blaine Montana 30005 1955 30
2227851 2227851 2022-02-18 Blaine Montana 30005 1955 30
2224600 2224600 2022-02-17 Blaine Montana 30005 1955 29
2221349 2221349 2022-02-16 Blaine Montana 30005 1941 29
2218098 2218098 2022-02-15 Blaine Montana 30005 1937 29
2214847 2214847 2022-02-14 Blaine Montana 30005 1934 29
2211595 2211595 2022-02-13 Blaine Montana 30005 1925 29
2208342 2208342 2022-02-12 Blaine Montana 30005 1925 29
2205089 2205089 2022-02-11 Blaine Montana 30005 1925 29
2201836 2201836 2022-02-10 Blaine Montana 30005 1860 29
2198582 2198582 2022-02-09 Blaine Montana 30005 1813 29
2195328 2195328 2022-02-08 Blaine Montana 30005 1765 29
2192074 2192074 2022-02-07 Blaine Montana 30005 1760 28
2188821 2188821 2022-02-06 Blaine Montana 30005 1756 28
2185568 2185568 2022-02-05 Blaine Montana 30005 1756 28
2182316 2182316 2022-02-04 Blaine Montana 30005 1756 28
2179064 2179064 2022-02-03 Blaine Montana 30005 1749 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);