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

358 rows where fips = 6059 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6059 · 358

county

Link rowid date ▲ county state fips cases deaths
933714 2021-01-16 Orange California 6059 221532 2320
930469 2021-01-15 Orange California 6059 217925 2277
927224 2021-01-14 Orange California 6059 214649 2195
923978 2021-01-13 Orange California 6059 211331 2179
920733 2021-01-12 Orange California 6059 207318 2148
917488 2021-01-11 Orange California 6059 202787 2120
914243 2021-01-10 Orange California 6059 199401 2091
910998 2021-01-09 Orange California 6059 196024 2041
907753 2021-01-08 Orange California 6059 191804 1998
904507 2021-01-07 Orange California 6059 188013 1972
901262 2021-01-06 Orange California 6059 185125 1943
898017 2021-01-05 Orange California 6059 181850 1926
894772 2021-01-04 Orange California 6059 180386 1926
891525 2021-01-03 Orange California 6059 170802 1901
888278 2021-01-02 Orange California 6059 170802 1901
885033 2021-01-01 Orange California 6059 166196 1875
881788 2020-12-31 Orange California 6059 166196 1875
878543 2020-12-30 Orange California 6059 164990 1874
875298 2020-12-29 Orange California 6059 160476 1847
872053 2020-12-28 Orange California 6059 157926 1846
868808 2020-12-27 Orange California 6059 153527 1846
865563 2020-12-26 Orange California 6059 149439 1845
862318 2020-12-25 Orange California 6059 141205 1782
859073 2020-12-24 Orange California 6059 140699 1782
855828 2020-12-23 Orange California 6059 137194 1781
852583 2020-12-22 Orange California 6059 132772 1779
849338 2020-12-21 Orange California 6059 130530 1777
846093 2020-12-20 Orange California 6059 126776 1775
842847 2020-12-19 Orange California 6059 122168 1760
839602 2020-12-18 Orange California 6059 118721 1734
836357 2020-12-17 Orange California 6059 116116 1731
833111 2020-12-16 Orange California 6059 113492 1718
829864 2020-12-15 Orange California 6059 110253 1695
826618 2020-12-14 Orange California 6059 108070 1694
823371 2020-12-13 Orange California 6059 104817 1694
820125 2020-12-12 Orange California 6059 101696 1680
816879 2020-12-11 Orange California 6059 99603 1662
813633 2020-12-10 Orange California 6059 96948 1640
810389 2020-12-09 Orange California 6059 95425 1633
807144 2020-12-08 Orange California 6059 92811 1633
803899 2020-12-07 Orange California 6059 91139 1633
800653 2020-12-06 Orange California 6059 89175 1633
797407 2020-12-05 Orange California 6059 87150 1618
794162 2020-12-04 Orange California 6059 85181 1603
790916 2020-12-03 Orange California 6059 83947 1586
787670 2020-12-02 Orange California 6059 82840 1578
784426 2020-12-01 Orange California 6059 81631 1577
781181 2020-11-30 Orange California 6059 80841 1577
777935 2020-11-29 Orange California 6059 80107 1577
774689 2020-11-28 Orange California 6059 79049 1577
771444 2020-11-27 Orange California 6059 77380 1577
768198 2020-11-26 Orange California 6059 75424 1559
764951 2020-11-25 Orange California 6059 75424 1559
761705 2020-11-24 Orange California 6059 74218 1556
758459 2020-11-23 Orange California 6059 73378 1554
755212 2020-11-22 Orange California 6059 71955 1554
751965 2020-11-21 Orange California 6059 71402 1551
748718 2020-11-20 Orange California 6059 70593 1540
745471 2020-11-19 Orange California 6059 69413 1537
742224 2020-11-18 Orange California 6059 68816 1528
738977 2020-11-17 Orange California 6059 68175 1526
735732 2020-11-16 Orange California 6059 67819 1526
732486 2020-11-15 Orange California 6059 67439 1526
729241 2020-11-14 Orange California 6059 66778 1524
725997 2020-11-13 Orange California 6059 66183 1522
722753 2020-11-12 Orange California 6059 65554 1520
719509 2020-11-11 Orange California 6059 65234 1514
716265 2020-11-10 Orange California 6059 64891 1512
713021 2020-11-09 Orange California 6059 64621 1509
709777 2020-11-08 Orange California 6059 64311 1509
706533 2020-11-07 Orange California 6059 63798 1506
703290 2020-11-06 Orange California 6059 63469 1503
700046 2020-11-05 Orange California 6059 63125 1494
696801 2020-11-04 Orange California 6059 62838 1491
693558 2020-11-03 Orange California 6059 62589 1484
690315 2020-11-02 Orange California 6059 62264 1484
687070 2020-11-01 Orange California 6059 62080 1484
683825 2020-10-31 Orange California 6059 61836 1483
680581 2020-10-30 Orange California 6059 61671 1475
677338 2020-10-29 Orange California 6059 61358 1468
674094 2020-10-28 Orange California 6059 61097 1467
670852 2020-10-27 Orange California 6059 60836 1454
667609 2020-10-26 Orange California 6059 60583 1447
664363 2020-10-25 Orange California 6059 60431 1447
661118 2020-10-24 Orange California 6059 60184 1444
657874 2020-10-23 Orange California 6059 59868 1440
654629 2020-10-22 Orange California 6059 59697 1434
651384 2020-10-21 Orange California 6059 59448 1423
648140 2020-10-20 Orange California 6059 59168 1412
644895 2020-10-19 Orange California 6059 58851 1410
641647 2020-10-18 Orange California 6059 58648 1409
638400 2020-10-17 Orange California 6059 58447 1409
635155 2020-10-16 Orange California 6059 58354 1401
631909 2020-10-15 Orange California 6059 58183 1391
628665 2020-10-14 Orange California 6059 58021 1360
625422 2020-10-13 Orange California 6059 57773 1341
622179 2020-10-12 Orange California 6059 57595 1341
618936 2020-10-11 Orange California 6059 57479 1341
615694 2020-10-10 Orange California 6059 57225 1340
612453 2020-10-09 Orange California 6059 57001 1316

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