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

376 rows where fips = 6055 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6055 · 376

county

Link rowid date ▲ county state fips cases deaths
1095912 2021-03-07 Napa California 6055 9130 75
1092666 2021-03-06 Napa California 6055 9110 75
1089420 2021-03-05 Napa California 6055 9095 75
1086175 2021-03-04 Napa California 6055 9091 74
1082929 2021-03-03 Napa California 6055 9081 72
1079683 2021-03-02 Napa California 6055 9057 71
1076438 2021-03-01 Napa California 6055 9054 69
1073192 2021-02-28 Napa California 6055 9039 69
1069946 2021-02-27 Napa California 6055 9015 69
1066701 2021-02-26 Napa California 6055 8999 69
1063456 2021-02-25 Napa California 6055 8977 68
1060211 2021-02-24 Napa California 6055 8968 68
1056965 2021-02-23 Napa California 6055 8951 68
1053719 2021-02-22 Napa California 6055 8930 67
1050472 2021-02-21 Napa California 6055 8911 67
1047225 2021-02-20 Napa California 6055 8900 67
1043980 2021-02-19 Napa California 6055 8878 67
1040735 2021-02-18 Napa California 6055 8866 65
1037490 2021-02-17 Napa California 6055 8855 64
1034245 2021-02-16 Napa California 6055 8838 62
1030999 2021-02-15 Napa California 6055 8827 62
1027752 2021-02-14 Napa California 6055 8810 62
1024507 2021-02-13 Napa California 6055 8786 62
1021262 2021-02-12 Napa California 6055 8778 62
1018017 2021-02-11 Napa California 6055 8770 61
1014772 2021-02-10 Napa California 6055 8750 59
1011527 2021-02-09 Napa California 6055 8720 59
1008281 2021-02-08 Napa California 6055 8702 58
1005035 2021-02-07 Napa California 6055 8640 58
1001789 2021-02-06 Napa California 6055 8599 58
998543 2021-02-05 Napa California 6055 8574 58
995297 2021-02-04 Napa California 6055 8535 58
992051 2021-02-03 Napa California 6055 8506 57
988805 2021-02-02 Napa California 6055 8450 55
985558 2021-02-01 Napa California 6055 8405 54
982311 2021-01-31 Napa California 6055 8343 54
979065 2021-01-30 Napa California 6055 8277 54
975820 2021-01-29 Napa California 6055 8234 52
972575 2021-01-28 Napa California 6055 8188 52
969330 2021-01-27 Napa California 6055 8146 52
966086 2021-01-26 Napa California 6055 8071 50
962841 2021-01-25 Napa California 6055 8006 48
959596 2021-01-24 Napa California 6055 7894 47
956350 2021-01-23 Napa California 6055 7829 47
953105 2021-01-22 Napa California 6055 7775 46
949860 2021-01-21 Napa California 6055 7732 45
946614 2021-01-20 Napa California 6055 7673 44
943367 2021-01-19 Napa California 6055 7602 40
940122 2021-01-18 Napa California 6055 7522 39
936877 2021-01-17 Napa California 6055 7357 39
933632 2021-01-16 Napa California 6055 7232 39
930387 2021-01-15 Napa California 6055 7158 38
927142 2021-01-14 Napa California 6055 7040 38
923896 2021-01-13 Napa California 6055 6943 37
920651 2021-01-12 Napa California 6055 6881 36
917406 2021-01-11 Napa California 6055 6702 36
914161 2021-01-10 Napa California 6055 6595 36
910916 2021-01-09 Napa California 6055 6545 36
907671 2021-01-08 Napa California 6055 6477 35
904425 2021-01-07 Napa California 6055 6343 33
901180 2021-01-06 Napa California 6055 6283 32
897935 2021-01-05 Napa California 6055 6199 30
894690 2021-01-04 Napa California 6055 6095 29
891443 2021-01-03 Napa California 6055 5995 29
888196 2021-01-02 Napa California 6055 5900 29
884951 2021-01-01 Napa California 6055 5802 29
881706 2020-12-31 Napa California 6055 5742 28
878461 2020-12-30 Napa California 6055 5665 27
875216 2020-12-29 Napa California 6055 5616 27
871971 2020-12-28 Napa California 6055 5497 27
868726 2020-12-27 Napa California 6055 5428 27
865481 2020-12-26 Napa California 6055 5352 27
862236 2020-12-25 Napa California 6055 5266 27
858991 2020-12-24 Napa California 6055 5173 27
855746 2020-12-23 Napa California 6055 5092 26
852501 2020-12-22 Napa California 6055 4966 25
849256 2020-12-21 Napa California 6055 4866 24
846011 2020-12-20 Napa California 6055 4773 24
842765 2020-12-19 Napa California 6055 4689 24
839520 2020-12-18 Napa California 6055 4647 24
836275 2020-12-17 Napa California 6055 4545 24
833029 2020-12-16 Napa California 6055 4456 24
829782 2020-12-15 Napa California 6055 4384 24
826536 2020-12-14 Napa California 6055 4248 23
823289 2020-12-13 Napa California 6055 4114 23
820043 2020-12-12 Napa California 6055 4055 23
816797 2020-12-11 Napa California 6055 4014 23
813551 2020-12-10 Napa California 6055 3936 23
810307 2020-12-09 Napa California 6055 3814 22
807062 2020-12-08 Napa California 6055 3734 21
803817 2020-12-07 Napa California 6055 3651 20
800572 2020-12-06 Napa California 6055 3566 19
797327 2020-12-05 Napa California 6055 3433 19
794082 2020-12-04 Napa California 6055 3389 18
790837 2020-12-03 Napa California 6055 3299 18
787592 2020-12-02 Napa California 6055 3227 18
784348 2020-12-01 Napa California 6055 3096 18
781103 2020-11-30 Napa California 6055 3091 17
777857 2020-11-29 Napa California 6055 3034 17
774612 2020-11-28 Napa California 6055 2989 17

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