Portal | Español

Privacy & Cookies
We request your permission to obtain statistical data of your navigation in this web.
If you continue browsing we consider that you accept the use of cookies.

Review Cookies Policy

table first_level_administration

General information
columns
field description Type Unit associated date foreign table
id Unique identifier Integer
name name Text
id_type type foreign key type of division
Area Area Real m²
id_capital capital city foreign key city
id_country Country foreign key country
id_continent continent foreign key continent
population population Integer people Si
population_year population year year
Relations
description related table relationship table
Table in which FK is located
table field
airline id_division_1_Headquarters
airport id_region
airport id_location_division_1
amusement park id_division_1
armed organizacion id_division_1_Headquarters
ballet company id_division_1
bank id_division_1_Headquarters
beach id_division_1
brewery id_division_1_Headquarters
bridge id_division_1
building id_division_1
cape id_division_1
casino id_division_1
castle id_division_1
cave id_division_1
cemetery id_division_1
choir id_division_1
city id_division_1
company id_division_1_Headquarters
concentration camp id_division_1
conflict id_division_1
dam id_division_1
distillery id_division_1_Headquarters
draft id_division_1
earthquake id_division_1
foundation id_division_1
ghetto id_division_1
golf club id_division_1
heritage site id_division_1
hospital id_division_1
hotel id_division_1
hut id_division_1
label id_division_1_Headquarters
legislature id_division_1
library id_division_1
lighthouse id_division_1
livery company id_division_1_Headquarters
magazine id_division_1_Headquarters
mall id_division_1
match id_division_1
meteorite id_division_1
military construction id_division_1
military unit id_division_1_Headquarters
mill id_division_1
mine id_division_1
monastery id_division_1
monument id_division_1
museum id_division_1
national military id_division_1_Headquarters
network id_division_1_Headquarters
newspaper id_division_1_Headquarters
observatory id_division_1
oil field id_division_1
opera company id_division_1_Headquarters
orchestra id_division_1_Headquarters
organization id_division_1_Headquarters
person id_division_1_of_death
person id_division_1_of_birth
pipeline id_to_locality_division_1
pipeline id_from_locality_division_1
plain id_division_1
political party id_division_1_Headquarters
port id_division_1
power station id_division_1
prison id_division_1
public body id_division_1_Headquarters
publisher id_division_1_Headquarters
pyramid id_division_1
race course id_division_1
radio id_division_1_Headquarters
religion id_division_1
religious organization id_division_1_Headquarters
reserve id_division_1
restaurant id_division_1
roller coaster id_division_1
school id_division_1
sculpture id_division_1
ski station id_division_1
space agency id_division_1_Headquarters
sport organization id_division_1_Headquarters
stadium id_division_1
station id_division_1
stock exchange id_division_1_Headquarters
stock exchange id_division_1
street id_division_1
studio id_division_1_Headquarters
team id_division_1
television id_division_1_Headquarters
temple id_division_1
theatre id_division_1
themed area id_division_1
tomb id_division_1
trade union id_division_1_Headquarters
tunnel id_division_1
university id_division_1
vivarium id_division_1
waterfall id_division_1
water park id_division_1
water ride id_division_1
wine region id_division_1
winery id_division_1
winery id_division_1_Headquarters