repodata_packages

Table actions

6 rows where repodata_id = 2 and "timestamp" is on date 2023-08-31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timestamp (date)

Link repodata_id package index_json timestamp
2,coincbc-2.10.10-0_metapackage.conda 2 2 coincbc-2.10.10-0_metapackage.conda 
{
    "build": "0_metapackage",
    "build_number": 0,
    "depends": [
        "coin-or-cbc 2.10.10.*"
    ],
    "license": "EPL-2.0",
    "license_family": "OTHER",
    "md5": "06623edb2bea4f42679dfd95394c774a",
    "name": "coincbc",
    "noarch": "generic",
    "sha256": "7c22e8ea1d749a1a3fc9477fbd405654d0a36818f1915ad23353ab6293748a27",
    "size": 10383,
    "subdir": "noarch",
    "timestamp": 1690870808658,
    "version": "2.10.10"
}
 2023-08-31 17:07:10
2,coincbc-2.10.10-0_metapackage.tar.bz2 2 2 coincbc-2.10.10-0_metapackage.tar.bz2 
{
    "build": "0_metapackage",
    "build_number": 0,
    "depends": [
        "coin-or-cbc 2.10.10.*"
    ],
    "license": "EPL-2.0",
    "license_family": "OTHER",
    "md5": "f29491e876326310814061b1f4a8ff7d",
    "name": "coincbc",
    "noarch": "generic",
    "sha256": "bc1699fdb52337664776d3ae5d83a8fd89563a02da190eec359469245a2b13f9",
    "size": 9726,
    "subdir": "noarch",
    "timestamp": 1690870808658,
    "version": "2.10.10"
}
 2023-08-31 17:07:10
2,python-tzdata-2023.3-pyhd3eb1b0_0.conda 2 2 python-tzdata-2023.3-pyhd3eb1b0_0.conda 
{
    "build": "pyhd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "python"
    ],
    "license": "Apache-2.0",
    "license_family": "Apache",
    "md5": "479c037de0186d114b9911158427624e",
    "name": "python-tzdata",
    "noarch": "python",
    "sha256": "df49723e943a5a7b8bfe3b0f7463b39225aedba73f75d4cb4cb5a794c2a4755d",
    "size": 143832,
    "subdir": "noarch",
    "timestamp": 1690578151230,
    "version": "2023.3"
}
 2023-08-31 17:07:10
2,python-tzdata-2023.3-pyhd3eb1b0_0.tar.bz2 2 2 python-tzdata-2023.3-pyhd3eb1b0_0.tar.bz2 
{
    "build": "pyhd3eb1b0_0",
    "build_number": 0,
    "depends": [
        "python"
    ],
    "license": "Apache-2.0",
    "license_family": "Apache",
    "md5": "02caf3f47f1d06256068053297355740",
    "name": "python-tzdata",
    "noarch": "python",
    "sha256": "554ca80900e3c5604c50a3fb73b359046d5d6c495b25909f7dff7db86234d67a",
    "size": 152292,
    "subdir": "noarch",
    "timestamp": 1690578151230,
    "version": "2023.3"
}
 2023-08-31 17:07:10
2,twine-3.7.1-pyhd3eb1b0_1.conda 2 2 twine-3.7.1-pyhd3eb1b0_1.conda 
{
    "build": "pyhd3eb1b0_1",
    "build_number": 1,
    "depends": [
        "colorama >=0.4.3",
        "importlib_metadata >=3.6",
        "keyring >=15.1",
        "pkginfo >=1.8.1",
        "python >=3.6",
        "readme_renderer >=21.0",
        "requests >=2.20",
        "requests-toolbelt >=0.8.0,!=0.9.0",
        "rfc3986 >=1.4.0",
        "tqdm >=4.14"
    ],
    "license": "Apache-2.0",
    "license_family": "Apache",
    "md5": "d2abbf905cac09e541ecae53b3015af7",
    "name": "twine",
    "noarch": "python",
    "sha256": "ad955475d7a4f5799e3a8bb14562b5deb7a1fae86dbc9b4328f9b604b62a4e05",
    "size": 30283,
    "subdir": "noarch",
    "timestamp": 1690451594072,
    "version": "3.7.1"
}
 2023-08-31 17:07:10
2,twine-3.7.1-pyhd3eb1b0_1.tar.bz2 2 2 twine-3.7.1-pyhd3eb1b0_1.tar.bz2 
{
    "build": "pyhd3eb1b0_1",
    "build_number": 1,
    "depends": [
        "colorama >=0.4.3",
        "importlib_metadata >=3.6",
        "keyring >=15.1",
        "pkginfo >=1.8.1",
        "python >=3.6",
        "readme_renderer >=21.0",
        "requests >=2.20",
        "requests-toolbelt >=0.8.0,!=0.9.0",
        "rfc3986 >=1.4.0",
        "tqdm >=4.14"
    ],
    "license": "Apache-2.0",
    "license_family": "Apache",
    "md5": "5626fd4f968460a554e25cecd58faf8e",
    "name": "twine",
    "noarch": "python",
    "sha256": "f1b80158992b00d89b4113169d01a0c2b78419f9b9c6e16ef6ff0a7fa976eb59",
    "size": 30321,
    "subdir": "noarch",
    "timestamp": 1690451594072,
    "version": "3.7.1"
}
 2023-08-31 17:07:10

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