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 2020-11-06 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
703198 | 703198 | 2020-11-06 | Alameda | California | 6001 | 24439 | 471 |
703199 | 703199 | 2020-11-06 | Alpine | California | 6003 | 6 | 0 |
703200 | 703200 | 2020-11-06 | Amador | California | 6005 | 362 | 16 |
703201 | 703201 | 2020-11-06 | Butte | California | 6007 | 3239 | 54 |
703202 | 703202 | 2020-11-06 | Calaveras | California | 6009 | 366 | 21 |
703203 | 703203 | 2020-11-06 | Colusa | California | 6011 | 581 | 6 |
703204 | 703204 | 2020-11-06 | Contra Costa | California | 6013 | 19656 | 250 |
703205 | 703205 | 2020-11-06 | Del Norte | California | 6015 | 203 | 1 |
703206 | 703206 | 2020-11-06 | El Dorado | California | 6017 | 1466 | 4 |
703207 | 703207 | 2020-11-06 | Fresno | California | 6019 | 32430 | 454 |
703208 | 703208 | 2020-11-06 | Glenn | California | 6021 | 702 | 3 |
703209 | 703209 | 2020-11-06 | Humboldt | California | 6023 | 605 | 10 |
703210 | 703210 | 2020-11-06 | Imperial | California | 6025 | 13398 | 340 |
703211 | 703211 | 2020-11-06 | Inyo | California | 6027 | 247 | 15 |
703212 | 703212 | 2020-11-06 | Kern | California | 6029 | 35063 | 429 |
703213 | 703213 | 2020-11-06 | Kings | California | 6031 | 8846 | 86 |
703214 | 703214 | 2020-11-06 | Lake | California | 6033 | 739 | 17 |
703215 | 703215 | 2020-11-06 | Lassen | California | 6035 | 790 | 1 |
703216 | 703216 | 2020-11-06 | Los Angeles | California | 6037 | 317727 | 7157 |
703217 | 703217 | 2020-11-06 | Madera | California | 6039 | 5249 | 76 |
703218 | 703218 | 2020-11-06 | Marin | California | 6041 | 7233 | 127 |
703219 | 703219 | 2020-11-06 | Mariposa | California | 6043 | 81 | 2 |
703220 | 703220 | 2020-11-06 | Mendocino | California | 6045 | 1216 | 21 |
703221 | 703221 | 2020-11-06 | Merced | California | 6047 | 9982 | 164 |
703222 | 703222 | 2020-11-06 | Modoc | California | 6049 | 68 | 0 |
703223 | 703223 | 2020-11-06 | Mono | California | 6051 | 335 | 2 |
703224 | 703224 | 2020-11-06 | Monterey | California | 6053 | 12136 | 99 |
703225 | 703225 | 2020-11-06 | Napa | California | 6055 | 2182 | 16 |
703226 | 703226 | 2020-11-06 | Nevada | California | 6057 | 699 | 9 |
703227 | 703227 | 2020-11-06 | Orange | California | 6059 | 63469 | 1503 |
703228 | 703228 | 2020-11-06 | Placer | California | 6061 | 4692 | 60 |
703229 | 703229 | 2020-11-06 | Plumas | California | 6063 | 90 | 0 |
703230 | 703230 | 2020-11-06 | Riverside | California | 6065 | 70696 | 1333 |
703231 | 703231 | 2020-11-06 | Sacramento | California | 6067 | 27529 | 508 |
703232 | 703232 | 2020-11-06 | San Benito | California | 6069 | 1499 | 15 |
703233 | 703233 | 2020-11-06 | San Bernardino | California | 6071 | 67777 | 1092 |
703234 | 703234 | 2020-11-06 | San Diego | California | 6073 | 59179 | 907 |
703235 | 703235 | 2020-11-06 | San Francisco | California | 6075 | 12756 | 151 |
703236 | 703236 | 2020-11-06 | San Joaquin | California | 6077 | 22635 | 494 |
703237 | 703237 | 2020-11-06 | San Luis Obispo | California | 6079 | 4568 | 33 |
703238 | 703238 | 2020-11-06 | San Mateo | California | 6081 | 11710 | 162 |
703239 | 703239 | 2020-11-06 | Santa Barbara | California | 6083 | 10128 | 131 |
703240 | 703240 | 2020-11-06 | Santa Clara | California | 6085 | 25883 | 431 |
703241 | 703241 | 2020-11-06 | Santa Cruz | California | 6087 | 3074 | 26 |
703242 | 703242 | 2020-11-06 | Shasta | California | 6089 | 2452 | 34 |
703243 | 703243 | 2020-11-06 | Sierra | California | 6091 | 6 | 0 |
703244 | 703244 | 2020-11-06 | Siskiyou | California | 6093 | 287 | 0 |
703245 | 703245 | 2020-11-06 | Solano | California | 6095 | 8137 | 79 |
703246 | 703246 | 2020-11-06 | Sonoma | California | 6097 | 10170 | 146 |
703247 | 703247 | 2020-11-06 | Stanislaus | California | 6099 | 19175 | 407 |
703248 | 703248 | 2020-11-06 | Sutter | California | 6101 | 1992 | 12 |
703249 | 703249 | 2020-11-06 | Tehama | California | 6103 | 1015 | 17 |
703250 | 703250 | 2020-11-06 | Trinity | California | 6105 | 42 | 0 |
703251 | 703251 | 2020-11-06 | Tulare | California | 6107 | 18312 | 297 |
703252 | 703252 | 2020-11-06 | Tuolumne | California | 6109 | 329 | 8 |
703253 | 703253 | 2020-11-06 | Ventura | California | 6111 | 15113 | 169 |
703254 | 703254 | 2020-11-06 | Yolo | California | 6113 | 3423 | 63 |
703255 | 703255 | 2020-11-06 | Yuba | California | 6115 | 1434 | 10 |
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);