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

342 rows where fips = 6073 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6073 · 342

county

Link rowid date ▲ county state fips cases deaths
933721 2021-01-16 San Diego California 6073 209960 2065
930476 2021-01-15 San Diego California 6073 206933 2037
927231 2021-01-14 San Diego California 6073 204238 2005
923985 2021-01-13 San Diego California 6073 201643 1952
920740 2021-01-12 San Diego California 6073 198382 1898
917495 2021-01-11 San Diego California 6073 194858 1857
914250 2021-01-10 San Diego California 6073 191951 1857
911005 2021-01-09 San Diego California 6073 188663 1824
907760 2021-01-08 San Diego California 6073 185125 1771
904514 2021-01-07 San Diego California 6073 180575 1738
901269 2021-01-06 San Diego California 6073 176725 1691
898024 2021-01-05 San Diego California 6073 172910 1654
894779 2021-01-04 San Diego California 6073 171096 1598
891532 2021-01-03 San Diego California 6073 168083 1592
888285 2021-01-02 San Diego California 6073 164563 1592
885040 2021-01-01 San Diego California 6073 155658 1534
881795 2020-12-31 San Diego California 6073 155658 1534
878550 2020-12-30 San Diego California 6073 152575 1472
875305 2020-12-29 San Diego California 6073 150127 1435
872060 2020-12-28 San Diego California 6073 147593 1404
868815 2020-12-27 San Diego California 6073 145842 1402
865570 2020-12-26 San Diego California 6073 142710 1402
862325 2020-12-25 San Diego California 6073 137018 1382
859080 2020-12-24 San Diego California 6073 137018 1382
855835 2020-12-23 San Diego California 6073 134759 1350
852590 2020-12-22 San Diego California 6073 132161 1311
849345 2020-12-21 San Diego California 6073 129780 1283
846100 2020-12-20 San Diego California 6073 126528 1280
842854 2020-12-19 San Diego California 6073 123035 1280
839609 2020-12-18 San Diego California 6073 120526 1253
836364 2020-12-17 San Diego California 6073 116915 1239
833118 2020-12-16 San Diego California 6073 114311 1217
829871 2020-12-15 San Diego California 6073 111504 1194
826625 2020-12-14 San Diego California 6073 109641 1162
823378 2020-12-13 San Diego California 6073 107435 1162
820132 2020-12-12 San Diego California 6073 102531 1137
816886 2020-12-11 San Diego California 6073 102529 1137
813640 2020-12-10 San Diego California 6073 99662 1114
810396 2020-12-09 San Diego California 6073 97612 1103
807151 2020-12-08 San Diego California 6073 95508 1062
803906 2020-12-07 San Diego California 6073 94232 1062
800660 2020-12-06 San Diego California 6073 92234 1062
797414 2020-12-05 San Diego California 6073 90531 1055
794169 2020-12-04 San Diego California 6073 88244 1047
790923 2020-12-03 San Diego California 6073 86205 1040
787677 2020-12-02 San Diego California 6073 84701 1035
784433 2020-12-01 San Diego California 6073 83484 1019
781188 2020-11-30 San Diego California 6073 82106 997
777942 2020-11-29 San Diego California 6073 80083 997
774696 2020-11-28 San Diego California 6073 80081 997
771451 2020-11-27 San Diego California 6073 78222 996
768205 2020-11-26 San Diego California 6073 75370 988
764958 2020-11-25 San Diego California 6073 75368 988
761712 2020-11-24 San Diego California 6073 74424 984
758466 2020-11-23 San Diego California 6073 72878 968
755219 2020-11-22 San Diego California 6073 71711 968
751972 2020-11-21 San Diego California 6073 70772 966
748725 2020-11-20 San Diego California 6073 69294 960
745478 2020-11-19 San Diego California 6073 68203 952
742231 2020-11-18 San Diego California 6073 67304 945
738984 2020-11-17 San Diego California 6073 66382 933
735739 2020-11-16 San Diego California 6073 65664 926
732493 2020-11-15 San Diego California 6073 64831 926
729248 2020-11-14 San Diego California 6073 63744 926
726004 2020-11-13 San Diego California 6073 63008 921
722760 2020-11-12 San Diego California 6073 62397 918
719516 2020-11-11 San Diego California 6073 61148 915
716272 2020-11-10 San Diego California 6073 61116 915
713028 2020-11-09 San Diego California 6073 60633 938
709784 2020-11-08 San Diego California 6073 60232 908
706540 2020-11-07 San Diego California 6073 59719 908
703297 2020-11-06 San Diego California 6073 59179 907
700053 2020-11-05 San Diego California 6073 58699 904
696808 2020-11-04 San Diego California 6073 58169 904
693565 2020-11-03 San Diego California 6073 57765 901
690322 2020-11-02 San Diego California 6073 57472 891
687077 2020-11-01 San Diego California 6073 57165 891
683832 2020-10-31 San Diego California 6073 56813 891
680588 2020-10-30 San Diego California 6073 56432 888
677345 2020-10-29 San Diego California 6073 55961 885
674101 2020-10-28 San Diego California 6073 55603 881
670859 2020-10-27 San Diego California 6073 55273 877
667616 2020-10-26 San Diego California 6073 55004 870
664370 2020-10-25 San Diego California 6073 54646 870
661125 2020-10-24 San Diego California 6073 54377 868
657881 2020-10-23 San Diego California 6073 53991 867
654636 2020-10-22 San Diego California 6073 53561 866
651391 2020-10-21 San Diego California 6073 53326 863
648147 2020-10-20 San Diego California 6073 53063 857
644902 2020-10-19 San Diego California 6073 52798 853
641654 2020-10-18 San Diego California 6073 52418 853
638407 2020-10-17 San Diego California 6073 52045 850
635162 2020-10-16 San Diego California 6073 51844 847
631916 2020-10-15 San Diego California 6073 51533 847
628672 2020-10-14 San Diego California 6073 51390 844
625429 2020-10-13 San Diego California 6073 51087 840
622186 2020-10-12 San Diego California 6073 50809 826
618943 2020-10-11 San Diego California 6073 50614 826
615701 2020-10-10 San Diego California 6073 50206 825
612460 2020-10-09 San Diego California 6073 49886 821

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