tenders-exposed / elvis-ember

**el.vis** - a tool for visualising public (EU) tenders big data
https://talk.tenders.exposed
GNU Affero General Public License v3.0
8 stars 2 forks source link

Display tender corrections #426

Open georgiana-b opened 6 years ago

georgiana-b commented 6 years ago

We now have the corrections made to tenders included in opentender.eu data. :tada:

This is great news because that info comes from erratas which were quite overlooked so far so there was room for using them in a shady way. In my first project on public procurement 4 yrs ago we found that sometimes buyers would declare a certain price in the tender and then use the errata to add orders of magnitude to the sum. Here is such an example:

{  
   "created":"2017-12-06T02:46:17.672",
   "modified":"2017-12-23T07:48:26.028",
   "titleEnglish":"Angiography supplies",
   "selectionMethod":"LOWEST_PRICE",
   "awardCriteria":[  
      {  
         "name":"PRICE",
         "weight":100,
         "isPriceRelated":true
      }
   ],
   "buyers":[  
      {  
         "name":"Spitalul Clinic de Urgenta „Prof. Dr. Nicolae Oblu” Iasi",
         "mainActivities":[  
            "HEALTH"
         ],
         "buyerType":"PUBLIC_BODY",
         "id":"EU_body_3a26cfe060c727acb2ebcd9af2729c94fce0ff21511882947b53af03d22987b3"
      }
   ],
   "publications":[  
      {  
         "source":"http://ted.europa.eu",
         "sourceId":"2016/S 182-327183",
         "humanReadableUrl":"http://ted.europa.eu/udl?uri=TED:NOTICE:327183-2016:TEXT:EN:HTML",
         "publicationDate":"2016-09-21",
         "language":"RO",
         "isIncluded":true,
         "formType":"CONTRACT_UPDATE",
         "sourceFormType":"F14_2011"
      }
   ],
   "corrections":[  
      {  
         "original":"II.2.1) Valoarea totală finală a contractului sau a contractelor: Valoare: 12 736 474,30 RON Fără TVA V.4) Informații privind valoarea contractului: Contract nr: 7921 Valoarea totală finală a contractului: Valoare: 85 487,50 RON Fără TVA",
         "replacement":"II.2.1) Valoarea totală finală a contractului sau a contractelor: Valoare: 15 042 374,30 RON Fără TVA V.4) Informații privind valoarea contractului: Contract nr: 7921 Valoarea totală finală a contractului: Valoare: 815 487,50 RON Fără TVA"
      }
   ],
   "country":"RO"
}

It says the value of one of the contracts is not 85 487,50 RON but 815 487,50 RON so 10 times more and then the final value of the tender is 15 042 374,30 instead of 12 736 474,30 RON.

I think corrections have great potential to offer journalists juicy discoveries and we should display them at least when they regard section V.4 - Value of contract. WDYT @zufanka?

nightsh commented 5 years ago

I still like this. Any way we could easily share them easily without cluttering the UI?

zufanka commented 5 years ago

Great idea, but no time to implement this, giving it a FUTURE label