Skip to content

Instantly share code, notes, and snippets.

@jnsprnw

jnsprnw/berlin.csv

Last active August 15, 2017 19:23
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jnsprnw/402a6416fb60b0a69001ed2a032b0ed1 to your computer and use it in GitHub Desktop.
Save jnsprnw/402a6416fb60b0a69001ed2a032b0ed1 to your computer and use it in GitHub Desktop.
Download ZIP
Wikidata
Raw
berlin.csv
attribute identifier value
highest point P610 Arkenberge (Q19259618) ()
topic's main Wikimedia portal P1151 Portal:Berlin (Q3248436) ()
instance of P31 seat of government (Q1901835) ();metropolis (Q200250) ();federal capital (Q257391) (+1990-10-03T00:00:00Z);big city (Q1549591) ();state of Germany (Q1221156) ();municipality of Germany (Q262166) ();city with millions of inhabitants (Q1637706) ();city-state (Q133442) ();integrated municipality (Q1307779) ();city (Q515) ();Einheitsgemeinde of Germany (Q15974307) ()
contains administrative territorial entity P150 Mitte (Q163966) ();Friedrichshain-Kreuzberg (Q158893) ();Pankow (Q163012) ();Charlottenburg-Wilmersdorf (Q158095) ();Spandau (Q158083) ();Steglitz-Zehlendorf (Q158064) ();Tempelhof-Schöneberg (Q158106) ();Neukölln (Q4071168) ();Treptow-Köpenick (Q158089) ();Marzahn-Hellersdorf (Q119284) ();Lichtenberg (Q329609) ();Reinickendorf (Q158876) ()
legislative body P194 Abgeordnetenhaus of Berlin (Q640859) ()
highest judicial authority P209 Constitutional Court of the State of Berlin (Q2515458) ()
sister city P190 Los Angeles (Q65) (+1967-06-27T00:00:00Z);Madrid (Q2807) (+1988-11-04T00:00:00Z);Istanbul (Q406) (+1989-11-17T00:00:00Z);Warsaw (Q270) (+1991-08-12T00:00:00Z);Moscow (Q649) (+1991-08-28T00:00:00Z);Brussels (Q239) (+1992-06-01T00:00:00Z);Jakarta (Q3630) (+1994-04-13T00:00:00Z);Tashkent (Q269) (+1993-04-30T00:00:00Z);Mexico City (Q1489) (+1993-09-01T00:00:00Z);Beijing (Q956) (+1994-04-05T00:00:00Z);Tokyo (Q1490) (+1994-05-14T00:00:00Z);Buenos Aires (Q1486) (+1994-05-19T00:00:00Z);Prague (Q1085) (+1995-06-10T00:00:00Z);Windhoek (Q3935) (+2000-07-06T00:00:00Z);London (Q84) (+2000-10-10T00:00:00Z);Budapest (Q1781) (+1992-08-28T00:00:00Z);Paris (Q90) (+1987-07-02T00:00:00Z);Brussels (Q9005) (+1992-06-01T00:00:00Z)
country P17 Germany (Q183) (+1990-10-03T00:00:00Z);East Germany (Q16957) (+1990-10-02T00:00:00Z);Soviet occupation zone (Q55300) (+1949-10-06T00:00:00Z);Nazi Germany (Q7318) (+1933-01-30T00:00:00Z);Weimar Republic (Q41304) (+1919-11-09T00:00:00Z);German Empire (Q43287) (+1871-01-18T00:00:00Z);North German Confederation (Q150981) (+1866-08-18T00:00:00Z);Kingdom of Prussia (Q27306) (+1866-08-17T00:00:00Z);Brandenburg-Prussia (Q157367) (+1701-01-17T00:00:00Z);Margraviate of Brandenburg (Q148499) (+1618-08-26T00:00:00Z)
Dewey Decimal Classification P1036 2--43155 ()
ISNI P213 0000 0001 2341 9654 ()
flag P163 flag of Berlin (Q819691) ()
flag image P41 Flag of Berlin.svg ()
coat of arms image P94 Coat of arms of Berlin.svg ()
shares border with P47 Brandenburg (Q1208) ();Barnim (Q6115) ();Märkisch-Oderland (Q6181) ();Oder-Spree (Q6178) ();Dahme-Spreewald (Q6173) ();Teltow-Fläming (Q6146) ();Potsdam-Mittelmark (Q6142) ();Potsdam (Q1711) ();Havelland (Q6139) ();Oberhavel (Q6119) ();Kleinmachnow (Q104192) ();Stahnsdorf (Q640426) ()
ISO 3166-2 code P300 DE-BE ()
OpenStreetMap Relation identifier P402 62422 ()
Commons category P373 Berlin ()
coat of arms P237 coat of arms of Berlin (Q819737) ()
locator map image P242 Locator map Berlin in Germany.svg ();Berlin, administrative divisions (+districts +boroughs +pop) - de - colored (less colors).svg ()
postal code P281 10115–14199 ()
located in time zone P421 UTC+01:00 (Q6655) ();Central European Time (Q25989) ();UTC+02:00 (Q6723) ()
local dialing code P473 030 ()
VIAF ID P214 122530980 ()
GND ID P227 4005728-8 ()
licence plate code P395 B (+1950-00-00T00:00:00Z);I (+1952-00-00T00:00:00Z)
in the administrative territorial entity P131 Germany (Q183) (+1990-00-00T00:00:00Z);Nazi Germany (Q7318) (+1933-00-00T00:00:00Z);Free State of Prussia (Q161036) (+1918-00-00T00:00:00Z);Kingdom of Prussia (Q27306) (+1881-00-00T00:00:00Z);Province of Brandenburg (Q700264) (+1815-00-00T00:00:00Z);Kingdom of Prussia (Q27306) (+1701-00-00T00:00:00Z);Brandenburg-Prussia (Q157367) (+1618-00-00T00:00:00Z);Margraviate of Brandenburg (Q148499) (+1157-00-00T00:00:00Z)
coordinate location P625 {latitude=>52.516666666667, longitude=>13.383333333333, altitude=>nil, precision=>0.016666666666667, globe=>http://www.wikidata.org/entity/Q2} ()
enclave within P501 Brandenburg (Q1208) ()
topic's main category P910 Category:Berlin (Q4579913) ()
head of government P6 Klaus Wowereit (Q8863) (+2001-06-16T00:00:00Z);Eberhard Diepgen (Q60957) (+1991-01-24T00:00:00Z);Walter Momper (Q61085) (+1991-01-24T00:00:00Z);Eberhard Diepgen (Q60957) (+1984-02-09T00:00:00Z);Richard von Weizsäcker (Q2567) (+1984-02-09T00:00:00Z);Hans-Jochen Vogel (Q552483) (+1981-06-11T00:00:00Z);Dietrich Stobbe (Q68748) (+1981-01-23T00:00:00Z);Klaus Schütz (Q215756) (+1977-05-02T00:00:00Z);Heinrich Albertz (Q705862) (+1967-10-19T00:00:00Z);Willy Brandt (Q2514) (+1957-10-03T00:00:00Z);Franz Amrehn (Q96399) (+1957-10-03T00:00:00Z);Otto Suhr (Q650878) (+1957-08-30T00:00:00Z);Walther Schreiber (Q69232) (+1955-01-11T00:00:00Z);Ernst Reuter (Q213561) (+1953-10-22T00:00:00Z);Michael Müller (Q102844) (+2014-12-11T00:00:00Z)
Wikivoyage banner P948 Berlin banner 2.jpg ()
official website P856 http://www.berlin.de/ ()
MusicBrainz area ID P982 c9ac1239-e832-41bc-9930-e252a1fd1105 ()
dmoz ID P998 Regional/Europe/Germany/States/Berlin/ ();World/Deutsch/Regional/Europa/Deutschland/Berlin/ ();World/Español/Regional/Europa/Alemania/Estados/Berlín/ ();World/Esperanto/Regionoj/Eŭropo/Germanio/Berlino/ ();World/Français/Régional/Europe/Allemagne/Etats_fédérés/Berlin/ ();World/Italiano/Regionale/Europa/Germania/Berlino/ ();World/Polski/Regionalne/Europa/Niemcy/Berlin/ ();World/Svenska/Regionalt/Europa/Tyskland/Städer_och_kommuner/Berlin/ ();World/Russian/Страны_и_регионы/Европа/Германия/Берлин/ ();World/Japanese/地域/ヨーロッパ/ドイツ/市町村/ベルリン/ ()
German municipality key P439 11000000 ()
NUTS code P605 DE3 ();DE30 (+2003-07-01T00:00:00Z);DE300 (+2003-07-01T00:00:00Z)
LAU P782 11000000 ()
NDL ID P349 00629194 ()
Freebase ID P646 /m/0156q ()
LCAuth ID P244 n79034972 ()
FIPS 10-4 (countries and regions) P901 GM16 ()
population P1082 {amount=>+1200, unit=>1} (+1250-01-01T00:00:00Z);{amount=>+7000, unit=>1, upperBound=>+7000, lowerBound=>+7000} (+1307-01-01T00:00:00Z);{amount=>+8500, unit=>1, upperBound=>+8500, lowerBound=>+8500} (+1400-01-01T00:00:00Z);{amount=>+7000, unit=>1, upperBound=>+7000, lowerBound=>+7000} (+1450-01-01T00:00:00Z);{amount=>+12000, unit=>1, upperBound=>+12000, lowerBound=>+12000} (+1576-01-01T00:00:00Z);{amount=>+9000, unit=>1, upperBound=>+9000, lowerBound=>+9000} (+1600-01-01T00:00:00Z);{amount=>+8100, unit=>1, upperBound=>+8100, lowerBound=>+8100} (+1631-01-01T00:00:00Z);{amount=>+7500, unit=>1, upperBound=>+7500, lowerBound=>+7500} (+1640-01-01T00:00:00Z);{amount=>+6000, unit=>1, upperBound=>+6000, lowerBound=>+6000} (+1648-01-01T00:00:00Z);{amount=>+10000, unit=>1, upperBound=>+10000, lowerBound=>+10000} (+1680-00-00T00:00:00Z);{amount=>+17000, unit=>1, upperBound=>+17000, lowerBound=>+17000} (+1685-00-00T00:00:00Z);{amount=>+19000, unit=>1, upperBound=>+20000, lowerBound=>+18000} (+1688-00-00T00:00:00Z);{amount=>+172988, unit=>1, upperBound=>+172988, lowerBound=>+172988} (+1801-00-00T00:00:00Z);{amount=>+401972, unit=>1, upperBound=>+401973, lowerBound=>+401971} (+1852-00-00T00:00:00Z);{amount=>+1888848, unit=>1} (+1900-12-31T00:00:00Z);{amount=>+2071257, unit=>1, upperBound=>+2071258, lowerBound=>+2071256} (+1910-12-31T00:00:00Z);{amount=>+3879409, unit=>1, upperBound=>+3879410, lowerBound=>+3879408} (+1920-12-31T00:00:00Z);{amount=>+4332834, unit=>1, upperBound=>+4332835, lowerBound=>+4332833} (+1930-12-31T00:00:00Z);{amount=>+4330810, unit=>1, upperBound=>+4330811, lowerBound=>+4330809} (+1940-12-31T00:00:00Z);{amount=>+3336026, unit=>1, upperBound=>+3336027, lowerBound=>+3336025} (+1950-12-31T00:00:00Z);{amount=>+3274016, unit=>1, upperBound=>+3274017, lowerBound=>+3274015} (+1960-12-31T00:00:00Z);{amount=>+3208719, unit=>1, upperBound=>+3208720, lowerBound=>+3208718} (+1970-12-31T00:00:00Z);{amount=>+3048759, unit=>1, upperBound=>+3048760, lowerBound=>+3048758} (+1980-12-31T00:00:00Z);{amount=>+3433695, unit=>1, upperBound=>+3433696, lowerBound=>+3433694} (+1990-12-31T00:00:00Z);{amount=>+3382169, unit=>1, upperBound=>+3382170, lowerBound=>+3382168} (+2000-12-31T00:00:00Z);{amount=>+3326002, unit=>1, upperBound=>+3326003, lowerBound=>+3326001} (+2011-12-31T00:00:00Z);{amount=>+3375222, unit=>1, upperBound=>+3375223, lowerBound=>+3375221} (+2012-12-31T00:00:00Z);{amount=>+3469849, unit=>1} (+2014-12-31T00:00:00Z);{amount=>+219968, unit=>1, upperBound=>+219968, lowerBound=>+219968} (+1825-00-00T00:00:00Z);{amount=>+172132, unit=>1, upperBound=>+172132, lowerBound=>+172132} (+1800-00-00T00:00:00Z);{amount=>+136137, unit=>1, upperBound=>+136137, lowerBound=>+136137} (+1775-00-00T00:00:00Z);{amount=>+113289, unit=>1, upperBound=>+113289, lowerBound=>+113289} (+1750-00-00T00:00:00Z)
BnF ID P268 15298132w ()
inception P571 {time=>+1237-01-01T00:00:00Z, timezone=>0, before=>0, after=>0, precision=>9, calendarmodel=>http://www.wikidata.org/entity/Q1985727} ()
category for people born here P1464 Category:People born in Berlin (Q15068755) ()
category for people who died here P1465 Category:Deaths in Berlin (Q9217674) ()
GeoNames ID P1566 2950157 ()
time of earliest written record P1249 {time=>+1237-00-00T00:00:00Z, timezone=>0, before=>0, after=>0, precision=>9, calendarmodel=>http://www.wikidata.org/entity/Q1985727} ();{time=>+1244-00-00T00:00:00Z, timezone=>0, before=>0, after=>0, precision=>9, calendarmodel=>http://www.wikidata.org/entity/Q1985727} ()
category for films shot at this location P1740 Category:Films shot in Berlin (Q6769919) ()
located next to body of water P206 Spree (Q1684) ();Großer Wannsee (Q3908364) ();Lake Tegel (Q697916) ();Havel (Q1682) ()
category of associated people P1792 Category:People from Berlin (Q6151539) ()
category of people buried here P1791 Category:Burials in Berlin by place (Q7975011) ()
SELIBR P906 161170 ()
German regional key P1388 11 ()
award received P166 Princess of Asturias Award for Concord (Q3323440) (+2009-00-00T00:00:00Z)
described by source P1343 Catholic Encyclopedia (Q302556) ();Small Brockhaus and Efron Encyclopedic Dictionary (Q19180675) ();Brockhaus and Efron Encyclopedic Dictionary (Q602358) ();Sytin Military Encyclopedia (Q4114391) ();Jewish Encyclopedia of Brockhaus and Efron (Q4173137) ()
capital of P1376 Germany (Q183) ();Nazi Germany (Q7318) ();Kingdom of Prussia (Q27306) ();Weimar Republic (Q41304) ();Brandenburg-Prussia (Q157367) ();Free State of Prussia (Q161036) ();Allied-occupied Germany (Q2415901) ()
office held by head of government P1313 Governing Mayor of Berlin (Q641159) ()
LAC ID P1670 0053C1712 ()
National Library of Israel ID P949 000974947 ()
BNE ID P950 XX451163 ()
part of P361 Berlin/Brandenburg Metropolitan Region (Q648102) ();agglomeration of Berlin (Q15781847) ()
area P2046 {amount=>+891.68, unit=>http://www.wikidata.org/entity/Q712226} ()
IPA transcription P898 bɛɐ̯ˈliːn ();bərˈlɪn ();bɛʁ.lɛ̃ ()
pronunciation audio P443 De-Berlin.ogg ();De-Berlin-2.ogg ();Berlintitle.ogg ();Pl-Berlin.ogg ();Cs-Berlín.ogg ();Nl-Berlijn.ogg ();Jer-Bèrlîn.ogg ()
history of topic P2184 history of Berlin (Q679741) ()
FAST-ID P2163 1204829 ()
image P18 Berlin Montage 4.jpg ();Cityscape Berlin.jpg ()
Commons gallery P935 Berlin ()
replaces P1365 Alt-Berlin (Q321674) ()
Genealogical Gazetteer (GOV) ID P2503 BERLINJO62PM ()
Facebook Places ID P1997 111175118906315 ()
geography of topic P2633 Geography of Berlin (Q5535125) ()
Encyclopædia Britannica Online ID P1417 place/Berlin ()
elevation above sea level P2044 {amount=>+34, unit=>http://www.wikidata.org/entity/Q11573, upperBound=>+35, lowerBound=>+33} ()
permanent duplicated item P2959 (Q21286937) ()
collage image P2716 Collage Berlin2.jpg ()
Quora topic ID P3417 Berlin ()
MeSH ID P486 D001604 ()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment