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 = 2511 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
14730 Mental health services across incomes - Wang et al. (2007) 
{
    "link": "https://www.sciencedirect.com/science/article/pii/S0140673607614147",
    "retrievedDate": "13th March 2018",
    "additionalInfo": "Data is available only for a small number of countries, and based on household surveys over the period 2001-2004.\n\n'Share receiving any treatment for mental health' refers to the percentage of total respondents (with or without mental health burden) who received any form of treatment in the last 12 months.\n\nIn differentiating the share of people with particular severities of mental illness receiving treatment, the authors define the following categories:\n- 'Severe' = \"bipolar I disorder or substance dependence with a physiological dependence syndrome, making a suicide attempt in conjunction with any other disorder, reporting severe role impairment due to a mental disorder in at least two areas of functioning measured by disorder-specific Sheehan Disability Scales (SDS),12 or having overall functional impairment from any disorder consistent with a Global Assessment of Functioning (GAF)13 score of 50 or less.\"\n\n- 'Moderate' = \"substance dependence without a physiological dependence syndrome or at least moderate interference in any SDS domain\"\n\n- 'Mild' = all other disorders not noted above.\n\nMental health services were classified into the following sectors: \n- mental health specialty (psychiatrist, psychologist, other mental health professional in any setting, social worker or counsellor in a mental health specialty setting, use of a mental health hotline); \n- general medical (primary care doctor, other general medical doctor, nurse, any other health professional not previously mentioned); \n- human services (religious or spiritual advisor, social worker, or counsellor in any setting other than a specialty mental health setting);\n- complementary and alternative medicine (any other type of healer such as chiropractors, participation in an internet support group, participation in a self-help group).",
    "dataPublishedBy": "Wang, P. S., Aguilar-Gaxiola, S., Alonso, J., Angermeyer, M. C., Borges, G., Bromet, E. J., ... & Haro, J. M. (2007). Use of mental health services for anxiety, mood, and substance disorders in 17 countries in the WHO world mental health surveys. The Lancet, 370(9590), 841-850.",
    "dataPublisherSource": "Face-to-face household surveys"
}
 2018-03-13 13:42:29 2018-03-13 13:42:29 Mental health services across incomes - Wang et al. (2007) 2511 Data is available only for a small number of countries, and based on household surveys over the period 2001-2004. 'Share receiving any treatment for mental health' refers to the percentage of total respondents (with or without mental health burden) who received any form of treatment in the last 12 months. In differentiating the share of people with particular severities of mental illness receiving treatment, the authors define the following categories: - 'Severe' = "bipolar I disorder or substance dependence with a physiological dependence syndrome, making a suicide attempt in conjunction with any other disorder, reporting severe role impairment due to a mental disorder in at least two areas of functioning measured by disorder-specific Sheehan Disability Scales (SDS),12 or having overall functional impairment from any disorder consistent with a Global Assessment of Functioning (GAF)13 score of 50 or less." - 'Moderate' = "substance dependence without a physiological dependence syndrome or at least moderate interference in any SDS domain" - 'Mild' = all other disorders not noted above. Mental health services were classified into the following sectors: - mental health specialty (psychiatrist, psychologist, other mental health professional in any setting, social worker or counsellor in a mental health specialty setting, use of a mental health hotline); - general medical (primary care doctor, other general medical doctor, nurse, any other health professional not previously mentioned); - human services (religious or spiritual advisor, social worker, or counsellor in any setting other than a specialty mental health setting); - complementary and alternative medicine (any other type of healer such as chiropractors, participation in an internet support group, participation in a self-help group). https://www.sciencedirect.com/science/article/pii/S0140673607614147 Wang, P. S., Aguilar-Gaxiola, S., Alonso, J., Angermeyer, M. C., Borges, G., Bromet, E. J., ... & Haro, J. M. (2007). Use of mental health services for anxiety, mood, and substance disorders in 17 countries in the WHO world mental health surveys. The Lancet, 370(9590), 841-850.

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