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

380 rows where fips = 6067 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6067 · 380

county

Link rowid date ▲ county state fips cases deaths
1092672 2021-03-06 Sacramento California 6067 94181 1510
1089426 2021-03-05 Sacramento California 6067 94128 1510
1086181 2021-03-04 Sacramento California 6067 93946 1506
1082935 2021-03-03 Sacramento California 6067 93789 1498
1079689 2021-03-02 Sacramento California 6067 93677 1488
1076444 2021-03-01 Sacramento California 6067 93527 1484
1073198 2021-02-28 Sacramento California 6067 93280 1472
1069952 2021-02-27 Sacramento California 6067 93179 1472
1066707 2021-02-26 Sacramento California 6067 93159 1472
1063462 2021-02-25 Sacramento California 6067 92943 1464
1060217 2021-02-24 Sacramento California 6067 92771 1456
1056971 2021-02-23 Sacramento California 6067 92620 1446
1053725 2021-02-22 Sacramento California 6067 92427 1438
1050478 2021-02-21 Sacramento California 6067 92056 1431
1047231 2021-02-20 Sacramento California 6067 91814 1431
1043986 2021-02-19 Sacramento California 6067 91796 1431
1040741 2021-02-18 Sacramento California 6067 91392 1412
1037496 2021-02-17 Sacramento California 6067 91245 1402
1034251 2021-02-16 Sacramento California 6067 91090 1382
1031005 2021-02-15 Sacramento California 6067 90855 1372
1027758 2021-02-14 Sacramento California 6067 90400 1372
1024513 2021-02-13 Sacramento California 6067 90251 1372
1021268 2021-02-12 Sacramento California 6067 89987 1372
1018023 2021-02-11 Sacramento California 6067 89652 1360
1014778 2021-02-10 Sacramento California 6067 89377 1352
1011533 2021-02-09 Sacramento California 6067 89266 1335
1008287 2021-02-08 Sacramento California 6067 88918 1318
1005041 2021-02-07 Sacramento California 6067 88531 1302
1001795 2021-02-06 Sacramento California 6067 87991 1302
998549 2021-02-05 Sacramento California 6067 87703 1302
995303 2021-02-04 Sacramento California 6067 87414 1288
992057 2021-02-03 Sacramento California 6067 87106 1281
988811 2021-02-02 Sacramento California 6067 86855 1271
985564 2021-02-01 Sacramento California 6067 86559 1262
982317 2021-01-31 Sacramento California 6067 86387 1239
979071 2021-01-30 Sacramento California 6067 86319 1239
975826 2021-01-29 Sacramento California 6067 85697 1239
972581 2021-01-28 Sacramento California 6067 85427 1216
969336 2021-01-27 Sacramento California 6067 85061 1208
966092 2021-01-26 Sacramento California 6067 84652 1194
962847 2021-01-25 Sacramento California 6067 84109 1185
959602 2021-01-24 Sacramento California 6067 83407 1157
956356 2021-01-23 Sacramento California 6067 82860 1157
953111 2021-01-22 Sacramento California 6067 82302 1157
949866 2021-01-21 Sacramento California 6067 81686 1145
946620 2021-01-20 Sacramento California 6067 81182 1128
943373 2021-01-19 Sacramento California 6067 80677 1111
940128 2021-01-18 Sacramento California 6067 80153 1080
936883 2021-01-17 Sacramento California 6067 79121 1080
933638 2021-01-16 Sacramento California 6067 80278 1080
930393 2021-01-15 Sacramento California 6067 79136 1080
927148 2021-01-14 Sacramento California 6067 78267 1062
923902 2021-01-13 Sacramento California 6067 77200 1044
920657 2021-01-12 Sacramento California 6067 76008 1031
917412 2021-01-11 Sacramento California 6067 75393 1015
914167 2021-01-10 Sacramento California 6067 74481 977
910922 2021-01-09 Sacramento California 6067 73244 977
907677 2021-01-08 Sacramento California 6067 72341 977
904431 2021-01-07 Sacramento California 6067 71571 955
901186 2021-01-06 Sacramento California 6067 70676 941
897941 2021-01-05 Sacramento California 6067 70163 917
894696 2021-01-04 Sacramento California 6067 69110 898
891449 2021-01-03 Sacramento California 6067 67809 857
888202 2021-01-02 Sacramento California 6067 66955 857
884957 2021-01-01 Sacramento California 6067 65816 857
881712 2020-12-31 Sacramento California 6067 65540 857
878467 2020-12-30 Sacramento California 6067 65077 844
875222 2020-12-29 Sacramento California 6067 64321 833
871977 2020-12-28 Sacramento California 6067 63415 827
868732 2020-12-27 Sacramento California 6067 62434 809
865487 2020-12-26 Sacramento California 6067 61629 809
862242 2020-12-25 Sacramento California 6067 60595 809
858997 2020-12-24 Sacramento California 6067 59769 809
855752 2020-12-23 Sacramento California 6067 58868 797
852507 2020-12-22 Sacramento California 6067 58000 786
849262 2020-12-21 Sacramento California 6067 57081 774
846017 2020-12-20 Sacramento California 6067 55168 741
842771 2020-12-19 Sacramento California 6067 54002 741
839526 2020-12-18 Sacramento California 6067 54002 741
836281 2020-12-17 Sacramento California 6067 53184 727
833035 2020-12-16 Sacramento California 6067 52181 711
829788 2020-12-15 Sacramento California 6067 51051 699
826542 2020-12-14 Sacramento California 6067 50222 689
823295 2020-12-13 Sacramento California 6067 48318 670
820049 2020-12-12 Sacramento California 6067 47472 670
816803 2020-12-11 Sacramento California 6067 47472 670
813557 2020-12-10 Sacramento California 6067 46478 659
810313 2020-12-09 Sacramento California 6067 45335 646
807068 2020-12-08 Sacramento California 6067 44687 635
803823 2020-12-07 Sacramento California 6067 43425 620
800578 2020-12-06 Sacramento California 6067 41877 614
797333 2020-12-05 Sacramento California 6067 41095 614
794088 2020-12-04 Sacramento California 6067 41095 614
790843 2020-12-03 Sacramento California 6067 40304 603
787598 2020-12-02 Sacramento California 6067 39366 591
784354 2020-12-01 Sacramento California 6067 38998 586
781109 2020-11-30 Sacramento California 6067 37883 581
777863 2020-11-29 Sacramento California 6067 36904 576
774618 2020-11-28 Sacramento California 6067 36629 576
771373 2020-11-27 Sacramento California 6067 36629 576

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