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

371 rows where fips = 6001 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6001 · 371

county

Link rowid date ▲ county state fips cases deaths
1092639 2021-03-06 Alameda California 6001 81276 1289
1089393 2021-03-05 Alameda California 6001 81189 1285
1086148 2021-03-04 Alameda California 6001 81107 1281
1082902 2021-03-03 Alameda California 6001 80971 1271
1079656 2021-03-02 Alameda California 6001 80894 1244
1076411 2021-03-01 Alameda California 6001 80798 1242
1073165 2021-02-28 Alameda California 6001 80689 1242
1069919 2021-02-27 Alameda California 6001 80517 1241
1066674 2021-02-26 Alameda California 6001 80300 1241
1063429 2021-02-25 Alameda California 6001 80109 1224
1060184 2021-02-24 Alameda California 6001 79969 1218
1056938 2021-02-23 Alameda California 6001 79817 1200
1053692 2021-02-22 Alameda California 6001 79670 1200
1050445 2021-02-21 Alameda California 6001 79560 1200
1047198 2021-02-20 Alameda California 6001 79492 1175
1043953 2021-02-19 Alameda California 6001 79318 1171
1040708 2021-02-18 Alameda California 6001 79113 1126
1037463 2021-02-17 Alameda California 6001 79037 1125
1034218 2021-02-16 Alameda California 6001 78904 1122
1030972 2021-02-15 Alameda California 6001 78735 1121
1027725 2021-02-14 Alameda California 6001 78377 1120
1024480 2021-02-13 Alameda California 6001 78306 1120
1021235 2021-02-12 Alameda California 6001 77947 1088
1017990 2021-02-11 Alameda California 6001 77653 1064
1014745 2021-02-10 Alameda California 6001 77237 1063
1011500 2021-02-09 Alameda California 6001 77130 1051
1008254 2021-02-08 Alameda California 6001 76669 1041
1005008 2021-02-07 Alameda California 6001 76191 1041
1001762 2021-02-06 Alameda California 6001 75758 1037
998516 2021-02-05 Alameda California 6001 75443 1030
995270 2021-02-04 Alameda California 6001 75196 1021
992024 2021-02-03 Alameda California 6001 74980 999
988778 2021-02-02 Alameda California 6001 74682 991
985531 2021-02-01 Alameda California 6001 74108 982
982284 2021-01-31 Alameda California 6001 73792 980
979038 2021-01-30 Alameda California 6001 73563 974
975793 2021-01-29 Alameda California 6001 73136 959
972548 2021-01-28 Alameda California 6001 72618 937
969303 2021-01-27 Alameda California 6001 72045 929
966059 2021-01-26 Alameda California 6001 71319 906
962814 2021-01-25 Alameda California 6001 70844 896
959569 2021-01-24 Alameda California 6001 70355 894
956323 2021-01-23 Alameda California 6001 69714 886
953078 2021-01-22 Alameda California 6001 69575 856
949833 2021-01-21 Alameda California 6001 69128 842
946587 2021-01-20 Alameda California 6001 68670 788
943340 2021-01-19 Alameda California 6001 67973 765
940095 2021-01-18 Alameda California 6001 67396 764
936850 2021-01-17 Alameda California 6001 66604 757
933605 2021-01-16 Alameda California 6001 65700 757
930360 2021-01-15 Alameda California 6001 64781 768
927115 2021-01-14 Alameda California 6001 63887 776
923869 2021-01-13 Alameda California 6001 62964 776
920624 2021-01-12 Alameda California 6001 62067 763
917379 2021-01-11 Alameda California 6001 61132 736
914134 2021-01-10 Alameda California 6001 60146 732
910889 2021-01-09 Alameda California 6001 59193 732
907644 2021-01-08 Alameda California 6001 57942 729
904398 2021-01-07 Alameda California 6001 57102 713
901153 2021-01-06 Alameda California 6001 56453 697
897908 2021-01-05 Alameda California 6001 55920 681
894663 2021-01-04 Alameda California 6001 55094 656
891416 2021-01-03 Alameda California 6001 54539 656
888169 2021-01-02 Alameda California 6001 53539 656
884924 2021-01-01 Alameda California 6001 52496 657
881679 2020-12-31 Alameda California 6001 51611 657
878434 2020-12-30 Alameda California 6001 50967 625
875189 2020-12-29 Alameda California 6001 50426 625
871944 2020-12-28 Alameda California 6001 49817 625
868699 2020-12-27 Alameda California 6001 49105 625
865454 2020-12-26 Alameda California 6001 48386 625
862209 2020-12-25 Alameda California 6001 47548 619
858964 2020-12-24 Alameda California 6001 46774 619
855719 2020-12-23 Alameda California 6001 45772 616
852474 2020-12-22 Alameda California 6001 44777 609
849229 2020-12-21 Alameda California 6001 44025 588
845984 2020-12-20 Alameda California 6001 43130 587
842738 2020-12-19 Alameda California 6001 42217 585
839493 2020-12-18 Alameda California 6001 41569 574
836248 2020-12-17 Alameda California 6001 40772 563
833002 2020-12-16 Alameda California 6001 40047 563
829755 2020-12-15 Alameda California 6001 39273 558
826509 2020-12-14 Alameda California 6001 38239 546
823262 2020-12-13 Alameda California 6001 37048 542
820016 2020-12-12 Alameda California 6001 36302 542
816770 2020-12-11 Alameda California 6001 35707 538
813524 2020-12-10 Alameda California 6001 35068 533
810280 2020-12-09 Alameda California 6001 34394 526
807035 2020-12-08 Alameda California 6001 33908 525
803790 2020-12-07 Alameda California 6001 33498 522
800545 2020-12-06 Alameda California 6001 32802 522
797300 2020-12-05 Alameda California 6001 31892 522
794055 2020-12-04 Alameda California 6001 31225 522
790810 2020-12-03 Alameda California 6001 31001 522
787565 2020-12-02 Alameda California 6001 30351 520
784321 2020-12-01 Alameda California 6001 29993 514
781076 2020-11-30 Alameda California 6001 29939 512
777830 2020-11-29 Alameda California 6001 29497 512
774585 2020-11-28 Alameda California 6001 29137 511
771340 2020-11-27 Alameda California 6001 28878 505

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