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

374 rows where fips = 6095 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6095 · 374

county

Link rowid date ▲ county state fips cases deaths
1082949 2021-03-03 Solano California 6095 30221 165
1079703 2021-03-02 Solano California 6095 30168 164
1076458 2021-03-01 Solano California 6095 30120 164
1073212 2021-02-28 Solano California 6095 30029 164
1069966 2021-02-27 Solano California 6095 30029 164
1066721 2021-02-26 Solano California 6095 30029 164
1063476 2021-02-25 Solano California 6095 29973 164
1060231 2021-02-24 Solano California 6095 29930 164
1056985 2021-02-23 Solano California 6095 29887 161
1053739 2021-02-22 Solano California 6095 29864 161
1050492 2021-02-21 Solano California 6095 29771 161
1047245 2021-02-20 Solano California 6095 29771 161
1044000 2021-02-19 Solano California 6095 29771 161
1040755 2021-02-18 Solano California 6095 29695 156
1037510 2021-02-17 Solano California 6095 29648 156
1034265 2021-02-16 Solano California 6095 29585 149
1031019 2021-02-15 Solano California 6095 29256 140
1027772 2021-02-14 Solano California 6095 29256 140
1024527 2021-02-13 Solano California 6095 29256 140
1021282 2021-02-12 Solano California 6095 29256 140
1018037 2021-02-11 Solano California 6095 29256 140
1014792 2021-02-10 Solano California 6095 29177 140
1011547 2021-02-09 Solano California 6095 29045 140
1008301 2021-02-08 Solano California 6095 28999 134
1005055 2021-02-07 Solano California 6095 28691 134
1001809 2021-02-06 Solano California 6095 28691 134
998563 2021-02-05 Solano California 6095 28691 134
995317 2021-02-04 Solano California 6095 28516 134
992071 2021-02-03 Solano California 6095 28415 129
988825 2021-02-02 Solano California 6095 28295 127
985578 2021-02-01 Solano California 6095 28196 122
982331 2021-01-31 Solano California 6095 27711 122
979085 2021-01-30 Solano California 6095 27711 122
975840 2021-01-29 Solano California 6095 27711 122
972595 2021-01-28 Solano California 6095 27491 122
969350 2021-01-27 Solano California 6095 27322 121
966106 2021-01-26 Solano California 6095 27146 118
962861 2021-01-25 Solano California 6095 27046 115
959616 2021-01-24 Solano California 6095 26499 111
956370 2021-01-23 Solano California 6095 26499 111
953125 2021-01-22 Solano California 6095 26499 111
949880 2021-01-21 Solano California 6095 26196 108
946634 2021-01-20 Solano California 6095 25988 107
943387 2021-01-19 Solano California 6095 25811 106
940142 2021-01-18 Solano California 6095 25221 105
936897 2021-01-17 Solano California 6095 24737 105
933652 2021-01-16 Solano California 6095 24659 105
930407 2021-01-15 Solano California 6095 24659 105
927162 2021-01-14 Solano California 6095 24296 105
923916 2021-01-13 Solano California 6095 23894 105
920671 2021-01-12 Solano California 6095 23559 103
917426 2021-01-11 Solano California 6095 23319 102
914181 2021-01-10 Solano California 6095 22237 102
910936 2021-01-09 Solano California 6095 22237 102
907691 2021-01-08 Solano California 6095 22237 102
904445 2021-01-07 Solano California 6095 21860 102
901200 2021-01-06 Solano California 6095 21525 102
897955 2021-01-05 Solano California 6095 21228 102
894710 2021-01-04 Solano California 6095 20958 100
891463 2021-01-03 Solano California 6095 19810 98
888216 2021-01-02 Solano California 6095 19398 98
884971 2021-01-01 Solano California 6095 19216 98
881726 2020-12-31 Solano California 6095 19216 98
878481 2020-12-30 Solano California 6095 19013 98
875236 2020-12-29 Solano California 6095 18731 98
871991 2020-12-28 Solano California 6095 18523 95
868746 2020-12-27 Solano California 6095 17533 95
865501 2020-12-26 Solano California 6095 17335 95
862256 2020-12-25 Solano California 6095 17335 95
859011 2020-12-24 Solano California 6095 17335 95
855766 2020-12-23 Solano California 6095 16849 95
852521 2020-12-22 Solano California 6095 16573 94
849276 2020-12-21 Solano California 6095 16229 94
846031 2020-12-20 Solano California 6095 15209 93
842785 2020-12-19 Solano California 6095 15013 93
839540 2020-12-18 Solano California 6095 15013 93
836295 2020-12-17 Solano California 6095 14718 93
833049 2020-12-16 Solano California 6095 14274 93
829802 2020-12-15 Solano California 6095 13902 91
826556 2020-12-14 Solano California 6095 13739 91
823309 2020-12-13 Solano California 6095 12753 91
820063 2020-12-12 Solano California 6095 12738 91
816817 2020-12-11 Solano California 6095 12738 91
813571 2020-12-10 Solano California 6095 12538 91
810327 2020-12-09 Solano California 6095 12128 90
807082 2020-12-08 Solano California 6095 11955 90
803837 2020-12-07 Solano California 6095 11752 85
800592 2020-12-06 Solano California 6095 11418 85
797347 2020-12-05 Solano California 6095 11418 85
794102 2020-12-04 Solano California 6095 11418 85
790857 2020-12-03 Solano California 6095 11124 81
787612 2020-12-02 Solano California 6095 10962 81
784368 2020-12-01 Solano California 6095 10736 81
781123 2020-11-30 Solano California 6095 10653 81
777877 2020-11-29 Solano California 6095 10257 81
774632 2020-11-28 Solano California 6095 10049 81
771387 2020-11-27 Solano California 6095 10041 81
768142 2020-11-26 Solano California 6095 10041 81
764896 2020-11-25 Solano California 6095 10041 81
761651 2020-11-24 Solano California 6095 9929 81

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