pypi_releases

2 rows where version = "sqlite-utils:3.1.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
05f23fd7eedbfed6d68aac44c7779014 sqlite-utils 3.1.1 sqlite-utils:3.1.1 bdist_wheel sqlite_utils-3.1.1-py3-none-any.whl   {"md5": "05f23fd7eedbfed6d68aac44c7779014", "sha256": "c2049bf7d35fc1c33428bf7430b557b60a9b13b7299934c146a786671a96b688"} 0 py3 >=3.6 33802 2021-01-01T23:58:18 2021-01-01T23:58:18.667800Z https://files.pythonhosted.org/packages/87/73/5dce4fcc403482e77850581f17361c73fa3a70867cf53a26e341dc68ed23/sqlite_utils-3.1.1-py3-none-any.whl 0  
88e18fb10608ad5c7be5b4bfc9ca4219 sqlite-utils 3.1.1 sqlite-utils:3.1.1 sdist sqlite-utils-3.1.1.tar.gz   {"md5": "88e18fb10608ad5c7be5b4bfc9ca4219", "sha256": "54df73364662ff3c763da3b42b9d27b1771ebfb3361caa255e44e1bf1544015b"} 0 source >=3.6 105315 2021-01-01T23:58:19 2021-01-01T23:58:19.805550Z https://files.pythonhosted.org/packages/50/a2/f9f712bb552f34321f16c9ce3154dfd7d13d0f51af7b9ddf95632f806f3a/sqlite-utils-3.1.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]);