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

347 rows where fips = 6075 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6075 · 347

county

Link rowid date ▲ county state fips cases deaths
923986 2021-01-13 San Francisco California 6075 27534 235
920741 2021-01-12 San Francisco California 6075 27267 235
917496 2021-01-11 San Francisco California 6075 27057 234
914251 2021-01-10 San Francisco California 6075 26711 233
911006 2021-01-09 San Francisco California 6075 26381 233
907761 2021-01-08 San Francisco California 6075 25888 218
904515 2021-01-07 San Francisco California 6075 25427 205
901270 2021-01-06 San Francisco California 6075 24992 203
898025 2021-01-05 San Francisco California 6075 24756 198
894780 2021-01-04 San Francisco California 6075 24591 194
891533 2021-01-03 San Francisco California 6075 24417 194
888286 2021-01-02 San Francisco California 6075 24148 194
885041 2021-01-01 San Francisco California 6075 23743 189
881796 2020-12-31 San Francisco California 6075 23227 186
878551 2020-12-30 San Francisco California 6075 22999 184
875306 2020-12-29 San Francisco California 6075 22729 182
872061 2020-12-28 San Francisco California 6075 22517 182
868816 2020-12-27 San Francisco California 6075 22322 182
865571 2020-12-26 San Francisco California 6075 22133 181
862326 2020-12-25 San Francisco California 6075 21833 181
859081 2020-12-24 San Francisco California 6075 21501 178
855836 2020-12-23 San Francisco California 6075 21235 178
852591 2020-12-22 San Francisco California 6075 21089 176
849346 2020-12-21 San Francisco California 6075 20940 176
846101 2020-12-20 San Francisco California 6075 20646 176
842855 2020-12-19 San Francisco California 6075 20318 176
839610 2020-12-18 San Francisco California 6075 19942 173
836365 2020-12-17 San Francisco California 6075 19627 172
833119 2020-12-16 San Francisco California 6075 19286 172
829872 2020-12-15 San Francisco California 6075 18907 167
826626 2020-12-14 San Francisco California 6075 18689 167
823379 2020-12-13 San Francisco California 6075 18416 167
820133 2020-12-12 San Francisco California 6075 18249 167
816887 2020-12-11 San Francisco California 6075 17948 167
813641 2020-12-10 San Francisco California 6075 17631 165
810397 2020-12-09 San Francisco California 6075 17387 164
807152 2020-12-08 San Francisco California 6075 17223 164
803907 2020-12-07 San Francisco California 6075 17110 164
800661 2020-12-06 San Francisco California 6075 16789 164
797415 2020-12-05 San Francisco California 6075 16502 164
794170 2020-12-04 San Francisco California 6075 16239 162
790924 2020-12-03 San Francisco California 6075 16061 161
787678 2020-12-02 San Francisco California 6075 15800 160
784434 2020-12-01 San Francisco California 6075 15642 160
781189 2020-11-30 San Francisco California 6075 15574 160
777943 2020-11-29 San Francisco California 6075 15453 160
774697 2020-11-28 San Francisco California 6075 15380 160
771452 2020-11-27 San Francisco California 6075 15159 160
768206 2020-11-26 San Francisco California 6075 15056 160
764959 2020-11-25 San Francisco California 6075 14877 160
761713 2020-11-24 San Francisco California 6075 14665 158
758467 2020-11-23 San Francisco California 6075 14545 158
755220 2020-11-22 San Francisco California 6075 14448 158
751973 2020-11-21 San Francisco California 6075 14330 158
748726 2020-11-20 San Francisco California 6075 14254 156
745479 2020-11-19 San Francisco California 6075 14060 156
742232 2020-11-18 San Francisco California 6075 13955 156
738985 2020-11-17 San Francisco California 6075 13850 156
735740 2020-11-16 San Francisco California 6075 13760 156
732494 2020-11-15 San Francisco California 6075 13668 156
729249 2020-11-14 San Francisco California 6075 13519 155
726005 2020-11-13 San Francisco California 6075 13407 153
722761 2020-11-12 San Francisco California 6075 13311 153
719517 2020-11-11 San Francisco California 6075 13213 153
716273 2020-11-10 San Francisco California 6075 13142 151
713029 2020-11-09 San Francisco California 6075 13084 151
709785 2020-11-08 San Francisco California 6075 12983 151
706541 2020-11-07 San Francisco California 6075 12863 151
703298 2020-11-06 San Francisco California 6075 12756 151
700054 2020-11-05 San Francisco California 6075 12669 149
696809 2020-11-04 San Francisco California 6075 12602 149
693566 2020-11-03 San Francisco California 6075 12557 149
690323 2020-11-02 San Francisco California 6075 12511 148
687078 2020-11-01 San Francisco California 6075 12457 148
683833 2020-10-31 San Francisco California 6075 12402 148
680589 2020-10-30 San Francisco California 6075 12323 147
677346 2020-10-29 San Francisco California 6075 12280 145
674102 2020-10-28 San Francisco California 6075 12244 145
670860 2020-10-27 San Francisco California 6075 12192 140
667617 2020-10-26 San Francisco California 6075 12155 140
664371 2020-10-25 San Francisco California 6075 12106 140
661126 2020-10-24 San Francisco California 6075 12072 140
657882 2020-10-23 San Francisco California 6075 12035 140
654637 2020-10-22 San Francisco California 6075 12003 138
651392 2020-10-21 San Francisco California 6075 12016 137
648148 2020-10-20 San Francisco California 6075 11940 133
644903 2020-10-19 San Francisco California 6075 11904 133
641655 2020-10-18 San Francisco California 6075 11880 133
638408 2020-10-17 San Francisco California 6075 11843 133
635163 2020-10-16 San Francisco California 6075 11811 131
631917 2020-10-15 San Francisco California 6075 11786 126
628673 2020-10-14 San Francisco California 6075 11715 123
625430 2020-10-13 San Francisco California 6075 11694 123
622187 2020-10-12 San Francisco California 6075 11669 123
618944 2020-10-11 San Francisco California 6075 11666 123
615702 2020-10-10 San Francisco California 6075 11623 123
612461 2020-10-09 San Francisco California 6075 11611 121
609219 2020-10-08 San Francisco California 6075 11554 115
605976 2020-10-07 San Francisco California 6075 11536 114
602734 2020-10-06 San Francisco California 6075 11508 111

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