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 ownership 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>".  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
  84 <p>Update 2015-06-15: Since the initial post I've been told that
  85 "<a href="http://www.proff.dk/firma/carl-allers-etablissement-aktieselskab/københavn-v/hovedkontorer/13624518-3/">Aller
  86 Holding A/S</a>" is a Danish company, which explain why it did not
  87 have a Norwegian organisation number.  I've also been told that there
  88 is a <a href="http://www.brreg.no/automatiske/webservices/">web
  89 services API available</a> from Brønnøysundsregistrene, for those
  90 willing to accept the terms or pay the price.</p>
  91 </div>
  92
  93       <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>
  94
  95
  96     </div>
  97
  98
  99
 100
 101     <div id="sidebar">
 102
 103
 104
 105 <h2>Archive</h2>
 106 <ul>
 107
 108 <li>2016
 109 <ul>
 110
 111 <li><a href="http://people.skolelinux.org/pere/blog/archive/2016/01/">January (3)</a></li>
 112
 113 <li><a href="http://people.skolelinux.org/pere/blog/archive/2016/02/">February (2)</a></li>
 114
 115 <li><a href="http://people.skolelinux.org/pere/blog/archive/2016/03/">March (3)</a></li>
 116
 117 <li><a href="http://people.skolelinux.org/pere/blog/archive/2016/04/">April (8)</a></li>
 118
 119 <li><a href="http://people.skolelinux.org/pere/blog/archive/2016/05/">May (8)</a></li>
 120
 121 <li><a href="http://people.skolelinux.org/pere/blog/archive/2016/06/">June (2)</a></li>
 122
 123 <li><a href="http://people.skolelinux.org/pere/blog/archive/2016/07/">July (2)</a></li>
 124
 125 <li><a href="http://people.skolelinux.org/pere/blog/archive/2016/08/">August (5)</a></li>
 126
 127 <li><a href="http://people.skolelinux.org/pere/blog/archive/2016/09/">September (2)</a></li>
 128
 129 <li><a href="http://people.skolelinux.org/pere/blog/archive/2016/10/">October (3)</a></li>
 130
 131 <li><a href="http://people.skolelinux.org/pere/blog/archive/2016/11/">November (1)</a></li>
 132
 133 </ul></li>
 134
 135 <li>2015
 136 <ul>
 137
 138 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/01/">January (7)</a></li>
 139
 140 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/02/">February (6)</a></li>
 141
 142 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/03/">March (1)</a></li>
 143
 144 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/04/">April (4)</a></li>
 145
 146 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/05/">May (3)</a></li>
 147
 148 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/06/">June (4)</a></li>
 149
 150 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/07/">July (6)</a></li>
 151
 152 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/08/">August (2)</a></li>
 153
 154 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/09/">September (2)</a></li>
 155
 156 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/10/">October (9)</a></li>
 157
 158 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/11/">November (6)</a></li>
 159
 160 <li><a href="http://people.skolelinux.org/pere/blog/archive/2015/12/">December (3)</a></li>
 161
 162 </ul></li>
 163
 164 <li>2014
 165 <ul>
 166
 167 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/01/">January (2)</a></li>
 168
 169 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/02/">February (3)</a></li>
 170
 171 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/03/">March (8)</a></li>
 172
 173 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/04/">April (7)</a></li>
 174
 175 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/05/">May (1)</a></li>
 176
 177 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/06/">June (2)</a></li>
 178
 179 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/07/">July (2)</a></li>
 180
 181 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/08/">August (2)</a></li>
 182
 183 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/09/">September (5)</a></li>
 184
 185 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/10/">October (6)</a></li>
 186
 187 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/11/">November (3)</a></li>
 188
 189 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/12/">December (5)</a></li>
 190
 191 </ul></li>
 192
 193 <li>2013
 194 <ul>
 195
 196 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/01/">January (11)</a></li>
 197
 198 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/02/">February (9)</a></li>
 199
 200 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/03/">March (9)</a></li>
 201
 202 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/04/">April (6)</a></li>
 203
 204 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/05/">May (9)</a></li>
 205
 206 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/06/">June (10)</a></li>
 207
 208 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/07/">July (7)</a></li>
 209
 210 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/08/">August (3)</a></li>
 211
 212 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/09/">September (5)</a></li>
 213
 214 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/10/">October (7)</a></li>
 215
 216 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/11/">November (9)</a></li>
 217
 218 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/12/">December (3)</a></li>
 219
 220 </ul></li>
 221
 222 <li>2012
 223 <ul>
 224
 225 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/01/">January (7)</a></li>
 226
 227 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/02/">February (10)</a></li>
 228
 229 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/03/">March (17)</a></li>
 230
 231 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/04/">April (12)</a></li>
 232
 233 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/05/">May (12)</a></li>
 234
 235 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/06/">June (20)</a></li>
 236
 237 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/07/">July (17)</a></li>
 238
 239 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/08/">August (6)</a></li>
 240
 241 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/09/">September (9)</a></li>
 242
 243 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/10/">October (17)</a></li>
 244
 245 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/11/">November (10)</a></li>
 246
 247 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/12/">December (7)</a></li>
 248
 249 </ul></li>
 250
 251 <li>2011
 252 <ul>
 253
 254 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/01/">January (16)</a></li>
 255
 256 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/02/">February (6)</a></li>
 257
 258 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/03/">March (6)</a></li>
 259
 260 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/04/">April (7)</a></li>
 261
 262 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/05/">May (3)</a></li>
 263
 264 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/06/">June (2)</a></li>
 265
 266 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/07/">July (7)</a></li>
 267
 268 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/08/">August (6)</a></li>
 269
 270 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/09/">September (4)</a></li>
 271
 272 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/10/">October (2)</a></li>
 273
 274 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/11/">November (3)</a></li>
 275
 276 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/12/">December (1)</a></li>
 277
 278 </ul></li>
 279
 280 <li>2010
 281 <ul>
 282
 283 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/01/">January (2)</a></li>
 284
 285 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/02/">February (1)</a></li>
 286
 287 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/03/">March (3)</a></li>
 288
 289 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/04/">April (3)</a></li>
 290
 291 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/05/">May (9)</a></li>
 292
 293 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/06/">June (14)</a></li>
 294
 295 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/07/">July (12)</a></li>
 296
 297 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/08/">August (13)</a></li>
 298
 299 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/09/">September (7)</a></li>
 300
 301 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/10/">October (9)</a></li>
 302
 303 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/11/">November (13)</a></li>
 304
 305 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/12/">December (12)</a></li>
 306
 307 </ul></li>
 308
 309 <li>2009
 310 <ul>
 311
 312 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/01/">January (8)</a></li>
 313
 314 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/02/">February (8)</a></li>
 315
 316 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/03/">March (12)</a></li>
 317
 318 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/04/">April (10)</a></li>
 319
 320 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/05/">May (9)</a></li>
 321
 322 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/06/">June (3)</a></li>
 323
 324 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/07/">July (4)</a></li>
 325
 326 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/08/">August (3)</a></li>
 327
 328 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/09/">September (1)</a></li>
 329
 330 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/10/">October (2)</a></li>
 331
 332 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/11/">November (3)</a></li>
 333
 334 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/12/">December (3)</a></li>
 335
 336 </ul></li>
 337
 338 <li>2008
 339 <ul>
 340
 341 <li><a href="http://people.skolelinux.org/pere/blog/archive/2008/11/">November (5)</a></li>
 342
 343 <li><a href="http://people.skolelinux.org/pere/blog/archive/2008/12/">December (7)</a></li>
 344
 345 </ul></li>
 346
 347 </ul>
 348
 349
 350
 351 <h2>Tags</h2>
 352 <ul>
 353
 354  <li><a href="http://people.skolelinux.org/pere/blog/tags/3d-printer">3d-printer (13)</a></li>
 355
 356  <li><a href="http://people.skolelinux.org/pere/blog/tags/amiga">amiga (1)</a></li>
 357
 358  <li><a href="http://people.skolelinux.org/pere/blog/tags/aros">aros (1)</a></li>
 359
 360  <li><a href="http://people.skolelinux.org/pere/blog/tags/bankid">bankid (4)</a></li>
 361
 362  <li><a href="http://people.skolelinux.org/pere/blog/tags/bitcoin">bitcoin (9)</a></li>
 363
 364  <li><a href="http://people.skolelinux.org/pere/blog/tags/bootsystem">bootsystem (16)</a></li>
 365
 366  <li><a href="http://people.skolelinux.org/pere/blog/tags/bsa">bsa (2)</a></li>
 367
 368  <li><a href="http://people.skolelinux.org/pere/blog/tags/chrpath">chrpath (2)</a></li>
 369
 370  <li><a href="http://people.skolelinux.org/pere/blog/tags/debian">debian (137)</a></li>
 371
 372  <li><a href="http://people.skolelinux.org/pere/blog/tags/debian edu">debian edu (157)</a></li>
 373
 374  <li><a href="http://people.skolelinux.org/pere/blog/tags/digistan">digistan (10)</a></li>
 375
 376  <li><a href="http://people.skolelinux.org/pere/blog/tags/dld">dld (16)</a></li>
 377
 378  <li><a href="http://people.skolelinux.org/pere/blog/tags/docbook">docbook (23)</a></li>
 379
 380  <li><a href="http://people.skolelinux.org/pere/blog/tags/drivstoffpriser">drivstoffpriser (4)</a></li>
 381
 382  <li><a href="http://people.skolelinux.org/pere/blog/tags/english">english (329)</a></li>
 383
 384  <li><a href="http://people.skolelinux.org/pere/blog/tags/fiksgatami">fiksgatami (23)</a></li>
 385
 386  <li><a href="http://people.skolelinux.org/pere/blog/tags/fildeling">fildeling (12)</a></li>
 387
 388  <li><a href="http://people.skolelinux.org/pere/blog/tags/freeculture">freeculture (28)</a></li>
 389
 390  <li><a href="http://people.skolelinux.org/pere/blog/tags/freedombox">freedombox (9)</a></li>
 391
 392  <li><a href="http://people.skolelinux.org/pere/blog/tags/frikanalen">frikanalen (18)</a></li>
 393
 394  <li><a href="http://people.skolelinux.org/pere/blog/tags/h264">h264 (20)</a></li>
 395
 396  <li><a href="http://people.skolelinux.org/pere/blog/tags/intervju">intervju (42)</a></li>
 397
 398  <li><a href="http://people.skolelinux.org/pere/blog/tags/isenkram">isenkram (13)</a></li>
 399
 400  <li><a href="http://people.skolelinux.org/pere/blog/tags/kart">kart (19)</a></li>
 401
 402  <li><a href="http://people.skolelinux.org/pere/blog/tags/ldap">ldap (9)</a></li>
 403
 404  <li><a href="http://people.skolelinux.org/pere/blog/tags/lenker">lenker (8)</a></li>
 405
 406  <li><a href="http://people.skolelinux.org/pere/blog/tags/lsdvd">lsdvd (2)</a></li>
 407
 408  <li><a href="http://people.skolelinux.org/pere/blog/tags/ltsp">ltsp (1)</a></li>
 409
 410  <li><a href="http://people.skolelinux.org/pere/blog/tags/mesh network">mesh network (8)</a></li>
 411
 412  <li><a href="http://people.skolelinux.org/pere/blog/tags/multimedia">multimedia (39)</a></li>
 413
 414  <li><a href="http://people.skolelinux.org/pere/blog/tags/nice free software">nice free software (8)</a></li>
 415
 416  <li><a href="http://people.skolelinux.org/pere/blog/tags/norsk">norsk (280)</a></li>
 417
 418  <li><a href="http://people.skolelinux.org/pere/blog/tags/nuug">nuug (182)</a></li>
 419
 420  <li><a href="http://people.skolelinux.org/pere/blog/tags/offentlig innsyn">offentlig innsyn (26)</a></li>
 421
 422  <li><a href="http://people.skolelinux.org/pere/blog/tags/open311">open311 (2)</a></li>
 423
 424  <li><a href="http://people.skolelinux.org/pere/blog/tags/opphavsrett">opphavsrett (61)</a></li>
 425
 426  <li><a href="http://people.skolelinux.org/pere/blog/tags/personvern">personvern (94)</a></li>
 427
 428  <li><a href="http://people.skolelinux.org/pere/blog/tags/raid">raid (1)</a></li>
 429
 430  <li><a href="http://people.skolelinux.org/pere/blog/tags/reactos">reactos (1)</a></li>
 431
 432  <li><a href="http://people.skolelinux.org/pere/blog/tags/reprap">reprap (11)</a></li>
 433
 434  <li><a href="http://people.skolelinux.org/pere/blog/tags/rfid">rfid (3)</a></li>
 435
 436  <li><a href="http://people.skolelinux.org/pere/blog/tags/robot">robot (9)</a></li>
 437
 438  <li><a href="http://people.skolelinux.org/pere/blog/tags/rss">rss (1)</a></li>
 439
 440  <li><a href="http://people.skolelinux.org/pere/blog/tags/ruter">ruter (4)</a></li>
 441
 442  <li><a href="http://people.skolelinux.org/pere/blog/tags/scraperwiki">scraperwiki (2)</a></li>
 443
 444  <li><a href="http://people.skolelinux.org/pere/blog/tags/sikkerhet">sikkerhet (51)</a></li>
 445
 446  <li><a href="http://people.skolelinux.org/pere/blog/tags/sitesummary">sitesummary (4)</a></li>
 447
 448  <li><a href="http://people.skolelinux.org/pere/blog/tags/skepsis">skepsis (5)</a></li>
 449
 450  <li><a href="http://people.skolelinux.org/pere/blog/tags/standard">standard (49)</a></li>
 451
 452  <li><a href="http://people.skolelinux.org/pere/blog/tags/stavekontroll">stavekontroll (4)</a></li>
 453
 454  <li><a href="http://people.skolelinux.org/pere/blog/tags/stortinget">stortinget (10)</a></li>
 455
 456  <li><a href="http://people.skolelinux.org/pere/blog/tags/surveillance">surveillance (42)</a></li>
 457
 458  <li><a href="http://people.skolelinux.org/pere/blog/tags/sysadmin">sysadmin (2)</a></li>
 459
 460  <li><a href="http://people.skolelinux.org/pere/blog/tags/usenix">usenix (2)</a></li>
 461
 462  <li><a href="http://people.skolelinux.org/pere/blog/tags/valg">valg (8)</a></li>
 463
 464  <li><a href="http://people.skolelinux.org/pere/blog/tags/video">video (59)</a></li>
 465
 466  <li><a href="http://people.skolelinux.org/pere/blog/tags/vitenskap">vitenskap (4)</a></li>
 467
 468  <li><a href="http://people.skolelinux.org/pere/blog/tags/web">web (38)</a></li>
 469
 470 </ul>
 471
 472
 473     </div>
 474     <p style="text-align: right">
 475  Created by <a href="http://steve.org.uk/Software/chronicle">Chronicle v4.6</a>
 476 </p>
 477
 478   </body>
 479 </html>