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

367 rows where fips = 6061 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6061 · 367

county

Link rowid date ▲ county state fips cases deaths
1082932 2021-03-03 Placer California 6061 19911 232
1079686 2021-03-02 Placer California 6061 19882 232
1076441 2021-03-01 Placer California 6061 19861 232
1073195 2021-02-28 Placer California 6061 19763 232
1069949 2021-02-27 Placer California 6061 19763 232
1066704 2021-02-26 Placer California 6061 19763 232
1063459 2021-02-25 Placer California 6061 19713 231
1060214 2021-02-24 Placer California 6061 19702 231
1056968 2021-02-23 Placer California 6061 19661 231
1053722 2021-02-22 Placer California 6061 19646 230
1050475 2021-02-21 Placer California 6061 19520 229
1047228 2021-02-20 Placer California 6061 19520 229
1043983 2021-02-19 Placer California 6061 19520 229
1040738 2021-02-18 Placer California 6061 19462 229
1037493 2021-02-17 Placer California 6061 19457 223
1034248 2021-02-16 Placer California 6061 19433 223
1031002 2021-02-15 Placer California 6061 19313 222
1027755 2021-02-14 Placer California 6061 19214 222
1024510 2021-02-13 Placer California 6061 19175 222
1021265 2021-02-12 Placer California 6061 19175 222
1018020 2021-02-11 Placer California 6061 19175 222
1014775 2021-02-10 Placer California 6061 19121 217
1011530 2021-02-09 Placer California 6061 19036 216
1008284 2021-02-08 Placer California 6061 18973 214
1005038 2021-02-07 Placer California 6061 18836 206
1001792 2021-02-06 Placer California 6061 18784 206
998546 2021-02-05 Placer California 6061 18784 206
995300 2021-02-04 Placer California 6061 18738 206
992054 2021-02-03 Placer California 6061 18670 205
988808 2021-02-02 Placer California 6061 18638 201
985561 2021-02-01 Placer California 6061 18608 201
982314 2021-01-31 Placer California 6061 18430 199
979068 2021-01-30 Placer California 6061 18399 199
975823 2021-01-29 Placer California 6061 18399 199
972578 2021-01-28 Placer California 6061 18267 192
969333 2021-01-27 Placer California 6061 18129 192
966089 2021-01-26 Placer California 6061 18034 188
962844 2021-01-25 Placer California 6061 17839 188
959599 2021-01-24 Placer California 6061 17675 188
956353 2021-01-23 Placer California 6061 17675 188
953108 2021-01-22 Placer California 6061 17675 188
949863 2021-01-21 Placer California 6061 17584 186
946617 2021-01-20 Placer California 6061 17490 184
943370 2021-01-19 Placer California 6061 17380 180
940125 2021-01-18 Placer California 6061 17194 173
936880 2021-01-17 Placer California 6061 16995 173
933635 2021-01-16 Placer California 6061 16761 173
930390 2021-01-15 Placer California 6061 16761 173
927145 2021-01-14 Placer California 6061 16532 172
923899 2021-01-13 Placer California 6061 16317 170
920654 2021-01-12 Placer California 6061 16135 161
917409 2021-01-11 Placer California 6061 15978 161
914164 2021-01-10 Placer California 6061 15609 159
910919 2021-01-09 Placer California 6061 15454 159
907674 2021-01-08 Placer California 6061 15454 159
904428 2021-01-07 Placer California 6061 15233 142
901183 2021-01-06 Placer California 6061 15015 132
897938 2021-01-05 Placer California 6061 14800 132
894693 2021-01-04 Placer California 6061 14317 125
891446 2021-01-03 Placer California 6061 14182 125
888199 2021-01-02 Placer California 6061 13987 125
884954 2021-01-01 Placer California 6061 13755 125
881709 2020-12-31 Placer California 6061 13755 125
878464 2020-12-30 Placer California 6061 13550 125
875219 2020-12-29 Placer California 6061 13272 125
871974 2020-12-28 Placer California 6061 13055 125
868729 2020-12-27 Placer California 6061 12816 120
865484 2020-12-26 Placer California 6061 12660 120
862239 2020-12-25 Placer California 6061 12457 120
858994 2020-12-24 Placer California 6061 12262 120
855749 2020-12-23 Placer California 6061 11968 110
852504 2020-12-22 Placer California 6061 11761 109
849259 2020-12-21 Placer California 6061 11541 104
846014 2020-12-20 Placer California 6061 11246 103
842768 2020-12-19 Placer California 6061 10995 103
839523 2020-12-18 Placer California 6061 10776 103
836278 2020-12-17 Placer California 6061 10554 98
833032 2020-12-16 Placer California 6061 10301 97
829785 2020-12-15 Placer California 6061 9722 94
826539 2020-12-14 Placer California 6061 9549 93
823292 2020-12-13 Placer California 6061 9390 92
820046 2020-12-12 Placer California 6061 8904 92
816800 2020-12-11 Placer California 6061 8906 92
813554 2020-12-10 Placer California 6061 8860 89
810310 2020-12-09 Placer California 6061 8544 85
807065 2020-12-08 Placer California 6061 8173 81
803820 2020-12-07 Placer California 6061 7979 81
800575 2020-12-06 Placer California 6061 7811 74
797330 2020-12-05 Placer California 6061 7461 74
794085 2020-12-04 Placer California 6061 7270 74
790840 2020-12-03 Placer California 6061 6941 72
787595 2020-12-02 Placer California 6061 6794 71
784351 2020-12-01 Placer California 6061 6664 71
781106 2020-11-30 Placer California 6061 6622 70
777860 2020-11-29 Placer California 6061 6497 68
774615 2020-11-28 Placer California 6061 6354 68
771370 2020-11-27 Placer California 6061 6354 68
768125 2020-11-26 Placer California 6061 6224 68
764879 2020-11-25 Placer California 6061 6224 68
761634 2020-11-24 Placer California 6061 6148 68

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