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

Mon Aug 29 08:21:56 UTC 2016

Dear Anna, Anna, Bela, Loic, Diana and Victoria,

thanks for your email: your project is really interesting.

My name is Elisa Murgese and I am a freelance journalist based in Milan. I works (also) as data journalist for Il Fatto Quotidiano.it<http://www.ilfattoquotidiano.it/blog/emurgese/ptype/articoli/> and Wired Italy<http://www.wired.it/author/emurgese/>, so it will be a pleasure for me looking at the data and making visualizations.

Moreover, I collaborate for Diritto di Sapere<https://chiedi.dirittodisapere.it>, the first and only Italian NGO specifically focused on Freedom of Information Act and access to information: our mission is to work to promote and expand the right to access to information as a tool for fostering transparency and accountability, defending civil liberties and human rights and improving citizen participation in policy-making.

For these reasons, I'd like to find stories in the datasets but also to work on European Funds and Subsidies for Italy.

Waiting for a kind reply,

Have a nice day

Elisa Murgese

+39 339 7137812
skype: elisamurgese

Giornalista per Il Fatto Quotidiano online<http://www.ilfattoquotidiano.it/blog/emurgese/ptype/articoli/>
Data journalist per Wired Italia<http://www.wired.it/author/emurgese/>
Collaboratrice per Diritto Di Sapere<http://www.dirittodisapere.it/progetto/>

> 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<http://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<http://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
> *****************************************************
_______________________________________________
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/20160829/62f7e82e/attachment-0003.html>