UN Habitat Urban Indicators

World urban statistics collected through household surveys and censuses

@kaggle.joebeachcapital_un_habitat_urban_indicators

Table List

1 table(509.88 KB)

Habitat Urban Data

@kaggle.joebeachcapital_un_habitat_urban_indicators.habitat_urban_data

509.88 KB
48491 rows
10 columns

category_of_the_indicator Category Of The Indicator	code_of_the_indicator Code Of The Indicator	name_of_the_indicator Name Of The Indicator	indicator_unit Indicator Unit	country_code Country Code	indicator_location Indicator Location	year_of_the_indicator Year Of The Indicator	value_of_the_indicator Value Of The Indicator	coordinates Coordinates	indicator_scope Indicator Scope
Population	infant_mortality_rate	Infant Mortality rate (Deaths per 1000 live births)	Unit	BY	Belarus	1995	18.5	53.0, 28.0	Country
Slum dwellers	rainwater	Access to rainwater	Percentage	CD	Congo, the democratic republic of the	2007	2.3	0.0, 25.0	Country
Population	population_cities_by_country_1m_5m	Population in cities by country – cities with 1 to 5 million inhabitants	Thousand of people	CF	Central african republic	2005	87130	7.0, 21.0	Country
Population	population_cities_by_country_1m_5m	Population in cities by country – cities with 1 to 5 million inhabitants	Thousand of people	DZ	Algeria	1965	1049	28.0, 3.0	Country
Population	death_per_1000_live_births	Deaths per 1000 live births	Unit	TR	Turkey	1990	67	39.0, 35.0	Country
Population	rural_population	Rural population	Thousand of people	TZ	Tanzania, united republic of	2030	40185	-6.0, 35.0	Country
Population	has_telephone	Access to telephone	Percentage	UG	Uganda	1995	2.4	1.0, 32.0	Country
Population	population	Total population	Thousand of people	UG	Uganda	2045	85039	1.0, 32.0	Country
Population	rural_population	Rural population	Thousand of people	VN	Viet nam	2005	62574	14.43, 108.55	Country
Slum dwellers	urban_population_percentage_fewer_500k	Percentage of urban population (by country) – Fewer than 500 000 inhabitants	Percentage	ZA	South africa	1990	48.57	-29.0, 24.0	Country


CREATE TABLE habitat_urban_data (
  "category_of_the_indicator" VARCHAR,
  "code_of_the_indicator" VARCHAR,
  "name_of_the_indicator" VARCHAR,
  "indicator_unit" VARCHAR,
  "country_code" VARCHAR,
  "indicator_location" VARCHAR,
  "year_of_the_indicator" DOUBLE,
  "value_of_the_indicator" DOUBLE,
  "coordinates" VARCHAR,
  "indicator_scope" VARCHAR
);