Brazilian Cities

Context

Brazil is the world's fifth-largest country by area, with 8.5 million square kilometer, and the fifth most populous, with over 208 million people.

The Federative Republic of Brazil is composed of the union of the 26 states, the Federal District, and the 5,570 municipalities.

This dataset is a compilation of several publicly available information about Brazilian Municipalities.

Content

The data was retrieved from several websites, as presented below. I processed and merged all data by city name, resulting in 79 fields for every city.

I am including the source of the information, in case the user wishes to understand better the information that is being analised.

FIELD - DESCRIPTION - REFERENCE - UNIT - SOURCE

CITY - Name of the City

STATE - Name of the State

CAPITAL - 1 if Capital of State

IBGE_RES_POP - Resident Population - 2010 - source

IBGE_RES_POP_BRAS - Resident Population Brazilian - 2010 - source

IBGE_RES_POP_ESTR - Redident Population Foreigners - 2010 - source

IBGE_DU - Domestic Units Total - 2010 - source

IBGE_DU_URBAN - Domestic Units Urban - 2010 - source

IBGE_DU_RURAL - Domestic Units Rural 2010 - source

IBGE_POP - Resident Population Regular Urban Planning - 2010 - source

IBGE_1 - Resident Population Regular Urban Planning - until 1 y.o - 2010 - source

IBGE_1-4 - Resident Population Regular Urban Planning - from 1 to 4 y.o - 2010 - source

IBGE_5-9 - Resident Population Regular Urban Planning - from 4 to 9 y.o - 2010 - source

IBGE_10-14 - Resident Population Regular Urban Planning - from 10 to 14 y.o - 2010 - source

IBGE_15-59 - Resident Population Regular Urban Planning - from 15 to 59 y.o 2010 - source

IBGE_60+ - Resident Population Regular Urban Planning - above 60 y.o - 2010 - source

IBGE_PLANTED_AREA - Planted Area (hectares) - 2017 - 1 hectare (1 hectare = 10,000 square meters) - source

IBGE_CROP_PRODUCTION_$ - Crop Production - 2017 - $ 1,000 reais - source

IDHM Ranking - HDI Ranking - 2010 - source

IDHM - HDI Human Development Index - 2010 - source

IDHM_Renda - HDI GNI Index - 2010 - source

IDHM_Longevidade - HDI Life Expectancy index - 2010 - source

IDHM_Educacao HDI Education index - 2010 - source

LONG - City Longitude - 2010 - source

LAT - City Latitude - 2010 - source

ALT - City Elevation (meters) - 2010 - 1 meter - source

PAY_TV - PayTV users - 2019-03 - source

FIXED_PHONES - Fixed Fones (not cell phones) users - 2019-03 - source

AREA - City area (square kilometers) - 2018 - 1 square Kilometer (1 kilometer = 1,000,000 square meters) - source

REGIAO_TUR - Turism Category Region - 2017 - source

CATEGORIA_TUR - Turism Category - 2017 - source

ESTIMATED_POP - Estimated Population - 2018-07 - source

RURAL_URBAN - Rural or Urban Tipology - 2016 - source

GVA_AGROPEC - Gross Added Value - Agropecuary - 2016 - $ 1,000 reais - source

GVA_INDUSTRY - Gross Added Value - Industry - 2016 - $ 1,000 reais - source

GVA_SERVICES - Gross Added Value - Services - 2016 - $ 1,000 reais - source

GVA_PUBLIC - Gross Added Value - Public Services - 2016 - $ 1,000 reais - source

GVA_TOTAL Total Gross Added Value - 2016 - $ 1,000 reais - source

TAXES - Taxes - 2016 - $ 1,000 - reais - source

GDP - Gross Domestic Product - 2016 - $ 1,000 reais - source

POP_GDP - Population - 2016 - source

GDP_CAPITA - Gross Domestic Product per capita - 2016 - source

GVA_MAIN - Activity with higher GVA contribution - 2016 - source

MUN_EXPENDIT - Municipal expenditures - in reais - 2016 - $ 1 real - source

COMP_TOT - Total number of companies 2016 - source

COMP_A Number of Companies: Agriculture, livestock, forestry, fishing and aquaculture - 2016 - source

COMP_B Number of Companies: Extractive industries 2016 - source

COMP_C Number of Companies: Industries of transformation - 2016 - source

COMP_D Number of Companies: Electricity and gas - 2016 - source

COMP_E Number of Companies: Water, sewage, waste management and decontamination activities - 2016 - source

COMP_F Number of Companies: Construction - 2016 - source

COMP_G - Number of Companies: Trade; repair of motor vehicles and motorcycles - 2016 - source

COMP_H - Number of Companies: Transport, storage and mail - 2016 - source

COMP_I - Number of Companies: Accommodation and food - 2016 - source

COMP_J - Number of Companies: Information and communication - 2016 - source

COMP_K - Number of Companies: Financial, insurance and related services activities - 2016 - source

COMP_L - Number of Companies: Real estate activities - 2016 - source

COMP_M - Number of Companies: Professional, scientific and technical activities - 2016 - source

COMP_N - Number of Companies: Administrative activities and complementary services - 2016 - source

COMP_O - Number of Companies: Public administration, defense and social security - 2016 - source

COMP_P - Number of Companies: Education - 2016 - source

COMP_Q - Number of Companies: Human health and social services - 2016 - source

COMP_R - Number of Companies: Arts, culture, sport and recreation - 2016 - source

COMP_S - Number of Companies: Other service activities - 2016 - source

COMP_T - Number of Companies: Domestic services - 2016 - source

COMP_U - Number of Companies: International and other extraterritorial institutions - 2016 - source

HOTELS - Total number of hotels - 2019-03 - source

BEDS - Total number of hotel beds - 2019-03 - source

Pr_Agencies - Total number of private bank agencies - 2019-02 - source

Pu_Agencies - Total number of public bank agencies - 2019-02 - source

Pr_Bank - Total number of private banks - 2019-02 - source

Pu_Bank - Total number of public banks 2019-02 - source

Pr_Assets - Total amount of private bank assets - 2019-02 $ 1 real source

Pu_Assets - Total amount of public bank assets - 2019-02 $ 1 real source

Cars - Total number of cars - 2019-01 - source

Motorcycles - Total number of motorcycles, scooters, moped - 2019-01 - source

Wheeled_tractor - Total number of wheeled tractors - 2019-01 - source

UBER - 1 if UBER 2019-05 - source

MAC - Total number of Mac Donalds stores - 2018-11 - source

WALLMART - Total number of Walmart Stores - 2018-12 - source

POST_OFFICES - Total number of post offices - 2019-05 - source

Inspiration

Hopefully this data would help students that wish to train and improve their analytical skills and also whoever is interested in learning more about my country ! :-)