repos

Table actions

3 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: owner, tags (array)

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