ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-09-30" 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 |
---|---|---|---|---|---|---|---|
1768063 | 1768063 | 2021-09-30 | Alameda | California | 6001 | 117832 | 1343 |
1768064 | 1768064 | 2021-09-30 | Alpine | California | 6003 | 101 | 0 |
1768065 | 1768065 | 2021-09-30 | Amador | California | 6005 | 5118 | 61 |
1768066 | 1768066 | 2021-09-30 | Butte | California | 6007 | 22380 | 242 |
1768067 | 1768067 | 2021-09-30 | Calaveras | California | 6009 | 3602 | 72 |
1768068 | 1768068 | 2021-09-30 | Colusa | California | 6011 | 2966 | 18 |
1768069 | 1768069 | 2021-09-30 | Contra Costa | California | 6013 | 97261 | 929 |
1768070 | 1768070 | 2021-09-30 | Del Norte | California | 6015 | 3585 | 39 |
1768071 | 1768071 | 2021-09-30 | El Dorado | California | 6017 | 16417 | 136 |
1768072 | 1768072 | 2021-09-30 | Fresno | California | 6019 | 139353 | 1957 |
1768073 | 1768073 | 2021-09-30 | Glenn | California | 6021 | 4151 | 37 |
1768074 | 1768074 | 2021-09-30 | Humboldt | California | 6023 | 8645 | 98 |
1768075 | 1768075 | 2021-09-30 | Imperial | California | 6025 | 34797 | 756 |
1768076 | 1768076 | 2021-09-30 | Inyo | California | 6027 | 1767 | 39 |
1768077 | 1768077 | 2021-09-30 | Kern | California | 6029 | 139021 | 1544 |
1768078 | 1768078 | 2021-09-30 | Kings | California | 6031 | 31028 | 299 |
1768079 | 1768079 | 2021-09-30 | Lake | California | 6033 | 6274 | 97 |
1768080 | 1768080 | 2021-09-30 | Lassen | California | 6035 | 7215 | 38 |
1768081 | 1768081 | 2021-09-30 | Los Angeles | California | 6037 | 1459891 | 26106 |
1768082 | 1768082 | 2021-09-30 | Madera | California | 6039 | 22484 | 269 |
1768083 | 1768083 | 2021-09-30 | Marin | California | 6041 | 17334 | 242 |
1768084 | 1768084 | 2021-09-30 | Mariposa | California | 6043 | 1094 | 13 |
1768085 | 1768085 | 2021-09-30 | Mendocino | California | 6045 | 7191 | 84 |
1768086 | 1768086 | 2021-09-30 | Merced | California | 6047 | 40780 | 557 |
1768087 | 1768087 | 2021-09-30 | Modoc | California | 6049 | 724 | 8 |
1768088 | 1768088 | 2021-09-30 | Mono | California | 6051 | 1543 | 5 |
1768089 | 1768089 | 2021-09-30 | Monterey | California | 6053 | 50161 | 574 |
1768090 | 1768090 | 2021-09-30 | Napa | California | 6055 | 12506 | 96 |
1768091 | 1768091 | 2021-09-30 | Nevada | California | 6057 | 8723 | 87 |
1768092 | 1768092 | 2021-09-30 | Orange | California | 6059 | 319132 | 5432 |
1768093 | 1768093 | 2021-09-30 | Placer | California | 6061 | 37636 | 379 |
1768094 | 1768094 | 2021-09-30 | Plumas | California | 6063 | 1318 | 6 |
1768095 | 1768095 | 2021-09-30 | Riverside | California | 6065 | 363281 | 4994 |
1768096 | 1768096 | 2021-09-30 | Sacramento | California | 6067 | 153768 | 2181 |
1768097 | 1768097 | 2021-09-30 | San Benito | California | 6069 | 7195 | 69 |
1768098 | 1768098 | 2021-09-30 | San Bernardino | California | 6071 | 351423 | 5545 |
1768099 | 1768099 | 2021-09-30 | San Diego | California | 6073 | 372734 | 4066 |
1768100 | 1768100 | 2021-09-30 | San Francisco | California | 6075 | 52815 | 629 |
1768101 | 1768101 | 2021-09-30 | San Joaquin | California | 6077 | 99527 | 1654 |
1768102 | 1768102 | 2021-09-30 | San Luis Obispo | California | 6079 | 28960 | 324 |
1768103 | 1768103 | 2021-09-30 | San Mateo | California | 6081 | 53012 | 612 |
1768104 | 1768104 | 2021-09-30 | Santa Barbara | California | 6083 | 43953 | 507 |
1768105 | 1768105 | 2021-09-30 | Santa Clara | California | 6085 | 142191 | 1862 |
1768106 | 1768106 | 2021-09-30 | Santa Cruz | California | 6087 | 20478 | 214 |
1768107 | 1768107 | 2021-09-30 | Shasta | California | 6089 | 22059 | 299 |
1768108 | 1768108 | 2021-09-30 | Sierra | California | 6091 | 145 | 0 |
1768109 | 1768109 | 2021-09-30 | Siskiyou | California | 6093 | 4382 | 54 |
1768110 | 1768110 | 2021-09-30 | Solano | California | 6095 | 44869 | 321 |
1768111 | 1768111 | 2021-09-30 | Sonoma | California | 6097 | 39930 | 386 |
1768112 | 1768112 | 2021-09-30 | Stanislaus | California | 6099 | 82575 | 1283 |
1768113 | 1768113 | 2021-09-30 | Sutter | California | 6101 | 13413 | 155 |
1768114 | 1768114 | 2021-09-30 | Tehama | California | 6103 | 8699 | 88 |
1768115 | 1768115 | 2021-09-30 | Trinity | California | 6105 | 790 | 10 |
1768116 | 1768116 | 2021-09-30 | Tulare | California | 6107 | 75711 | 908 |
1768117 | 1768117 | 2021-09-30 | Tuolumne | California | 6109 | 6550 | 103 |
1768118 | 1768118 | 2021-09-30 | Ventura | California | 6111 | 99034 | 1146 |
1768119 | 1768119 | 2021-09-30 | Yolo | California | 6113 | 19591 | 239 |
1768120 | 1768120 | 2021-09-30 | Yuba | California | 6115 | 9931 | 66 |
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);