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

330 rows where fips = 6001 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6001 · 330

county

Link rowid date ▲ county state fips cases deaths
959649 2021-01-24 Alameda California 6001 70355 894
956403 2021-01-23 Alameda California 6001 69714 886
953158 2021-01-22 Alameda California 6001 69575 856
949913 2021-01-21 Alameda California 6001 69128 842
946667 2021-01-20 Alameda California 6001 68670 788
943420 2021-01-19 Alameda California 6001 67973 765
940175 2021-01-18 Alameda California 6001 67396 764
936930 2021-01-17 Alameda California 6001 66604 757
933685 2021-01-16 Alameda California 6001 65700 757
930440 2021-01-15 Alameda California 6001 64781 768
927195 2021-01-14 Alameda California 6001 63887 776
923949 2021-01-13 Alameda California 6001 62964 776
920704 2021-01-12 Alameda California 6001 62067 763
917459 2021-01-11 Alameda California 6001 61132 736
914214 2021-01-10 Alameda California 6001 60146 732
910969 2021-01-09 Alameda California 6001 59193 732
907724 2021-01-08 Alameda California 6001 57942 729
904478 2021-01-07 Alameda California 6001 57102 713
901233 2021-01-06 Alameda California 6001 56453 697
897988 2021-01-05 Alameda California 6001 55920 681
894743 2021-01-04 Alameda California 6001 55094 656
891496 2021-01-03 Alameda California 6001 54539 656
888249 2021-01-02 Alameda California 6001 53539 656
885004 2021-01-01 Alameda California 6001 52496 657
881759 2020-12-31 Alameda California 6001 51611 657
878514 2020-12-30 Alameda California 6001 50967 625
875269 2020-12-29 Alameda California 6001 50426 625
872024 2020-12-28 Alameda California 6001 49817 625
868779 2020-12-27 Alameda California 6001 49105 625
865534 2020-12-26 Alameda California 6001 48386 625
862289 2020-12-25 Alameda California 6001 47548 619
859044 2020-12-24 Alameda California 6001 46774 619
855799 2020-12-23 Alameda California 6001 45772 616
852554 2020-12-22 Alameda California 6001 44777 609
849309 2020-12-21 Alameda California 6001 44025 588
846064 2020-12-20 Alameda California 6001 43130 587
842818 2020-12-19 Alameda California 6001 42217 585
839573 2020-12-18 Alameda California 6001 41569 574
836328 2020-12-17 Alameda California 6001 40772 563
833082 2020-12-16 Alameda California 6001 40047 563
829835 2020-12-15 Alameda California 6001 39273 558
826589 2020-12-14 Alameda California 6001 38239 546
823342 2020-12-13 Alameda California 6001 37048 542
820096 2020-12-12 Alameda California 6001 36302 542
816850 2020-12-11 Alameda California 6001 35707 538
813604 2020-12-10 Alameda California 6001 35068 533
810360 2020-12-09 Alameda California 6001 34394 526
807115 2020-12-08 Alameda California 6001 33908 525
803870 2020-12-07 Alameda California 6001 33498 522
800624 2020-12-06 Alameda California 6001 32802 522
797378 2020-12-05 Alameda California 6001 31892 522
794133 2020-12-04 Alameda California 6001 31225 522
790887 2020-12-03 Alameda California 6001 31001 522
787641 2020-12-02 Alameda California 6001 30351 520
784397 2020-12-01 Alameda California 6001 29993 514
781152 2020-11-30 Alameda California 6001 29939 512
777906 2020-11-29 Alameda California 6001 29497 512
774660 2020-11-28 Alameda California 6001 29137 511
771415 2020-11-27 Alameda California 6001 28878 505
768169 2020-11-26 Alameda California 6001 28399 502
764922 2020-11-25 Alameda California 6001 28246 502
761676 2020-11-24 Alameda California 6001 27878 499
758430 2020-11-23 Alameda California 6001 27643 499
755183 2020-11-22 Alameda California 6001 27506 499
751936 2020-11-21 Alameda California 6001 27456 499
748689 2020-11-20 Alameda California 6001 27244 499
745442 2020-11-19 Alameda California 6001 26948 495
742195 2020-11-18 Alameda California 6001 26676 494
738948 2020-11-17 Alameda California 6001 26481 493
735703 2020-11-16 Alameda California 6001 26068 490
732457 2020-11-15 Alameda California 6001 25893 490
729212 2020-11-14 Alameda California 6001 25781 489
725968 2020-11-13 Alameda California 6001 25620 486
722724 2020-11-12 Alameda California 6001 25421 486
719480 2020-11-11 Alameda California 6001 25270 483
716236 2020-11-10 Alameda California 6001 25131 475
712992 2020-11-09 Alameda California 6001 25022 475
709748 2020-11-08 Alameda California 6001 24872 475
706504 2020-11-07 Alameda California 6001 24685 475
703261 2020-11-06 Alameda California 6001 24439 471
700017 2020-11-05 Alameda California 6001 24391 465
696772 2020-11-04 Alameda California 6001 24254 466
693529 2020-11-03 Alameda California 6001 24183 466
690286 2020-11-02 Alameda California 6001 24116 464
687041 2020-11-01 Alameda California 6001 24015 464
683796 2020-10-31 Alameda California 6001 23897 464
680552 2020-10-30 Alameda California 6001 23796 463
677309 2020-10-29 Alameda California 6001 23657 463
674065 2020-10-28 Alameda California 6001 23597 462
670823 2020-10-27 Alameda California 6001 23492 462
667580 2020-10-26 Alameda California 6001 23412 461
664334 2020-10-25 Alameda California 6001 23333 461
661089 2020-10-24 Alameda California 6001 23236 460
657845 2020-10-23 Alameda California 6001 23154 456
654600 2020-10-22 Alameda California 6001 23022 456
651355 2020-10-21 Alameda California 6001 22953 435
648111 2020-10-20 Alameda California 6001 22828 433
644866 2020-10-19 Alameda California 6001 22759 433
641618 2020-10-18 Alameda California 6001 22657 442
638371 2020-10-17 Alameda California 6001 22480 442

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