sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 4902 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
17633 UN Population Division (2013) 
{
    "link": "Table A.2: https://www.un.org/en/development/desa/population/publications/pdf/technical/TP2013-2.pdf",
    "retrievedDate": "16/01/20",
    "additionalInfo": "The estimates and projections of the number of women of reproductive age (15 to 49 years) who are married or in a union were prepared based on data from individual countries on an age-specific basis (for five-year age groups 15-19 to 45-49).\n\nFor the purpose of this data, women who are currently married or in a union are either (i) women who have been married and are not divorced, widowed or separated; or (ii) women who are living in a cohabiting union.\n\nThe question usually asked in censuses and surveys is on the marital status or union status of an individual.\n\nThe definitions of marital status and union status of individuals differ by the source of data, country and time period. For example, in the United Nations principles and recommendations for census taking, only registered partnerships and consensual unions that are legal and binding under law should be reported. However, there is considerable variation among the definitions and terminology used in surveys. The Demographic and Health Surveys, one of the major sources of data on marital and union status, ask individuals whether they are married or \u2018living together\u2019 with a partner; however, in countries with low prevalence of cohabiting unions, the survey question is normally limited only to marriage.\n\nFor a breakdown of countries by region see the UN Methodology page <a href=\"https://unstats.un.org/unsd/methodology/m49/overview/\">here</a>.\n\n<strong>Data is estimated until 2010, and projected for 2020 and 2030. </strong>",
    "dataPublishedBy": "Vladim\u00edra Kantorov\u00e1, UN Population Division (2013). National, Regional and Global Estimates and Projections of the Number of Women Aged 15 to 49 Who Are Married or in a Union, 1970-2030. Technical Paper No. 2013/2. ",
    "dataPublisherSource": "Census, surveys"
}
 2020-01-16 20:43:05 2020-01-16 20:43:05 Estimated percent of women who are married or in a union (UN) 4902 The estimates and projections of the number of women of reproductive age (15 to 49 years) who are married or in a union were prepared based on data from individual countries on an age-specific basis (for five-year age groups 15-19 to 45-49). For the purpose of this data, women who are currently married or in a union are either (i) women who have been married and are not divorced, widowed or separated; or (ii) women who are living in a cohabiting union. The question usually asked in censuses and surveys is on the marital status or union status of an individual. The definitions of marital status and union status of individuals differ by the source of data, country and time period. For example, in the United Nations principles and recommendations for census taking, only registered partnerships and consensual unions that are legal and binding under law should be reported. However, there is considerable variation among the definitions and terminology used in surveys. The Demographic and Health Surveys, one of the major sources of data on marital and union status, ask individuals whether they are married or ‘living together’ with a partner; however, in countries with low prevalence of cohabiting unions, the survey question is normally limited only to marriage. For a breakdown of countries by region see the UN Methodology page <a href="https://unstats.un.org/unsd/methodology/m49/overview/">here</a>. <strong>Data is estimated until 2010, and projected for 2020 and 2030. </strong> Table A.2: https://www.un.org/en/development/desa/population/publications/pdf/technical/TP2013-2.pdf Vladimíra Kantorová, UN Population Division (2013). National, Regional and Global Estimates and Projections of the Number of Women Aged 15 to 49 Who Are Married or in a Union, 1970-2030. Technical Paper No. 2013/2.

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");