⚠️ 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

357 rows where fips = 6085 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6085 · 357

county

Link rowid date ▲ county state fips cases deaths
949955 2021-01-21 Santa Clara California 6085 95936 1159
946709 2021-01-20 Santa Clara California 6085 94905 1130
943462 2021-01-19 Santa Clara California 6085 94366 1110
940217 2021-01-18 Santa Clara California 6085 93557 1077
936972 2021-01-17 Santa Clara California 6085 92625 1066
933727 2021-01-16 Santa Clara California 6085 91466 1061
930482 2021-01-15 Santa Clara California 6085 89983 1041
927237 2021-01-14 Santa Clara California 6085 88379 1029
923991 2021-01-13 Santa Clara California 6085 87045 1012
920746 2021-01-12 Santa Clara California 6085 85929 987
917501 2021-01-11 Santa Clara California 6085 84726 945
914256 2021-01-10 Santa Clara California 6085 83655 920
911011 2021-01-09 Santa Clara California 6085 82170 884
907766 2021-01-08 Santa Clara California 6085 80466 844
904520 2021-01-07 Santa Clara California 6085 78683 816
901275 2021-01-06 Santa Clara California 6085 77366 800
898030 2021-01-05 Santa Clara California 6085 76235 772
894785 2021-01-04 Santa Clara California 6085 74527 748
891538 2021-01-03 Santa Clara California 6085 74359 748
888291 2021-01-02 Santa Clara California 6085 73493 748
885046 2021-01-01 Santa Clara California 6085 71755 748
881801 2020-12-31 Santa Clara California 6085 69879 710
878556 2020-12-30 Santa Clara California 6085 67581 674
875311 2020-12-29 Santa Clara California 6085 67423 674
872066 2020-12-28 Santa Clara California 6085 66270 653
868821 2020-12-27 Santa Clara California 6085 64974 653
865576 2020-12-26 Santa Clara California 6085 63302 653
862331 2020-12-25 Santa Clara California 6085 61742 644
859086 2020-12-24 Santa Clara California 6085 61090 644
855841 2020-12-23 Santa Clara California 6085 59923 633
852596 2020-12-22 Santa Clara California 6085 58637 616
849351 2020-12-21 Santa Clara California 6085 57452 608
846106 2020-12-20 Santa Clara California 6085 56334 584
842860 2020-12-19 Santa Clara California 6085 54905 584
839615 2020-12-18 Santa Clara California 6085 53885 584
836370 2020-12-17 Santa Clara California 6085 52414 567
833124 2020-12-16 Santa Clara California 6085 51233 562
829877 2020-12-15 Santa Clara California 6085 50315 554
826631 2020-12-14 Santa Clara California 6085 49216 530
823384 2020-12-13 Santa Clara California 6085 48015 527
820138 2020-12-12 Santa Clara California 6085 45986 527
816892 2020-12-11 Santa Clara California 6085 45178 527
813646 2020-12-10 Santa Clara California 6085 44039 520
810402 2020-12-09 Santa Clara California 6085 43001 516
807157 2020-12-08 Santa Clara California 6085 41316 513
803912 2020-12-07 Santa Clara California 6085 40624 512
800666 2020-12-06 Santa Clara California 6085 39193 504
797420 2020-12-05 Santa Clara California 6085 38388 504
794175 2020-12-04 Santa Clara California 6085 37517 504
790929 2020-12-03 Santa Clara California 6085 36673 496
787683 2020-12-02 Santa Clara California 6085 35945 487
784439 2020-12-01 Santa Clara California 6085 35457 483
781194 2020-11-30 Santa Clara California 6085 35085 477
777948 2020-11-29 Santa Clara California 6085 34292 477
774702 2020-11-28 Santa Clara California 6085 33732 477
771457 2020-11-27 Santa Clara California 6085 32985 477
768211 2020-11-26 Santa Clara California 6085 32454 477
764964 2020-11-25 Santa Clara California 6085 32049 471
761718 2020-11-24 Santa Clara California 6085 31603 468
758472 2020-11-23 Santa Clara California 6085 31103 465
755225 2020-11-22 Santa Clara California 6085 30676 464
751978 2020-11-21 Santa Clara California 6085 30411 464
748731 2020-11-20 Santa Clara California 6085 30025 464
745484 2020-11-19 Santa Clara California 6085 29631 460
742237 2020-11-18 Santa Clara California 6085 29297 454
738990 2020-11-17 Santa Clara California 6085 29023 448
735745 2020-11-16 Santa Clara California 6085 28686 446
732499 2020-11-15 Santa Clara California 6085 28307 445
729254 2020-11-14 Santa Clara California 6085 27977 445
726010 2020-11-13 Santa Clara California 6085 27648 445
722766 2020-11-12 Santa Clara California 6085 27299 441
719522 2020-11-11 Santa Clara California 6085 27124 441
716278 2020-11-10 Santa Clara California 6085 26972 437
713034 2020-11-09 Santa Clara California 6085 26747 434
709790 2020-11-08 Santa Clara California 6085 26490 431
706546 2020-11-07 Santa Clara California 6085 26137 431
703303 2020-11-06 Santa Clara California 6085 25883 431
700059 2020-11-05 Santa Clara California 6085 25705 425
696814 2020-11-04 Santa Clara California 6085 25543 422
693571 2020-11-03 Santa Clara California 6085 25421 413
690328 2020-11-02 Santa Clara California 6085 25277 410
687083 2020-11-01 Santa Clara California 6085 25139 407
683838 2020-10-31 Santa Clara California 6085 24986 407
680594 2020-10-30 Santa Clara California 6085 24867 407
677351 2020-10-29 Santa Clara California 6085 24665 405
674107 2020-10-28 Santa Clara California 6085 24558 403
670865 2020-10-27 Santa Clara California 6085 24425 393
667622 2020-10-26 Santa Clara California 6085 24313 389
664376 2020-10-25 Santa Clara California 6085 24144 389
661131 2020-10-24 Santa Clara California 6085 24014 389
657887 2020-10-23 Santa Clara California 6085 23881 389
654642 2020-10-22 Santa Clara California 6085 23679 386
651397 2020-10-21 Santa Clara California 6085 23591 386
648153 2020-10-20 Santa Clara California 6085 23458 383
644908 2020-10-19 Santa Clara California 6085 23355 379
641660 2020-10-18 Santa Clara California 6085 23224 374
638413 2020-10-17 Santa Clara California 6085 23052 374
635168 2020-10-16 Santa Clara California 6085 22974 374
631922 2020-10-15 Santa Clara California 6085 22859 368
628678 2020-10-14 Santa Clara California 6085 22801 364

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