{
  "_id": "6af71771b90b31e79afd81e7",
  "Package": "virta",
  "Type": "Package",
  "Title": "Survo Data Virtual Tables for RSQLite",
  "Version": "0.9.7",
  "Date": "2026-07-07",
  "Authors@R": "person(given = \"Reijo\",\nfamily = \"Sund\",\nrole = c(\"aut\", \"cre\"),\nemail = \"reijo.sund@uef.fi\")",
  "Description": "SQLite's loadable extension feature to provide virtual\ntable access to SVO-files.",
  "License": "Artistic-2.0",
  "LazyLoad": "yes",
  "Additional_repositories": "https://rsund.r-universe.dev, https://survo.fi",
  "NeedsCompilation": "yes",
  "Repository": "https://rsund.r-universe.dev",
  "Date/Publication": "2026-10-14 15:14:34 UTC",
  "RemoteUrl": "https://github.com/rsund/survor",
  "RemoteRef": "HEAD",
  "RemoteSha": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
  "RemoteSubdir": "pkg/virta",
  "Packaged": {
    "Date": "2026-11-13 13:36:33 UTC",
    "User": "root"
  },
  "Author": "Reijo Sund [aut, cre]",
  "Maintainer": "Reijo Sund <reijo.sund@uef.fi>",
  "_user": "rsund",
  "_type": "src",
  "_file": "virta_0.9.7.tar.gz",
  "_fileid": "https://r2.ropensci.org/116010bbf1133f8d1e28a4ba943e9542b994c349f9c72abc0c0ec49d017693dd",
  "_filesize": 257525,
  "_sha256": "116010bbf1133f8d1e28a4ba943e9542b994c349f9c72abc0c0ec49d017693dd",
  "_expires": "2027-02-21T13:58:07.000Z",
  "_created": "2026-11-13T13:36:33.000Z",
  "_published": "2026-11-13T13:58:09.268Z",
  "_upstream": "https://github.com/rsund/survor",
  "_status": "success",
  "_maintainer": {
    "name": "Reijo Sund",
    "email": "reijo.sund@uef.fi",
    "login": "rsund",
    "description": "",
    "uuid": 7668641
  },
  "_jobs": [
    {
      "job": 131918293607,
      "time": 88,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "14043031865"
    },
    {
      "job": 131918293598,
      "time": 103,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "14043836603"
    },
    {
      "job": 131918293559,
      "time": 79,
      "config": "linux-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14042961701"
    },
    {
      "job": 131918293560,
      "time": 94,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14043771465"
    },
    {
      "job": 131918293557,
      "time": 107,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "14043254989"
    },
    {
      "job": 131918293487,
      "time": 316,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "14042384900"
    },
    {
      "job": 131918293474,
      "time": 180,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14043604489"
    },
    {
      "job": 131918293541,
      "time": 306,
      "config": "macos-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14042944318"
    },
    {
      "job": 131916881962,
      "time": 167,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14043061625"
    },
    {
      "job": 131918293372,
      "time": 98,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "14043781574"
    },
    {
      "job": 131918293532,
      "time": 334,
      "config": "windows-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "14041998703"
    },
    {
      "job": 131918293526,
      "time": 204,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "14043891873"
    },
    {
      "job": 131918293495,
      "time": 198,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "14043901880"
    },
    {
      "job": 131918293525,
      "time": 334,
      "config": "windows-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14043497258"
    },
    {
      "job": 131918293516,
      "time": 200,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14043751972"
    }
  ],
  "_buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614",
  "_commit": {
    "id": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
    "author": "Reijo Sund <reijo.sund@uef.fi>",
    "committer": "Reijo Sund <reijo.sund@uef.fi>",
    "message": "Register missing functions for .Call\n",
    "time": 1791990874
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "RSQLite",
      "version": ">= 1.0",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "role": "Depends"
    },
    {
      "package": "muste",
      "version": ">= 0.5.36",
      "role": "Depends"
    },
    {
      "package": "muste",
      "role": "LinkingTo"
    }
  ],
  "_owner": "rsund",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-27",
      "n": 9
    },
    {
      "week": "2026-28",
      "n": 5
    },
    {
      "week": "2026-42",
      "n": 1
    }
  ],
  "_tags": [],
  "_stars": 3,
  "_contributors": [
    {
      "user": "rsund",
      "count": 416,
      "uuid": 7668641
    }
  ],
  "_userbio": {
    "uuid": 7668641,
    "type": "user",
    "name": "Reijo Sund",
    "followers": 2
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/virta"
  },
  "_devurl": "https://github.com/rsund/survor",
  "_searchresults": 0,
  "_rbuild": "4.6.2",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/readme.html",
    "extra/readme.md",
    "extra/virta.html"
  ],
  "_cranurl": false,
  "_exports": [
    "init_virtualtables",
    "virta.sql"
  ],
  "_help": [
    {
      "page": "init_virtualtables",
      "title": "Initialize SQLite extension virtual tables on a SQLite DB connection",
      "topics": [
        "init_virtualtables"
      ]
    },
    {
      "page": "virta",
      "title": "Survo virtual tables for RSQLite",
      "topics": [
        "virta"
      ]
    },
    {
      "page": "virta.sql",
      "title": "SQL queries from Muste (SVO)-files using virtual tables",
      "topics": [
        "virta.sql"
      ]
    }
  ],
  "_readme": "https://github.com/rsund/survor/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "cpp11",
    "DBI",
    "fastmap",
    "glue",
    "lifecycle",
    "memoise",
    "muste",
    "pkgconfig",
    "rlang",
    "RSQLite",
    "vctrs"
  ],
  "_score": 2.6532125137753435,
  "_indexed": true,
  "_nocasepkg": "virta",
  "_universes": [
    "rsund"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.9.7",
      "date": "2026-11-13T13:38:05.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/93cfd9b8475fd9697cd55660cfee85e28794bd29c09dbeaf04d99c40831bd9fb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.9.7",
      "date": "2026-11-13T13:38:20.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/20744a18b89c415a450631093be56bf6dfe9cfe4eca69cc284d8658fb9101c43",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.9.7",
      "date": "2026-11-13T13:37:59.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/3fddb933f5e1770049d4cf3a7969f2b895b5d8226b48338462ee6a9bc2a3082b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.9.7",
      "date": "2026-11-13T13:38:12.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/a9b529bad585459478cd6b077268855da22bf8cff514fadc3b152b063f682ca0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.9.7",
      "date": "2026-11-13T13:57:31.000Z",
      "arch": "aarch64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/44642bc3bd9f79369a47e96ce5b56b7faea72e80d0637a22dd5cdc0db1c80c1a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.9.7",
      "date": "2026-11-13T13:49:54.000Z",
      "arch": "x86_64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/bc8bf07c0ecf103764f0e00fa5b0c651e897c2629ca3ad8fef644da6539ac5fb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "0.9.7",
      "date": "2026-11-13T13:53:03.000Z",
      "arch": "aarch64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/099eb1bc8d642a5242d4fe00c5608a94eb1b4e1771c380859909c9f6897a21bc",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "0.9.7",
      "date": "2026-11-13T13:50:34.000Z",
      "arch": "x86_64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/c24a079e946eb26f2597957357dd6b84a0828d74de602b16081a14ac9c8955cd",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.9.7",
      "date": "2026-11-13T13:38:25.000Z",
      "arch": "emscripten",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/bcb75d6c29ab074c52e7423de210e3799952f8617065187a7506a283b8a878b2",
      "status": "success",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.9.7",
      "date": "2026-11-13T13:41:33.000Z",
      "arch": "aarch64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/95df2f7031676247a8c8d74ee6dfa21cee11a0d84a9899088ad3a8421bdd4b64",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.9.7",
      "date": "2026-11-13T13:38:31.000Z",
      "arch": "x86_64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/ad624773edfda55f228cf321d48614651a1685a256c958a6a066ebc74b34920a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.9.7",
      "date": "2026-11-13T13:38:52.000Z",
      "arch": "x86_64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/b8103e9620073363401ef49698887058d0ccb1f786412d11542cb12752126c2b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "0.9.7",
      "date": "2026-11-13T13:41:25.000Z",
      "arch": "aarch64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/4f125c30ab03fb8643dfa2d65d0bd6e3995c2f9aa09296e37464b23f3598a4c9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "0.9.7",
      "date": "2026-11-13T13:38:57.000Z",
      "arch": "x86_64",
      "commit": "b08376ed2a5818a51c01fa8328c489e90f781ab3",
      "fileid": "https://r2.ropensci.org/9b023c649d54e5b5e20863d4cdcef740b0a01aa04441359a4cdb85923a9f9c01",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/rsund/actions/runs/43434710614"
    }
  ]
}