ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
647 rows where county = "Phillips" and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501228 | 2501228 | 2022-05-13 | Phillips | Montana | 30071 | 1060 | 28 |
2497970 | 2497970 | 2022-05-12 | Phillips | Montana | 30071 | 1060 | 28 |
2494712 | 2494712 | 2022-05-11 | Phillips | Montana | 30071 | 1060 | 28 |
2491454 | 2491454 | 2022-05-10 | Phillips | Montana | 30071 | 1060 | 28 |
2488196 | 2488196 | 2022-05-09 | Phillips | Montana | 30071 | 1060 | 28 |
2484939 | 2484939 | 2022-05-08 | Phillips | Montana | 30071 | 1060 | 28 |
2481681 | 2481681 | 2022-05-07 | Phillips | Montana | 30071 | 1060 | 28 |
2478423 | 2478423 | 2022-05-06 | Phillips | Montana | 30071 | 1060 | 28 |
2475165 | 2475165 | 2022-05-05 | Phillips | Montana | 30071 | 1061 | 28 |
2471908 | 2471908 | 2022-05-04 | Phillips | Montana | 30071 | 1061 | 28 |
2468652 | 2468652 | 2022-05-03 | Phillips | Montana | 30071 | 1061 | 28 |
2465396 | 2465396 | 2022-05-02 | Phillips | Montana | 30071 | 1061 | 28 |
2462141 | 2462141 | 2022-05-01 | Phillips | Montana | 30071 | 1061 | 28 |
2458885 | 2458885 | 2022-04-30 | Phillips | Montana | 30071 | 1061 | 28 |
2455629 | 2455629 | 2022-04-29 | Phillips | Montana | 30071 | 1061 | 28 |
2452373 | 2452373 | 2022-04-28 | Phillips | Montana | 30071 | 1061 | 28 |
2449117 | 2449117 | 2022-04-27 | Phillips | Montana | 30071 | 1062 | 28 |
2445860 | 2445860 | 2022-04-26 | Phillips | Montana | 30071 | 1062 | 28 |
2442605 | 2442605 | 2022-04-25 | Phillips | Montana | 30071 | 1062 | 28 |
2439349 | 2439349 | 2022-04-24 | Phillips | Montana | 30071 | 1062 | 28 |
2436093 | 2436093 | 2022-04-23 | Phillips | Montana | 30071 | 1062 | 28 |
2432837 | 2432837 | 2022-04-22 | Phillips | Montana | 30071 | 1062 | 28 |
2429581 | 2429581 | 2022-04-21 | Phillips | Montana | 30071 | 1062 | 28 |
2426325 | 2426325 | 2022-04-20 | Phillips | Montana | 30071 | 1062 | 28 |
2423069 | 2423069 | 2022-04-19 | Phillips | Montana | 30071 | 1062 | 28 |
2419812 | 2419812 | 2022-04-18 | Phillips | Montana | 30071 | 1062 | 28 |
2416557 | 2416557 | 2022-04-17 | Phillips | Montana | 30071 | 1062 | 28 |
2413301 | 2413301 | 2022-04-16 | Phillips | Montana | 30071 | 1062 | 28 |
2410045 | 2410045 | 2022-04-15 | Phillips | Montana | 30071 | 1062 | 28 |
2406789 | 2406789 | 2022-04-14 | Phillips | Montana | 30071 | 1062 | 28 |
2403533 | 2403533 | 2022-04-13 | Phillips | Montana | 30071 | 1062 | 28 |
2400278 | 2400278 | 2022-04-12 | Phillips | Montana | 30071 | 1062 | 28 |
2397023 | 2397023 | 2022-04-11 | Phillips | Montana | 30071 | 1062 | 28 |
2393768 | 2393768 | 2022-04-10 | Phillips | Montana | 30071 | 1062 | 28 |
2390512 | 2390512 | 2022-04-09 | Phillips | Montana | 30071 | 1062 | 28 |
2387256 | 2387256 | 2022-04-08 | Phillips | Montana | 30071 | 1062 | 28 |
2384001 | 2384001 | 2022-04-07 | Phillips | Montana | 30071 | 1062 | 28 |
2380746 | 2380746 | 2022-04-06 | Phillips | Montana | 30071 | 1062 | 28 |
2377491 | 2377491 | 2022-04-05 | Phillips | Montana | 30071 | 1062 | 28 |
2374238 | 2374238 | 2022-04-04 | Phillips | Montana | 30071 | 1062 | 28 |
2370986 | 2370986 | 2022-04-03 | Phillips | Montana | 30071 | 1062 | 28 |
2367733 | 2367733 | 2022-04-02 | Phillips | Montana | 30071 | 1062 | 28 |
2364480 | 2364480 | 2022-04-01 | Phillips | Montana | 30071 | 1062 | 28 |
2361226 | 2361226 | 2022-03-31 | Phillips | Montana | 30071 | 1062 | 28 |
2357972 | 2357972 | 2022-03-30 | Phillips | Montana | 30071 | 1062 | 28 |
2354719 | 2354719 | 2022-03-29 | Phillips | Montana | 30071 | 1061 | 28 |
2351466 | 2351466 | 2022-03-28 | Phillips | Montana | 30071 | 1061 | 28 |
2348214 | 2348214 | 2022-03-27 | Phillips | Montana | 30071 | 1061 | 28 |
2344961 | 2344961 | 2022-03-26 | Phillips | Montana | 30071 | 1061 | 28 |
2341708 | 2341708 | 2022-03-25 | Phillips | Montana | 30071 | 1061 | 28 |
2338455 | 2338455 | 2022-03-24 | Phillips | Montana | 30071 | 1062 | 28 |
2335201 | 2335201 | 2022-03-23 | Phillips | Montana | 30071 | 1062 | 28 |
2331947 | 2331947 | 2022-03-22 | Phillips | Montana | 30071 | 1059 | 28 |
2328694 | 2328694 | 2022-03-21 | Phillips | Montana | 30071 | 1059 | 28 |
2325442 | 2325442 | 2022-03-20 | Phillips | Montana | 30071 | 1059 | 28 |
2322188 | 2322188 | 2022-03-19 | Phillips | Montana | 30071 | 1059 | 28 |
2318934 | 2318934 | 2022-03-18 | Phillips | Montana | 30071 | 1059 | 28 |
2315681 | 2315681 | 2022-03-17 | Phillips | Montana | 30071 | 1059 | 28 |
2312428 | 2312428 | 2022-03-16 | Phillips | Montana | 30071 | 1056 | 28 |
2309175 | 2309175 | 2022-03-15 | Phillips | Montana | 30071 | 1056 | 28 |
2305923 | 2305923 | 2022-03-14 | Phillips | Montana | 30071 | 1055 | 28 |
2302672 | 2302672 | 2022-03-13 | Phillips | Montana | 30071 | 1055 | 28 |
2299420 | 2299420 | 2022-03-12 | Phillips | Montana | 30071 | 1055 | 28 |
2296168 | 2296168 | 2022-03-11 | Phillips | Montana | 30071 | 1055 | 28 |
2292916 | 2292916 | 2022-03-10 | Phillips | Montana | 30071 | 1054 | 28 |
2289664 | 2289664 | 2022-03-09 | Phillips | Montana | 30071 | 1054 | 28 |
2286412 | 2286412 | 2022-03-08 | Phillips | Montana | 30071 | 1053 | 28 |
2283160 | 2283160 | 2022-03-07 | Phillips | Montana | 30071 | 1053 | 28 |
2279907 | 2279907 | 2022-03-06 | Phillips | Montana | 30071 | 1053 | 28 |
2276654 | 2276654 | 2022-03-05 | Phillips | Montana | 30071 | 1053 | 28 |
2273401 | 2273401 | 2022-03-04 | Phillips | Montana | 30071 | 1053 | 28 |
2270149 | 2270149 | 2022-03-03 | Phillips | Montana | 30071 | 1045 | 28 |
2266896 | 2266896 | 2022-03-02 | Phillips | Montana | 30071 | 1044 | 28 |
2263645 | 2263645 | 2022-03-01 | Phillips | Montana | 30071 | 1041 | 28 |
2260394 | 2260394 | 2022-02-28 | Phillips | Montana | 30071 | 1038 | 28 |
2257143 | 2257143 | 2022-02-27 | Phillips | Montana | 30071 | 1038 | 28 |
2253892 | 2253892 | 2022-02-26 | Phillips | Montana | 30071 | 1038 | 28 |
2250641 | 2250641 | 2022-02-25 | Phillips | Montana | 30071 | 1038 | 28 |
2247390 | 2247390 | 2022-02-24 | Phillips | Montana | 30071 | 1038 | 28 |
2244139 | 2244139 | 2022-02-23 | Phillips | Montana | 30071 | 1037 | 28 |
2240888 | 2240888 | 2022-02-22 | Phillips | Montana | 30071 | 1037 | 28 |
2237637 | 2237637 | 2022-02-21 | Phillips | Montana | 30071 | 1037 | 28 |
2234386 | 2234386 | 2022-02-20 | Phillips | Montana | 30071 | 1037 | 28 |
2231135 | 2231135 | 2022-02-19 | Phillips | Montana | 30071 | 1037 | 28 |
2227884 | 2227884 | 2022-02-18 | Phillips | Montana | 30071 | 1037 | 28 |
2224633 | 2224633 | 2022-02-17 | Phillips | Montana | 30071 | 1034 | 28 |
2221382 | 2221382 | 2022-02-16 | Phillips | Montana | 30071 | 1032 | 28 |
2218131 | 2218131 | 2022-02-15 | Phillips | Montana | 30071 | 1030 | 28 |
2214880 | 2214880 | 2022-02-14 | Phillips | Montana | 30071 | 1028 | 28 |
2211628 | 2211628 | 2022-02-13 | Phillips | Montana | 30071 | 1028 | 28 |
2208375 | 2208375 | 2022-02-12 | Phillips | Montana | 30071 | 1028 | 28 |
2205122 | 2205122 | 2022-02-11 | Phillips | Montana | 30071 | 1028 | 28 |
2201869 | 2201869 | 2022-02-10 | Phillips | Montana | 30071 | 1021 | 28 |
2198615 | 2198615 | 2022-02-09 | Phillips | Montana | 30071 | 1013 | 28 |
2195361 | 2195361 | 2022-02-08 | Phillips | Montana | 30071 | 1008 | 28 |
2192107 | 2192107 | 2022-02-07 | Phillips | Montana | 30071 | 1004 | 28 |
2188854 | 2188854 | 2022-02-06 | Phillips | Montana | 30071 | 1003 | 28 |
2185601 | 2185601 | 2022-02-05 | Phillips | Montana | 30071 | 1003 | 28 |
2182349 | 2182349 | 2022-02-04 | Phillips | Montana | 30071 | 1003 | 28 |
2179097 | 2179097 | 2022-02-03 | Phillips | Montana | 30071 | 994 | 28 |
Advanced export
JSON shape: default, array, newline-delimited
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);