Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
This data as json, copyable, CSV (advanced)
| id ▼ | value |
|---|---|
| 1 | San Luis Obispo |
| 2 | Stanislaus |
| 3 | Orange |
| 4 | San Diego |
| 5 | Santa Cruz |
| 6 | Los Angeles |
| 7 | Santa Barbara |
| 8 | Ventura |
| 9 | Fresno |
| 10 | Riverside |
| 11 | Napa |
| 12 | Contra Costa |
| 13 | San Francisco |
| 14 | Monterey |
| 15 | San Mateo |
| 16 | Sonoma |
| 17 | Alameda |
| 18 | Tehama |
| 19 | Santa Clara |
| 20 | Imperial |
JSON shape: default, array, newline-delimited, object
CREATE TABLE [COUNTY] (
[id] INTEGER PRIMARY KEY,
[value] TEXT
);
CREATE UNIQUE INDEX [idx_COUNTY_value]
ON [COUNTY] ([value]);