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 deaths 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 |
2490030 | 2490030 | 2022-05-10 | Santa Clara | California | 6085 | 340266 | 2295 |
2493288 | 2493288 | 2022-05-11 | Santa Clara | California | 6085 | 340266 | 2295 |
2496546 | 2496546 | 2022-05-12 | Santa Clara | California | 6085 | 340266 | 2295 |
2476999 | 2476999 | 2022-05-06 | Santa Clara | California | 6085 | 338035 | 2288 |
2480257 | 2480257 | 2022-05-07 | Santa Clara | California | 6085 | 338035 | 2288 |
2483515 | 2483515 | 2022-05-08 | Santa Clara | California | 6085 | 338035 | 2288 |
2486773 | 2486773 | 2022-05-09 | Santa Clara | California | 6085 | 338035 | 2288 |
2467228 | 2467228 | 2022-05-03 | Santa Clara | California | 6085 | 335661 | 2286 |
2470484 | 2470484 | 2022-05-04 | Santa Clara | California | 6085 | 335661 | 2286 |
2473741 | 2473741 | 2022-05-05 | Santa Clara | California | 6085 | 335661 | 2286 |
2444437 | 2444437 | 2022-04-26 | Santa Clara | California | 6085 | 331774 | 2283 |
2447693 | 2447693 | 2022-04-27 | Santa Clara | California | 6085 | 331774 | 2283 |
2450949 | 2450949 | 2022-04-28 | Santa Clara | California | 6085 | 331774 | 2283 |
2454205 | 2454205 | 2022-04-29 | Santa Clara | California | 6085 | 333565 | 2282 |
2457461 | 2457461 | 2022-04-30 | Santa Clara | California | 6085 | 333565 | 2282 |
2460717 | 2460717 | 2022-05-01 | Santa Clara | California | 6085 | 333565 | 2282 |
2463973 | 2463973 | 2022-05-02 | Santa Clara | California | 6085 | 333565 | 2282 |
2431413 | 2431413 | 2022-04-22 | Santa Clara | California | 6085 | 330184 | 2278 |
2434669 | 2434669 | 2022-04-23 | Santa Clara | California | 6085 | 330184 | 2278 |
2437925 | 2437925 | 2022-04-24 | Santa Clara | California | 6085 | 330184 | 2278 |
2441181 | 2441181 | 2022-04-25 | Santa Clara | California | 6085 | 330184 | 2278 |
2421645 | 2421645 | 2022-04-19 | Santa Clara | California | 6085 | 328915 | 2275 |
2424901 | 2424901 | 2022-04-20 | Santa Clara | California | 6085 | 328915 | 2275 |
2428157 | 2428157 | 2022-04-21 | Santa Clara | California | 6085 | 328915 | 2275 |
2408621 | 2408621 | 2022-04-15 | Santa Clara | California | 6085 | 327856 | 2269 |
2411877 | 2411877 | 2022-04-16 | Santa Clara | California | 6085 | 327856 | 2269 |
2415133 | 2415133 | 2022-04-17 | Santa Clara | California | 6085 | 327856 | 2269 |
2418389 | 2418389 | 2022-04-18 | Santa Clara | California | 6085 | 327856 | 2269 |
2405365 | 2405365 | 2022-04-14 | Santa Clara | California | 6085 | 327423 | 2268 |
2385833 | 2385833 | 2022-04-08 | Santa Clara | California | 6085 | 326422 | 2267 |
2389088 | 2389088 | 2022-04-09 | Santa Clara | California | 6085 | 326422 | 2267 |
2392344 | 2392344 | 2022-04-10 | Santa Clara | California | 6085 | 326422 | 2267 |
2395600 | 2395600 | 2022-04-11 | Santa Clara | California | 6085 | 326422 | 2267 |
2398855 | 2398855 | 2022-04-12 | Santa Clara | California | 6085 | 326422 | 2267 |
2402110 | 2402110 | 2022-04-13 | Santa Clara | California | 6085 | 326422 | 2267 |
2376069 | 2376069 | 2022-04-05 | Santa Clara | California | 6085 | 325735 | 2266 |
2379323 | 2379323 | 2022-04-06 | Santa Clara | California | 6085 | 325735 | 2266 |
2382578 | 2382578 | 2022-04-07 | Santa Clara | California | 6085 | 325735 | 2266 |
2356550 | 2356550 | 2022-03-30 | Santa Clara | California | 6085 | 324405 | 2260 |
2359804 | 2359804 | 2022-03-31 | Santa Clara | California | 6085 | 324710 | 2259 |
2363058 | 2363058 | 2022-04-01 | Santa Clara | California | 6085 | 324974 | 2259 |
2366311 | 2366311 | 2022-04-02 | Santa Clara | California | 6085 | 324974 | 2259 |
2369564 | 2369564 | 2022-04-03 | Santa Clara | California | 6085 | 324974 | 2259 |
2372817 | 2372817 | 2022-04-04 | Santa Clara | California | 6085 | 324974 | 2259 |
2350045 | 2350045 | 2022-03-28 | Santa Clara | California | 6085 | 324160 | 2258 |
2353297 | 2353297 | 2022-03-29 | Santa Clara | California | 6085 | 324291 | 2258 |
2337033 | 2337033 | 2022-03-24 | Santa Clara | California | 6085 | 323294 | 2251 |
2340286 | 2340286 | 2022-03-25 | Santa Clara | California | 6085 | 323527 | 2251 |
2343539 | 2343539 | 2022-03-26 | Santa Clara | California | 6085 | 323527 | 2251 |
2346792 | 2346792 | 2022-03-27 | Santa Clara | California | 6085 | 323527 | 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 |
2304502 | 2304502 | 2022-03-14 | Santa Clara | California | 6085 | 321736 | 2226 |
2317512 | 2317512 | 2022-03-18 | Santa Clara | California | 6085 | 322203 | 2226 |
2320766 | 2320766 | 2022-03-19 | Santa Clara | California | 6085 | 322203 | 2226 |
2324020 | 2324020 | 2022-03-20 | Santa Clara | California | 6085 | 322203 | 2226 |
2311006 | 2311006 | 2022-03-16 | Santa Clara | California | 6085 | 321778 | 2225 |
2314259 | 2314259 | 2022-03-17 | Santa Clara | California | 6085 | 321974 | 2225 |
2307753 | 2307753 | 2022-03-15 | Santa Clara | California | 6085 | 321843 | 2224 |
2294746 | 2294746 | 2022-03-11 | Santa Clara | California | 6085 | 321232 | 2209 |
2297998 | 2297998 | 2022-03-12 | Santa Clara | California | 6085 | 321232 | 2209 |
2301250 | 2301250 | 2022-03-13 | Santa Clara | California | 6085 | 321232 | 2209 |
2288242 | 2288242 | 2022-03-09 | Santa Clara | California | 6085 | 320725 | 2207 |
2291494 | 2291494 | 2022-03-10 | Santa Clara | California | 6085 | 321008 | 2207 |
2284991 | 2284991 | 2022-03-08 | Santa Clara | California | 6085 | 320714 | 2203 |
1472532 | 1472532 | 2021-07-01 | Santa Clara | California | 6085 | 119388 | 2202 |
2281739 | 2281739 | 2022-03-07 | Santa Clara | California | 6085 | 320447 | 2202 |
1453062 | 1453062 | 2021-06-25 | Santa Clara | California | 6085 | 120274 | 2201 |
1456307 | 1456307 | 2021-06-26 | Santa Clara | California | 6085 | 120272 | 2201 |
1459552 | 1459552 | 2021-06-27 | Santa Clara | California | 6085 | 120321 | 2201 |
1462797 | 1462797 | 2021-06-28 | Santa Clara | California | 6085 | 120352 | 2201 |
1469287 | 1469287 | 2021-06-30 | Santa Clara | California | 6085 | 119357 | 2201 |
1466042 | 1466042 | 2021-06-29 | Santa Clara | California | 6085 | 120377 | 2198 |
2271980 | 2271980 | 2022-03-04 | Santa Clara | California | 6085 | 319886 | 2196 |
2275233 | 2275233 | 2022-03-05 | Santa Clara | California | 6085 | 319886 | 2196 |
2278486 | 2278486 | 2022-03-06 | Santa Clara | California | 6085 | 319886 | 2196 |
1446571 | 1446571 | 2021-06-23 | Santa Clara | California | 6085 | 120194 | 2194 |
1449816 | 1449816 | 2021-06-24 | Santa Clara | California | 6085 | 120233 | 2194 |
1443326 | 1443326 | 2021-06-22 | Santa Clara | California | 6085 | 120192 | 2191 |
2265475 | 2265475 | 2022-03-02 | Santa Clara | California | 6085 | 319162 | 2191 |
1430341 | 1430341 | 2021-06-18 | Santa Clara | California | 6085 | 120032 | 2189 |
1433587 | 1433587 | 2021-06-19 | Santa Clara | California | 6085 | 120081 | 2189 |
1436834 | 1436834 | 2021-06-20 | Santa Clara | California | 6085 | 120110 | 2189 |
1440081 | 1440081 | 2021-06-21 | Santa Clara | California | 6085 | 120163 | 2189 |
1595933 | 1595933 | 2021-08-08 | Santa Clara | California | 6085 | 126121 | 2189 |
1427096 | 1427096 | 2021-06-17 | Santa Clara | California | 6085 | 119982 | 2188 |
1599182 | 1599182 | 2021-08-09 | Santa Clara | California | 6085 | 126478 | 2188 |
1602431 | 1602431 | 2021-08-10 | Santa Clara | California | 6085 | 126716 | 2188 |
1589435 | 1589435 | 2021-08-06 | Santa Clara | California | 6085 | 125415 | 2186 |
1592684 | 1592684 | 2021-08-07 | Santa Clara | California | 6085 | 125415 | 2186 |
2268728 | 2268728 | 2022-03-03 | Santa Clara | California | 6085 | 319551 | 2185 |
1576438 | 1576438 | 2021-08-02 | Santa Clara | California | 6085 | 124411 | 2184 |
1579686 | 1579686 | 2021-08-03 | Santa Clara | California | 6085 | 124555 | 2184 |
1582936 | 1582936 | 2021-08-04 | Santa Clara | California | 6085 | 124814 | 2184 |
1586186 | 1586186 | 2021-08-05 | Santa Clara | California | 6085 | 125052 | 2184 |
2258973 | 2258973 | 2022-02-28 | Santa Clara | California | 6085 | 318940 | 2181 |
2262224 | 2262224 | 2022-03-01 | Santa Clara | California | 6085 | 319114 | 2181 |
1423851 | 1423851 | 2021-06-16 | Santa Clara | California | 6085 | 119963 | 2180 |
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);