blog/Litt_statistikk_fra_Offentlig_Elektronisk_postjournal.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: Litt statistikk fra Offentlig Elektronisk postjournal</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">Litt statistikk fra Offentlig Elektronisk postjournal</div>
  24       <div class="date">10th June 2012</div>
  25       <div class="body"><p>De siste månedene har jeg sammen med andre i NUUG jobbet med å
  26 gjøre det enklere å få innsyn i offentlige dokumenter, og dette
  27 inkluderer å gjøre postjournaler enklere tilgjengelig for maskinell
  28 analyse og søk.  I den forbindelse tok jeg i dag å tittet litt på
  29 <a href="http://www.oep.no/">Offentlig Elektronisk Postjournal
  30 (OEP)</a>, FAD/DIFIs fellesløsning for departementer og statlige
  31 etater.</p>
  32
  33 <p>Her er antall oppføringer pr. måned det siste året,
  34 <a href="https://api.scraperwiki.com/api/1.0/datastore/sqlite?format=htmltable&name=postliste-oep&query=select%20strftime(%22%25Y-%25m%22%2C%20%60recordpublishdate%60)%20as%20oeppubmonth%2C%20count(*)%20from%20%60swdata%60%20group%20by%20oeppubmonth%20order%20by%20oeppubmonth">summert
  35 opp</a> ved hjelp av
  36 <a href="https://scraperwiki.com/scrapers/postliste-oep/">en
  37 Scraperwiki-database</a>.  Merk at denne Scraperwikien har
  38 ytelsesproblemer pga. mengden data. </p>
  39
  40 <p><table border="1">
  41 <tr><th>Måned</th><th>Antall</th></tr>
  42 <tr><td>2011-07</td><td>164355</td></tr>
  43 <tr><td>2011-08</td><td>153662</td></tr>
  44 <tr><td>2011-09</td><td>173134</td></tr>
  45 <tr><td>2011-10</td><td>170665</td></tr>
  46 <tr><td>2011-11</td><td>198409</td></tr>
  47 <tr><td>2011-12</td><td>175908</td></tr>
  48 <tr><td>2012-01</td><td>206875</td></tr>
  49 <tr><td>2012-02</td><td>202862</td></tr>
  50 <tr><td>2012-03</td><td>204225</td></tr>
  51 <tr><td>2012-04</td><td>207931</td></tr>
  52 <tr><td>2012-05</td><td>223754</td></tr>
  53 </table></p>
  54
  55 <p>Det er også interessant å se hvor ofte ulike etater sender inn sine
  56 journaloppføringer til OEP.  OEP inneholder en liste med sist
  57 innrapporteringsdato for alle som sender til OEP, og ved å se når og
  58 hvor ofte det blir sendt inn fra etatene kan
  59 <a href="https://api.scraperwiki.com/api/1.0/datastore/sqlite?format=htmltable&name=postliste-oep-deliverydates&query=select%20agency%2C%0A(julianday(datetime('now'))%20-%20%0A%20julianday(min(%60deliverydate%60)))%2Fcount(*)%20as%20dayfreq%2C%0A%20count(*)%0Afrom%20%60swdata%60%20group%20by%20agency%20order%20by%20dayfreq%20desc">frekvensen
  60 beregnes</a>.  Her er bunnlista, dvs. de som leverer sjeldnere enn hver 10.
  61 dag beregnet fra
  62 <a href="https://scraperwiki.com/scrapers/postliste-oep-deliverydates/">en
  63 Scraperwiki-database</a>:</p>
  64
  65 <p><table border="1">
  66
  67 <tr> <th>Etat</th> <th>Frekvens</th> <th>Leveringer</th> </tr>
  68 <tr> <td>Norges geologiske undersøkelse</td> <td>83.7527546296</td> <td>1</td> </tr>
  69 <tr> <td>Medietilsynet</td> <td>33.7527546296</td> <td>1</td> </tr>
  70 <tr> <td>Departementenes servicesenter</td> <td>23.8763773148</td> <td>2</td> </tr>
  71 <tr> <td>Kunnskapsdepartementet</td> <td>15.8763773148</td> <td>2</td> </tr>
  72 <tr> <td>Kompetansesenter for distriktsutvikling</td> <td>15.3763773148</td> <td>2</td> </tr>
  73 <tr> <td>Toll- og avgiftsdirektoratet</td> <td>15.3763773148</td> <td>2</td> </tr>
  74 <tr> <td>Fredskorpset</td> <td>12.5842515432</td> <td>3</td> </tr>
  75 <tr> <td>Statens legemiddelverk</td> <td>12.1881886574</td> <td>4</td> </tr>
  76 <tr> <td>Utlendingsnemnda</td> <td>11.5842515432</td> <td>3</td> </tr>
  77 <tr> <td>Politidirektoratet</td> <td>10.9175848765</td> <td>3</td> </tr>
  78 <tr> <td>Skattedirektoratet</td> <td>10.9175848765</td> <td>3</td> </tr>
  79 <tr> <td>Statens innkrevingssentral</td> <td>10.5842515432</td> <td>3</td> </tr>
  80 <tr> <td>Barne-, ungdoms- og familiedirektoratet</td> <td>10.2509182099</td> <td>3</td> </tr>
  81 <tr> <td>Kunst i offentlige rom</td> <td>10.2509182099</td> <td>3</td> </tr>
  82
  83 </table></p>
  84
  85 <p>En kan beregne lignende frekvenser ved å sammenligne
  86 journalføringsdato med publiseringsdato for hver enkelt oppføring i
  87 OEP, men den lenken legger jeg ikke ved her for å unngå at
  88 søkemotorroboter begynner å overbelaste Scraperwiki-databasen.</p>
  89
  90 <p>Jeg har spurt Norges geologiske undersøkelse om hvorfor de leverer
  91 så sjelden, og det kommer av at de har problemer etter oppgradering av
  92 arkivsystemet sitt og jobber med å fikse det slik at de kan gå tilbake
  93 til å levere hver uke.  Har ikke undersøkt noen av de andre.</p>
  94 </div>
  95
  96       <div class="tags">Tags: <a href="http://people.skolelinux.org/pere/blog/tags/norsk">norsk</a>, <a href="http://people.skolelinux.org/pere/blog/tags/nuug">nuug</a>, <a href="http://people.skolelinux.org/pere/blog/tags/offentlig innsyn">offentlig innsyn</a>.</div>
  97
  98
  99     </div>
 100
 101
 102
 103
 104     <div id="sidebar">
 105
 106
 107
 108 <h2>Archive</h2>
 109 <ul>
 110
 111 <li>2014
 112 <ul>
 113
 114 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/01/">January (2)</a></li>
 115
 116 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/02/">February (3)</a></li>
 117
 118 <li><a href="http://people.skolelinux.org/pere/blog/archive/2014/03/">March (4)</a></li>
 119
 120 </ul></li>
 121
 122 <li>2013
 123 <ul>
 124
 125 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/01/">January (11)</a></li>
 126
 127 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/02/">February (9)</a></li>
 128
 129 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/03/">March (9)</a></li>
 130
 131 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/04/">April (6)</a></li>
 132
 133 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/05/">May (9)</a></li>
 134
 135 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/06/">June (10)</a></li>
 136
 137 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/07/">July (7)</a></li>
 138
 139 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/08/">August (3)</a></li>
 140
 141 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/09/">September (5)</a></li>
 142
 143 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/10/">October (7)</a></li>
 144
 145 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/11/">November (9)</a></li>
 146
 147 <li><a href="http://people.skolelinux.org/pere/blog/archive/2013/12/">December (3)</a></li>
 148
 149 </ul></li>
 150
 151 <li>2012
 152 <ul>
 153
 154 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/01/">January (7)</a></li>
 155
 156 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/02/">February (10)</a></li>
 157
 158 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/03/">March (17)</a></li>
 159
 160 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/04/">April (12)</a></li>
 161
 162 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/05/">May (12)</a></li>
 163
 164 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/06/">June (20)</a></li>
 165
 166 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/07/">July (17)</a></li>
 167
 168 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/08/">August (6)</a></li>
 169
 170 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/09/">September (9)</a></li>
 171
 172 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/10/">October (17)</a></li>
 173
 174 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/11/">November (10)</a></li>
 175
 176 <li><a href="http://people.skolelinux.org/pere/blog/archive/2012/12/">December (7)</a></li>
 177
 178 </ul></li>
 179
 180 <li>2011
 181 <ul>
 182
 183 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/01/">January (16)</a></li>
 184
 185 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/02/">February (6)</a></li>
 186
 187 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/03/">March (6)</a></li>
 188
 189 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/04/">April (7)</a></li>
 190
 191 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/05/">May (3)</a></li>
 192
 193 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/06/">June (2)</a></li>
 194
 195 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/07/">July (7)</a></li>
 196
 197 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/08/">August (6)</a></li>
 198
 199 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/09/">September (4)</a></li>
 200
 201 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/10/">October (2)</a></li>
 202
 203 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/11/">November (3)</a></li>
 204
 205 <li><a href="http://people.skolelinux.org/pere/blog/archive/2011/12/">December (1)</a></li>
 206
 207 </ul></li>
 208
 209 <li>2010
 210 <ul>
 211
 212 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/01/">January (2)</a></li>
 213
 214 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/02/">February (1)</a></li>
 215
 216 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/03/">March (3)</a></li>
 217
 218 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/04/">April (3)</a></li>
 219
 220 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/05/">May (9)</a></li>
 221
 222 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/06/">June (14)</a></li>
 223
 224 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/07/">July (12)</a></li>
 225
 226 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/08/">August (13)</a></li>
 227
 228 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/09/">September (7)</a></li>
 229
 230 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/10/">October (9)</a></li>
 231
 232 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/11/">November (13)</a></li>
 233
 234 <li><a href="http://people.skolelinux.org/pere/blog/archive/2010/12/">December (12)</a></li>
 235
 236 </ul></li>
 237
 238 <li>2009
 239 <ul>
 240
 241 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/01/">January (8)</a></li>
 242
 243 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/02/">February (8)</a></li>
 244
 245 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/03/">March (12)</a></li>
 246
 247 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/04/">April (10)</a></li>
 248
 249 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/05/">May (9)</a></li>
 250
 251 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/06/">June (3)</a></li>
 252
 253 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/07/">July (4)</a></li>
 254
 255 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/08/">August (3)</a></li>
 256
 257 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/09/">September (1)</a></li>
 258
 259 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/10/">October (2)</a></li>
 260
 261 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/11/">November (3)</a></li>
 262
 263 <li><a href="http://people.skolelinux.org/pere/blog/archive/2009/12/">December (3)</a></li>
 264
 265 </ul></li>
 266
 267 <li>2008
 268 <ul>
 269
 270 <li><a href="http://people.skolelinux.org/pere/blog/archive/2008/11/">November (5)</a></li>
 271
 272 <li><a href="http://people.skolelinux.org/pere/blog/archive/2008/12/">December (7)</a></li>
 273
 274 </ul></li>
 275
 276 </ul>
 277
 278
 279
 280 <h2>Tags</h2>
 281 <ul>
 282
 283  <li><a href="http://people.skolelinux.org/pere/blog/tags/3d-printer">3d-printer (13)</a></li>
 284
 285  <li><a href="http://people.skolelinux.org/pere/blog/tags/amiga">amiga (1)</a></li>
 286
 287  <li><a href="http://people.skolelinux.org/pere/blog/tags/aros">aros (1)</a></li>
 288
 289  <li><a href="http://people.skolelinux.org/pere/blog/tags/bankid">bankid (4)</a></li>
 290
 291  <li><a href="http://people.skolelinux.org/pere/blog/tags/bitcoin">bitcoin (8)</a></li>
 292
 293  <li><a href="http://people.skolelinux.org/pere/blog/tags/bootsystem">bootsystem (14)</a></li>
 294
 295  <li><a href="http://people.skolelinux.org/pere/blog/tags/bsa">bsa (2)</a></li>
 296
 297  <li><a href="http://people.skolelinux.org/pere/blog/tags/chrpath">chrpath (2)</a></li>
 298
 299  <li><a href="http://people.skolelinux.org/pere/blog/tags/debian">debian (95)</a></li>
 300
 301  <li><a href="http://people.skolelinux.org/pere/blog/tags/debian edu">debian edu (145)</a></li>
 302
 303  <li><a href="http://people.skolelinux.org/pere/blog/tags/digistan">digistan (10)</a></li>
 304
 305  <li><a href="http://people.skolelinux.org/pere/blog/tags/docbook">docbook (10)</a></li>
 306
 307  <li><a href="http://people.skolelinux.org/pere/blog/tags/drivstoffpriser">drivstoffpriser (4)</a></li>
 308
 309  <li><a href="http://people.skolelinux.org/pere/blog/tags/english">english (238)</a></li>
 310
 311  <li><a href="http://people.skolelinux.org/pere/blog/tags/fiksgatami">fiksgatami (21)</a></li>
 312
 313  <li><a href="http://people.skolelinux.org/pere/blog/tags/fildeling">fildeling (12)</a></li>
 314
 315  <li><a href="http://people.skolelinux.org/pere/blog/tags/freeculture">freeculture (12)</a></li>
 316
 317  <li><a href="http://people.skolelinux.org/pere/blog/tags/freedombox">freedombox (6)</a></li>
 318
 319  <li><a href="http://people.skolelinux.org/pere/blog/tags/frikanalen">frikanalen (11)</a></li>
 320
 321  <li><a href="http://people.skolelinux.org/pere/blog/tags/intervju">intervju (39)</a></li>
 322
 323  <li><a href="http://people.skolelinux.org/pere/blog/tags/isenkram">isenkram (7)</a></li>
 324
 325  <li><a href="http://people.skolelinux.org/pere/blog/tags/kart">kart (18)</a></li>
 326
 327  <li><a href="http://people.skolelinux.org/pere/blog/tags/ldap">ldap (9)</a></li>
 328
 329  <li><a href="http://people.skolelinux.org/pere/blog/tags/lenker">lenker (7)</a></li>
 330
 331  <li><a href="http://people.skolelinux.org/pere/blog/tags/ltsp">ltsp (1)</a></li>
 332
 333  <li><a href="http://people.skolelinux.org/pere/blog/tags/mesh network">mesh network (7)</a></li>
 334
 335  <li><a href="http://people.skolelinux.org/pere/blog/tags/multimedia">multimedia (25)</a></li>
 336
 337  <li><a href="http://people.skolelinux.org/pere/blog/tags/norsk">norsk (242)</a></li>
 338
 339  <li><a href="http://people.skolelinux.org/pere/blog/tags/nuug">nuug (162)</a></li>
 340
 341  <li><a href="http://people.skolelinux.org/pere/blog/tags/offentlig innsyn">offentlig innsyn (11)</a></li>
 342
 343  <li><a href="http://people.skolelinux.org/pere/blog/tags/open311">open311 (2)</a></li>
 344
 345  <li><a href="http://people.skolelinux.org/pere/blog/tags/opphavsrett">opphavsrett (45)</a></li>
 346
 347  <li><a href="http://people.skolelinux.org/pere/blog/tags/personvern">personvern (69)</a></li>
 348
 349  <li><a href="http://people.skolelinux.org/pere/blog/tags/raid">raid (1)</a></li>
 350
 351  <li><a href="http://people.skolelinux.org/pere/blog/tags/reprap">reprap (11)</a></li>
 352
 353  <li><a href="http://people.skolelinux.org/pere/blog/tags/rfid">rfid (2)</a></li>
 354
 355  <li><a href="http://people.skolelinux.org/pere/blog/tags/robot">robot (9)</a></li>
 356
 357  <li><a href="http://people.skolelinux.org/pere/blog/tags/rss">rss (1)</a></li>
 358
 359  <li><a href="http://people.skolelinux.org/pere/blog/tags/ruter">ruter (4)</a></li>
 360
 361  <li><a href="http://people.skolelinux.org/pere/blog/tags/scraperwiki">scraperwiki (2)</a></li>
 362
 363  <li><a href="http://people.skolelinux.org/pere/blog/tags/sikkerhet">sikkerhet (35)</a></li>
 364
 365  <li><a href="http://people.skolelinux.org/pere/blog/tags/sitesummary">sitesummary (4)</a></li>
 366
 367  <li><a href="http://people.skolelinux.org/pere/blog/tags/skepsis">skepsis (4)</a></li>
 368
 369  <li><a href="http://people.skolelinux.org/pere/blog/tags/standard">standard (44)</a></li>
 370
 371  <li><a href="http://people.skolelinux.org/pere/blog/tags/stavekontroll">stavekontroll (3)</a></li>
 372
 373  <li><a href="http://people.skolelinux.org/pere/blog/tags/stortinget">stortinget (9)</a></li>
 374
 375  <li><a href="http://people.skolelinux.org/pere/blog/tags/surveillance">surveillance (22)</a></li>
 376
 377  <li><a href="http://people.skolelinux.org/pere/blog/tags/sysadmin">sysadmin (1)</a></li>
 378
 379  <li><a href="http://people.skolelinux.org/pere/blog/tags/valg">valg (8)</a></li>
 380
 381  <li><a href="http://people.skolelinux.org/pere/blog/tags/video">video (39)</a></li>
 382
 383  <li><a href="http://people.skolelinux.org/pere/blog/tags/vitenskap">vitenskap (4)</a></li>
 384
 385  <li><a href="http://people.skolelinux.org/pere/blog/tags/web">web (29)</a></li>
 386
 387 </ul>
 388
 389
 390     </div>
 391     <p style="text-align: right">
 392  Created by <a href="http://steve.org.uk/Software/chronicle">Chronicle v4.6</a>
 393 </p>
 394
 395   </body>
 396 </html>