{ "_id": "6a1028d7acfb0bcc41c91001", "Package": "ugatsdb", "Title": "Uganda Time Series Database API", "Version": "0.2.3", "Date": "2022-11-20", "Authors@R": "person(\"Sebastian\", \"Krantz\", role = c(\"aut\", \"cre\"), \nemail = \"sebastian.krantz@graduateinstitute.ch\")", "Description": "An R API providing easy access to a relational database\nwith macroeconomic, financial and development related time\nseries data for Uganda. Overall more than 5000 series at\nvarying frequency (daily, monthly, quarterly, annual in fiscal\nor calendar years) can be accessed through the API. The data is\nprovided by the Bank of Uganda, the Ugandan Ministry of\nFinance, Planning and Economic Development, the IMF and the\nWorld Bank. The database is being updated once a month.", "URL": "https://mepd.finance.go.ug/apps.html", "License": "GPL-3", "Encoding": "UTF-8", "RoxygenNote": "7.1.2", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-22 09:54:44 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": "2022-11-23 23:20:02 UTC", "RemoteUrl": "https://github.com/cran/ugatsdb", "RemoteRef": "HEAD", "RemoteSha": "bc3240124f980bb67ead4b350820815560e72b28", "MD5sum": "309630e69cfc015f578346fe82d2aec3", "_user": "sebkrantz", "_type": "src", "_file": "ugatsdb_0.2.3.tar.gz", "_fileid": "b301741ceeb69a02c32e4018b9846040af8b85abaf2cabb50f9437f79e03054f", "_filesize": 151834, "_sha256": "b301741ceeb69a02c32e4018b9846040af8b85abaf2cabb50f9437f79e03054f", "_created": "2026-05-22T09:54:44.000Z", "_published": "2026-05-22T09:58:47.257Z", "_distro": "noble", "_jobs": [ { "job": 77357078797, "time": 127, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7157789383" }, { "job": 77357078756, "time": 126, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7157788900" }, { "job": 77357078724, "time": 187, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7157800876" }, { "job": 77357078793, "time": 151, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7157798095" }, { "job": 77356667221, "time": 157, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7157750872" }, { "job": 77357078758, "time": 105, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7157782249" }, { "job": 77357078868, "time": 89, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7157777795" }, { "job": 77357078774, "time": 117, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7157785938" }, { "job": 77357078811, "time": 78, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7157774859" } ], "_buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26280925500", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/ugatsdb", "_commit": { "id": "bc3240124f980bb67ead4b350820815560e72b28", "author": "Sebastian Krantz ", "committer": "cran-robot ", "message": "version 0.2.3\n", "time": 1669245602 }, "_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": "DBI", "role": "Imports" }, { "package": "RMySQL", "role": "Imports" }, { "package": "data.table", "role": "Imports" }, { "package": "collapse", "role": "Imports" }, { "package": "writexl", "role": "Imports" }, { "package": "magrittr", "role": "Suggests" }, { "package": "xts", "role": "Suggests" }, { "package": "dygraphs", "role": "Suggests" } ], "_owner": "cran", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "sebkrantz", "count": 5, "uuid": 48053842 } ], "_userbio": { "uuid": 48053842, "type": "user", "name": "Sebastian Krantz", "description": "Economist and Software Engineer" }, "_downloads": { "count": 317, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/ugatsdb" }, "_searchresults": 9, "_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/ugatsdb.html", "manual.pdf" ], "_realowner": "sebkrantz", "_cranurl": false, "_releases": [ { "version": "0.1.7", "date": "2021-07-13" }, { "version": "0.2.0", "date": "2021-08-18" }, { "version": "0.2.1", "date": "2021-09-17" }, { "version": "0.2.2", "date": "2021-11-26" }, { "version": "0.2.3", "date": "2022-11-24" } ], "_exports": [ ".IDvars", ".Tvars", "datasets", "datasources", "expand_date", "get_data", "long2wide", "make_date", "series", "transpose_wide", "ugatsdb_reconnect", "wide2excel", "wide2long" ], "_help": [ { "page": "ugatsdb-package", "title": "Uganda Time Series Database API", "topics": [ "ugatsdb-package", "ugatsdb" ] }, { "page": "dot-IDvars", "title": "Global Identifier Macros", "topics": [ ".IDvars", ".Tvars" ] }, { "page": "datasets", "title": "Retrieve Datasets Table", "topics": [ "datasets" ] }, { "page": "datasources", "title": "Retrieve Data Sources Table", "topics": [ "datasources" ] }, { "page": "expand_date", "title": "Generate Temporal Identifiers from a Date Column", "topics": [ "expand_date" ] }, { "page": "get_data", "title": "Retrieve Data from the Database", "topics": [ "get_data" ] }, { "page": "long2wide", "title": "Reshape Long API Data to Column-Based Format", "topics": [ "long2wide" ] }, { "page": "make_date", "title": "Coerce Vectors to Dates", "topics": [ "make_date" ] }, { "page": "series", "title": "Retrieve Series Table", "topics": [ "series" ] }, { "page": "transpose_wide", "title": "Transpose a Wide Dataset to a Row-Based Format", "topics": [ "transpose_wide" ] }, { "page": "ugatsdb_reconnect", "title": "Reconnect to Database", "topics": [ "ugatsdb_reconnect" ] }, { "page": "wide2excel", "title": "Export Wide Data to Excel", "topics": [ "wide2excel" ] }, { "page": "wide2long", "title": "Reshape Column-Based Data to Long Format", "topics": [ "wide2long" ] } ], "_rundeps": [ "collapse", "data.table", "DBI", "Rcpp", "RMySQL", "writexl" ], "_score": 1, "_indexed": true, "_nocasepkg": "ugatsdb", "_universes": [ "sebkrantz" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.3", "date": "2026-05-22T09:56:52.000Z", "distro": "noble", "commit": "bc3240124f980bb67ead4b350820815560e72b28", "fileid": "a1cffcaf850ea4948fdc172f75e89c8d9625b2b0a84567fb46688a861dadc08d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26280925500" }, { "r": "4.6.0", "os": "linux", "version": "0.2.3", "date": "2026-05-22T09:56:50.000Z", "distro": "noble", "commit": "bc3240124f980bb67ead4b350820815560e72b28", "fileid": "3aae9764975dec241510ee80ba143c1637a9f801f82cfdd1d763876957121148", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26280925500" }, { "r": "4.5.3", "os": "mac", "version": "0.2.3", "date": "2026-05-22T09:57:36.000Z", "commit": "bc3240124f980bb67ead4b350820815560e72b28", "fileid": "c5fb13d994df5760e7f0aceb4cf959681f334113daf8ad82d10feae673b847af", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26280925500" }, { "r": "4.6.0", "os": "mac", "version": "0.2.3", "date": "2026-05-22T09:57:22.000Z", "commit": "bc3240124f980bb67ead4b350820815560e72b28", "fileid": "3fbab276de7a91f2c6d0572612c46caa814ec195420722c756ee9fd458d46e40", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26280925500" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.3", "date": "2026-05-22T09:56:43.000Z", "commit": "bc3240124f980bb67ead4b350820815560e72b28", "fileid": "1268eed162aa52369fa0105b14ad21e0def331cbcf5842817eb91479ef93afaf", "status": "success", "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26280925500" }, { "r": "4.7.0", "os": "win", "version": "0.2.3", "date": "2026-05-22T09:56:10.000Z", "commit": "bc3240124f980bb67ead4b350820815560e72b28", "fileid": "c1319b701199a3cd5c6a719b6d2cbf9c2196bc712b209c2489b2df9d41a97dcd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26280925500" }, { "r": "4.5.3", "os": "win", "version": "0.2.3", "date": "2026-05-22T09:56:36.000Z", "commit": "bc3240124f980bb67ead4b350820815560e72b28", "fileid": "91a98ca3424723f29730994f5a3d551fb5869f3f1a6efab6de9752a966944ca9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26280925500" }, { "r": "4.6.0", "os": "win", "version": "0.2.3", "date": "2026-05-22T09:56:00.000Z", "commit": "bc3240124f980bb67ead4b350820815560e72b28", "fileid": "5762374eccc2a55a380b0326ce284709caa4f2409b614fc56fc6e3138c4593e2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/sebkrantz/actions/runs/26280925500" } ] }