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

778 rows where fips = 30067 and state = "Montana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Montana · 778 ✖

fips 1

  • 30067 · 778 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501226 2501226 2022-05-13 Park Montana 30067 4260 35
2497968 2497968 2022-05-12 Park Montana 30067 4232 35
2494710 2494710 2022-05-11 Park Montana 30067 4232 35
2491452 2491452 2022-05-10 Park Montana 30067 4232 35
2488194 2488194 2022-05-09 Park Montana 30067 4232 35
2484937 2484937 2022-05-08 Park Montana 30067 4232 35
2481679 2481679 2022-05-07 Park Montana 30067 4232 35
2478421 2478421 2022-05-06 Park Montana 30067 4232 35
2475163 2475163 2022-05-05 Park Montana 30067 4228 35
2471906 2471906 2022-05-04 Park Montana 30067 4225 35
2468650 2468650 2022-05-03 Park Montana 30067 4224 35
2465394 2465394 2022-05-02 Park Montana 30067 4217 35
2462139 2462139 2022-05-01 Park Montana 30067 4212 35
2458883 2458883 2022-04-30 Park Montana 30067 4212 35
2455627 2455627 2022-04-29 Park Montana 30067 4212 35
2452371 2452371 2022-04-28 Park Montana 30067 4211 35
2449115 2449115 2022-04-27 Park Montana 30067 4208 35
2445858 2445858 2022-04-26 Park Montana 30067 4202 35
2442603 2442603 2022-04-25 Park Montana 30067 4201 35
2439347 2439347 2022-04-24 Park Montana 30067 4200 35
2436091 2436091 2022-04-23 Park Montana 30067 4200 35
2432835 2432835 2022-04-22 Park Montana 30067 4200 35
2429579 2429579 2022-04-21 Park Montana 30067 4196 35
2426323 2426323 2022-04-20 Park Montana 30067 4194 35
2423067 2423067 2022-04-19 Park Montana 30067 4191 35
2419810 2419810 2022-04-18 Park Montana 30067 4191 35
2416555 2416555 2022-04-17 Park Montana 30067 4189 35
2413299 2413299 2022-04-16 Park Montana 30067 4189 35
2410043 2410043 2022-04-15 Park Montana 30067 4189 35
2406787 2406787 2022-04-14 Park Montana 30067 4189 35
2403531 2403531 2022-04-13 Park Montana 30067 4189 35
2400276 2400276 2022-04-12 Park Montana 30067 4187 35
2397021 2397021 2022-04-11 Park Montana 30067 4184 35
2393766 2393766 2022-04-10 Park Montana 30067 4179 35
2390510 2390510 2022-04-09 Park Montana 30067 4179 35
2387254 2387254 2022-04-08 Park Montana 30067 4179 35
2383999 2383999 2022-04-07 Park Montana 30067 4179 35
2380744 2380744 2022-04-06 Park Montana 30067 4177 35
2377489 2377489 2022-04-05 Park Montana 30067 4176 35
2374236 2374236 2022-04-04 Park Montana 30067 4176 35
2370984 2370984 2022-04-03 Park Montana 30067 4175 35
2367731 2367731 2022-04-02 Park Montana 30067 4175 35
2364478 2364478 2022-04-01 Park Montana 30067 4175 35
2361224 2361224 2022-03-31 Park Montana 30067 4172 35
2357970 2357970 2022-03-30 Park Montana 30067 4172 35
2354717 2354717 2022-03-29 Park Montana 30067 4172 35
2351464 2351464 2022-03-28 Park Montana 30067 4171 35
2348212 2348212 2022-03-27 Park Montana 30067 4170 35
2344959 2344959 2022-03-26 Park Montana 30067 4170 35
2341706 2341706 2022-03-25 Park Montana 30067 4170 35
2338453 2338453 2022-03-24 Park Montana 30067 4170 35
2335199 2335199 2022-03-23 Park Montana 30067 4169 35
2331945 2331945 2022-03-22 Park Montana 30067 4167 35
2328692 2328692 2022-03-21 Park Montana 30067 4165 35
2325440 2325440 2022-03-20 Park Montana 30067 4164 35
2322186 2322186 2022-03-19 Park Montana 30067 4164 35
2318932 2318932 2022-03-18 Park Montana 30067 4164 35
2315679 2315679 2022-03-17 Park Montana 30067 4161 35
2312426 2312426 2022-03-16 Park Montana 30067 4160 34
2309173 2309173 2022-03-15 Park Montana 30067 4159 34
2305921 2305921 2022-03-14 Park Montana 30067 4158 34
2302670 2302670 2022-03-13 Park Montana 30067 4156 34
2299418 2299418 2022-03-12 Park Montana 30067 4156 34
2296166 2296166 2022-03-11 Park Montana 30067 4156 34
2292914 2292914 2022-03-10 Park Montana 30067 4153 34
2289662 2289662 2022-03-09 Park Montana 30067 4150 34
2286410 2286410 2022-03-08 Park Montana 30067 4150 34
2283158 2283158 2022-03-07 Park Montana 30067 4150 34
2279905 2279905 2022-03-06 Park Montana 30067 4149 34
2276652 2276652 2022-03-05 Park Montana 30067 4149 34
2273399 2273399 2022-03-04 Park Montana 30067 4149 34
2270147 2270147 2022-03-03 Park Montana 30067 4062 34
2266894 2266894 2022-03-02 Park Montana 30067 4057 34
2263643 2263643 2022-03-01 Park Montana 30067 4046 34
2260392 2260392 2022-02-28 Park Montana 30067 4058 34
2257141 2257141 2022-02-27 Park Montana 30067 4054 34
2253890 2253890 2022-02-26 Park Montana 30067 4054 34
2250639 2250639 2022-02-25 Park Montana 30067 4054 34
2247388 2247388 2022-02-24 Park Montana 30067 4052 34
2244137 2244137 2022-02-23 Park Montana 30067 4050 33
2240886 2240886 2022-02-22 Park Montana 30067 4048 33
2237635 2237635 2022-02-21 Park Montana 30067 4038 33
2234384 2234384 2022-02-20 Park Montana 30067 4038 33
2231133 2231133 2022-02-19 Park Montana 30067 4038 33
2227882 2227882 2022-02-18 Park Montana 30067 4038 33
2224631 2224631 2022-02-17 Park Montana 30067 4023 33
2221380 2221380 2022-02-16 Park Montana 30067 4013 33
2218129 2218129 2022-02-15 Park Montana 30067 3985 33
2214878 2214878 2022-02-14 Park Montana 30067 3963 33
2211626 2211626 2022-02-13 Park Montana 30067 3949 33
2208373 2208373 2022-02-12 Park Montana 30067 3949 33
2205120 2205120 2022-02-11 Park Montana 30067 3949 33
2201867 2201867 2022-02-10 Park Montana 30067 3920 33
2198613 2198613 2022-02-09 Park Montana 30067 3863 33
2195359 2195359 2022-02-08 Park Montana 30067 3822 33
2192105 2192105 2022-02-07 Park Montana 30067 3803 33
2188852 2188852 2022-02-06 Park Montana 30067 3777 33
2185599 2185599 2022-02-05 Park Montana 30067 3777 33
2182347 2182347 2022-02-04 Park Montana 30067 3777 33
2179095 2179095 2022-02-03 Park Montana 30067 3717 33

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