ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,464 rows where county = "Clearwater" 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 |
---|---|---|---|---|---|---|---|
2500150 | 2500150 | 2022-05-13 | Clearwater | Idaho | 16035 | 2324 | 33 |
2500919 | 2500919 | 2022-05-13 | Clearwater | Minnesota | 27029 | 2175 | 30 |
2496892 | 2496892 | 2022-05-12 | Clearwater | Idaho | 16035 | 2323 | 33 |
2497661 | 2497661 | 2022-05-12 | Clearwater | Minnesota | 27029 | 2175 | 30 |
2493634 | 2493634 | 2022-05-11 | Clearwater | Idaho | 16035 | 2323 | 33 |
2494403 | 2494403 | 2022-05-11 | Clearwater | Minnesota | 27029 | 2175 | 30 |
2490376 | 2490376 | 2022-05-10 | Clearwater | Idaho | 16035 | 2318 | 33 |
2491145 | 2491145 | 2022-05-10 | Clearwater | Minnesota | 27029 | 2174 | 30 |
2487119 | 2487119 | 2022-05-09 | Clearwater | Idaho | 16035 | 2318 | 33 |
2487888 | 2487888 | 2022-05-09 | Clearwater | Minnesota | 27029 | 2173 | 30 |
2483861 | 2483861 | 2022-05-08 | Clearwater | Idaho | 16035 | 2318 | 33 |
2484630 | 2484630 | 2022-05-08 | Clearwater | Minnesota | 27029 | 2169 | 30 |
2480603 | 2480603 | 2022-05-07 | Clearwater | Idaho | 16035 | 2318 | 33 |
2481372 | 2481372 | 2022-05-07 | Clearwater | Minnesota | 27029 | 2169 | 30 |
2477345 | 2477345 | 2022-05-06 | Clearwater | Idaho | 16035 | 2318 | 33 |
2478114 | 2478114 | 2022-05-06 | Clearwater | Minnesota | 27029 | 2169 | 30 |
2474087 | 2474087 | 2022-05-05 | Clearwater | Idaho | 16035 | 2314 | 33 |
2474856 | 2474856 | 2022-05-05 | Clearwater | Minnesota | 27029 | 2169 | 30 |
2470830 | 2470830 | 2022-05-04 | Clearwater | Idaho | 16035 | 2314 | 33 |
2471599 | 2471599 | 2022-05-04 | Clearwater | Minnesota | 27029 | 2167 | 30 |
2467574 | 2467574 | 2022-05-03 | Clearwater | Idaho | 16035 | 2312 | 33 |
2468343 | 2468343 | 2022-05-03 | Clearwater | Minnesota | 27029 | 2167 | 30 |
2464319 | 2464319 | 2022-05-02 | Clearwater | Idaho | 16035 | 2312 | 33 |
2465088 | 2465088 | 2022-05-02 | Clearwater | Minnesota | 27029 | 2166 | 30 |
2461063 | 2461063 | 2022-05-01 | Clearwater | Idaho | 16035 | 2311 | 33 |
2461832 | 2461832 | 2022-05-01 | Clearwater | Minnesota | 27029 | 2165 | 30 |
2457807 | 2457807 | 2022-04-30 | Clearwater | Idaho | 16035 | 2311 | 33 |
2458576 | 2458576 | 2022-04-30 | Clearwater | Minnesota | 27029 | 2165 | 30 |
2454551 | 2454551 | 2022-04-29 | Clearwater | Idaho | 16035 | 2311 | 33 |
2455320 | 2455320 | 2022-04-29 | Clearwater | Minnesota | 27029 | 2165 | 30 |
2451295 | 2451295 | 2022-04-28 | Clearwater | Idaho | 16035 | 2311 | 33 |
2452064 | 2452064 | 2022-04-28 | Clearwater | Minnesota | 27029 | 2165 | 30 |
2448039 | 2448039 | 2022-04-27 | Clearwater | Idaho | 16035 | 2311 | 33 |
2448808 | 2448808 | 2022-04-27 | Clearwater | Minnesota | 27029 | 2163 | 30 |
2444783 | 2444783 | 2022-04-26 | Clearwater | Idaho | 16035 | 2310 | 33 |
2445552 | 2445552 | 2022-04-26 | Clearwater | Minnesota | 27029 | 2162 | 30 |
2441527 | 2441527 | 2022-04-25 | Clearwater | Idaho | 16035 | 2310 | 33 |
2442296 | 2442296 | 2022-04-25 | Clearwater | Minnesota | 27029 | 2161 | 30 |
2438271 | 2438271 | 2022-04-24 | Clearwater | Idaho | 16035 | 2308 | 33 |
2439040 | 2439040 | 2022-04-24 | Clearwater | Minnesota | 27029 | 2158 | 30 |
2435015 | 2435015 | 2022-04-23 | Clearwater | Idaho | 16035 | 2308 | 33 |
2435784 | 2435784 | 2022-04-23 | Clearwater | Minnesota | 27029 | 2158 | 30 |
2431759 | 2431759 | 2022-04-22 | Clearwater | Idaho | 16035 | 2308 | 33 |
2432528 | 2432528 | 2022-04-22 | Clearwater | Minnesota | 27029 | 2158 | 30 |
2428503 | 2428503 | 2022-04-21 | Clearwater | Idaho | 16035 | 2307 | 33 |
2429272 | 2429272 | 2022-04-21 | Clearwater | Minnesota | 27029 | 2157 | 30 |
2425247 | 2425247 | 2022-04-20 | Clearwater | Idaho | 16035 | 2307 | 33 |
2426016 | 2426016 | 2022-04-20 | Clearwater | Minnesota | 27029 | 2157 | 30 |
2421991 | 2421991 | 2022-04-19 | Clearwater | Idaho | 16035 | 2306 | 33 |
2422760 | 2422760 | 2022-04-19 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2418735 | 2418735 | 2022-04-18 | Clearwater | Idaho | 16035 | 2306 | 33 |
2419504 | 2419504 | 2022-04-18 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2415479 | 2415479 | 2022-04-17 | Clearwater | Idaho | 16035 | 2305 | 33 |
2416248 | 2416248 | 2022-04-17 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2412223 | 2412223 | 2022-04-16 | Clearwater | Idaho | 16035 | 2305 | 33 |
2412992 | 2412992 | 2022-04-16 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2408967 | 2408967 | 2022-04-15 | Clearwater | Idaho | 16035 | 2305 | 33 |
2409736 | 2409736 | 2022-04-15 | Clearwater | Minnesota | 27029 | 2155 | 30 |
2405711 | 2405711 | 2022-04-14 | Clearwater | Idaho | 16035 | 2305 | 33 |
2406480 | 2406480 | 2022-04-14 | Clearwater | Minnesota | 27029 | 2154 | 30 |
2402456 | 2402456 | 2022-04-13 | Clearwater | Idaho | 16035 | 2304 | 33 |
2403224 | 2403224 | 2022-04-13 | Clearwater | Minnesota | 27029 | 2154 | 30 |
2399201 | 2399201 | 2022-04-12 | Clearwater | Idaho | 16035 | 2303 | 33 |
2399970 | 2399970 | 2022-04-12 | Clearwater | Minnesota | 27029 | 2154 | 30 |
2395946 | 2395946 | 2022-04-11 | Clearwater | Idaho | 16035 | 2302 | 33 |
2396714 | 2396714 | 2022-04-11 | Clearwater | Minnesota | 27029 | 2154 | 30 |
2392690 | 2392690 | 2022-04-10 | Clearwater | Idaho | 16035 | 2302 | 33 |
2393459 | 2393459 | 2022-04-10 | Clearwater | Minnesota | 27029 | 2153 | 30 |
2389434 | 2389434 | 2022-04-09 | Clearwater | Idaho | 16035 | 2302 | 33 |
2390203 | 2390203 | 2022-04-09 | Clearwater | Minnesota | 27029 | 2153 | 30 |
2386179 | 2386179 | 2022-04-08 | Clearwater | Idaho | 16035 | 2302 | 33 |
2386947 | 2386947 | 2022-04-08 | Clearwater | Minnesota | 27029 | 2153 | 30 |
2382924 | 2382924 | 2022-04-07 | Clearwater | Idaho | 16035 | 2302 | 33 |
2383692 | 2383692 | 2022-04-07 | Clearwater | Minnesota | 27029 | 2153 | 30 |
2379669 | 2379669 | 2022-04-06 | Clearwater | Idaho | 16035 | 2302 | 33 |
2380437 | 2380437 | 2022-04-06 | Clearwater | Minnesota | 27029 | 2153 | 30 |
2376415 | 2376415 | 2022-04-05 | Clearwater | Idaho | 16035 | 2301 | 33 |
2377182 | 2377182 | 2022-04-05 | Clearwater | Minnesota | 27029 | 2153 | 30 |
2373163 | 2373163 | 2022-04-04 | Clearwater | Idaho | 16035 | 2300 | 33 |
2373930 | 2373930 | 2022-04-04 | Clearwater | Minnesota | 27029 | 2152 | 30 |
2369910 | 2369910 | 2022-04-03 | Clearwater | Idaho | 16035 | 2298 | 33 |
2370677 | 2370677 | 2022-04-03 | Clearwater | Minnesota | 27029 | 2152 | 30 |
2366657 | 2366657 | 2022-04-02 | Clearwater | Idaho | 16035 | 2298 | 33 |
2367424 | 2367424 | 2022-04-02 | Clearwater | Minnesota | 27029 | 2152 | 30 |
2363404 | 2363404 | 2022-04-01 | Clearwater | Idaho | 16035 | 2298 | 33 |
2364171 | 2364171 | 2022-04-01 | Clearwater | Minnesota | 27029 | 2152 | 30 |
2360150 | 2360150 | 2022-03-31 | Clearwater | Idaho | 16035 | 2298 | 33 |
2360917 | 2360917 | 2022-03-31 | Clearwater | Minnesota | 27029 | 2152 | 30 |
2356896 | 2356896 | 2022-03-30 | Clearwater | Idaho | 16035 | 2297 | 33 |
2357663 | 2357663 | 2022-03-30 | Clearwater | Minnesota | 27029 | 2150 | 30 |
2353643 | 2353643 | 2022-03-29 | Clearwater | Idaho | 16035 | 2297 | 33 |
2354410 | 2354410 | 2022-03-29 | Clearwater | Minnesota | 27029 | 2149 | 30 |
2350391 | 2350391 | 2022-03-28 | Clearwater | Idaho | 16035 | 2297 | 33 |
2351158 | 2351158 | 2022-03-28 | Clearwater | Minnesota | 27029 | 2148 | 30 |
2347138 | 2347138 | 2022-03-27 | Clearwater | Idaho | 16035 | 2295 | 33 |
2347905 | 2347905 | 2022-03-27 | Clearwater | Minnesota | 27029 | 2148 | 30 |
2343885 | 2343885 | 2022-03-26 | Clearwater | Idaho | 16035 | 2295 | 33 |
2344652 | 2344652 | 2022-03-26 | Clearwater | Minnesota | 27029 | 2148 | 30 |
2340632 | 2340632 | 2022-03-25 | Clearwater | Idaho | 16035 | 2295 | 33 |
2341399 | 2341399 | 2022-03-25 | Clearwater | Minnesota | 27029 | 2148 | 30 |
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);