{
"_id": "6a495131f6c47c441949b071",
"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 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-07-04 18:22:54 UTC",
"User": "root"
},
"Author": "Sebastian Krantz [aut, cre]",
"Maintainer": "Sebastian Krantz ",
"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/ad5e572ed871c5768ee40753cad31e00359b58dd953840ff9e6ebd18f3f49511",
"_filesize": 147712,
"_sha256": "ad5e572ed871c5768ee40753cad31e00359b58dd953840ff9e6ebd18f3f49511",
"_expires": "2026-10-12T18:30:07.000Z",
"_created": "2026-07-04T18:22:54.000Z",
"_published": "2026-07-04T18:30:09.449Z",
"_jobs": [
{
"job": 85155994031,
"time": 401,
"config": "linux-devel-x86_64",
"r": "4.7.0",
"check": "OK",
"artifact": "8084312755"
},
{
"job": 85155994049,
"time": 122,
"config": "linux-release-x86_64",
"r": "4.6.1",
"check": "OK",
"artifact": "8084276519"
},
{
"job": 85155994045,
"time": 81,
"config": "macos-oldrel-arm64",
"r": "4.5.3",
"check": "OK",
"artifact": "8084271048"
},
{
"job": 85155994065,
"time": 82,
"config": "macos-release-arm64",
"r": "4.6.1",
"check": "OK",
"artifact": "8084271222"
},
{
"job": 85155816910,
"time": 144,
"config": "source",
"r": "4.6.1",
"check": "OK",
"artifact": "8084260789"
},
{
"job": 85155994041,
"time": 131,
"config": "wasm-release",
"r": "4.6.0",
"check": "OK",
"artifact": "8084277513"
},
{
"job": 85155994073,
"time": 77,
"config": "windows-devel",
"r": "4.7.0",
"check": "OK",
"artifact": "8084270677"
},
{
"job": 85155994072,
"time": 80,
"config": "windows-oldrel",
"r": "4.5.3",
"check": "OK",
"artifact": "8084270952"
},
{
"job": 85155994066,
"time": 80,
"config": "windows-release",
"r": "4.6.1",
"check": "OK",
"artifact": "8084271275"
}
],
"_host": "GitHub-Actions",
"_buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/28715420341",
"_status": "success",
"_upstream": "https://github.com/cran/samadb",
"_commit": {
"id": "a9da4840cd0a6281ffa570294960cd53aece41ff",
"author": "Sebastian Krantz ",
"committer": "cran-robot ",
"message": "version 0.3.1\n",
"time": 1755601202
},
"_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
},
"_distro": "resolute",
"_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": [
{
"week": "2025-34",
"n": 1
}
],
"_tags": [
{
"name": "0.3.1",
"date": "2025-08-19"
}
],
"_stars": 0,
"_contributors": [
{
"user": "sebkrantz",
"count": 3,
"uuid": 48053842
}
],
"_userbio": {
"uuid": 48053842,
"type": "user",
"name": "Sebastian Krantz",
"followers": 355,
"description": "Economist and Software Engineer"
},
"_downloads": {
"count": 297,
"source": "https://cranlogs.r-pkg.org/downloads/total/last-month/samadb"
},
"_devurl": "https://github.com/stellenbosch-econometrics/samadb-issues",
"_searchresults": 2,
"_rbuild": "4.6.1",
"_assets": [
"extra/citation.cff",
"extra/citation.html",
"extra/citation.json",
"extra/citation.txt",
"extra/contents.json",
"extra/NEWS.html",
"extra/NEWS.txt",
"extra/samadb.html",
"manual.pdf"
],
"_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-07-04T18:25:03.000Z",
"distro": "resolute",
"commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
"fileid": "https://r2.ropensci.org/1c4c87d398e25b19054342647bd2cfcec0ce7e7c4dd798cdc3892bab7cc100e6",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/28715420341"
},
{
"r": "4.6.1",
"os": "linux",
"version": "0.3.1",
"date": "2026-07-04T18:24:55.000Z",
"distro": "resolute",
"commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
"fileid": "https://r2.ropensci.org/aded07b0a6a1c7386abca9bad9e0a9d1c950ef0bf9bad2cf468d2d30012d0c2c",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/28715420341"
},
{
"r": "4.5.3",
"os": "mac",
"version": "0.3.1",
"date": "2026-07-04T18:24:18.000Z",
"commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
"fileid": "https://r2.ropensci.org/ac927583a43d4c87cdbd069118fcb07e7828e0bce6411339c764002565e87eae",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/28715420341"
},
{
"r": "4.6.1",
"os": "mac",
"version": "0.3.1",
"date": "2026-07-04T18:24:19.000Z",
"commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
"fileid": "https://r2.ropensci.org/c58c29962dceb3257be38240e661968eababa3610a551134a6329fe9b862208f",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/28715420341"
},
{
"r": "4.6.0",
"os": "wasm",
"version": "0.3.1",
"date": "2026-07-04T18:25:20.000Z",
"commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
"fileid": "https://r2.ropensci.org/9d963b041e91e4e17b4b8c8c4c19e41ce702de5c86358e811cf071f68172671d",
"status": "success",
"buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/28715420341"
},
{
"r": "4.7.0",
"os": "win",
"version": "0.3.1",
"date": "2026-07-04T18:24:10.000Z",
"commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
"fileid": "https://r2.ropensci.org/1d83bf88295c6fcde8fd9790ff1abe887a5323c774b4f8c2d540a5f9c2a369d8",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/28715420341"
},
{
"r": "4.5.3",
"os": "win",
"version": "0.3.1",
"date": "2026-07-04T18:24:07.000Z",
"commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
"fileid": "https://r2.ropensci.org/d1f23a7a811278d36e820178c8fa7a315033be873e8a104484538b4ff9f81501",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/28715420341"
},
{
"r": "4.6.1",
"os": "win",
"version": "0.3.1",
"date": "2026-07-04T18:24:09.000Z",
"commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
"fileid": "https://r2.ropensci.org/88c48020d08e6ae40f519c371e1acd622214efa40fb71f2aaaa7627d22b7d00f",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/28715420341"
}
]
}