variables
Data license: CC-BY
22 rows where datasetId = 2694 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt, createdAt (date), updatedAt (date)
id ▲ | name | unit | description | createdAt | updatedAt | code | coverage | timespan | datasetId | sourceId | shortUnit | display | columnOrder | originalMetadata | grapherConfigAdmin | shortName | catalogPath | dimensions | schemaVersion | processingLevel | processingLog | titlePublic | titleVariant | attributionShort | attribution | descriptionShort | descriptionFromProducer | descriptionKey | descriptionProcessing | licenses | license | grapherConfigETL | type | sort | dataChecksum | metadataChecksum |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
95541 | Indicator:Antiretroviral therapy coverage among people with advanced HIV infection (%), WHO 2006 guidelines | 2018-03-23 12:44:44 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Antiretroviral therapy coverage among people with advanced HIV infection (%), WHO 2006 guidelines 15410 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95516 | Indicator:Estimated antiretroviral therapy coverage among people living with HIV (%) | 2018-03-23 12:44:42 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Estimated antiretroviral therapy coverage among people living with HIV (%) 15392 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95489 | Indicator:Congenital syphilis rate per 100 000 live births | 2018-03-23 12:44:41 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Congenital syphilis rate per 100 000 live births 15382 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95388 | Indicator:Antiretroviral therapy coverage among people with HIV infection eligible for ART according to 2010 guidelines (%) | 2018-03-23 12:44:30 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Antiretroviral therapy coverage among people with HIV infection eligible for ART according to 2010 guidelines (%) 15346 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95311 | Indicator:People aged 15 years and over who received HIV testing and counselling, estimated number per 1000 adult population | 2018-03-23 12:44:20 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | People aged 15 years and over who received HIV testing and counselling, estimated number per 1000 adult population 15333 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95257 | Indicator:Estimated number of children needing antiretroviral therapy based on WHO methods | 2018-03-23 12:44:11 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Estimated number of children needing antiretroviral therapy based on WHO methods 15323 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95255 | Indicator:Estimated number of pregnant women living with HIV needing antiretrovirals for preventing mother-to-child transmission based on WHO methods | 2018-03-23 12:44:11 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Estimated number of pregnant women living with HIV needing antiretrovirals for preventing mother-to-child transmission based on WHO methods 15321 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95205 | Indicator:Reported number of people receiving antiretroviral therapy | 2018-03-23 12:44:09 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Reported number of people receiving antiretroviral therapy 15306 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95204 | Indicator:Estimated percentage of pregnant women living with HIV who received antiretrovirals for preventing mother-to-child transmission | 2018-03-23 12:44:09 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Estimated percentage of pregnant women living with HIV who received antiretrovirals for preventing mother-to-child transmission 15305 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95188 | Indicator:Congenital syphilis number of reported cases | 2018-03-23 12:44:08 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Congenital syphilis number of reported cases 15294 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95177 | Indicator:Testing and counselling facilities, estimated number per 100 000 adult population | 2018-03-23 12:44:07 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Testing and counselling facilities, estimated number per 100 000 adult population 15288 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95147 | Indicator:Number of deaths due to HIV/AIDS | 2018-03-23 12:44:04 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Number of deaths due to HIV/AIDS 15275 | {} |
0 | 1 | ||||||||||||||||||||||||||||
95108 | Indicator:Testing and counselling facilities, reported number | 2018-03-23 12:44:02 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Testing and counselling facilities, reported number 15252 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94959 | Indicator:Number of pregnant women living with HIV who received antiretrovirals for preventing mother-to-child transmission | 2018-03-23 12:43:50 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Number of pregnant women living with HIV who received antiretrovirals for preventing mother-to-child transmission 15203 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94833 | Indicator:Reported number of children receiving antiretroviral therapy | 2018-03-23 12:43:45 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Reported number of children receiving antiretroviral therapy 15149 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94832 | Indicator:Reported number of children receiving antiretroviral therapy, month and year of report | 2018-03-23 12:43:45 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Reported number of children receiving antiretroviral therapy, month and year of report 15148 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94773 | Indicator:Prevalence of HIV among adults aged 15 to 49 (%) | 2018-03-23 12:43:43 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Prevalence of HIV among adults aged 15 to 49 (%) 15125 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94170 | Indicator:Number of people aged 15 years and over who received HIV testing and counselling, reported number | 2018-03-23 12:42:58 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Number of people aged 15 years and over who received HIV testing and counselling, reported number 15006 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94144 | Indicator:Number of new HIV infections | 2018-03-23 12:42:57 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Number of new HIV infections 14995 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94136 | Indicator:Estimated antiretroviral therapy coverage among children | 2018-03-23 12:42:57 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Estimated antiretroviral therapy coverage among children 14990 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94134 | Indicator:Estimated number of people eligible for antiretroviral therapy according to 2010 guidelines | 2018-03-23 12:42:56 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Estimated number of people eligible for antiretroviral therapy according to 2010 guidelines 14988 | {} |
0 | 1 | ||||||||||||||||||||||||||||
94112 | Indicator:Estimated number of people (all ages) living with HIV | 2018-03-23 12:42:56 | 2023-06-15 05:05:42 | HIV/AIDS and other STIs 2694 | Estimated number of people (all ages) living with HIV 14982 | {} |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "variables" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(750) NULL , "unit" VARCHAR(255) NOT NULL , "description" TEXT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "code" VARCHAR(255) NULL , "coverage" VARCHAR(255) NOT NULL , "timespan" VARCHAR(255) NOT NULL , "datasetId" INTEGER NOT NULL , "sourceId" INTEGER NULL , "shortUnit" VARCHAR(255) NULL , "display" TEXT NOT NULL , "columnOrder" INTEGER NOT NULL DEFAULT '0' , "originalMetadata" TEXT NULL , "grapherConfigAdmin" TEXT NULL , "shortName" VARCHAR(255) NULL , "catalogPath" VARCHAR(767) NULL , "dimensions" TEXT NULL , "schemaVersion" INTEGER NOT NULL DEFAULT '1' , "processingLevel" VARCHAR(30) NULL , "processingLog" TEXT NULL , "titlePublic" VARCHAR(512) NULL , "titleVariant" VARCHAR(255) NULL , "attributionShort" VARCHAR(512) NULL , "attribution" TEXT NULL , "descriptionShort" TEXT NULL , "descriptionFromProducer" TEXT NULL , "descriptionKey" TEXT NULL , "descriptionProcessing" TEXT NULL , "licenses" TEXT NULL , "license" TEXT NULL , "grapherConfigETL" TEXT NULL , "type" TEXT NULL , "sort" TEXT NULL , "dataChecksum" VARCHAR(64) NULL , "metadataChecksum" VARCHAR(64) NULL, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT, FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath"); CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId"); CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId"); CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId"); CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId"); CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");