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

326 rows where fips = 6097 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6097 · 326

county

Link rowid date ▲ county state fips cases deaths
933733 2021-01-16 Sonoma California 6097 23204 234
930488 2021-01-15 Sonoma California 6097 23089 234
927243 2021-01-14 Sonoma California 6097 22840 234
923997 2021-01-13 Sonoma California 6097 22531 227
920752 2021-01-12 Sonoma California 6097 22191 219
917507 2021-01-11 Sonoma California 6097 21925 218
914262 2021-01-10 Sonoma California 6097 21393 218
911017 2021-01-09 Sonoma California 6097 21264 218
907772 2021-01-08 Sonoma California 6097 21067 218
904526 2021-01-07 Sonoma California 6097 20752 214
901281 2021-01-06 Sonoma California 6097 20501 213
898036 2021-01-05 Sonoma California 6097 20210 204
894791 2021-01-04 Sonoma California 6097 20015 196
891544 2021-01-03 Sonoma California 6097 19761 196
888297 2021-01-02 Sonoma California 6097 19513 196
885052 2021-01-01 Sonoma California 6097 19129 192
881807 2020-12-31 Sonoma California 6097 19055 192
878562 2020-12-30 Sonoma California 6097 18872 184
875317 2020-12-29 Sonoma California 6097 18872 184
872072 2020-12-28 Sonoma California 6097 18649 182
868827 2020-12-27 Sonoma California 6097 18539 182
865582 2020-12-26 Sonoma California 6097 18147 182
862337 2020-12-25 Sonoma California 6097 17903 181
859092 2020-12-24 Sonoma California 6097 17444 180
855847 2020-12-23 Sonoma California 6097 17444 180
852602 2020-12-22 Sonoma California 6097 17075 177
849357 2020-12-21 Sonoma California 6097 16802 174
846112 2020-12-20 Sonoma California 6097 16706 174
842866 2020-12-19 Sonoma California 6097 16495 174
839621 2020-12-18 Sonoma California 6097 16024 171
836376 2020-12-17 Sonoma California 6097 16024 171
833130 2020-12-16 Sonoma California 6097 15702 166
829883 2020-12-15 Sonoma California 6097 15096 166
826637 2020-12-14 Sonoma California 6097 14859 164
823390 2020-12-13 Sonoma California 6097 14705 162
820144 2020-12-12 Sonoma California 6097 14475 162
816898 2020-12-11 Sonoma California 6097 14282 162
813652 2020-12-10 Sonoma California 6097 14168 162
810408 2020-12-09 Sonoma California 6097 13912 162
807163 2020-12-08 Sonoma California 6097 13719 160
803918 2020-12-07 Sonoma California 6097 13439 160
800672 2020-12-06 Sonoma California 6097 13369 160
797426 2020-12-05 Sonoma California 6097 13098 160
794181 2020-12-04 Sonoma California 6097 13098 160
790935 2020-12-03 Sonoma California 6097 12923 160
787689 2020-12-02 Sonoma California 6097 12795 160
784445 2020-12-01 Sonoma California 6097 12662 160
781200 2020-11-30 Sonoma California 6097 12319 157
777954 2020-11-29 Sonoma California 6097 12198 157
774708 2020-11-28 Sonoma California 6097 12049 157
771463 2020-11-27 Sonoma California 6097 12049 157
768217 2020-11-26 Sonoma California 6097 11846 157
764970 2020-11-25 Sonoma California 6097 11846 157
761724 2020-11-24 Sonoma California 6097 11608 155
758478 2020-11-23 Sonoma California 6097 11608 155
755231 2020-11-22 Sonoma California 6097 11486 155
751984 2020-11-21 Sonoma California 6097 11428 155
748737 2020-11-20 Sonoma California 6097 11363 155
745490 2020-11-19 Sonoma California 6097 11316 150
742243 2020-11-18 Sonoma California 6097 11169 150
738996 2020-11-17 Sonoma California 6097 11133 150
735751 2020-11-16 Sonoma California 6097 11055 150
732505 2020-11-15 Sonoma California 6097 10970 149
729260 2020-11-14 Sonoma California 6097 10845 149
726016 2020-11-13 Sonoma California 6097 10679 149
722772 2020-11-12 Sonoma California 6097 10679 149
719528 2020-11-11 Sonoma California 6097 10606 149
716284 2020-11-10 Sonoma California 6097 10505 149
713040 2020-11-09 Sonoma California 6097 10424 146
709796 2020-11-08 Sonoma California 6097 10248 146
706552 2020-11-07 Sonoma California 6097 10248 146
703309 2020-11-06 Sonoma California 6097 10170 146
700065 2020-11-05 Sonoma California 6097 10116 146
696820 2020-11-04 Sonoma California 6097 10041 142
693577 2020-11-03 Sonoma California 6097 9953 142
690334 2020-11-02 Sonoma California 6097 9866 142
687089 2020-11-01 Sonoma California 6097 9686 136
683844 2020-10-31 Sonoma California 6097 9686 136
680600 2020-10-30 Sonoma California 6097 9646 136
677357 2020-10-29 Sonoma California 6097 9601 136
674113 2020-10-28 Sonoma California 6097 9569 136
670871 2020-10-27 Sonoma California 6097 9494 136
667628 2020-10-26 Sonoma California 6097 9402 136
664382 2020-10-25 Sonoma California 6097 9312 136
661137 2020-10-24 Sonoma California 6097 9245 134
657893 2020-10-23 Sonoma California 6097 9163 134
654648 2020-10-22 Sonoma California 6097 9099 134
651403 2020-10-21 Sonoma California 6097 9073 134
648159 2020-10-20 Sonoma California 6097 9016 134
644914 2020-10-19 Sonoma California 6097 8934 129
641666 2020-10-18 Sonoma California 6097 8858 129
638419 2020-10-17 Sonoma California 6097 8810 129
635174 2020-10-16 Sonoma California 6097 8717 129
631928 2020-10-15 Sonoma California 6097 8684 128
628684 2020-10-14 Sonoma California 6097 8615 128
625441 2020-10-13 Sonoma California 6097 8558 128
622198 2020-10-12 Sonoma California 6097 8500 128
618955 2020-10-11 Sonoma California 6097 8422 128
615713 2020-10-10 Sonoma California 6097 8352 126
612472 2020-10-09 Sonoma California 6097 8270 126

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