variables
Data license: CC-BY
3 rows where sourceId = 15531 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97494 | Literacy rate, adult female (% of total respondents) (DHS Surveys) | % | The female adult literacy rate is defined as the percentage of female survey respondents, aged 15 and above, who can read. Variable (M)V155 has been used to calculate literacy rates. The 155 literacy variable indicates whether a respondent who attended primary schooling can read a whole or part of a sentence showed. A respondent who attended secondary education or higher are coded 2 as well as respondent who could read a whole sentence. Possible categories include: 0 - cannot read at all; 1 - able to read only parts of sentence; 2 - able to read whole sentence; 3 - no card with required language; 4 - blind/visually impaired. Our estimates exclude those in categories 3 and 4. The female adult literacy rate has been calculated as the total number of female respondents who are in categories 1 or 2, divided by the total number of respondents by country, per year. | 2018-05-16 14:45:15 | 2023-06-15 05:05:42 | Literacy rate (% of total respondents) - DHS Surveys 2794 | DHS Surveys 15531 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97493 | Literacy rate, adult male (% of total respondents) (DHS Surveys) | % | The adult male literacy rate is defined as the percentage of male survey respondents, aged 15 and above, who can read. Variable (M)V155 has been used to calculate literacy rates. The 155 literacy variable indicates whether a respondent who attended primary schooling can read a whole or part of a sentence showed. A respondent who attended secondary education or higher are coded 2 as well as respondent who could read a whole sentence. Possible categories include: 0 - cannot read at all; 1 - able to read only parts of sentence; 2 - able to read whole sentence; 3 - no card with required language; 4 - blind/visually impaired. Our estimates exclude those in categories 3 and 4. The male adult literacy rate has been calculated as the total number of male respondents who are in categories 1 or 2, divided by the total number of respondents by country, per year. | 2018-05-16 14:45:15 | 2023-06-15 05:05:42 | Literacy rate (% of total respondents) - DHS Surveys 2794 | DHS Surveys 15531 | {} |
0 | 1 | ||||||||||||||||||||||||||
| 97492 | Literacy rate, adult total (% of total respondents) (DHS Surveys) | % | The adult literacy rate is defined as the percentage of survey respondents, aged 15 and above, who can read. Variable (M)V155 has been used to calculate literacy rates. The 155 literacy variable indicates whether a respondent who attended primary schooling can read a whole or part of a sentence showed. A respondent who attended secondary education or higher are coded 2 as well as respondent who could read a whole sentence. Possible categories include: 0 - cannot read at all; 1 - able to read only parts of sentence; 2 - able to read whole sentence; 3 - no card with required language; 4 - blind/visually impaired. Our estimates exclude those in categories 3 and 4. The adult literacy rate has been calculated as the total number of respondents who are in categories 1 or 2, divided by the total number of respondents by country, per year. | 2018-05-16 14:45:14 | 2023-06-15 05:05:42 | Literacy rate (% of total respondents) - DHS Surveys 2794 | DHS Surveys 15531 | {} |
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");