{ "_id": "6a1f360fb401979e73428819", "Package": "sonata", "Title": "Interagir com MozART 2.0", "Version": "1.0.0", "Authors@R": "c(\nperson(\"Joe\", \"Lara\", email = \"jlara@usaid.gov\", role = c(\"aut\", \"cre\")),\nperson(\"Karishma\", \"Srikanth\", email = \"ksrikanth@usaid.gov\", role = c(\"aut\")),\nperson(\"Baboyma\", \"Kagniniwa\", email = \"bkagniniwa@usaid.gov\", role = (\"aut\")),\nperson(\"Timothy\", \"Essam\", email = \"tessam@usaid.gov\", role = (\"aut\")))", "Description": "Provides a set of utilities and functions for connecting,\nquerying, and analyzing data from the Mozambique MozART 2.0\ndatabase.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "LazyData": "true", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2", "BugReports": "https://github.com/usaid-mozambique/sonata/issues", "VignetteBuilder": "knitr", "URL": "https://usaid-mozambique.github.io/sonata/", "Config/pak/sysreqs": "cmake make libicu-dev libmysqlclient-dev libuv1-dev\nlibx11-dev", "Repository": "https://usaid-mozambique.r-universe.dev", "Date/Publication": "2025-03-15 09:38:38 UTC", "RemoteUrl": "https://github.com/usaid-mozambique/sonata", "RemoteRef": "HEAD", "RemoteSha": "5e95f4f82408465558d4e429daba0aee1549fa99", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-15 06:24:53 UTC", "User": "root" }, "Author": "Joe Lara [aut, cre],\nKarishma Srikanth [aut],\nBaboyma Kagniniwa [aut],\nTimothy Essam [aut]", "Maintainer": "Joe Lara ", "MD5sum": "199e86726177b61a82c0ad96eb0fd4dc", "_user": "usaid-mozambique", "_type": "src", "_file": "sonata_1.0.0.tar.gz", "_fileid": "a011d34e159156fc06a978cb93e360bcfa6e92c5845c66aceab8e17ab424cf5d", "_filesize": 1423001, "_sha256": "a011d34e159156fc06a978cb93e360bcfa6e92c5845c66aceab8e17ab424cf5d", "_created": "2026-05-15T06:24:53.000Z", "_published": "2026-06-02T19:59:11.430Z", "_distro": "noble", "_jobs": [ { "job": 79160206724, "time": 128, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7011394461" }, { "job": 79160206872, "time": 152, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7011397805" }, { "job": 79160206722, "time": 82, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "7011383440" }, { "job": 79160206711, "time": 74, "config": "macos-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7011381781" }, { "job": 79160206617, "time": 207, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7011365294" }, { "job": 79160205781, "time": 112, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7368404765" }, { "job": 79160206693, "time": 84, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7011383740" }, { "job": 79160206840, "time": 89, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "7011384811" }, { "job": 79160206969, "time": 74, "config": "windows-release", "r": "4.6.0", "check": "NOTE", "artifact": "7011381460" } ], "_buildurl": "https://github.com/r-universe/usaid-mozambique/actions/runs/25903676212", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/usaid-mozambique/sonata", "_commit": { "id": "5e95f4f82408465558d4e429daba0aee1549fa99", "author": "Joseph Lara ", "committer": "Joseph Lara ", "message": "**fix** updates\n", "time": 1742031518 }, "_maintainer": { "name": "Joe Lara", "email": "jlara@usaid.gov" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "dplyr", "role": "Imports" }, { "package": "lubridate", "role": "Imports" }, { "package": "RMySQL", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "lifecycle", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "testthat", "role": "Imports" }, { "package": "tidyselect", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "usaid-mozambique", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "josephlara", "count": 106, "uuid": 25661908 }, { "user": "karishmas26", "count": 9, "uuid": 84093378 } ], "_userbio": { "uuid": 53524470, "type": "organization", "name": "usaid-mozambique" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sonata" }, "_devurl": "https://github.com/usaid-mozambique/sonata", "_pkgdown": "https://usaid-mozambique.github.io/sonata/", "_searchresults": 0, "_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/readme.html", "extra/readme.md", "extra/sonata.html", "manual.pdf" ], "_cranurl": false, "_exports": [ "calc_age_var", "calc_arv_pickups", "calc_consults", "calc_tx_active", "calc_tx_new", "mysql_connection", "project_age_out", "pull_active_uuid", "pull_client_uuid", "pull_new_uuid", "recode_age", "recode_cols", "recode_disp_mode", "recode_form", "recode_location", "recode_regimen", "recode_sex", "recode_state" ], "_datasets": [ { "name": "data_location_lookup", "title": "Referência: location_uuid", "object": "data_location_lookup", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "location_uuid", "datim_id", "sisma_id", "province", "district", "datim_name", "mozart_name" ], "rows": 635, "table": true, "tojson": true }, { "name": "data_observation_lookup", "title": "Referência: data_observation_lookup", "object": "data_observation_lookup", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "concept_id", "concept_name" ], "rows": 11632, "table": true, "tojson": true }, { "name": "data_type_id_lookup", "title": "Referência: data_type_id_lookup", "object": "data_type_id_lookup", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "id", "table_name", "column_name", "id_type_lookup", "id_type_desc", "id_type_desc_pt", "notes" ], "rows": 807, "table": true, "tojson": true } ], "_help": [ { "page": "calc_age_var", "title": "Calcular a idade do cliente", "topics": [ "calc_age_var" ] }, { "page": "calc_arv_pickups", "title": "Query levantamentos TARV", "topics": [ "calc_arv_pickups" ] }, { "page": "calc_consults", "title": "Query consultas clínicas HIV", "topics": [ "calc_consults" ] }, { "page": "calc_tx_active", "title": "Query clientes activos em TARV", "topics": [ "calc_tx_active" ] }, { "page": "calc_tx_new", "title": "Query novos inícios ao TARV", "topics": [ "calc_tx_new" ] }, { "page": "data_location_lookup", "title": "Referência: location_uuid", "topics": [ "data_location_lookup" ] }, { "page": "data_observation_lookup", "title": "Referência: data_observation_lookup", "topics": [ "data_observation_lookup" ] }, { "page": "data_type_id_lookup", "title": "Referência: data_type_id_lookup", "topics": [ "data_type_id_lookup" ] }, { "page": "mysql_connection", "title": "Passar de forma segura credenciais e estabelecer coneção ao MozART 2.0", "topics": [ "mysql_connection" ] }, { "page": "project_age_out", "title": "Detectar transição etária", "topics": [ "project_age_out" ] }, { "page": "pull_active_uuid", "title": "Query uuids dos activos no TARV", "topics": [ "pull_active_uuid" ] }, { "page": "pull_client_uuid", "title": "Query uuids para activos ou novos inícios ao TARV", "topics": [ "pull_client_uuid" ] }, { "page": "pull_new_uuid", "title": "Query uuids dos novos inícios ao TARV", "topics": [ "pull_new_uuid" ] }, { "page": "recode_age", "title": "Recodificar idade", "topics": [ "recode_age" ] }, { "page": "recode_cols", "title": "Recodificar várias colunas utilizando vectores custimizados", "topics": [ "recode_cols" ] }, { "page": "recode_disp_mode", "title": "Recodificar modo de dispensa TARV", "topics": [ "recode_disp_mode" ] }, { "page": "recode_form", "title": "Recodificar formulario primario", "topics": [ "recode_form" ] }, { "page": "recode_location", "title": "Recodificar location_uuid's", "topics": [ "recode_location" ] }, { "page": "recode_regimen", "title": "Recodificar regimen TARV", "topics": [ "recode_regimen" ] }, { "page": "recode_sex", "title": "Recodificar sexo", "topics": [ "recode_sex" ] }, { "page": "recode_state", "title": "Recodificar estado do cliente", "topics": [ "recode_state" ] } ], "_pkglogo": "https://github.com/usaid-mozambique/sonata/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/usaid-mozambique/sonata/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "brio", "callr", "cli", "clipr", "cpp11", "crayon", "DBI", "desc", "diffobj", "dplyr", "evaluate", "fs", "generics", "glue", "hms", "jsonlite", "lifecycle", "lubridate", "magrittr", "pillar", "pkgbuild", "pkgconfig", "pkgload", "praise", "prettyunits", "processx", "progress", "ps", "R6", "readr", "rlang", "RMySQL", "rprojroot", "stringi", "stringr", "testthat", "tibble", "tidyselect", "timechange", "tzdb", "utf8", "vctrs", "vroom", "waldo", "withr" ], "_vignettes": [ { "source": "analisar-transicao-etaria.Rmd", "filename": "analisar-transicao-etaria.html", "title": "Detectar Transição Etária", "engine": "knitr::rmarkdown", "headings": [ "Anexar pacotes", "Estabelecer conexão", "Chamar população de base", "Projectar idade individual", "Analisar transição etária" ], "created": "2025-02-19 15:22:32", "modified": "2025-02-21 16:10:58", "commits": 3 }, { "source": "chamar-activos-e-recodificar.Rmd", "filename": "chamar-activos-e-recodificar.html", "title": "Cálculo dos Activos em TARV", "engine": "knitr::rmarkdown", "headings": [ "Anexar pacotes", "Estabelecer conexão", "Chamar \"Activos em TARV\"", "Recodificar variáveis" ], "created": "2025-02-17 09:47:52", "modified": "2025-02-25 10:30:40", "commits": 7 }, { "source": "definir-credenciais.Rmd", "filename": "definir-credenciais.html", "title": "Uso de Credenciais MozART 2.0", "engine": "knitr::rmarkdown", "headings": [ "Introdução", "Carregar pacotes", "Gravar credenciais", "Carregar credenciais e conectar" ], "created": "2025-02-14 09:03:47", "modified": "2025-02-26 10:46:29", "commits": 10 } ], "_score": 3.1760912590556813, "_indexed": true, "_nocasepkg": "sonata", "_universes": [ "usaid-mozambique" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.0", "date": "2026-05-15T06:27:12.000Z", "distro": "noble", "commit": "5e95f4f82408465558d4e429daba0aee1549fa99", "fileid": "70efe8b5df2177a141d99ba9f44a8564778e0b64867c636d4fb1578acff24938", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usaid-mozambique/actions/runs/25903676212" }, { "r": "4.6.0", "os": "linux", "version": "1.0.0", "date": "2026-05-15T06:27:27.000Z", "distro": "noble", "commit": "5e95f4f82408465558d4e429daba0aee1549fa99", "fileid": "224f62bd1f559e01ff93870ab961af6ff1e2d4b4569dae0fea35ef2675a5fd86", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usaid-mozambique/actions/runs/25903676212" }, { "r": "4.5.3", "os": "mac", "version": "1.0.0", "date": "2026-05-15T06:26:26.000Z", "commit": "5e95f4f82408465558d4e429daba0aee1549fa99", "fileid": "fdbf4093bc699dd0579ea2de89ed9542faa84bfc436360b65da60e9671f8eb65", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usaid-mozambique/actions/runs/25903676212" }, { "r": "4.6.0", "os": "mac", "version": "1.0.0", "date": "2026-05-15T06:26:17.000Z", "commit": "5e95f4f82408465558d4e429daba0aee1549fa99", "fileid": "ac89a6775a80ec27b7e1285efe118941ac85e0c41ca67e7db0c7cabc4c48ebfb", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usaid-mozambique/actions/runs/25903676212" }, { "r": "4.7.0", "os": "win", "version": "1.0.0", "date": "2026-05-15T06:26:14.000Z", "commit": "5e95f4f82408465558d4e429daba0aee1549fa99", "fileid": "001aa22c0cbfcfb0f38e15dd2ee4ca1267f176cc7eb5883cbcacd96f3cd7bd9e", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usaid-mozambique/actions/runs/25903676212" }, { "r": "4.5.3", "os": "win", "version": "1.0.0", "date": "2026-05-15T06:26:20.000Z", "commit": "5e95f4f82408465558d4e429daba0aee1549fa99", "fileid": "502a73a4abb59a099d943bf9ec8a8586d57ed938265f165112135374acfb481a", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usaid-mozambique/actions/runs/25903676212" }, { "r": "4.6.0", "os": "win", "version": "1.0.0", "date": "2026-05-15T06:26:06.000Z", "commit": "5e95f4f82408465558d4e429daba0aee1549fa99", "fileid": "9a77c5509029464273f5f1cb21d4a86502ce86daf4efdf2cde0217d13446bd5e", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/usaid-mozambique/actions/runs/25903676212" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.0", "date": "2026-06-02T19:58:56.000Z", "commit": "5e95f4f82408465558d4e429daba0aee1549fa99", "fileid": "de49650fc95af84bd24fe295a62f600cf3e309ab3b84e6176aec3af667d7810a", "status": "success", "buildurl": "https://github.com/r-universe/usaid-mozambique/actions/runs/25903676212" } ] }