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 |
---|---|---|---|---|---|---|---|
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 |
953120 | 953120 | 2021-01-22 | Santa Clara | California | 6085 | 96340 | 1182 |
949875 | 949875 | 2021-01-21 | Santa Clara | California | 6085 | 95936 | 1159 |
946629 | 946629 | 2021-01-20 | Santa Clara | California | 6085 | 94905 | 1130 |
943382 | 943382 | 2021-01-19 | Santa Clara | California | 6085 | 94366 | 1110 |
940137 | 940137 | 2021-01-18 | Santa Clara | California | 6085 | 93557 | 1077 |
936892 | 936892 | 2021-01-17 | Santa Clara | California | 6085 | 92625 | 1066 |
933647 | 933647 | 2021-01-16 | Santa Clara | California | 6085 | 91466 | 1061 |
930402 | 930402 | 2021-01-15 | Santa Clara | California | 6085 | 89983 | 1041 |
927157 | 927157 | 2021-01-14 | Santa Clara | California | 6085 | 88379 | 1029 |
923911 | 923911 | 2021-01-13 | Santa Clara | California | 6085 | 87045 | 1012 |
920666 | 920666 | 2021-01-12 | Santa Clara | California | 6085 | 85929 | 987 |
917421 | 917421 | 2021-01-11 | Santa Clara | California | 6085 | 84726 | 945 |
914176 | 914176 | 2021-01-10 | Santa Clara | California | 6085 | 83655 | 920 |
910931 | 910931 | 2021-01-09 | Santa Clara | California | 6085 | 82170 | 884 |
907686 | 907686 | 2021-01-08 | Santa Clara | California | 6085 | 80466 | 844 |
904440 | 904440 | 2021-01-07 | Santa Clara | California | 6085 | 78683 | 816 |
901195 | 901195 | 2021-01-06 | Santa Clara | California | 6085 | 77366 | 800 |
897950 | 897950 | 2021-01-05 | Santa Clara | California | 6085 | 76235 | 772 |
894705 | 894705 | 2021-01-04 | Santa Clara | California | 6085 | 74527 | 748 |
891458 | 891458 | 2021-01-03 | Santa Clara | California | 6085 | 74359 | 748 |
888211 | 888211 | 2021-01-02 | Santa Clara | California | 6085 | 73493 | 748 |
884966 | 884966 | 2021-01-01 | Santa Clara | California | 6085 | 71755 | 748 |
881721 | 881721 | 2020-12-31 | Santa Clara | California | 6085 | 69879 | 710 |
878476 | 878476 | 2020-12-30 | Santa Clara | California | 6085 | 67581 | 674 |
875231 | 875231 | 2020-12-29 | Santa Clara | California | 6085 | 67423 | 674 |
871986 | 871986 | 2020-12-28 | Santa Clara | California | 6085 | 66270 | 653 |
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);