[ddj] ...data on all European Subsidies - SQL

Sun Aug 28 17:08:27 UTC 2016

Hi Anna,

I'm a freelance journalist based near Los Angeles and interested in looking at the data and making visualizations. I'd like to use the compiled data to create meaningful charts and graphs.

At my ecommerce day job, I'm accustomed to manipulating large amounts data. If you need help compiling, cross referencing or cleaning, I would love to help as well. I'm also comfortable using php to scrape data/content from websites.

Regards,
Matthew

> On Aug 27, 2016, at 5:00 AM, "data-driven-journalism-request at lists.okfn.org" <data-driven-journalism-request at lists.okfn.org> wrote:
> 
> Send data-driven-journalism mailing list submissions to
>  data-driven-journalism at lists.okfn.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>  https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> or, via email, send a message with subject or body 'help' to
>  data-driven-journalism-request at lists.okfn.org
> 
> You can reach the person managing the list at
>  data-driven-journalism-owner at lists.okfn.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of data-driven-journalism digest..."
> 
> 
> Today's Topics:
> 
> 1. We want ALL data on all European Subsidies! (Anna Alberts)
> 2. Re: We want ALL data on all European Subsidies! (Adrian)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Fri, 26 Aug 2016 14:27:03 +0200
> From: Anna Alberts <anna.alberts at okfn.de>
> To: data-driven-journalism at lists.okfn.org
> Cc: Diana Krebs <diana.krebs at okfn.org>, loic <loic at cyberpunk.bike>,
>  Victoria Vlad <victoria.vlad at okfn.org>
> Subject: [ddj] We want ALL data on all European Subsidies!
> Message-ID:
>  <CA+mox0k8D4asMsuw2wpNN1K-aFVXyO9z9-uTVZxNsHwccHDuvQ at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
> 
> Hi Everyone,
> 
> *We need your HELP! We want ALL data on all European Subsidies!*
> 
> How much the EU spends its money and how EU-subsidies are divided on
> regional level is wonderfully complex
> <http://openbudgets.eu/post/2016/06/09/how-can-we-track-EU-spending/>
> and difficult
> to trace. <http://openbudgets.eu/post/2016/06/14/tracing-eu-funds/> The
> data is partially available on different websites of regions and members
> states.
> 
> We, Open Knowledge Germany and Open Knowledge International, have set out
> to bring this all together in one platform, and make sure it is easy to
> query, visualise and analyse. We will start with the European Structural
> and Cohesion Funds (ESIF). We have made a first forey bringing all the ESIF
> datasets/websites in this spreadsheet
> <https://docs.google.com/spreadsheets/d/1RkC_YuWWlhGxyDRc-bpD_zaWAXK78GpPr8nfPesQfSY/edit?usp=sharing>
> and
> this repository. <https://github.com/os-data/eu-structural-funds>
> 
> Now we need your help!
> 
> Would you like to work on European Funds and Subsidies for your country, or
> are you already working on it? Do drop us a line!
> 
> Do you have domain knowledge about Financial Transparency in Europe and
> would you like to help us write tutorials and resources?
> 
> Do you just want to play around with the data and find stories in the
> datasets?
> 
> Let us know!
> 
> Cheers,
> 
> Anna, Bela, Loic, Diana, Victoria
> 
> -- 
> Anna Alberts, Project Manager OpenBudgets.eu
> Open Knowledge Foundation Germany
> www.okfn.de | info at okfn.de | @okfde
> anna.alberts at okfn.de <info at okfn.de> | @Anna_Alberts
> Office: +49 30 57703666 0
> Mobile: +49 176 21370998 <%2B49%20176%2032768530>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20160826/6ec99808/attachment-0001.html>
> 
> ------------------------------
> 
> Message: 2
> Date: Fri, 26 Aug 2016 22:53:44 +0530
> From: Adrian <adrianblancoramos at gmail.com>
> To: "List about Data Driven Journalism and Open Data in Journalism."
>  <data-driven-journalism at lists.okfn.org>
> Subject: Re: [ddj] We want ALL data on all European Subsidies!
> Message-ID: <F7569453-B00C-4A23-8ABE-92CB7026432D at gmail.com>
> Content-Type: text/plain; charset="utf-8"
> 
> Hi Anna,
> 
> I am Adrian Blanco, a data journalist working at Spanish newspaper El Confidencial.
> 
> Next week I am in holidays but on September I will be back. Sounds like a really good idea. Take me into account to work in the project. I have worked before with EU subsidies and it is a very interesting and wide topic.
> 
> Let me know if you need more info and next steps.
> 
> 
> All the best,
> 
> Adri?n
> 
> 
>> On 26 Aug 2016, at 17:57, Anna Alberts <anna.alberts at okfn.de> wrote:
>> 
>> Hi Everyone,
>> 
>> We need your HELP! We want ALL data on all European Subsidies!
>> 
>> How much the EU spends its money and how EU-subsidies are divided on regional level is wonderfully complex and difficult to trace. The data is partially available on different websites of regions and members states. 
>> 
>> We, Open Knowledge Germany and Open Knowledge International, have set out to bring this all together in one platform, and make sure it is easy to query, visualise and analyse. We will start with the European Structural and Cohesion Funds (ESIF). We have made a first forey bringing all the ESIF datasets/websites in this spreadsheet and this repository.
>> 
>> Now we need your help!
>> 
>> Would you like to work on European Funds and Subsidies for your country, or are you already working on it? Do drop us a line!
>> 
>> Do you have domain knowledge about Financial Transparency in Europe and would you like to help us write tutorials and resources?
>> 
>> Do you just want to play around with the data and find stories in the datasets?
>> 
>> Let us know!
>> 
>> Cheers,
>> 
>> Anna, Bela, Loic, Diana, Victoria
>> 
>> 
>> -- 
>> Anna Alberts, Project Manager OpenBudgets.eu
>> Open Knowledge Foundation Germany
>> www.okfn.de | info at okfn.de | @okfde
>> anna.alberts at okfn.de | @Anna_Alberts
>> Office: +49 30 57703666 0
>> Mobile: +49 176 21370998
>> _______________________________________________
>> data-driven-journalism mailing list
>> data-driven-journalism at lists.okfn.org
>> https://lists.okfn.org/mailman/listinfo/data-driven-journalism
>> Unsubscribe: https://lists.okfn.org/mailman/options/data-driven-journalism
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20160826/c5debe55/attachment-0001.html>
> 
> ------------------------------
> 
> Subject: Digest Footer
> 
> _______________________________________________
> data-driven-journalism mailing list
> data-driven-journalism at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> Unsubscribe: https://lists.okfn.org/mailman/options/data-driven-journalism
> 
> 
> ------------------------------
> 
> End of data-driven-journalism Digest, Vol 65, Issue 4
> *****************************************************