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