pypi_releases

2 rows where version = "datasette-leaflet-geojson:0.7"

✎ 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
0219253b3134018bbe77bb9219cdf420 datasette-leaflet-geojson 0.7 datasette-leaflet-geojson:0.7 bdist_wheel datasette_leaflet_geojson-0.7-py3-none-any.whl   {"md5": "0219253b3134018bbe77bb9219cdf420", "sha256": "d921b45e2923e5dd897f8d4291b34842356eb1d4c4f86f0725466474a8e6c902"} 0 py3   5062 2021-01-20T20:22:21 2021-01-20T20:22:21.470804Z https://files.pythonhosted.org/packages/0a/e3/d97b5a1cd23051eab3b593b9b4712b23995802a03d9443c6143845f07aa4/datasette_leaflet_geojson-0.7-py3-none-any.whl 0  
6836c0cb233e42f9c62e4875cff0992b datasette-leaflet-geojson 0.7 datasette-leaflet-geojson:0.7 sdist datasette-leaflet-geojson-0.7.tar.gz   {"md5": "6836c0cb233e42f9c62e4875cff0992b", "sha256": "3cc0910b66e37b547c235a595b3239c51d607fb1a452438a9850df9a1c403f36"} 0 source   4395 2021-01-20T20:22:22 2021-01-20T20:22:22.553599Z https://files.pythonhosted.org/packages/be/a4/fb47840eba21967757190ba1fc71084dabbb05b288ce2f852e8a5503f604/datasette-leaflet-geojson-0.7.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]);