pypi_releases

2 rows where version = "geocode-sqlite:0.6.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
41d7a219ea19855ead2a6f3aaab58bf9 geocode-sqlite 0.6.1 geocode-sqlite:0.6.1 bdist_wheel geocode_sqlite-0.6.1-py3-none-any.whl   {"md5": "41d7a219ea19855ead2a6f3aaab58bf9", "sha256": "daf138a160ee31a08657b81470037547e004090f5f764fb23f7db0b2353891fb"} 0 py3   13639 2022-03-16T01:41:40 2022-03-16T01:41:40.120039Z https://files.pythonhosted.org/packages/ac/bc/1efde67a132a488ccae85324aff445536c97a2b381e97147b021eef4911c/geocode_sqlite-0.6.1-py3-none-any.whl 0  
83787f9a5c853c56236687b5420e5114 geocode-sqlite 0.6.1 geocode-sqlite:0.6.1 sdist geocode-sqlite-0.6.1.tar.gz   {"md5": "83787f9a5c853c56236687b5420e5114", "sha256": "a3c16716a9b76e63858c690c67f560421c81f97fd979de6106a00c7c9733a879"} 0 source   14721 2022-03-16T01:41:41 2022-03-16T01:41:41.126379Z https://files.pythonhosted.org/packages/3e/b0/b1d0ea586e268cda8345a3b9e0032dd21285709ba5bbc47d68d4f35eff11/geocode-sqlite-0.6.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]);