⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

398 rows where fips = 6085 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6085 · 398

county

Link rowid date ▲ county state fips cases deaths
1082944 2021-03-03 Santa Clara California 6085 111076 1799
1079698 2021-03-02 Santa Clara California 6085 110911 1798
1076453 2021-03-01 Santa Clara California 6085 110755 1782
1073207 2021-02-28 Santa Clara California 6085 110621 1778
1069961 2021-02-27 Santa Clara California 6085 110422 1778
1066716 2021-02-26 Santa Clara California 6085 110237 1778
1063471 2021-02-25 Santa Clara California 6085 109841 1766
1060226 2021-02-24 Santa Clara California 6085 109506 1748
1056980 2021-02-23 Santa Clara California 6085 109506 1748
1053734 2021-02-22 Santa Clara California 6085 109276 1737
1050487 2021-02-21 Santa Clara California 6085 109054 1730
1047240 2021-02-20 Santa Clara California 6085 108800 1729
1043995 2021-02-19 Santa Clara California 6085 108462 1726
1040750 2021-02-18 Santa Clara California 6085 108255 1709
1037505 2021-02-17 Santa Clara California 6085 107980 1683
1034260 2021-02-16 Santa Clara California 6085 107769 1670
1031014 2021-02-15 Santa Clara California 6085 107619 1669
1027767 2021-02-14 Santa Clara California 6085 107397 1667
1024522 2021-02-13 Santa Clara California 6085 107110 1662
1021277 2021-02-12 Santa Clara California 6085 106749 1644
1018032 2021-02-11 Santa Clara California 6085 106372 1625
1014787 2021-02-10 Santa Clara California 6085 106023 1595
1011542 2021-02-09 Santa Clara California 6085 105740 1577
1008296 2021-02-08 Santa Clara California 6085 105386 1547
1005050 2021-02-07 Santa Clara California 6085 105094 1541
1001804 2021-02-06 Santa Clara California 6085 104609 1529
998558 2021-02-05 Santa Clara California 6085 104076 1524
995312 2021-02-04 Santa Clara California 6085 103748 1506
992066 2021-02-03 Santa Clara California 6085 103236 1474
988820 2021-02-02 Santa Clara California 6085 102836 1434
985573 2021-02-01 Santa Clara California 6085 102427 1419
982326 2021-01-31 Santa Clara California 6085 101964 1415
979080 2021-01-30 Santa Clara California 6085 101453 1396
975835 2021-01-29 Santa Clara California 6085 100997 1373
972590 2021-01-28 Santa Clara California 6085 100468 1345
969345 2021-01-27 Santa Clara California 6085 99702 1315
966101 2021-01-26 Santa Clara California 6085 99174 1279
962856 2021-01-25 Santa Clara California 6085 98583 1265
959611 2021-01-24 Santa Clara California 6085 98057 1235
956365 2021-01-23 Santa Clara California 6085 96435 1182
953120 2021-01-22 Santa Clara California 6085 96340 1182
949875 2021-01-21 Santa Clara California 6085 95936 1159
946629 2021-01-20 Santa Clara California 6085 94905 1130
943382 2021-01-19 Santa Clara California 6085 94366 1110
940137 2021-01-18 Santa Clara California 6085 93557 1077
936892 2021-01-17 Santa Clara California 6085 92625 1066
933647 2021-01-16 Santa Clara California 6085 91466 1061
930402 2021-01-15 Santa Clara California 6085 89983 1041
927157 2021-01-14 Santa Clara California 6085 88379 1029
923911 2021-01-13 Santa Clara California 6085 87045 1012
920666 2021-01-12 Santa Clara California 6085 85929 987
917421 2021-01-11 Santa Clara California 6085 84726 945
914176 2021-01-10 Santa Clara California 6085 83655 920
910931 2021-01-09 Santa Clara California 6085 82170 884
907686 2021-01-08 Santa Clara California 6085 80466 844
904440 2021-01-07 Santa Clara California 6085 78683 816
901195 2021-01-06 Santa Clara California 6085 77366 800
897950 2021-01-05 Santa Clara California 6085 76235 772
894705 2021-01-04 Santa Clara California 6085 74527 748
891458 2021-01-03 Santa Clara California 6085 74359 748
888211 2021-01-02 Santa Clara California 6085 73493 748
884966 2021-01-01 Santa Clara California 6085 71755 748
881721 2020-12-31 Santa Clara California 6085 69879 710
878476 2020-12-30 Santa Clara California 6085 67581 674
875231 2020-12-29 Santa Clara California 6085 67423 674
871986 2020-12-28 Santa Clara California 6085 66270 653
868741 2020-12-27 Santa Clara California 6085 64974 653
865496 2020-12-26 Santa Clara California 6085 63302 653
862251 2020-12-25 Santa Clara California 6085 61742 644
859006 2020-12-24 Santa Clara California 6085 61090 644
855761 2020-12-23 Santa Clara California 6085 59923 633
852516 2020-12-22 Santa Clara California 6085 58637 616
849271 2020-12-21 Santa Clara California 6085 57452 608
846026 2020-12-20 Santa Clara California 6085 56334 584
842780 2020-12-19 Santa Clara California 6085 54905 584
839535 2020-12-18 Santa Clara California 6085 53885 584
836290 2020-12-17 Santa Clara California 6085 52414 567
833044 2020-12-16 Santa Clara California 6085 51233 562
829797 2020-12-15 Santa Clara California 6085 50315 554
826551 2020-12-14 Santa Clara California 6085 49216 530
823304 2020-12-13 Santa Clara California 6085 48015 527
820058 2020-12-12 Santa Clara California 6085 45986 527
816812 2020-12-11 Santa Clara California 6085 45178 527
813566 2020-12-10 Santa Clara California 6085 44039 520
810322 2020-12-09 Santa Clara California 6085 43001 516
807077 2020-12-08 Santa Clara California 6085 41316 513
803832 2020-12-07 Santa Clara California 6085 40624 512
800587 2020-12-06 Santa Clara California 6085 39193 504
797342 2020-12-05 Santa Clara California 6085 38388 504
794097 2020-12-04 Santa Clara California 6085 37517 504
790852 2020-12-03 Santa Clara California 6085 36673 496
787607 2020-12-02 Santa Clara California 6085 35945 487
784363 2020-12-01 Santa Clara California 6085 35457 483
781118 2020-11-30 Santa Clara California 6085 35085 477
777872 2020-11-29 Santa Clara California 6085 34292 477
774627 2020-11-28 Santa Clara California 6085 33732 477
771382 2020-11-27 Santa Clara California 6085 32985 477
768137 2020-11-26 Santa Clara California 6085 32454 477
764891 2020-11-25 Santa Clara California 6085 32049 471
761646 2020-11-24 Santa Clara California 6085 31603 468

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);