Alegeri extra (view)
Data source: Expert Forum · About: Metodologie
4 rows where Tip = "L"
This data as json, CSV (advanced)
Alegeri | Tip | Descriptiv | Data desfășurării | Data | Candidați | Competitori | Independenți | Venituri | Cheltuieli |
---|---|---|---|---|---|---|---|---|---|
2008L | L | Alegeri locale | 1 iunie 2008 | 01.06.2008 | 366814 | 4.34 | 77467422.39 | 91566845.52000001 | |
2012L | L | Alegeri locale | 10 iunie 2012 | 10.06.2012 | 285416 | 2810 | 51612145 | 61677485 | |
2016L | L | Alegeri locale | 5 iunie 2016 | 05.06.2016 | 267240 | 2376 | 58741439.92000001 | 53660759.57000001 | |
2020L | L | Alegeri locale | 27 septembrie 2020 | 27.09.2020 | 256042 | 177780309.53000003 | 167248814.60999995 |
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;