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 = 4890 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
17621 OECD Family Database 
{
    "link": "http://www.oecd.org/els/family/database.htm",
    "retrievedDate": "9/1/2020",
    "additionalInfo": "Data for Australia, Japan, Korea and New Zealand refer to ex-nuptial/out-of-wedlock births, that is, where the child's parents are not registered as married to each other (or, for New Zealand only, in a civil union with each other) at the time of the birth. For all other countries, data refer to births to mothers where the mother's marital status at the time of birth was other than married. For Canada, births to mothers whose marital status is other than married as a proportion of births where the mother's marital status is recorded. In 2017, the mother's marital status was not recorded on 8% of births. For Mexico, births to mothers whose civil status is other than married as a proportion of births where the mother's civil status is recorded. In 2017, the mother's civil status was not recorded on 8% of births. For Israel, data refer to births to unmarried Jewish women as a proportion of all births to Jewish women, only.",
    "dataPublishedBy": "OECD Family Database",
    "dataPublisherSource": "For European countries, Eurostat Demographic Statistics; for Australia, Australian Bureau of Statistics; for Canada, Statistics Canada; for Chile, INE; for Costa Rica, INEC; for Israel, Central Bureau of Statistics; for Japan, Ministry of Health, Labour and Welfare; for Korea, Korean Statistical Information Service; for Mexico, INEGI; for New Zealand, Statistics New Zealand; for the United States, Centres for Disease Control and Prevention."
}
 2020-01-09 19:51:10 2020-01-09 19:51:10 Births outside of marriage 4890 Data for Australia, Japan, Korea and New Zealand refer to ex-nuptial/out-of-wedlock births, that is, where the child's parents are not registered as married to each other (or, for New Zealand only, in a civil union with each other) at the time of the birth. For all other countries, data refer to births to mothers where the mother's marital status at the time of birth was other than married. For Canada, births to mothers whose marital status is other than married as a proportion of births where the mother's marital status is recorded. In 2017, the mother's marital status was not recorded on 8% of births. For Mexico, births to mothers whose civil status is other than married as a proportion of births where the mother's civil status is recorded. In 2017, the mother's civil status was not recorded on 8% of births. For Israel, data refer to births to unmarried Jewish women as a proportion of all births to Jewish women, only. http://www.oecd.org/els/family/database.htm OECD Family Database

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");