[Os-datawrangling] Multiple entities

Tue Oct 29 12:30:07 UTC 2013

That's a tough one, we have the same issue in EU Commission expenditure,
for example. I guess you have three options:

1) Split up the contract into parts and pro rata the price. Depending on
what you want to do with this, the result may be OK, but of course the
amounts themselves become fictional.

2) Make a consortium supplier, i.e. just put all their names together
separated by commas. You can JSON-encode their individual names into a
secondary dimension if you want to use this in a UI somewhere.

3) Make noise with the government to get detailed breakdowns :)

Option four would be to support multiple values in the core software, but
that seems like modelling a weird type of ambiguity with little gain in
understanding.

I'd go for 2 + 3.

- Friedrich

On Mon, Oct 28, 2013 at 2:06 PM, Olaf Veerman <olaf.veerman at flipside.org>wrote:

> Hi all,
> We're preparing a CSV to upload non-bid contracts from Portugal. In a
> couple of cases, there are multiple recipients / contractors for a
> particular contract, without further mention on how the amounts are
> distributed.
> Has anybody dealt with this situation already?
> best,
> Olaf
>
> --
> Flipside
> www.flipside.org | +351 926 5264 65
>
> _______________________________________________
> Os-datawrangling mailing list
> Os-datawrangling at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/os-datawrangling
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/os-datawrangling/attachments/20131029/1d2407a7/attachment-0001.html>