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

372 rows where fips = 6097 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6097 · 372

county

Link rowid date ▲ county state fips cases deaths
1082950 2021-03-03 Sonoma California 6097 28261 301
1079704 2021-03-02 Sonoma California 6097 28222 298
1076459 2021-03-01 Sonoma California 6097 28193 298
1073213 2021-02-28 Sonoma California 6097 28141 298
1069967 2021-02-27 Sonoma California 6097 28063 298
1066722 2021-02-26 Sonoma California 6097 28004 298
1063477 2021-02-25 Sonoma California 6097 27954 298
1060232 2021-02-24 Sonoma California 6097 27882 295
1056986 2021-02-23 Sonoma California 6097 27845 295
1053740 2021-02-22 Sonoma California 6097 27793 295
1050493 2021-02-21 Sonoma California 6097 27703 291
1047246 2021-02-20 Sonoma California 6097 27606 291
1044001 2021-02-19 Sonoma California 6097 27542 291
1040756 2021-02-18 Sonoma California 6097 27414 291
1037511 2021-02-17 Sonoma California 6097 27414 291
1034266 2021-02-16 Sonoma California 6097 27361 291
1031020 2021-02-15 Sonoma California 6097 27361 287
1027773 2021-02-14 Sonoma California 6097 27249 287
1024528 2021-02-13 Sonoma California 6097 27143 287
1021283 2021-02-12 Sonoma California 6097 27133 287
1018038 2021-02-11 Sonoma California 6097 27056 283
1014793 2021-02-10 Sonoma California 6097 26971 283
1011548 2021-02-09 Sonoma California 6097 26939 280
1008302 2021-02-08 Sonoma California 6097 26909 277
1005056 2021-02-07 Sonoma California 6097 26836 277
1001810 2021-02-06 Sonoma California 6097 26674 275
998564 2021-02-05 Sonoma California 6097 26595 275
995318 2021-02-04 Sonoma California 6097 26430 270
992072 2021-02-03 Sonoma California 6097 26306 267
988826 2021-02-02 Sonoma California 6097 26250 267
985579 2021-02-01 Sonoma California 6097 26189 265
982332 2021-01-31 Sonoma California 6097 26108 260
979086 2021-01-30 Sonoma California 6097 25992 260
975841 2021-01-29 Sonoma California 6097 25825 260
972596 2021-01-28 Sonoma California 6097 25678 260
969351 2021-01-27 Sonoma California 6097 25536 254
966107 2021-01-26 Sonoma California 6097 25160 251
962862 2021-01-25 Sonoma California 6097 25141 251
959617 2021-01-24 Sonoma California 6097 24935 247
956371 2021-01-23 Sonoma California 6097 24761 247
953126 2021-01-22 Sonoma California 6097 24571 245
949881 2021-01-21 Sonoma California 6097 24469 245
946635 2021-01-20 Sonoma California 6097 24184 242
943388 2021-01-19 Sonoma California 6097 24068 240
940143 2021-01-18 Sonoma California 6097 23871 240
936898 2021-01-17 Sonoma California 6097 23607 234
933653 2021-01-16 Sonoma California 6097 23204 234
930408 2021-01-15 Sonoma California 6097 23089 234
927163 2021-01-14 Sonoma California 6097 22840 234
923917 2021-01-13 Sonoma California 6097 22531 227
920672 2021-01-12 Sonoma California 6097 22191 219
917427 2021-01-11 Sonoma California 6097 21925 218
914182 2021-01-10 Sonoma California 6097 21393 218
910937 2021-01-09 Sonoma California 6097 21264 218
907692 2021-01-08 Sonoma California 6097 21067 218
904446 2021-01-07 Sonoma California 6097 20752 214
901201 2021-01-06 Sonoma California 6097 20501 213
897956 2021-01-05 Sonoma California 6097 20210 204
894711 2021-01-04 Sonoma California 6097 20015 196
891464 2021-01-03 Sonoma California 6097 19761 196
888217 2021-01-02 Sonoma California 6097 19513 196
884972 2021-01-01 Sonoma California 6097 19129 192
881727 2020-12-31 Sonoma California 6097 19055 192
878482 2020-12-30 Sonoma California 6097 18872 184
875237 2020-12-29 Sonoma California 6097 18872 184
871992 2020-12-28 Sonoma California 6097 18649 182
868747 2020-12-27 Sonoma California 6097 18539 182
865502 2020-12-26 Sonoma California 6097 18147 182
862257 2020-12-25 Sonoma California 6097 17903 181
859012 2020-12-24 Sonoma California 6097 17444 180
855767 2020-12-23 Sonoma California 6097 17444 180
852522 2020-12-22 Sonoma California 6097 17075 177
849277 2020-12-21 Sonoma California 6097 16802 174
846032 2020-12-20 Sonoma California 6097 16706 174
842786 2020-12-19 Sonoma California 6097 16495 174
839541 2020-12-18 Sonoma California 6097 16024 171
836296 2020-12-17 Sonoma California 6097 16024 171
833050 2020-12-16 Sonoma California 6097 15702 166
829803 2020-12-15 Sonoma California 6097 15096 166
826557 2020-12-14 Sonoma California 6097 14859 164
823310 2020-12-13 Sonoma California 6097 14705 162
820064 2020-12-12 Sonoma California 6097 14475 162
816818 2020-12-11 Sonoma California 6097 14282 162
813572 2020-12-10 Sonoma California 6097 14168 162
810328 2020-12-09 Sonoma California 6097 13912 162
807083 2020-12-08 Sonoma California 6097 13719 160
803838 2020-12-07 Sonoma California 6097 13439 160
800593 2020-12-06 Sonoma California 6097 13369 160
797348 2020-12-05 Sonoma California 6097 13098 160
794103 2020-12-04 Sonoma California 6097 13098 160
790858 2020-12-03 Sonoma California 6097 12923 160
787613 2020-12-02 Sonoma California 6097 12795 160
784369 2020-12-01 Sonoma California 6097 12662 160
781124 2020-11-30 Sonoma California 6097 12319 157
777878 2020-11-29 Sonoma California 6097 12198 157
774633 2020-11-28 Sonoma California 6097 12049 157
771388 2020-11-27 Sonoma California 6097 12049 157
768143 2020-11-26 Sonoma California 6097 11846 157
764897 2020-11-25 Sonoma California 6097 11846 157
761652 2020-11-24 Sonoma California 6097 11608 155

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