blog/Graphing_the_Norwegian_company_ownership_structure.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
   2           "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
   3 <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr">
   4   <head>
   5     <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
   6     <title>Petter Reinholdtsen: Graphing the Norwegian company ownership structure</title>
   7     <link rel="stylesheet" type="text/css" media="screen" href="http://people.skolelinux.org/pere/blog/style.css" />
   8     <link rel="stylesheet" type="text/css" media="screen" href="http://people.skolelinux.org/pere/blog/vim.css" />
   9
  10
  11   </head>
  12   <body>
  13     <div class="title">
  14  <h1>
  15      <a href="http://people.skolelinux.org/pere/blog/">Petter Reinholdtsen</a>
  16
  17  </h1>
  18
  19 </div>
  20
  21
  22     <div class="entry">
  23       <div class="title">Graphing the Norwegian company ownership structure</div>
  24       <div class="date">15th June 2015</div>
  25       <div class="body"><p>It is a bit work to figure out the ownership structure of companies
  26 in Norway.  The information is publicly available, but one need to
  27 recursively look up ownership for all owners to figure out the complete
  28 ownership graph of a given set of companies.  To save me the work in
  29 the future, I wrote a script to do this automatically, outputting the
  30 ownership structure using the Graphviz/dotty format.  The data source
  31 is web scraping from <a href="http://www.proff.no/">Proff</a>, because
  32 I failed to find a useful source directly from the official keepers of
  33 the ownership data, <a href="http://www.brreg.no/">Brønnøysundsregistrene</a>.</p>
  34
  35 <p>To get an owner ship graph for a set of companies, fetch
  36 <a href="https://github.com/petterreinholdtsen/brreg-norway-ownership-graph">the code from git</a> and run it using the organisation number.  I'm
  37 using the Norwegian newspaper Dagbladet as an example here, as its
  38 ownership structure is very simple:</p>
  39
  40 <pre>
  41 % time ./bin/eierskap-dotty 958033540 > dagbladet.dot
  42
  43 real    0m2.841s
  44 user    0m0.184s
  45 sys     0m0.036s
  46 %
  47 </pre>
  48
  49 <p>The script accept several organisation numbers on the command line,
  50 allowing a cluster of companies to be graphed in the same image.  The
  51 resulting dot file for the example above look like this.  The edges
  52 are labeled with the ownership percentage, and the nodes uses the
  53 organisation number as their name and the name as the label:</p>
  54
  55 <pre>
  56 digraph ownership {
  57 rankdir = LR;
  58 "Aller Holding A/s" -> "910119877" [label="100%"]
  59 "910119877" -> "998689015" [label="100%"]
  60 "998689015" -> "958033540" [label="99%"]
  61 "974530600" -> "958033540" [label="1%"]
  62 "958033540" [label="AS DAGBLADET"]
  63 "998689015" [label="Berner Media Holding AS"]
  64 "974530600" [label="Dagbladets Stiftelse"]
  65 "910119877" [label="Aller Media AS"]
  66 }
  67 </pre>
  68
  69 <p>To view the ownership graph, run "<tt>dotty dagbladet.dot</tt>" or
  70 convert it to a PNG using "<tt>dot -T png dagbladet.dot >
  71 dagbladet.png</tt>".  This is the result can be seen below:</p>
  72
  73 <img src="http://people.skolelinux.org/pere/blog/images/2015-06-15-ownership-graphs-norway-dagbladet.png" width="80%">
  74
  75 <p>Note that I suspect the "Aller Holding A/S" entry to be incorrect
  76 data in the official ownership register, as that name is not
  77 registered in the official company register for Norway.  The ownership
  78 register is sensitive to typos and there seem to be no strict checking
  79 of the ownership links.</p>
  80
  81 <p>Let me know if you improve the script or find better data sources.
  82 The code is licensed according to GPL 2 or newer.</p>
  83 </div>
  84
  85       <div class="tags">Tags: <a href="http://people.skolelinux.org/pere/blog/tags/english">english</a>, <a href="http://people.skolelinux.org/pere/blog/tags/offentlig innsyn">offentlig innsyn</a>.</div>
  86
  87
  88     </div>
  89
  90
  91
  92
  93     <div id="sidebar">
  94
  95
  96
  97 <h2>Archive</h2>
  98 <ul>
  99
 100 <li>2015
 101 <ul>
 102
 103 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/01/">January (7)</a></li>
 104
 105 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/02/">February (6)</a></li>
 106
 107 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/03/">March (1)</a></li>
 108
 109 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/04/">April (4)</a></li>
 110
 111 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/05/">May (3)</a></li>
 112
 113 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/06/">June (3)</a></li>
 114
 115 </ul></li>
 116
 117 <li>2014
 118 <ul>
 119
 120 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/01/">January (2)</a></li>
 121
 122 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/02/">February (3)</a></li>
 123
 124 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/03/">March (8)</a></li>
 125
 126 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/04/">April (7)</a></li>
 127
 128 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/05/">May (1)</a></li>
 129
 130 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/06/">June (2)</a></li>
 131
 132 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/07/">July (2)</a></li>
 133
 134 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/08/">August (2)</a></li>
 135
 136 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/09/">September (5)</a></li>
 137
 138 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/10/">October (6)</a></li>
 139
 140 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/11/">November (3)</a></li>
 141
 142 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/12/">December (5)</a></li>
 143
 144 </ul></li>
 145
 146 <li>2013
 147 <ul>
 148
 149 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/01/">January (11)</a></li>
 150
 151 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/02/">February (9)</a></li>
 152
 153 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/03/">March (9)</a></li>
 154
 155 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/04/">April (6)</a></li>
 156
 157 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/05/">May (9)</a></li>
 158
 159 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/06/">June (10)</a></li>
 160
 161 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/07/">July (7)</a></li>
 162
 163 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/08/">August (3)</a></li>
 164
 165 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/09/">September (5)</a></li>
 166
 167 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/10/">October (7)</a></li>
 168
 169 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/11/">November (9)</a></li>
 170
 171 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/12/">December (3)</a></li>
 172
 173 </ul></li>
 174
 175 <li>2012
 176 <ul>
 177
 178 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/01/">January (7)</a></li>
 179
 180 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/02/">February (10)</a></li>
 181
 182 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/03/">March (17)</a></li>
 183
 184 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/04/">April (12)</a></li>
 185
 186 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/05/">May (12)</a></li>
 187
 188 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/06/">June (20)</a></li>
 189
 190 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/07/">July (17)</a></li>
 191
 192 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/08/">August (6)</a></li>
 193
 194 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/09/">September (9)</a></li>
 195
 196 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/10/">October (17)</a></li>
 197
 198 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/11/">November (10)</a></li>
 199
 200 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/12/">December (7)</a></li>
 201
 202 </ul></li>
 203
 204 <li>2011
 205 <ul>
 206
 207 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/01/">January (16)</a></li>
 208
 209 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/02/">February (6)</a></li>
 210
 211 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/03/">March (6)</a></li>
 212
 213 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/04/">April (7)</a></li>
 214
 215 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/05/">May (3)</a></li>
 216
 217 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/06/">June (2)</a></li>
 218
 219 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/07/">July (7)</a></li>
 220
 221 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/08/">August (6)</a></li>
 222
 223 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/09/">September (4)</a></li>
 224
 225 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/10/">October (2)</a></li>
 226
 227 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/11/">November (3)</a></li>
 228
 229 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/12/">December (1)</a></li>
 230
 231 </ul></li>
 232
 233 <li>2010
 234 <ul>
 235
 236 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/01/">January (2)</a></li>
 237
 238 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/02/">February (1)</a></li>
 239
 240 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/03/">March (3)</a></li>
 241
 242 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/04/">April (3)</a></li>
 243
 244 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/05/">May (9)</a></li>
 245
 246 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/06/">June (14)</a></li>
 247
 248 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/07/">July (12)</a></li>
 249
 250 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/08/">August (13)</a></li>
 251
 252 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/09/">September (7)</a></li>
 253
 254 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/10/">October (9)</a></li>
 255
 256 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/11/">November (13)</a></li>
 257
 258 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/12/">December (12)</a></li>
 259
 260 </ul></li>
 261
 262 <li>2009
 263 <ul>
 264
 265 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/01/">January (8)</a></li>
 266
 267 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/02/">February (8)</a></li>
 268
 269 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/03/">March (12)</a></li>
 270
 271 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/04/">April (10)</a></li>
 272
 273 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/05/">May (9)</a></li>
 274
 275 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/06/">June (3)</a></li>
 276
 277 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/07/">July (4)</a></li>
 278
 279 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/08/">August (3)</a></li>
 280
 281 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/09/">September (1)</a></li>
 282
 283 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/10/">October (2)</a></li>
 284
 285 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/11/">November (3)</a></li>
 286
 287 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/12/">December (3)</a></li>
 288
 289 </ul></li>
 290
 291 <li>2008
 292 <ul>
 293
 294 <li><a href="http://people.skolelinux.org/pere/blog/archive/2008/11/">November (5)</a></li>
 295
 296 <li><a href="http://people.skolelinux.org/pere/blog/archive/2008/12/">December (7)</a></li>
 297
 298 </ul></li>
 299
 300 </ul>
 301
 302
 303
 304 <h2>Tags</h2>
 305 <ul>
 306
 307  <li><a href="http://people.skolelinux.org/pere/blog/tags/3d-printer">3d-printer (13)</a></li>
 308
 309  <li><a href="http://people.skolelinux.org/pere/blog/tags/amiga">amiga (1)</a></li>
 310
 311  <li><a href="http://people.skolelinux.org/pere/blog/tags/aros">aros (1)</a></li>
 312
 313  <li><a href="http://people.skolelinux.org/pere/blog/tags/bankid">bankid (4)</a></li>
 314
 315  <li><a href="http://people.skolelinux.org/pere/blog/tags/bitcoin">bitcoin (8)</a></li>
 316
 317  <li><a href="http://people.skolelinux.org/pere/blog/tags/bootsystem">bootsystem (15)</a></li>
 318
 319  <li><a href="http://people.skolelinux.org/pere/blog/tags/bsa">bsa (2)</a></li>
 320
 321  <li><a href="http://people.skolelinux.org/pere/blog/tags/chrpath">chrpath (2)</a></li>
 322
 323  <li><a href="http://people.skolelinux.org/pere/blog/tags/debian">debian (109)</a></li>
 324
 325  <li><a href="http://people.skolelinux.org/pere/blog/tags/debian edu">debian edu (153)</a></li>
 326
 327  <li><a href="http://people.skolelinux.org/pere/blog/tags/digistan">digistan (10)</a></li>
 328
 329  <li><a href="http://people.skolelinux.org/pere/blog/tags/dld">dld (15)</a></li>
 330
 331  <li><a href="http://people.skolelinux.org/pere/blog/tags/docbook">docbook (13)</a></li>
 332
 333  <li><a href="http://people.skolelinux.org/pere/blog/tags/drivstoffpriser">drivstoffpriser (4)</a></li>
 334
 335  <li><a href="http://people.skolelinux.org/pere/blog/tags/english">english (279)</a></li>
 336
 337  <li><a href="http://people.skolelinux.org/pere/blog/tags/fiksgatami">fiksgatami (23)</a></li>
 338
 339  <li><a href="http://people.skolelinux.org/pere/blog/tags/fildeling">fildeling (12)</a></li>
 340
 341  <li><a href="http://people.skolelinux.org/pere/blog/tags/freeculture">freeculture (15)</a></li>
 342
 343  <li><a href="http://people.skolelinux.org/pere/blog/tags/freedombox">freedombox (9)</a></li>
 344
 345  <li><a href="http://people.skolelinux.org/pere/blog/tags/frikanalen">frikanalen (15)</a></li>
 346
 347  <li><a href="http://people.skolelinux.org/pere/blog/tags/h264">h264 (19)</a></li>
 348
 349  <li><a href="http://people.skolelinux.org/pere/blog/tags/intervju">intervju (42)</a></li>
 350
 351  <li><a href="http://people.skolelinux.org/pere/blog/tags/isenkram">isenkram (10)</a></li>
 352
 353  <li><a href="http://people.skolelinux.org/pere/blog/tags/kart">kart (19)</a></li>
 354
 355  <li><a href="http://people.skolelinux.org/pere/blog/tags/ldap">ldap (9)</a></li>
 356
 357  <li><a href="http://people.skolelinux.org/pere/blog/tags/lenker">lenker (8)</a></li>
 358
 359  <li><a href="http://people.skolelinux.org/pere/blog/tags/lsdvd">lsdvd (2)</a></li>
 360
 361  <li><a href="http://people.skolelinux.org/pere/blog/tags/ltsp">ltsp (1)</a></li>
 362
 363  <li><a href="http://people.skolelinux.org/pere/blog/tags/mesh network">mesh network (8)</a></li>
 364
 365  <li><a href="http://people.skolelinux.org/pere/blog/tags/multimedia">multimedia (34)</a></li>
 366
 367  <li><a href="http://people.skolelinux.org/pere/blog/tags/norsk">norsk (262)</a></li>
 368
 369  <li><a href="http://people.skolelinux.org/pere/blog/tags/nuug">nuug (176)</a></li>
 370
 371  <li><a href="http://people.skolelinux.org/pere/blog/tags/offentlig innsyn">offentlig innsyn (17)</a></li>
 372
 373  <li><a href="http://people.skolelinux.org/pere/blog/tags/open311">open311 (2)</a></li>
 374
 375  <li><a href="http://people.skolelinux.org/pere/blog/tags/opphavsrett">opphavsrett (52)</a></li>
 376
 377  <li><a href="http://people.skolelinux.org/pere/blog/tags/personvern">personvern (86)</a></li>
 378
 379  <li><a href="http://people.skolelinux.org/pere/blog/tags/raid">raid (1)</a></li>
 380
 381  <li><a href="http://people.skolelinux.org/pere/blog/tags/reactos">reactos (1)</a></li>
 382
 383  <li><a href="http://people.skolelinux.org/pere/blog/tags/reprap">reprap (11)</a></li>
 384
 385  <li><a href="http://people.skolelinux.org/pere/blog/tags/rfid">rfid (3)</a></li>
 386
 387  <li><a href="http://people.skolelinux.org/pere/blog/tags/robot">robot (9)</a></li>
 388
 389  <li><a href="http://people.skolelinux.org/pere/blog/tags/rss">rss (1)</a></li>
 390
 391  <li><a href="http://people.skolelinux.org/pere/blog/tags/ruter">ruter (4)</a></li>
 392
 393  <li><a href="http://people.skolelinux.org/pere/blog/tags/scraperwiki">scraperwiki (2)</a></li>
 394
 395  <li><a href="http://people.skolelinux.org/pere/blog/tags/sikkerhet">sikkerhet (41)</a></li>
 396
 397  <li><a href="http://people.skolelinux.org/pere/blog/tags/sitesummary">sitesummary (4)</a></li>
 398
 399  <li><a href="http://people.skolelinux.org/pere/blog/tags/skepsis">skepsis (4)</a></li>
 400
 401  <li><a href="http://people.skolelinux.org/pere/blog/tags/standard">standard (47)</a></li>
 402
 403  <li><a href="http://people.skolelinux.org/pere/blog/tags/stavekontroll">stavekontroll (3)</a></li>
 404
 405  <li><a href="http://people.skolelinux.org/pere/blog/tags/stortinget">stortinget (9)</a></li>
 406
 407  <li><a href="http://people.skolelinux.org/pere/blog/tags/surveillance">surveillance (33)</a></li>
 408
 409  <li><a href="http://people.skolelinux.org/pere/blog/tags/sysadmin">sysadmin (2)</a></li>
 410
 411  <li><a href="http://people.skolelinux.org/pere/blog/tags/usenix">usenix (2)</a></li>
 412
 413  <li><a href="http://people.skolelinux.org/pere/blog/tags/valg">valg (8)</a></li>
 414
 415  <li><a href="http://people.skolelinux.org/pere/blog/tags/video">video (52)</a></li>
 416
 417  <li><a href="http://people.skolelinux.org/pere/blog/tags/vitenskap">vitenskap (4)</a></li>
 418
 419  <li><a href="http://people.skolelinux.org/pere/blog/tags/web">web (36)</a></li>
 420
 421 </ul>
 422
 423
 424     </div>
 425     <p style="text-align: right">
 426  Created by <a href="http://steve.org.uk/Software/chronicle">Chronicle v4.6</a>
 427 </p>
 428
 429   </body>
 430 </html>