⚠️ 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 = 6055 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6055 · 327

county

Link rowid date ▲ county state fips cases deaths
936957 2021-01-17 Napa California 6055 7357 39
933712 2021-01-16 Napa California 6055 7232 39
930467 2021-01-15 Napa California 6055 7158 38
927222 2021-01-14 Napa California 6055 7040 38
923976 2021-01-13 Napa California 6055 6943 37
920731 2021-01-12 Napa California 6055 6881 36
917486 2021-01-11 Napa California 6055 6702 36
914241 2021-01-10 Napa California 6055 6595 36
910996 2021-01-09 Napa California 6055 6545 36
907751 2021-01-08 Napa California 6055 6477 35
904505 2021-01-07 Napa California 6055 6343 33
901260 2021-01-06 Napa California 6055 6283 32
898015 2021-01-05 Napa California 6055 6199 30
894770 2021-01-04 Napa California 6055 6095 29
891523 2021-01-03 Napa California 6055 5995 29
888276 2021-01-02 Napa California 6055 5900 29
885031 2021-01-01 Napa California 6055 5802 29
881786 2020-12-31 Napa California 6055 5742 28
878541 2020-12-30 Napa California 6055 5665 27
875296 2020-12-29 Napa California 6055 5616 27
872051 2020-12-28 Napa California 6055 5497 27
868806 2020-12-27 Napa California 6055 5428 27
865561 2020-12-26 Napa California 6055 5352 27
862316 2020-12-25 Napa California 6055 5266 27
859071 2020-12-24 Napa California 6055 5173 27
855826 2020-12-23 Napa California 6055 5092 26
852581 2020-12-22 Napa California 6055 4966 25
849336 2020-12-21 Napa California 6055 4866 24
846091 2020-12-20 Napa California 6055 4773 24
842845 2020-12-19 Napa California 6055 4689 24
839600 2020-12-18 Napa California 6055 4647 24
836355 2020-12-17 Napa California 6055 4545 24
833109 2020-12-16 Napa California 6055 4456 24
829862 2020-12-15 Napa California 6055 4384 24
826616 2020-12-14 Napa California 6055 4248 23
823369 2020-12-13 Napa California 6055 4114 23
820123 2020-12-12 Napa California 6055 4055 23
816877 2020-12-11 Napa California 6055 4014 23
813631 2020-12-10 Napa California 6055 3936 23
810387 2020-12-09 Napa California 6055 3814 22
807142 2020-12-08 Napa California 6055 3734 21
803897 2020-12-07 Napa California 6055 3651 20
800651 2020-12-06 Napa California 6055 3566 19
797405 2020-12-05 Napa California 6055 3433 19
794160 2020-12-04 Napa California 6055 3389 18
790914 2020-12-03 Napa California 6055 3299 18
787668 2020-12-02 Napa California 6055 3227 18
784424 2020-12-01 Napa California 6055 3096 18
781179 2020-11-30 Napa California 6055 3091 17
777933 2020-11-29 Napa California 6055 3034 17
774687 2020-11-28 Napa California 6055 2989 17
771442 2020-11-27 Napa California 6055 2989 17
768196 2020-11-26 Napa California 6055 2946 17
764949 2020-11-25 Napa California 6055 2932 17
761703 2020-11-24 Napa California 6055 2885 17
758457 2020-11-23 Napa California 6055 2788 17
755210 2020-11-22 Napa California 6055 2758 17
751963 2020-11-21 Napa California 6055 2719 17
748716 2020-11-20 Napa California 6055 2696 17
745469 2020-11-19 Napa California 6055 2624 17
742222 2020-11-18 Napa California 6055 2591 17
738975 2020-11-17 Napa California 6055 2554 17
735730 2020-11-16 Napa California 6055 2522 17
732484 2020-11-15 Napa California 6055 2474 17
729239 2020-11-14 Napa California 6055 2441 17
725995 2020-11-13 Napa California 6055 2433 17
722751 2020-11-12 Napa California 6055 2386 17
719507 2020-11-11 Napa California 6055 2342 17
716263 2020-11-10 Napa California 6055 2332 16
713019 2020-11-09 Napa California 6055 2300 16
709775 2020-11-08 Napa California 6055 2243 16
706531 2020-11-07 Napa California 6055 2190 16
703288 2020-11-06 Napa California 6055 2182 16
700044 2020-11-05 Napa California 6055 2150 16
696799 2020-11-04 Napa California 6055 2131 16
693556 2020-11-03 Napa California 6055 2109 16
690313 2020-11-02 Napa California 6055 2076 16
687068 2020-11-01 Napa California 6055 2041 16
683823 2020-10-31 Napa California 6055 2029 16
680579 2020-10-30 Napa California 6055 2022 16
677336 2020-10-29 Napa California 6055 2003 16
674092 2020-10-28 Napa California 6055 1993 16
670850 2020-10-27 Napa California 6055 1976 16
667607 2020-10-26 Napa California 6055 1963 15
664361 2020-10-25 Napa California 6055 1958 15
661116 2020-10-24 Napa California 6055 1943 15
657872 2020-10-23 Napa California 6055 1938 15
654627 2020-10-22 Napa California 6055 1924 15
651382 2020-10-21 Napa California 6055 1914 14
648138 2020-10-20 Napa California 6055 1909 14
644893 2020-10-19 Napa California 6055 1889 14
641645 2020-10-18 Napa California 6055 1867 14
638398 2020-10-17 Napa California 6055 1856 14
635153 2020-10-16 Napa California 6055 1852 14
631907 2020-10-15 Napa California 6055 1841 14
628663 2020-10-14 Napa California 6055 1833 14
625420 2020-10-13 Napa California 6055 1824 14
622177 2020-10-12 Napa California 6055 1818 13
618934 2020-10-11 Napa California 6055 1805 13
615692 2020-10-10 Napa California 6055 1796 13

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