ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2021-03-04 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1086148 | 1086148 | 2021-03-04 | Alameda | California | 6001 | 81107 | 1281 |
1086149 | 1086149 | 2021-03-04 | Alpine | California | 6003 | 77 | 0 |
1086150 | 1086150 | 2021-03-04 | Amador | California | 6005 | 3477 | 41 |
1086151 | 1086151 | 2021-03-04 | Butte | California | 6007 | 11014 | 167 |
1086152 | 1086152 | 2021-03-04 | Calaveras | California | 6009 | 1893 | 49 |
1086153 | 1086153 | 2021-03-04 | Colusa | California | 6011 | 2140 | 13 |
1086154 | 1086154 | 2021-03-04 | Contra Costa | California | 6013 | 63053 | 696 |
1086155 | 1086155 | 2021-03-04 | Del Norte | California | 6015 | 1016 | 5 |
1086156 | 1086156 | 2021-03-04 | El Dorado | California | 6017 | 9121 | 100 |
1086157 | 1086157 | 2021-03-04 | Fresno | California | 6019 | 95893 | 1458 |
1086158 | 1086158 | 2021-03-04 | Glenn | California | 6021 | 2711 | 23 |
1086159 | 1086159 | 2021-03-04 | Humboldt | California | 6023 | 3246 | 33 |
1086160 | 1086160 | 2021-03-04 | Imperial | California | 6025 | 26939 | 635 |
1086161 | 1086161 | 2021-03-04 | Inyo | California | 6027 | 1294 | 37 |
1086162 | 1086162 | 2021-03-04 | Kern | California | 6029 | 103894 | 924 |
1086163 | 1086163 | 2021-03-04 | Kings | California | 6031 | 22119 | 227 |
1086164 | 1086164 | 2021-03-04 | Lake | California | 6033 | 3175 | 41 |
1086165 | 1086165 | 2021-03-04 | Lassen | California | 6035 | 5623 | 19 |
1086166 | 1086166 | 2021-03-04 | Los Angeles | California | 6037 | 1198737 | 21778 |
1086167 | 1086167 | 2021-03-04 | Madera | California | 6039 | 15553 | 214 |
1086168 | 1086168 | 2021-03-04 | Marin | California | 6041 | 13216 | 198 |
1086169 | 1086169 | 2021-03-04 | Mariposa | California | 6043 | 395 | 7 |
1086170 | 1086170 | 2021-03-04 | Mendocino | California | 6045 | 3827 | 44 |
1086171 | 1086171 | 2021-03-04 | Merced | California | 6047 | 29325 | 412 |
1086172 | 1086172 | 2021-03-04 | Modoc | California | 6049 | 450 | 4 |
1086173 | 1086173 | 2021-03-04 | Mono | California | 6051 | 1191 | 4 |
1086174 | 1086174 | 2021-03-04 | Monterey | California | 6053 | 42362 | 329 |
1086175 | 1086175 | 2021-03-04 | Napa | California | 6055 | 9091 | 74 |
1086176 | 1086176 | 2021-03-04 | Nevada | California | 6057 | 4012 | 74 |
1086177 | 1086177 | 2021-03-04 | Orange | California | 6059 | 261976 | 4013 |
1086178 | 1086178 | 2021-03-04 | Placer | California | 6061 | 19963 | 232 |
1086179 | 1086179 | 2021-03-04 | Plumas | California | 6063 | 631 | 6 |
1086180 | 1086180 | 2021-03-04 | Riverside | California | 6065 | 290744 | 3884 |
1086181 | 1086181 | 2021-03-04 | Sacramento | California | 6067 | 93946 | 1506 |
1086182 | 1086182 | 2021-03-04 | San Benito | California | 6069 | 5774 | 61 |
1086183 | 1086183 | 2021-03-04 | San Bernardino | California | 6071 | 287246 | 3022 |
1086184 | 1086184 | 2021-03-04 | San Diego | California | 6073 | 261924 | 3359 |
1086185 | 1086185 | 2021-03-04 | San Francisco | California | 6075 | 34446 | 423 |
1086186 | 1086186 | 2021-03-04 | San Joaquin | California | 6077 | 67213 | 1177 |
1086187 | 1086187 | 2021-03-04 | San Luis Obispo | California | 6079 | 19797 | 241 |
1086188 | 1086188 | 2021-03-04 | San Mateo | California | 6081 | 39189 | 521 |
1086189 | 1086189 | 2021-03-04 | Santa Barbara | California | 6083 | 32219 | 421 |
1086190 | 1086190 | 2021-03-04 | Santa Clara | California | 6085 | 111281 | 1821 |
1086191 | 1086191 | 2021-03-04 | Santa Cruz | California | 6087 | 14760 | 187 |
1086192 | 1086192 | 2021-03-04 | Shasta | California | 6089 | 11086 | 179 |
1086193 | 1086193 | 2021-03-04 | Sierra | California | 6091 | 48 | 0 |
1086194 | 1086194 | 2021-03-04 | Siskiyou | California | 6093 | 1786 | 14 |
1086195 | 1086195 | 2021-03-04 | Solano | California | 6095 | 30267 | 165 |
1086196 | 1086196 | 2021-03-04 | Sonoma | California | 6097 | 28307 | 301 |
1086197 | 1086197 | 2021-03-04 | Stanislaus | California | 6099 | 56522 | 955 |
1086198 | 1086198 | 2021-03-04 | Sutter | California | 6101 | 8906 | 98 |
1086199 | 1086199 | 2021-03-04 | Tehama | California | 6103 | 4601 | 52 |
1086200 | 1086200 | 2021-03-04 | Trinity | California | 6105 | 303 | 5 |
1086201 | 1086201 | 2021-03-04 | Tulare | California | 6107 | 48163 | 768 |
1086202 | 1086202 | 2021-03-04 | Tuolumne | California | 6109 | 3968 | 59 |
1086203 | 1086203 | 2021-03-04 | Ventura | California | 6111 | 78057 | 876 |
1086204 | 1086204 | 2021-03-04 | Yolo | California | 6113 | 12890 | 185 |
1086205 | 1086205 | 2021-03-04 | Yuba | California | 6115 | 5786 | 39 |
Advanced export
JSON shape: default, array, newline-delimited
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] desc);