Brazilian Cities

A collection of 79 attributes from Brazilian Cities

@kaggle.crisparada_brazilian_cities

Table List

2 tables(1.4 MB)

Brazil Cities

@kaggle.crisparada_brazilian_cities.brazil_cities

1.39 MB
5573 rows
81 columns

city CITY	state STATE	ibge_res_pop IBGE RES POP	ibge_res_pop_bras IBGE RES POP BRAS	ibge_res_pop_estr IBGE RES POP ESTR	ibge_du IBGE DU	ibge_du_urban IBGE DU URBAN	ibge_du_rural IBGE DU RURAL	ibge_pop IBGE POP	ibge_1 IBGE 1	ibge_1_4 IBGE 1-4	ibge_5_9 IBGE 5-9	ibge_10_14 IBGE 10-14	ibge_15_59 IBGE 15-59	ibge_60 IBGE 60+	ibge_planted_area IBGE PLANTED AREA	ibge_crop_production IBGE CROP PRODUCTION $	idhm_ranking_2010 IDHM Ranking 2010	idhm IDHM	idhm_renda IDHM Renda	idhm_longevidade IDHM Longevidade	idhm_educacao IDHM Educacao	long LONG	lat LAT	alt ALT	pay_tv PAY TV	fixed_phones FIXED PHONES	area AREA	regiao_tur REGIAO TUR	categoria_tur CATEGORIA TUR	estimated_pop ESTIMATED POP	rural_urban RURAL URBAN	gva_agropec GVA AGROPEC	gva_industry GVA INDUSTRY	gva_services GVA SERVICES	gva_public GVA PUBLIC	n__gva_total GVA TOTAL	taxes TAXES	gdp GDP	pop_gdp POP GDP	gdp_capita GDP CAPITA	gva_main GVA MAIN	mun_expendit MUN EXPENDIT	comp_tot COMP TOT	comp_a COMP A	comp_b COMP B	comp_c COMP C	comp_d COMP D	comp_e COMP E	comp_f COMP F	comp_g COMP G	comp_h COMP H	comp_i COMP I	comp_j COMP J	comp_k COMP K	comp_l COMP L	comp_m COMP M	comp_n COMP N	comp_o COMP O	comp_p COMP P	comp_q COMP Q	comp_r COMP R	comp_s COMP S	hotels HOTELS	beds BEDS	pr_agencies Pr Agencies	pu_agencies Pu Agencies	pr_bank Pr Bank	pu_bank Pu Bank	pr_assets Pr Assets	pu_assets Pu Assets	cars Cars	motorcycles Motorcycles	wheeled_tractor Wheeled Tractor	post_offices POST OFFICES
Abadia De Goiás	GO	6876	6876		2137	1546	591	5300	69	318	438	517	3542	416	319	1843	1689	0.708	0.687	0.83	0.622	-49.44054783	-16.75881189	893.6	360	842	147.26	nan	nan	8583	Urbano	6.2	27991.25	74750.32	36915.04	145857.6	20554.2	166.41	8053	20664.57	Demais serviços	28227691	284	5	1	56		2	29	110	26	4	5		2	10	12	4	6	6	1	5									2158	1246		1
Abadia Dos Dourados	MG	6704	6704		2328	1481	847	4154	38	207	260	351	2709	589	4479	18017	2207	0.69	0.693	0.839	0.563	-47.39683244	-18.48756496	753.12	77	296	881.06	Caminhos Do Cerrado	D	6972	Rural Adjacente	50524.57	25917.7	62689.23	28083.79	167215.28	12873.5	180.09	7037	25591.7	Demais serviços	17909274	476	6	6	30	1	2	34	190	70	28	11		4	15	29	2	9	14	6	19									2227	1142		1
Abadiânia	GO	15757	15609	148	4655	3233	1422	10656	139	650	894	1087	6896	990	10307	33085	2202	0.69	0.671	0.841	0.579	-48.71881214	-16.18267186	1017.55	227	720	1045.13	Região Turística Do Ouro E Cristais	C	19614	Rural Adjacente	42.84	16728.3	138198.58	63396.2	261161.91	26822.58	287984.49	18427	15628.4	Demais serviços	37513019	288	5	9	26		2	7	117	12	57	2	1		7	15	3	11	5	1	8	1	34	1	1	1	1	33724584	67091904	2838	1426		3
Abaeté	MG	22690	22690		7694	6667	1027	18464	176	856	1233	1539	11979	2681	1862	7502	1994	0.698	0.72	0.848	0.556	-45.44619142	-19.15584769	644.74	1230	1716	1817.07	Lago De Três Marias	D	23223	Urbano	113824.6	31002.62	172.33	86081.41	403241.27	26994.09	430235.36	23574	18250.42	Demais serviços		621	18	1	40		1	20	303	62	30	9	6	4	28	27	2	15	19	9	27			2	2	2	2	44974716	371922572	6928	2953		4
Abaetetuba	PA	141100	141040	60	31061	19057	12004	82956	1354	5567	7618	8905	53516	5996	25200	700872	3530	0.628	0.579	0.798	0.537	-48.88440382	-1.723469863	10.12	3389	1218	1610.65	Araguaia-Tocantins	D	156292	Urbano	140463.72	58610	468128.69	486872.4	1154074.81	95180.48	1249255.29	151934	8222.36	Administração, defesa, educação e saúde públicas e seguridade social		931	4	2	43		1	27	500	16	31	6	1	1	22	16	2	155	33	15	56			2	4	2	4	76181384	800078483	5277	25661		2
Abaiara	CE	10496	10496		2791	1251	1540	4538	98	323	421	483	2631	582	2598	5234	3522	0.628	0.54	0.748	0.612	-39.04754664	-7.356976596	403.11	29	34	180.08	nan	nan	11663	Rural Adjacente	4435.16	5.88	22.81	35989.96	69108.67	4042.79	73151.46	11483	6370.41	Administração, defesa, educação e saúde públicas e seguridade social		86	1		4			6	48	2	10	2			2	3	2		2		4									553	1674		1
Abaíra	BA	8316	8316		2572	1193	1379	3725	37	156	263	277	2319	673	895	3999	4086	0.603	0.577	0.746	0.51	-41.66160848	-13.25353189	674.22	952	335	538.68	Chapada Diamantina	D	8767	Rural Remoto	12.41	3437.43	17990.74	28463.74	62304.83	2019.77	64324.59	9212	6982.7	Administração, defesa, educação e saúde públicas e seguridade social		191	6		8		1	4	97	5	5	3	1		5	5	2	8	1	2	38	1	24							896	696		1
Abaré	BA	17064	17064		4332	2379	1953	8994	167	733	978	927	5386	803	2058	22761	4756	0.575	0.533	0.776	0.46	-39.11658794	-8.723418246	316.38	51	222	1604.92	nan	nan	19814	Rural Remoto	9176.4	6.7	36921.84	65.75	118.55	6.21	124754.26	19939	6256.8	Administração, defesa, educação e saúde públicas e seguridade social		87	2		3				71		1	1				1	2		2		4			1		1		21823314		613	1532		1
Abatiá	PR	7764	7764		2499	1877	622	5685	69	302	370	483	3650	811	1197	9943	2258	0.687	0.676	0.804	0.596	-50.31252658	-23.30049404	579.3	55	392	228.72	nan	nan	7507	Rural Adjacente	73340.52	8839.71	42999.37	34103.49	159283.08	5.77	165048.21	7795	21173.6	Agricultura, inclusive apoio à agricultura e a pós colheita		285	5		20		1	10	133	18	14	8		4	11	26	2	8	9	4	12				1		1		45976288	2168	912		1
Abdon Batista	SC	2653	2653		848	234	614	724	12	32	49	63	479	89	5502	26195	2092	0.69	0.66	0.812	0.625	-51.02527221	-27.60898712	720.98	109	260	237.16	Vale Do Contestado	D	2577	Rural Adjacente	24996.75	3578.87	16011.1	17842.64	62429.36	2312.65	64742.01	2617	24739.02	Administração, defesa, educação e saúde públicas e seguridade social	19506956	69	2		4			2	35	8	3	1	1		4		2	1	3		3				1		1		42909056	976	345	2	1


CREATE TABLE brazil_cities (
  "city" VARCHAR,
  "state" VARCHAR,
  "capital" BIGINT,
  "ibge_res_pop" DOUBLE,
  "ibge_res_pop_bras" DOUBLE,
  "ibge_res_pop_estr" DOUBLE,
  "ibge_du" DOUBLE,
  "ibge_du_urban" DOUBLE,
  "ibge_du_rural" DOUBLE,
  "ibge_pop" DOUBLE,
  "ibge_1" DOUBLE,
  "ibge_1_4" DOUBLE,
  "ibge_5_9" DOUBLE,
  "ibge_10_14" DOUBLE,
  "ibge_15_59" DOUBLE,
  "ibge_60" DOUBLE,
  "ibge_planted_area" DOUBLE,
  "ibge_crop_production" DOUBLE,
  "idhm_ranking_2010" DOUBLE,
  "idhm" DOUBLE,
  "idhm_renda" DOUBLE,
  "idhm_longevidade" DOUBLE,
  "idhm_educacao" DOUBLE,
  "long" DOUBLE,
  "lat" DOUBLE,
  "alt" DOUBLE,
  "pay_tv" DOUBLE,
  "fixed_phones" DOUBLE,
  "area" DOUBLE,
  "regiao_tur" VARCHAR,
  "categoria_tur" VARCHAR,
  "estimated_pop" DOUBLE,
  "rural_urban" VARCHAR,
  "gva_agropec" DOUBLE,
  "gva_industry" DOUBLE,
  "gva_services" DOUBLE,
  "gva_public" DOUBLE,
  "n__gva_total" DOUBLE,
  "taxes" DOUBLE,
  "gdp" DOUBLE,
  "pop_gdp" DOUBLE,
  "gdp_capita" DOUBLE,
  "gva_main" VARCHAR,
  "mun_expendit" DOUBLE,
  "comp_tot" DOUBLE,
  "comp_a" DOUBLE,
  "comp_b" DOUBLE,
  "comp_c" DOUBLE,
  "comp_d" DOUBLE,
  "comp_e" DOUBLE,
  "comp_f" DOUBLE,
  "comp_g" DOUBLE,
  "comp_h" DOUBLE,
  "comp_i" DOUBLE,
  "comp_j" DOUBLE,
  "comp_k" DOUBLE,
  "comp_l" DOUBLE,
  "comp_m" DOUBLE,
  "comp_n" DOUBLE,
  "comp_o" DOUBLE,
  "comp_p" DOUBLE,
  "comp_q" DOUBLE,
  "comp_r" DOUBLE,
  "comp_s" DOUBLE,
  "comp_t" DOUBLE,
  "comp_u" DOUBLE,
  "hotels" DOUBLE,
  "beds" DOUBLE,
  "pr_agencies" DOUBLE,
  "pu_agencies" DOUBLE,
  "pr_bank" DOUBLE,
  "pu_bank" DOUBLE,
  "pr_assets" DOUBLE,
  "pu_assets" DOUBLE,
  "cars" DOUBLE,
  "motorcycles" DOUBLE,
  "wheeled_tractor" DOUBLE,
  "uber" DOUBLE,
  "mac" DOUBLE,
  "wal_mart" DOUBLE,
  "post_offices" DOUBLE
);