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

404 rows where fips = 6059 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6059 · 404

county

Link rowid date ▲ county state fips cases deaths
1082931 2021-03-03 Orange California 6059 261798 3966
1079685 2021-03-02 Orange California 6059 261608 3952
1076440 2021-03-01 Orange California 6059 261408 3921
1073194 2021-02-28 Orange California 6059 261220 3917
1069948 2021-02-27 Orange California 6059 261022 3904
1066703 2021-02-26 Orange California 6059 260721 3892
1063458 2021-02-25 Orange California 6059 260348 3889
1060213 2021-02-24 Orange California 6059 260157 3848
1056967 2021-02-23 Orange California 6059 259857 3848
1053721 2021-02-22 Orange California 6059 259581 3848
1050474 2021-02-21 Orange California 6059 259305 3810
1047227 2021-02-20 Orange California 6059 258991 3770
1043982 2021-02-19 Orange California 6059 258567 3726
1040737 2021-02-18 Orange California 6059 258182 3685
1037492 2021-02-17 Orange California 6059 257816 3644
1034247 2021-02-16 Orange California 6059 257589 3617
1031001 2021-02-15 Orange California 6059 256889 3577
1027754 2021-02-14 Orange California 6059 256889 3577
1024509 2021-02-13 Orange California 6059 256510 3544
1021264 2021-02-12 Orange California 6059 255254 3493
1018019 2021-02-11 Orange California 6059 255254 3493
1014774 2021-02-10 Orange California 6059 254417 3451
1011529 2021-02-09 Orange California 6059 253900 3416
1008283 2021-02-08 Orange California 6059 253289 3383
1005037 2021-02-07 Orange California 6059 252311 3358
1001791 2021-02-06 Orange California 6059 251079 3312
998545 2021-02-05 Orange California 6059 250300 3279
995299 2021-02-04 Orange California 6059 249195 3249
992053 2021-02-03 Orange California 6059 248510 3199
988807 2021-02-02 Orange California 6059 247886 3162
985560 2021-02-01 Orange California 6059 247035 3109
982313 2021-01-31 Orange California 6059 245978 3062
979067 2021-01-30 Orange California 6059 244562 3018
975822 2021-01-29 Orange California 6059 243212 2975
972577 2021-01-28 Orange California 6059 241648 2868
969332 2021-01-27 Orange California 6059 240314 2839
966088 2021-01-26 Orange California 6059 239175 2768
962843 2021-01-25 Orange California 6059 237708 2704
959598 2021-01-24 Orange California 6059 236312 2638
956352 2021-01-23 Orange California 6059 234427 2625
953107 2021-01-22 Orange California 6059 231574 2547
949862 2021-01-21 Orange California 6059 230582 2546
946616 2021-01-20 Orange California 6059 229132 2508
943369 2021-01-19 Orange California 6059 227321 2477
940124 2021-01-18 Orange California 6059 223088 2367
936879 2021-01-17 Orange California 6059 223088 2367
933634 2021-01-16 Orange California 6059 221532 2320
930389 2021-01-15 Orange California 6059 217925 2277
927144 2021-01-14 Orange California 6059 214649 2195
923898 2021-01-13 Orange California 6059 211331 2179
920653 2021-01-12 Orange California 6059 207318 2148
917408 2021-01-11 Orange California 6059 202787 2120
914163 2021-01-10 Orange California 6059 199401 2091
910918 2021-01-09 Orange California 6059 196024 2041
907673 2021-01-08 Orange California 6059 191804 1998
904427 2021-01-07 Orange California 6059 188013 1972
901182 2021-01-06 Orange California 6059 185125 1943
897937 2021-01-05 Orange California 6059 181850 1926
894692 2021-01-04 Orange California 6059 180386 1926
891445 2021-01-03 Orange California 6059 170802 1901
888198 2021-01-02 Orange California 6059 170802 1901
884953 2021-01-01 Orange California 6059 166196 1875
881708 2020-12-31 Orange California 6059 166196 1875
878463 2020-12-30 Orange California 6059 164990 1874
875218 2020-12-29 Orange California 6059 160476 1847
871973 2020-12-28 Orange California 6059 157926 1846
868728 2020-12-27 Orange California 6059 153527 1846
865483 2020-12-26 Orange California 6059 149439 1845
862238 2020-12-25 Orange California 6059 141205 1782
858993 2020-12-24 Orange California 6059 140699 1782
855748 2020-12-23 Orange California 6059 137194 1781
852503 2020-12-22 Orange California 6059 132772 1779
849258 2020-12-21 Orange California 6059 130530 1777
846013 2020-12-20 Orange California 6059 126776 1775
842767 2020-12-19 Orange California 6059 122168 1760
839522 2020-12-18 Orange California 6059 118721 1734
836277 2020-12-17 Orange California 6059 116116 1731
833031 2020-12-16 Orange California 6059 113492 1718
829784 2020-12-15 Orange California 6059 110253 1695
826538 2020-12-14 Orange California 6059 108070 1694
823291 2020-12-13 Orange California 6059 104817 1694
820045 2020-12-12 Orange California 6059 101696 1680
816799 2020-12-11 Orange California 6059 99603 1662
813553 2020-12-10 Orange California 6059 96948 1640
810309 2020-12-09 Orange California 6059 95425 1633
807064 2020-12-08 Orange California 6059 92811 1633
803819 2020-12-07 Orange California 6059 91139 1633
800574 2020-12-06 Orange California 6059 89175 1633
797329 2020-12-05 Orange California 6059 87150 1618
794084 2020-12-04 Orange California 6059 85181 1603
790839 2020-12-03 Orange California 6059 83947 1586
787594 2020-12-02 Orange California 6059 82840 1578
784350 2020-12-01 Orange California 6059 81631 1577
781105 2020-11-30 Orange California 6059 80841 1577
777859 2020-11-29 Orange California 6059 80107 1577
774614 2020-11-28 Orange California 6059 79049 1577
771369 2020-11-27 Orange California 6059 77380 1577
768124 2020-11-26 Orange California 6059 75424 1559
764878 2020-11-25 Orange California 6059 75424 1559
761633 2020-11-24 Orange California 6059 74218 1556

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