Alegeri extra (view)
Data source: Expert Forum · About: Metodologie
4 rows where Tip = "EUR" sorted by Data
This data as json, CSV (advanced)
Alegeri | Tip | Descriptiv | Data desfășurării | Data ▼ | Candidați | Competitori | Independenți | Venituri | Cheltuieli |
---|---|---|---|---|---|---|---|---|---|
2009EUR | EUR | Parlamentul European | 7 iunie 2009 | 07.06.2009 | 289 | 9 | 13184406.93 | 21121893.179999996 | |
2014EUR | EUR | Parlamentul European | 25 mai 2014 | 25.05.2014 | 579 | 23 | 12222397 | 21159896 | |
2007EUR | EUR | Parlamentul European | 25 noiembrie 2007 | 25.11.2007 | 506 | 14 | 14168911.080000002 | 22909000.219999995 | |
2019EUR | EUR | Parlamentul European | 26 mai 2019 | 26.05.2019 | 695 | 17 | 95126378.81 | 90341169.60000002 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW "Alegeri extra" AS SELECT a.*, b.Venituri, b.Cheltuieli FROM (SELECT Cod AS Alegeri, Tip, Descriptiv, "Data desfășurării", Data, Candidați, Competitori, Independenți FROM 'Legenda alegeri') a JOIN (SELECT alegeri, Venituri, Cheltuieli FROM "Venituri cheltuieli alegeri - total" ) b on a.Alegeri = b.Alegeri;