owid: sources: 1 row where datasetId = 4188 sorted by id descending

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 = 4188 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
17016	Rhino populations (AfRSG & other sources, 2022)	{ "link": "http://www.rhinoresourcecenter.com/index.php", "retrievedDate": "April 2022", "additionalInfo": "Data was compiled by Our World in Data based on a number of historical sources. Data is based on best estimates: there is greater uncertainty in earlier historical data but is provided as the best estimate of the time. \n\nThe main data source for rhino populations is the African and Asian Rhino Specialist Groups (AfRSG). AfRSG periodically produce the latest estimates of rhino populations in Africa and Asia, in update reports of their status. The available literature from AfRSG can be accessed at: http://www.rhinoresourcecenter.com/index.php?s=1&act=refs.\n\nWhere a range of values are reported in the above document we report the central value. This is only the case for rhino population estimates in Indonesia, Malaysia and Vietnam.\n\nCitation of the latest report is as follows:\nBurgess, Gayle & Ferreira, Sam & Talukdar, Bibhab & Knight, Michael & Baruch-Mordo, Sharon & Ellis, Susie. (2022). African and Asian Rhinoceroses: Status, Conservation and Trade: Report from the IUCN Species Survival Commission (IUCN SSC) African and Asian Rhino Specialist Groups and TRAFFIC (CITES CoP19 Doc 75). \n\nWhere estimates from AfRSG is available, we have used its data. However, we have also combined these statistics with earlier estimates from multiple academic sources. These include:\n\nPusparini, W., Sievert, P. R., Fuller, T. K., Randhir, T. O., & Andayani, N. (2015). Rhinos in the parks: an island-wide survey of the last wild population of the Sumatran rhinoceros. PloS one, 10(9), e0136643.\n\nFor values before 1998: \nEmslie, R. and Brooks, M. (1999) African Rhino. Status Survey and Conservation Action Plan. IUCN/SSC African Rhino Specialist Group. IUCN, Gland, Switzerland and Cambridge, UK. ix + 92 pp. Available at: http://www.rhinoresourcecenter.com/pdf_files/117/1175863242.pdf\n\nThapa, K., Nepal, S., Thapa, G., Bhatta, S. R., & Wikramanayake, E. (2013). Past, present and future conservation of the greater one-horned rhinoceros Rhinoceros unicornis in Nepal. Oryx, 47(3), 345-351.\n\nWe also include estimates from the State of the Rhino Report (2020 and 2022)\n2022 - https://rhinos.org/wp-content/uploads/2022/09/IRF-State-of-the-Rhino-2022.pdf", "dataPublishedBy": "IUCN Species Survival Commission (IUCN/SSC) African and Asian Rhino Specialist Groups (AfRSG) & other sources" }	2019-08-15 16:03:16	2019-08-15 16:03:16	Rhino populations (AfRSG & other sources, 2022) 4188	Data was compiled by Our World in Data based on a number of historical sources. Data is based on best estimates: there is greater uncertainty in earlier historical data but is provided as the best estimate of the time. The main data source for rhino populations is the African and Asian Rhino Specialist Groups (AfRSG). AfRSG periodically produce the latest estimates of rhino populations in Africa and Asia, in update reports of their status. The available literature from AfRSG can be accessed at: http://www.rhinoresourcecenter.com/index.php?s=1&act=refs. Where a range of values are reported in the above document we report the central value. This is only the case for rhino population estimates in Indonesia, Malaysia and Vietnam. Citation of the latest report is as follows: Burgess, Gayle & Ferreira, Sam & Talukdar, Bibhab & Knight, Michael & Baruch-Mordo, Sharon & Ellis, Susie. (2022). African and Asian Rhinoceroses: Status, Conservation and Trade: Report from the IUCN Species Survival Commission (IUCN SSC) African and Asian Rhino Specialist Groups and TRAFFIC (CITES CoP19 Doc 75). Where estimates from AfRSG is available, we have used its data. However, we have also combined these statistics with earlier estimates from multiple academic sources. These include: Pusparini, W., Sievert, P. R., Fuller, T. K., Randhir, T. O., & Andayani, N. (2015). Rhinos in the parks: an island-wide survey of the last wild population of the Sumatran rhinoceros. PloS one, 10(9), e0136643. For values before 1998: Emslie, R. and Brooks, M. (1999) African Rhino. Status Survey and Conservation Action Plan. IUCN/SSC African Rhino Specialist Group. IUCN, Gland, Switzerland and Cambridge, UK. ix + 92 pp. Available at: http://www.rhinoresourcecenter.com/pdf_files/117/1175863242.pdf Thapa, K., Nepal, S., Thapa, G., Bhatta, S. R., & Wikramanayake, E. (2013). Past, present and future conservation of the greater one-horned rhinoceros Rhinoceros unicornis in Nepal. Oryx, 47(3), 345-351. We also include estimates from the State of the Rhino…	http://www.rhinoresourcecenter.com/index.php	IUCN Species Survival Commission (IUCN/SSC) African and Asian Rhino Specialist Groups (AfRSG) & other sources

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