Bad Teeth, Sugar And Government Health Spending
Thanks to Gapminder Data
@kaggle.angelmm_healthteethsugar
Thanks to Gapminder Data
@kaggle.angelmm_healthteethsugar
If you get richer your teeth could get worse (if you eat more sugar foods) or better (because of better health assistance or, even, more education and health-conciousness). These variables can be analysed with these data, downloaded from Gapminder Data:
CREATE TABLE adultliteracy (
"adult_15_literacy_rate_total" VARCHAR -- Adult..15...literacy.rate......Total,
"x1975" DOUBLE,
"x1976" DOUBLE,
"x1977" DOUBLE,
"x1978" DOUBLE,
"x1979" DOUBLE,
"x1980" DOUBLE,
"x1981" DOUBLE,
"x1982" DOUBLE,
"x1983" DOUBLE,
"x1984" DOUBLE,
"x1985" DOUBLE,
"x1986" DOUBLE,
"x1987" DOUBLE,
"x1988" DOUBLE,
"x1989" DOUBLE,
"x1990" DOUBLE,
"x1991" DOUBLE,
"x1992" DOUBLE,
"x1993" DOUBLE,
"x1994" DOUBLE,
"x1995" DOUBLE,
"x1996" DOUBLE,
"x1997" DOUBLE,
"x1998" DOUBLE,
"x1999" DOUBLE,
"x2000" DOUBLE,
"x2001" DOUBLE,
"x2002" DOUBLE,
"x2003" DOUBLE,
"x2004" DOUBLE,
"x2005" DOUBLE,
"x2006" DOUBLE,
"x2007" DOUBLE,
"x2008" DOUBLE,
"x2009" DOUBLE,
"x2010" DOUBLE,
"x2011" DOUBLE
);CREATE TABLE badteeth (
"na" VARCHAR -- NA.,
"x2004" DOUBLE,
"na_1" VARCHAR -- NA..1,
"na_2" VARCHAR -- NA..2,
"na_3" VARCHAR -- NA..3
);CREATE TABLE gdp (
"income_per_person_fixed_2000_us" VARCHAR -- Income.per.person..fixed.2000.US..,
"x1960" DOUBLE,
"x1961" DOUBLE,
"x1962" DOUBLE,
"x1963" DOUBLE,
"x1964" DOUBLE,
"x1965" DOUBLE,
"x1966" DOUBLE,
"x1967" DOUBLE,
"x1968" DOUBLE,
"x1969" DOUBLE,
"x1970" DOUBLE,
"x1971" DOUBLE,
"x1972" DOUBLE,
"x1973" DOUBLE,
"x1974" DOUBLE,
"x1975" DOUBLE,
"x1976" DOUBLE,
"x1977" DOUBLE,
"x1978" DOUBLE,
"x1979" DOUBLE,
"x1980" DOUBLE,
"x1981" DOUBLE,
"x1982" DOUBLE,
"x1983" DOUBLE,
"x1984" DOUBLE,
"x1985" DOUBLE,
"x1986" DOUBLE,
"x1987" DOUBLE,
"x1988" DOUBLE,
"x1989" DOUBLE,
"x1990" DOUBLE,
"x1991" DOUBLE,
"x1992" DOUBLE,
"x1993" DOUBLE,
"x1994" DOUBLE,
"x1995" DOUBLE,
"x1996" DOUBLE,
"x1997" DOUBLE,
"x1998" DOUBLE,
"x1999" DOUBLE,
"x2000" DOUBLE,
"x2001" DOUBLE,
"x2002" DOUBLE,
"x2003" DOUBLE,
"x2004" DOUBLE,
"x2005" DOUBLE,
"x2006" DOUBLE,
"x2007" DOUBLE,
"x2008" DOUBLE,
"x2009" DOUBLE,
"x2010" DOUBLE,
"x2011" DOUBLE
);CREATE TABLE healthexpend (
"per_capita_government_expenditure_on_health_at_average_b3fd9a58" VARCHAR -- Per.capita.government.expenditure.on.health.at.average.exchange.rate..US..,
"x1995" DOUBLE,
"x1996" DOUBLE,
"x1997" DOUBLE,
"x1998" DOUBLE,
"x1999" DOUBLE,
"x2000" DOUBLE,
"x2001" DOUBLE,
"x2002" DOUBLE,
"x2003" DOUBLE,
"x2004" DOUBLE,
"x2005" DOUBLE,
"x2006" DOUBLE,
"x2007" DOUBLE,
"x2008" DOUBLE,
"x2009" DOUBLE,
"x2010" DOUBLE
);CREATE TABLE sugar_consumption (
"na" VARCHAR -- NA.,
"x1961" DOUBLE,
"x1962" DOUBLE,
"x1963" DOUBLE,
"x1964" DOUBLE,
"x1965" DOUBLE,
"x1966" DOUBLE,
"x1967" DOUBLE,
"x1968" DOUBLE,
"x1969" DOUBLE,
"x1970" DOUBLE,
"x1971" DOUBLE,
"x1972" DOUBLE,
"x1973" DOUBLE,
"x1974" DOUBLE,
"x1975" DOUBLE,
"x1976" DOUBLE,
"x1977" DOUBLE,
"x1978" DOUBLE,
"x1979" DOUBLE,
"x1980" DOUBLE,
"x1981" DOUBLE,
"x1982" DOUBLE,
"x1983" DOUBLE,
"x1984" DOUBLE,
"x1985" DOUBLE,
"x1986" DOUBLE,
"x1987" DOUBLE,
"x1988" DOUBLE,
"x1989" DOUBLE,
"x1990" DOUBLE,
"x1991" DOUBLE,
"x1992" DOUBLE,
"x1993" DOUBLE,
"x1994" DOUBLE,
"x1995" DOUBLE,
"x1996" DOUBLE,
"x1997" DOUBLE,
"x1998" DOUBLE,
"x1999" DOUBLE,
"x2000" DOUBLE,
"x2001" DOUBLE,
"x2002" DOUBLE,
"x2003" DOUBLE,
"x2004" DOUBLE,
"na_1" VARCHAR -- NA..1
);Anyone who has the link will be able to view this.