blog/data/2013-02-11-doffin-stats.txt

   1 Title: Litt statistikk over offentlige anbud annonsert via Doffin siden 2008
   2 Tags: norsk, nuug, offentlig innsyn
   3 Date: 2013-02-11 14:40
   4
   5 <p>For et halvt år siden
   6 <a href="http://www.hungry.com/~pere/blog/SQL_database_med_anbud_publisert_p__Doffin.html">satte
   7 jeg opp et system for å lage en database</a> med informasjon om
   8 offentlige anbud fra <a href="http://www.doffin.no/">Doffin</a> ved
   9 <a href="https://scraperwiki.com/scrapers/norwegian-doffin/">hjelp av
  10 Scraperwiki</a>.  Nå er databasen så vidt jeg kan se komplett, med
  11 data helt tilbake til 2008.  Her er litt statistikk over
  12 <a href="https://api.scraperwiki.com/api/1.0/datastore/sqlite?format=htmltable&name=norwegian-doffin&query=select%20strftime(%22%25Y-%25m%22%2C%20publishdate)%20as%20publishmonth%2C%20count(*)%20from%20%60swdata%60%20group%20by%20publishmonth%20order%20by%20publishmonth%20desc">antall
  13 anbud publisert hver måned</a>:</p>
  14
  15 <p><table border="1">
  16 <tr> <th>Publiseringsmåned</th> <th>Antall</th> </tr>
  17 <tr> <td>2013-01</td> <td>1015</td> </tr>
  18 <tr> <td>2012-12</td> <td>756</td> </tr>
  19 <tr> <td>2012-11</td> <td>979</td> </tr>
  20 <tr> <td>2012-10</td> <td>1093</td> </tr>
  21 <tr> <td>2012-09</td> <td>1023</td> </tr>
  22 <tr> <td>2012-08</td> <td>951</td> </tr>
  23 <tr> <td>2012-07</td> <td>1103</td> </tr>
  24 <tr> <td>2012-06</td> <td>1334</td> </tr>
  25 <tr> <td>2012-05</td> <td>1435</td> </tr>
  26 <tr> <td>2012-04</td> <td>1169</td> </tr>
  27 <tr> <td>2012-03</td> <td>1573</td> </tr>
  28 <tr> <td>2012-02</td> <td>1335</td> </tr>
  29 <tr> <td>2012-01</td> <td>1147</td> </tr>
  30 <tr> <td>2011-12</td> <td>1045</td> </tr>
  31 <tr> <td>2011-11</td> <td>1114</td> </tr>
  32 <tr> <td>2011-10</td> <td>1230</td> </tr>
  33 <tr> <td>2011-09</td> <td>1165</td> </tr>
  34 <tr> <td>2011-08</td> <td>966</td> </tr>
  35 <tr> <td>2011-07</td> <td>1148</td> </tr>
  36 <tr> <td>2011-06</td> <td>1410</td> </tr>
  37 <tr> <td>2011-05</td> <td>1536</td> </tr>
  38 <tr> <td>2011-04</td> <td>1350</td> </tr>
  39 <tr> <td>2011-03</td> <td>1574</td> </tr>
  40 <tr> <td>2011-02</td> <td>1370</td> </tr>
  41 <tr> <td>2011-01</td> <td>1049</td> </tr>
  42 <tr> <td>2010-12</td> <td>992</td> </tr>
  43 <tr> <td>2010-11</td> <td>1089</td> </tr>
  44 <tr> <td>2010-10</td> <td>1110</td> </tr>
  45 <tr> <td>2010-09</td> <td>1132</td> </tr>
  46 <tr> <td>2010-08</td> <td>883</td> </tr>
  47 <tr> <td>2010-07</td> <td>1126</td> </tr>
  48 <tr> <td>2010-06</td> <td>1440</td> </tr>
  49 <tr> <td>2010-05</td> <td>1236</td> </tr>
  50 <tr> <td>2010-04</td> <td>1249</td> </tr>
  51 <tr> <td>2010-03</td> <td>1556</td> </tr>
  52 <tr> <td>2010-02</td> <td>1256</td> </tr>
  53 <tr> <td>2010-01</td> <td>1140</td> </tr>
  54 <tr> <td>2009-12</td> <td>1013</td> </tr>
  55 <tr> <td>2009-11</td> <td>1220</td> </tr>
  56 <tr> <td>2009-10</td> <td>1320</td> </tr>
  57 <tr> <td>2009-09</td> <td>1294</td> </tr>
  58 <tr> <td>2009-08</td> <td>953</td> </tr>
  59 <tr> <td>2009-07</td> <td>1162</td> </tr>
  60 <tr> <td>2009-06</td> <td>1605</td> </tr>
  61 <tr> <td>2009-05</td> <td>1568</td> </tr>
  62 <tr> <td>2009-04</td> <td>1522</td> </tr>
  63 <tr> <td>2009-03</td> <td>1599</td> </tr>
  64 <tr> <td>2009-02</td> <td>1376</td> </tr>
  65 <tr> <td>2009-01</td> <td>1080</td> </tr>
  66 <tr> <td>2008-12</td> <td>1028</td> </tr>
  67 <tr> <td>2008-11</td> <td>949</td> </tr>
  68 <tr> <td>2008-10</td> <td>1047</td> </tr>
  69 <tr> <td>2008-09</td> <td>965</td> </tr>
  70 <tr> <td>2008-08</td> <td>725</td> </tr>
  71 <tr> <td>2008-07</td> <td>1015</td> </tr>
  72 <tr> <td>2008-06</td> <td>1304</td> </tr>
  73 <tr> <td>2008-05</td> <td>323</td> </tr>
  74 </table></p>
  75
  76 <p>Her er tilsvarende
  77 <a href="https://api.scraperwiki.com/api/1.0/datastore/sqlite?format=htmltable&name=norwegian-doffin&query=select%20strftime(%22%25Y%22%2C%20publishdate)%20as%20publishyear%2C%20count(*)%20from%20%60swdata%60%20group%20by%20publishyear%20order%20by%20publishyear%20desc">tall
  78 per år</a>, som viser en liten nedgang i antall anbud:</p>
  79
  80 <table border="1">
  81 <tr> <th>Publiseringsår</th> <th>Antall</th> </tr>
  82 <tr> <td>2012</td> <td>13898</td> </tr>
  83 <tr> <td>2011</td> <td>14957</td> </tr>
  84 <tr> <td>2010</td> <td>14209</td> </tr>
  85 <tr> <td>2009</td> <td>15712</td> </tr>
  86 <tr> <td>2008</td> <td>7356</td> </tr>
  87 </table></p>
  88
  89 <p>Jeg droppet den ufullstendige måneden og året fra tabellen.  Se
  90 lenken for oppdaterte tall.</p>