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-09-27 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
573470 | 573470 | 2020-09-27 | Alameda | California | 6001 | 21210 | 406 |
573471 | 573471 | 2020-09-27 | Alpine | California | 6003 | 2 | 0 |
573472 | 573472 | 2020-09-27 | Amador | California | 6005 | 290 | 16 |
573473 | 573473 | 2020-09-27 | Butte | California | 6007 | 2827 | 44 |
573474 | 573474 | 2020-09-27 | Calaveras | California | 6009 | 317 | 14 |
573475 | 573475 | 2020-09-27 | Colusa | California | 6011 | 529 | 6 |
573476 | 573476 | 2020-09-27 | Contra Costa | California | 6013 | 16640 | 206 |
573477 | 573477 | 2020-09-27 | Del Norte | California | 6015 | 139 | 1 |
573478 | 573478 | 2020-09-27 | El Dorado | California | 6017 | 1127 | 4 |
573479 | 573479 | 2020-09-27 | Fresno | California | 6019 | 28336 | 382 |
573480 | 573480 | 2020-09-27 | Glenn | California | 6021 | 576 | 3 |
573481 | 573481 | 2020-09-27 | Humboldt | California | 6023 | 501 | 7 |
573482 | 573482 | 2020-09-27 | Imperial | California | 6025 | 11835 | 316 |
573483 | 573483 | 2020-09-27 | Inyo | California | 6027 | 187 | 15 |
573484 | 573484 | 2020-09-27 | Kern | California | 6029 | 31994 | 369 |
573485 | 573485 | 2020-09-27 | Kings | California | 6031 | 7651 | 80 |
573486 | 573486 | 2020-09-27 | Lake | California | 6033 | 549 | 11 |
573487 | 573487 | 2020-09-27 | Lassen | California | 6035 | 740 | 0 |
573488 | 573488 | 2020-09-27 | Los Angeles | California | 6037 | 267801 | 6514 |
573489 | 573489 | 2020-09-27 | Madera | California | 6039 | 4458 | 65 |
573490 | 573490 | 2020-09-27 | Marin | California | 6041 | 6730 | 118 |
573491 | 573491 | 2020-09-27 | Mariposa | California | 6043 | 75 | 2 |
573492 | 573492 | 2020-09-27 | Mendocino | California | 6045 | 934 | 18 |
573493 | 573493 | 2020-09-27 | Merced | California | 6047 | 8872 | 142 |
573494 | 573494 | 2020-09-27 | Modoc | California | 6049 | 27 | 0 |
573495 | 573495 | 2020-09-27 | Mono | California | 6051 | 166 | 2 |
573496 | 573496 | 2020-09-27 | Monterey | California | 6053 | 9953 | 72 |
573497 | 573497 | 2020-09-27 | Napa | California | 6055 | 1682 | 13 |
573498 | 573498 | 2020-09-27 | Nevada | California | 6057 | 534 | 7 |
573499 | 573499 | 2020-09-27 | Orange | California | 6059 | 54778 | 1216 |
573500 | 573500 | 2020-09-27 | Placer | California | 6061 | 3577 | 45 |
573501 | 573501 | 2020-09-27 | Plumas | California | 6063 | 48 | 0 |
573502 | 573502 | 2020-09-27 | Riverside | California | 6065 | 58178 | 1189 |
573503 | 573503 | 2020-09-27 | Sacramento | California | 6067 | 22268 | 406 |
573504 | 573504 | 2020-09-27 | San Benito | California | 6069 | 1345 | 11 |
573505 | 573505 | 2020-09-27 | San Bernardino | California | 6071 | 54478 | 925 |
573506 | 573506 | 2020-09-27 | San Diego | California | 6073 | 46673 | 776 |
573507 | 573507 | 2020-09-27 | San Francisco | California | 6075 | 11146 | 101 |
573508 | 573508 | 2020-09-27 | San Joaquin | California | 6077 | 20194 | 441 |
573509 | 573509 | 2020-09-27 | San Luis Obispo | California | 6079 | 3546 | 29 |
573510 | 573510 | 2020-09-27 | San Mateo | California | 6081 | 9843 | 150 |
573511 | 573511 | 2020-09-27 | Santa Barbara | California | 6083 | 9061 | 113 |
573512 | 573512 | 2020-09-27 | Santa Clara | California | 6085 | 21153 | 313 |
573513 | 573513 | 2020-09-27 | Santa Cruz | California | 6087 | 2360 | 9 |
573514 | 573514 | 2020-09-27 | Shasta | California | 6089 | 856 | 17 |
573515 | 573515 | 2020-09-27 | Sierra | California | 6091 | 6 | 0 |
573516 | 573516 | 2020-09-27 | Siskiyou | California | 6093 | 165 | 0 |
573517 | 573517 | 2020-09-27 | Solano | California | 6095 | 6314 | 63 |
573518 | 573518 | 2020-09-27 | Sonoma | California | 6097 | 7412 | 122 |
573519 | 573519 | 2020-09-27 | Stanislaus | California | 6099 | 16452 | 354 |
573520 | 573520 | 2020-09-27 | Sutter | California | 6101 | 1705 | 11 |
573521 | 573521 | 2020-09-27 | Tehama | California | 6103 | 560 | 5 |
573522 | 573522 | 2020-09-27 | Trinity | California | 6105 | 17 | 0 |
573523 | 573523 | 2020-09-27 | Tulare | California | 6107 | 15970 | 263 |
573524 | 573524 | 2020-09-27 | Tuolumne | California | 6109 | 227 | 4 |
573525 | 573525 | 2020-09-27 | Ventura | California | 6111 | 12729 | 150 |
573526 | 573526 | 2020-09-27 | Yolo | California | 6113 | 2803 | 55 |
573527 | 573527 | 2020-09-27 | Yuba | California | 6115 | 1153 | 7 |
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);