pypi_releases

2 rows where version = "sqlite-generate:0.1"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: upload_time (date), upload_time_iso_8601 (date)

md5_digest ▼ package version packagetype filename comment_text digests has_sig python_version requires_python size upload_time upload_time_iso_8601 url yanked yanked_reason
17fde62e5038742f0e492c8a54e55630 sqlite-generate 0.1 sqlite-generate:0.1 sdist sqlite-generate-0.1.tar.gz   {"md5": "17fde62e5038742f0e492c8a54e55630", "sha256": "29b8695a4dda0a72cea124830d105ed8f23203c254c2059d27d8a3c58a39a186"} 0 source   2378 2020-06-22T23:44:39 2020-06-22T23:44:39.178784Z https://files.pythonhosted.org/packages/fb/6c/164ea6a47d267d436364daf186cfa19e45b785aadf9586bec4cc060f99fe/sqlite-generate-0.1.tar.gz 0  
74e40918511c1b38cc91b49af8a7fe25 sqlite-generate 0.1 sqlite-generate:0.1 bdist_wheel sqlite_generate-0.1-py3-none-any.whl   {"md5": "74e40918511c1b38cc91b49af8a7fe25", "sha256": "2ffcd92c76f3eeb4d4e3ce1d035c5d538a5979dfb553439dc705757154ce2a5f"} 0 py3   6837 2020-06-22T23:44:37 2020-06-22T23:44:37.249754Z https://files.pythonhosted.org/packages/01/93/d056c31db4164ee2deab9aa4f3f04c17765ed49eb7691b67f4f44da1ee4f/sqlite_generate-0.1-py3-none-any.whl 0  

Advanced export

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

CSV options: 

CREATE TABLE [pypi_releases] (
   [md5_digest] TEXT PRIMARY KEY,
   [package] TEXT REFERENCES [pypi_packages]([name]),
   [version] TEXT REFERENCES [pypi_versions]([id]),
   [packagetype] TEXT,
   [filename] TEXT,
   [comment_text] TEXT,
   [digests] TEXT,
   [has_sig] INTEGER,
   [python_version] TEXT,
   [requires_python] TEXT,
   [size] INTEGER,
   [upload_time] TEXT,
   [upload_time_iso_8601] TEXT,
   [url] TEXT,
   [yanked] INTEGER,
   [yanked_reason] TEXT
);
CREATE INDEX [idx_pypi_releases_version]
    ON [pypi_releases] ([version]);
CREATE INDEX [idx_pypi_releases_package]
    ON [pypi_releases] ([package]);