ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-12-08" 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 |
---|---|---|---|---|---|---|---|
1992290 | 1992290 | 2021-12-08 | Alameda | California | 6001 | 126466 | 1513 |
1992291 | 1992291 | 2021-12-08 | Alpine | California | 6003 | 108 | 0 |
1992292 | 1992292 | 2021-12-08 | Amador | California | 6005 | 5848 | 69 |
1992293 | 1992293 | 2021-12-08 | Butte | California | 6007 | 25731 | 324 |
1992294 | 1992294 | 2021-12-08 | Calaveras | California | 6009 | 4510 | 88 |
1992295 | 1992295 | 2021-12-08 | Colusa | California | 6011 | 3302 | 21 |
1992296 | 1992296 | 2021-12-08 | Contra Costa | California | 6013 | 104815 | 1058 |
1992297 | 1992297 | 2021-12-08 | Del Norte | California | 6015 | 3909 | 42 |
1992298 | 1992298 | 2021-12-08 | El Dorado | California | 6017 | 18569 | 170 |
1992299 | 1992299 | 2021-12-08 | Fresno | California | 6019 | 158450 | 2289 |
1992300 | 1992300 | 2021-12-08 | Glenn | California | 6021 | 4605 | 51 |
1992301 | 1992301 | 2021-12-08 | Humboldt | California | 6023 | 10391 | 120 |
1992302 | 1992302 | 2021-12-08 | Imperial | California | 6025 | 39228 | 777 |
1992303 | 1992303 | 2021-12-08 | Inyo | California | 6027 | 2602 | 46 |
1992304 | 1992304 | 2021-12-08 | Kern | California | 6029 | 159336 | 1855 |
1992305 | 1992305 | 2021-12-08 | Kings | California | 6031 | 35628 | 372 |
1992306 | 1992306 | 2021-12-08 | Lake | California | 6033 | 7079 | 113 |
1992307 | 1992307 | 2021-12-08 | Lassen | California | 6035 | 8012 | 61 |
1992308 | 1992308 | 2021-12-08 | Los Angeles | California | 6037 | 1540904 | 27275 |
1992309 | 1992309 | 2021-12-08 | Madera | California | 6039 | 26567 | 311 |
1992310 | 1992310 | 2021-12-08 | Marin | California | 6041 | 18796 | 249 |
1992311 | 1992311 | 2021-12-08 | Mariposa | California | 6043 | 1640 | 18 |
1992312 | 1992312 | 2021-12-08 | Mendocino | California | 6045 | 8775 | 99 |
1992313 | 1992313 | 2021-12-08 | Merced | California | 6047 | 45961 | 684 |
1992314 | 1992314 | 2021-12-08 | Modoc | California | 6049 | 1065 | 10 |
1992315 | 1992315 | 2021-12-08 | Mono | California | 6051 | 1941 | 4 |
1992316 | 1992316 | 2021-12-08 | Monterey | California | 6053 | 53040 | 636 |
1992317 | 1992317 | 2021-12-08 | Napa | California | 6055 | 13529 | 107 |
1992318 | 1992318 | 2021-12-08 | Nevada | California | 6057 | 10218 | 105 |
1992319 | 1992319 | 2021-12-08 | Orange | California | 6059 | 337328 | 5796 |
1992320 | 1992320 | 2021-12-08 | Placer | California | 6061 | 42858 | 479 |
1992321 | 1992321 | 2021-12-08 | Plumas | California | 6063 | 1969 | 12 |
1992322 | 1992322 | 2021-12-08 | Riverside | California | 6065 | 392020 | 5492 |
1992323 | 1992323 | 2021-12-08 | Sacramento | California | 6067 | 170342 | 2467 |
1992324 | 1992324 | 2021-12-08 | San Benito | California | 6069 | 7967 | 78 |
1992325 | 1992325 | 2021-12-08 | San Bernardino | California | 6071 | 379107 | 6007 |
1992326 | 1992326 | 2021-12-08 | San Diego | California | 6073 | 413645 | 4357 |
1992327 | 1992327 | 2021-12-08 | San Francisco | California | 6075 | 57587 | 676 |
1992328 | 1992328 | 2021-12-08 | San Joaquin | California | 6077 | 108590 | 1839 |
1992329 | 1992329 | 2021-12-08 | San Luis Obispo | California | 6079 | 31844 | 365 |
1992330 | 1992330 | 2021-12-08 | San Mateo | California | 6081 | 56974 | 631 |
1992331 | 1992331 | 2021-12-08 | Santa Barbara | California | 6083 | 47954 | 556 |
1992332 | 1992332 | 2021-12-08 | Santa Clara | California | 6085 | 154047 | 1942 |
1992333 | 1992333 | 2021-12-08 | Santa Cruz | California | 6087 | 22609 | 224 |
1992334 | 1992334 | 2021-12-08 | Shasta | California | 6089 | 26397 | 465 |
1992335 | 1992335 | 2021-12-08 | Sierra | California | 6091 | 222 | 0 |
1992336 | 1992336 | 2021-12-08 | Siskiyou | California | 6093 | 4977 | 74 |
1992337 | 1992337 | 2021-12-08 | Solano | California | 6095 | 48116 | 365 |
1992338 | 1992338 | 2021-12-08 | Sonoma | California | 6097 | 43725 | 414 |
1992339 | 1992339 | 2021-12-08 | Stanislaus | California | 6099 | 92420 | 1441 |
1992340 | 1992340 | 2021-12-08 | Sutter | California | 6101 | 14740 | 186 |
1992341 | 1992341 | 2021-12-08 | Tehama | California | 6103 | 10339 | 133 |
1992342 | 1992342 | 2021-12-08 | Trinity | California | 6105 | 1025 | 17 |
1992343 | 1992343 | 2021-12-08 | Tulare | California | 6107 | 87136 | 1103 |
1992344 | 1992344 | 2021-12-08 | Tuolumne | California | 6109 | 7965 | 145 |
1992345 | 1992345 | 2021-12-08 | Ventura | California | 6111 | 105127 | 1194 |
1992346 | 1992346 | 2021-12-08 | Yolo | California | 6113 | 21840 | 263 |
1992347 | 1992347 | 2021-12-08 | Yuba | California | 6115 | 11348 | 91 |
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);