pypi_releases

2 rows where version = "datasette-write: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
05cbf37ee0a0b0d7b45be7df963fa2ba datasette-write 0.1 datasette-write:0.1 bdist_wheel datasette_write-0.1-py3-none-any.whl   {"md5": "05cbf37ee0a0b0d7b45be7df963fa2ba", "sha256": "947e8cd967c86921a34a7177d604c86f636774240e884f43b0797b41bcdfd3b6"} 0 py3   3593 2020-07-01T23:48:28 2020-07-01T23:48:28.758544Z https://files.pythonhosted.org/packages/0d/d2/4388bf012757a378e271cfb3434fe159acbace927b7e10416b1b3825c257/datasette_write-0.1-py3-none-any.whl 0  
338b0c09b0991f86d87426f7eac02b01 datasette-write 0.1 datasette-write:0.1 sdist datasette-write-0.1.tar.gz   {"md5": "338b0c09b0991f86d87426f7eac02b01", "sha256": "31c069cb67c575845ace9f7d1809a2c5ea3817643f01e9b304a0987188fdad65"} 0 source   3279 2020-07-01T23:48:29 2020-07-01T23:48:29.544636Z https://files.pythonhosted.org/packages/b6/7d/2c5de4255e86ae7f1877815300ed2cc10e1af87307bdb2b10fab866f97fa/datasette-write-0.1.tar.gz 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]);