columns

11 rows where table_id = 43

View and edit SQL

id ▼ table_id name
160 Film_Locations_in_San_Francisco 43 Title
161 Film_Locations_in_San_Francisco 43 Release Year
162 Film_Locations_in_San_Francisco 43 Locations
163 Film_Locations_in_San_Francisco 43 Fun Facts
164 Film_Locations_in_San_Francisco 43 Production Company
165 Film_Locations_in_San_Francisco 43 Distributor
166 Film_Locations_in_San_Francisco 43 Director
167 Film_Locations_in_San_Francisco 43 Writer
168 Film_Locations_in_San_Francisco 43 Actor 1
169 Film_Locations_in_San_Francisco 43 Actor 2
170 Film_Locations_in_San_Francisco 43 Actor 3

Advanced export

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

CSV options:

CREATE TABLE columns (
            id integer PRIMARY KEY,
            table_id integer,
            name text,
            FOREIGN KEY (table_id) REFERENCES tables(id)
        );
Powered by Datasette · Query took 8.308ms