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 |
---|---|---|---|---|---|---|---|
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 |
868741 | 868741 | 2020-12-27 | Santa Clara | California | 6085 | 64974 | 653 |
865496 | 865496 | 2020-12-26 | Santa Clara | California | 6085 | 63302 | 653 |
862251 | 862251 | 2020-12-25 | Santa Clara | California | 6085 | 61742 | 644 |
859006 | 859006 | 2020-12-24 | Santa Clara | California | 6085 | 61090 | 644 |
855761 | 855761 | 2020-12-23 | Santa Clara | California | 6085 | 59923 | 633 |
852516 | 852516 | 2020-12-22 | Santa Clara | California | 6085 | 58637 | 616 |
849271 | 849271 | 2020-12-21 | Santa Clara | California | 6085 | 57452 | 608 |
846026 | 846026 | 2020-12-20 | Santa Clara | California | 6085 | 56334 | 584 |
842780 | 842780 | 2020-12-19 | Santa Clara | California | 6085 | 54905 | 584 |
839535 | 839535 | 2020-12-18 | Santa Clara | California | 6085 | 53885 | 584 |
836290 | 836290 | 2020-12-17 | Santa Clara | California | 6085 | 52414 | 567 |
833044 | 833044 | 2020-12-16 | Santa Clara | California | 6085 | 51233 | 562 |
829797 | 829797 | 2020-12-15 | Santa Clara | California | 6085 | 50315 | 554 |
826551 | 826551 | 2020-12-14 | Santa Clara | California | 6085 | 49216 | 530 |
823304 | 823304 | 2020-12-13 | Santa Clara | California | 6085 | 48015 | 527 |
820058 | 820058 | 2020-12-12 | Santa Clara | California | 6085 | 45986 | 527 |
816812 | 816812 | 2020-12-11 | Santa Clara | California | 6085 | 45178 | 527 |
813566 | 813566 | 2020-12-10 | Santa Clara | California | 6085 | 44039 | 520 |
810322 | 810322 | 2020-12-09 | Santa Clara | California | 6085 | 43001 | 516 |
807077 | 807077 | 2020-12-08 | Santa Clara | California | 6085 | 41316 | 513 |
803832 | 803832 | 2020-12-07 | Santa Clara | California | 6085 | 40624 | 512 |
800587 | 800587 | 2020-12-06 | Santa Clara | California | 6085 | 39193 | 504 |
797342 | 797342 | 2020-12-05 | Santa Clara | California | 6085 | 38388 | 504 |
794097 | 794097 | 2020-12-04 | Santa Clara | California | 6085 | 37517 | 504 |
790852 | 790852 | 2020-12-03 | Santa Clara | California | 6085 | 36673 | 496 |
787607 | 787607 | 2020-12-02 | Santa Clara | California | 6085 | 35945 | 487 |
784363 | 784363 | 2020-12-01 | Santa Clara | California | 6085 | 35457 | 483 |
781118 | 781118 | 2020-11-30 | Santa Clara | California | 6085 | 35085 | 477 |
777872 | 777872 | 2020-11-29 | Santa Clara | California | 6085 | 34292 | 477 |
774627 | 774627 | 2020-11-28 | Santa Clara | California | 6085 | 33732 | 477 |
771382 | 771382 | 2020-11-27 | Santa Clara | California | 6085 | 32985 | 477 |
768137 | 768137 | 2020-11-26 | Santa Clara | California | 6085 | 32454 | 477 |
764891 | 764891 | 2020-11-25 | Santa Clara | California | 6085 | 32049 | 471 |
761646 | 761646 | 2020-11-24 | Santa Clara | California | 6085 | 31603 | 468 |
758401 | 758401 | 2020-11-23 | Santa Clara | California | 6085 | 31103 | 465 |
755154 | 755154 | 2020-11-22 | Santa Clara | California | 6085 | 30676 | 464 |
751908 | 751908 | 2020-11-21 | Santa Clara | California | 6085 | 30411 | 464 |
748662 | 748662 | 2020-11-20 | Santa Clara | California | 6085 | 30025 | 464 |
745416 | 745416 | 2020-11-19 | Santa Clara | California | 6085 | 29631 | 460 |
742169 | 742169 | 2020-11-18 | Santa Clara | California | 6085 | 29297 | 454 |
738922 | 738922 | 2020-11-17 | Santa Clara | California | 6085 | 29023 | 448 |
735678 | 735678 | 2020-11-16 | Santa Clara | California | 6085 | 28686 | 446 |
732432 | 732432 | 2020-11-15 | Santa Clara | California | 6085 | 28307 | 445 |
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);