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 = 5535 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
21933 Stockholm International Peace Research Institute 
{
    "link": "https://www.sipri.org/databases/milex",
    "retrievedDate": "24 February 2022",
    "additionalInfo": "The SIPRI Military Expenditure Database contains consistent time series on the military spending of countries since 1949. The database is updated annually.\n\nMilitary expenditure figures are adjusted for inflation and expressed in constant (2019) US Dollars.\n\nThe availability of data varies considerably by country, but for a majority of countries that were independent at the time, data is available from at least the late 1950s. Estimates for regional military expenditure have been extended backward depending on the availability of data for countries in the region, but no estimates for total world military expenditure are available before 1988 due to the lack of data for the Soviet Union.\n\nSIPRI military expenditure data is based on open sources only.",
    "dataPublishedBy": "SIPRI Military Expenditure Database, Stockholm International Peace Research Institute (SIPRI)"
}
 2022-02-25 11:15:22 2022-02-25 11:15:22 SIPRI Military Expenditure Database 5535 The SIPRI Military Expenditure Database contains consistent time series on the military spending of countries since 1949. The database is updated annually. Military expenditure figures are adjusted for inflation and expressed in constant (2019) US Dollars. The availability of data varies considerably by country, but for a majority of countries that were independent at the time, data is available from at least the late 1950s. Estimates for regional military expenditure have been extended backward depending on the availability of data for countries in the region, but no estimates for total world military expenditure are available before 1988 due to the lack of data for the Soviet Union. SIPRI military expenditure data is based on open sources only. https://www.sipri.org/databases/milex SIPRI Military Expenditure Database, Stockholm International Peace Research Institute (SIPRI)

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