sources
Data license: CC-BY
1 row where datasetId = 3271 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
16775 | Sex ratio at birth (Chao et al. 2019) | { "link": "https://www.pnas.org/content/early/2019/04/09/1812593116", "retrievedDate": "16th April 2019", "additionalInfo": "Sex ratio at birth, measured as the number of male births per 100 female births. Birth ratios are slightly male-biased, with an expected biological ratio of 105 male per 100 female births.\n\nData is available for every country from 1950, with modelled estimates based on a range of sources (census, household surveys and other population information sources) by the study authors.", "dataPublishedBy": "Chao, F., Gerland, P., Cook, A.R., Alkema, L. (2019). Systematic assessment of the sex ratio at birth for all countries and estimation of national imbalances and regional reference levels. PNAS. " } |
2019-04-16 18:06:37 | 2019-04-16 18:06:37 | Sex ratio at birth (Chao et al. 2019) 3271 | Sex ratio at birth, measured as the number of male births per 100 female births. Birth ratios are slightly male-biased, with an expected biological ratio of 105 male per 100 female births. Data is available for every country from 1950, with modelled estimates based on a range of sources (census, household surveys and other population information sources) by the study authors. | https://www.pnas.org/content/early/2019/04/09/1812593116 | Chao, F., Gerland, P., Cook, A.R., Alkema, L. (2019). Systematic assessment of the sex ratio at birth for all countries and estimation of national imbalances and regional reference levels. PNAS. |
Advanced export
JSON shape: default, array, newline-delimited, object
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");