[Os-datawrangling] Multiple entities

Wed Oct 30 15:14:53 UTC 2013

Hi Friedrich,
Thanks for your feedback.
Without the fourth option (OpenSpending support for multiple entities), I
guess it will always be a trade-off between having a good reflection of the
amounts and reflecting the relationships between entities well.

We'll follow your suggestion and go for the second option, which is the one
where we meddle the least with the data. Especially since there are cases
in which we have multiple suppliers with multiple contractors.
best,
Olaf

On Tue, Oct 29, 2013 at 12:30 PM, Friedrich Lindenberg
<friedrich at pudo.org>wrote:

> 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
>>
>>
>

-- 
Flipside
www.flipside.org | +351 926 5264 65
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/os-datawrangling/attachments/20131030/cb65092c/attachment-0001.html>