{
  "_id": "6acf2f8bd9de2f3f33fc8cb9",
  "Package": "selfdestructin5",
  "Title": "Creates SI OHA Mission Director Briefers",
  "Version": "0.4.0",
  "Authors@R": "c(\nperson(\"Tim\", \"Essam\", ,\"tessam@usaid.gov\", c(\"aut\", \"cre\")),\nperson(\"Aaron\", \"Chafetz\", ,\"achafetz@usaid.gov\", c(\"aut\")),\nperson(\"Karishma\", \"Srinkanth\", ,\"ksrikanth@usaid.gov\", c(\"aut\"))\n)",
  "Description": "Creates a series of data frames that can be passed to a\ngt() to create the PEPFAR summary tables.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "LazyData": "true",
  "URL": "https://github.com/USAID-OHA-SI/selfdestructin5",
  "BugReports": "https://github.com/USAID-OHA-SI/selfdestructin5/issues",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.1",
  "Remotes": [
    "USAID-OHA-SI/glamr",
    "USAID-OHA-SI/glitr",
    "USAID-OHA-SI/gophr",
    "USAID-OHA-SI/gagglr"
  ],
  "BuildVignettes": "true",
  "VignetteBuilder": "knitr",
  "Config/pak/sysreqs": "cmake libfontconfig1-dev libfreetype6-dev git make\nlibgit2-dev libicu-dev libsecret-1-dev libuv1-dev libxml2-dev\nlibssl-dev libnode-dev libx11-dev",
  "Repository": "https://usaid-oha-si.r-universe.dev",
  "Date/Publication": "2025-02-18 17:18:39 UTC",
  "RemoteUrl": "https://github.com/USAID-OHA-SI/selfdestructin5",
  "RemoteRef": "HEAD",
  "RemoteSha": "132db63cccb0fd2aa776794d019f8e539ea3fd6f",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-14 07:16:39 UTC",
    "User": "root"
  },
  "Author": "Tim Essam [aut, cre],\nAaron Chafetz [aut],\nKarishma Srinkanth [aut]",
  "Maintainer": "Tim Essam <tessam@usaid.gov>",
  "_user": "usaid-oha-si",
  "_type": "src",
  "_file": "selfdestructin5_0.4.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/80ba8a2de58f26d24c89231a13a7666063ae396c37dc0747ebc22a0db1d31e58",
  "_filesize": 243044,
  "_sha256": "80ba8a2de58f26d24c89231a13a7666063ae396c37dc0747ebc22a0db1d31e58",
  "_expires": "2027-01-22T07:30:16.000Z",
  "_created": "2026-10-14T07:16:39.000Z",
  "_published": "2026-10-14T07:30:19.455Z",
  "_buildurl": "https://github.com/r-universe/usaid-oha-si/actions/runs/38526851796",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 115730625598,
      "time": 134,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "11875789534"
    },
    {
      "job": 115730625599,
      "time": 140,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "11876676654"
    },
    {
      "job": 115730625653,
      "time": 112,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "11876533783"
    },
    {
      "job": 115730625560,
      "time": 88,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "11876751969"
    },
    {
      "job": 115729235398,
      "time": 242,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11876800369"
    },
    {
      "job": 115730625622,
      "time": 129,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11876298723"
    },
    {
      "job": 115730625808,
      "time": 96,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "11875884173"
    },
    {
      "job": 115730625647,
      "time": 76,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "11876193683"
    },
    {
      "job": 115730625677,
      "time": 102,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "11875967604"
    }
  ],
  "_upstream": "https://github.com/USAID-OHA-SI/selfdestructin5",
  "_commit": {
    "id": "132db63cccb0fd2aa776794d019f8e539ea3fd6f",
    "author": "tessam30 <tessam30@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #41 from USAID-OHA-SI/minoria_dev\n\nMinoria dev",
    "time": 1739899119
  },
  "_maintainer": {
    "name": "Tim Essam",
    "email": "tessam@usaid.gov",
    "login": "tessam30",
    "linkedin": "in/timessam",
    "description": "Data wrangler / janitor / sciencer...sometimes. Previous collaborator with @achafetz,  @baboyma & @karishmas26 and @flaneuse.",
    "uuid": 5873344
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 2.10",
      "role": "Depends"
    },
    {
      "package": "crayon",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "glue",
      "role": "Imports"
    },
    {
      "package": "magrittr",
      "role": "Imports"
    },
    {
      "package": "purrr",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "glitr",
      "role": "Imports"
    },
    {
      "package": "glamr",
      "role": "Imports"
    },
    {
      "package": "gophr",
      "role": "Imports"
    },
    {
      "package": "gt",
      "role": "Imports"
    },
    {
      "package": "tidyselect",
      "role": "Imports"
    },
    {
      "package": "fontawesome",
      "role": "Imports"
    },
    {
      "package": "forcats",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "qpdf",
      "role": "Suggests"
    }
  ],
  "_owner": "usaid-oha-si",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [],
  "_tags": [],
  "_stars": 1,
  "_contributors": [
    {
      "user": "tessam30",
      "count": 148,
      "uuid": 5873344
    },
    {
      "user": "mmm2365",
      "count": 27,
      "uuid": 74432178
    },
    {
      "user": "achafetz",
      "count": 16,
      "uuid": 8933069
    },
    {
      "user": "karishmas26",
      "count": 1,
      "uuid": 84093378
    }
  ],
  "_userbio": {
    "uuid": 24459861,
    "type": "organization",
    "name": "USAID OHA SI",
    "followers": 48
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/selfdestructin5"
  },
  "_devurl": "https://github.com/usaid-oha-si/selfdestructin5",
  "_searchresults": 21,
  "_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/readme.html",
    "extra/readme.md",
    "extra/selfdestructin5.html",
    "LICENSE"
  ],
  "_cranurl": false,
  "_exports": [
    "%>%",
    "bold_column",
    "bold_rowgroup",
    "collapse_base_tbl",
    "collapse_vlc_tbl",
    "create_mdb",
    "embiggen",
    "fetch_indicators",
    "fetch_metadata",
    "format_indicator",
    "label_aggregation",
    "legend",
    "make_achv_shape",
    "make_chg_shape",
    "make_mdb_df",
    "make_mdb_tx_df",
    "mdb_main_theme",
    "mdb_treatment_theme",
    "msd_period",
    "past_fy",
    "reshape_mdb_df",
    "reshape_mdb_tx_df",
    "set_metadata"
  ],
  "_datasets": [
    {
      "name": "mdb_tbl",
      "title": "mdb_tbl: Example Data Set",
      "object": "mdb_tbl",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "indic_category",
        "indicator",
        "indicator_plain",
        "frequency",
        "type",
        "mdb_table"
      ],
      "rows": 16,
      "table": true,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "bold_column",
      "title": "Bold columns inside gt objects Helper function to quickly make columns within table bold",
      "topics": [
        "bold_column"
      ]
    },
    {
      "page": "bold_rowgroup",
      "title": "Make all text larger Bold Agency names - used to increase stroke on row group label",
      "concept": [
        "gt helpers"
      ],
      "topics": [
        "bold_rowgroup"
      ]
    },
    {
      "page": "calc_growth",
      "title": "Calculate growth between two metrics that are positive",
      "concept": [
        "MDB helper functions"
      ],
      "topics": [
        "calc_growth"
      ]
    },
    {
      "page": "collapse_base_tbl",
      "title": "Collapse base MSD down to a desired level for main MDB table",
      "concept": [
        "data frame munging"
      ],
      "topics": [
        "collapse_base_tbl"
      ]
    },
    {
      "page": "collapse_vlc_tbl",
      "title": "Collapse base MSD down to a desired level for core treatment indicators",
      "concept": [
        "data frame munging"
      ],
      "topics": [
        "collapse_vlc_tbl"
      ]
    },
    {
      "page": "create_mdb",
      "title": "Wrapper function to create a MDB table",
      "topics": [
        "create_mdb"
      ]
    },
    {
      "page": "embiggen",
      "title": "Embiggen parts of mdb table A noble spirit embiggens the smallest man",
      "topics": [
        "embiggen"
      ]
    },
    {
      "page": "extract_num_colnames",
      "title": "Extract a vector of numeric column names",
      "concept": [
        "gt helpers"
      ],
      "topics": [
        "extract_num_colnames"
      ]
    },
    {
      "page": "fetch_indicators",
      "title": "Fetches indicators used to make tables, accounting for quarter of MSD and semi-annual indicators",
      "topics": [
        "fetch_indicators"
      ]
    },
    {
      "page": "fetch_metadata",
      "title": "Fetch metadata",
      "topics": [
        "fetch_metadata"
      ]
    },
    {
      "page": "format_indicator",
      "title": "Formats PEPFAR indicators for MDB tables",
      "concept": [
        "MDB helper functions"
      ],
      "topics": [
        "format_indicator"
      ]
    },
    {
      "page": "label_aggregation",
      "title": "Label aggregation level",
      "concept": [
        "MDB helper functions"
      ],
      "topics": [
        "label_aggregation"
      ]
    },
    {
      "page": "legend",
      "title": "Object pointing to github location of legend for Q1",
      "concept": [
        "gt helpers"
      ],
      "topics": [
        "legend"
      ]
    },
    {
      "page": "legend_q1",
      "title": "Object pointing to github location of legend for Q1",
      "concept": [
        "gt helpers"
      ],
      "topics": [
        "legend_q1"
      ]
    },
    {
      "page": "legend_q2",
      "title": "Object pointing to github location of legend for Q2",
      "concept": [
        "gt helpers"
      ],
      "topics": [
        "legend_q2"
      ]
    },
    {
      "page": "legend_q3",
      "title": "Object pointing to github location of legend for Q3",
      "concept": [
        "gt helpers"
      ],
      "topics": [
        "legend_q3"
      ]
    },
    {
      "page": "legend_snapshot",
      "title": "Object pointing to github location of legend for snapshot indicators and Q4",
      "concept": [
        "gt helpers"
      ],
      "topics": [
        "legend_snapshot"
      ]
    },
    {
      "page": "make_achv_shape",
      "title": "Generate colored circle as an svg",
      "concept": [
        "MDB helper functions"
      ],
      "topics": [
        "make_achv_shape"
      ]
    },
    {
      "page": "make_chg_shape",
      "title": "Create fontawesome performance arrow",
      "concept": [
        "MDB helper functions"
      ],
      "topics": [
        "make_chg_shape"
      ]
    },
    {
      "page": "make_mdb_df",
      "title": "Create a base table of MDB indicators stacked long",
      "concept": [
        "data frame munging"
      ],
      "topics": [
        "make_mdb_df"
      ]
    },
    {
      "page": "make_mdb_tx_df",
      "title": "Creates the base table for the treatment / VLS MDB tables",
      "concept": [
        "data frame munging"
      ],
      "topics": [
        "make_mdb_tx_df"
      ]
    },
    {
      "page": "mdb_main_theme",
      "title": "GT theme for main MDB tables",
      "concept": [
        "MDB gt themes"
      ],
      "topics": [
        "mdb_main_theme"
      ]
    },
    {
      "page": "mdb_tbl",
      "title": "mdb_tbl: Example Data Set",
      "topics": [
        "mdb_tbl"
      ]
    },
    {
      "page": "mdb_treatment_theme",
      "title": "GT theme for main MDB tables",
      "concept": [
        "MDB gt themes"
      ],
      "topics": [
        "mdb_treatment_theme"
      ]
    },
    {
      "page": "msd_period",
      "title": "Identify MSD Period and Type",
      "topics": [
        "msd_period"
      ]
    },
    {
      "page": "reshape_mdb_df",
      "title": "Prepare filtered data frame for MSD briefer formatting",
      "concept": [
        "data frame munging"
      ],
      "topics": [
        "reshape_mdb_df"
      ]
    },
    {
      "page": "reshape_mdb_tx_df",
      "title": "Prepare filtered data frame of treatment indicators for MDB formatting",
      "concept": [
        "data frame munging"
      ],
      "topics": [
        "reshape_mdb_tx_df"
      ]
    },
    {
      "page": "set_metadata",
      "title": "Set metadata",
      "topics": [
        "set_metadata"
      ]
    }
  ],
  "_pkglogo": "https://github.com/USAID-OHA-SI/selfdestructin5/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/USAID-OHA-SI/selfdestructin5/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "base64enc",
    "bigD",
    "bit",
    "bit64",
    "bitops",
    "bslib",
    "cachem",
    "cellranger",
    "cli",
    "clipr",
    "commonmark",
    "cpp11",
    "crayon",
    "credentials",
    "curl",
    "desc",
    "digest",
    "dplyr",
    "evaluate",
    "farver",
    "fastmap",
    "filelock",
    "fontawesome",
    "fs",
    "gargle",
    "generics",
    "gert",
    "getPass",
    "ggplot2",
    "gitcreds",
    "glamr",
    "glitr",
    "glue",
    "googledrive",
    "googlesheets4",
    "gophr",
    "gt",
    "gtable",
    "highr",
    "hms",
    "htmltools",
    "htmlwidgets",
    "httr",
    "httr2",
    "ids",
    "ini",
    "isoband",
    "jquerylib",
    "jsonlite",
    "juicyjuice",
    "keyring",
    "knitr",
    "labeling",
    "lifecycle",
    "litedown",
    "lubridate",
    "magrittr",
    "markdown",
    "memoise",
    "mime",
    "openssl",
    "pak",
    "pillar",
    "pkgconfig",
    "prettyunits",
    "progress",
    "purrr",
    "R6",
    "rappdirs",
    "RColorBrewer",
    "Rcpp",
    "reactable",
    "reactR",
    "readr",
    "rematch",
    "rematch2",
    "rlang",
    "rmarkdown",
    "rprojroot",
    "rstudioapi",
    "S7",
    "sass",
    "scales",
    "stringi",
    "stringr",
    "sys",
    "systemfonts",
    "tibble",
    "tidyr",
    "tidyselect",
    "timechange",
    "tinytex",
    "tzdb",
    "usethis",
    "utf8",
    "uuid",
    "V8",
    "vctrs",
    "viridisLite",
    "vroom",
    "whisker",
    "withr",
    "xfun",
    "xml2",
    "yaml",
    "zip"
  ],
  "_vignettes": [
    {
      "source": "creating-summary-tables.Rmd",
      "filename": "creating-summary-tables.html",
      "title": "Creating Summary Tables",
      "engine": "knitr::rmarkdown",
      "headings": [
        "GHSD MSD Summary Tables",
        "Batching Tables",
        "Creating bespoke tables"
      ],
      "created": "2024-07-11 19:17:55",
      "modified": "2024-07-11 19:17:55",
      "commits": 1
    }
  ],
  "_score": 3.498310553789601,
  "_indexed": true,
  "_nocasepkg": "selfdestructin5",
  "_universes": [
    "usaid-oha-si",
    "tessam30"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.4.0",
      "date": "2026-10-14T07:19:01.000Z",
      "distro": "resolute",
      "commit": "132db63cccb0fd2aa776794d019f8e539ea3fd6f",
      "fileid": "https://r2.ropensci.org/14f6a40ffdb4fb2efe5d28974114eea5b66f3b860926f7d0844b8807d3be02cc",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/usaid-oha-si/actions/runs/38526851796"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.4.0",
      "date": "2026-10-14T07:19:06.000Z",
      "distro": "resolute",
      "commit": "132db63cccb0fd2aa776794d019f8e539ea3fd6f",
      "fileid": "https://r2.ropensci.org/2ade4b744b5012aa8676e4cde8f86c4700cee4c4917a7a66aafbd2450dae271f",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/usaid-oha-si/actions/runs/38526851796"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.4.0",
      "date": "2026-10-14T07:29:36.000Z",
      "commit": "132db63cccb0fd2aa776794d019f8e539ea3fd6f",
      "fileid": "https://r2.ropensci.org/cede6c3fe7556789961b480df59f86328621910d16674138a6f03431bb06914f",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/usaid-oha-si/actions/runs/38526851796"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.4.0",
      "date": "2026-10-14T07:23:18.000Z",
      "commit": "132db63cccb0fd2aa776794d019f8e539ea3fd6f",
      "fileid": "https://r2.ropensci.org/31c4175b48cd99e49690c7cc957ae06f2bad32d4126e477e47a3732edeb787c1",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/usaid-oha-si/actions/runs/38526851796"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.4.0",
      "date": "2026-10-14T07:19:10.000Z",
      "commit": "132db63cccb0fd2aa776794d019f8e539ea3fd6f",
      "fileid": "https://r2.ropensci.org/b34f27e41f165c2f72afe80b8041a578557a73d9cdc208e11b8b7d576d3db8d4",
      "status": "success",
      "buildurl": "https://github.com/r-universe/usaid-oha-si/actions/runs/38526851796"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.4.0",
      "date": "2026-10-14T07:18:15.000Z",
      "commit": "132db63cccb0fd2aa776794d019f8e539ea3fd6f",
      "fileid": "https://r2.ropensci.org/83d62c1a96a2f9ac01aba12c5969b970dd15f2bd5887649f49cb5cf5999aad02",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/usaid-oha-si/actions/runs/38526851796"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.4.0",
      "date": "2026-10-14T07:18:01.000Z",
      "commit": "132db63cccb0fd2aa776794d019f8e539ea3fd6f",
      "fileid": "https://r2.ropensci.org/208b5b23fc319d52a5b2f868680b3d52e44fe2b281264058f64ced1c7b6ea12e",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/usaid-oha-si/actions/runs/38526851796"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.4.0",
      "date": "2026-10-14T07:18:26.000Z",
      "commit": "132db63cccb0fd2aa776794d019f8e539ea3fd6f",
      "fileid": "https://r2.ropensci.org/aa9513726bda9c72b1d6ab74d0cf606959678b1d357913fe0b3db5f01bd552ae",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/usaid-oha-si/actions/runs/38526851796"
    }
  ]
}