logo Netzschleuder network catalog, repository, and centrifuge

sister_cities — Sister cities (Wikidata)

Description

Directed networks of cities and other places of the world connected by "sister city" (twin town) relationships, as recorded in Wikidata with the property "twinned administrative body" (P190). Each node is a Wikidata item, and a directed edge from A to B means that the item of A lists B as twinned with it. The relationship is symmetric in reality, but it is not always recorded on both items, so that a pair of twinned places can be connected by edges in one or both directions.

Only the statements of items that are instances of "human settlement" (Q486972) or of any of its subclasses (property paths P31/P279*) are included, i.e. the edges whose source is such an item; their targets may be other kinds of places (e.g. regions or districts that have twin towns), which are marked by the property is_city. Only the preferred (or, if there is none, the normal) statements are used ("truthy" statements), and statements whose value is "unknown" are left out.

There are two networks:

  • 2017: from the Wikidata dump of "truthy" statements of 16 November 2017 (the class hierarchy of that time is used for the selection).
  • 2026: from the Wikidata Query Service, reflecting the state of Wikidata at the time of download (October 2026).

The networks have the following properties:

  • (Node) wikidata_id: the Wikidata identifier of the item (e.g. Q64 for Berlin).
  • (Node) name: the English label of the item (empty if it has none).
  • (Node) is_city: whether the item is an instance of "human settlement" or of one of its subclasses.
  • (Node) latitude, longitude: the coordinates of the item (property P625; NaN if it has none, or only coordinates on another celestial body); if it has several, one of them.
  • (Node) country: the English labels of the countries the item belongs to (property P17), separated by semicolons (empty if none).
Tags
Social Offline Relationships Unweighted Metadata
Added
2026-10-27
Citation
  • D. Vrandečić, M. Krötzsch, "Wikidata: a free collaborative knowledgebase." Communications of the ACM 57, 78-85 (2014). 10.1145/2629489 Sci-Hub
Upstream URL OK
https://www.wikidata.org/wiki/Property:P190
https://archive.org/details/wikibase-wikidatawiki-20171116
https://query.wikidata.org/
Upstream license
CC0 1.0 (Wikidata), https://www.wikidata.org/wiki/Wikidata:Licensing
Networks
Tip: click on a column header to sort the list, or hover over it for a description.
Column legend
$\left<k\right>$
Mean degree
$\sigma_k$
Standard deviation of the degrees
$\lambda_h$
Largest eigenvalue of the Hashimoto (non-backtracking) matrix
$\tau$
Random walk mixing time
$r$
Degree assortativity
$c$
Global clustering coefficient
$\oslash$
(Pseudo-) diameter
$S$
Relative size of the largest component
NPs
Node properties
EPs
Edge properties
Name Nodes Edges $\left<k\right>$ $\sigma_k$ $\lambda_h$ $\tau$ $r$ $c$ $\oslash$ $S$ Kind Mode NPs EPs gt GraphML GML csv
2017 — — — — — — — — — — 262 KiB 357 KiB 354 KiB 283 KiB
2026 — — — — — — — — — — 262 KiB 357 KiB 354 KiB 283 KiB
Ridiculograms*
* These are automatically generated force-directed visualizations, and can be quite meaningless for networks both big and small. They should not be taken seriously as sources of scientific insight. See here for a discussion.