pypi_versions

4 rows where package = "datasette-template-sql"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ package name
datasette-template-sql:0.1 datasette-template-sql 0.1
datasette-template-sql:1.0 datasette-template-sql 1.0
datasette-template-sql:1.0.1 datasette-template-sql 1.0.1
datasette-template-sql:1.0.2 datasette-template-sql 1.0.2

Advanced export

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

CSV options: 

CREATE TABLE [pypi_versions] (
   [id] TEXT PRIMARY KEY,
   [package] TEXT REFERENCES [pypi_packages]([name]),
   [name] TEXT
);
CREATE INDEX [idx_pypi_versions_package]
    ON [pypi_versions] ([package]);