COUNTY

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

58 rows

✎ View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [COUNTY] (
   [id] INTEGER PRIMARY KEY,
   [value] TEXT
);
CREATE UNIQUE INDEX [idx_COUNTY_value]
    ON [COUNTY] ([value]);