Alegeri extra (view)
Data source: Expert Forum · About: Metodologie
1 row where Competitori = 9 sorted by Tip
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 |
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;