[Os-datawrangling] Multiple entities

[Anders Pedersen]

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>