ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
834 rows where fips = 6085 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 |
---|---|---|---|---|---|---|---|
2499804 | 2499804 | 2022-05-13 | Santa Clara | California | 6085 | 342015 | 2298 |
2496546 | 2496546 | 2022-05-12 | Santa Clara | California | 6085 | 340266 | 2295 |
2493288 | 2493288 | 2022-05-11 | Santa Clara | California | 6085 | 340266 | 2295 |
2490030 | 2490030 | 2022-05-10 | Santa Clara | California | 6085 | 340266 | 2295 |
2486773 | 2486773 | 2022-05-09 | Santa Clara | California | 6085 | 338035 | 2288 |
2483515 | 2483515 | 2022-05-08 | Santa Clara | California | 6085 | 338035 | 2288 |
2480257 | 2480257 | 2022-05-07 | Santa Clara | California | 6085 | 338035 | 2288 |
2476999 | 2476999 | 2022-05-06 | Santa Clara | California | 6085 | 338035 | 2288 |
2473741 | 2473741 | 2022-05-05 | Santa Clara | California | 6085 | 335661 | 2286 |
2470484 | 2470484 | 2022-05-04 | Santa Clara | California | 6085 | 335661 | 2286 |
2467228 | 2467228 | 2022-05-03 | Santa Clara | California | 6085 | 335661 | 2286 |
2463973 | 2463973 | 2022-05-02 | Santa Clara | California | 6085 | 333565 | 2282 |
2460717 | 2460717 | 2022-05-01 | Santa Clara | California | 6085 | 333565 | 2282 |
2457461 | 2457461 | 2022-04-30 | Santa Clara | California | 6085 | 333565 | 2282 |
2454205 | 2454205 | 2022-04-29 | Santa Clara | California | 6085 | 333565 | 2282 |
2450949 | 2450949 | 2022-04-28 | Santa Clara | California | 6085 | 331774 | 2283 |
2447693 | 2447693 | 2022-04-27 | Santa Clara | California | 6085 | 331774 | 2283 |
2444437 | 2444437 | 2022-04-26 | Santa Clara | California | 6085 | 331774 | 2283 |
2441181 | 2441181 | 2022-04-25 | Santa Clara | California | 6085 | 330184 | 2278 |
2437925 | 2437925 | 2022-04-24 | Santa Clara | California | 6085 | 330184 | 2278 |
2434669 | 2434669 | 2022-04-23 | Santa Clara | California | 6085 | 330184 | 2278 |
2431413 | 2431413 | 2022-04-22 | Santa Clara | California | 6085 | 330184 | 2278 |
2428157 | 2428157 | 2022-04-21 | Santa Clara | California | 6085 | 328915 | 2275 |
2424901 | 2424901 | 2022-04-20 | Santa Clara | California | 6085 | 328915 | 2275 |
2421645 | 2421645 | 2022-04-19 | Santa Clara | California | 6085 | 328915 | 2275 |
2418389 | 2418389 | 2022-04-18 | Santa Clara | California | 6085 | 327856 | 2269 |
2415133 | 2415133 | 2022-04-17 | Santa Clara | California | 6085 | 327856 | 2269 |
2411877 | 2411877 | 2022-04-16 | Santa Clara | California | 6085 | 327856 | 2269 |
2408621 | 2408621 | 2022-04-15 | Santa Clara | California | 6085 | 327856 | 2269 |
2405365 | 2405365 | 2022-04-14 | Santa Clara | California | 6085 | 327423 | 2268 |
2402110 | 2402110 | 2022-04-13 | Santa Clara | California | 6085 | 326422 | 2267 |
2398855 | 2398855 | 2022-04-12 | Santa Clara | California | 6085 | 326422 | 2267 |
2395600 | 2395600 | 2022-04-11 | Santa Clara | California | 6085 | 326422 | 2267 |
2392344 | 2392344 | 2022-04-10 | Santa Clara | California | 6085 | 326422 | 2267 |
2389088 | 2389088 | 2022-04-09 | Santa Clara | California | 6085 | 326422 | 2267 |
2385833 | 2385833 | 2022-04-08 | Santa Clara | California | 6085 | 326422 | 2267 |
2382578 | 2382578 | 2022-04-07 | Santa Clara | California | 6085 | 325735 | 2266 |
2379323 | 2379323 | 2022-04-06 | Santa Clara | California | 6085 | 325735 | 2266 |
2376069 | 2376069 | 2022-04-05 | Santa Clara | California | 6085 | 325735 | 2266 |
2372817 | 2372817 | 2022-04-04 | Santa Clara | California | 6085 | 324974 | 2259 |
2369564 | 2369564 | 2022-04-03 | Santa Clara | California | 6085 | 324974 | 2259 |
2366311 | 2366311 | 2022-04-02 | Santa Clara | California | 6085 | 324974 | 2259 |
2363058 | 2363058 | 2022-04-01 | Santa Clara | California | 6085 | 324974 | 2259 |
2359804 | 2359804 | 2022-03-31 | Santa Clara | California | 6085 | 324710 | 2259 |
2356550 | 2356550 | 2022-03-30 | Santa Clara | California | 6085 | 324405 | 2260 |
2353297 | 2353297 | 2022-03-29 | Santa Clara | California | 6085 | 324291 | 2258 |
2350045 | 2350045 | 2022-03-28 | Santa Clara | California | 6085 | 324160 | 2258 |
2346792 | 2346792 | 2022-03-27 | Santa Clara | California | 6085 | 323527 | 2251 |
2343539 | 2343539 | 2022-03-26 | Santa Clara | California | 6085 | 323527 | 2251 |
2340286 | 2340286 | 2022-03-25 | Santa Clara | California | 6085 | 323527 | 2251 |
2337033 | 2337033 | 2022-03-24 | Santa Clara | California | 6085 | 323294 | 2251 |
2333779 | 2333779 | 2022-03-23 | Santa Clara | California | 6085 | 323072 | 2250 |
2330525 | 2330525 | 2022-03-22 | Santa Clara | California | 6085 | 322794 | 2246 |
2327273 | 2327273 | 2022-03-21 | Santa Clara | California | 6085 | 322697 | 2244 |
2324020 | 2324020 | 2022-03-20 | Santa Clara | California | 6085 | 322203 | 2226 |
2320766 | 2320766 | 2022-03-19 | Santa Clara | California | 6085 | 322203 | 2226 |
2317512 | 2317512 | 2022-03-18 | Santa Clara | California | 6085 | 322203 | 2226 |
2314259 | 2314259 | 2022-03-17 | Santa Clara | California | 6085 | 321974 | 2225 |
2311006 | 2311006 | 2022-03-16 | Santa Clara | California | 6085 | 321778 | 2225 |
2307753 | 2307753 | 2022-03-15 | Santa Clara | California | 6085 | 321843 | 2224 |
2304502 | 2304502 | 2022-03-14 | Santa Clara | California | 6085 | 321736 | 2226 |
2301250 | 2301250 | 2022-03-13 | Santa Clara | California | 6085 | 321232 | 2209 |
2297998 | 2297998 | 2022-03-12 | Santa Clara | California | 6085 | 321232 | 2209 |
2294746 | 2294746 | 2022-03-11 | Santa Clara | California | 6085 | 321232 | 2209 |
2291494 | 2291494 | 2022-03-10 | Santa Clara | California | 6085 | 321008 | 2207 |
2288242 | 2288242 | 2022-03-09 | Santa Clara | California | 6085 | 320725 | 2207 |
2284991 | 2284991 | 2022-03-08 | Santa Clara | California | 6085 | 320714 | 2203 |
2281739 | 2281739 | 2022-03-07 | Santa Clara | California | 6085 | 320447 | 2202 |
2278486 | 2278486 | 2022-03-06 | Santa Clara | California | 6085 | 319886 | 2196 |
2275233 | 2275233 | 2022-03-05 | Santa Clara | California | 6085 | 319886 | 2196 |
2271980 | 2271980 | 2022-03-04 | Santa Clara | California | 6085 | 319886 | 2196 |
2268728 | 2268728 | 2022-03-03 | Santa Clara | California | 6085 | 319551 | 2185 |
2265475 | 2265475 | 2022-03-02 | Santa Clara | California | 6085 | 319162 | 2191 |
2262224 | 2262224 | 2022-03-01 | Santa Clara | California | 6085 | 319114 | 2181 |
2258973 | 2258973 | 2022-02-28 | Santa Clara | California | 6085 | 318940 | 2181 |
2255722 | 2255722 | 2022-02-27 | Santa Clara | California | 6085 | 318079 | 2167 |
2252471 | 2252471 | 2022-02-26 | Santa Clara | California | 6085 | 318079 | 2167 |
2249220 | 2249220 | 2022-02-25 | Santa Clara | California | 6085 | 318079 | 2167 |
2245969 | 2245969 | 2022-02-24 | Santa Clara | California | 6085 | 317668 | 2158 |
2242718 | 2242718 | 2022-02-23 | Santa Clara | California | 6085 | 317086 | 2156 |
2239467 | 2239467 | 2022-02-22 | Santa Clara | California | 6085 | 316899 | 2159 |
2236216 | 2236216 | 2022-02-21 | Santa Clara | California | 6085 | 315118 | 2139 |
2232965 | 2232965 | 2022-02-20 | Santa Clara | California | 6085 | 315118 | 2139 |
2229714 | 2229714 | 2022-02-19 | Santa Clara | California | 6085 | 315118 | 2139 |
2226463 | 2226463 | 2022-02-18 | Santa Clara | California | 6085 | 315118 | 2139 |
2223212 | 2223212 | 2022-02-17 | Santa Clara | California | 6085 | 314480 | 2131 |
2219961 | 2219961 | 2022-02-16 | Santa Clara | California | 6085 | 314619 | 2131 |
2216710 | 2216710 | 2022-02-15 | Santa Clara | California | 6085 | 314107 | 2128 |
2213459 | 2213459 | 2022-02-14 | Santa Clara | California | 6085 | 313200 | 2115 |
2210207 | 2210207 | 2022-02-13 | Santa Clara | California | 6085 | 310964 | 2094 |
2206954 | 2206954 | 2022-02-12 | Santa Clara | California | 6085 | 310964 | 2094 |
2203701 | 2203701 | 2022-02-11 | Santa Clara | California | 6085 | 310964 | 2094 |
2200448 | 2200448 | 2022-02-10 | Santa Clara | California | 6085 | 309945 | 2092 |
2197194 | 2197194 | 2022-02-09 | Santa Clara | California | 6085 | 308556 | 2092 |
2193939 | 2193939 | 2022-02-08 | Santa Clara | California | 6085 | 306237 | 2086 |
2190686 | 2190686 | 2022-02-07 | Santa Clara | California | 6085 | 304609 | 2076 |
2187433 | 2187433 | 2022-02-06 | Santa Clara | California | 6085 | 302139 | 2068 |
2184180 | 2184180 | 2022-02-05 | Santa Clara | California | 6085 | 302139 | 2068 |
2180928 | 2180928 | 2022-02-04 | Santa Clara | California | 6085 | 302139 | 2068 |
2177677 | 2177677 | 2022-02-03 | Santa Clara | California | 6085 | 300320 | 2052 |
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);