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

329 rows where fips = 6095 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6095 · 329

county

Link rowid date ▲ county state fips cases deaths
936977 2021-01-17 Solano California 6095 24737 105
933732 2021-01-16 Solano California 6095 24659 105
930487 2021-01-15 Solano California 6095 24659 105
927242 2021-01-14 Solano California 6095 24296 105
923996 2021-01-13 Solano California 6095 23894 105
920751 2021-01-12 Solano California 6095 23559 103
917506 2021-01-11 Solano California 6095 23319 102
914261 2021-01-10 Solano California 6095 22237 102
911016 2021-01-09 Solano California 6095 22237 102
907771 2021-01-08 Solano California 6095 22237 102
904525 2021-01-07 Solano California 6095 21860 102
901280 2021-01-06 Solano California 6095 21525 102
898035 2021-01-05 Solano California 6095 21228 102
894790 2021-01-04 Solano California 6095 20958 100
891543 2021-01-03 Solano California 6095 19810 98
888296 2021-01-02 Solano California 6095 19398 98
885051 2021-01-01 Solano California 6095 19216 98
881806 2020-12-31 Solano California 6095 19216 98
878561 2020-12-30 Solano California 6095 19013 98
875316 2020-12-29 Solano California 6095 18731 98
872071 2020-12-28 Solano California 6095 18523 95
868826 2020-12-27 Solano California 6095 17533 95
865581 2020-12-26 Solano California 6095 17335 95
862336 2020-12-25 Solano California 6095 17335 95
859091 2020-12-24 Solano California 6095 17335 95
855846 2020-12-23 Solano California 6095 16849 95
852601 2020-12-22 Solano California 6095 16573 94
849356 2020-12-21 Solano California 6095 16229 94
846111 2020-12-20 Solano California 6095 15209 93
842865 2020-12-19 Solano California 6095 15013 93
839620 2020-12-18 Solano California 6095 15013 93
836375 2020-12-17 Solano California 6095 14718 93
833129 2020-12-16 Solano California 6095 14274 93
829882 2020-12-15 Solano California 6095 13902 91
826636 2020-12-14 Solano California 6095 13739 91
823389 2020-12-13 Solano California 6095 12753 91
820143 2020-12-12 Solano California 6095 12738 91
816897 2020-12-11 Solano California 6095 12738 91
813651 2020-12-10 Solano California 6095 12538 91
810407 2020-12-09 Solano California 6095 12128 90
807162 2020-12-08 Solano California 6095 11955 90
803917 2020-12-07 Solano California 6095 11752 85
800671 2020-12-06 Solano California 6095 11418 85
797425 2020-12-05 Solano California 6095 11418 85
794180 2020-12-04 Solano California 6095 11418 85
790934 2020-12-03 Solano California 6095 11124 81
787688 2020-12-02 Solano California 6095 10962 81
784444 2020-12-01 Solano California 6095 10736 81
781199 2020-11-30 Solano California 6095 10653 81
777953 2020-11-29 Solano California 6095 10257 81
774707 2020-11-28 Solano California 6095 10049 81
771462 2020-11-27 Solano California 6095 10041 81
768216 2020-11-26 Solano California 6095 10041 81
764969 2020-11-25 Solano California 6095 10041 81
761723 2020-11-24 Solano California 6095 9929 81
758477 2020-11-23 Solano California 6095 9750 81
755230 2020-11-22 Solano California 6095 9354 80
751983 2020-11-21 Solano California 6095 9354 80
748736 2020-11-20 Solano California 6095 9354 80
745489 2020-11-19 Solano California 6095 9296 80
742242 2020-11-18 Solano California 6095 9166 80
738995 2020-11-17 Solano California 6095 9093 80
735750 2020-11-16 Solano California 6095 8964 79
732504 2020-11-15 Solano California 6095 8734 79
729259 2020-11-14 Solano California 6095 8734 79
726015 2020-11-13 Solano California 6095 8734 79
722771 2020-11-12 Solano California 6095 8601 79
719527 2020-11-11 Solano California 6095 8435 79
716283 2020-11-10 Solano California 6095 8435 79
713039 2020-11-09 Solano California 6095 8371 79
709795 2020-11-08 Solano California 6095 8137 79
706551 2020-11-07 Solano California 6095 8137 79
703308 2020-11-06 Solano California 6095 8137 79
700064 2020-11-05 Solano California 6095 8001 76
696819 2020-11-04 Solano California 6095 7945 76
693576 2020-11-03 Solano California 6095 7854 76
690333 2020-11-02 Solano California 6095 7806 76
687088 2020-11-01 Solano California 6095 7639 76
683843 2020-10-31 Solano California 6095 7639 76
680599 2020-10-30 Solano California 6095 7639 76
677356 2020-10-29 Solano California 6095 7591 76
674112 2020-10-28 Solano California 6095 7485 76
670870 2020-10-27 Solano California 6095 7450 76
667627 2020-10-26 Solano California 6095 7389 76
664381 2020-10-25 Solano California 6095 7291 74
661136 2020-10-24 Solano California 6095 7291 74
657892 2020-10-23 Solano California 6095 7291 74
654647 2020-10-22 Solano California 6095 7254 74
651402 2020-10-21 Solano California 6095 7210 74
648158 2020-10-20 Solano California 6095 7176 74
644913 2020-10-19 Solano California 6095 7122 74
641665 2020-10-18 Solano California 6095 7014 74
638418 2020-10-17 Solano California 6095 7014 74
635173 2020-10-16 Solano California 6095 7014 74
631927 2020-10-15 Solano California 6095 6956 74
628683 2020-10-14 Solano California 6095 6913 74
625440 2020-10-13 Solano California 6095 6881 74
622197 2020-10-12 Solano California 6095 6755 74
618954 2020-10-11 Solano California 6095 6755 74
615712 2020-10-10 Solano California 6095 6755 74

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