view_on_repos (view)
3 rows
This data as json, CSV (advanced)
Suggested facets: owner, tags (array)
id | full_name | name | owner | license | tags |
---|---|---|---|---|---|
1 | simonw/datasette | datasette | 2 | apache2 | ["databases", "apis"] |
2 | cleopaws/dogspotter | dogspotter | 1 | mit | ["dogs"] |
3 | simonw/private | private | 2 | [] |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW view_on_repos AS select * from repos;