repodata_packages

Table actions

2 rows where repodata_id = 2 and "timestamp" is on date 2022-12-09

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timestamp (date)

Link repodata_id package index_json timestamp
2,mpl_sample_data-3.6.2-pyhd3eb1b0_0.conda 2 2 mpl_sample_data-3.6.2-pyhd3eb1b0_0.conda 
{
    "build": "pyhd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "matplotlib-base >=3.6.2,<3.7.0a0",
        "python"
    ],
    "license": "LicenseRef-PSF-based",
    "license_family": "PSF",
    "md5": "4022132ca1ff4a16e1db0c63719ef8f3",
    "name": "mpl_sample_data",
    "noarch": "python",
    "sha256": "55fa6d42423e0d6ff9118c76636c6191704184a1949d2c57f1123bf2121cb245",
    "size": 444466,
    "subdir": "noarch",
    "timestamp": 1670466432946,
    "version": "3.6.2"
}
 2022-12-09 21:46:33
2,mpl_sample_data-3.6.2-pyhd3eb1b0_0.tar.bz2 2 2 mpl_sample_data-3.6.2-pyhd3eb1b0_0.tar.bz2 
{
    "build": "pyhd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "matplotlib-base >=3.6.2,<3.7.0a0",
        "python"
    ],
    "license": "LicenseRef-PSF-based",
    "license_family": "PSF",
    "md5": "f1303beefe8bad00f7a60eae126c55f9",
    "name": "mpl_sample_data",
    "noarch": "python",
    "sha256": "6e0739f612a801895400765fc6aeb991aa1cb983d62d573ec5184ea871d048aa",
    "size": 441799,
    "subdir": "noarch",
    "timestamp": 1670466432946,
    "version": "3.6.2"
}
 2022-12-09 21:46:33

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));