{
  "_id": "6af1a9cc1c36d7c6403e3a78",
  "Package": "samadb",
  "Title": "South Africa Macroeconomic Database API",
  "Version": "0.3.1",
  "Authors@R": "person(\"Sebastian\", \"Krantz\", role = c(\"aut\", \"cre\"), \nemail = \"sebastian.krantz@graduateinstitute.ch\")",
  "Description": "An R API providing access to a relational database with\nmacroeconomic time series data for South Africa, obtained from\nthe South African Reserve Bank (SARB) and Statistics South\nAfrica (STATSSA), and updated on a weekly basis via the\nEconData <https://www.econdata.co.za/> platform and automated\nscraping of the SARB and STATSSA websites. The database is\nmaintained at the Department of Economics at Stellenbosch\nUniversity.",
  "BugReports": "https://github.com/Stellenbosch-Econometrics/SAMADB-Issues/issues",
  "License": "GPL-3",
  "Encoding": "UTF-8",
  "RoxygenNote": "7.2.3",
  "Config/testthat/edition": "3",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-11-09 11:05:44 UTC",
    "User": "root"
  },
  "Author": "Sebastian Krantz [aut, cre]",
  "Maintainer": "Sebastian Krantz <sebastian.krantz@graduateinstitute.ch>",
  "Config/pak/sysreqs": "libmysqlclient-dev zlib1g-dev",
  "Repository": "https://sebkrantz.r-universe.dev",
  "Date/Publication": "2025-08-19 11:00:02 UTC",
  "RemoteUrl": "https://github.com/cran/samadb",
  "RemoteRef": "HEAD",
  "RemoteSha": "a9da4840cd0a6281ffa570294960cd53aece41ff",
  "_user": "sebkrantz",
  "_type": "src",
  "_file": "samadb_0.3.1.tar.gz",
  "_fileid": "https://r2.ropensci.org/b3b13f6b345955d8ef8d3ec9a2ca8942c63c015e9bf9b4817a24692565037eac",
  "_filesize": 145828,
  "_sha256": "b3b13f6b345955d8ef8d3ec9a2ca8942c63c015e9bf9b4817a24692565037eac",
  "_expires": "2027-02-17T11:08:59.000Z",
  "_created": "2026-11-09T11:05:44.000Z",
  "_published": "2026-11-09T11:09:00.690Z",
  "_upstream": "https://github.com/cran/samadb",
  "_status": "success",
  "_maintainer": {
    "name": "Sebastian Krantz",
    "email": "sebastian.krantz@graduateinstitute.ch",
    "login": "sebkrantz",
    "mastodon": "@sebkrantz@fosstodon.org",
    "bluesky": "@sebkrantz.bsky.social",
    "description": "Economist and Software Engineer",
    "uuid": 48053842
  },
  "_jobs": [
    {
      "job": 129122870999,
      "time": 152,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13667804204"
    },
    {
      "job": 129122871071,
      "time": 113,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13668850320"
    },
    {
      "job": 129122871168,
      "time": 88,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13667314785"
    },
    {
      "job": 129122871094,
      "time": 88,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13666989466"
    },
    {
      "job": 129121361237,
      "time": 191,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13668770546"
    },
    {
      "job": 129122871070,
      "time": 83,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "13667338571"
    },
    {
      "job": 129122871027,
      "time": 68,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13667398192"
    },
    {
      "job": 129122871144,
      "time": 83,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13667468065"
    },
    {
      "job": 129122871034,
      "time": 98,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13668550961"
    }
  ],
  "_buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/42605763982",
  "_commit": {
    "id": "a9da4840cd0a6281ffa570294960cd53aece41ff",
    "author": "Sebastian Krantz <sebastian.krantz@graduateinstitute.ch>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 0.3.1\n",
    "time": 1755601202
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.3.0",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "RMySQL",
      "role": "Imports"
    },
    {
      "package": "writexl",
      "role": "Imports"
    },
    {
      "package": "data.table",
      "role": "Imports"
    },
    {
      "package": "collapse",
      "version": ">= 2.0.0",
      "role": "Imports"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    }
  ],
  "_owner": "cran",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [],
  "_tags": [],
  "_stars": 0,
  "_contributors": [
    {
      "user": "sebkrantz",
      "count": 3,
      "uuid": 48053842
    }
  ],
  "_userbio": {
    "uuid": 48053842,
    "type": "user",
    "name": "Sebastian Krantz",
    "followers": 368,
    "description": "Economist and Software Engineer"
  },
  "_downloads": {
    "count": 366,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/samadb"
  },
  "_devurl": "https://github.com/stellenbosch-econometrics/samadb-issues",
  "_searchresults": 2,
  "_rbuild": "4.6.2",
  "_assets": [
    "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/samadb.html"
  ],
  "_realowner": "sebkrantz",
  "_cranurl": false,
  "_releases": [
    {
      "version": "0.2.6",
      "date": "2023-05-15"
    },
    {
      "version": "0.3.0",
      "date": "2024-05-24"
    },
    {
      "version": "0.3.1",
      "date": "2025-08-19"
    }
  ],
  "_exports": [
    ".SAMADB_ID",
    ".SAMADB_T",
    "sm_as_date",
    "sm_data",
    "sm_datasets",
    "sm_datasources",
    "sm_expand_date",
    "sm_pivot_longer",
    "sm_pivot_wider",
    "sm_series",
    "sm_transpose",
    "sm_write_excel"
  ],
  "_help": [
    {
      "page": "samadb-package",
      "title": "South Africa Macroeconomic Database API",
      "topics": [
        "samadb-package",
        "samadb"
      ]
    },
    {
      "page": "dot-SAMADB_ID",
      "title": "Global Identifier Macros",
      "topics": [
        ".SAMADB_ID",
        ".SAMADB_T"
      ]
    },
    {
      "page": "sm_as_date",
      "title": "Coerce Vectors to Dates",
      "topics": [
        "sm_as_date"
      ]
    },
    {
      "page": "sm_data",
      "title": "Retrieve Data from the Database",
      "topics": [
        "sm_data"
      ]
    },
    {
      "page": "sm_datasets",
      "title": "Retrieve Datasets Table",
      "topics": [
        "sm_datasets"
      ]
    },
    {
      "page": "sm_datasources",
      "title": "Retrieve Data Sources Table",
      "topics": [
        "sm_datasources"
      ]
    },
    {
      "page": "sm_expand_date",
      "title": "Generate Temporal Identifiers from a Date Column",
      "topics": [
        "sm_expand_date"
      ]
    },
    {
      "page": "sm_pivot_longer",
      "title": "Reshape Column-Based Data to Long Format",
      "topics": [
        "sm_pivot_longer"
      ]
    },
    {
      "page": "sm_pivot_wider",
      "title": "Reshape Long API Data to Column-Based Format",
      "topics": [
        "sm_pivot_wider"
      ]
    },
    {
      "page": "sm_series",
      "title": "Retrieve Series Table",
      "topics": [
        "sm_series"
      ]
    },
    {
      "page": "sm_transpose",
      "title": "Transpose a Wide Dataset to a Row-Based Format",
      "topics": [
        "sm_transpose"
      ]
    },
    {
      "page": "sm_write_excel",
      "title": "Export Wide Data to Excel",
      "topics": [
        "sm_write_excel"
      ]
    }
  ],
  "_rundeps": [
    "collapse",
    "data.table",
    "DBI",
    "Rcpp",
    "RMySQL",
    "writexl"
  ],
  "_score": 1,
  "_indexed": true,
  "_nocasepkg": "samadb",
  "_universes": [
    "sebkrantz",
    "stellenbosch-econometrics"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.3.1",
      "date": "2026-11-09T11:08:10.000Z",
      "distro": "resolute",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/f633709bd26990a13eaffe85429065f66ec1b6a58ccc24d866c5e9ae50defc92",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/42605763982"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.3.1",
      "date": "2026-11-09T11:07:32.000Z",
      "distro": "resolute",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/cba40ea00f7e4de4a6357453637f7ff0e42cac0b1bc42e0247daee31355771a0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/42605763982"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.1",
      "date": "2026-11-09T11:07:10.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/d958a12b097f74da75e96231466203dc94df4c8a03a5dc93dd536107b059003a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/42605763982"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "0.3.1",
      "date": "2026-11-09T11:07:11.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/898804862169b3e80d816e9365c4da2de181936347bafbedc771b7c4655b1ea1",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/42605763982"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.1",
      "date": "2026-11-09T11:07:22.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/3d72381870ed69663ec36ad3b2ce78f0ce1ae32cc494110e8ca71e263f60f5d6",
      "status": "success",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/42605763982"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.1",
      "date": "2026-11-09T11:06:41.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/75e68ed058724e027fe85b7a60ffa7e0473741a2349451ef1de7baf044ec1e7d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/42605763982"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.1",
      "date": "2026-11-09T11:06:47.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/9ccee067a52e3ae10d258c8f0d8ee502bce42c9bb2b82589945a16de8ca761c0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/42605763982"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "0.3.1",
      "date": "2026-11-09T11:07:12.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/e187a719a7459e714a5b266abf173bd86af0a332d27ac8cdb37e6d0fad96fb33",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/42605763982"
    }
  ]
}