repos

3 rows

View and edit SQL

Suggested facets: tags (array)

owner

id ▼ full_name name owner license tags
1 simonw/datasette datasette simonw 2 Apache 2 apache2 ["databases", "apis"]
2 cleopaws/dogspotter dogspotter cleopaws 1 MIT mit ["dogs"]
3 simonw/private private simonw 2   []

Advanced export

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

CSV options:

CREATE TABLE [repos] (
   [id] INTEGER PRIMARY KEY,
   [full_name] TEXT,
   [name] TEXT,
   [owner] INTEGER REFERENCES [users]([id]),
   [license] TEXT REFERENCES [licenses]([$key]),
   [tags] TEXT
);
Powered by Datasette · Query took 20.455ms · About: simonw/datasette-graphql