scrutins.scrutin_groupe_non_votants_votant
Chemin scrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant · présence : L17 99 %, L16 96 %, L15 99 %, L14 100 %
38 323 lignes (estimation)
Colonnes
| # | Colonne | Type | Commentaire |
|---|---|---|---|
| 1 | _id | BIGINT | identifiant : code de la source × 10¹⁰ + rang |
| 2 | _source | VARCHAR | source du catalogue (catalogue.py) |
| 3 | _legislature | BIGINT | colonne constante de la source |
| 4 | _racine_id | BIGINT | _id de la ligne racine |
| 5 | _parent_id | BIGINT | _id de la ligne parente |
| 6 | _ordre | BIGINT | rang dans le tableau d'origine (1…) |
| 7 | acteur_ref | VARCHAR | scrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.acteurRef · présence : L17 99 %, L16 96 %, L15 99 %, L14 100 % |
| 8 | mandat_ref | VARCHAR | scrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.mandatRef · présence : L17 99 %, L16 96 %, L15 99 %, L14 100 % |
| 9 | par_delegation | BOOLEAN | scrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.parDelegation · présence : L17 99 % |
| 10 | num_place | VARCHAR | scrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.numPlace · présence : L17 99 % |
| 11 | cause_position_vote | VARCHAR | scrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.causePositionVote · présence : L17 99 %, L16 96 %, L15 99 %, L14 100 % · XSD 2016 : Principalement utilisé dans le cas "nonVotant" pour pouvoir expliquer la raison 'réglementaire' de la position i.e. : Président de l'A.N., Président de la Séance, Nomination à un ministère, ou position personnelle 4 valeurs sont possibles PSE = Président de Séance PAN = Président de l'Assemblée nationale MG = Membre du Gouvernement PP = Position personnelle |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_ref | mandat_ref | par_delegation | num_place | cause_position_vote |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000215195 | L17/scrutins | 17 | 17080000215162 | 17080000215194 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000215196 | L17/scrutins | 17 | 17080000215162 | 17080000215194 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000215373 | L17/scrutins | 17 | 17080000215292 | 17080000215372 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000215416 | L17/scrutins | 17 | 17080000215292 | 17080000215415 | 1 | PA795228 | PM840447 | False | 627 | PSE |
| 17080000215492 | L17/scrutins | 17 | 17080000215292 | 17080000215491 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080000215523 | L17/scrutins | 17 | 17080000215292 | 17080000215522 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080000215594 | L17/scrutins | 17 | 17080000215560 | 17080000215593 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000215660 | L17/scrutins | 17 | 17080000215560 | 17080000215659 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000215704 | L17/scrutins | 17 | 17080000215671 | 17080000215703 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000215705 | L17/scrutins | 17 | 17080000215671 | 17080000215703 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000215831 | L17/scrutins | 17 | 17080000215798 | 17080000215830 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000215832 | L17/scrutins | 17 | 17080000215798 | 17080000215830 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000215961 | L17/scrutins | 17 | 17080000215929 | 17080000215960 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000215962 | L17/scrutins | 17 | 17080000215929 | 17080000215960 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000216085 | L17/scrutins | 17 | 17080000216055 | 17080000216084 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000216086 | L17/scrutins | 17 | 17080000216055 | 17080000216084 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000216211 | L17/scrutins | 17 | 17080000216180 | 17080000216210 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000216212 | L17/scrutins | 17 | 17080000216180 | 17080000216210 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000216334 | L17/scrutins | 17 | 17080000216303 | 17080000216333 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000216335 | L17/scrutins | 17 | 17080000216303 | 17080000216333 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000216459 | L17/scrutins | 17 | 17080000216428 | 17080000216458 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000216460 | L17/scrutins | 17 | 17080000216428 | 17080000216458 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000216806 | L17/scrutins | 17 | 17080000216763 | 17080000216805 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000216989 | L17/scrutins | 17 | 17080000216956 | 17080000216988 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000217143 | L17/scrutins | 17 | 17080000217101 | 17080000217142 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000217224 | L17/scrutins | 17 | 17080000217101 | 17080000217223 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000217279 | L17/scrutins | 17 | 17080000217241 | 17080000217278 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000217468 | L17/scrutins | 17 | 17080000217430 | 17080000217467 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000217660 | L17/scrutins | 17 | 17080000217619 | 17080000217659 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000217866 | L17/scrutins | 17 | 17080000217819 | 17080000217865 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000218081 | L17/scrutins | 17 | 17080000218026 | 17080000218080 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000218333 | L17/scrutins | 17 | 17080000218268 | 17080000218332 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000218429 | L17/scrutins | 17 | 17080000218268 | 17080000218428 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000218538 | L17/scrutins | 17 | 17080000218497 | 17080000218537 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000218580 | L17/scrutins | 17 | 17080000218497 | 17080000218579 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000218674 | L17/scrutins | 17 | 17080000218614 | 17080000218673 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000218774 | L17/scrutins | 17 | 17080000218614 | 17080000218773 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000218895 | L17/scrutins | 17 | 17080000218834 | 17080000218894 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000218992 | L17/scrutins | 17 | 17080000218834 | 17080000218991 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000219115 | L17/scrutins | 17 | 17080000219055 | 17080000219114 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000219227 | L17/scrutins | 17 | 17080000219055 | 17080000219226 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000219330 | L17/scrutins | 17 | 17080000219288 | 17080000219329 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000219389 | L17/scrutins | 17 | 17080000219288 | 17080000219388 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000219468 | L17/scrutins | 17 | 17080000219407 | 17080000219467 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000219690 | L17/scrutins | 17 | 17080000219653 | 17080000219689 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000219773 | L17/scrutins | 17 | 17080000219653 | 17080000219772 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000219825 | L17/scrutins | 17 | 17080000219822 | 17080000219824 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000219997 | L17/scrutins | 17 | 17080000219952 | 17080000219996 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000219998 | L17/scrutins | 17 | 17080000219952 | 17080000219996 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000220170 | L17/scrutins | 17 | 17080000220124 | 17080000220169 | 1 | PA721908 | PM843467 | False | 402 | PAN |