sources
Data license: CC-BY
1 row where datasetId = 5200 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
| id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
|---|---|---|---|---|---|---|---|---|
| 17930 | Time spent on sports and physical activity - Eurostat & American Time Use Survey | {
"link": "Eurostat: https://ec.europa.eu/eurostat/data/database ; ATUS: https://data.bls.gov/PDQWeb/tu",
"retrievedDate": "16/10/2020",
"additionalInfo": "Data for European countries is taken from Eurostat's <a href=\"https://appsso.eurostat.ec.europa.eu/nui/show.do?query=BOOKMARK_DS-193365_QID_25B95566_UID_-3F171EB0&layout=AGE,L,X,0;GEO,L,Y,0;TIME,C,Z,0;ACL00,L,Z,1;SEX,L,Z,2;UNIT,L,Z,3;INDICATORS,C,Z,4;&zSelection=DS-193365SEX,T;DS-193365UNIT,PTP_TIME;DS-193365ACL00,AC6A;DS-193365INDICATORS,OBS_FLAG;DS-193365TIME,2010;&rankName1=TIME_1_0_-1_2&rankName2=INDICATORS_1_2_-1_2&rankName3=UNIT_1_2_1_0&rankName4=SEX_1_2_0_0&rankName5=ACL00_1_2_0_0&rankName6=AGE_1_2_0_0&rankName7=GEO_1_2_0_1&rStp=&cStp=&rDCh=&cDCh=&rDM=true&cDM=true&footnes=false&empty=false&wai=false&time_mode=ROLLING&time_most_recent=true&lang=EN&cfo=%23%23%23%2C%23%23%23.%23%23%23&eub_bm:tus_00age$DV_167&lang=en\">time spent on sport and physical activity dataset</a> (tus_00age). \nEurostat specifies the average daily time spent on categories of sports and physical activity by all persons aged 15 and over. Eurostat takes its estimates from the Harmonised European Time Use Surveys (HETUS).\nThe time categories for European countries are coded as: \n- Walking and hiking\n- Sports and outdoor activities, except walking and hiking\n- Walking the dog\n\nThe US series is taken from the <a href=\"https://data.bls.gov/PDQWeb/tu\">American Time Use Survey (ATUS)</a>. It details the average time spent on each activity per day by persons aged 15 and over. Figures include all persons irrespective of labor force status, and all days (including both weekdays, weekends, and holidays). \nThe time categories for the US in the ATUS are coded as: \n- Walking (130131)\n- Participating in sports, exercise, or recreation (130100)\n- Walking, exercising, and playing with animals (020602)",
"dataPublishedBy": "Eurostat, US Bureau of Labor Statistics",
"dataPublisherSource": "Survey data"
} |
2020-10-18 20:20:48 | 2020-10-18 20:20:48 | Time spent on sports and physical activity - Eurostat & American Time Use Survey 5200 | Data for European countries is taken from Eurostat's <a href="https://appsso.eurostat.ec.europa.eu/nui/show.do?query=BOOKMARK_DS-193365_QID_25B95566_UID_-3F171EB0&layout=AGE,L,X,0;GEO,L,Y,0;TIME,C,Z,0;ACL00,L,Z,1;SEX,L,Z,2;UNIT,L,Z,3;INDICATORS,C,Z,4;&zSelection=DS-193365SEX,T;DS-193365UNIT,PTP_TIME;DS-193365ACL00,AC6A;DS-193365INDICATORS,OBS_FLAG;DS-193365TIME,2010;&rankName1=TIME_1_0_-1_2&rankName2=INDICATORS_1_2_-1_2&rankName3=UNIT_1_2_1_0&rankName4=SEX_1_2_0_0&rankName5=ACL00_1_2_0_0&rankName6=AGE_1_2_0_0&rankName7=GEO_1_2_0_1&rStp=&cStp=&rDCh=&cDCh=&rDM=true&cDM=true&footnes=false&empty=false&wai=false&time_mode=ROLLING&time_most_recent=true&lang=EN&cfo=%23%23%23%2C%23%23%23.%23%23%23&eub_bm:tus_00age$DV_167&lang=en">time spent on sport and physical activity dataset</a> (tus_00age). Eurostat specifies the average daily time spent on categories of sports and physical activity by all persons aged 15 and over. Eurostat takes its estimates from the Harmonised European Time Use Surveys (HETUS). The time categories for European countries are coded as: - Walking and hiking - Sports and outdoor activities, except walking and hiking - Walking the dog The US series is taken from the <a href="https://data.bls.gov/PDQWeb/tu">American Time Use Survey (ATUS)</a>. It details the average time spent on each activity per day by persons aged 15 and over. Figures include all persons irrespective of labor force status, and all days (including both weekdays, weekends, and holidays). The time categories for the US in the ATUS are coded as: - Walking (130131) - Participating in sports, exercise, or recreation (130100) - Walking, exercising, and playing with animals (020602) | Eurostat: https://ec.europa.eu/eurostat/data/database ; ATUS: https://data.bls.gov/PDQWeb/tu | Eurostat, US Bureau of Labor Statistics |
Advanced export
JSON shape: default, array, newline-delimited, object
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");