ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
687 rows where county = "Clearwater" and fips = 16035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500150 | 2500150 | 2022-05-13 | Clearwater | Idaho | 16035 | 2324 | 33 |
2496892 | 2496892 | 2022-05-12 | Clearwater | Idaho | 16035 | 2323 | 33 |
2493634 | 2493634 | 2022-05-11 | Clearwater | Idaho | 16035 | 2323 | 33 |
2490376 | 2490376 | 2022-05-10 | Clearwater | Idaho | 16035 | 2318 | 33 |
2487119 | 2487119 | 2022-05-09 | Clearwater | Idaho | 16035 | 2318 | 33 |
2483861 | 2483861 | 2022-05-08 | Clearwater | Idaho | 16035 | 2318 | 33 |
2480603 | 2480603 | 2022-05-07 | Clearwater | Idaho | 16035 | 2318 | 33 |
2477345 | 2477345 | 2022-05-06 | Clearwater | Idaho | 16035 | 2318 | 33 |
2474087 | 2474087 | 2022-05-05 | Clearwater | Idaho | 16035 | 2314 | 33 |
2470830 | 2470830 | 2022-05-04 | Clearwater | Idaho | 16035 | 2314 | 33 |
2467574 | 2467574 | 2022-05-03 | Clearwater | Idaho | 16035 | 2312 | 33 |
2464319 | 2464319 | 2022-05-02 | Clearwater | Idaho | 16035 | 2312 | 33 |
2461063 | 2461063 | 2022-05-01 | Clearwater | Idaho | 16035 | 2311 | 33 |
2457807 | 2457807 | 2022-04-30 | Clearwater | Idaho | 16035 | 2311 | 33 |
2454551 | 2454551 | 2022-04-29 | Clearwater | Idaho | 16035 | 2311 | 33 |
2451295 | 2451295 | 2022-04-28 | Clearwater | Idaho | 16035 | 2311 | 33 |
2448039 | 2448039 | 2022-04-27 | Clearwater | Idaho | 16035 | 2311 | 33 |
2444783 | 2444783 | 2022-04-26 | Clearwater | Idaho | 16035 | 2310 | 33 |
2441527 | 2441527 | 2022-04-25 | Clearwater | Idaho | 16035 | 2310 | 33 |
2438271 | 2438271 | 2022-04-24 | Clearwater | Idaho | 16035 | 2308 | 33 |
2435015 | 2435015 | 2022-04-23 | Clearwater | Idaho | 16035 | 2308 | 33 |
2431759 | 2431759 | 2022-04-22 | Clearwater | Idaho | 16035 | 2308 | 33 |
2428503 | 2428503 | 2022-04-21 | Clearwater | Idaho | 16035 | 2307 | 33 |
2425247 | 2425247 | 2022-04-20 | Clearwater | Idaho | 16035 | 2307 | 33 |
2421991 | 2421991 | 2022-04-19 | Clearwater | Idaho | 16035 | 2306 | 33 |
2418735 | 2418735 | 2022-04-18 | Clearwater | Idaho | 16035 | 2306 | 33 |
2415479 | 2415479 | 2022-04-17 | Clearwater | Idaho | 16035 | 2305 | 33 |
2412223 | 2412223 | 2022-04-16 | Clearwater | Idaho | 16035 | 2305 | 33 |
2408967 | 2408967 | 2022-04-15 | Clearwater | Idaho | 16035 | 2305 | 33 |
2405711 | 2405711 | 2022-04-14 | Clearwater | Idaho | 16035 | 2305 | 33 |
2402456 | 2402456 | 2022-04-13 | Clearwater | Idaho | 16035 | 2304 | 33 |
2399201 | 2399201 | 2022-04-12 | Clearwater | Idaho | 16035 | 2303 | 33 |
2395946 | 2395946 | 2022-04-11 | Clearwater | Idaho | 16035 | 2302 | 33 |
2392690 | 2392690 | 2022-04-10 | Clearwater | Idaho | 16035 | 2302 | 33 |
2389434 | 2389434 | 2022-04-09 | Clearwater | Idaho | 16035 | 2302 | 33 |
2386179 | 2386179 | 2022-04-08 | Clearwater | Idaho | 16035 | 2302 | 33 |
2382924 | 2382924 | 2022-04-07 | Clearwater | Idaho | 16035 | 2302 | 33 |
2379669 | 2379669 | 2022-04-06 | Clearwater | Idaho | 16035 | 2302 | 33 |
2376415 | 2376415 | 2022-04-05 | Clearwater | Idaho | 16035 | 2301 | 33 |
2373163 | 2373163 | 2022-04-04 | Clearwater | Idaho | 16035 | 2300 | 33 |
2369910 | 2369910 | 2022-04-03 | Clearwater | Idaho | 16035 | 2298 | 33 |
2366657 | 2366657 | 2022-04-02 | Clearwater | Idaho | 16035 | 2298 | 33 |
2363404 | 2363404 | 2022-04-01 | Clearwater | Idaho | 16035 | 2298 | 33 |
2360150 | 2360150 | 2022-03-31 | Clearwater | Idaho | 16035 | 2298 | 33 |
2356896 | 2356896 | 2022-03-30 | Clearwater | Idaho | 16035 | 2297 | 33 |
2353643 | 2353643 | 2022-03-29 | Clearwater | Idaho | 16035 | 2297 | 33 |
2350391 | 2350391 | 2022-03-28 | Clearwater | Idaho | 16035 | 2297 | 33 |
2347138 | 2347138 | 2022-03-27 | Clearwater | Idaho | 16035 | 2295 | 33 |
2343885 | 2343885 | 2022-03-26 | Clearwater | Idaho | 16035 | 2295 | 33 |
2340632 | 2340632 | 2022-03-25 | Clearwater | Idaho | 16035 | 2295 | 33 |
2337379 | 2337379 | 2022-03-24 | Clearwater | Idaho | 16035 | 2290 | 33 |
2334125 | 2334125 | 2022-03-23 | Clearwater | Idaho | 16035 | 2289 | 33 |
2330871 | 2330871 | 2022-03-22 | Clearwater | Idaho | 16035 | 2289 | 33 |
2327619 | 2327619 | 2022-03-21 | Clearwater | Idaho | 16035 | 2289 | 32 |
2324366 | 2324366 | 2022-03-20 | Clearwater | Idaho | 16035 | 2288 | 32 |
2321112 | 2321112 | 2022-03-19 | Clearwater | Idaho | 16035 | 2288 | 32 |
2317858 | 2317858 | 2022-03-18 | Clearwater | Idaho | 16035 | 2288 | 32 |
2314605 | 2314605 | 2022-03-17 | Clearwater | Idaho | 16035 | 2287 | 32 |
2311352 | 2311352 | 2022-03-16 | Clearwater | Idaho | 16035 | 2285 | 32 |
2308099 | 2308099 | 2022-03-15 | Clearwater | Idaho | 16035 | 2282 | 32 |
2304848 | 2304848 | 2022-03-14 | Clearwater | Idaho | 16035 | 2281 | 32 |
2301596 | 2301596 | 2022-03-13 | Clearwater | Idaho | 16035 | 2279 | 32 |
2298344 | 2298344 | 2022-03-12 | Clearwater | Idaho | 16035 | 2279 | 32 |
2295092 | 2295092 | 2022-03-11 | Clearwater | Idaho | 16035 | 2279 | 32 |
2291840 | 2291840 | 2022-03-10 | Clearwater | Idaho | 16035 | 2278 | 32 |
2288588 | 2288588 | 2022-03-09 | Clearwater | Idaho | 16035 | 2275 | 31 |
2285337 | 2285337 | 2022-03-08 | Clearwater | Idaho | 16035 | 2272 | 31 |
2282085 | 2282085 | 2022-03-07 | Clearwater | Idaho | 16035 | 2268 | 31 |
2278832 | 2278832 | 2022-03-06 | Clearwater | Idaho | 16035 | 2261 | 31 |
2275579 | 2275579 | 2022-03-05 | Clearwater | Idaho | 16035 | 2261 | 31 |
2272326 | 2272326 | 2022-03-04 | Clearwater | Idaho | 16035 | 2261 | 31 |
2269074 | 2269074 | 2022-03-03 | Clearwater | Idaho | 16035 | 2258 | 31 |
2265821 | 2265821 | 2022-03-02 | Clearwater | Idaho | 16035 | 2246 | 31 |
2262570 | 2262570 | 2022-03-01 | Clearwater | Idaho | 16035 | 2200 | 31 |
2259319 | 2259319 | 2022-02-28 | Clearwater | Idaho | 16035 | 2190 | 31 |
2256068 | 2256068 | 2022-02-27 | Clearwater | Idaho | 16035 | 2189 | 31 |
2252817 | 2252817 | 2022-02-26 | Clearwater | Idaho | 16035 | 2189 | 31 |
2249566 | 2249566 | 2022-02-25 | Clearwater | Idaho | 16035 | 2189 | 31 |
2246315 | 2246315 | 2022-02-24 | Clearwater | Idaho | 16035 | 2185 | 31 |
2243064 | 2243064 | 2022-02-23 | Clearwater | Idaho | 16035 | 2185 | 31 |
2239813 | 2239813 | 2022-02-22 | Clearwater | Idaho | 16035 | 2183 | 31 |
2236562 | 2236562 | 2022-02-21 | Clearwater | Idaho | 16035 | 2179 | 31 |
2233311 | 2233311 | 2022-02-20 | Clearwater | Idaho | 16035 | 2179 | 31 |
2230060 | 2230060 | 2022-02-19 | Clearwater | Idaho | 16035 | 2179 | 31 |
2226809 | 2226809 | 2022-02-18 | Clearwater | Idaho | 16035 | 2179 | 31 |
2223558 | 2223558 | 2022-02-17 | Clearwater | Idaho | 16035 | 2178 | 31 |
2220307 | 2220307 | 2022-02-16 | Clearwater | Idaho | 16035 | 2175 | 31 |
2217056 | 2217056 | 2022-02-15 | Clearwater | Idaho | 16035 | 2175 | 31 |
2213805 | 2213805 | 2022-02-14 | Clearwater | Idaho | 16035 | 2173 | 31 |
2210553 | 2210553 | 2022-02-13 | Clearwater | Idaho | 16035 | 2169 | 31 |
2207300 | 2207300 | 2022-02-12 | Clearwater | Idaho | 16035 | 2169 | 31 |
2204047 | 2204047 | 2022-02-11 | Clearwater | Idaho | 16035 | 2169 | 31 |
2200794 | 2200794 | 2022-02-10 | Clearwater | Idaho | 16035 | 2164 | 31 |
2197540 | 2197540 | 2022-02-09 | Clearwater | Idaho | 16035 | 2160 | 31 |
2194286 | 2194286 | 2022-02-08 | Clearwater | Idaho | 16035 | 2149 | 31 |
2191032 | 2191032 | 2022-02-07 | Clearwater | Idaho | 16035 | 2141 | 31 |
2187779 | 2187779 | 2022-02-06 | Clearwater | Idaho | 16035 | 2132 | 31 |
2184526 | 2184526 | 2022-02-05 | Clearwater | Idaho | 16035 | 2132 | 31 |
2181274 | 2181274 | 2022-02-04 | Clearwater | Idaho | 16035 | 2132 | 31 |
2178023 | 2178023 | 2022-02-03 | Clearwater | Idaho | 16035 | 2119 | 31 |
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);