{
  "_id": "6ac64546f511ae58c09a9377",
  "Package": "acdcquery",
  "Title": "Query the Attentional Control Data Collection or the Truth\nEffect Database",
  "Version": "1.2.4",
  "Authors@R": "c(\nperson(given = \"Sven\", family = \"Lesche\", email = \"sven.lesche@psychologie.uni-heidelberg.de\", role = c(\"aut\", \"cre\", \"cph\")),\nperson(given = \"Julia M.\", family = \"Haaf\", email = \"j.m.haaf@uva.nl\", role = c(\"ctb\", \"ths\")),\nperson(given = \"Madlen\", family = \"Hoffstadt\", email = \"madlenfeehoffstadt@gmail.com\", role = c(\"ctb\"))\n)",
  "Description": "Interact with the Attentional Control Data Collection\n(ACDC) or the Truth Effect Database (TED). Download the\ndatabases using download_acdc() or download_ted(), connect to\nthe database via connect_to_db(), set filter arguments via\nadd_argument() and query the database via query_db().",
  "License": "GPL (>= 3)",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.2",
  "URL": "https://github.com/SLesche/acdc-query",
  "BugReports": "https://github.com/SLesche/acdc-query/issues",
  "Config/pak/sysreqs": "libssl-dev",
  "Repository": "https://slesche.r-universe.dev",
  "Date/Publication": "2026-10-05 12:45:43 UTC",
  "RemoteUrl": "https://github.com/slesche/acdc-query",
  "RemoteRef": "HEAD",
  "RemoteSha": "1bc9b7a1288f2e000988c3df8a9e272222ddad7e",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-07 10:35:28 UTC",
    "User": "root"
  },
  "Author": "Sven Lesche [aut, cre, cph],\nJulia M. Haaf [ctb, ths],\nMadlen Hoffstadt [ctb]",
  "Maintainer": "Sven Lesche <sven.lesche@psychologie.uni-heidelberg.de>",
  "_user": "slesche",
  "_type": "src",
  "_file": "acdcquery_1.2.4.tar.gz",
  "_fileid": "https://r2.ropensci.org/0d791d388ea04eec6a945d8d790e607edde6c592e5050e45b50934db398ba5c2",
  "_filesize": 147157,
  "_sha256": "0d791d388ea04eec6a945d8d790e607edde6c592e5050e45b50934db398ba5c2",
  "_expires": "2027-01-15T13:12:36.000Z",
  "_created": "2026-10-07T10:35:28.000Z",
  "_published": "2026-10-07T13:12:38.087Z",
  "_buildurl": "https://github.com/r-universe/slesche/actions/runs/37608098347",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 112749550252,
      "time": 106,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11476096170"
    },
    {
      "job": 112749550282,
      "time": 110,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11476680160"
    },
    {
      "job": 112749550279,
      "time": 158,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11484357074"
    },
    {
      "job": 112749550259,
      "time": 164,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11483838768"
    },
    {
      "job": 112748589118,
      "time": 154,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11475608610"
    },
    {
      "job": 112749550187,
      "time": 82,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11476255825"
    },
    {
      "job": 112749550366,
      "time": 71,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11475861448"
    },
    {
      "job": 112749550361,
      "time": 69,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11475921290"
    },
    {
      "job": 112749550274,
      "time": 71,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11476675072"
    }
  ],
  "_upstream": "https://github.com/slesche/acdc-query",
  "_commit": {
    "id": "1bc9b7a1288f2e000988c3df8a9e272222ddad7e",
    "author": "Sven Lesche <113923517+SLesche@users.noreply.github.com>",
    "committer": "Sven Lesche <113923517+SLesche@users.noreply.github.com>",
    "message": "Update CRAN-SUBMISSION\n",
    "time": 1791204343
  },
  "_maintainer": {
    "name": "Sven Lesche",
    "email": "sven.lesche@psychologie.uni-heidelberg.de"
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "RSQLite",
      "role": "Imports"
    },
    {
      "package": "httr",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "digest",
      "role": "Imports"
    }
  ],
  "_owner": "slesche",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-48",
      "n": 2
    },
    {
      "week": "2025-49",
      "n": 1
    },
    {
      "week": "2026-08",
      "n": 18
    },
    {
      "week": "2026-41",
      "n": 5
    }
  ],
  "_tags": [
    {
      "name": "v1.1.1",
      "date": "2025-11-28"
    }
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "slesche",
      "count": 141,
      "uuid": 113923517
    }
  ],
  "_userbio": {
    "uuid": 113923517,
    "type": "user",
    "name": "Sven Lesche",
    "followers": 3,
    "description": "PhD Candidate | Psychology | Heidelberg University"
  },
  "_downloads": {
    "count": 478,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/acdcquery"
  },
  "_devurl": "https://github.com/slesche/acdc-query",
  "_searchresults": 31,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/acdcquery.html",
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md"
  ],
  "_homeurl": "https://github.com/slesche/acdc-query",
  "_realowner": "slesche",
  "_cranurl": true,
  "_releases": [
    {
      "version": "1.0.1",
      "date": "2023-10-20"
    },
    {
      "version": "1.1.0",
      "date": "2025-08-01"
    },
    {
      "version": "1.1.1",
      "date": "2025-11-30"
    },
    {
      "version": "1.2.1",
      "date": "2026-02-18"
    },
    {
      "version": "1.2.2",
      "date": "2026-02-18"
    },
    {
      "version": "1.2.3",
      "date": "2026-02-19"
    },
    {
      "version": "1.2.4",
      "date": "2026-10-05"
    }
  ],
  "_exports": [
    "add_argument",
    "check_acdc",
    "check_ted",
    "connect_to_db",
    "download_acdc",
    "download_ted",
    "query_db",
    "update_acdc",
    "update_ted"
  ],
  "_help": [
    {
      "page": "add_argument",
      "title": "Add a filter argument to a list",
      "topics": [
        "add_argument"
      ]
    },
    {
      "page": "add_join_paths_to_query",
      "title": "Add Join Paths to Query",
      "topics": [
        "add_join_paths_to_query"
      ]
    },
    {
      "page": "check_acdc",
      "title": "Check local ACDC database against GitHub release",
      "topics": [
        "check_acdc"
      ]
    },
    {
      "page": "check_operator",
      "title": "Check validity of operator and values",
      "topics": [
        "check_operator"
      ]
    },
    {
      "page": "check_ted",
      "title": "Check local TED database against GitHub release",
      "topics": [
        "check_ted"
      ]
    },
    {
      "page": "compare_sqlite_to_release",
      "title": "Compare local SQLite database to GitHub release hash",
      "topics": [
        "compare_sqlite_to_release"
      ]
    },
    {
      "page": "connect_to_db",
      "title": "Connect to an SQLite database",
      "topics": [
        "connect_to_db"
      ]
    },
    {
      "page": "create_sqlite_hash_file",
      "title": "Create SHA256 hash file for a SQLite database",
      "topics": [
        "create_sqlite_hash_file"
      ]
    },
    {
      "page": "discover_id_introduction_steps",
      "title": "Discover ID Introduction Steps",
      "topics": [
        "discover_id_introduction_steps"
      ]
    },
    {
      "page": "download_acdc",
      "title": "Download ACDC database from GitHub release",
      "topics": [
        "download_acdc"
      ]
    },
    {
      "page": "download_sqlite_release",
      "title": "Download SQLite file from GitHub release",
      "topics": [
        "download_sqlite_release"
      ]
    },
    {
      "page": "download_ted",
      "title": "Download TED database from GitHub release",
      "topics": [
        "download_ted"
      ]
    },
    {
      "page": "find_relevant_tables",
      "title": "Find relevant tables based on column name",
      "topics": [
        "find_relevant_tables"
      ]
    },
    {
      "page": "get_argument_sequence",
      "title": "Get argument sequence based on argument relation",
      "topics": [
        "get_argument_sequence"
      ]
    },
    {
      "page": "get_column_names",
      "title": "Get column names from database tables",
      "topics": [
        "get_column_names"
      ]
    },
    {
      "page": "get_filter_statement",
      "title": "Get Filter Statement",
      "topics": [
        "get_filter_statement"
      ]
    },
    {
      "page": "make_valid_sql",
      "title": "Create a valid SQL statement based on variable, operator, and values",
      "topics": [
        "make_valid_sql"
      ]
    },
    {
      "page": "precompute_table_join_paths",
      "title": "Precompute Table Join Paths",
      "topics": [
        "precompute_table_join_paths"
      ]
    },
    {
      "page": "query_db",
      "title": "Query Database",
      "topics": [
        "query_db"
      ]
    },
    {
      "page": "return_id_name_from_table",
      "title": "Return ID column name from table name",
      "topics": [
        "return_id_name_from_table"
      ]
    },
    {
      "page": "return_table_name_from_id",
      "title": "Return table name from ID column name",
      "topics": [
        "return_table_name_from_id"
      ]
    },
    {
      "page": "update_acdc",
      "title": "Update local ACDC database from GitHub release",
      "topics": [
        "update_acdc"
      ]
    },
    {
      "page": "update_database",
      "title": "Update a local SQLite database from a GitHub release",
      "topics": [
        "update_database"
      ]
    },
    {
      "page": "update_ted",
      "title": "Update local TED database from GitHub release",
      "topics": [
        "update_ted"
      ]
    }
  ],
  "_readme": "https://github.com/slesche/acdc-query/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "cpp11",
    "curl",
    "DBI",
    "digest",
    "fastmap",
    "glue",
    "httr",
    "jsonlite",
    "lifecycle",
    "memoise",
    "mime",
    "openssl",
    "pkgconfig",
    "R6",
    "rlang",
    "RSQLite",
    "sys",
    "vctrs"
  ],
  "_score": 3.792391689498254,
  "_indexed": true,
  "_nocasepkg": "acdcquery",
  "_universes": [
    "slesche"
  ],
  "_previous": "1.2.3",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.2.4",
      "date": "2026-10-07T10:37:15.000Z",
      "distro": "resolute",
      "commit": "1bc9b7a1288f2e000988c3df8a9e272222ddad7e",
      "fileid": "https://r2.ropensci.org/202fa51f22ec3d82c218e34ca5134f90520fdc781ef82ea716749e2791011cbf",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/slesche/actions/runs/37608098347"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.2.4",
      "date": "2026-10-07T10:37:17.000Z",
      "distro": "resolute",
      "commit": "1bc9b7a1288f2e000988c3df8a9e272222ddad7e",
      "fileid": "https://r2.ropensci.org/12de04b5f404f95e5bb5f2bd721f037782cd8599769b42467616f7ec94b7829d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/slesche/actions/runs/37608098347"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.2.4",
      "date": "2026-10-07T13:08:04.000Z",
      "commit": "1bc9b7a1288f2e000988c3df8a9e272222ddad7e",
      "fileid": "https://r2.ropensci.org/0ca9a81dcdf6247b8fedd8f0a6672425e067f7bd5f1ef85356c581587730a153",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/slesche/actions/runs/37608098347"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.2.4",
      "date": "2026-10-07T13:11:27.000Z",
      "commit": "1bc9b7a1288f2e000988c3df8a9e272222ddad7e",
      "fileid": "https://r2.ropensci.org/6d58351a03c4fbee405cbfe2713ad98c77fdb861605dc53f48b121d72a2d0f2a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/slesche/actions/runs/37608098347"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.2.4",
      "date": "2026-10-07T10:37:08.000Z",
      "commit": "1bc9b7a1288f2e000988c3df8a9e272222ddad7e",
      "fileid": "https://r2.ropensci.org/f9412c3d3d014e7f2086238c5bc65c52d252f8f224603a091a30dcf32e8dfd09",
      "status": "success",
      "buildurl": "https://github.com/r-universe/slesche/actions/runs/37608098347"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.2.4",
      "date": "2026-10-07T10:36:32.000Z",
      "commit": "1bc9b7a1288f2e000988c3df8a9e272222ddad7e",
      "fileid": "https://r2.ropensci.org/2ee705cffb12833a812fd0166a181033ed3bd1a6999ae5ca46d0e73dc67421db",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/slesche/actions/runs/37608098347"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.2.4",
      "date": "2026-10-07T10:36:36.000Z",
      "commit": "1bc9b7a1288f2e000988c3df8a9e272222ddad7e",
      "fileid": "https://r2.ropensci.org/c07bd68cf73d48956a65cc03aa0574d04acd5169bf02cbd753fe7f007921b58a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/slesche/actions/runs/37608098347"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.2.4",
      "date": "2026-10-07T10:36:35.000Z",
      "commit": "1bc9b7a1288f2e000988c3df8a9e272222ddad7e",
      "fileid": "https://r2.ropensci.org/3fbdf1ace465dc989ae05c091ac7b284114fad28a2e269dccac90d271d79d520",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/slesche/actions/runs/37608098347"
    }
  ]
}