{
  "_id": "6aca4b66fe5cc25786e86c19",
  "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-10-10 14:08:37 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/a5aa99b03a4062bf0434cac2258667cda2c6c8ca5709f604e3f1464f29e71017",
  "_filesize": 145711,
  "_sha256": "a5aa99b03a4062bf0434cac2258667cda2c6c8ca5709f604e3f1464f29e71017",
  "_expires": "2027-01-18T14:27:48.000Z",
  "_created": "2026-10-10T14:08:37.000Z",
  "_published": "2026-10-10T14:27:50.215Z",
  "_buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/38058250831",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 114231655425,
      "time": 120,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11672565502"
    },
    {
      "job": 114231655434,
      "time": 112,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11672425695"
    },
    {
      "job": 114231655465,
      "time": 121,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11672777100"
    },
    {
      "job": 114231655463,
      "time": 80,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11672417522"
    },
    {
      "job": 114231100845,
      "time": 164,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11670944307"
    },
    {
      "job": 114231655489,
      "time": 89,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11672405681"
    },
    {
      "job": 114231655475,
      "time": 111,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11672206055"
    },
    {
      "job": 114231655499,
      "time": 69,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "11671143891"
    },
    {
      "job": 114231655472,
      "time": 75,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11671099036"
    }
  ],
  "_upstream": "https://github.com/cran/samadb",
  "_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
  },
  "_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": [],
  "_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": 276,
    "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/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-10-10T14:10:34.000Z",
      "distro": "resolute",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/b702eec69c4e1dab1a02254a08ba9d1a8959c268887aa108232bc1e9aad67268",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/38058250831"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.3.1",
      "date": "2026-10-10T14:10:26.000Z",
      "distro": "resolute",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/9500c8dd7b6fee8f40da1d9ef0ab6ae0bd92864139f63ff8b0a5796d38232954",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/38058250831"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.1",
      "date": "2026-10-10T14:26:54.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/eeea86ed831252390023b7d360b248b8b968a785639eb33fceab558f721c9ab8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/38058250831"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.3.1",
      "date": "2026-10-10T14:27:15.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/38e25f7c4ff89297d118afc6389acccae3ba8a309c429334d923ea762b404e5a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/38058250831"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.1",
      "date": "2026-10-10T14:10:22.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/eec45be104747f46dac8676b959067eaaad4b153bad82a8e2fa1c3ae96d310b4",
      "status": "success",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/38058250831"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.1",
      "date": "2026-10-10T14:09:47.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/d09b8883f6d7c5eafe3513b5ac97e1c303fc6bac02be51355d8334968270b45f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/38058250831"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.1",
      "date": "2026-10-10T14:09:40.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/9c348ac8ec8e1a42807187dce3b9551a38a9add6398d952321a2a078682c3b50",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/38058250831"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.3.1",
      "date": "2026-10-10T14:09:46.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "https://r2.ropensci.org/1bc30409c6461f0c5c00d2890fc270382e8b30abf401614beb5fdfa8bef94131",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/38058250831"
    }
  ]
}