ny_times_us_counties

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

18,077 rows where state = "California" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

state

  • California · 18,077 ✖
Link rowid date ▲ county state fips cases deaths
953158 953158 2021-01-22 Alameda California 6001 69575 856
953159 953159 2021-01-22 Alpine California 6003 71 0
953160 953160 2021-01-22 Amador California 6005 3037 31
953161 953161 2021-01-22 Butte California 6007 9643 130
953162 953162 2021-01-22 Calaveras California 6009 1647 23
953163 953163 2021-01-22 Colusa California 6011 1854 9
953164 953164 2021-01-22 Contra Costa California 6013 54140 483
953165 953165 2021-01-22 Del Norte California 6015 870 2
953166 953166 2021-01-22 El Dorado California 6017 7823 53
953167 953167 2021-01-22 Fresno California 6019 84137 1020
953168 953168 2021-01-22 Glenn California 6021 1964 20
953169 953169 2021-01-22 Humboldt California 6023 2494 25
953170 953170 2021-01-22 Imperial California 6025 25509 492
953171 953171 2021-01-22 Inyo California 6027 946 29
953172 953172 2021-01-22 Kern California 6029 88399 587
953173 953173 2021-01-22 Kings California 6031 19703 160
953174 953174 2021-01-22 Lake California 6033 2669 31
953175 953175 2021-01-22 Lassen California 6035 5269 16
953176 953176 2021-01-22 Los Angeles California 6037 1055214 14894
953177 953177 2021-01-22 Madera California 6039 13664 151
953178 953178 2021-01-22 Marin California 6041 11899 163
953179 953179 2021-01-22 Mariposa California 6043 346 4
953180 953180 2021-01-22 Mendocino California 6045 3234 33
953181 953181 2021-01-22 Merced California 6047 25048 324
953182 953182 2021-01-22 Modoc California 6049 284 3
953183 953183 2021-01-22 Mono California 6051 1104 4
953184 953184 2021-01-22 Monterey California 6053 36950 259
953185 953185 2021-01-22 Napa California 6055 7775 46
953186 953186 2021-01-22 Nevada California 6057 3292 74
953187 953187 2021-01-22 Orange California 6059 231574 2547
953188 953188 2021-01-22 Placer California 6061 17675 188
953189 953189 2021-01-22 Plumas California 6063 518 5
953190 953190 2021-01-22 Riverside California 6065 258352 2777
953191 953191 2021-01-22 Sacramento California 6067 82302 1157
953192 953192 2021-01-22 San Benito California 6069 5101 48
953193 953193 2021-01-22 San Bernardino California 6071 261199 1579
953194 953194 2021-01-22 San Diego California 6073 222641 2301
953195 953195 2021-01-22 San Francisco California 6075 29804 275
953196 953196 2021-01-22 San Joaquin California 6077 59395 808
953197 953197 2021-01-22 San Luis Obispo California 6079 16437 151
953198 953198 2021-01-22 San Mateo California 6081 33468 340
953199 953199 2021-01-22 Santa Barbara California 6083 25986 260
953200 953200 2021-01-22 Santa Clara California 6085 96340 1182
953201 953201 2021-01-22 Santa Cruz California 6087 12649 130
953202 953202 2021-01-22 Shasta California 6089 9920 129
953203 953203 2021-01-22 Sierra California 6091 40 0
953204 953204 2021-01-22 Siskiyou California 6093 1484 13
953205 953205 2021-01-22 Solano California 6095 26499 111
953206 953206 2021-01-22 Sonoma California 6097 24571 245
953207 953207 2021-01-22 Stanislaus California 6099 48100 782
953208 953208 2021-01-22 Sutter California 6101 7927 83
953209 953209 2021-01-22 Tehama California 6103 3938 44
953210 953210 2021-01-22 Trinity California 6105 262 4
953211 953211 2021-01-22 Tulare California 6107 42759 531
953212 953212 2021-01-22 Tuolumne California 6109 3443 40
953213 953213 2021-01-22 Ventura California 6111 63995 507
953214 953214 2021-01-22 Yolo California 6113 10940 138
953215 953215 2021-01-22 Yuba California 6115 5049 29
949913 949913 2021-01-21 Alameda California 6001 69128 842
949914 949914 2021-01-21 Alpine California 6003 71 0
949915 949915 2021-01-21 Amador California 6005 3035 31
949916 949916 2021-01-21 Butte California 6007 9582 128
949917 949917 2021-01-21 Calaveras California 6009 1637 23
949918 949918 2021-01-21 Colusa California 6011 1853 9
949919 949919 2021-01-21 Contra Costa California 6013 53844 477
949920 949920 2021-01-21 Del Norte California 6015 869 2
949921 949921 2021-01-21 El Dorado California 6017 7785 49
949922 949922 2021-01-21 Fresno California 6019 83591 968
949923 949923 2021-01-21 Glenn California 6021 1955 20
949924 949924 2021-01-21 Humboldt California 6023 2458 25
949925 949925 2021-01-21 Imperial California 6025 25380 485
949926 949926 2021-01-21 Inyo California 6027 901 29
949927 949927 2021-01-21 Kern California 6029 87714 583
949928 949928 2021-01-21 Kings California 6031 19703 160
949929 949929 2021-01-21 Lake California 6033 2646 31
949930 949930 2021-01-21 Lassen California 6035 5224 13
949931 949931 2021-01-21 Los Angeles California 6037 1046424 14641
949932 949932 2021-01-21 Madera California 6039 13585 151
949933 949933 2021-01-21 Marin California 6041 11808 159
949934 949934 2021-01-21 Mariposa California 6043 346 4
949935 949935 2021-01-21 Mendocino California 6045 3206 32
949936 949936 2021-01-21 Merced California 6047 24788 320
949937 949937 2021-01-21 Modoc California 6049 282 3
949938 949938 2021-01-21 Mono California 6051 1105 4
949939 949939 2021-01-21 Monterey California 6053 36668 259
949940 949940 2021-01-21 Napa California 6055 7732 45
949941 949941 2021-01-21 Nevada California 6057 3257 74
949942 949942 2021-01-21 Orange California 6059 230582 2546
949943 949943 2021-01-21 Placer California 6061 17584 186
949944 949944 2021-01-21 Plumas California 6063 512 5
949945 949945 2021-01-21 Riverside California 6065 255808 2739
949946 949946 2021-01-21 Sacramento California 6067 81686 1145
949947 949947 2021-01-21 San Benito California 6069 5042 46
949948 949948 2021-01-21 San Bernardino California 6071 258742 1561
949949 949949 2021-01-21 San Diego California 6073 219794 2222
949950 949950 2021-01-21 San Francisco California 6075 29668 274
949951 949951 2021-01-21 San Joaquin California 6077 59096 806
949952 949952 2021-01-21 San Luis Obispo California 6079 16228 151
949953 949953 2021-01-21 San Mateo California 6081 33207 309
949954 949954 2021-01-21 Santa Barbara California 6083 25751 249

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