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

779 rows where fips = 30053 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 · 779 ✖

fips 1

  • 30053 · 779 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501219 2501219 2022-05-13 Lincoln Montana 30053 4787 89
2497961 2497961 2022-05-12 Lincoln Montana 30053 4784 89
2494703 2494703 2022-05-11 Lincoln Montana 30053 4784 89
2491445 2491445 2022-05-10 Lincoln Montana 30053 4784 89
2488187 2488187 2022-05-09 Lincoln Montana 30053 4784 89
2484930 2484930 2022-05-08 Lincoln Montana 30053 4784 89
2481672 2481672 2022-05-07 Lincoln Montana 30053 4784 89
2478414 2478414 2022-05-06 Lincoln Montana 30053 4784 89
2475156 2475156 2022-05-05 Lincoln Montana 30053 4782 89
2471899 2471899 2022-05-04 Lincoln Montana 30053 4779 89
2468643 2468643 2022-05-03 Lincoln Montana 30053 4777 89
2465387 2465387 2022-05-02 Lincoln Montana 30053 4777 89
2462132 2462132 2022-05-01 Lincoln Montana 30053 4762 89
2458876 2458876 2022-04-30 Lincoln Montana 30053 4762 89
2455620 2455620 2022-04-29 Lincoln Montana 30053 4762 89
2452364 2452364 2022-04-28 Lincoln Montana 30053 4756 89
2449108 2449108 2022-04-27 Lincoln Montana 30053 4757 88
2445851 2445851 2022-04-26 Lincoln Montana 30053 4756 88
2442596 2442596 2022-04-25 Lincoln Montana 30053 4751 88
2439340 2439340 2022-04-24 Lincoln Montana 30053 4751 86
2436084 2436084 2022-04-23 Lincoln Montana 30053 4751 86
2432828 2432828 2022-04-22 Lincoln Montana 30053 4751 86
2429572 2429572 2022-04-21 Lincoln Montana 30053 4750 86
2426316 2426316 2022-04-20 Lincoln Montana 30053 4750 86
2423060 2423060 2022-04-19 Lincoln Montana 30053 4743 86
2419803 2419803 2022-04-18 Lincoln Montana 30053 4730 86
2416548 2416548 2022-04-17 Lincoln Montana 30053 4729 86
2413292 2413292 2022-04-16 Lincoln Montana 30053 4729 86
2410036 2410036 2022-04-15 Lincoln Montana 30053 4729 86
2406780 2406780 2022-04-14 Lincoln Montana 30053 4728 86
2403524 2403524 2022-04-13 Lincoln Montana 30053 4728 86
2400269 2400269 2022-04-12 Lincoln Montana 30053 4728 86
2397014 2397014 2022-04-11 Lincoln Montana 30053 4726 86
2393759 2393759 2022-04-10 Lincoln Montana 30053 4725 86
2390503 2390503 2022-04-09 Lincoln Montana 30053 4725 86
2387247 2387247 2022-04-08 Lincoln Montana 30053 4725 86
2383992 2383992 2022-04-07 Lincoln Montana 30053 4725 86
2380737 2380737 2022-04-06 Lincoln Montana 30053 4723 86
2377482 2377482 2022-04-05 Lincoln Montana 30053 4721 86
2374229 2374229 2022-04-04 Lincoln Montana 30053 4721 86
2370977 2370977 2022-04-03 Lincoln Montana 30053 4719 86
2367724 2367724 2022-04-02 Lincoln Montana 30053 4719 86
2364471 2364471 2022-04-01 Lincoln Montana 30053 4719 86
2361217 2361217 2022-03-31 Lincoln Montana 30053 4718 86
2357963 2357963 2022-03-30 Lincoln Montana 30053 4718 86
2354710 2354710 2022-03-29 Lincoln Montana 30053 4718 86
2351457 2351457 2022-03-28 Lincoln Montana 30053 4717 86
2348205 2348205 2022-03-27 Lincoln Montana 30053 4717 86
2344952 2344952 2022-03-26 Lincoln Montana 30053 4717 86
2341699 2341699 2022-03-25 Lincoln Montana 30053 4717 86
2338446 2338446 2022-03-24 Lincoln Montana 30053 4714 86
2335192 2335192 2022-03-23 Lincoln Montana 30053 4711 86
2331938 2331938 2022-03-22 Lincoln Montana 30053 4711 86
2328685 2328685 2022-03-21 Lincoln Montana 30053 4706 86
2325433 2325433 2022-03-20 Lincoln Montana 30053 4704 86
2322179 2322179 2022-03-19 Lincoln Montana 30053 4704 86
2318925 2318925 2022-03-18 Lincoln Montana 30053 4704 86
2315672 2315672 2022-03-17 Lincoln Montana 30053 4701 86
2312419 2312419 2022-03-16 Lincoln Montana 30053 4697 86
2309166 2309166 2022-03-15 Lincoln Montana 30053 4696 86
2305914 2305914 2022-03-14 Lincoln Montana 30053 4685 86
2302663 2302663 2022-03-13 Lincoln Montana 30053 4684 86
2299411 2299411 2022-03-12 Lincoln Montana 30053 4684 86
2296159 2296159 2022-03-11 Lincoln Montana 30053 4684 86
2292907 2292907 2022-03-10 Lincoln Montana 30053 4683 86
2289655 2289655 2022-03-09 Lincoln Montana 30053 4681 86
2286403 2286403 2022-03-08 Lincoln Montana 30053 4674 86
2283151 2283151 2022-03-07 Lincoln Montana 30053 4669 86
2279898 2279898 2022-03-06 Lincoln Montana 30053 4664 81
2276645 2276645 2022-03-05 Lincoln Montana 30053 4664 81
2273392 2273392 2022-03-04 Lincoln Montana 30053 4664 81
2270140 2270140 2022-03-03 Lincoln Montana 30053 4656 81
2266887 2266887 2022-03-02 Lincoln Montana 30053 4653 81
2263636 2263636 2022-03-01 Lincoln Montana 30053 4653 81
2260385 2260385 2022-02-28 Lincoln Montana 30053 4650 81
2257134 2257134 2022-02-27 Lincoln Montana 30053 4635 81
2253883 2253883 2022-02-26 Lincoln Montana 30053 4635 81
2250632 2250632 2022-02-25 Lincoln Montana 30053 4635 81
2247381 2247381 2022-02-24 Lincoln Montana 30053 4629 81
2244130 2244130 2022-02-23 Lincoln Montana 30053 4619 80
2240879 2240879 2022-02-22 Lincoln Montana 30053 4613 80
2237628 2237628 2022-02-21 Lincoln Montana 30053 4565 79
2234377 2234377 2022-02-20 Lincoln Montana 30053 4565 79
2231126 2231126 2022-02-19 Lincoln Montana 30053 4565 79
2227875 2227875 2022-02-18 Lincoln Montana 30053 4565 79
2224624 2224624 2022-02-17 Lincoln Montana 30053 4552 80
2221373 2221373 2022-02-16 Lincoln Montana 30053 4546 77
2218122 2218122 2022-02-15 Lincoln Montana 30053 4545 77
2214871 2214871 2022-02-14 Lincoln Montana 30053 4537 77
2211619 2211619 2022-02-13 Lincoln Montana 30053 4525 77
2208366 2208366 2022-02-12 Lincoln Montana 30053 4525 77
2205113 2205113 2022-02-11 Lincoln Montana 30053 4525 77
2201860 2201860 2022-02-10 Lincoln Montana 30053 4516 77
2198606 2198606 2022-02-09 Lincoln Montana 30053 4493 77
2195352 2195352 2022-02-08 Lincoln Montana 30053 4485 77
2192098 2192098 2022-02-07 Lincoln Montana 30053 4462 77
2188845 2188845 2022-02-06 Lincoln Montana 30053 4427 77
2185592 2185592 2022-02-05 Lincoln Montana 30053 4427 77
2182340 2182340 2022-02-04 Lincoln Montana 30053 4427 77
2179088 2179088 2022-02-03 Lincoln Montana 30053 4386 77

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