Data table via SPARQL

Most populated places

Data table via SPARQL Published 30 Mar 2013 Last modified 13 Jan 2021

Example of dbpedia query for most populated places

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

subject	label	abstract	populationTotal	latitude	longitude
<http://dbpedia.org/resource/West_Java>	"West Java"@en	"West Java (Indonesian: Jawa Barat; Sundanese: \u1b8f\u1b9d \u1b8a\u1ba5\u1b9c\u1ba7\u1b94\u1baa is a province of Indonesia on the western part of the island of Java, with its provincial capital in Bandung. West Java is bordered by the province of Banten and the country's capital region of Jakarta to the west, the Java Sea to the north, the province of Central Java to the east and the Indian Ocean to the south. The province is the homeland of the Sundanese people, the second-largest ethnic group in Indonesia after the Javanese."@en	"49935858"^^<http://www.w3.org/2001/XMLSchema#integer>	"-6.75"^^<http://www.w3.org/2001/XMLSchema#float>	"107.5"^^<http://www.w3.org/2001/XMLSchema#float>
<http://dbpedia.org/resource/Andhra_Pradesh>	"Andhra Pradesh"@en	"Andhra Pradesh (/\u02cc\u0251\u02d0ndr\u0259 pr\u0259\u02c8d\u025b\u0283/ ) also known as Andhra or Andhra Rashtram is a state in the south-eastern coastal region of India. It is the seventh-largest state by area covering an area of 162,975 km2 (62,925 sq mi) and tenth-most populous state with 49,386,799 inhabitants. It has the second-longest coastline after Gujarat of about 974 km (605 mi). It is bordered by Odisha to the north, Chhattisgarh to the north-east, Tamil Nadu to the south, Karnataka to the west, Telangana to the north-west and the Bay of Bengal to the east. Andhra Pradesh is the first state to be formed on a linguistic basis in India on Oct 1, 1953. Andhra Pradesh was once a major Buddhist pilgrimage site in India and a Buddhist learning center which can be seen in many sites in the state in the form of ruins, chait"@en	"49386799"^^<http://www.w3.org/2001/XMLSchema#integer>	"16.5"^^<http://www.w3.org/2001/XMLSchema#float>	"80.64"^^<http://www.w3.org/2001/XMLSchema#float>
<http://dbpedia.org/resource/Guangxi>	"Guangxi"@en	"Guangxi ([kwa\u0300\u014b.\u0255i\u0301] (); alternately romanized as Kwanghsi; Chinese: \u5e7f\u897f; Zhuang: Gvangjsih), officially the Guangxi Zhuang Autonomous Region (GZAR), is an autonomous region of the People's Republic of China, located in South China and bordering Vietnam (H\u00e0 Giang, Cao B\u1eb1ng, L\u1ea1ng S\u01a1n and Qu\u1ea3ng Ninh Provinces) and the Gulf of Tonkin. Formerly a province, Guangxi became an autonomous region in 1958. Its current capital is Nanning."@en	"48380000"^^<http://www.w3.org/2001/XMLSchema#integer>	"23.6"^^<http://www.w3.org/2001/XMLSchema#float>	"108.3"^^<http://www.w3.org/2001/XMLSchema#float>
<http://dbpedia.org/resource/Sindh>	"Sindh"@en	"Sindh (; Sindhi: \u0633\u0646\u068c\u200e; Urdu: \u0633\u0646\u062f\u06be\u200e, pronounced [s\u026and\u032a\u02b0]) is one of the four provinces of Pakistan. Located in the southeast of the country, it is the historical home of the Sindhi people. Sindh is the third largest province of Pakistan by area, and second largest province by population after Punjab. Sindh is bordered by Balochistan province to the west, and Punjab province to the north. Sindh also borders the Indian states of Gujarat and Rajasthan to the east, and Arabian Sea to the south. Sindh's landscape consists mostly of alluvial plains flanking the Indus River, the Thar desert in the eastern portion of the province closest to the border with India, and the Kirthar Mountains in the western part of Sindh."@en	"47886051"^^<http://www.w3.org/2001/XMLSchema#integer>	"26.35"^^<http://www.w3.org/2001/XMLSchema#float>	"68.85"^^<http://www.w3.org/2001/XMLSchema#float>
<http://dbpedia.org/resource/Otatitlán>	"Otatitl\u00e1n"@en	"Otatitl\u00e1n is a town and municipality in the Mexican state of Veracruz, in the south of the state along the border with the state of Oaxaca. The town is best known for its large black image of a crucified Christ, one of three notable images of this type. Most of the population is poor and the area is dedicated to agriculture, especially sugar cane and bananas."@en	"46595250"^^<http://www.w3.org/2001/XMLSchema#integer>	"18.1772"^^<http://www.w3.org/2001/XMLSchema#float>	"-96.0342"^^<http://www.w3.org/2001/XMLSchema#float>
<http://dbpedia.org/resource/East_North_Central_states>	"East North Central states"@en	"The East North Central states form one of the nine geographic subdivisions within the United States which are officially recognized by the United States Census Bureau. These states are near the Great Lakes. The division contains five states: Illinois, Indiana, Michigan, Ohio, and Wisconsin. It is one of two divisions used to categorize the region of the U.S. generally called the \"Midwest\"; the other such division is the West North Central states (The Great Plains States). The region closely matches the area of the Northwest Territory, excepting a portion of Minnesota."@en	"46421564"^^<http://www.w3.org/2001/XMLSchema#integer>	""	""
<http://dbpedia.org/resource/National_Capital_Region_(India)>	"National Capital Region (India)"@en	"The Delhi National Capital Region (NCR) is a central planning region centred upon the National Capital Territory in India.The NCR is Not a part of NCT Delhi but is cames under Delhi metropolitan area or Delhi NCR.It encompasses the entire NCT of Delhi and several districts surrounding it from the states of Haryana, Uttar Pradesh and Rajasthan. The NCR and the associated National Capital Region Planning Board were created in 1985 to plan the development of the region and to evolve harmonized policies for the control of land-uses and development of infrastructure in the region. Prominent cities of NCR include Delhi, Ghaziabad, Faridabad, Gurugram, Noida, Meerut, Bulandshahr, Karnal, Rohtak, Alwar, Bharatpur, Sonipat, Panipat and Mathura."@en	"46069000"^^<http://www.w3.org/2001/XMLSchema#integer>	"28.6606"^^<http://www.w3.org/2001/XMLSchema#float>	"77.1089"^^<http://www.w3.org/2001/XMLSchema#float>
<http://dbpedia.org/resource/Yunnan>	"Yunnan"@en	"Yunnan () is a province in the southwest of the People's Republic of China. The province spans approximately 394,000 square kilometres (152,000 sq mi) and has a population of 48.300 million (as of 2018). The capital of the province is Kunming, formerly also known as Yunnan. The province borders the Chinese provinces of Guizhou, Sichuan, autonomous regions of Guangxi, and Tibet as well as Southeast Asian countries: Vietnam, Laos, and Myanmar. Yunnan is China's fourth least developed province based on disposable income per capita in 2014."@en	"45966239"^^<http://www.w3.org/2001/XMLSchema#integer>	"25.05"^^<http://www.w3.org/2001/XMLSchema#float>	"101.867"^^<http://www.w3.org/2001/XMLSchema#float>
<http://dbpedia.org/resource/Jiangxi>	"Jiangxi"@en	"Jiangxi (; alternately romanized as Kiangsi or Chianghsi, Gan Chinese: Kongsi, Hakka: Gong Si) is a landlocked province in the east of the People's Republic of China. Its capital and largest city is Nanchang. Spanning from the banks of the Yangtze river in the north into hillier areas in the south and east, it shares a border with Anhui to the north, Zhejiang to the northeast, Fujian to the east, Guangdong to the south, Hunan to the west, and Hubei to the northwest."@en	"45200000"^^<http://www.w3.org/2001/XMLSchema#integer>	"27.3"^^<http://www.w3.org/2001/XMLSchema#float>	"116.0"^^<http://www.w3.org/2001/XMLSchema#float>
<http://dbpedia.org/resource/Liaoning>	"Liaoning"@en	"Liaoning (), is a coastal province in Northeast China that is the smallest, southernmost, and most populous province in the region. Located on the northern shore of the Yellow Sea, it is the northernmost coastal province of the People's Republic of China."@en	"43900000"^^<http://www.w3.org/2001/XMLSchema#integer>	"41.1"^^<http://www.w3.org/2001/XMLSchema#float>	"122.3"^^<http://www.w3.org/2001/XMLSchema#float>

Received 3135 rows in 0.104 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/eionet/data/local-sparql-queries/most-populated-places/daviz.json

For system integrators

Linked Data query (SPARQL)

The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.

Are you new to Linked Data technology? visit http://linkeddata.org

SPARQL Endpoint:
http://dbpedia.org/sparql

SPARQL Query:


        PREFIX o: <http://dbpedia.org/ontology/>
PREFIX p: <http://dbpedia.org/property/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>

SELECT DISTINCT * WHERE {
?subject a o:PopulatedPlace.
?subject rdfs:label ?label.
OPTIONAL {?subject rdfs:comment ?abstract.}
?subject p:populationTotal ?populationTotal.
OPTIONAL {?subject geo:lat ?latitude.}
OPTIONAL {?subject geo:long ?longitude.}
FILTER (lang(?label) = "en" && lang(?abstract) = "en" && (?populationTotal >= "1000000"^^xsd:integer && ?populationTotal < "50000000"^^xsd:integer))
} ORDER BY DESC(?populationTotal)