[Os-datawrangling] Catalan budget

Mon Aug 5 16:35:41 UTC 2013

Hello,
I extracted the data for the Agriculture dept and I am sharing this file to
ask for help to clean it and upload it to openspending

https://docs.google.com/file/d/0BydolXXFqjameTdBaFA1VnhwaDg/edit?usp=sharing

I did this by looking for keywords and codes so there will probably be
mistakes but this is my first attempt so please be patient.

This is the translation of the interesting columns

*Sheet 1*

This groups together all types of organizations belonging to this
Department (subject to different levels of interaction and different types
of public or private law- trusts, consortiums, ltds, etc)

Column B

Ingresos / Despeses=

I= Income/ D=Expenditure

C

Servei/ Entitat= organization code

D

organization name

E

type of organization

 *Sheet 2 – DG and SG*

Direccions Generals i Secretaries Generals

These group together the budget of Secretariats and Administrative Offices
directly. Secretariats are usually at a higher hierarchical level. Each
Department may have an unspecified number of each (and both)

S

concept

W

budgetary program

I look forward to your feedback. All the best,

Concha

2013/7/30 <os-datawrangling-request at lists.okfn.org>

> Send Os-datawrangling mailing list submissions to
>         os-datawrangling at lists.okfn.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://lists.okfn.org/mailman/listinfo/os-datawrangling
> or, via email, send a message with subject or body 'help' to
>         os-datawrangling-request at lists.okfn.org
>
> You can reach the person managing the list at
>         os-datawrangling-owner at lists.okfn.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Os-datawrangling digest..."
>
>
> Today's Topics:
>
>    1. Re: Data Wrangling team mailing list :) (Anders Pedersen)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 25 Jul 2013 06:44:59 -0400
> From: Anders Pedersen <anders.pedersen at okfn.org>
> Subject: Re: [Os-datawrangling] Data Wrangling team mailing list :)
> To: Conchita Catalan <ccgbcn at gmail.com>,
>         os-datawrangling at lists.okfn.org
> Cc: Elaine.ayo at gmail.com, azadeh.gishani at gmail.com,
>         alessandro.martinisi at my.westminster.ac.uk,
>         pierre.chrzanowski at gmail.com, info at mehmet.be,
> sammyslee at gmail.com,
>         tamara at weiseworte.de, jens at mnml.dk,     teo.beleaga at gmail.com,
> Mariam Edun
>         <mariam at yourbudgit.com>,        hans.loos at ymail.com,
> nclemson at hotmail.com,
>         gabe at pwd.ca,    rochellesampy at hotmail.com, tosin at yourbudgit.com
> Message-ID:
>         <
> CAKQ1VfaFNyDZkxBznXyvAHE3MvrvX_rBbqGQ+rZP04iBboOdxQ at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> All,
>
> Thanks a lot to those of you who joined the Hangout yesterday. And thanks
> Concha for pointing to the Datawrangling mailing list.
>
> I wanted to mention that we have a really interesting project to open up
> procurement data in Nigeria. The data is currently captured in a 70-page
> PDF document. I am copying to this email Mariam and Tosin from BudgIT,
> Nigeria, who are working on the project.
>
> You can find the issue created for the Nigerian procurement data on
> Datatoload here:
> https://github.com/openspending/datatoload/issues/10
>
> Tasks include:
>
>    - convert PDF to CSV
>    - clean up the CSV file, format the data and add it to OpenSpending
>
>
> It would be great to hear if this project would interest any of you?
>
> Best,
> Anders
>
> On 24 July 2013 13:41, Conchita Catalan <ccgbcn at gmail.com> wrote:
>
> > Hello,
> > This is the link to the Open Spending Data Wrangling Team Anders asked us
> > to join
> >
> > http://lists.okfn.org/mailman/listinfo/os-datawrangling
> >
> > This link is for Adriana and other journalists for resources about their
> > right to know
> >
> > http://www.access-info.org/en/toolkits/17-toolkits
> >
> > Thanks Anders for coordinating. Nice to cybermeet you all and see you
> > again on the list.
> >
> > Concha
> >
> > --
> > Visita mi blog: http://barcelonalittleshell.blogspot.com.es/
> > Visita opengov.cat
> >
> >
> >
> > 2013/7/18 Anders Pedersen <anders.pedersen at okfn.org>
> >
> >> Dear Data Wrangler,
> >>
> >> Thank you for your application to become a Data Wrangler at
> OpenSpending.
> >> I am glad to write you that we would like to invite you to join the Data
> >> Wrangling team! We have been thrilled to see such a strong interest in
> the
> >> initiative from across the community and we are eager to help you get
> >> started on what this is all about - data wrangling!
> >>
> >> On *Wednesday 24th at 18:00 CET / 17:00 BST / 12:00 EDT *we will provide
> >> you with an* introduction to the Data Wrangling team* and give you a
> >> chance to meet fellow wranglers via Google Hangout. I strongly encourage
> >> you to take part in this if time zones and work obligations allow. If
> you
> >> are not able to join, let me know and we will try to set up an
> alternative
> >> date to talk. Let me know if you can join the GHangout by responding to
> >> this email.
> >>
> >> *What will you be doing as Data Wrangler?*
> >> We have created this short guide for Data Wranglers<
> https://docs.google.com/a/okfn.org/document/d/1q_L4JC8KwpOg51BgWXhJvQD39o8GZ1c4O6rAhdVm9ro/edit#>.
> It
> >> is important to us that you read it, as it should give you a clear idea
> >> about what tasks you will be working on. Let us know if you have
> questions
> >> by commenting directly in the guide or by sharing your comments via this
> >> email. The Data Wrangling initiative is new and we are eager to hear
> your
> >> thoughts!
> >>
> >> *The first thing that we ask from you is to:*
> >> - *Claim a dataset* from progress.openspending.org, where datasets are
> >> waiting to be uploaded to OpenSpending. Begin wrangling the data,
> upload it
> >> to OpenSpending, share it with the community<
> http://lists.okfn.org/mailman/listinfo/openspending>and let us know if
> you have issues getting the data working. (If you
> >> already know what dataset that you would like to work on, add this to
> >> progress.openspending.org so that others can see what you are working
> >> on.)
> >> - *Add your bio* and picture to this google doc<
> https://docs.google.com/a/okfn.org/document/d/1rmB8azR447-zZSeouE10Z_Jq9MOKGL6f-Lic4DN2fZ4/edit
> >.
> >> We will add a page listing you and all other active Data Wranglers on
> the
> >> OpenSpending site.
> >> - *Introduce yourself *to the Data Wrangling team by responding to this
> >> email
> >>
> >> *City Spending Data Party:*
> >> As some of you have noticed we are running a City Spending Data Party<
> http://blog.openspending.org/2013/06/30/spending-data-party-announce/>
> this
> >> weekend. If you are available we encourage you to join the event online
> >> either by *working on your newly claimed dataset* or by *offering your
> >> wrangling support* to community members. We will for example be looking
> >> for a Data Wrangler to assist OKF Nepal to work on the budget of
> Kathmandu.
> >> If you would like to join the spending party, let the mailing list<
> http://lists.okfn.org/mailman/listinfo/openspending>know or ping me
> directly.
> >> We will host a Data Clinic via GHangout preparing for the spending party
> >> today *Thursday July 1**8th **at 19CET / 18 BST / 13 EDT* - your time
> >> zone<
> http://www.timeanddate.com/worldclock/fixedtime.html?msg=OS+Data+Clinic&iso=20130718T13&p1=263&ah=1
> >.
> >> You can sign up here<
> https://docs.google.com/forms/d/1vi2LNysNsu346-X8H5oIp00OUjDFsiR_pYcQSWrQAiY/viewform
> >
> >> .
> >>
> >> Welcome on board - we are thrilled to have you on!
> >>
> >> Best,
> >> Anders
> >> --
> >> *
> >>
> >> 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>
> >>
> >>
> >> *
> >>
> >> **
> >>
> >> *
> >>
> >
> >
> >
> >
> >
>
>
> --
> *
>
> 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/20130725/c6863a7d/attachment.htm
> >
>
> ------------------------------
>
> _______________________________________________
> Os-datawrangling mailing list
> Os-datawrangling at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/os-datawrangling
>
>
> End of Os-datawrangling Digest, Vol 1, Issue 1
> **********************************************
>

-- 
Visita mi blog: http://barcelonalittleshell.blogspot.com.es/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/os-datawrangling/attachments/20130805/9e0bb47b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: AGpressupost.ods
Type: application/vnd.oasis.opendocument.spreadsheet
Size: 63813 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/os-datawrangling/attachments/20130805/9e0bb47b/attachment-0002.ods>