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

2 rows where datasetId = 6080 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
29989 YouGov 
{
    "link": "https://today.yougov.com/topics/politics/trackers/worry-about-automation",
    "retrievedDate": "2023-06-08",
    "additionalInfo": "\nBiannual tracking of Americans' level of concern regarding job automation replacing their employment. The provided results are weighted to ensure they are representative of the United States population across various demographic factors.\n\nThe weighting is based on factors such as age, gender, race, education, region, political party affiliation, and income level. This weighting process helps to account for the diversity within the population and ensures that the results reflect a broader representation of the United States as a whole. Next update in January. Each wave comprises responses from 460 to 495 working US adults.\n",
    "dataPublishedBy": "YouGov (2023)"
}
 2024-02-02 04:03:43 2024-02-02 04:03:45 How worried are Americans about being automated out of a job? (YouGov, June 2023) 6080 Biannual tracking of Americans' level of concern regarding job automation replacing their employment. The provided results are weighted to ensure they are representative of the United States population across various demographic factors. The weighting is based on factors such as age, gender, race, education, region, political party affiliation, and income level. This weighting process helps to account for the diversity within the population and ensures that the results reflect a broader representation of the United States as a whole. Next update in January. Each wave comprises responses from 460 to 495 working US adults. https://today.yougov.com/topics/politics/trackers/worry-about-automation YouGov (2023)
29987 YouGov 
{
    "link": "https://today.yougov.com/topics/politics/trackers/worry-about-automation",
    "retrievedDate": "2023-06-08",
    "additionalInfo": "Biannual tracking of Americans' level of concern regarding job automation replacing their employment. The provided results are weighted to ensure they are representative of the United States population across various demographic factors.\n\nThe weighting is based on factors such as age, gender, race, education, region, political party affiliation, and income level. This weighting process helps to account for the diversity within the population and ensures that the results reflect a broader representation of the United States as a whole. Next update in January. Each wave comprises responses from 460 to 495 working US adults.\n",
    "dataPublishedBy": "YouGov (2023)"
}
 2024-02-02 04:03:43 2024-02-02 04:03:43 How worried are Americans about being automated out of a job? (YouGov, June 2023) 6080 Biannual tracking of Americans' level of concern regarding job automation replacing their employment. The provided results are weighted to ensure they are representative of the United States population across various demographic factors. The weighting is based on factors such as age, gender, race, education, region, political party affiliation, and income level. This weighting process helps to account for the diversity within the population and ensures that the results reflect a broader representation of the United States as a whole. Next update in January. Each wave comprises responses from 460 to 495 working US adults. https://today.yougov.com/topics/politics/trackers/worry-about-automation YouGov (2023)

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