pypi_releases

2 rows where version = "datasette-ics:0.5.2"

✎ 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
611db8fa1a8e0cebe5fa615f8bb52af8 datasette-ics 0.5.2 datasette-ics:0.5.2 sdist datasette-ics-0.5.2.tar.gz   {"md5": "611db8fa1a8e0cebe5fa615f8bb52af8", "sha256": "61ba2c939338526d2ef46add8cb3279748f478d9254981f36f8c7bd50b46f4e0"} 0 source   8327 2022-07-12T02:09:21 2022-07-12T02:09:21.937889Z https://files.pythonhosted.org/packages/bf/b1/2f08723d89563604348a12b0f5bc334115cc6d02ac08be541f81e62324df/datasette-ics-0.5.2.tar.gz 0  
d2cee0870b235a32e51f98984d6bed94 datasette-ics 0.5.2 datasette-ics:0.5.2 bdist_wheel datasette_ics-0.5.2-py3-none-any.whl   {"md5": "d2cee0870b235a32e51f98984d6bed94", "sha256": "2ca8f5927adf2255aaa1e750e3b17fe3cf6fc089841c578db42c37f9ae32471f"} 0 py3   8917 2022-07-12T02:09:20 2022-07-12T02:09:20.123221Z https://files.pythonhosted.org/packages/f7/16/34340fa1c33142bbdf6efa106a22cfed863cc93acf480c1377239f9bee2d/datasette_ics-0.5.2-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]);