if(!require(pacman)) install.packages("pacman")
## Loading required package: pacman
pacman::p_load(tidyverse, reactable, htmltools)
pacman::p_load_gh("gpw13/ghost")


reactable_print <- function(df){
  df %>% 
    reactable::reactable(defaultPageSize = 10, 
                         striped = TRUE,
                         highlight = TRUE,
                         resizable = TRUE,
                         defaultColDef = reactable::colDef(align = "left", 
                                                           html = TRUE, 
                                                           class = "border-left", 
                                                           na = "NA"), 
                         wrap = FALSE,
                         bordered = TRUE,
                         theme = reactable::reactableTheme(stripedColor = "#f2f7f7", 
                                                           cellPadding = "2px 5px 2px 5px", 
                                                           borderColor = "#e1f2f2", 
                                                           borderWidth = "1.5px"))
}   
htm_indicators <- gho_indicators() %>% 
  filter(grepl("malaria|mosquito|HIV|AIDS|tuberculosis|tb", 
               IndicatorName,
               ignore.case = T))

reactable_print(htm_indicators)

Indicator Detailed Tables

The following sections display the first rows for each indicator.

for (i in 1:nrow(htm_indicators)) {
#for (i in 1:10) {

  section_title <- htm_indicators[[i, "IndicatorName"]]
  code <- htm_indicators[[i, "IndicatorCode"]]
  
  data_for_reactable <- 
    gho_data(code) %>% 
    arrange() %>% 
    head(500)
  
  cat(paste0("\n## ", section_title, "\n\n"))
  print(htmltools::tagList(reactable_print(data_for_reactable)))
}

Estimated number of people (all ages) living with HIV

Number of pregnant women living with HIV who received antiretrovirals for preventing mother-to-child transmission

Estimated number of pregnant women living with HIV

Estimated number of pregnant women living with HIV needing antiretrovirals for preventing mother-to-child transmission

Number of new HIV infections

Estimated antiretroviral therapy coverage among people living with HIV (%)

Deaths due to tuberculosis among HIV-negative people (per 100 000 population)

Incidence of tuberculosis (per 100 000 population per year)

Population aged 15-24 years with comprehensive correct knowledge of HIV/AIDS (%)

Prevalence of HIV among adults aged 15 to 49 (%)

Smear-positive tuberculosis case-detection rate (%)

Smear-positive tuberculosis treatment-success rate (%)

Antiretroviral therapy coverage among people with HIV infection eligible for ART according to 2010 guidelines (%)

Antiretroviral therapy coverage among people with advanced HIV infection (%), WHO 2006 guidelines

Specialized treatment services for drug use disoders and HIV/AIDS

Specialized treatment services for substance use disorders and TB

HIV, Hepatitis counselling and treatment availability in specialized facilities and services

New HIV infections (per 1000 uninfected population)

Tuberculosis treatment coverage

New cases tested for RR-/MDR-TB (%)

Previously treated cases tested for RR-/MDR-TB (%)

Laboratories providing tuberculosis diagnostic services using culture (per 5 million population)

Laboratories providing tuberculosis diagnostic services using sputum smear microscopy (per 100 000 population)

Treatment success rate for patients treated for MDR-TB (%)

Cases started on MDR-TB treatment

Treatment success rate for new pulmonary smear-negative and extrapulmonary tuberculosis cases

Treatment success rate: new TB cases

Tuberculosis - new and relapse cases

Total number of notified TB cases

Treatment success rate: previously treated TB cases

Treatment success rate: HIV-positive TB cases

Treatment success rate: XDR-TB cases

Confirmed cases of MDR-TB started treatment for MDR-TB (%)

Number of incident tuberculosis cases

Number of incident tuberculosis cases in children aged 0 - 14

Incidence of tuberculosis (per 100 000 population) (HIV-positive cases)

Number of incident tuberculosis cases, (HIV-positive cases)

Estimated MDR-TB cases among notified pulmonary TB cases

Number of deaths due to tuberculosis, excluding HIV

Number of prevalent tuberculosis cases

Tuberculosis effective treatment coverage (%)

HIV-positive TB patients on ART (antiretroviral therapy) (%)

HIV-positive TB patients on CPT (co-trimoxazole preventive therapy) (%)

TB patients with known HIV status (%)

Tested TB patients HIV-positive (%)

Confirmed cases of MDR-TB

Confirmed cases of RR-/MDR-TB

Tuberculosis - new and relapse cases

Deaths due to HIV/AIDS (per 100 000 population)

Deaths due to malaria (per 100 000 population)

Number of reported cases of tuberculosis

In-prison HIV diagnosis (number of diagnoses)

Number of indigenous P. falciparum malaria cases

Number of imported malaria cases

Population with access to an insecticide-treated bed net (ITN) for malaria protection (%), modelled

Estimated number of malaria deaths

Estimated malaria incidence (per 1000 population at risk)

In-prison MDR-TB diagnosis (number of diagnoses)

Estimated number of MDR/RR-TB incident cases

In-prison TB diagnosis (number of diagnoses)

Number of malaria suspects examined by microscopy

Estimated number of malaria cases

Number of suspected malaria cases

Status of indigenous malaria cases

Number of indigenous P. vivax malaria cases

Number of indigenous malaria cases

Number of confirmed malaria cases

Number of malaria suspects examined by rapid diagnostic test (RDT)

Number of malaria cases treated with artemisinin-based combination therapies (ACTs)

Number of malaria positive cases by microscopy

Number of malaria positive cases by rapid diagnostic test (RDT)

Number of malaria cases treated with any first  line tx courses (including artemisinin-based combination therapies (ACTs))

Estimated malaria mortality rate (per 100 000 population)

Pregnant women attending antenatal care  at least once and receiving at least 3 doses of Intermittent Preventive Treatment of Malaria for Pregnant Women (IPTp3) (%)

Number of presumed malaria cases

Number of people protected from malaria by indoor residual spraying (IRS)

Total number of  malaria cases (presumed + confirmed cases)