World Population Data 1960-2020

@kaggle.utkarshx27_world_population_data_1960_2020

Table List

1 table(138.32 KB)

World Pop

@kaggle.utkarshx27_world_population_data_1960_2020.world_pop

138.32 KB
216 rows
63 columns

unnamed_0 Unnamed: 0	country Country	year_1960 Year 1960	year_1961 Year 1961	year_1962 Year 1962	year_1963 Year 1963	year_1964 Year 1964	year_1965 Year 1965	year_1966 Year 1966	year_1967 Year 1967	year_1968 Year 1968	year_1969 Year 1969	year_1970 Year 1970	year_1971 Year 1971	year_1972 Year 1972	year_1973 Year 1973	year_1974 Year 1974	year_1975 Year 1975	year_1976 Year 1976	year_1977 Year 1977	year_1978 Year 1978	year_1979 Year 1979	year_1980 Year 1980	year_1981 Year 1981	year_1982 Year 1982	year_1983 Year 1983	year_1984 Year 1984	year_1985 Year 1985	year_1986 Year 1986	year_1987 Year 1987	year_1988 Year 1988	year_1989 Year 1989	year_1990 Year 1990	year_1991 Year 1991	year_1992 Year 1992	year_1993 Year 1993	year_1994 Year 1994	year_1995 Year 1995	year_1996 Year 1996	year_1997 Year 1997	year_1998 Year 1998	year_1999 Year 1999	year_2000 Year 2000	year_2001 Year 2001	year_2002 Year 2002	year_2003 Year 2003	year_2004 Year 2004	year_2005 Year 2005	year_2006 Year 2006	year_2007 Year 2007	year_2008 Year 2008	year_2009 Year 2009	year_2010 Year 2010	year_2011 Year 2011	year_2012 Year 2012	year_2013 Year 2013	year_2014 Year 2014	year_2015 Year 2015	year_2016 Year 2016	year_2017 Year 2017	year_2018 Year 2018	year_2019 Year 2019	year_2020 Year 2020
1	Afghanistan	8996967	9169406	9351442	9543200	9744772	9956318	10174840	10399936	10637064	10893772	11173654	11475450	11791222	12108963	12412960	12689164	12943093	13171294	13341199	13411060	13356500	13171679	12882518	12537732	12204306	11938204	11736177	11604538	11618008	11868873	12412311	13299016	14485543	15816601	17075728	18110662	18853444	19357126	19737770	20170847	20779957	21606992	22600774	23680871	24726689	25654274	26433058	27100542	27722281	28394806	29185511	30117411	31161378	32269592	33370804	34413603	35383028	36296111	37171922	38041757	38928341
2	Albania	1608800	1659800	1711319	1762621	1814135	1864791	1914573	1965598	2022272	2081695	2135479	2187853	2243126	2296752	2350124	2404831	2458526	2513546	2566266	2617832	2671997	2726056	2784278	2843960	2904429	2964762	3022635	3083605	3142336	3227943	3286542	3266790	3247039	3227287	3207536	3187784	3168033	3148281	3128530	3108778	3089027	3060173	3051010	3039616	3026939	3011487	2992547	2970017	2947314	2927519	2913021	2905195	2900401	2895092	2889104	2880703	2876101	2873457	2866376	2854191	2837743
3	Algeria	11057864	11336336	11619828	11912800	12221675	12550880	12902626	13275020	13663581	14061724	14464992	14872253	15285992	15709831	16149018	16607706	17085799	17582899	18102266	18647801	19221659	19824297	20452901	21101875	21763578	22431507	23102386	23774287	24443472	25106192	25758872	26400468	27028330	27635517	28213777	28757788	29266415	29742980	30192750	30623406	31042238	31451513	31855110	32264159	32692153	33149720	33641007	34166976	34730604	35333882	35977451	36661438	37383899	38140135	38923688	39728020	40551398	41389174	42228415	43053054	43851043
4	American Samoa	20127	20605	21246	22029	22850	23675	24473	25235	25980	26698	27362	27982	28564	29103	29595	30045	30455	30834	31262	31842	32648	33697	34969	36413	37946	39521	41114	42741	44346	45894	47351	48682	49900	51025	52099	53158	54209	55227	56180	57049	57816	58496	59077	59495	59684	59557	59109	58367	57490	56675	56084	55755	55669	55717	55791	55806	55739	55617	55461	55312	55197
5	Andorra	13410	14378	15379	16407	17466	18542	19646	20760	21886	23053	24275	25571	26885	28232	29515	30705	31782	32769	33744	34825	36063	37498	39115	40854	42706	44593	46520	48459	50433	52452	54508	56666	58882	60974	62676	63860	64363	64318	64140	64368	65390	67344	70048	73180	76250	78871	80995	82682	83860	84461	84454	83748	82427	80770	79213	77993	77295	76997	77008	77146	77265
6	Angola	5454938	5531451	5608499	5679409	5734995	5770573	5781305	5774440	5771973	5803677	5890360	6041239	6248965	6497283	6761623	7023994	7279630	7533814	7790774	8058112	8341290	8640478	8952971	9278104	9614756	9961993	10320116	10689247	11068051	11454784	11848385	12248901	12657361	13075044	13503753	13945205	14400722	14871572	15359600	15866871	16395477	16945753	17519418	18121477	18758138	19433604	20149905	20905360	21695636	22514275	23356247	24220660	25107925	26015786	26941773	27884380	28842482	29816769	30809787	31825299	32866268
7	Antigua and Barbuda	54132	55005	55849	56701	57641	58699	59912	61240	62523	63553	64184	64354	64134	63649	63108	62671	62353	62162	62038	61948	61861	61789	61780	61779	61784	61785	61754	61713	61758	62007	62533	63363	64459	65777	67201	68672	70176	71707	73219	74674	76007	77212	78298	79311	80347	81462	82715	84029	85394	86743	88030	89250	90407	91510	92562	93571	94520	95425	96282	97115	97928
8	Argentina	20481781	20817270	21153042	21488916	21824427	22159644	22494031	22828872	23168268	23517613	23880564	24259564	24653172	25056475	25462305	25865775	26264681	26661397	27061041	27471046	27896532	28338514	28794550	29262049	29737097	30216284	30698964	31184411	31668939	32148137	32618648	33079002	33529320	33970103	34402669	34828168	35246376	35657438	36063451	36467218	36870796	37275644	37681743	38087866	38491970	38892924	39289876	39684303	40080159	40482786	40788453	41261490	41733271	42202935	42669500	43131966	43590368	44044811	44494502	44938712	45376763
9	Armenia	1874119	1941498	2009524	2077584	2145004	2211316	2276038	2339133	2401142	2462938	2525067	2587716	2650484	2712780	2773750	2832752	2889583	2944375	2997419	3049107	3099759	3148096	3193696	3238592	3285593	3335935	3392264	3451947	3504667	3536473	3538164	3505249	3442820	3363111	3283664	3217349	3168213	3133081	3108691	3089020	3069597	3050686	3033976	3017938	3000715	2981262	2958301	2932615	2907615	2888094	2877314	2876536	2884239	2897593	2912403	2925559	2936147	2944789	2951741	2957728	2963234
10	Aruba	54208	55434	56234	56699	57029	57357	57702	58044	58377	58734	59070	59442	59849	60236	60527	60653	60586	60366	60102	59972	60097	60561	61341	62213	62826	63024	62645	61838	61072	61033	62152	64623	68240	72495	76705	80324	83211	85450	87280	89009	90866	92892	94992	97016	98744	100028	100830	101226	101362	101452	101665	102050	102565	103165	103776	104339	104865	105361	105846	106310	106766


CREATE TABLE world_pop (
  "unnamed_0" BIGINT,
  "country" VARCHAR,
  "year_1960" DOUBLE,
  "year_1961" DOUBLE,
  "year_1962" DOUBLE,
  "year_1963" DOUBLE,
  "year_1964" DOUBLE,
  "year_1965" DOUBLE,
  "year_1966" DOUBLE,
  "year_1967" DOUBLE,
  "year_1968" DOUBLE,
  "year_1969" DOUBLE,
  "year_1970" DOUBLE,
  "year_1971" DOUBLE,
  "year_1972" DOUBLE,
  "year_1973" DOUBLE,
  "year_1974" DOUBLE,
  "year_1975" DOUBLE,
  "year_1976" DOUBLE,
  "year_1977" DOUBLE,
  "year_1978" DOUBLE,
  "year_1979" DOUBLE,
  "year_1980" DOUBLE,
  "year_1981" DOUBLE,
  "year_1982" DOUBLE,
  "year_1983" DOUBLE,
  "year_1984" DOUBLE,
  "year_1985" DOUBLE,
  "year_1986" DOUBLE,
  "year_1987" DOUBLE,
  "year_1988" DOUBLE,
  "year_1989" DOUBLE,
  "year_1990" BIGINT,
  "year_1991" BIGINT,
  "year_1992" DOUBLE,
  "year_1993" DOUBLE,
  "year_1994" DOUBLE,
  "year_1995" BIGINT,
  "year_1996" BIGINT,
  "year_1997" BIGINT,
  "year_1998" BIGINT,
  "year_1999" BIGINT,
  "year_2000" BIGINT,
  "year_2001" BIGINT,
  "year_2002" BIGINT,
  "year_2003" BIGINT,
  "year_2004" BIGINT,
  "year_2005" BIGINT,
  "year_2006" BIGINT,
  "year_2007" BIGINT,
  "year_2008" BIGINT,
  "year_2009" BIGINT,
  "year_2010" BIGINT,
  "year_2011" BIGINT,
  "year_2012" DOUBLE,
  "year_2013" DOUBLE,
  "year_2014" DOUBLE,
  "year_2015" DOUBLE,
  "year_2016" DOUBLE,
  "year_2017" DOUBLE,
  "year_2018" DOUBLE,
  "year_2019" DOUBLE,
  "year_2020" DOUBLE
);