ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 6101 and state = "California" 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 |
---|---|---|---|---|---|---|---|
2499812 | 2499812 | 2022-05-13 | Sutter | California | 6101 | 23045 | 234 |
2496554 | 2496554 | 2022-05-12 | Sutter | California | 6101 | 23045 | 234 |
2493296 | 2493296 | 2022-05-11 | Sutter | California | 6101 | 23045 | 234 |
2490038 | 2490038 | 2022-05-10 | Sutter | California | 6101 | 22967 | 233 |
2486781 | 2486781 | 2022-05-09 | Sutter | California | 6101 | 22967 | 233 |
2483523 | 2483523 | 2022-05-08 | Sutter | California | 6101 | 22967 | 233 |
2480265 | 2480265 | 2022-05-07 | Sutter | California | 6101 | 22967 | 233 |
2477007 | 2477007 | 2022-05-06 | Sutter | California | 6101 | 22967 | 233 |
2473749 | 2473749 | 2022-05-05 | Sutter | California | 6101 | 22967 | 233 |
2470492 | 2470492 | 2022-05-04 | Sutter | California | 6101 | 22967 | 233 |
2467236 | 2467236 | 2022-05-03 | Sutter | California | 6101 | 22890 | 233 |
2463981 | 2463981 | 2022-05-02 | Sutter | California | 6101 | 22890 | 233 |
2460725 | 2460725 | 2022-05-01 | Sutter | California | 6101 | 22890 | 233 |
2457469 | 2457469 | 2022-04-30 | Sutter | California | 6101 | 22890 | 233 |
2454213 | 2454213 | 2022-04-29 | Sutter | California | 6101 | 22890 | 233 |
2450957 | 2450957 | 2022-04-28 | Sutter | California | 6101 | 22890 | 233 |
2447701 | 2447701 | 2022-04-27 | Sutter | California | 6101 | 22890 | 233 |
2444445 | 2444445 | 2022-04-26 | Sutter | California | 6101 | 22854 | 233 |
2441189 | 2441189 | 2022-04-25 | Sutter | California | 6101 | 22854 | 233 |
2437933 | 2437933 | 2022-04-24 | Sutter | California | 6101 | 22854 | 233 |
2434677 | 2434677 | 2022-04-23 | Sutter | California | 6101 | 22854 | 233 |
2431421 | 2431421 | 2022-04-22 | Sutter | California | 6101 | 22854 | 233 |
2428165 | 2428165 | 2022-04-21 | Sutter | California | 6101 | 22854 | 233 |
2424909 | 2424909 | 2022-04-20 | Sutter | California | 6101 | 22854 | 233 |
2421653 | 2421653 | 2022-04-19 | Sutter | California | 6101 | 22768 | 233 |
2418397 | 2418397 | 2022-04-18 | Sutter | California | 6101 | 22768 | 233 |
2415141 | 2415141 | 2022-04-17 | Sutter | California | 6101 | 22768 | 233 |
2411885 | 2411885 | 2022-04-16 | Sutter | California | 6101 | 22768 | 233 |
2408629 | 2408629 | 2022-04-15 | Sutter | California | 6101 | 22768 | 233 |
2405373 | 2405373 | 2022-04-14 | Sutter | California | 6101 | 22768 | 233 |
2402118 | 2402118 | 2022-04-13 | Sutter | California | 6101 | 22768 | 233 |
2398863 | 2398863 | 2022-04-12 | Sutter | California | 6101 | 22727 | 232 |
2395608 | 2395608 | 2022-04-11 | Sutter | California | 6101 | 22727 | 232 |
2392352 | 2392352 | 2022-04-10 | Sutter | California | 6101 | 22727 | 232 |
2389096 | 2389096 | 2022-04-09 | Sutter | California | 6101 | 22727 | 232 |
2385841 | 2385841 | 2022-04-08 | Sutter | California | 6101 | 22727 | 232 |
2382586 | 2382586 | 2022-04-07 | Sutter | California | 6101 | 22727 | 232 |
2379331 | 2379331 | 2022-04-06 | Sutter | California | 6101 | 22727 | 232 |
2376077 | 2376077 | 2022-04-05 | Sutter | California | 6101 | 22675 | 231 |
2372825 | 2372825 | 2022-04-04 | Sutter | California | 6101 | 22672 | 231 |
2369572 | 2369572 | 2022-04-03 | Sutter | California | 6101 | 22672 | 231 |
2366319 | 2366319 | 2022-04-02 | Sutter | California | 6101 | 22672 | 231 |
2363066 | 2363066 | 2022-04-01 | Sutter | California | 6101 | 22672 | 231 |
2359812 | 2359812 | 2022-03-31 | Sutter | California | 6101 | 22672 | 231 |
2356558 | 2356558 | 2022-03-30 | Sutter | California | 6101 | 22672 | 231 |
2353305 | 2353305 | 2022-03-29 | Sutter | California | 6101 | 22627 | 230 |
2350053 | 2350053 | 2022-03-28 | Sutter | California | 6101 | 22623 | 230 |
2346800 | 2346800 | 2022-03-27 | Sutter | California | 6101 | 22619 | 230 |
2343547 | 2343547 | 2022-03-26 | Sutter | California | 6101 | 22619 | 230 |
2340294 | 2340294 | 2022-03-25 | Sutter | California | 6101 | 22619 | 230 |
2337041 | 2337041 | 2022-03-24 | Sutter | California | 6101 | 22619 | 230 |
2333787 | 2333787 | 2022-03-23 | Sutter | California | 6101 | 22619 | 230 |
2330533 | 2330533 | 2022-03-22 | Sutter | California | 6101 | 22528 | 226 |
2327281 | 2327281 | 2022-03-21 | Sutter | California | 6101 | 22524 | 226 |
2324028 | 2324028 | 2022-03-20 | Sutter | California | 6101 | 22518 | 226 |
2320774 | 2320774 | 2022-03-19 | Sutter | California | 6101 | 22518 | 226 |
2317520 | 2317520 | 2022-03-18 | Sutter | California | 6101 | 22518 | 226 |
2314267 | 2314267 | 2022-03-17 | Sutter | California | 6101 | 22518 | 226 |
2311014 | 2311014 | 2022-03-16 | Sutter | California | 6101 | 22456 | 225 |
2307761 | 2307761 | 2022-03-15 | Sutter | California | 6101 | 22454 | 225 |
2304510 | 2304510 | 2022-03-14 | Sutter | California | 6101 | 22450 | 225 |
2301258 | 2301258 | 2022-03-13 | Sutter | California | 6101 | 22446 | 225 |
2298006 | 2298006 | 2022-03-12 | Sutter | California | 6101 | 22446 | 225 |
2294754 | 2294754 | 2022-03-11 | Sutter | California | 6101 | 22446 | 225 |
2291502 | 2291502 | 2022-03-10 | Sutter | California | 6101 | 22446 | 225 |
2288250 | 2288250 | 2022-03-09 | Sutter | California | 6101 | 22413 | 225 |
2284999 | 2284999 | 2022-03-08 | Sutter | California | 6101 | 22366 | 225 |
2281747 | 2281747 | 2022-03-07 | Sutter | California | 6101 | 22300 | 225 |
2278494 | 2278494 | 2022-03-06 | Sutter | California | 6101 | 22300 | 225 |
2275241 | 2275241 | 2022-03-05 | Sutter | California | 6101 | 22300 | 225 |
2271988 | 2271988 | 2022-03-04 | Sutter | California | 6101 | 22300 | 225 |
2268736 | 2268736 | 2022-03-03 | Sutter | California | 6101 | 22300 | 225 |
2265483 | 2265483 | 2022-03-02 | Sutter | California | 6101 | 22202 | 225 |
2262232 | 2262232 | 2022-03-01 | Sutter | California | 6101 | 22169 | 224 |
2258981 | 2258981 | 2022-02-28 | Sutter | California | 6101 | 22108 | 222 |
2255730 | 2255730 | 2022-02-27 | Sutter | California | 6101 | 22068 | 222 |
2252479 | 2252479 | 2022-02-26 | Sutter | California | 6101 | 22068 | 222 |
2249228 | 2249228 | 2022-02-25 | Sutter | California | 6101 | 22068 | 222 |
2245977 | 2245977 | 2022-02-24 | Sutter | California | 6101 | 22037 | 221 |
2242726 | 2242726 | 2022-02-23 | Sutter | California | 6101 | 22007 | 220 |
2239475 | 2239475 | 2022-02-22 | Sutter | California | 6101 | 21943 | 218 |
2236224 | 2236224 | 2022-02-21 | Sutter | California | 6101 | 21894 | 218 |
2232973 | 2232973 | 2022-02-20 | Sutter | California | 6101 | 21894 | 218 |
2229722 | 2229722 | 2022-02-19 | Sutter | California | 6101 | 21894 | 218 |
2226471 | 2226471 | 2022-02-18 | Sutter | California | 6101 | 21894 | 218 |
2223220 | 2223220 | 2022-02-17 | Sutter | California | 6101 | 21839 | 218 |
2219969 | 2219969 | 2022-02-16 | Sutter | California | 6101 | 21781 | 218 |
2216718 | 2216718 | 2022-02-15 | Sutter | California | 6101 | 21746 | 217 |
2213467 | 2213467 | 2022-02-14 | Sutter | California | 6101 | 21746 | 217 |
2210215 | 2210215 | 2022-02-13 | Sutter | California | 6101 | 21566 | 217 |
2206962 | 2206962 | 2022-02-12 | Sutter | California | 6101 | 21566 | 217 |
2203709 | 2203709 | 2022-02-11 | Sutter | California | 6101 | 21566 | 217 |
2200456 | 2200456 | 2022-02-10 | Sutter | California | 6101 | 21524 | 217 |
2197202 | 2197202 | 2022-02-09 | Sutter | California | 6101 | 21403 | 215 |
2193947 | 2193947 | 2022-02-08 | Sutter | California | 6101 | 21403 | 215 |
2190694 | 2190694 | 2022-02-07 | Sutter | California | 6101 | 21269 | 211 |
2187441 | 2187441 | 2022-02-06 | Sutter | California | 6101 | 21075 | 211 |
2184188 | 2184188 | 2022-02-05 | Sutter | California | 6101 | 21075 | 211 |
2180936 | 2180936 | 2022-02-04 | Sutter | California | 6101 | 21075 | 211 |
2177685 | 2177685 | 2022-02-03 | Sutter | California | 6101 | 20959 | 211 |
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);