repos
1 row where license = "apache2" sorted by license
This data as json, CSV (advanced)
id | full_name | name | owner | license ▼ | tags |
---|---|---|---|---|---|
1 | simonw/datasette | datasette | simonw 2 | Apache 2 apache2 | ["databases", "apis"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [repos] ( [id] INTEGER PRIMARY KEY, [full_name] TEXT, [name] TEXT, [owner] INTEGER REFERENCES [users]([id]), [license] TEXT REFERENCES [licenses]([$key]), [tags] TEXT );