{
  "_id": "6a1d69221d7bb097a0a4eac4",
  "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-06-01 11:04:30 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",
  "MD5sum": "da817d9770e877ba82ef0c67feccd77a",
  "_user": "sebkrantz",
  "_type": "src",
  "_file": "samadb_0.3.1.tar.gz",
  "_fileid": "a9be41cb3d0a0ef30dfb73201115267934f54bfb81bfd5dc4b68752cf1699de9",
  "_filesize": 146737,
  "_sha256": "a9be41cb3d0a0ef30dfb73201115267934f54bfb81bfd5dc4b68752cf1699de9",
  "_created": "2026-06-01T11:04:30.000Z",
  "_published": "2026-06-01T11:12:34.671Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 78838800303,
      "time": 102,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7329845034"
    },
    {
      "job": 78838800319,
      "time": 118,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7329850013"
    },
    {
      "job": 78838800309,
      "time": 120,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7329888002"
    },
    {
      "job": 78838800299,
      "time": 81,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7329950280"
    },
    {
      "job": 78838374637,
      "time": 159,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7329812751"
    },
    {
      "job": 78838800296,
      "time": 102,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7329844737"
    },
    {
      "job": 78838800344,
      "time": 86,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7329839742"
    },
    {
      "job": 78838800335,
      "time": 72,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7329835750"
    },
    {
      "job": 78838800327,
      "time": 70,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7329835077"
    }
  ],
  "_buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26750891794",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_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
  },
  "_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",
    "description": "Economist and Software Engineer"
  },
  "_downloads": {
    "count": 201,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/samadb"
  },
  "_devurl": "https://github.com/stellenbosch-econometrics/samadb-issues",
  "_searchresults": 2,
  "_rbuild": "4.6.0",
  "_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-06-01T11:06:13.000Z",
      "distro": "noble",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "c0c615529fb5a432ee8d819e537d655813fc6af927b1c0b9970755cc0f502b0d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26750891794"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.3.1",
      "date": "2026-06-01T11:06:29.000Z",
      "distro": "noble",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "05f93a2bd8d2b80cbbe0c424e7cb7928cecd66581538795e3470a901ab15fa38",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26750891794"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.1",
      "date": "2026-06-01T11:08:29.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "cc927c4d3a056d77a274e04b22e706f861a68990185f6152e98cac3606409ab5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26750891794"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.3.1",
      "date": "2026-06-01T11:12:05.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "04e647c9f43bd99b88697036613133d34eceb6f302196f340874211b8ffc1a7a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26750891794"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.1",
      "date": "2026-06-01T11:06:28.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "f6f6ad91d7633a992d83768cf8faf6f2a3e81896c4c75902884aeee9c9db9bf7",
      "status": "success",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26750891794"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.1",
      "date": "2026-06-01T11:05:51.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "443f45380f75b7f2a1f31248ed0c2e4542e6316003cdd9661bcbc5791b602172",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26750891794"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.1",
      "date": "2026-06-01T11:05:36.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "96e3a63af5b81929a8c5e7e3d20d1f381a907f23f09c251aae51804a4ac65b12",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26750891794"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.3.1",
      "date": "2026-06-01T11:05:36.000Z",
      "commit": "a9da4840cd0a6281ffa570294960cd53aece41ff",
      "fileid": "956a4819643661dc8819d1bef93d44af27a3cc24a40bce6c0a0b11b6a45bb49d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26750891794"
    }
  ]
}