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 2021-02-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 |
---|---|---|---|---|---|---|---|
1011500 | 1011500 | 2021-02-09 | Alameda | California | 6001 | 77130 | 1051 |
1011501 | 1011501 | 2021-02-09 | Alpine | California | 6003 | 73 | 0 |
1011502 | 1011502 | 2021-02-09 | Amador | California | 6005 | 3343 | 35 |
1011503 | 1011503 | 2021-02-09 | Butte | California | 6007 | 10524 | 148 |
1011504 | 1011504 | 2021-02-09 | Calaveras | California | 6009 | 1840 | 23 |
1011505 | 1011505 | 2021-02-09 | Colusa | California | 6011 | 2046 | 11 |
1011506 | 1011506 | 2021-02-09 | Contra Costa | California | 6013 | 59585 | 574 |
1011507 | 1011507 | 2021-02-09 | Del Norte | California | 6015 | 905 | 3 |
1011508 | 1011508 | 2021-02-09 | El Dorado | California | 6017 | 8627 | 86 |
1011509 | 1011509 | 2021-02-09 | Fresno | California | 6019 | 91430 | 1254 |
1011510 | 1011510 | 2021-02-09 | Glenn | California | 6021 | 2544 | 23 |
1011511 | 1011511 | 2021-02-09 | Humboldt | California | 6023 | 2960 | 32 |
1011512 | 1011512 | 2021-02-09 | Imperial | California | 6025 | 26526 | 572 |
1011513 | 1011513 | 2021-02-09 | Inyo | California | 6027 | 1126 | 32 |
1011514 | 1011514 | 2021-02-09 | Kern | California | 6029 | 98187 | 660 |
1011515 | 1011515 | 2021-02-09 | Kings | California | 6031 | 21342 | 199 |
1011516 | 1011516 | 2021-02-09 | Lake | California | 6033 | 2949 | 35 |
1011517 | 1011517 | 2021-02-09 | Lassen | California | 6035 | 5492 | 18 |
1011518 | 1011518 | 2021-02-09 | Los Angeles | California | 6037 | 1152740 | 18360 |
1011519 | 1011519 | 2021-02-09 | Madera | California | 6039 | 14887 | 189 |
1011520 | 1011520 | 2021-02-09 | Marin | California | 6041 | 12591 | 176 |
1011521 | 1011521 | 2021-02-09 | Mariposa | California | 6043 | 380 | 5 |
1011522 | 1011522 | 2021-02-09 | Mendocino | California | 6045 | 3612 | 39 |
1011523 | 1011523 | 2021-02-09 | Merced | California | 6047 | 27509 | 367 |
1011524 | 1011524 | 2021-02-09 | Modoc | California | 6049 | 437 | 4 |
1011525 | 1011525 | 2021-02-09 | Mono | California | 6051 | 1165 | 4 |
1011526 | 1011526 | 2021-02-09 | Monterey | California | 6053 | 40908 | 291 |
1011527 | 1011527 | 2021-02-09 | Napa | California | 6055 | 8720 | 59 |
1011528 | 1011528 | 2021-02-09 | Nevada | California | 6057 | 3694 | 74 |
1011529 | 1011529 | 2021-02-09 | Orange | California | 6059 | 253900 | 3416 |
1011530 | 1011530 | 2021-02-09 | Placer | California | 6061 | 19036 | 216 |
1011531 | 1011531 | 2021-02-09 | Plumas | California | 6063 | 584 | 6 |
1011532 | 1011532 | 2021-02-09 | Riverside | California | 6065 | 283525 | 3414 |
1011533 | 1011533 | 2021-02-09 | Sacramento | California | 6067 | 89266 | 1335 |
1011534 | 1011534 | 2021-02-09 | San Benito | California | 6069 | 5553 | 57 |
1011535 | 1011535 | 2021-02-09 | San Bernardino | California | 6071 | 279412 | 2142 |
1011536 | 1011536 | 2021-02-09 | San Diego | California | 6073 | 248114 | 2853 |
1011537 | 1011537 | 2021-02-09 | San Francisco | California | 6075 | 32682 | 346 |
1011538 | 1011538 | 2021-02-09 | San Joaquin | California | 6077 | 64396 | 929 |
1011539 | 1011539 | 2021-02-09 | San Luis Obispo | California | 6079 | 18788 | 200 |
1011540 | 1011540 | 2021-02-09 | San Mateo | California | 6081 | 37139 | 447 |
1011541 | 1011541 | 2021-02-09 | Santa Barbara | California | 6083 | 30206 | 348 |
1011542 | 1011542 | 2021-02-09 | Santa Clara | California | 6085 | 105740 | 1577 |
1011543 | 1011543 | 2021-02-09 | Santa Cruz | California | 6087 | 14055 | 160 |
1011544 | 1011544 | 2021-02-09 | Shasta | California | 6089 | 10700 | 161 |
1011545 | 1011545 | 2021-02-09 | Sierra | California | 6091 | 44 | 0 |
1011546 | 1011546 | 2021-02-09 | Siskiyou | California | 6093 | 1636 | 13 |
1011547 | 1011547 | 2021-02-09 | Solano | California | 6095 | 29045 | 140 |
1011548 | 1011548 | 2021-02-09 | Sonoma | California | 6097 | 26939 | 280 |
1011549 | 1011549 | 2021-02-09 | Stanislaus | California | 6099 | 53278 | 874 |
1011550 | 1011550 | 2021-02-09 | Sutter | California | 6101 | 8594 | 92 |
1011551 | 1011551 | 2021-02-09 | Tehama | California | 6103 | 4403 | 47 |
1011552 | 1011552 | 2021-02-09 | Trinity | California | 6105 | 267 | 5 |
1011553 | 1011553 | 2021-02-09 | Tulare | California | 6107 | 45617 | 651 |
1011554 | 1011554 | 2021-02-09 | Tuolumne | California | 6109 | 3734 | 51 |
1011555 | 1011555 | 2021-02-09 | Ventura | California | 6111 | 74068 | 683 |
1011556 | 1011556 | 2021-02-09 | Yolo | California | 6113 | 12169 | 170 |
1011557 | 1011557 | 2021-02-09 | Yuba | California | 6115 | 5530 | 36 |
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);