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)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1517983 | 1517983 | 2021-07-15 | Santa Clara | California | 6085 | 120681 | 2099 |
1514736 | 1514736 | 2021-07-14 | Santa Clara | California | 6085 | 120564 | 2099 |
1511490 | 1511490 | 2021-07-13 | Santa Clara | California | 6085 | 120471 | 2099 |
1508243 | 1508243 | 2021-07-12 | Santa Clara | California | 6085 | 120386 | 2099 |
1504997 | 1504997 | 2021-07-11 | Santa Clara | California | 6085 | 120167 | 2095 |
1501751 | 1501751 | 2021-07-10 | Santa Clara | California | 6085 | 120167 | 2095 |
1498505 | 1498505 | 2021-07-09 | Santa Clara | California | 6085 | 120167 | 2095 |
1495258 | 1495258 | 2021-07-08 | Santa Clara | California | 6085 | 120087 | 2095 |
1492011 | 1492011 | 2021-07-07 | Santa Clara | California | 6085 | 119678 | 2096 |
1488764 | 1488764 | 2021-07-06 | Santa Clara | California | 6085 | 119623 | 2091 |
1485517 | 1485517 | 2021-07-05 | Santa Clara | California | 6085 | 119612 | 2091 |
1482271 | 1482271 | 2021-07-04 | Santa Clara | California | 6085 | 119498 | 2091 |
1479024 | 1479024 | 2021-07-03 | Santa Clara | California | 6085 | 119498 | 2091 |
1475778 | 1475778 | 2021-07-02 | Santa Clara | California | 6085 | 119448 | 2091 |
1472532 | 1472532 | 2021-07-01 | Santa Clara | California | 6085 | 119388 | 2202 |
1469287 | 1469287 | 2021-06-30 | Santa Clara | California | 6085 | 119357 | 2201 |
1466042 | 1466042 | 2021-06-29 | Santa Clara | California | 6085 | 120377 | 2198 |
1462797 | 1462797 | 2021-06-28 | Santa Clara | California | 6085 | 120352 | 2201 |
1459552 | 1459552 | 2021-06-27 | Santa Clara | California | 6085 | 120321 | 2201 |
1456307 | 1456307 | 2021-06-26 | Santa Clara | California | 6085 | 120272 | 2201 |
1453062 | 1453062 | 2021-06-25 | Santa Clara | California | 6085 | 120274 | 2201 |
1449816 | 1449816 | 2021-06-24 | Santa Clara | California | 6085 | 120233 | 2194 |
1446571 | 1446571 | 2021-06-23 | Santa Clara | California | 6085 | 120194 | 2194 |
1443326 | 1443326 | 2021-06-22 | Santa Clara | California | 6085 | 120192 | 2191 |
1440081 | 1440081 | 2021-06-21 | Santa Clara | California | 6085 | 120163 | 2189 |
1436834 | 1436834 | 2021-06-20 | Santa Clara | California | 6085 | 120110 | 2189 |
1433587 | 1433587 | 2021-06-19 | Santa Clara | California | 6085 | 120081 | 2189 |
1430341 | 1430341 | 2021-06-18 | Santa Clara | California | 6085 | 120032 | 2189 |
1427096 | 1427096 | 2021-06-17 | Santa Clara | California | 6085 | 119982 | 2188 |
1423851 | 1423851 | 2021-06-16 | Santa Clara | California | 6085 | 119963 | 2180 |
1420603 | 1420603 | 2021-06-15 | Santa Clara | California | 6085 | 119957 | 2179 |
1417358 | 1417358 | 2021-06-14 | Santa Clara | California | 6085 | 119946 | 2178 |
1414112 | 1414112 | 2021-06-13 | Santa Clara | California | 6085 | 119894 | 2176 |
1410867 | 1410867 | 2021-06-12 | Santa Clara | California | 6085 | 119860 | 2176 |
1407622 | 1407622 | 2021-06-11 | Santa Clara | California | 6085 | 119832 | 2176 |
1404376 | 1404376 | 2021-06-10 | Santa Clara | California | 6085 | 119793 | 2166 |
1401131 | 1401131 | 2021-06-09 | Santa Clara | California | 6085 | 119770 | 2158 |
1397886 | 1397886 | 2021-06-08 | Santa Clara | California | 6085 | 119743 | 2158 |
1394639 | 1394639 | 2021-06-07 | Santa Clara | California | 6085 | 119711 | 2156 |
1391394 | 1391394 | 2021-06-06 | Santa Clara | California | 6085 | 119676 | 2154 |
1388149 | 1388149 | 2021-06-05 | Santa Clara | California | 6085 | 119619 | 2154 |
1384904 | 1384904 | 2021-06-04 | Santa Clara | California | 6085 | 119592 | 2154 |
1381658 | 1381658 | 2021-06-03 | Santa Clara | California | 6085 | 119553 | 2144 |
1378413 | 1378413 | 2021-06-02 | Santa Clara | California | 6085 | 119528 | 2143 |
1375167 | 1375167 | 2021-06-01 | Santa Clara | California | 6085 | 119515 | 2143 |
1371922 | 1371922 | 2021-05-31 | Santa Clara | California | 6085 | 119510 | 2143 |
1368677 | 1368677 | 2021-05-30 | Santa Clara | California | 6085 | 119498 | 2143 |
1365431 | 1365431 | 2021-05-29 | Santa Clara | California | 6085 | 119462 | 2143 |
1362185 | 1362185 | 2021-05-28 | Santa Clara | California | 6085 | 119452 | 2143 |
1358938 | 1358938 | 2021-05-27 | Santa Clara | California | 6085 | 119421 | 2136 |
1355692 | 1355692 | 2021-05-26 | Santa Clara | California | 6085 | 119393 | 2119 |
1352446 | 1352446 | 2021-05-25 | Santa Clara | California | 6085 | 119358 | 2118 |
1349200 | 1349200 | 2021-05-24 | Santa Clara | California | 6085 | 119333 | 2117 |
1345953 | 1345953 | 2021-05-23 | Santa Clara | California | 6085 | 119292 | 2117 |
1342705 | 1342705 | 2021-05-22 | Santa Clara | California | 6085 | 119247 | 2117 |
1339457 | 1339457 | 2021-05-21 | Santa Clara | California | 6085 | 119222 | 2117 |
1336210 | 1336210 | 2021-05-20 | Santa Clara | California | 6085 | 119176 | 2117 |
1332963 | 1332963 | 2021-05-19 | Santa Clara | California | 6085 | 119171 | 2098 |
1329716 | 1329716 | 2021-05-18 | Santa Clara | California | 6085 | 119116 | 2098 |
1326469 | 1326469 | 2021-05-17 | Santa Clara | California | 6085 | 119098 | 2099 |
1323223 | 1323223 | 2021-05-16 | Santa Clara | California | 6085 | 119060 | 2097 |
1319977 | 1319977 | 2021-05-15 | Santa Clara | California | 6085 | 119006 | 2097 |
1316730 | 1316730 | 2021-05-14 | Santa Clara | California | 6085 | 118952 | 2097 |
1313483 | 1313483 | 2021-05-13 | Santa Clara | California | 6085 | 119064 | 2097 |
1310236 | 1310236 | 2021-05-12 | Santa Clara | California | 6085 | 119010 | 2089 |
1306990 | 1306990 | 2021-05-11 | Santa Clara | California | 6085 | 118974 | 2089 |
1303744 | 1303744 | 2021-05-10 | Santa Clara | California | 6085 | 118932 | 2087 |
1300497 | 1300497 | 2021-05-09 | Santa Clara | California | 6085 | 118901 | 2086 |
1297250 | 1297250 | 2021-05-08 | Santa Clara | California | 6085 | 118851 | 2086 |
1294004 | 1294004 | 2021-05-07 | Santa Clara | California | 6085 | 118792 | 2086 |
1290758 | 1290758 | 2021-05-06 | Santa Clara | California | 6085 | 118698 | 2085 |
1287512 | 1287512 | 2021-05-05 | Santa Clara | California | 6085 | 118593 | 2074 |
1284266 | 1284266 | 2021-05-04 | Santa Clara | California | 6085 | 118541 | 2071 |
1281019 | 1281019 | 2021-05-03 | Santa Clara | California | 6085 | 118479 | 2070 |
1277772 | 1277772 | 2021-05-02 | Santa Clara | California | 6085 | 118424 | 2069 |
1274525 | 1274525 | 2021-05-01 | Santa Clara | California | 6085 | 118369 | 2069 |
1271278 | 1271278 | 2021-04-30 | Santa Clara | California | 6085 | 118269 | 2069 |
1268031 | 1268031 | 2021-04-29 | Santa Clara | California | 6085 | 118181 | 2061 |
1264784 | 1264784 | 2021-04-28 | Santa Clara | California | 6085 | 118094 | 2049 |
1261537 | 1261537 | 2021-04-27 | Santa Clara | California | 6085 | 118036 | 2049 |
1258290 | 1258290 | 2021-04-26 | Santa Clara | California | 6085 | 117965 | 2048 |
1255043 | 1255043 | 2021-04-25 | Santa Clara | California | 6085 | 117860 | 2044 |
1251796 | 1251796 | 2021-04-24 | Santa Clara | California | 6085 | 117755 | 2044 |
1248549 | 1248549 | 2021-04-23 | Santa Clara | California | 6085 | 117678 | 2044 |
1245302 | 1245302 | 2021-04-22 | Santa Clara | California | 6085 | 117538 | 2026 |
1242055 | 1242055 | 2021-04-21 | Santa Clara | California | 6085 | 117317 | 2020 |
1238808 | 1238808 | 2021-04-20 | Santa Clara | California | 6085 | 117317 | 2018 |
1235561 | 1235561 | 2021-04-19 | Santa Clara | California | 6085 | 117186 | 2018 |
1232314 | 1232314 | 2021-04-18 | Santa Clara | California | 6085 | 117081 | 2014 |
1229065 | 1229065 | 2021-04-17 | Santa Clara | California | 6085 | 116971 | 2014 |
1225817 | 1225817 | 2021-04-16 | Santa Clara | California | 6085 | 116772 | 2014 |
1222570 | 1222570 | 2021-04-15 | Santa Clara | California | 6085 | 116678 | 2009 |
1219322 | 1219322 | 2021-04-14 | Santa Clara | California | 6085 | 116562 | 2003 |
1216074 | 1216074 | 2021-04-13 | Santa Clara | California | 6085 | 116436 | 2003 |
1212827 | 1212827 | 2021-04-12 | Santa Clara | California | 6085 | 116324 | 2000 |
1209579 | 1209579 | 2021-04-11 | Santa Clara | California | 6085 | 116228 | 1996 |
1206330 | 1206330 | 2021-04-10 | Santa Clara | California | 6085 | 116084 | 1996 |
1203082 | 1203082 | 2021-04-09 | Santa Clara | California | 6085 | 115825 | 1996 |
1199834 | 1199834 | 2021-04-08 | Santa Clara | California | 6085 | 115569 | 1973 |
1196585 | 1196585 | 2021-04-07 | Santa Clara | California | 6085 | 115396 | 1970 |
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);