sources

Data license: CC-BY

1 row where datasetId = 5300 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "link": "https://stats.oecd.org/viewhtml.aspx?datasetcode=HEALTH_PHMC",
    "retrievedDate": "20th April 2021",
    "additionalInfo": "The OECD reports the consumption of antidepressants in terms of daily defined doses per 1,000 people. \n\nThis estimates of the daily intake of antidepressants per 1000 people, calculated as the 'defined daily dose' \u2013 the expected doses of antidepressants taken per 1000 people per day, according to the recommended dosages for each antidepressant. This enables us to compare overall levels of drug consumption, accounting for the fact that different antidepressants have different recommended dosages.",
    "dataPublishedBy": "Organisation for Economic Co-operation and Development (OECD)"
}

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