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

339 rows where fips = 6067 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6067 · 339

county

Link rowid date ▲ county state fips cases deaths
959682 2021-01-24 Sacramento California 6067 83407 1157
956436 2021-01-23 Sacramento California 6067 82860 1157
953191 2021-01-22 Sacramento California 6067 82302 1157
949946 2021-01-21 Sacramento California 6067 81686 1145
946700 2021-01-20 Sacramento California 6067 81182 1128
943453 2021-01-19 Sacramento California 6067 80677 1111
940208 2021-01-18 Sacramento California 6067 80153 1080
936963 2021-01-17 Sacramento California 6067 79121 1080
933718 2021-01-16 Sacramento California 6067 80278 1080
930473 2021-01-15 Sacramento California 6067 79136 1080
927228 2021-01-14 Sacramento California 6067 78267 1062
923982 2021-01-13 Sacramento California 6067 77200 1044
920737 2021-01-12 Sacramento California 6067 76008 1031
917492 2021-01-11 Sacramento California 6067 75393 1015
914247 2021-01-10 Sacramento California 6067 74481 977
911002 2021-01-09 Sacramento California 6067 73244 977
907757 2021-01-08 Sacramento California 6067 72341 977
904511 2021-01-07 Sacramento California 6067 71571 955
901266 2021-01-06 Sacramento California 6067 70676 941
898021 2021-01-05 Sacramento California 6067 70163 917
894776 2021-01-04 Sacramento California 6067 69110 898
891529 2021-01-03 Sacramento California 6067 67809 857
888282 2021-01-02 Sacramento California 6067 66955 857
885037 2021-01-01 Sacramento California 6067 65816 857
881792 2020-12-31 Sacramento California 6067 65540 857
878547 2020-12-30 Sacramento California 6067 65077 844
875302 2020-12-29 Sacramento California 6067 64321 833
872057 2020-12-28 Sacramento California 6067 63415 827
868812 2020-12-27 Sacramento California 6067 62434 809
865567 2020-12-26 Sacramento California 6067 61629 809
862322 2020-12-25 Sacramento California 6067 60595 809
859077 2020-12-24 Sacramento California 6067 59769 809
855832 2020-12-23 Sacramento California 6067 58868 797
852587 2020-12-22 Sacramento California 6067 58000 786
849342 2020-12-21 Sacramento California 6067 57081 774
846097 2020-12-20 Sacramento California 6067 55168 741
842851 2020-12-19 Sacramento California 6067 54002 741
839606 2020-12-18 Sacramento California 6067 54002 741
836361 2020-12-17 Sacramento California 6067 53184 727
833115 2020-12-16 Sacramento California 6067 52181 711
829868 2020-12-15 Sacramento California 6067 51051 699
826622 2020-12-14 Sacramento California 6067 50222 689
823375 2020-12-13 Sacramento California 6067 48318 670
820129 2020-12-12 Sacramento California 6067 47472 670
816883 2020-12-11 Sacramento California 6067 47472 670
813637 2020-12-10 Sacramento California 6067 46478 659
810393 2020-12-09 Sacramento California 6067 45335 646
807148 2020-12-08 Sacramento California 6067 44687 635
803903 2020-12-07 Sacramento California 6067 43425 620
800657 2020-12-06 Sacramento California 6067 41877 614
797411 2020-12-05 Sacramento California 6067 41095 614
794166 2020-12-04 Sacramento California 6067 41095 614
790920 2020-12-03 Sacramento California 6067 40304 603
787674 2020-12-02 Sacramento California 6067 39366 591
784430 2020-12-01 Sacramento California 6067 38998 586
781185 2020-11-30 Sacramento California 6067 37883 581
777939 2020-11-29 Sacramento California 6067 36904 576
774693 2020-11-28 Sacramento California 6067 36629 576
771448 2020-11-27 Sacramento California 6067 36629 576
768202 2020-11-26 Sacramento California 6067 35738 566
764955 2020-11-25 Sacramento California 6067 35738 566
761709 2020-11-24 Sacramento California 6067 35142 557
758463 2020-11-23 Sacramento California 6067 34185 550
755216 2020-11-22 Sacramento California 6067 33132 546
751969 2020-11-21 Sacramento California 6067 32864 546
748722 2020-11-20 Sacramento California 6067 32864 546
745475 2020-11-19 Sacramento California 6067 32410 544
742228 2020-11-18 Sacramento California 6067 31851 536
738981 2020-11-17 Sacramento California 6067 31386 533
735736 2020-11-16 Sacramento California 6067 30998 527
732490 2020-11-15 Sacramento California 6067 30297 520
729245 2020-11-14 Sacramento California 6067 29836 520
726001 2020-11-13 Sacramento California 6067 29836 520
722757 2020-11-12 Sacramento California 6067 29509 517
719513 2020-11-11 Sacramento California 6067 29013 514
716269 2020-11-10 Sacramento California 6067 28720 514
713025 2020-11-09 Sacramento California 6067 28236 513
709781 2020-11-08 Sacramento California 6067 27772 508
706537 2020-11-07 Sacramento California 6067 27529 508
703294 2020-11-06 Sacramento California 6067 27529 508
700050 2020-11-05 Sacramento California 6067 27277 506
696805 2020-11-04 Sacramento California 6067 27042 506
693562 2020-11-03 Sacramento California 6067 26883 504
690319 2020-11-02 Sacramento California 6067 26715 502
687074 2020-11-01 Sacramento California 6067 26315 500
683829 2020-10-31 Sacramento California 6067 26184 500
680585 2020-10-30 Sacramento California 6067 26184 500
677342 2020-10-29 Sacramento California 6067 26017 500
674098 2020-10-28 Sacramento California 6067 25881 499
670856 2020-10-27 Sacramento California 6067 25749 496
667613 2020-10-26 Sacramento California 6067 25600 491
664367 2020-10-25 Sacramento California 6067 25371 484
661122 2020-10-24 Sacramento California 6067 25263 484
657878 2020-10-23 Sacramento California 6067 25263 484
654633 2020-10-22 Sacramento California 6067 25093 482
651388 2020-10-21 Sacramento California 6067 24956 480
648144 2020-10-20 Sacramento California 6067 24810 474
644899 2020-10-19 Sacramento California 6067 24581 471
641651 2020-10-18 Sacramento California 6067 24303 468
638404 2020-10-17 Sacramento California 6067 24191 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]);