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 = 4906 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
17637 Gallup (2017) 
{
    "link": "https://news.gallup.com/poll/212702/lgbt-adults-married-sex-spouse.aspx",
    "retrievedDate": "22 February 2020",
    "additionalInfo": "Survey method notes from the source:\n\n<em> Results for this Gallup poll are based on telephone interviews conducted June 20, 2016-June 19, 2017, on the Gallup U.S. Daily survey, with a random sample of 352,851 adults, aged 18 and older, living in all 50 U.S. states and the District of Columbia. For results based on the total sample of national adults, the margin of sampling error is \u00b11 percentage point at the 95% confidence level.\n\nFor results based on the total sample of 12,832 lesbian, gay, bisexual or transgender adults, the margin of sampling error is \u00b11 percentage point at the 95% confidence level. All reported margins of sampling error include computed design effects for weighting.\n\nEach sample of national adults includes a minimum quota of 70% cellphone respondents and 30% landline respondents, with additional minimum quotas by time zone within region. Landline and cellular telephone numbers are selected using random-digit-dial methods. </em>",
    "dataPublishedBy": "Gallup News, Social and Policy Issues, June 22, 2017",
    "dataPublisherSource": "Gallup U.S. Daily survey"
}
 2020-01-22 16:07:46 2020-01-22 16:07:46 LGBT Marital Status in the US (Gallup 2017) 4906 Survey method notes from the source: <em> Results for this Gallup poll are based on telephone interviews conducted June 20, 2016-June 19, 2017, on the Gallup U.S. Daily survey, with a random sample of 352,851 adults, aged 18 and older, living in all 50 U.S. states and the District of Columbia. For results based on the total sample of national adults, the margin of sampling error is ±1 percentage point at the 95% confidence level. For results based on the total sample of 12,832 lesbian, gay, bisexual or transgender adults, the margin of sampling error is ±1 percentage point at the 95% confidence level. All reported margins of sampling error include computed design effects for weighting. Each sample of national adults includes a minimum quota of 70% cellphone respondents and 30% landline respondents, with additional minimum quotas by time zone within region. Landline and cellular telephone numbers are selected using random-digit-dial methods. </em> https://news.gallup.com/poll/212702/lgbt-adults-married-sex-spouse.aspx Gallup News, Social and Policy Issues, June 22, 2017

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