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-03 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
693469 | 693469 | 2020-11-03 | Alameda | California | 6001 | 24183 | 466 |
693470 | 693470 | 2020-11-03 | Alpine | California | 6003 | 4 | 0 |
693471 | 693471 | 2020-11-03 | Amador | California | 6005 | 356 | 16 |
693472 | 693472 | 2020-11-03 | Butte | California | 6007 | 3198 | 54 |
693473 | 693473 | 2020-11-03 | Calaveras | California | 6009 | 361 | 21 |
693474 | 693474 | 2020-11-03 | Colusa | California | 6011 | 572 | 6 |
693475 | 693475 | 2020-11-03 | Contra Costa | California | 6013 | 19339 | 247 |
693476 | 693476 | 2020-11-03 | Del Norte | California | 6015 | 194 | 1 |
693477 | 693477 | 2020-11-03 | El Dorado | California | 6017 | 1405 | 4 |
693478 | 693478 | 2020-11-03 | Fresno | California | 6019 | 32022 | 447 |
693479 | 693479 | 2020-11-03 | Glenn | California | 6021 | 692 | 3 |
693480 | 693480 | 2020-11-03 | Humboldt | California | 6023 | 586 | 10 |
693481 | 693481 | 2020-11-03 | Imperial | California | 6025 | 13260 | 337 |
693482 | 693482 | 2020-11-03 | Inyo | California | 6027 | 243 | 15 |
693483 | 693483 | 2020-11-03 | Kern | California | 6029 | 34676 | 425 |
693484 | 693484 | 2020-11-03 | Kings | California | 6031 | 8673 | 84 |
693485 | 693485 | 2020-11-03 | Lake | California | 6033 | 728 | 17 |
693486 | 693486 | 2020-11-03 | Lassen | California | 6035 | 782 | 1 |
693487 | 693487 | 2020-11-03 | Los Angeles | California | 6037 | 311745 | 7097 |
693488 | 693488 | 2020-11-03 | Madera | California | 6039 | 5094 | 76 |
693489 | 693489 | 2020-11-03 | Marin | California | 6041 | 7181 | 127 |
693490 | 693490 | 2020-11-03 | Mariposa | California | 6043 | 81 | 2 |
693491 | 693491 | 2020-11-03 | Mendocino | California | 6045 | 1188 | 21 |
693492 | 693492 | 2020-11-03 | Merced | California | 6047 | 9819 | 160 |
693493 | 693493 | 2020-11-03 | Modoc | California | 6049 | 52 | 0 |
693494 | 693494 | 2020-11-03 | Mono | California | 6051 | 237 | 2 |
693495 | 693495 | 2020-11-03 | Monterey | California | 6053 | 11906 | 97 |
693496 | 693496 | 2020-11-03 | Napa | California | 6055 | 2109 | 16 |
693497 | 693497 | 2020-11-03 | Nevada | California | 6057 | 672 | 9 |
693498 | 693498 | 2020-11-03 | Orange | California | 6059 | 62589 | 1484 |
693499 | 693499 | 2020-11-03 | Placer | California | 6061 | 4527 | 60 |
693500 | 693500 | 2020-11-03 | Plumas | California | 6063 | 86 | 0 |
693501 | 693501 | 2020-11-03 | Riverside | California | 6065 | 69407 | 1324 |
693502 | 693502 | 2020-11-03 | Sacramento | California | 6067 | 26883 | 504 |
693503 | 693503 | 2020-11-03 | San Benito | California | 6069 | 1478 | 15 |
693504 | 693504 | 2020-11-03 | San Bernardino | California | 6071 | 65997 | 1079 |
693505 | 693505 | 2020-11-03 | San Diego | California | 6073 | 57765 | 901 |
693506 | 693506 | 2020-11-03 | San Francisco | California | 6075 | 12557 | 149 |
693507 | 693507 | 2020-11-03 | San Joaquin | California | 6077 | 22365 | 494 |
693508 | 693508 | 2020-11-03 | San Luis Obispo | California | 6079 | 4380 | 33 |
693509 | 693509 | 2020-11-03 | San Mateo | California | 6081 | 11479 | 161 |
693510 | 693510 | 2020-11-03 | Santa Barbara | California | 6083 | 10016 | 129 |
693511 | 693511 | 2020-11-03 | Santa Clara | California | 6085 | 25421 | 413 |
693512 | 693512 | 2020-11-03 | Santa Cruz | California | 6087 | 2974 | 26 |
693513 | 693513 | 2020-11-03 | Shasta | California | 6089 | 2284 | 32 |
693514 | 693514 | 2020-11-03 | Sierra | California | 6091 | 6 | 0 |
693515 | 693515 | 2020-11-03 | Siskiyou | California | 6093 | 272 | 0 |
693516 | 693516 | 2020-11-03 | Solano | California | 6095 | 7854 | 76 |
693517 | 693517 | 2020-11-03 | Sonoma | California | 6097 | 9953 | 142 |
693518 | 693518 | 2020-11-03 | Stanislaus | California | 6099 | 18915 | 403 |
693519 | 693519 | 2020-11-03 | Sutter | California | 6101 | 1951 | 12 |
693520 | 693520 | 2020-11-03 | Tehama | California | 6103 | 971 | 14 |
693521 | 693521 | 2020-11-03 | Trinity | California | 6105 | 31 | 0 |
693522 | 693522 | 2020-11-03 | Tulare | California | 6107 | 18053 | 295 |
693523 | 693523 | 2020-11-03 | Tuolumne | California | 6109 | 309 | 6 |
693524 | 693524 | 2020-11-03 | Ventura | California | 6111 | 14767 | 167 |
693525 | 693525 | 2020-11-03 | Yolo | California | 6113 | 3344 | 61 |
693526 | 693526 | 2020-11-03 | Yuba | California | 6115 | 1398 | 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);