Baselight

Brazilian Cities Informations

Cities from Brazil with geolocation information from IBGE in 2020

@kaggle.paulolomeu_brazilian_cities_informations

Brazilian Cities Geo
@kaggle.paulolomeu_brazilian_cities_informations.brazilian_cities_geo

  • 221.21 KB
  • 5570 rows
  • 13 columns
unnamed_0

Unnamed: 0

code_ibge

Code Ibge

city_name

City Name

city_latitude

City Latitude

city_longitude

City Longitude

capital_flag

Capital Flag

phone_code

Phone Code

time_zone

Time Zone

state

State

state_name

State Name

state_latitude

State Latitude

state_longitude

State Longitude

region

Region

5200050ABADIA DE GOIÁS-16.7573-49.441262America/Sao_PauloGOGoiás-15.98-49.86Centro-Oeste
15200100ABADIÂNIA-16.197-48.705762America/Sao_PauloGOGoiás-15.98-49.86Centro-Oeste
25200134ACREÚNA-17.396-50.374964America/Sao_PauloGOGoiás-15.98-49.86Centro-Oeste
35200159ADELÂNDIA-16.4127-50.165764America/Sao_PauloGOGoiás-15.98-49.86Centro-Oeste
45200175ÁGUA FRIA DE GOIÁS-14.9778-47.782362America/Sao_PauloGOGoiás-15.98-49.86Centro-Oeste
55200209ÁGUA LIMPA-18.0771-48.760364America/Sao_PauloGOGoiás-15.98-49.86Centro-Oeste
65200258ÁGUAS LINDAS DE GOIÁS-15.7617-48.281661America/Sao_PauloGOGoiás-15.98-49.86Centro-Oeste
75200308ALEXÂNIA-16.0834-48.507662America/Sao_PauloGOGoiás-15.98-49.86Centro-Oeste
85200506ALOÂNDIA-17.7292-49.476964America/Sao_PauloGOGoiás-15.98-49.86Centro-Oeste
95200555ALTO HORIZONTE-14.1978-49.337862America/Sao_PauloGOGoiás-15.98-49.86Centro-Oeste

CREATE TABLE brazilian_cities_geo (
  "unnamed_0" BIGINT,
  "code_ibge" BIGINT,
  "city_name" VARCHAR,
  "city_latitude" DOUBLE,
  "city_longitude" DOUBLE,
  "capital_flag" BIGINT,
  "phone_code" BIGINT,
  "time_zone" VARCHAR,
  "state" VARCHAR,
  "state_name" VARCHAR,
  "state_latitude" DOUBLE,
  "state_longitude" DOUBLE,
  "region" VARCHAR
);

Share link

Anyone who has the link will be able to view this.