[OpenSpending] italian data on Regional Public Accounts

Thu Mar 7 17:18:21 UTC 2013

Hi Marco,

Thanks a lot for sharing the information on the great work you're
doing on the regional budgets. Apologies for the response!

I've added some comments inline below. Let me know if this answers
your questions and make sure to keep us updated on new developments.

Best,
Anders

On 1 March 2013 12:50, Cocchiara Marco <marco.cocchiara at tesoro.it> wrote:
> Hi all,
>
>
>
> We’re writing about the Italian data on Regional Public Accounts which are
> available on the OpenSpending platform at
> http://openspending.org/it-regional-accounts as well as at
> http://openspending.org/cpt2006-2010cofog as a result of a joint one-time
> work for upload and publication, made some time ago.
>

Yes, I believe they were added during one of the recent Journalism
festivals in Perugia (http://www.journalismfestival.com/).

>
>
> We worked a lot in the last months in order to guarantee the availability of
> the entire database (budgets of the whole Italian General Government/Public
> Sector at the regional level) in open format and we have just published two
> different sets of csv files, one on revenues and one on expenditures. They
> are both available:
>
>
>
> -          At http://www.dps.tesoro.it/cpt/opencpt.asp with variable labels
> in Italian
>
>
>
> -          At http://www.dps.tesoro.it/cpt-eng/rpa_opencpt.asp with variable
> labels in English in order to facilitate international reuse of information
>
>
>
> The entire data time series (1996-2010) is now published under the CC BY-SA
> 3.0 licence so that users are allowed to: replicate, share and circulate
> both data and analyses in the public domain; change and adapt data; use data
> for business purposes, provided the same type of licence is applied.
>
>
>
> As a result of such upgrades, it would be great to update Italian Regional
> Public Accounts data on the OpenSpending platform using the new csv files.

If the format is completely identical (ie. same columns) as the
regional data already uploaded, only with additional years, you can
add the new data as an additional source.

However as I understand there are revised figures in the new data,
which differs from the older data, right? In that case, I would
suggest that you add the data as a separate dataset. In this way we
manage to keep a clear "paper trail" of earlier uploaded versions of
the Italian Regional data, which might turn out to be useful in the
future.

>
> Please note that the txt duplicate on the datahub
> (http://datahub.io/group/openspending) can be removed.
>
>
>
> Please let us know if you can proceed on your own for the publication on
> OpenSpending or need some kind of analytic support from us. And if, after
> this publication, you can perform an automatic upload when we update data
> (we are going to publish 2011 data in a few weeks' time).
>

As you are the ones who knows the budget data best both as of
dimensions and language, I think it would be ideal if you upload the
data your self. You can easily create an account here:
http://openspending.org/login

>
>
> We would like to support reuse of Italian data and all the OpenSpending
> visualizations are extremely useful for us….
>
>
>
> A last (but not least!) request: is it possible to quote the source in the
> OpenSpending page related to these data including a link to the English web
> site on the Regional Public Accounts
> (http://www.dps.tesoro.it/cpt-eng/rpa_about.asp )? It would be great and it
> would help users in understanding some relevant methodological aspects
> extremely important in comparing visualization with other budget
> information!

Yes. When you upload a dataset to OpenSpending, you can add such a
link as well as a methodological text to the "Description" field:
http://openspending.org/datasets/new

>
>
>
> Thank you for everything!
>

You're welcome. We're glad you are working on this. Let us know if we
can provide any other assistance!

>
>
> The Italian team of the Regional Public Accounts project
>
>
>
>
> _______________________________________________
> openspending mailing list
> openspending at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/openspending
> Unsubscribe: http://lists.okfn.org/mailman/options/openspending
>

--
Anders Pedersen
Community Coordinator
OpenSpending
Open Knowledge Foundation
Twitter: @anpe
Skype: anpehej