repos

Table actions

2 rows where owner = 2 sorted by license

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: tags (array)

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

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
);