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 |
---|---|---|---|---|---|---|---|
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 |
1193337 | 1193337 | 2021-04-06 | Santa Clara | California | 6085 | 115266 | 1970 |
1190087 | 1190087 | 2021-04-05 | Santa Clara | California | 6085 | 115171 | 1962 |
1186840 | 1186840 | 2021-04-04 | Santa Clara | California | 6085 | 115057 | 1950 |
1183593 | 1183593 | 2021-04-03 | Santa Clara | California | 6085 | 114947 | 1950 |
1180346 | 1180346 | 2021-04-02 | Santa Clara | California | 6085 | 114852 | 1950 |
1177099 | 1177099 | 2021-04-01 | Santa Clara | California | 6085 | 114683 | 1943 |
1173852 | 1173852 | 2021-03-31 | Santa Clara | California | 6085 | 114570 | 1943 |
1170605 | 1170605 | 2021-03-30 | Santa Clara | California | 6085 | 114482 | 1941 |
1167357 | 1167357 | 2021-03-29 | Santa Clara | California | 6085 | 114398 | 1938 |
1164109 | 1164109 | 2021-03-28 | Santa Clara | California | 6085 | 114294 | 1935 |
1160861 | 1160861 | 2021-03-27 | Santa Clara | California | 6085 | 114183 | 1935 |
1157613 | 1157613 | 2021-03-26 | Santa Clara | California | 6085 | 114015 | 1935 |
1154366 | 1154366 | 2021-03-25 | Santa Clara | California | 6085 | 113929 | 1935 |
1151119 | 1151119 | 2021-03-24 | Santa Clara | California | 6085 | 113814 | 1917 |
1147872 | 1147872 | 2021-03-23 | Santa Clara | California | 6085 | 113700 | 1913 |
1144625 | 1144625 | 2021-03-22 | Santa Clara | California | 6085 | 113641 | 1908 |
1141378 | 1141378 | 2021-03-21 | Santa Clara | California | 6085 | 113552 | 1902 |
1138132 | 1138132 | 2021-03-20 | Santa Clara | California | 6085 | 113446 | 1902 |
1134886 | 1134886 | 2021-03-19 | Santa Clara | California | 6085 | 113292 | 1902 |
1131639 | 1131639 | 2021-03-18 | Santa Clara | California | 6085 | 113173 | 1893 |
1128391 | 1128391 | 2021-03-17 | Santa Clara | California | 6085 | 113044 | 1876 |
1125145 | 1125145 | 2021-03-16 | Santa Clara | California | 6085 | 112909 | 1877 |
1121899 | 1121899 | 2021-03-15 | Santa Clara | California | 6085 | 112794 | 1870 |
1118652 | 1118652 | 2021-03-14 | Santa Clara | California | 6085 | 112712 | 1859 |
1115405 | 1115405 | 2021-03-13 | Santa Clara | California | 6085 | 112602 | 1859 |
1112159 | 1112159 | 2021-03-12 | Santa Clara | California | 6085 | 112470 | 1859 |
1108913 | 1108913 | 2021-03-11 | Santa Clara | California | 6085 | 112325 | 1837 |
1105667 | 1105667 | 2021-03-10 | Santa Clara | California | 6085 | 112174 | 1836 |
1102421 | 1102421 | 2021-03-09 | Santa Clara | California | 6085 | 112036 | 1831 |
1099175 | 1099175 | 2021-03-08 | Santa Clara | California | 6085 | 111952 | 1828 |
1095927 | 1095927 | 2021-03-07 | Santa Clara | California | 6085 | 111814 | 1823 |
1092681 | 1092681 | 2021-03-06 | Santa Clara | California | 6085 | 111638 | 1823 |
1089435 | 1089435 | 2021-03-05 | Santa Clara | California | 6085 | 111460 | 1823 |
1086190 | 1086190 | 2021-03-04 | Santa Clara | California | 6085 | 111281 | 1821 |
1082944 | 1082944 | 2021-03-03 | Santa Clara | California | 6085 | 111076 | 1799 |
1079698 | 1079698 | 2021-03-02 | Santa Clara | California | 6085 | 110911 | 1798 |
1076453 | 1076453 | 2021-03-01 | Santa Clara | California | 6085 | 110755 | 1782 |
1073207 | 1073207 | 2021-02-28 | Santa Clara | California | 6085 | 110621 | 1778 |
1069961 | 1069961 | 2021-02-27 | Santa Clara | California | 6085 | 110422 | 1778 |
1066716 | 1066716 | 2021-02-26 | Santa Clara | California | 6085 | 110237 | 1778 |
1063471 | 1063471 | 2021-02-25 | Santa Clara | California | 6085 | 109841 | 1766 |
1060226 | 1060226 | 2021-02-24 | Santa Clara | California | 6085 | 109506 | 1748 |
1056980 | 1056980 | 2021-02-23 | Santa Clara | California | 6085 | 109506 | 1748 |
1053734 | 1053734 | 2021-02-22 | Santa Clara | California | 6085 | 109276 | 1737 |
1050487 | 1050487 | 2021-02-21 | Santa Clara | California | 6085 | 109054 | 1730 |
1047240 | 1047240 | 2021-02-20 | Santa Clara | California | 6085 | 108800 | 1729 |
1043995 | 1043995 | 2021-02-19 | Santa Clara | California | 6085 | 108462 | 1726 |
1040750 | 1040750 | 2021-02-18 | Santa Clara | California | 6085 | 108255 | 1709 |
1037505 | 1037505 | 2021-02-17 | Santa Clara | California | 6085 | 107980 | 1683 |
1034260 | 1034260 | 2021-02-16 | Santa Clara | California | 6085 | 107769 | 1670 |
1031014 | 1031014 | 2021-02-15 | Santa Clara | California | 6085 | 107619 | 1669 |
1027767 | 1027767 | 2021-02-14 | Santa Clara | California | 6085 | 107397 | 1667 |
1024522 | 1024522 | 2021-02-13 | Santa Clara | California | 6085 | 107110 | 1662 |
1021277 | 1021277 | 2021-02-12 | Santa Clara | California | 6085 | 106749 | 1644 |
1018032 | 1018032 | 2021-02-11 | Santa Clara | California | 6085 | 106372 | 1625 |
1014787 | 1014787 | 2021-02-10 | Santa Clara | California | 6085 | 106023 | 1595 |
1011542 | 1011542 | 2021-02-09 | Santa Clara | California | 6085 | 105740 | 1577 |
1008296 | 1008296 | 2021-02-08 | Santa Clara | California | 6085 | 105386 | 1547 |
1005050 | 1005050 | 2021-02-07 | Santa Clara | California | 6085 | 105094 | 1541 |
1001804 | 1001804 | 2021-02-06 | Santa Clara | California | 6085 | 104609 | 1529 |
998558 | 998558 | 2021-02-05 | Santa Clara | California | 6085 | 104076 | 1524 |
995312 | 995312 | 2021-02-04 | Santa Clara | California | 6085 | 103748 | 1506 |
992066 | 992066 | 2021-02-03 | Santa Clara | California | 6085 | 103236 | 1474 |
988820 | 988820 | 2021-02-02 | Santa Clara | California | 6085 | 102836 | 1434 |
985573 | 985573 | 2021-02-01 | Santa Clara | California | 6085 | 102427 | 1419 |
982326 | 982326 | 2021-01-31 | Santa Clara | California | 6085 | 101964 | 1415 |
979080 | 979080 | 2021-01-30 | Santa Clara | California | 6085 | 101453 | 1396 |
975835 | 975835 | 2021-01-29 | Santa Clara | California | 6085 | 100997 | 1373 |
972590 | 972590 | 2021-01-28 | Santa Clara | California | 6085 | 100468 | 1345 |
969345 | 969345 | 2021-01-27 | Santa Clara | California | 6085 | 99702 | 1315 |
966101 | 966101 | 2021-01-26 | Santa Clara | California | 6085 | 99174 | 1279 |
962856 | 962856 | 2021-01-25 | Santa Clara | California | 6085 | 98583 | 1265 |
959611 | 959611 | 2021-01-24 | Santa Clara | California | 6085 | 98057 | 1235 |
956365 | 956365 | 2021-01-23 | Santa Clara | California | 6085 | 96435 | 1182 |
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);