ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-10-30" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
680494 | 680494 | 2020-10-30 | Alameda | California | 6001 | 23796 | 463 |
680495 | 680495 | 2020-10-30 | Alpine | California | 6003 | 4 | 0 |
680496 | 680496 | 2020-10-30 | Amador | California | 6005 | 337 | 16 |
680497 | 680497 | 2020-10-30 | Butte | California | 6007 | 3144 | 53 |
680498 | 680498 | 2020-10-30 | Calaveras | California | 6009 | 354 | 21 |
680499 | 680499 | 2020-10-30 | Colusa | California | 6011 | 557 | 6 |
680500 | 680500 | 2020-10-30 | Contra Costa | California | 6013 | 18933 | 246 |
680501 | 680501 | 2020-10-30 | Del Norte | California | 6015 | 181 | 1 |
680502 | 680502 | 2020-10-30 | El Dorado | California | 6017 | 1370 | 4 |
680503 | 680503 | 2020-10-30 | Fresno | California | 6019 | 31594 | 443 |
680504 | 680504 | 2020-10-30 | Glenn | California | 6021 | 673 | 3 |
680505 | 680505 | 2020-10-30 | Humboldt | California | 6023 | 571 | 10 |
680506 | 680506 | 2020-10-30 | Imperial | California | 6025 | 13038 | 337 |
680507 | 680507 | 2020-10-30 | Inyo | California | 6027 | 238 | 15 |
680508 | 680508 | 2020-10-30 | Kern | California | 6029 | 34308 | 423 |
680509 | 680509 | 2020-10-30 | Kings | California | 6031 | 8502 | 83 |
680510 | 680510 | 2020-10-30 | Lake | California | 6033 | 702 | 17 |
680511 | 680511 | 2020-10-30 | Lassen | California | 6035 | 772 | 1 |
680512 | 680512 | 2020-10-30 | Los Angeles | California | 6037 | 306327 | 7056 |
680513 | 680513 | 2020-10-30 | Madera | California | 6039 | 5094 | 76 |
680514 | 680514 | 2020-10-30 | Marin | California | 6041 | 7131 | 127 |
680515 | 680515 | 2020-10-30 | Mariposa | California | 6043 | 81 | 2 |
680516 | 680516 | 2020-10-30 | Mendocino | California | 6045 | 1165 | 21 |
680517 | 680517 | 2020-10-30 | Merced | California | 6047 | 9674 | 156 |
680518 | 680518 | 2020-10-30 | Modoc | California | 6049 | 48 | 0 |
680519 | 680519 | 2020-10-30 | Mono | California | 6051 | 182 | 2 |
680520 | 680520 | 2020-10-30 | Monterey | California | 6053 | 11705 | 95 |
680521 | 680521 | 2020-10-30 | Napa | California | 6055 | 2022 | 16 |
680522 | 680522 | 2020-10-30 | Nevada | California | 6057 | 642 | 9 |
680523 | 680523 | 2020-10-30 | Orange | California | 6059 | 61671 | 1475 |
680524 | 680524 | 2020-10-30 | Placer | California | 6061 | 4353 | 59 |
680525 | 680525 | 2020-10-30 | Plumas | California | 6063 | 69 | 0 |
680526 | 680526 | 2020-10-30 | Riverside | California | 6065 | 68050 | 1319 |
680527 | 680527 | 2020-10-30 | Sacramento | California | 6067 | 26184 | 500 |
680528 | 680528 | 2020-10-30 | San Benito | California | 6069 | 1461 | 15 |
680529 | 680529 | 2020-10-30 | San Bernardino | California | 6071 | 64367 | 1074 |
680530 | 680530 | 2020-10-30 | San Diego | California | 6073 | 56432 | 888 |
680531 | 680531 | 2020-10-30 | San Francisco | California | 6075 | 12323 | 147 |
680532 | 680532 | 2020-10-30 | San Joaquin | California | 6077 | 22106 | 494 |
680533 | 680533 | 2020-10-30 | San Luis Obispo | California | 6079 | 4298 | 32 |
680534 | 680534 | 2020-10-30 | San Mateo | California | 6081 | 11341 | 161 |
680535 | 680535 | 2020-10-30 | Santa Barbara | California | 6083 | 9944 | 128 |
680536 | 680536 | 2020-10-30 | Santa Clara | California | 6085 | 24867 | 407 |
680537 | 680537 | 2020-10-30 | Santa Cruz | California | 6087 | 2884 | 26 |
680538 | 680538 | 2020-10-30 | Shasta | California | 6089 | 2046 | 31 |
680539 | 680539 | 2020-10-30 | Sierra | California | 6091 | 6 | 0 |
680540 | 680540 | 2020-10-30 | Siskiyou | California | 6093 | 241 | 0 |
680541 | 680541 | 2020-10-30 | Solano | California | 6095 | 7639 | 76 |
680542 | 680542 | 2020-10-30 | Sonoma | California | 6097 | 9646 | 136 |
680543 | 680543 | 2020-10-30 | Stanislaus | California | 6099 | 18656 | 401 |
680544 | 680544 | 2020-10-30 | Sutter | California | 6101 | 1912 | 12 |
680545 | 680545 | 2020-10-30 | Tehama | California | 6103 | 925 | 9 |
680546 | 680546 | 2020-10-30 | Trinity | California | 6105 | 29 | 0 |
680547 | 680547 | 2020-10-30 | Tulare | California | 6107 | 17852 | 293 |
680548 | 680548 | 2020-10-30 | Tuolumne | California | 6109 | 291 | 6 |
680549 | 680549 | 2020-10-30 | Ventura | California | 6111 | 14486 | 166 |
680550 | 680550 | 2020-10-30 | Yolo | California | 6113 | 3266 | 60 |
680551 | 680551 | 2020-10-30 | Yuba | California | 6115 | 1353 | 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);