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-12-09 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
810280 | 810280 | 2020-12-09 | Alameda | California | 6001 | 34394 | 526 |
810281 | 810281 | 2020-12-09 | Alpine | California | 6003 | 53 | 0 |
810282 | 810282 | 2020-12-09 | Amador | California | 6005 | 1042 | 17 |
810283 | 810283 | 2020-12-09 | Butte | California | 6007 | 4757 | 64 |
810284 | 810284 | 2020-12-09 | Calaveras | California | 6009 | 657 | 22 |
810285 | 810285 | 2020-12-09 | Colusa | California | 6011 | 895 | 7 |
810286 | 810286 | 2020-12-09 | Contra Costa | California | 6013 | 28391 | 270 |
810287 | 810287 | 2020-12-09 | Del Norte | California | 6015 | 489 | 1 |
810288 | 810288 | 2020-12-09 | El Dorado | California | 6017 | 3296 | 8 |
810289 | 810289 | 2020-12-09 | Fresno | California | 6019 | 41574 | 514 |
810290 | 810290 | 2020-12-09 | Glenn | California | 6021 | 1094 | 11 |
810291 | 810291 | 2020-12-09 | Humboldt | California | 6023 | 1163 | 10 |
810292 | 810292 | 2020-12-09 | Imperial | California | 6025 | 17733 | 366 |
810293 | 810293 | 2020-12-09 | Inyo | California | 6027 | 333 | 16 |
810294 | 810294 | 2020-12-09 | Kern | California | 6029 | 47411 | 463 |
810295 | 810295 | 2020-12-09 | Kings | California | 6031 | 12716 | 97 |
810296 | 810296 | 2020-12-09 | Lake | California | 6033 | 1127 | 21 |
810297 | 810297 | 2020-12-09 | Lassen | California | 6035 | 2930 | 5 |
810298 | 810298 | 2020-12-09 | Los Angeles | California | 6037 | 475409 | 8075 |
810299 | 810299 | 2020-12-09 | Madera | California | 6039 | 7251 | 107 |
810300 | 810300 | 2020-12-09 | Marin | California | 6041 | 8252 | 132 |
810301 | 810301 | 2020-12-09 | Mariposa | California | 6043 | 167 | 4 |
810302 | 810302 | 2020-12-09 | Mendocino | California | 6045 | 1873 | 24 |
810303 | 810303 | 2020-12-09 | Merced | California | 6047 | 14058 | 201 |
810304 | 810304 | 2020-12-09 | Modoc | California | 6049 | 197 | 0 |
810305 | 810305 | 2020-12-09 | Mono | California | 6051 | 597 | 3 |
810306 | 810306 | 2020-12-09 | Monterey | California | 6053 | 17752 | 146 |
810307 | 810307 | 2020-12-09 | Napa | California | 6055 | 3814 | 22 |
810308 | 810308 | 2020-12-09 | Nevada | California | 6057 | 1895 | 19 |
810309 | 810309 | 2020-12-09 | Orange | California | 6059 | 95425 | 1633 |
810310 | 810310 | 2020-12-09 | Placer | California | 6061 | 8544 | 85 |
810311 | 810311 | 2020-12-09 | Plumas | California | 6063 | 258 | 0 |
810312 | 810312 | 2020-12-09 | Riverside | California | 6065 | 107620 | 1539 |
810313 | 810313 | 2020-12-09 | Sacramento | California | 6067 | 45335 | 646 |
810314 | 810314 | 2020-12-09 | San Benito | California | 6069 | 2264 | 19 |
810315 | 810315 | 2020-12-09 | San Bernardino | California | 6071 | 111518 | 1208 |
810316 | 810316 | 2020-12-09 | San Diego | California | 6073 | 97612 | 1103 |
810317 | 810317 | 2020-12-09 | San Francisco | California | 6075 | 17387 | 164 |
810318 | 810318 | 2020-12-09 | San Joaquin | California | 6077 | 30579 | 532 |
810319 | 810319 | 2020-12-09 | San Luis Obispo | California | 6079 | 7071 | 45 |
810320 | 810320 | 2020-12-09 | San Mateo | California | 6081 | 16666 | 177 |
810321 | 810321 | 2020-12-09 | Santa Barbara | California | 6083 | 12636 | 139 |
810322 | 810322 | 2020-12-09 | Santa Clara | California | 6085 | 43001 | 516 |
810323 | 810323 | 2020-12-09 | Santa Cruz | California | 6087 | 5388 | 47 |
810324 | 810324 | 2020-12-09 | Shasta | California | 6089 | 6135 | 54 |
810325 | 810325 | 2020-12-09 | Sierra | California | 6091 | 18 | 0 |
810326 | 810326 | 2020-12-09 | Siskiyou | California | 6093 | 863 | 7 |
810327 | 810327 | 2020-12-09 | Solano | California | 6095 | 12128 | 90 |
810328 | 810328 | 2020-12-09 | Sonoma | California | 6097 | 13912 | 162 |
810329 | 810329 | 2020-12-09 | Stanislaus | California | 6099 | 27134 | 454 |
810330 | 810330 | 2020-12-09 | Sutter | California | 6101 | 4502 | 30 |
810331 | 810331 | 2020-12-09 | Tehama | California | 6103 | 2057 | 29 |
810332 | 810332 | 2020-12-09 | Trinity | California | 6105 | 199 | 1 |
810333 | 810333 | 2020-12-09 | Tulare | California | 6107 | 24239 | 323 |
810334 | 810334 | 2020-12-09 | Tuolumne | California | 6109 | 1458 | 15 |
810335 | 810335 | 2020-12-09 | Ventura | California | 6111 | 23665 | 197 |
810336 | 810336 | 2020-12-09 | Yolo | California | 6113 | 5639 | 89 |
810337 | 810337 | 2020-12-09 | Yuba | California | 6115 | 2700 | 11 |
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);