ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Kern" and fips = 6029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499776 | 2499776 | 2022-05-13 | Kern | California | 6029 | 244681 | 2427 |
2496518 | 2496518 | 2022-05-12 | Kern | California | 6029 | 244205 | 2396 |
2493260 | 2493260 | 2022-05-11 | Kern | California | 6029 | 244205 | 2396 |
2490002 | 2490002 | 2022-05-10 | Kern | California | 6029 | 244205 | 2396 |
2486745 | 2486745 | 2022-05-09 | Kern | California | 6029 | 243954 | 2395 |
2483487 | 2483487 | 2022-05-08 | Kern | California | 6029 | 243954 | 2395 |
2480229 | 2480229 | 2022-05-07 | Kern | California | 6029 | 243954 | 2395 |
2476971 | 2476971 | 2022-05-06 | Kern | California | 6029 | 243954 | 2395 |
2473713 | 2473713 | 2022-05-05 | Kern | California | 6029 | 243687 | 2386 |
2470456 | 2470456 | 2022-05-04 | Kern | California | 6029 | 243687 | 2386 |
2467200 | 2467200 | 2022-05-03 | Kern | California | 6029 | 243687 | 2386 |
2463945 | 2463945 | 2022-05-02 | Kern | California | 6029 | 243475 | 2363 |
2460689 | 2460689 | 2022-05-01 | Kern | California | 6029 | 243475 | 2363 |
2457433 | 2457433 | 2022-04-30 | Kern | California | 6029 | 243475 | 2363 |
2454177 | 2454177 | 2022-04-29 | Kern | California | 6029 | 243475 | 2363 |
2450921 | 2450921 | 2022-04-28 | Kern | California | 6029 | 243325 | 2360 |
2447665 | 2447665 | 2022-04-27 | Kern | California | 6029 | 243325 | 2360 |
2444409 | 2444409 | 2022-04-26 | Kern | California | 6029 | 243325 | 2360 |
2441153 | 2441153 | 2022-04-25 | Kern | California | 6029 | 243186 | 2356 |
2437897 | 2437897 | 2022-04-24 | Kern | California | 6029 | 243186 | 2356 |
2434641 | 2434641 | 2022-04-23 | Kern | California | 6029 | 243186 | 2356 |
2431385 | 2431385 | 2022-04-22 | Kern | California | 6029 | 243186 | 2356 |
2428129 | 2428129 | 2022-04-21 | Kern | California | 6029 | 243003 | 2344 |
2424873 | 2424873 | 2022-04-20 | Kern | California | 6029 | 243003 | 2344 |
2421617 | 2421617 | 2022-04-19 | Kern | California | 6029 | 243003 | 2344 |
2418361 | 2418361 | 2022-04-18 | Kern | California | 6029 | 242888 | 2334 |
2415105 | 2415105 | 2022-04-17 | Kern | California | 6029 | 242888 | 2334 |
2411849 | 2411849 | 2022-04-16 | Kern | California | 6029 | 242888 | 2334 |
2408593 | 2408593 | 2022-04-15 | Kern | California | 6029 | 242888 | 2334 |
2405337 | 2405337 | 2022-04-14 | Kern | California | 6029 | 242803 | 2323 |
2402082 | 2402082 | 2022-04-13 | Kern | California | 6029 | 242803 | 2323 |
2398827 | 2398827 | 2022-04-12 | Kern | California | 6029 | 242803 | 2323 |
2395572 | 2395572 | 2022-04-11 | Kern | California | 6029 | 242682 | 2320 |
2392316 | 2392316 | 2022-04-10 | Kern | California | 6029 | 242682 | 2320 |
2389060 | 2389060 | 2022-04-09 | Kern | California | 6029 | 242682 | 2320 |
2385805 | 2385805 | 2022-04-08 | Kern | California | 6029 | 242682 | 2320 |
2382550 | 2382550 | 2022-04-07 | Kern | California | 6029 | 242598 | 2304 |
2379295 | 2379295 | 2022-04-06 | Kern | California | 6029 | 242598 | 2304 |
2376041 | 2376041 | 2022-04-05 | Kern | California | 6029 | 242598 | 2304 |
2372789 | 2372789 | 2022-04-04 | Kern | California | 6029 | 242458 | 2294 |
2369536 | 2369536 | 2022-04-03 | Kern | California | 6029 | 242458 | 2294 |
2366283 | 2366283 | 2022-04-02 | Kern | California | 6029 | 242458 | 2294 |
2363030 | 2363030 | 2022-04-01 | Kern | California | 6029 | 242458 | 2294 |
2359776 | 2359776 | 2022-03-31 | Kern | California | 6029 | 242345 | 2281 |
2356522 | 2356522 | 2022-03-30 | Kern | California | 6029 | 242345 | 2281 |
2353269 | 2353269 | 2022-03-29 | Kern | California | 6029 | 242261 | 2273 |
2350017 | 2350017 | 2022-03-28 | Kern | California | 6029 | 242261 | 2273 |
2346764 | 2346764 | 2022-03-27 | Kern | California | 6029 | 242196 | 2265 |
2343511 | 2343511 | 2022-03-26 | Kern | California | 6029 | 242196 | 2265 |
2340258 | 2340258 | 2022-03-25 | Kern | California | 6029 | 242196 | 2265 |
2337005 | 2337005 | 2022-03-24 | Kern | California | 6029 | 242104 | 2244 |
2333751 | 2333751 | 2022-03-23 | Kern | California | 6029 | 242104 | 2244 |
2330497 | 2330497 | 2022-03-22 | Kern | California | 6029 | 242015 | 2230 |
2327245 | 2327245 | 2022-03-21 | Kern | California | 6029 | 242015 | 2230 |
2323992 | 2323992 | 2022-03-20 | Kern | California | 6029 | 241875 | 2225 |
2320738 | 2320738 | 2022-03-19 | Kern | California | 6029 | 241875 | 2225 |
2317484 | 2317484 | 2022-03-18 | Kern | California | 6029 | 241875 | 2225 |
2314231 | 2314231 | 2022-03-17 | Kern | California | 6029 | 241765 | 2222 |
2310978 | 2310978 | 2022-03-16 | Kern | California | 6029 | 241657 | 2204 |
2307725 | 2307725 | 2022-03-15 | Kern | California | 6029 | 241421 | 2196 |
2304474 | 2304474 | 2022-03-14 | Kern | California | 6029 | 241233 | 2188 |
2301222 | 2301222 | 2022-03-13 | Kern | California | 6029 | 240904 | 2182 |
2297970 | 2297970 | 2022-03-12 | Kern | California | 6029 | 240904 | 2182 |
2294718 | 2294718 | 2022-03-11 | Kern | California | 6029 | 240904 | 2182 |
2291466 | 2291466 | 2022-03-10 | Kern | California | 6029 | 240705 | 2182 |
2288214 | 2288214 | 2022-03-09 | Kern | California | 6029 | 240530 | 2173 |
2284963 | 2284963 | 2022-03-08 | Kern | California | 6029 | 240461 | 2167 |
2281711 | 2281711 | 2022-03-07 | Kern | California | 6029 | 240299 | 2158 |
2278458 | 2278458 | 2022-03-06 | Kern | California | 6029 | 239635 | 2147 |
2275205 | 2275205 | 2022-03-05 | Kern | California | 6029 | 239635 | 2147 |
2271952 | 2271952 | 2022-03-04 | Kern | California | 6029 | 239635 | 2147 |
2268700 | 2268700 | 2022-03-03 | Kern | California | 6029 | 238866 | 2136 |
2265447 | 2265447 | 2022-03-02 | Kern | California | 6029 | 238120 | 2130 |
2262196 | 2262196 | 2022-03-01 | Kern | California | 6029 | 237530 | 2122 |
2258945 | 2258945 | 2022-02-28 | Kern | California | 6029 | 236843 | 2117 |
2255694 | 2255694 | 2022-02-27 | Kern | California | 6029 | 235765 | 2107 |
2252443 | 2252443 | 2022-02-26 | Kern | California | 6029 | 235765 | 2107 |
2249192 | 2249192 | 2022-02-25 | Kern | California | 6029 | 235765 | 2107 |
2245941 | 2245941 | 2022-02-24 | Kern | California | 6029 | 235122 | 2107 |
2242690 | 2242690 | 2022-02-23 | Kern | California | 6029 | 234269 | 2107 |
2239439 | 2239439 | 2022-02-22 | Kern | California | 6029 | 233501 | 2107 |
2236188 | 2236188 | 2022-02-21 | Kern | California | 6029 | 231871 | 2101 |
2232937 | 2232937 | 2022-02-20 | Kern | California | 6029 | 231871 | 2101 |
2229686 | 2229686 | 2022-02-19 | Kern | California | 6029 | 231871 | 2101 |
2226435 | 2226435 | 2022-02-18 | Kern | California | 6029 | 231871 | 2101 |
2223184 | 2223184 | 2022-02-17 | Kern | California | 6029 | 230630 | 2095 |
2219933 | 2219933 | 2022-02-16 | Kern | California | 6029 | 229772 | 2087 |
2216682 | 2216682 | 2022-02-15 | Kern | California | 6029 | 229034 | 2077 |
2213431 | 2213431 | 2022-02-14 | Kern | California | 6029 | 228153 | 2074 |
2210179 | 2210179 | 2022-02-13 | Kern | California | 6029 | 226717 | 2058 |
2206926 | 2206926 | 2022-02-12 | Kern | California | 6029 | 226717 | 2058 |
2203673 | 2203673 | 2022-02-11 | Kern | California | 6029 | 226717 | 2058 |
2200420 | 2200420 | 2022-02-10 | Kern | California | 6029 | 225509 | 2051 |
2197166 | 2197166 | 2022-02-09 | Kern | California | 6029 | 224771 | 2043 |
2193911 | 2193911 | 2022-02-08 | Kern | California | 6029 | 222651 | 2040 |
2190658 | 2190658 | 2022-02-07 | Kern | California | 6029 | 221944 | 2032 |
2187405 | 2187405 | 2022-02-06 | Kern | California | 6029 | 220089 | 2031 |
2184152 | 2184152 | 2022-02-05 | Kern | California | 6029 | 220089 | 2031 |
2180900 | 2180900 | 2022-02-04 | Kern | California | 6029 | 220089 | 2031 |
2177649 | 2177649 | 2022-02-03 | Kern | California | 6029 | 218219 | 2019 |
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);