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

327 rows where fips = 6061 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6061 · 327

county

Link rowid date ▲ county state fips cases deaths
953188 2021-01-22 Placer California 6061 17675 188
949943 2021-01-21 Placer California 6061 17584 186
946697 2021-01-20 Placer California 6061 17490 184
943450 2021-01-19 Placer California 6061 17380 180
940205 2021-01-18 Placer California 6061 17194 173
936960 2021-01-17 Placer California 6061 16995 173
933715 2021-01-16 Placer California 6061 16761 173
930470 2021-01-15 Placer California 6061 16761 173
927225 2021-01-14 Placer California 6061 16532 172
923979 2021-01-13 Placer California 6061 16317 170
920734 2021-01-12 Placer California 6061 16135 161
917489 2021-01-11 Placer California 6061 15978 161
914244 2021-01-10 Placer California 6061 15609 159
910999 2021-01-09 Placer California 6061 15454 159
907754 2021-01-08 Placer California 6061 15454 159
904508 2021-01-07 Placer California 6061 15233 142
901263 2021-01-06 Placer California 6061 15015 132
898018 2021-01-05 Placer California 6061 14800 132
894773 2021-01-04 Placer California 6061 14317 125
891526 2021-01-03 Placer California 6061 14182 125
888279 2021-01-02 Placer California 6061 13987 125
885034 2021-01-01 Placer California 6061 13755 125
881789 2020-12-31 Placer California 6061 13755 125
878544 2020-12-30 Placer California 6061 13550 125
875299 2020-12-29 Placer California 6061 13272 125
872054 2020-12-28 Placer California 6061 13055 125
868809 2020-12-27 Placer California 6061 12816 120
865564 2020-12-26 Placer California 6061 12660 120
862319 2020-12-25 Placer California 6061 12457 120
859074 2020-12-24 Placer California 6061 12262 120
855829 2020-12-23 Placer California 6061 11968 110
852584 2020-12-22 Placer California 6061 11761 109
849339 2020-12-21 Placer California 6061 11541 104
846094 2020-12-20 Placer California 6061 11246 103
842848 2020-12-19 Placer California 6061 10995 103
839603 2020-12-18 Placer California 6061 10776 103
836358 2020-12-17 Placer California 6061 10554 98
833112 2020-12-16 Placer California 6061 10301 97
829865 2020-12-15 Placer California 6061 9722 94
826619 2020-12-14 Placer California 6061 9549 93
823372 2020-12-13 Placer California 6061 9390 92
820126 2020-12-12 Placer California 6061 8904 92
816880 2020-12-11 Placer California 6061 8906 92
813634 2020-12-10 Placer California 6061 8860 89
810390 2020-12-09 Placer California 6061 8544 85
807145 2020-12-08 Placer California 6061 8173 81
803900 2020-12-07 Placer California 6061 7979 81
800654 2020-12-06 Placer California 6061 7811 74
797408 2020-12-05 Placer California 6061 7461 74
794163 2020-12-04 Placer California 6061 7270 74
790917 2020-12-03 Placer California 6061 6941 72
787671 2020-12-02 Placer California 6061 6794 71
784427 2020-12-01 Placer California 6061 6664 71
781182 2020-11-30 Placer California 6061 6622 70
777936 2020-11-29 Placer California 6061 6497 68
774690 2020-11-28 Placer California 6061 6354 68
771445 2020-11-27 Placer California 6061 6354 68
768199 2020-11-26 Placer California 6061 6224 68
764952 2020-11-25 Placer California 6061 6224 68
761706 2020-11-24 Placer California 6061 6148 68
758460 2020-11-23 Placer California 6061 6071 67
755213 2020-11-22 Placer California 6061 5778 67
751966 2020-11-21 Placer California 6061 5687 67
748719 2020-11-20 Placer California 6061 5687 67
745472 2020-11-19 Placer California 6061 5642 66
742225 2020-11-18 Placer California 6061 5543 65
738978 2020-11-17 Placer California 6061 5489 64
735733 2020-11-16 Placer California 6061 5397 64
732487 2020-11-15 Placer California 6061 5215 63
729242 2020-11-14 Placer California 6061 5134 63
725998 2020-11-13 Placer California 6061 5134 63
722754 2020-11-12 Placer California 6061 5056 62
719510 2020-11-11 Placer California 6061 4993 60
716266 2020-11-10 Placer California 6061 4912 60
713022 2020-11-09 Placer California 6061 4853 60
709778 2020-11-08 Placer California 6061 4720 60
706534 2020-11-07 Placer California 6061 4692 60
703291 2020-11-06 Placer California 6061 4692 60
700047 2020-11-05 Placer California 6061 4640 60
696802 2020-11-04 Placer California 6061 4542 60
693559 2020-11-03 Placer California 6061 4527 60
690316 2020-11-02 Placer California 6061 4467 59
687071 2020-11-01 Placer California 6061 4374 59
683826 2020-10-31 Placer California 6061 4353 59
680582 2020-10-30 Placer California 6061 4353 59
677339 2020-10-29 Placer California 6061 4290 59
674095 2020-10-28 Placer California 6061 4248 57
670853 2020-10-27 Placer California 6061 4207 57
667610 2020-10-26 Placer California 6061 4178 57
664364 2020-10-25 Placer California 6061 4093 57
661119 2020-10-24 Placer California 6061 4088 57
657875 2020-10-23 Placer California 6061 4088 57
654630 2020-10-22 Placer California 6061 4052 57
651385 2020-10-21 Placer California 6061 4023 55
648141 2020-10-20 Placer California 6061 4012 55
644896 2020-10-19 Placer California 6061 3978 52
641648 2020-10-18 Placer California 6061 3898 52
638401 2020-10-17 Placer California 6061 3880 52
635156 2020-10-16 Placer California 6061 3880 52
631910 2020-10-15 Placer California 6061 3864 52

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