[openspending-dev] Balance Sheets - advice please!

Mon Feb 13 12:42:32 UTC 2012

Hi JeanBrice,

We've taken a bit more look at your data and it's great - but we've
concluded that a little more data would be useful in order to produce a
useful visualisation.

In particular:

1. There seem to be a few encoding problems, these could be fixed by hand.
(We need UTF-8 for OpenSpending)

2. Some fields seem to be empty, perhaps there is a way to pad them with
appropriate values

3. It's really short - is there another level of detail we could
investigate?
Please let us know, we're keen to see this data beautified ;)

Lucy

On Fri, Jan 27, 2012 at 1:30 PM, Lucy Chambers <lucy.chambers at okfn.org>wrote:

> Hi Folk,
>
> Great - thanks for all of your input. Are we decided then - to reformat
> the data along the lines suggested by Mark.
>
> @Friedrich, didn't entirely understand:
>
> "We'll just have to remember to reverse `to` and `from` if they are to be
> set :)"
>
> - Is this something JeanBrice needs to worry about when formatting his
> data / is this only an issue when loading the data in?
>
> Lucy
>
> On Thu, Jan 26, 2012 at 3:53 PM, JeanBrice Anti-Corruption <
> jeanbrice at kick-corruption.org> wrote:
>
>> Hello all,
>>
>> Thank you for your quick responses. I would just add that it is
>> deliberately that the budget is made to be hard to understand, in the other
>> hand we have a lot of difficulties in obtaining more detailed information
>> on expenses. But we continue to seek this information.
>> We hope that the viewing of this budget will be an asset to improve the
>> budget in Cameroon.
>>
>> Thank you for your support again.
>>
>> JeanBrice.
>>
>> 2012/1/26 Friedrich Lindenberg <friedrich.lindenberg at okfn.org>
>>
>>> On Thu, Jan 26, 2012 at 1:32 PM, Mark Brough
>>> <mark.brough at publishwhatyoufund.org> wrote:
>>> > Looks to me like it's two tables of data side by side?
>>>
>>> That was my impression as well, but my french is disastrous.
>>>
>>> > The Revenue (left) side has titles for each of the sections (anything
>>> where
>>> > "Imputation" is blank). Imputation means budget line.
>>> >
>>> > The "Spending" (right) side looks like it is separated into capital and
>>> > recurrent spending on each row. You'd want to include the stuff lower
>>> down
>>> > on pensions, local government (presuming commune=local government)
>>> spending
>>> > and debt.
>>>
>>> This is nice for us, since we can aggregate both ways: sum up capital
>>> and recurrent or by other breakdowns.
>>>
>>> > BF = Budget de fonctionnement. BIP = Budget d'Investissement Public
>>> >
>>> > BF = current
>>> > BIP = capital
>>> >
>>> > Would combining the two tables work in OpenSpending by turning the
>>> data into
>>> > something like:
>>> >
>>> > From | From_id | To | source | type | type_code | type_2 | type_2_code
>>> >
>>> > IMPOTS SUR LES REVENUS DES PERSONNES PHYSIQUES | 721 | Government of
>>> > Cameroon | Revenue | RECETTES PROPRES | A | RECETTES FISCALES | i |
>>> 155900
>>> > Government of Cameroon | 1 | Society (Cameroon) | Spending |
>>> PRESIDENCE DE
>>> > LA REPUBPLIQUE | 1 | Current spending | BF | 40927
>>> >
>>> > Would that work? Then the views would allow you to show Revenue and
>>> Spending
>>> > on separate tabs, broken down by `type` in each case.
>>>
>>> That sounds good, I've been using this with German budgets (Federal,
>>> Berlin, Bremen) and the Budget of the European Union.
>>>
>>> We'll just have to remember to reverse `to` and `from` if they are to be
>>> set :)
>>>
>>> - Friedrich
>>>
>>> > On 26 January 2012 09:34, Lucy Chambers <lucy.chambers at okfn.org>
>>> wrote:
>>> >>
>>> >> Hi Pudo,
>>> >>
>>> >> Thanks for looking at this.
>>> >>
>>> >>> Looking at the tree though, I'm not entirely sure this is normal
>>> >>> balance sheet data - is there perhaps an English version or some data
>>> >>> to look at available?
>>> >>
>>> >>
>>> >>  Sorry, I meant to send you the link to the DataHub package, there's
>>> some
>>> >> sample data in there:
>>> >>
>>> >> http://thedatahub.org/dataset/cameroon-budget-2012
>>> >>
>>> >> If there is any way to meaningfully restructure the data, I'd be
>>> happy to
>>> >> write up a guide to put on the wiki.
>>> >>
>>> >> Lucy
>>> >>
>>> >>
>>> >>>
>>> >>> Best regards,
>>> >>>
>>> >>>  - Friedrich
>>> >>>
>>> >>> [1] https://github.com/okfn/openspending/issues/157
>>> >>>
>>> >>> On Thu, Jan 26, 2012 at 12:14 AM, Lucy Chambers <
>>> lucy.chambers at okfn.org>
>>> >>> wrote:
>>> >>> > Hi All,
>>> >>> >
>>> >>> > I've been attempting to guide JeanBrice, dealing with the Cameroon
>>> >>> > budget
>>> >>> > through the Data Format process, but want to make sure I am
>>> advising
>>> >>> > him to
>>> >>> > do the right thing.
>>> >>> >
>>> >>> > His data is more like a balance sheet than what we usually have.
>>> Do we
>>> >>> > have
>>> >>> > any nice way to display receipts / income (distinguishing them from
>>> >>> > outgoings) or should he work just on the outgoings for now?
>>> >>> >
>>> >>> > His data (including a diagram to show the structure of the budget)
>>> is
>>> >>> >
>>> >>> > here:
>>> https://commondatastorage.googleapis.com/ckannet-storage/2012-01-25T132804/Tree-of-the-Budget-of-the-State-of-Cameroon.pdf
>>> ).
>>> >>> >
>>> >>> > Help appreciated!
>>> >>> >
>>> >>> > Lucy
>>> >>> >
>>> >>> > --
>>> >>> > Lucy Chambers
>>> >>> > Community Coordinator
>>> >>> > Open Knowledge Foundation
>>> >>> > http://okfn.org/
>>> >>> > Skype: lucyfediachambers
>>> >>> >
>>> >>> > _______________________________________________
>>> >>> > openspending-dev mailing list
>>> >>> > openspending-dev at lists.okfn.org
>>> >>> > http://lists.okfn.org/mailman/listinfo/openspending-dev
>>> >>> >
>>> >>
>>> >>
>>> >>
>>> >>
>>> >> --
>>> >> Lucy Chambers
>>> >> Community Coordinator
>>> >> Open Knowledge Foundation
>>> >> http://okfn.org/
>>> >> Skype: lucyfediachambers
>>> >>
>>> >> _______________________________________________
>>> >> openspending-dev mailing list
>>> >> openspending-dev at lists.okfn.org
>>> >> http://lists.okfn.org/mailman/listinfo/openspending-dev
>>> >>
>>> >
>>>
>>
>>
>
>
> --
> Lucy Chambers
> Community Coordinator
> Open Knowledge Foundation
> http://okfn.org/
> Skype: lucyfediachambers
>

-- 
Lucy Chambers
Community Coordinator
Open Knowledge Foundation
http://okfn.org/
Skype: lucyfediachambers
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending-dev/attachments/20120213/171a280e/attachment.html>