DBpedia JSON Extractor

dbpedia.jsonl

{"comment": "Kaiserslautern ([\u02ccka\u026az\u0250s\u02c8la\u028at\u0250n]) is a city in southwest Germany, located in the Bundesland (State) of Rhineland-Palatinate (Rheinland-Pfalz) at the edge of the Palatinate Forest (Pf\u00e4lzerwald). The historic centre dates to the 9th century. It is 459 kilometres (285 miles) from Paris, 117 km (73 miles) from Frankfurt am Main, and 159 km (99 miles) from Luxembourg.", "pic": "http://commons.wikimedia.org/wiki/Special:FilePath/Kaiserslautern-Stadtwappen.svg", "uri": "http://dbpedia.org/resource/Kaiserslautern", "label": "Kaiserslautern", "areaTotal": "1.3972e+08", "types": ["http://www.w3.org/2002/07/owl#Thing", "http://www.wikidata.org/entity/Q3957", "http://www.wikidata.org/entity/Q486972", "http://dbpedia.org/ontology/PopulatedPlace", "http://dbpedia.org/ontology/Settlement", "http://dbpedia.org/ontology/Town", "http://www.w3.org/2003/01/geo/wgs84_pos#SpatialThing", "http://schema.org/Place", "http://dbpedia.org/ontology/Place", "http://dbpedia.org/ontology/Location", "http://umbel.org/umbel/rc/Town", "http://dbpedia.org/class/yago/AdministrativeDistrict108491826", "http://dbpedia.org/class/yago/City108524735", "http://dbpedia.org/class/yago/District108552138", "http://dbpedia.org/class/yago/GeographicalArea108574314", "http://dbpedia.org/class/yago/Location100027167", "http://dbpedia.org/class/yago/Municipality108626283", "http://dbpedia.org/class/yago/Object100002684", "http://dbpedia.org/class/yago/PhysicalEntity100001930", "http://dbpedia.org/class/yago/Region108630985", "http://dbpedia.org/class/yago/Town108665504", "http://dbpedia.org/class/yago/UrbanArea108675967", "http://dbpedia.org/class/yago/YagoGeoEntity", "http://dbpedia.org/class/yago/YagoLegalActorGeo", "http://dbpedia.org/class/yago/YagoPermanentlyLocatedEntity", "http://dbpedia.org/class/yago/WikicatCitiesInRhineland-Palatinate", "http://dbpedia.org/class/yago/WikicatImperialFreeCities", "http://dbpedia.org/class/yago/WikicatTownsInRhineland-Palatinate", "http://dbpedia.org/class/yago/WikicatUniversityTownsInGermany"]}
{"comment": "The Federal City of Bonn ([\u02c8b\u0254n]; Latin: Bonna) is a city on the banks of the Rhine and northwest of theSiebengebirge (Seven Mountains) in the German state of North Rhine-Westphalia, with a population of 311,287 within its administrative limits. Bonn serves alongside the capital Berlin as the seat of government of Germany. The city is the second official seat and second official residence of the President of Germany, the Chancellor of Germany, the Bundesrat, and the first official seat and first official residence of six German federal ministries. Bonn is located in the southernmost part of the Rhine-Ruhr region, the largest metropolitan area of Germany, with over 11 million inhabitants.", "pic": "http://commons.wikimedia.org/wiki/Special:FilePath/Bonn\u00dcbersicht.jpg", "uri": "http://dbpedia.org/resource/Bonn", "label": "Bonn", "areaTotal": "1.4106e+08", "types": ["http://www.w3.org/2002/07/owl#Thing", "http://www.wikidata.org/entity/Q486972", "http://www.wikidata.org/entity/Q515", "http://dbpedia.org/ontology/City", "http://dbpedia.org/ontology/PopulatedPlace", "http://dbpedia.org/ontology/Settlement", "http://www.w3.org/2003/01/geo/wgs84_pos#SpatialThing", "http://schema.org/City", "http://schema.org/Place", "http://dbpedia.org/ontology/Place", "http://dbpedia.org/ontology/Location", "http://umbel.org/umbel/rc/PopulatedPlace", "http://umbel.org/umbel/rc/Village", "http://umbel.org/umbel/rc/Location_Underspecified", "http://dbpedia.org/class/yago/Abstraction100002137", "http://dbpedia.org/class/yago/AdministrativeDistrict108491826", "http://dbpedia.org/class/yago/Area108497294", "http://dbpedia.org/class/yago/Artifact100021939", "http://dbpedia.org/class/yago/Camp102944826", "http://dbpedia.org/class/yago/Capital108518505", "http://dbpedia.org/class/yago/Center108523483", "http://dbpedia.org/class/yago/City108524735", "http://dbpedia.org/class/yago/District108552138", "http://dbpedia.org/class/yago/GeographicalArea108574314", "http://dbpedia.org/class/yago/Housing103546340", "http://dbpedia.org/class/yago/LanguageUnit106284225", "http://dbpedia.org/class/yago/LivingQuarters103679384", "http://dbpedia.org/class/yago/Location100027167", "http://dbpedia.org/class/yago/MilitaryQuarters103763727", "http://dbpedia.org/class/yago/Municipality108626283", "http://dbpedia.org/class/yago/Name106333653", "http://dbpedia.org/class/yago/NationalCapital108691669", "http://dbpedia.org/class/yago/Object100002684", "http://dbpedia.org/class/yago/Part113809207", "http://dbpedia.org/class/yago/PhysicalEntity100001930", "http://dbpedia.org/class/yago/Region108630985", "http://dbpedia.org/class/yago/Relation100031921", "http://dbpedia.org/class/yago/Seat108647945", "http://dbpedia.org/class/yago/Site108651247", "http://dbpedia.org/class/yago/Structure104341686", "http://dbpedia.org/class/yago/Town108665504", "http://dbpedia.org/class/yago/Tract108673395", "http://dbpedia.org/class/yago/TradeName106845599", "http://dbpedia.org/class/yago/UrbanArea108675967", "http://dbpedia.org/class/yago/Whole100003553", "http://dbpedia.org/class/yago/YagoGeoEntity", "http://dbpedia.org/class/yago/YagoLegalActorGeo", "http://dbpedia.org/class/yago/YagoPermanentlyLocatedEntity", "http://dbpedia.org/class/yago/WikicatBeerBrandsOfGermany", "http://dbpedia.org/class/yago/WikicatCitiesInGermany", "http://dbpedia.org/class/yago/WikicatCitiesInNorthRhine-Westphalia", "http://dbpedia.org/class/yago/WikicatFormerNationalCapitals", "http://dbpedia.org/class/yago/WikicatMunicipalitiesInNorthRhine-Westphalia", "http://dbpedia.org/class/yago/WikicatPopulatedPlacesOnTheRhine", "http://dbpedia.org/class/yago/WikicatRomanLegions'CampsInGermany", "http://dbpedia.org/class/yago/WikicatRomanTownsAndCities", "http://dbpedia.org/class/yago/WikicatRomanTownsAndCitiesInGermany", "http://dbpedia.org/class/yago/WikicatTownsInNorthRhine-Westphalia", "http://dbpedia.org/class/yago/WikicatUniversityTownsInGermany"]}
{"comment": "Cologne (/k\u0259\u02c8lo\u028an/; German K\u00f6ln [k\u0153ln], Colognian: K\u00f6lle [\u02c8k\u0153\u026b\u0259]), is the largest city both in the federal State of North Rhine-Westphalia in Germany and is the fourth-largest city in the country (after Berlin, Hamburg, and Munich). It is located within the Rhine-Ruhr metropolitan region, one of the major European metropolitan regions and the largest in Germany with more than ten million inhabitants.", "pic": "http://commons.wikimedia.org/wiki/Special:FilePath/Cologne_montage.png", "uri": "http://dbpedia.org/resource/Cologne", "label": "Cologne", "areaTotal": "4.0515e+08", "types": ["http://www.w3.org/2002/07/owl#Thing", "http://www.wikidata.org/entity/Q486972", "http://www.wikidata.org/entity/Q515", "http://dbpedia.org/ontology/City", "http://dbpedia.org/ontology/PopulatedPlace", "http://dbpedia.org/ontology/Settlement", "http://www.w3.org/2003/01/geo/wgs84_pos#SpatialThing", "http://schema.org/City", "http://schema.org/Place", "http://dbpedia.org/ontology/Place", "http://dbpedia.org/ontology/Location", "http://umbel.org/umbel/rc/City", "http://umbel.org/umbel/rc/PopulatedPlace", "http://umbel.org/umbel/rc/Village", "http://umbel.org/umbel/rc/Location_Underspecified", "http://dbpedia.org/class/yago/AdministrativeDistrict108491826", "http://dbpedia.org/class/yago/Artifact100021939", "http://dbpedia.org/class/yago/Camp102944826", "http://dbpedia.org/class/yago/City108524735", "http://dbpedia.org/class/yago/District108552138", "http://dbpedia.org/class/yago/GeographicalArea108574314", "http://dbpedia.org/class/yago/Housing103546340", "http://dbpedia.org/class/yago/LivingQuarters103679384", "http://dbpedia.org/class/yago/Location100027167", "http://dbpedia.org/class/yago/MilitaryQuarters103763727", "http://dbpedia.org/class/yago/Municipality108626283", "http://dbpedia.org/class/yago/Object100002684", "http://dbpedia.org/class/yago/PhysicalEntity100001930", "http://dbpedia.org/class/yago/Region108630985", "http://dbpedia.org/class/yago/Site108651247", "http://dbpedia.org/class/yago/Structure104341686", "http://dbpedia.org/class/yago/Town108665504", "http://dbpedia.org/class/yago/Tract108673395", "http://dbpedia.org/class/yago/UrbanArea108675967", "http://dbpedia.org/class/yago/Whole100003553", "http://dbpedia.org/class/yago/YagoGeoEntity", "http://dbpedia.org/class/yago/YagoLegalActorGeo", "http://dbpedia.org/class/yago/YagoPermanentlyLocatedEntity", "http://dbpedia.org/class/yago/WikicatCatholicPilgrimageSites", "http://dbpedia.org/class/yago/WikicatCitiesInGermany", "http://dbpedia.org/class/yago/WikicatCitiesInNorthRhine-Westphalia", "http://dbpedia.org/class/yago/WikicatHolyCities", "http://dbpedia.org/class/yago/WikicatImperialFreeCities", "http://dbpedia.org/class/yago/WikicatMunicipalitiesInNorthRhine-Westphalia", "http://dbpedia.org/class/yago/WikicatPopulatedPlacesEstablishedInThe1stCenturyBC", "http://dbpedia.org/class/yago/WikicatPopulatedPlacesOnTheRhine", "http://dbpedia.org/class/yago/WikicatRomanLegions'CampsInGermany", "http://dbpedia.org/class/yago/WikicatRomanTownsAndCitiesInGermany", "http://dbpedia.org/class/yago/WikicatTownsInNorthRhine-Westphalia", "http://dbpedia.org/class/yago/WikicatUniversityTownsInGermany", "http://dbpedia.org/class/yago/WikicatWorldHeritageSitesInGermany"]}
{"comment": "Berlin (/b\u0259r\u02c8l\u026an/, [b\u025b\u0250\u032f\u02c8li\u02d0n]) is the capital of Germany and one of the 16 states of Germany. With a population of 3.5 million people, it is the second most populous city proper and the seventh most populous urban area in the European Union. Located in northeastern Germany on the banks of Rivers Spree and Havel, it is the centre of the Berlin-Brandenburg Metropolitan Region, which has about six million residents from over 180 nations. Due to its location in the European Plain, Berlin is influenced by a temperate seasonal climate. Around one-third of the city's area is composed of forests, parks, gardens, rivers and lakes.", "pic": "http://commons.wikimedia.org/wiki/Special:FilePath/Coat_of_arms_of_Berlin.svg", "uri": "http://dbpedia.org/resource/Berlin", "label": "Berlin", "areaTotal": "8.9185e+08", "types": ["http://www.w3.org/2002/07/owl#Thing", "http://www.wikidata.org/entity/Q3455524", "http://www.wikidata.org/entity/Q486972", "http://dbpedia.org/ontology/AdministrativeRegion", "http://dbpedia.org/ontology/PopulatedPlace", "http://dbpedia.org/ontology/Region", "http://www.w3.org/2003/01/geo/wgs84_pos#SpatialThing", "http://schema.org/AdministrativeArea", "http://schema.org/Place", "http://dbpedia.org/ontology/Place", "http://dbpedia.org/ontology/Location", "http://dbpedia.org/ontology/%3Chttp://purl.org/dc/terms/Jurisdiction%3E", "http://umbel.org/umbel/rc/City", "http://umbel.org/umbel/rc/PopulatedPlace", "http://umbel.org/umbel/rc/Village", "http://umbel.org/umbel/rc/Location_Underspecified", "http://dbpedia.org/class/yago/AdministrativeDistrict108491826", "http://dbpedia.org/class/yago/Area108497294", "http://dbpedia.org/class/yago/Capital108518505", "http://dbpedia.org/class/yago/Center108523483", "http://dbpedia.org/class/yago/City108524735", "http://dbpedia.org/class/yago/District108552138", "http://dbpedia.org/class/yago/GeographicalArea108574314", "http://dbpedia.org/class/yago/Location100027167", "http://dbpedia.org/class/yago/Municipality108626283", "http://dbpedia.org/class/yago/Object100002684", "http://dbpedia.org/class/yago/PhysicalEntity100001930", "http://dbpedia.org/class/yago/Region108630985", "http://dbpedia.org/class/yago/Seat108647945", "http://dbpedia.org/class/yago/Section108648322", "http://dbpedia.org/class/yago/Site108651247", "http://dbpedia.org/class/yago/StateCapital108695539", "http://dbpedia.org/class/yago/Town108665504", "http://dbpedia.org/class/yago/Tract108673395", "http://dbpedia.org/class/yago/UrbanArea108675967", "http://dbpedia.org/class/yago/Vicinity108641113", "http://dbpedia.org/class/yago/YagoGeoEntity", "http://dbpedia.org/class/yago/YagoLegalActorGeo", "http://dbpedia.org/class/yago/YagoPermanentlyLocatedEntity", "http://dbpedia.org/class/yago/WikicatCapitalsInEurope", "http://dbpedia.org/class/yago/WikicatCitiesInGermany", "http://dbpedia.org/class/yago/WikicatCitiesWithMillionsOfInhabitants", "http://dbpedia.org/class/yago/WikicatGermanStateCapitals", "http://dbpedia.org/class/yago/WikicatLocalitiesOfBerlin", "http://dbpedia.org/class/yago/WikicatMunicipalitiesOfGermany", "http://dbpedia.org/class/yago/WikicatPopulatedPlacesEstablishedInThe13thCentury", "http://dbpedia.org/class/yago/WikicatStatesAndTerritoriesEstablishedIn1237", "http://dbpedia.org/class/yago/WikicatStatesOfGermany", "http://dbpedia.org/class/yago/WikicatUniversityTownsInGermany", "http://dbpedia.org/class/yago/WikicatWorldHeritageSitesInGermany"]}
{"comment": "Leipzig (/\u02c8la\u026aps\u026a\u0261/; [\u02c8la\u026apts\u026a\u00e7]) is the largest city in the federal state of Saxony, Germany. With its population of 544,479 inhabitants (1,001,220 residents in the larger urban zone) Leipzig, one of Germany's top 15 cities by population, is located about 160 kilometers (99 miles) southwest of Berlin at the confluence of the White Elster, Pleisse, and Parthe rivers at the southerly end of the North German Plain.", "pic": "http://commons.wikimedia.org/wiki/Special:FilePath/Flag_of_Leipzig.svg", "uri": "http://dbpedia.org/resource/Leipzig", "label": "Leipzig", "areaTotal": "2.9736e+08", "types": ["http://www.w3.org/2002/07/owl#Thing", "http://www.wikidata.org/entity/Q3957", "http://www.wikidata.org/entity/Q486972", "http://dbpedia.org/ontology/PopulatedPlace", "http://dbpedia.org/ontology/Settlement", "http://dbpedia.org/ontology/Town", "http://www.w3.org/2003/01/geo/wgs84_pos#SpatialThing", "http://schema.org/Place", "http://dbpedia.org/ontology/Place", "http://dbpedia.org/ontology/Location", "http://umbel.org/umbel/rc/PopulatedPlace", "http://umbel.org/umbel/rc/Town", "http://umbel.org/umbel/rc/Village", "http://umbel.org/umbel/rc/Location_Underspecified", "http://dbpedia.org/class/yago/AdministrativeDistrict108491826", "http://dbpedia.org/class/yago/City108524735", "http://dbpedia.org/class/yago/District108552138", "http://dbpedia.org/class/yago/GeographicalArea108574314", "http://dbpedia.org/class/yago/Location100027167", "http://dbpedia.org/class/yago/Municipality108626283", "http://dbpedia.org/class/yago/Object100002684", "http://dbpedia.org/class/yago/PhysicalEntity100001930", "http://dbpedia.org/class/yago/Region108630985", "http://dbpedia.org/class/yago/Town108665504", "http://dbpedia.org/class/yago/UrbanArea108675967", "http://dbpedia.org/class/yago/YagoGeoEntity", "http://dbpedia.org/class/yago/YagoLegalActorGeo", "http://dbpedia.org/class/yago/YagoPermanentlyLocatedEntity", "http://dbpedia.org/class/yago/WikicatCitiesInGermany", "http://dbpedia.org/class/yago/WikicatCitiesInSaxony", "http://dbpedia.org/class/yago/WikicatUniversityTownsInGermany"]}

dbpedia_json_extractor.ipynb

uris.txt

http://dbpedia.org/resource/Kaiserslautern
http://dbpedia.org/resource/Leipzig
http://dbpedia.org/resource/Berlin
http://dbpedia.org/resource/Bonn
http://dbpedia.org/resource/Cologne