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

337 rows where fips = 6023 sorted by date descending

View and edit SQL

Suggested facets: deaths, date (date)

state

fips

  • 6023 · 337

county

Link rowid date ▲ county state fips cases deaths
949924 2021-01-21 Humboldt California 6023 2458 25
946678 2021-01-20 Humboldt California 6023 2427 25
943431 2021-01-19 Humboldt California 6023 2393 24
940186 2021-01-18 Humboldt California 6023 2322 24
936941 2021-01-17 Humboldt California 6023 2294 24
933696 2021-01-16 Humboldt California 6023 2263 24
930451 2021-01-15 Humboldt California 6023 2263 24
927206 2021-01-14 Humboldt California 6023 2220 24
923960 2021-01-13 Humboldt California 6023 2171 24
920715 2021-01-12 Humboldt California 6023 2138 24
917470 2021-01-11 Humboldt California 6023 2124 23
914225 2021-01-10 Humboldt California 6023 2031 23
910980 2021-01-09 Humboldt California 6023 2031 23
907735 2021-01-08 Humboldt California 6023 2031 23
904489 2021-01-07 Humboldt California 6023 1998 23
901244 2021-01-06 Humboldt California 6023 1957 23
897999 2021-01-05 Humboldt California 6023 1928 23
894754 2021-01-04 Humboldt California 6023 1910 22
891507 2021-01-03 Humboldt California 6023 1815 22
888260 2021-01-02 Humboldt California 6023 1783 22
885015 2021-01-01 Humboldt California 6023 1764 22
881770 2020-12-31 Humboldt California 6023 1764 22
878525 2020-12-30 Humboldt California 6023 1731 22
875280 2020-12-29 Humboldt California 6023 1678 20
872035 2020-12-28 Humboldt California 6023 1647 20
868790 2020-12-27 Humboldt California 6023 1584 18
865545 2020-12-26 Humboldt California 6023 1584 18
862300 2020-12-25 Humboldt California 6023 1539 17
859055 2020-12-24 Humboldt California 6023 1539 17
855810 2020-12-23 Humboldt California 6023 1539 17
852565 2020-12-22 Humboldt California 6023 1512 16
849320 2020-12-21 Humboldt California 6023 1500 16
846075 2020-12-20 Humboldt California 6023 1387 15
842829 2020-12-19 Humboldt California 6023 1387 15
839584 2020-12-18 Humboldt California 6023 1387 15
836339 2020-12-17 Humboldt California 6023 1374 15
833093 2020-12-16 Humboldt California 6023 1357 14
829846 2020-12-15 Humboldt California 6023 1321 13
826600 2020-12-14 Humboldt California 6023 1295 12
823353 2020-12-13 Humboldt California 6023 1231 10
820107 2020-12-12 Humboldt California 6023 1231 10
816861 2020-12-11 Humboldt California 6023 1231 10
813615 2020-12-10 Humboldt California 6023 1195 10
810371 2020-12-09 Humboldt California 6023 1163 10
807126 2020-12-08 Humboldt California 6023 1137 9
803881 2020-12-07 Humboldt California 6023 1102 9
800635 2020-12-06 Humboldt California 6023 1014 9
797389 2020-12-05 Humboldt California 6023 1014 9
794144 2020-12-04 Humboldt California 6023 1014 9
790898 2020-12-03 Humboldt California 6023 993 9
787652 2020-12-02 Humboldt California 6023 949 9
784408 2020-12-01 Humboldt California 6023 919 9
781163 2020-11-30 Humboldt California 6023 898 9
777917 2020-11-29 Humboldt California 6023 850 9
774671 2020-11-28 Humboldt California 6023 850 9
771426 2020-11-27 Humboldt California 6023 850 9
768180 2020-11-26 Humboldt California 6023 819 9
764933 2020-11-25 Humboldt California 6023 819 9
761687 2020-11-24 Humboldt California 6023 801 9
758441 2020-11-23 Humboldt California 6023 784 9
755194 2020-11-22 Humboldt California 6023 730 9
751947 2020-11-21 Humboldt California 6023 730 9
748700 2020-11-20 Humboldt California 6023 730 9
745453 2020-11-19 Humboldt California 6023 711 9
742206 2020-11-18 Humboldt California 6023 699 9
738959 2020-11-17 Humboldt California 6023 695 10
735714 2020-11-16 Humboldt California 6023 687 10
732468 2020-11-15 Humboldt California 6023 658 10
729223 2020-11-14 Humboldt California 6023 658 10
725979 2020-11-13 Humboldt California 6023 658 10
722735 2020-11-12 Humboldt California 6023 653 10
719491 2020-11-11 Humboldt California 6023 624 10
716247 2020-11-10 Humboldt California 6023 624 10
713003 2020-11-09 Humboldt California 6023 621 10
709759 2020-11-08 Humboldt California 6023 605 10
706515 2020-11-07 Humboldt California 6023 605 10
703272 2020-11-06 Humboldt California 6023 605 10
700028 2020-11-05 Humboldt California 6023 599 10
696783 2020-11-04 Humboldt California 6023 592 10
693540 2020-11-03 Humboldt California 6023 586 10
690297 2020-11-02 Humboldt California 6023 579 10
687052 2020-11-01 Humboldt California 6023 571 10
683807 2020-10-31 Humboldt California 6023 571 10
680563 2020-10-30 Humboldt California 6023 571 10
677320 2020-10-29 Humboldt California 6023 569 10
674076 2020-10-28 Humboldt California 6023 568 10
670834 2020-10-27 Humboldt California 6023 568 10
667591 2020-10-26 Humboldt California 6023 567 10
664345 2020-10-25 Humboldt California 6023 562 9
661100 2020-10-24 Humboldt California 6023 562 9
657856 2020-10-23 Humboldt California 6023 562 9
654611 2020-10-22 Humboldt California 6023 561 9
651366 2020-10-21 Humboldt California 6023 560 9
648122 2020-10-20 Humboldt California 6023 558 9
644877 2020-10-19 Humboldt California 6023 554 9
641629 2020-10-18 Humboldt California 6023 544 8
638382 2020-10-17 Humboldt California 6023 544 8
635137 2020-10-16 Humboldt California 6023 544 8
631891 2020-10-15 Humboldt California 6023 544 8
628647 2020-10-14 Humboldt California 6023 542 8

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