repodata_packages

Table actions

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timestamp (date)

Link repodata_id package index_json timestamp
2,conda-token-0.4.0-pyhd3eb1b0_0.conda 2 2 conda-token-0.4.0-pyhd3eb1b0_0.conda 
{
    "build": "pyhd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "conda >=4.3",
        "conda-content-trust",
        "packaging",
        "python"
    ],
    "license": "BSD-3-Clause",
    "license_family": "BSD",
    "md5": "92e52e52f3ff3785f721021639fb1ced",
    "name": "conda-token",
    "noarch": "python",
    "sha256": "4dad9d120276c2f1e3c5c52cb880ad026616cdd946def2a9a363bc80c0031ff3",
    "size": 13011,
    "subdir": "noarch",
    "timestamp": 1662660396740,
    "version": "0.4.0"
}
 2022-09-14 22:14:21
2,conda-token-0.4.0-pyhd3eb1b0_0.tar.bz2 2 2 conda-token-0.4.0-pyhd3eb1b0_0.tar.bz2 
{
    "build": "pyhd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "conda >=4.3",
        "conda-content-trust",
        "packaging",
        "python"
    ],
    "license": "BSD-3-Clause",
    "license_family": "BSD",
    "md5": "4c72bba48f8549d67b2b49390d5d7076",
    "name": "conda-token",
    "noarch": "python",
    "sha256": "1018fe618ff9cd6eb520f78fefa457cecd5f308c869b37fae94b8ed208e0e21a",
    "size": 12341,
    "subdir": "noarch",
    "timestamp": 1662660396740,
    "version": "0.4.0"
}
 2022-09-14 22:14:21
2,tzdata-2022c-h04d1e81_0.conda 2 2 tzdata-2022c-h04d1e81_0.conda 
{
    "build": "h04d1e81_0",
    "build_number": 0,
    "depends": [],
    "license": "CC-PDDC OR BSD-3-Clause",
    "license_family": "BSD",
    "md5": "c10549a6463dbd5320b8015772d572cd",
    "name": "tzdata",
    "noarch": "generic",
    "sha256": "84293399cafca896377f650da8ae241a6a8c2788c608a776524dd2ab0cb8ada3",
    "size": 109395,
    "subdir": "noarch",
    "timestamp": 1663021577488,
    "version": "2022c"
}
 2022-09-14 22:14:21
2,tzdata-2022c-h04d1e81_0.tar.bz2 2 2 tzdata-2022c-h04d1e81_0.tar.bz2 
{
    "build": "h04d1e81_0",
    "build_number": 0,
    "depends": [],
    "license": "CC-PDDC OR BSD-3-Clause",
    "license_family": "BSD",
    "md5": "db31ca17cf24e0f904166e56bd35d17a",
    "name": "tzdata",
    "noarch": "generic",
    "sha256": "cf48464e06519485eb9fd393bebf5d8a2408c347a2bea24d2f4f8fcdc4ebd84e",
    "size": 120235,
    "subdir": "noarch",
    "timestamp": 1663021577488,
    "version": "2022c"
}
 2022-09-14 22:14:21

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