[Os-datawrangling] Multiple entities

Anders Pedersen anders.pedersen at okfn.org
Wed Oct 30 15:22:14 UTC 2013


Hi Olaf,

Great. Looking much forward to see this data up on OpenSpending, and by
then make sure to let us know on the list!

Best,
Anders


On 30 October 2013 11:14, Olaf Veerman <olaf.veerman at flipside.org> wrote:

> 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
>
> _______________________________________________
> Os-datawrangling mailing list
> Os-datawrangling at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/os-datawrangling
>
>


-- 
*

Anders Pedersen

Community Coordinator  |  skype: anpehej  |  @anpe <https://twitter.com/>

The Open Knowledge Foundation <http://okfn.org/>

Empowering through Open Knowledge

http://okfn.org/  |  @okfn <http://twitter.com/OKFN>  |  OKF on
Facebook<https://www.facebook.com/OKFNetwork> |
Blog <http://blog.okfn.org/>  |  Newsletter<http://okfn.org/about/newsletter>

*

OpenSpending | http://openspending.org |
@openspending<http://twitter.com/openspending>

School of Data | http://schoolofdata.org |
@schoolofdata<http://twitter.com/schoolofdata>


*

**

*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/os-datawrangling/attachments/20131030/315e892b/attachment-0001.html>


More information about the os-datawrangling mailing list