DW Data - Parteispenden
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
In this spreadsheet you find the raw data that DW's article xxx is based on. In case you have any commentsm questions or spotted a mistake, please don't hesitate to get in touch via email to design.data@dw.com
2
Link to the mentioned article:
3
4
In diesem Tabellen-Dokument finden Sie die Roh-Daten, auf denen der DW-Artikel "Wie Firmen deutsche Parteien finanzieren" beruht. Sollten Sie Anmerkungen, Fragen oder einen Fehler gefunden haben, freuen wir uns über Ihre Email an design.data@dw.com
5
Link zum erwähnten Artikel:
6
7
A. DATA SOURCES (Datenquellen)
8
9
1. Party Financial Statements (Rechenschaftsberichte)
10
This parliament website collects all financial statements of all parties
https://www.bundestag.de/parlament/praesidium/parteienfinanzierung/rechenschaftsberichte/
11
Diese Website des Bundestages sammelt die Rechenschaftsberichte aller Parteien
12
13
For
14
2013
data were downloaded from the Open Data City Database
https://apps.opendatacity.de/parteispenden-recherche/#/list
15
and slightly revised because of four duplicates that were taken out
16
2014and
17
2015
were reverse-engineered from the above-linked pdfs into machine-readable format using Python and the tesseract library
18
and subsequentially cleaned with Regular Expressions, manually dounble-checked for accuracy and lastly reworked with Open Refine to unify names and addresses
19
2016, 2017
not yet available
20
21
2. Disclosed major donations (Gemeldete Großspenden)
22
The German parliament's website (Meldewebseite des Bundestages)
https://www.bundestag.de/parlament/praesidium/parteienfinanzierung/fundstellen50000
23
The website was scraped using Python and the Beautiful Soup library
24
25
Only donations to CDU, CSU, SPD, the Greens, the Left party, FDP, and the AfD were included
26
Three donations from BMW in February and March 2013 were excluded [FDP (69,081.24), SPD (107,376.06 Euro) and CSU (143,817.65 Euro)] because they were referring to the equivalent of performance in kind from 2012
http://dip21.bundestag.de/dip21/btd/17/130/1713010.pdf
27
28
B. INDEX OF DIFFERENT SPREADSHEETS CONTAINED IN THIS FILE (Index der verschiedenen Tabellen-Dokumente, die in dieser Datei enthalten sind)
29
30
1) Major donations (Großspenden) 2013 - 2017
31
A major contribution is defined as any individual donation above 50,000 euros ($60,000)
32
33
2) Donor information for donations above 10K from all parties' financial statements, 2013-2015
34
This includes data from donors and also contributions from elected representatives for example; the threshold for being listed with name, address and donation within a party's financial statement is a contribution of at least 10K a given year
35
36
3) Sources of party income from all parties' financial statements, 2013-2015
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Meta-Information
1_Major donations_Großspenden_2013-2017
2_Donations_over_10K_2013-2015
3_Sources_of_party_income