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

399 rows where fips = 6075 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6075 · 399

county

Link rowid date ▲ county state fips cases deaths
1092676 2021-03-06 San Francisco California 6075 34529 432
1089430 2021-03-05 San Francisco California 6075 34483 426
1086185 2021-03-04 San Francisco California 6075 34446 423
1082939 2021-03-03 San Francisco California 6075 34390 422
1079693 2021-03-02 San Francisco California 6075 34321 422
1076448 2021-03-01 San Francisco California 6075 34294 422
1073202 2021-02-28 San Francisco California 6075 34263 422
1069956 2021-02-27 San Francisco California 6075 34216 412
1066711 2021-02-26 San Francisco California 6075 34141 410
1063466 2021-02-25 San Francisco California 6075 34064 398
1060221 2021-02-24 San Francisco California 6075 33997 394
1056975 2021-02-23 San Francisco California 6075 33950 394
1053729 2021-02-22 San Francisco California 6075 33894 394
1050482 2021-02-21 San Francisco California 6075 33823 394
1047235 2021-02-20 San Francisco California 6075 33749 394
1043990 2021-02-19 San Francisco California 6075 33653 387
1040745 2021-02-18 San Francisco California 6075 33561 376
1037500 2021-02-17 San Francisco California 6075 33494 376
1034255 2021-02-16 San Francisco California 6075 33457 372
1031009 2021-02-15 San Francisco California 6075 33377 366
1027762 2021-02-14 San Francisco California 6075 33294 366
1024517 2021-02-13 San Francisco California 6075 33182 366
1021272 2021-02-12 San Francisco California 6075 33079 359
1018027 2021-02-11 San Francisco California 6075 32958 351
1014782 2021-02-10 San Francisco California 6075 32785 351
1011537 2021-02-09 San Francisco California 6075 32682 346
1008291 2021-02-08 San Francisco California 6075 32612 346
1005045 2021-02-07 San Francisco California 6075 32440 346
1001799 2021-02-06 San Francisco California 6075 32232 345
998553 2021-02-05 San Francisco California 6075 32119 345
995307 2021-02-04 San Francisco California 6075 31986 328
992061 2021-02-03 San Francisco California 6075 31791 328
988815 2021-02-02 San Francisco California 6075 31706 324
985568 2021-02-01 San Francisco California 6075 31566 324
982321 2021-01-31 San Francisco California 6075 31430 324
979075 2021-01-30 San Francisco California 6075 31297 323
975830 2021-01-29 San Francisco California 6075 31196 317
972585 2021-01-28 San Francisco California 6075 31085 308
969340 2021-01-27 San Francisco California 6075 30877 297
966096 2021-01-26 San Francisco California 6075 30737 293
962851 2021-01-25 San Francisco California 6075 30562 293
959606 2021-01-24 San Francisco California 6075 30311 293
956360 2021-01-23 San Francisco California 6075 30030 278
953115 2021-01-22 San Francisco California 6075 29804 275
949870 2021-01-21 San Francisco California 6075 29668 274
946624 2021-01-20 San Francisco California 6075 29505 266
943377 2021-01-19 San Francisco California 6075 29324 262
940132 2021-01-18 San Francisco California 6075 29142 262
936887 2021-01-17 San Francisco California 6075 28856 254
933642 2021-01-16 San Francisco California 6075 28577 254
930397 2021-01-15 San Francisco California 6075 28203 241
927152 2021-01-14 San Francisco California 6075 27866 237
923906 2021-01-13 San Francisco California 6075 27534 235
920661 2021-01-12 San Francisco California 6075 27267 235
917416 2021-01-11 San Francisco California 6075 27057 234
914171 2021-01-10 San Francisco California 6075 26711 233
910926 2021-01-09 San Francisco California 6075 26381 233
907681 2021-01-08 San Francisco California 6075 25888 218
904435 2021-01-07 San Francisco California 6075 25427 205
901190 2021-01-06 San Francisco California 6075 24992 203
897945 2021-01-05 San Francisco California 6075 24756 198
894700 2021-01-04 San Francisco California 6075 24591 194
891453 2021-01-03 San Francisco California 6075 24417 194
888206 2021-01-02 San Francisco California 6075 24148 194
884961 2021-01-01 San Francisco California 6075 23743 189
881716 2020-12-31 San Francisco California 6075 23227 186
878471 2020-12-30 San Francisco California 6075 22999 184
875226 2020-12-29 San Francisco California 6075 22729 182
871981 2020-12-28 San Francisco California 6075 22517 182
868736 2020-12-27 San Francisco California 6075 22322 182
865491 2020-12-26 San Francisco California 6075 22133 181
862246 2020-12-25 San Francisco California 6075 21833 181
859001 2020-12-24 San Francisco California 6075 21501 178
855756 2020-12-23 San Francisco California 6075 21235 178
852511 2020-12-22 San Francisco California 6075 21089 176
849266 2020-12-21 San Francisco California 6075 20940 176
846021 2020-12-20 San Francisco California 6075 20646 176
842775 2020-12-19 San Francisco California 6075 20318 176
839530 2020-12-18 San Francisco California 6075 19942 173
836285 2020-12-17 San Francisco California 6075 19627 172
833039 2020-12-16 San Francisco California 6075 19286 172
829792 2020-12-15 San Francisco California 6075 18907 167
826546 2020-12-14 San Francisco California 6075 18689 167
823299 2020-12-13 San Francisco California 6075 18416 167
820053 2020-12-12 San Francisco California 6075 18249 167
816807 2020-12-11 San Francisco California 6075 17948 167
813561 2020-12-10 San Francisco California 6075 17631 165
810317 2020-12-09 San Francisco California 6075 17387 164
807072 2020-12-08 San Francisco California 6075 17223 164
803827 2020-12-07 San Francisco California 6075 17110 164
800582 2020-12-06 San Francisco California 6075 16789 164
797337 2020-12-05 San Francisco California 6075 16502 164
794092 2020-12-04 San Francisco California 6075 16239 162
790847 2020-12-03 San Francisco California 6075 16061 161
787602 2020-12-02 San Francisco California 6075 15800 160
784358 2020-12-01 San Francisco California 6075 15642 160
781113 2020-11-30 San Francisco California 6075 15574 160
777867 2020-11-29 San Francisco California 6075 15453 160
774622 2020-11-28 San Francisco California 6075 15380 160
771377 2020-11-27 San Francisco California 6075 15159 160

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