Health Nutrition And Population Statistics

Examining Global Health, Population & Nutrition Trends

@kaggle.sazidthe1_health_nutrition_and_population_statistics

Table List

1 table(27.18 MB)

Health Nutrition Population Statistics

@kaggle.sazidthe1_health_nutrition_and_population_statistics.health_nutrition_population_statistics

27.18 MB
125020 rows
67 columns

country_name Country Name	country_code Country Code	indicator_name Indicator Name	indicator_code Indicator Code	n_1960 1960	n_1961 1961	n_1962 1962	n_1963 1963	n_1964 1964	n_1965 1965	n_1966 1966	n_1967 1967	n_1968 1968	n_1969 1969	n_1970 1970	n_1971 1971	n_1972 1972	n_1973 1973	n_1974 1974	n_1975 1975	n_1976 1976	n_1977 1977	n_1978 1978	n_1979 1979	n_1980 1980	n_1981 1981	n_1982 1982	n_1983 1983	n_1984 1984	n_1985 1985	n_1986 1986	n_1987 1987	n_1988 1988	n_1989 1989	n_1990 1990	n_1991 1991	n_1992 1992	n_1993 1993	n_1994 1994	n_1995 1995	n_1996 1996	n_1997 1997	n_1998 1998	n_1999 1999	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022
Afghanistan	AFG	Adolescent fertility rate (births per 1,000 women ages 15-19)	SP.ADO.TFRT	138.876	138.717	138.494	138.173	140.107	140.935	142.821	143.154	142.341	141.28	140.861	142.301	142.809	142.874	142.713	142.241	141.602	141.159	141.317	138.594	136.482	133.836	131.855	132.271	133.815	134.862	134.459	134.501	138.05	140.807	142.96	147.525	147.521	147.896	155.669	156.77	154.932	156.444	154.262	154.416	152.572	150.863	148.141	143.37	138.827	133.071	126.106	125.858	128.171	120.635	120.82	116.454	111.286	106.537	101.454	97.415	94.018	90.342	88.431	86.803	84.296	82.565
Afghanistan	AFG	Adults (ages 15+) and children (0-14 years) living with HIV	SH.HIV.TOTL																															500	500	550	670	800	930	1000	1200	1300	1500	1700	1900	2200	2400	2700	3000	3200	3500	3800	4100	4400	4800	5400	5900	6400	6900	7500	8000	8700	9400	10000	11000
Afghanistan	AFG	Adults (ages 15+) and children (ages 0-14) newly infected with HIV	SH.HIV.INCD.TL																															100	100	200	200	200	200	200	500	500	500	500	500	500	500	500	500	510	550	590	630	660	700	810	830	880	990	1000	1000	1200	1300	1300	1500
Afghanistan	AFG	Adults (ages 15+) living with HIV	SH.DYN.AIDS																															500	500	530	640	770	890	990	1100	1200	1400	1600	1800	2000	2300	2500	2800	3000	3300	3500	3800	4200	4500	5000	5500	6000	6600	7100	7600	8200	8900	9600	10000
Afghanistan	AFG	Adults (ages 15-49) newly infected with HIV	SH.HIV.INCD																															100	100	200	200	200	200	200	200	500	500	500	500	500	500	500	500	500	500	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1100	1100	1300
Afghanistan	AFG	Age at first marriage, female	SP.DYN.SMAM.FE														18.1						17.8																															21.5	21.2				21.5
Afghanistan	AFG	Age at first marriage, male	SP.DYN.SMAM.MA														26						25.3																																				24.7
Afghanistan	AFG	Age dependency ratio (% of working-age population)	SP.POP.DPND	80.05111405	80.22234036	80.40194284	80.71531767	81.21955708	81.99481518	82.95472205	83.90807343	84.84414984	85.76082364	86.64480199	87.4931472	88.31357474	89.10825595	89.8921779	90.65687103	91.39637484	92.11993802	92.82450905	93.50762132	94.16497342	94.79133071	95.36895164	95.83013393	96.24427069	96.65471398	97.07749903	97.49192929	97.91601741	98.3606926	98.89048802	99.55700704	100.3021951	101.0721158	101.9883012	103.0284654	104.1438958	105.2886632	106.4190125	107.4724722	108.3466346	108.9898856	109.3471569	109.4475325	109.2868198	107.9646046	106.3261911	108.3381249	109.2403785	106.8457744	105.4334164	102.585972	99.30035987	97.12553365	94.7066971	93.04244766	92.01212492	90.54309411	89.09145113	87.64932155	85.9595496	84.59925702	83.57035951
Afghanistan	AFG	Age dependency ratio, old	SP.POP.DPND.OL	5.100901063	5.078087919	5.049558481	5.022020416	4.99971913	4.985287472	4.9791624	4.976930721	4.976000228	4.974508197	4.970392427	4.967781434	4.965033507	4.959390583	4.956236366	4.956795799	4.962227563	4.965320198	4.956994415	4.934795482	4.901788059	4.865839052	4.815528054	4.755125968	4.674756914	4.576091914	4.508390906	4.473853274	4.457401908	4.462199715	4.468230756	4.482376298	4.514652999	4.554424653	4.593353536	4.628650921	4.66324768	4.693863585	4.718492836	4.741467286	4.760314251	4.775097884	4.79160891	4.804548051	4.806580158	4.781964308	4.750411084	4.803680825	4.849388368	4.830453701	4.834730209	4.809148811	4.767237123	4.737487477	4.690796787	4.644245638	4.606350887	4.57268661	4.551607034	4.53690098	4.494552727	4.437871825	4.395300155
Afghanistan	AFG	Age dependency ratio, young	SP.POP.DPND.YG	74.95021298	75.14425245	75.35238435	75.69329726	76.21983795	77.00952771	77.97555965	78.93114271	79.86814961	80.78631544	81.67440956	82.52536577	83.34854123	84.14886536	84.93594153	85.70007523	86.43414728	87.15461783	87.86751463	88.57282584	89.26318536	89.92549165	90.55342358	91.07500796	91.56951377	92.07862207	92.56910813	93.01807602	93.4586155	93.89849289	94.42225726	95.07463075	95.78754211	96.51769117	97.39494764	98.39981452	99.48064812	100.5947996	101.7005197	102.7310049	103.5863204	104.2147877	104.5555479	104.6429844	104.4802397	103.1826403	101.57578	103.5344441	104.3909902	102.0153207	100.5986861	97.77682319	94.53312275	92.38804618	90.01590031	88.39820203	87.40577403	85.9704075	84.53984409	83.11242057	81.46499687	80.16138519	79.17505936


CREATE TABLE health_nutrition_population_statistics (
  "country_name" VARCHAR,
  "country_code" VARCHAR,
  "indicator_name" VARCHAR,
  "indicator_code" VARCHAR,
  "n_1960" DOUBLE,
  "n_1961" DOUBLE,
  "n_1962" DOUBLE,
  "n_1963" DOUBLE,
  "n_1964" DOUBLE,
  "n_1965" DOUBLE,
  "n_1966" DOUBLE,
  "n_1967" DOUBLE,
  "n_1968" DOUBLE,
  "n_1969" DOUBLE,
  "n_1970" DOUBLE,
  "n_1971" DOUBLE,
  "n_1972" DOUBLE,
  "n_1973" DOUBLE,
  "n_1974" DOUBLE,
  "n_1975" DOUBLE,
  "n_1976" DOUBLE,
  "n_1977" DOUBLE,
  "n_1978" DOUBLE,
  "n_1979" DOUBLE,
  "n_1980" DOUBLE,
  "n_1981" DOUBLE,
  "n_1982" DOUBLE,
  "n_1983" DOUBLE,
  "n_1984" DOUBLE,
  "n_1985" DOUBLE,
  "n_1986" DOUBLE,
  "n_1987" DOUBLE,
  "n_1988" DOUBLE,
  "n_1989" DOUBLE,
  "n_1990" DOUBLE,
  "n_1991" DOUBLE,
  "n_1992" DOUBLE,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE
);