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-11-29 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1963038 | 1963038 | 2021-11-29 | Alameda | California | 6001 | 125143 | 1504 |
1963039 | 1963039 | 2021-11-29 | Alpine | California | 6003 | 108 | 0 |
1963040 | 1963040 | 2021-11-29 | Amador | California | 6005 | 5769 | 66 |
1963041 | 1963041 | 2021-11-29 | Butte | California | 6007 | 25441 | 313 |
1963042 | 1963042 | 2021-11-29 | Calaveras | California | 6009 | 4412 | 88 |
1963043 | 1963043 | 2021-11-29 | Colusa | California | 6011 | 3253 | 19 |
1963044 | 1963044 | 2021-11-29 | Contra Costa | California | 6013 | 103686 | 1046 |
1963045 | 1963045 | 2021-11-29 | Del Norte | California | 6015 | 3856 | 42 |
1963046 | 1963046 | 2021-11-29 | El Dorado | California | 6017 | 18294 | 166 |
1963047 | 1963047 | 2021-11-29 | Fresno | California | 6019 | 156677 | 2252 |
1963048 | 1963048 | 2021-11-29 | Glenn | California | 6021 | 4566 | 51 |
1963049 | 1963049 | 2021-11-29 | Humboldt | California | 6023 | 10143 | 118 |
1963050 | 1963050 | 2021-11-29 | Imperial | California | 6025 | 38446 | 772 |
1963051 | 1963051 | 2021-11-29 | Inyo | California | 6027 | 2568 | 46 |
1963052 | 1963052 | 2021-11-29 | Kern | California | 6029 | 157525 | 1791 |
1963053 | 1963053 | 2021-11-29 | Kings | California | 6031 | 35204 | 364 |
1963054 | 1963054 | 2021-11-29 | Lake | California | 6033 | 7039 | 110 |
1963055 | 1963055 | 2021-11-29 | Lassen | California | 6035 | 7923 | 57 |
1963056 | 1963056 | 2021-11-29 | Los Angeles | California | 6037 | 1526976 | 27138 |
1963057 | 1963057 | 2021-11-29 | Madera | California | 6039 | 26180 | 311 |
1963058 | 1963058 | 2021-11-29 | Marin | California | 6041 | 18447 | 249 |
1963059 | 1963059 | 2021-11-29 | Mariposa | California | 6043 | 1598 | 18 |
1963060 | 1963060 | 2021-11-29 | Mendocino | California | 6045 | 8560 | 97 |
1963061 | 1963061 | 2021-11-29 | Merced | California | 6047 | 45417 | 670 |
1963062 | 1963062 | 2021-11-29 | Modoc | California | 6049 | 1021 | 9 |
1963063 | 1963063 | 2021-11-29 | Mono | California | 6051 | 1860 | 4 |
1963064 | 1963064 | 2021-11-29 | Monterey | California | 6053 | 52477 | 632 |
1963065 | 1963065 | 2021-11-29 | Napa | California | 6055 | 13420 | 104 |
1963066 | 1963066 | 2021-11-29 | Nevada | California | 6057 | 10014 | 105 |
1963067 | 1963067 | 2021-11-29 | Orange | California | 6059 | 334176 | 5710 |
1963068 | 1963068 | 2021-11-29 | Placer | California | 6061 | 42120 | 470 |
1963069 | 1963069 | 2021-11-29 | Plumas | California | 6063 | 1936 | 7 |
1963070 | 1963070 | 2021-11-29 | Riverside | California | 6065 | 387395 | 5447 |
1963071 | 1963071 | 2021-11-29 | Sacramento | California | 6067 | 168241 | 2428 |
1963072 | 1963072 | 2021-11-29 | San Benito | California | 6069 | 7807 | 77 |
1963073 | 1963073 | 2021-11-29 | San Bernardino | California | 6071 | 374256 | 5958 |
1963074 | 1963074 | 2021-11-29 | San Diego | California | 6073 | 405162 | 4325 |
1963075 | 1963075 | 2021-11-29 | San Francisco | California | 6075 | 56869 | 669 |
1963076 | 1963076 | 2021-11-29 | San Joaquin | California | 6077 | 107527 | 1837 |
1963077 | 1963077 | 2021-11-29 | San Luis Obispo | California | 6079 | 31463 | 358 |
1963078 | 1963078 | 2021-11-29 | San Mateo | California | 6081 | 56265 | 629 |
1963079 | 1963079 | 2021-11-29 | Santa Barbara | California | 6083 | 47268 | 549 |
1963080 | 1963080 | 2021-11-29 | Santa Clara | California | 6085 | 151905 | 1921 |
1963081 | 1963081 | 2021-11-29 | Santa Cruz | California | 6087 | 22209 | 224 |
1963082 | 1963082 | 2021-11-29 | Shasta | California | 6089 | 26082 | 444 |
1963083 | 1963083 | 2021-11-29 | Sierra | California | 6091 | 218 | 0 |
1963084 | 1963084 | 2021-11-29 | Siskiyou | California | 6093 | 4907 | 70 |
1963085 | 1963085 | 2021-11-29 | Solano | California | 6095 | 47649 | 356 |
1963086 | 1963086 | 2021-11-29 | Sonoma | California | 6097 | 43127 | 412 |
1963087 | 1963087 | 2021-11-29 | Stanislaus | California | 6099 | 91465 | 1415 |
1963088 | 1963088 | 2021-11-29 | Sutter | California | 6101 | 14559 | 186 |
1963089 | 1963089 | 2021-11-29 | Tehama | California | 6103 | 10275 | 130 |
1963090 | 1963090 | 2021-11-29 | Trinity | California | 6105 | 997 | 17 |
1963091 | 1963091 | 2021-11-29 | Tulare | California | 6107 | 86070 | 1095 |
1963092 | 1963092 | 2021-11-29 | Tuolumne | California | 6109 | 7845 | 141 |
1963093 | 1963093 | 2021-11-29 | Ventura | California | 6111 | 103969 | 1190 |
1963094 | 1963094 | 2021-11-29 | Yolo | California | 6113 | 21547 | 257 |
1963095 | 1963095 | 2021-11-29 | Yuba | California | 6115 | 11190 | 89 |
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);