Pakistan Census 2017

Pakistan's Population Growth Trends

@kaggle.usamaraheem_pakistan_census_2017

Table List

1 table(105.71 KB)

Pakistan 2017 Census Final

@kaggle.usamaraheem_pakistan_census_2017.pakistan_2017_census_final

105.71 KB
2073 rows
17 columns

adm_lvl_1 Adm Lvl 1	adm_lvl_2 Adm Lvl 2	adm_lvl_3 Adm Lvl 3	adm_lvl_4 Adm Lvl 4	area_name Area Name	area_type Area Type	area_sq_km Area Sq Km	total_pop Total Pop	total_male Total Male	total_female Total Female	total_trans Total Trans	sex_ratio Sex Ratio	pop_density Pop Density	pct_urban Pct Urban	avg_hh_size Avg Hh Size	total_pop_98 Total Pop 98	avg_annual_growth Avg Annual Growth
BALOCHISTAN	nan	nan	nan	BALOCHISTAN	TOTAL	347190	12335129	6483736	5850613	780	110.82	35.53	0.2762	6.87	6565885	0.0337
BALOCHISTAN	nan	nan	nan	BALOCHISTAN	RURAL		8928428	4685756	4242183	489	110.46			6.8	4997105	0.031
BALOCHISTAN	nan	nan	nan	BALOCHISTAN	URBAN		3406701	1797980	1608430	291	111.78			7.06	1568780	0.0416
BALOCHISTAN	nan	AWARAN	nan	AWARAN DISTRICT	TOTAL	29510	121821	63063	58749	9	107.34	4.13	0.281	6.61	118173	0.0016
BALOCHISTAN	nan	AWARAN	nan	AWARAN DISTRICT	RURAL		87584	45438	42138	8	107.83			6.25	118173	-0.0156
BALOCHISTAN	nan	AWARAN	nan	AWARAN DISTRICT	URBAN		34237	17625	16611	1	106.1			7.81
BALOCHISTAN	nan	AWARAN	AWARAN TEHSIL	AWARAN TEHSIL	TOTAL	13075	30345	15320	15024	1	101.97	2.32	0.7171	7.06	27156	0.0059
BALOCHISTAN	nan	AWARAN	AWARAN TEHSIL	AWARAN TEHSIL	RURAL		8584	4334	4250		101.98			5.72	27156	-0.0587
BALOCHISTAN	nan	AWARAN	AWARAN TEHSIL	AWARAN TEHSIL	URBAN		21761	10986	10774	1	101.97			7.81
BALOCHISTAN	nan	AWARAN	GISHKORE SUB-TEHSIL	GISHKORE SUB-TEHSIL	TOTAL	4578	18390	9683	8704	3	111.25	4.02		5.07	22430	-0.0104


CREATE TABLE pakistan_2017_census_final (
  "adm_lvl_1" VARCHAR,
  "adm_lvl_2" VARCHAR,
  "adm_lvl_3" VARCHAR,
  "adm_lvl_4" VARCHAR,
  "area_name" VARCHAR,
  "area_type" VARCHAR,
  "area_sq_km" DOUBLE,
  "total_pop" DOUBLE,
  "total_male" DOUBLE,
  "total_female" DOUBLE,
  "total_trans" DOUBLE,
  "sex_ratio" DOUBLE,
  "pop_density" DOUBLE,
  "pct_urban" DOUBLE,
  "avg_hh_size" DOUBLE,
  "total_pop_98" DOUBLE,
  "avg_annual_growth" DOUBLE
);