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-10-21 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1836295 | 1836295 | 2021-10-21 | Alameda | California | 6001 | 120551 | 1400 |
1836296 | 1836296 | 2021-10-21 | Alpine | California | 6003 | 103 | 0 |
1836297 | 1836297 | 2021-10-21 | Amador | California | 6005 | 5439 | 64 |
1836298 | 1836298 | 2021-10-21 | Butte | California | 6007 | 23738 | 270 |
1836299 | 1836299 | 2021-10-21 | Calaveras | California | 6009 | 3893 | 81 |
1836300 | 1836300 | 2021-10-21 | Colusa | California | 6011 | 3072 | 18 |
1836301 | 1836301 | 2021-10-21 | Contra Costa | California | 6013 | 99884 | 1008 |
1836302 | 1836302 | 2021-10-21 | Del Norte | California | 6015 | 3685 | 42 |
1836303 | 1836303 | 2021-10-21 | El Dorado | California | 6017 | 17169 | 149 |
1836304 | 1836304 | 2021-10-21 | Fresno | California | 6019 | 145877 | 2084 |
1836305 | 1836305 | 2021-10-21 | Glenn | California | 6021 | 4367 | 42 |
1836306 | 1836306 | 2021-10-21 | Humboldt | California | 6023 | 9243 | 108 |
1836307 | 1836307 | 2021-10-21 | Imperial | California | 6025 | 35999 | 765 |
1836308 | 1836308 | 2021-10-21 | Inyo | California | 6027 | 2111 | 40 |
1836309 | 1836309 | 2021-10-21 | Kern | California | 6029 | 145962 | 1644 |
1836310 | 1836310 | 2021-10-21 | Kings | California | 6031 | 32801 | 323 |
1836311 | 1836311 | 2021-10-21 | Lake | California | 6033 | 6605 | 104 |
1836312 | 1836312 | 2021-10-21 | Lassen | California | 6035 | 7543 | 49 |
1836313 | 1836313 | 2021-10-21 | Los Angeles | California | 6037 | 1482518 | 26506 |
1836314 | 1836314 | 2021-10-21 | Madera | California | 6039 | 23876 | 285 |
1836315 | 1836315 | 2021-10-21 | Marin | California | 6041 | 17692 | 244 |
1836316 | 1836316 | 2021-10-21 | Mariposa | California | 6043 | 1334 | 16 |
1836317 | 1836317 | 2021-10-21 | Mendocino | California | 6045 | 7636 | 87 |
1836318 | 1836318 | 2021-10-21 | Merced | California | 6047 | 42667 | 586 |
1836319 | 1836319 | 2021-10-21 | Modoc | California | 6049 | 804 | 9 |
1836320 | 1836320 | 2021-10-21 | Mono | California | 6051 | 1670 | 5 |
1836321 | 1836321 | 2021-10-21 | Monterey | California | 6053 | 50885 | 590 |
1836322 | 1836322 | 2021-10-21 | Napa | California | 6055 | 12883 | 100 |
1836323 | 1836323 | 2021-10-21 | Nevada | California | 6057 | 9142 | 90 |
1836324 | 1836324 | 2021-10-21 | Orange | California | 6059 | 324184 | 5550 |
1836325 | 1836325 | 2021-10-21 | Placer | California | 6061 | 39342 | 425 |
1836326 | 1836326 | 2021-10-21 | Plumas | California | 6063 | 1641 | 7 |
1836327 | 1836327 | 2021-10-21 | Riverside | California | 6065 | 371293 | 5129 |
1836328 | 1836328 | 2021-10-21 | Sacramento | California | 6067 | 159332 | 2308 |
1836329 | 1836329 | 2021-10-21 | San Benito | California | 6069 | 7444 | 71 |
1836330 | 1836330 | 2021-10-21 | San Bernardino | California | 6071 | 358213 | 5663 |
1836331 | 1836331 | 2021-10-21 | San Diego | California | 6073 | 382533 | 4178 |
1836332 | 1836332 | 2021-10-21 | San Francisco | California | 6075 | 54378 | 646 |
1836333 | 1836333 | 2021-10-21 | San Joaquin | California | 6077 | 102582 | 1726 |
1836334 | 1836334 | 2021-10-21 | San Luis Obispo | California | 6079 | 29945 | 335 |
1836335 | 1836335 | 2021-10-21 | San Mateo | California | 6081 | 54112 | 622 |
1836336 | 1836336 | 2021-10-21 | Santa Barbara | California | 6083 | 45160 | 523 |
1836337 | 1836337 | 2021-10-21 | Santa Clara | California | 6085 | 145391 | 1897 |
1836338 | 1836338 | 2021-10-21 | Santa Cruz | California | 6087 | 21018 | 219 |
1836339 | 1836339 | 2021-10-21 | Shasta | California | 6089 | 23851 | 352 |
1836340 | 1836340 | 2021-10-21 | Sierra | California | 6091 | 188 | 0 |
1836341 | 1836341 | 2021-10-21 | Siskiyou | California | 6093 | 4652 | 62 |
1836342 | 1836342 | 2021-10-21 | Solano | California | 6095 | 46026 | 341 |
1836343 | 1836343 | 2021-10-21 | Sonoma | California | 6097 | 40925 | 402 |
1836344 | 1836344 | 2021-10-21 | Stanislaus | California | 6099 | 86070 | 1331 |
1836345 | 1836345 | 2021-10-21 | Sutter | California | 6101 | 13913 | 175 |
1836346 | 1836346 | 2021-10-21 | Tehama | California | 6103 | 9510 | 110 |
1836347 | 1836347 | 2021-10-21 | Trinity | California | 6105 | 878 | 11 |
1836348 | 1836348 | 2021-10-21 | Tulare | California | 6107 | 80203 | 968 |
1836349 | 1836349 | 2021-10-21 | Tuolumne | California | 6109 | 7039 | 113 |
1836350 | 1836350 | 2021-10-21 | Ventura | California | 6111 | 100984 | 1166 |
1836351 | 1836351 | 2021-10-21 | Yolo | California | 6113 | 20353 | 248 |
1836352 | 1836352 | 2021-10-21 | Yuba | California | 6115 | 10488 | 82 |
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);