ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
115 rows where county = "Routt" and deaths = 24 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 |
---|---|---|---|---|---|---|---|
2359874 | 2359874 | 2022-03-31 | Routt | Colorado | 8107 | 6370 | 24 |
2356620 | 2356620 | 2022-03-30 | Routt | Colorado | 8107 | 6359 | 24 |
2353367 | 2353367 | 2022-03-29 | Routt | Colorado | 8107 | 6356 | 24 |
2350115 | 2350115 | 2022-03-28 | Routt | Colorado | 8107 | 6351 | 24 |
2346862 | 2346862 | 2022-03-27 | Routt | Colorado | 8107 | 6344 | 24 |
2343609 | 2343609 | 2022-03-26 | Routt | Colorado | 8107 | 6344 | 24 |
2340356 | 2340356 | 2022-03-25 | Routt | Colorado | 8107 | 6344 | 24 |
2337103 | 2337103 | 2022-03-24 | Routt | Colorado | 8107 | 6335 | 24 |
2333849 | 2333849 | 2022-03-23 | Routt | Colorado | 8107 | 6332 | 24 |
2330595 | 2330595 | 2022-03-22 | Routt | Colorado | 8107 | 6324 | 24 |
2327343 | 2327343 | 2022-03-21 | Routt | Colorado | 8107 | 6321 | 24 |
2324090 | 2324090 | 2022-03-20 | Routt | Colorado | 8107 | 6312 | 24 |
2320836 | 2320836 | 2022-03-19 | Routt | Colorado | 8107 | 6312 | 24 |
2317582 | 2317582 | 2022-03-18 | Routt | Colorado | 8107 | 6312 | 24 |
2314329 | 2314329 | 2022-03-17 | Routt | Colorado | 8107 | 6312 | 24 |
2311076 | 2311076 | 2022-03-16 | Routt | Colorado | 8107 | 6308 | 24 |
2307823 | 2307823 | 2022-03-15 | Routt | Colorado | 8107 | 6300 | 24 |
2304572 | 2304572 | 2022-03-14 | Routt | Colorado | 8107 | 6293 | 24 |
2301320 | 2301320 | 2022-03-13 | Routt | Colorado | 8107 | 6288 | 24 |
2298068 | 2298068 | 2022-03-12 | Routt | Colorado | 8107 | 6288 | 24 |
2294816 | 2294816 | 2022-03-11 | Routt | Colorado | 8107 | 6288 | 24 |
2291564 | 2291564 | 2022-03-10 | Routt | Colorado | 8107 | 6283 | 24 |
2288312 | 2288312 | 2022-03-09 | Routt | Colorado | 8107 | 6279 | 24 |
2285061 | 2285061 | 2022-03-08 | Routt | Colorado | 8107 | 6269 | 24 |
2281809 | 2281809 | 2022-03-07 | Routt | Colorado | 8107 | 6266 | 24 |
2278556 | 2278556 | 2022-03-06 | Routt | Colorado | 8107 | 6192 | 24 |
2275303 | 2275303 | 2022-03-05 | Routt | Colorado | 8107 | 6192 | 24 |
2272050 | 2272050 | 2022-03-04 | Routt | Colorado | 8107 | 6192 | 24 |
2268798 | 2268798 | 2022-03-03 | Routt | Colorado | 8107 | 6184 | 24 |
2265545 | 2265545 | 2022-03-02 | Routt | Colorado | 8107 | 6176 | 24 |
2262294 | 2262294 | 2022-03-01 | Routt | Colorado | 8107 | 6172 | 24 |
2259043 | 2259043 | 2022-02-28 | Routt | Colorado | 8107 | 6166 | 24 |
2255792 | 2255792 | 2022-02-27 | Routt | Colorado | 8107 | 6148 | 24 |
2252541 | 2252541 | 2022-02-26 | Routt | Colorado | 8107 | 6148 | 24 |
2249290 | 2249290 | 2022-02-25 | Routt | Colorado | 8107 | 6148 | 24 |
2246039 | 2246039 | 2022-02-24 | Routt | Colorado | 8107 | 6137 | 24 |
2242788 | 2242788 | 2022-02-23 | Routt | Colorado | 8107 | 6128 | 24 |
2236286 | 2236286 | 2022-02-21 | Routt | Colorado | 8107 | 6110 | 24 |
2233035 | 2233035 | 2022-02-20 | Routt | Colorado | 8107 | 6091 | 24 |
2229784 | 2229784 | 2022-02-19 | Routt | Colorado | 8107 | 6091 | 24 |
2226533 | 2226533 | 2022-02-18 | Routt | Colorado | 8107 | 6091 | 24 |
2223282 | 2223282 | 2022-02-17 | Routt | Colorado | 8107 | 6083 | 24 |
2220031 | 2220031 | 2022-02-16 | Routt | Colorado | 8107 | 6082 | 24 |
2216780 | 2216780 | 2022-02-15 | Routt | Colorado | 8107 | 6073 | 24 |
2213529 | 2213529 | 2022-02-14 | Routt | Colorado | 8107 | 6066 | 24 |
2210277 | 2210277 | 2022-02-13 | Routt | Colorado | 8107 | 6059 | 24 |
2207024 | 2207024 | 2022-02-12 | Routt | Colorado | 8107 | 6059 | 24 |
2203771 | 2203771 | 2022-02-11 | Routt | Colorado | 8107 | 6059 | 24 |
2200518 | 2200518 | 2022-02-10 | Routt | Colorado | 8107 | 6053 | 24 |
2197264 | 2197264 | 2022-02-09 | Routt | Colorado | 8107 | 6048 | 24 |
2194010 | 2194010 | 2022-02-08 | Routt | Colorado | 8107 | 6033 | 24 |
2190756 | 2190756 | 2022-02-07 | Routt | Colorado | 8107 | 6022 | 24 |
2187503 | 2187503 | 2022-02-06 | Routt | Colorado | 8107 | 6005 | 24 |
2184250 | 2184250 | 2022-02-05 | Routt | Colorado | 8107 | 6005 | 24 |
2180998 | 2180998 | 2022-02-04 | Routt | Colorado | 8107 | 6005 | 24 |
2177747 | 2177747 | 2022-02-03 | Routt | Colorado | 8107 | 5986 | 24 |
2174494 | 2174494 | 2022-02-02 | Routt | Colorado | 8107 | 5963 | 24 |
2171241 | 2171241 | 2022-02-01 | Routt | Colorado | 8107 | 5944 | 24 |
2148464 | 2148464 | 2022-01-25 | Routt | Colorado | 8107 | 5836 | 24 |
2145212 | 2145212 | 2022-01-24 | Routt | Colorado | 8107 | 5813 | 24 |
2141957 | 2141957 | 2022-01-23 | Routt | Colorado | 8107 | 5721 | 24 |
2138702 | 2138702 | 2022-01-22 | Routt | Colorado | 8107 | 5721 | 24 |
2135446 | 2135446 | 2022-01-21 | Routt | Colorado | 8107 | 5721 | 24 |
2132194 | 2132194 | 2022-01-20 | Routt | Colorado | 8107 | 5684 | 24 |
2128941 | 2128941 | 2022-01-19 | Routt | Colorado | 8107 | 5641 | 24 |
2125687 | 2125687 | 2022-01-18 | Routt | Colorado | 8107 | 5575 | 24 |
2122435 | 2122435 | 2022-01-17 | Routt | Colorado | 8107 | 5540 | 24 |
2119183 | 2119183 | 2022-01-16 | Routt | Colorado | 8107 | 5439 | 24 |
2115931 | 2115931 | 2022-01-15 | Routt | Colorado | 8107 | 5439 | 24 |
2112680 | 2112680 | 2022-01-14 | Routt | Colorado | 8107 | 5439 | 24 |
2109428 | 2109428 | 2022-01-13 | Routt | Colorado | 8107 | 5355 | 24 |
2106177 | 2106177 | 2022-01-12 | Routt | Colorado | 8107 | 5268 | 24 |
2102926 | 2102926 | 2022-01-11 | Routt | Colorado | 8107 | 5161 | 24 |
2099675 | 2099675 | 2022-01-10 | Routt | Colorado | 8107 | 5064 | 24 |
2096424 | 2096424 | 2022-01-09 | Routt | Colorado | 8107 | 4788 | 24 |
2093172 | 2093172 | 2022-01-08 | Routt | Colorado | 8107 | 4788 | 24 |
2089920 | 2089920 | 2022-01-07 | Routt | Colorado | 8107 | 4788 | 24 |
2086669 | 2086669 | 2022-01-06 | Routt | Colorado | 8107 | 4755 | 24 |
2083417 | 2083417 | 2022-01-05 | Routt | Colorado | 8107 | 4662 | 24 |
2080165 | 2080165 | 2022-01-04 | Routt | Colorado | 8107 | 4589 | 24 |
2076913 | 2076913 | 2022-01-03 | Routt | Colorado | 8107 | 4525 | 24 |
2073662 | 2073662 | 2022-01-02 | Routt | Colorado | 8107 | 4358 | 24 |
2070411 | 2070411 | 2022-01-01 | Routt | Colorado | 8107 | 4358 | 24 |
2067160 | 2067160 | 2021-12-31 | Routt | Colorado | 8107 | 4358 | 24 |
2063909 | 2063909 | 2021-12-30 | Routt | Colorado | 8107 | 4304 | 24 |
2060659 | 2060659 | 2021-12-29 | Routt | Colorado | 8107 | 4219 | 24 |
2057410 | 2057410 | 2021-12-28 | Routt | Colorado | 8107 | 4148 | 24 |
2054161 | 2054161 | 2021-12-27 | Routt | Colorado | 8107 | 4043 | 24 |
2050911 | 2050911 | 2021-12-26 | Routt | Colorado | 8107 | 4009 | 24 |
2047661 | 2047661 | 2021-12-25 | Routt | Colorado | 8107 | 4009 | 24 |
2044411 | 2044411 | 2021-12-24 | Routt | Colorado | 8107 | 4009 | 24 |
2041162 | 2041162 | 2021-12-23 | Routt | Colorado | 8107 | 3979 | 24 |
2037912 | 2037912 | 2021-12-22 | Routt | Colorado | 8107 | 3958 | 24 |
2034662 | 2034662 | 2021-12-21 | Routt | Colorado | 8107 | 3948 | 24 |
2031412 | 2031412 | 2021-12-20 | Routt | Colorado | 8107 | 3938 | 24 |
2028161 | 2028161 | 2021-12-19 | Routt | Colorado | 8107 | 3920 | 24 |
2024910 | 2024910 | 2021-12-18 | Routt | Colorado | 8107 | 3920 | 24 |
2021659 | 2021659 | 2021-12-17 | Routt | Colorado | 8107 | 3920 | 24 |
2018408 | 2018408 | 2021-12-16 | Routt | Colorado | 8107 | 3915 | 24 |
2015158 | 2015158 | 2021-12-15 | Routt | Colorado | 8107 | 3913 | 24 |
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);