pypi_releases

2 rows where version = "sqlite-utils:2.22"

✎ 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
96f37a388f794c896642a910b819823f sqlite-utils 2.22 sqlite-utils:2.22 bdist_wheel sqlite_utils-2.22-py3-none-any.whl   {"md5": "96f37a388f794c896642a910b819823f", "sha256": "f7de6e9a827ade79f2b85d7ebdea00ca165ed1a0da7c0c17f3ec6498e19a8166"} 0 py3   30285 2020-10-16T19:34:07 2020-10-16T19:34:07.942033Z https://files.pythonhosted.org/packages/77/5a/222ce3841de6d38b3c9d7444f84e61c28e6dc6f1e8d4a9c6d09ba32a18f5/sqlite_utils-2.22-py3-none-any.whl 0  
d73dead3e5d1217376b5834c21a10f79 sqlite-utils 2.22 sqlite-utils:2.22 sdist sqlite-utils-2.22.tar.gz   {"md5": "d73dead3e5d1217376b5834c21a10f79", "sha256": "db6d0465816a6bdf494d8b9a57db99478015d1694c4e9fa38cb11a8ec9fd1f3d"} 0 source   94726 2020-10-16T19:34:09 2020-10-16T19:34:09.118584Z https://files.pythonhosted.org/packages/17/ab/81a0685c4314f1f04c81a894b51630619249bcf99e15040691d1d6f9e9f1/sqlite-utils-2.22.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]);