repodata_packages

Table actions

8 rows where repodata_id = 2 and "timestamp" is on date 2023-03-08

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timestamp (date)

Link repodata_id package index_json timestamp
2,flask-1.1.4-pyhd3eb1b0_0.conda 2 2 flask-1.1.4-pyhd3eb1b0_0.conda 
{
    "build": "pyhd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "click >=5.1,<8.0",
        "itsdangerous >=0.24,<2.0",
        "jinja2 >=2.10.1,<3.0",
        "python >=3.5",
        "werkzeug >=0.15,<2.0"
    ],
    "license": "BSD-3-Clause",
    "license_family": "BSD",
    "md5": "9486688c175191fe9f085862d298374c",
    "name": "flask",
    "noarch": "python",
    "sha256": "565e910b20f9eddc2fa444105df74195b4a1bcff4f9a67b928fffe9562e7d8d7",
    "size": 82085,
    "subdir": "noarch",
    "timestamp": 1676477105125,
    "version": "1.1.4"
}
 2023-03-08 22:07:03
2,flask-1.1.4-pyhd3eb1b0_0.tar.bz2 2 2 flask-1.1.4-pyhd3eb1b0_0.tar.bz2 
{
    "build": "pyhd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "click >=5.1,<8.0",
        "itsdangerous >=0.24,<2.0",
        "jinja2 >=2.10.1,<3.0",
        "python >=3.5",
        "werkzeug >=0.15,<2.0"
    ],
    "license": "BSD-3-Clause",
    "license_family": "BSD",
    "md5": "6fca11900eaea16cb41933e9a27d2d58",
    "name": "flask",
    "noarch": "python",
    "sha256": "2575f43573364c6d0ff17f2f8fdfe745cc9b5d188f7e69546932399b53365904",
    "size": 72334,
    "subdir": "noarch",
    "timestamp": 1676477105125,
    "version": "1.1.4"
}
 2023-03-08 22:07:03
2,greyskull-2.2.2-hd3eb1b0_0.conda 2 2 greyskull-2.2.2-hd3eb1b0_0.conda 
{
    "build": "hd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "grayskull >=2.2.2,<2.2.3.0a0"
    ],
    "license": "Apache-2.0",
    "license_family": "Apache",
    "md5": "c0be01ca3813e71e4f57ac00870c9cd5",
    "name": "greyskull",
    "noarch": "generic",
    "sha256": "045f7f88aa046b87265f5c334fb59c5eca22fcc9b0760a4476c5e362311ba8af",
    "size": 8255,
    "subdir": "noarch",
    "timestamp": 1677053931342,
    "version": "2.2.2"
}
 2023-03-08 22:07:03
2,greyskull-2.2.2-hd3eb1b0_0.tar.bz2 2 2 greyskull-2.2.2-hd3eb1b0_0.tar.bz2 
{
    "build": "hd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "grayskull >=2.2.2,<2.2.3.0a0"
    ],
    "license": "Apache-2.0",
    "license_family": "Apache",
    "md5": "9d067fdeb035b28b5c32ee4e20335e8d",
    "name": "greyskull",
    "noarch": "generic",
    "sha256": "d471f3f1eb35d773e0627e430e2993c4e4860be9433bca9b33c54f4ae1131a8f",
    "size": 7577,
    "subdir": "noarch",
    "timestamp": 1677053931342,
    "version": "2.2.2"
}
 2023-03-08 22:07:03
2,mpl_sample_data-3.7.0-pyhd3eb1b0_0.conda 2 2 mpl_sample_data-3.7.0-pyhd3eb1b0_0.conda 
{
    "build": "pyhd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "matplotlib-base >=3.7.0,<3.8.0a0",
        "python"
    ],
    "license": "LicenseRef-PSF-based",
    "license_family": "PSF",
    "md5": "f8aa50896a9367973f77e11ab4f104a1",
    "name": "mpl_sample_data",
    "noarch": "python",
    "sha256": "53d8320f772ced2cb3279eb512c663b071458efcf47e8ecddf980b04a4163efd",
    "size": 445404,
    "subdir": "noarch",
    "timestamp": 1677674642194,
    "version": "3.7.0"
}
 2023-03-08 22:07:03
2,mpl_sample_data-3.7.0-pyhd3eb1b0_0.tar.bz2 2 2 mpl_sample_data-3.7.0-pyhd3eb1b0_0.tar.bz2 
{
    "build": "pyhd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "matplotlib-base >=3.7.0,<3.8.0a0",
        "python"
    ],
    "license": "LicenseRef-PSF-based",
    "license_family": "PSF",
    "md5": "e09965fcbe88534de872f5bf412c0602",
    "name": "mpl_sample_data",
    "noarch": "python",
    "sha256": "ad1db80a101d9d3b13d19be951fade09913f7d92ebd7f2bc0875a23646a9531e",
    "size": 442357,
    "subdir": "noarch",
    "timestamp": 1677674642194,
    "version": "3.7.0"
}
 2023-03-08 22:07:03
2,slack_sdk-3.19.5-pyhd3eb1b0_0.conda 2 2 slack_sdk-3.19.5-pyhd3eb1b0_0.conda 
{
    "build": "pyhd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "python",
        "slack-sdk 3.19.5 py38h06a4308_0"
    ],
    "license": "MIT",
    "license_family": "MIT",
    "md5": "5a0beb06e9aba1155f0245e4b7d8f2f7",
    "name": "slack_sdk",
    "noarch": "python",
    "sha256": "8a1b7eeb0e2b6fceef418ab84c0a8d88fe7c54d2c3edb6110ea04a54c9018410",
    "size": 5029,
    "subdir": "noarch",
    "timestamp": 1675353437796,
    "version": "3.19.5"
}
 2023-03-08 22:07:03
2,slack_sdk-3.19.5-pyhd3eb1b0_0.tar.bz2 2 2 slack_sdk-3.19.5-pyhd3eb1b0_0.tar.bz2 
{
    "build": "pyhd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "python",
        "slack-sdk 3.19.5 py38h06a4308_0"
    ],
    "license": "MIT",
    "license_family": "MIT",
    "md5": "ed0f0901fd579f14d6a138178a0fb422",
    "name": "slack_sdk",
    "noarch": "python",
    "sha256": "ed31f1391ef43f33a758ce1958b4016a9f9a2bdc2d9f64299a3cc21e0666f698",
    "size": 4519,
    "subdir": "noarch",
    "timestamp": 1675353437796,
    "version": "3.19.5"
}
 2023-03-08 22:07:03

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE repodata_packages
        (repodata_id INTEGER NOT NULL,
        package TEXT NOT NULL,
        index_json TEXT NOT NULL,
        timestamp TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,
        PRIMARY KEY (repodata_id, package),
        FOREIGN KEY (repodata_id) REFERENCES repodata(id));