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

391 rows where fips = 6073 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6073 · 391

county

Link rowid date ▲ county state fips cases deaths
1092675 2021-03-06 San Diego California 6073 262844 3385
1089429 2021-03-05 San Diego California 6073 262423 3371
1086184 2021-03-04 San Diego California 6073 261924 3359
1082938 2021-03-03 San Diego California 6073 261416 3342
1079692 2021-03-02 San Diego California 6073 261064 3317
1076447 2021-03-01 San Diego California 6073 260688 3303
1073201 2021-02-28 San Diego California 6073 260419 3303
1069955 2021-02-27 San Diego California 6073 260157 3284
1066710 2021-02-26 San Diego California 6073 259707 3271
1063465 2021-02-25 San Diego California 6073 259045 3260
1060220 2021-02-24 San Diego California 6073 258526 3230
1056974 2021-02-23 San Diego California 6073 257868 3218
1053728 2021-02-22 San Diego California 6073 257414 3190
1050481 2021-02-21 San Diego California 6073 257093 3190
1047234 2021-02-20 San Diego California 6073 256576 3188
1043989 2021-02-19 San Diego California 6073 255865 3169
1040744 2021-02-18 San Diego California 6073 255053 3135
1037499 2021-02-17 San Diego California 6073 254243 3099
1034254 2021-02-16 San Diego California 6073 253704 3042
1031008 2021-02-15 San Diego California 6073 252313 3037
1027761 2021-02-14 San Diego California 6073 252313 3037
1024516 2021-02-13 San Diego California 6073 251745 3009
1021271 2021-02-12 San Diego California 6073 250854 2979
1018026 2021-02-11 San Diego California 6073 250037 2955
1014781 2021-02-10 San Diego California 6073 248924 2904
1011536 2021-02-09 San Diego California 6073 248114 2853
1008290 2021-02-08 San Diego California 6073 247525 2821
1005044 2021-02-07 San Diego California 6073 246627 2821
1001798 2021-02-06 San Diego California 6073 245397 2812
998552 2021-02-05 San Diego California 6073 244132 2777
995306 2021-02-04 San Diego California 6073 242679 2738
992060 2021-02-03 San Diego California 6073 241081 2683
988814 2021-02-02 San Diego California 6073 240113 2629
985567 2021-02-01 San Diego California 6073 239205 2619
982320 2021-01-31 San Diego California 6073 238105 2619
979074 2021-01-30 San Diego California 6073 236831 2603
975829 2021-01-29 San Diego California 6073 234703 2571
972584 2021-01-28 San Diego California 6073 233033 2534
969339 2021-01-27 San Diego California 6073 231544 2465
966095 2021-01-26 San Diego California 6073 230129 2421
962850 2021-01-25 San Diego California 6073 228695 2375
959605 2021-01-24 San Diego California 6073 227258 2375
956359 2021-01-23 San Diego California 6073 225621 2344
953114 2021-01-22 San Diego California 6073 222641 2301
949869 2021-01-21 San Diego California 6073 219794 2222
946623 2021-01-20 San Diego California 6073 218618 2174
943376 2021-01-19 San Diego California 6073 216898 2109
940131 2021-01-18 San Diego California 6073 211850 2103
936886 2021-01-17 San Diego California 6073 211850 2103
933641 2021-01-16 San Diego California 6073 209960 2065
930396 2021-01-15 San Diego California 6073 206933 2037
927151 2021-01-14 San Diego California 6073 204238 2005
923905 2021-01-13 San Diego California 6073 201643 1952
920660 2021-01-12 San Diego California 6073 198382 1898
917415 2021-01-11 San Diego California 6073 194858 1857
914170 2021-01-10 San Diego California 6073 191951 1857
910925 2021-01-09 San Diego California 6073 188663 1824
907680 2021-01-08 San Diego California 6073 185125 1771
904434 2021-01-07 San Diego California 6073 180575 1738
901189 2021-01-06 San Diego California 6073 176725 1691
897944 2021-01-05 San Diego California 6073 172910 1654
894699 2021-01-04 San Diego California 6073 171096 1598
891452 2021-01-03 San Diego California 6073 168083 1592
888205 2021-01-02 San Diego California 6073 164563 1592
884960 2021-01-01 San Diego California 6073 155658 1534
881715 2020-12-31 San Diego California 6073 155658 1534
878470 2020-12-30 San Diego California 6073 152575 1472
875225 2020-12-29 San Diego California 6073 150127 1435
871980 2020-12-28 San Diego California 6073 147593 1404
868735 2020-12-27 San Diego California 6073 145842 1402
865490 2020-12-26 San Diego California 6073 142710 1402
862245 2020-12-25 San Diego California 6073 137018 1382
859000 2020-12-24 San Diego California 6073 137018 1382
855755 2020-12-23 San Diego California 6073 134759 1350
852510 2020-12-22 San Diego California 6073 132161 1311
849265 2020-12-21 San Diego California 6073 129780 1283
846020 2020-12-20 San Diego California 6073 126528 1280
842774 2020-12-19 San Diego California 6073 123035 1280
839529 2020-12-18 San Diego California 6073 120526 1253
836284 2020-12-17 San Diego California 6073 116915 1239
833038 2020-12-16 San Diego California 6073 114311 1217
829791 2020-12-15 San Diego California 6073 111504 1194
826545 2020-12-14 San Diego California 6073 109641 1162
823298 2020-12-13 San Diego California 6073 107435 1162
820052 2020-12-12 San Diego California 6073 102531 1137
816806 2020-12-11 San Diego California 6073 102529 1137
813560 2020-12-10 San Diego California 6073 99662 1114
810316 2020-12-09 San Diego California 6073 97612 1103
807071 2020-12-08 San Diego California 6073 95508 1062
803826 2020-12-07 San Diego California 6073 94232 1062
800581 2020-12-06 San Diego California 6073 92234 1062
797336 2020-12-05 San Diego California 6073 90531 1055
794091 2020-12-04 San Diego California 6073 88244 1047
790846 2020-12-03 San Diego California 6073 86205 1040
787601 2020-12-02 San Diego California 6073 84701 1035
784357 2020-12-01 San Diego California 6073 83484 1019
781112 2020-11-30 San Diego California 6073 82106 997
777866 2020-11-29 San Diego California 6073 80083 997
774621 2020-11-28 San Diego California 6073 80081 997
771376 2020-11-27 San Diego California 6073 78222 996

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