The Global Human Day
Estimates how all in the world humans spend their time
@kaggle.joebeachcapital_the_global_human_day
Estimates how all in the world humans spend their time
@kaggle.joebeachcapital_the_global_human_day
The daily activities of ≈ 8 billion people occupy exactly 24 h per day, placing a strict physical limit on what changes can be achieved in the world. These activities form the basis of human behavior, and because of the global integration of societies and economies, many of these activities interact across national borders. This project estimates how all humans spend their time using a generalized, physical outcome–based categorization that facilitates the integration of data from hundreds of diverse datasets.
CREATE TABLE all_countries (
"category" VARCHAR,
"subcategory" VARCHAR,
"country_iso3" VARCHAR,
"region_code" VARCHAR,
"population" BIGINT,
"hoursperdaycombined" DOUBLE,
"uncertaintycombined" DOUBLE
);
CREATE TABLE country_regions (
"region_code" VARCHAR,
"region_name" VARCHAR,
"country_name" VARCHAR,
"m49_code" BIGINT,
"country_iso2" VARCHAR,
"country_iso3" VARCHAR,
"alt_country_name" VARCHAR,
"alt_country_name1" VARCHAR,
"alt_country_name2" VARCHAR,
"alt_country_name3" VARCHAR,
"alt_country_name4" VARCHAR,
"alt_country_name5" VARCHAR,
"alt_country_name6" VARCHAR,
"other_code1" VARCHAR,
"other_code2" VARCHAR
);
CREATE TABLE global_economic_activity (
"subcategory" VARCHAR,
"hoursperday" DOUBLE,
"uncertainty" DOUBLE
);
CREATE TABLE global_human_day (
"subcategory" VARCHAR,
"hoursperday" DOUBLE,
"uncertainty" DOUBLE
);
Anyone who has the link will be able to view this.