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

764 rows where fips = 30003 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 · 764 ✖

fips 1

  • 30003 · 764 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501194 2501194 2022-05-13 Big Horn Montana 30003 4980 96
2497936 2497936 2022-05-12 Big Horn Montana 30003 4976 95
2494678 2494678 2022-05-11 Big Horn Montana 30003 4976 95
2491420 2491420 2022-05-10 Big Horn Montana 30003 4976 95
2488162 2488162 2022-05-09 Big Horn Montana 30003 4976 95
2484905 2484905 2022-05-08 Big Horn Montana 30003 4976 95
2481647 2481647 2022-05-07 Big Horn Montana 30003 4976 95
2478389 2478389 2022-05-06 Big Horn Montana 30003 4976 95
2475131 2475131 2022-05-05 Big Horn Montana 30003 4975 95
2471874 2471874 2022-05-04 Big Horn Montana 30003 4975 95
2468618 2468618 2022-05-03 Big Horn Montana 30003 4971 95
2465362 2465362 2022-05-02 Big Horn Montana 30003 4969 95
2462107 2462107 2022-05-01 Big Horn Montana 30003 4969 95
2458851 2458851 2022-04-30 Big Horn Montana 30003 4969 95
2455595 2455595 2022-04-29 Big Horn Montana 30003 4969 95
2452339 2452339 2022-04-28 Big Horn Montana 30003 4968 94
2449083 2449083 2022-04-27 Big Horn Montana 30003 4967 94
2445826 2445826 2022-04-26 Big Horn Montana 30003 4967 94
2442571 2442571 2022-04-25 Big Horn Montana 30003 4966 94
2439315 2439315 2022-04-24 Big Horn Montana 30003 4964 94
2436059 2436059 2022-04-23 Big Horn Montana 30003 4964 94
2432803 2432803 2022-04-22 Big Horn Montana 30003 4964 94
2429547 2429547 2022-04-21 Big Horn Montana 30003 4963 94
2426291 2426291 2022-04-20 Big Horn Montana 30003 4961 94
2423035 2423035 2022-04-19 Big Horn Montana 30003 4961 94
2419778 2419778 2022-04-18 Big Horn Montana 30003 4961 94
2416523 2416523 2022-04-17 Big Horn Montana 30003 4960 94
2413267 2413267 2022-04-16 Big Horn Montana 30003 4960 94
2410011 2410011 2022-04-15 Big Horn Montana 30003 4960 94
2406755 2406755 2022-04-14 Big Horn Montana 30003 4959 94
2403499 2403499 2022-04-13 Big Horn Montana 30003 4958 94
2400244 2400244 2022-04-12 Big Horn Montana 30003 4957 94
2396989 2396989 2022-04-11 Big Horn Montana 30003 4956 92
2393734 2393734 2022-04-10 Big Horn Montana 30003 4956 92
2390478 2390478 2022-04-09 Big Horn Montana 30003 4956 92
2387222 2387222 2022-04-08 Big Horn Montana 30003 4956 92
2383967 2383967 2022-04-07 Big Horn Montana 30003 4956 92
2380712 2380712 2022-04-06 Big Horn Montana 30003 4956 92
2377457 2377457 2022-04-05 Big Horn Montana 30003 4956 92
2374204 2374204 2022-04-04 Big Horn Montana 30003 4956 92
2370952 2370952 2022-04-03 Big Horn Montana 30003 4956 92
2367699 2367699 2022-04-02 Big Horn Montana 30003 4956 92
2364446 2364446 2022-04-01 Big Horn Montana 30003 4956 92
2361192 2361192 2022-03-31 Big Horn Montana 30003 4956 92
2357938 2357938 2022-03-30 Big Horn Montana 30003 4956 92
2354685 2354685 2022-03-29 Big Horn Montana 30003 4955 92
2351432 2351432 2022-03-28 Big Horn Montana 30003 4954 92
2348180 2348180 2022-03-27 Big Horn Montana 30003 4953 92
2344927 2344927 2022-03-26 Big Horn Montana 30003 4953 92
2341674 2341674 2022-03-25 Big Horn Montana 30003 4953 92
2338421 2338421 2022-03-24 Big Horn Montana 30003 4953 92
2335167 2335167 2022-03-23 Big Horn Montana 30003 4953 92
2331913 2331913 2022-03-22 Big Horn Montana 30003 4954 92
2328660 2328660 2022-03-21 Big Horn Montana 30003 4951 92
2325408 2325408 2022-03-20 Big Horn Montana 30003 4951 92
2322154 2322154 2022-03-19 Big Horn Montana 30003 4951 92
2318900 2318900 2022-03-18 Big Horn Montana 30003 4951 92
2315647 2315647 2022-03-17 Big Horn Montana 30003 4951 92
2312394 2312394 2022-03-16 Big Horn Montana 30003 4951 92
2309141 2309141 2022-03-15 Big Horn Montana 30003 4951 92
2305889 2305889 2022-03-14 Big Horn Montana 30003 4951 92
2302638 2302638 2022-03-13 Big Horn Montana 30003 4949 92
2299386 2299386 2022-03-12 Big Horn Montana 30003 4949 92
2296134 2296134 2022-03-11 Big Horn Montana 30003 4949 92
2292882 2292882 2022-03-10 Big Horn Montana 30003 4949 92
2289630 2289630 2022-03-09 Big Horn Montana 30003 4947 92
2286378 2286378 2022-03-08 Big Horn Montana 30003 4945 92
2283126 2283126 2022-03-07 Big Horn Montana 30003 4943 91
2279873 2279873 2022-03-06 Big Horn Montana 30003 4941 92
2276620 2276620 2022-03-05 Big Horn Montana 30003 4941 92
2273367 2273367 2022-03-04 Big Horn Montana 30003 4941 92
2270115 2270115 2022-03-03 Big Horn Montana 30003 4788 92
2266862 2266862 2022-03-02 Big Horn Montana 30003 4778 92
2263611 2263611 2022-03-01 Big Horn Montana 30003 4784 92
2260360 2260360 2022-02-28 Big Horn Montana 30003 4782 92
2257109 2257109 2022-02-27 Big Horn Montana 30003 4780 92
2253858 2253858 2022-02-26 Big Horn Montana 30003 4780 92
2250607 2250607 2022-02-25 Big Horn Montana 30003 4780 92
2247356 2247356 2022-02-24 Big Horn Montana 30003 4776 92
2244105 2244105 2022-02-23 Big Horn Montana 30003 4775 92
2240854 2240854 2022-02-22 Big Horn Montana 30003 4775 91
2237603 2237603 2022-02-21 Big Horn Montana 30003 4713 89
2234352 2234352 2022-02-20 Big Horn Montana 30003 4713 89
2231101 2231101 2022-02-19 Big Horn Montana 30003 4713 89
2227850 2227850 2022-02-18 Big Horn Montana 30003 4713 89
2224599 2224599 2022-02-17 Big Horn Montana 30003 4660 89
2221348 2221348 2022-02-16 Big Horn Montana 30003 4645 89
2218097 2218097 2022-02-15 Big Horn Montana 30003 4591 89
2214846 2214846 2022-02-14 Big Horn Montana 30003 4552 89
2211594 2211594 2022-02-13 Big Horn Montana 30003 4450 89
2208341 2208341 2022-02-12 Big Horn Montana 30003 4450 89
2205088 2205088 2022-02-11 Big Horn Montana 30003 4450 89
2201835 2201835 2022-02-10 Big Horn Montana 30003 4391 89
2198581 2198581 2022-02-09 Big Horn Montana 30003 4342 89
2195327 2195327 2022-02-08 Big Horn Montana 30003 4312 89
2192073 2192073 2022-02-07 Big Horn Montana 30003 4259 89
2188820 2188820 2022-02-06 Big Horn Montana 30003 4194 89
2185567 2185567 2022-02-05 Big Horn Montana 30003 4194 89
2182315 2182315 2022-02-04 Big Horn Montana 30003 4194 89
2179063 2179063 2022-02-03 Big Horn Montana 30003 4116 89

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