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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000320437 | L17/scrutins | 17 | 17080000320372 | 17080000320436 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000320476 | L17/scrutins | 17 | 17080000320455 | 17080000320475 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000320512 | L17/scrutins | 17 | 17080000320455 | 17080000320511 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000320553 | L17/scrutins | 17 | 17080000320530 | 17080000320552 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000320596 | L17/scrutins | 17 | 17080000320530 | 17080000320595 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000320636 | L17/scrutins | 17 | 17080000320613 | 17080000320635 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000320679 | L17/scrutins | 17 | 17080000320613 | 17080000320678 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000320716 | L17/scrutins | 17 | 17080000320696 | 17080000320715 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000320784 | L17/scrutins | 17 | 17080000320764 | 17080000320783 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000320908 | L17/scrutins | 17 | 17080000320841 | 17080000320907 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000320958 | L17/scrutins | 17 | 17080000320841 | 17080000320957 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000321025 | L17/scrutins | 17 | 17080000321005 | 17080000321024 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000321100 | L17/scrutins | 17 | 17080000321080 | 17080000321099 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000321179 | L17/scrutins | 17 | 17080000321161 | 17080000321178 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000321258 | L17/scrutins | 17 | 17080000321239 | 17080000321257 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000321337 | L17/scrutins | 17 | 17080000321319 | 17080000321336 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000321419 | L17/scrutins | 17 | 17080000321400 | 17080000321418 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000321498 | L17/scrutins | 17 | 17080000321479 | 17080000321497 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000321573 | L17/scrutins | 17 | 17080000321560 | 17080000321572 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000321643 | L17/scrutins | 17 | 17080000321626 | 17080000321642 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000321718 | L17/scrutins | 17 | 17080000321701 | 17080000321717 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000321835 | L17/scrutins | 17 | 17080000321778 | 17080000321834 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000321890 | L17/scrutins | 17 | 17080000321778 | 17080000321889 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000321947 | L17/scrutins | 17 | 17080000321930 | 17080000321946 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000322028 | L17/scrutins | 17 | 17080000322007 | 17080000322027 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000322108 | L17/scrutins | 17 | 17080000322089 | 17080000322107 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000322123 | L17/scrutins | 17 | 17080000322089 | 17080000322122 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000322185 | L17/scrutins | 17 | 17080000322166 | 17080000322184 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000322200 | L17/scrutins | 17 | 17080000322166 | 17080000322199 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000322267 | L17/scrutins | 17 | 17080000322249 | 17080000322266 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000322351 | L17/scrutins | 17 | 17080000322333 | 17080000322350 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000322366 | L17/scrutins | 17 | 17080000322333 | 17080000322365 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000322446 | L17/scrutins | 17 | 17080000322418 | 17080000322445 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000322527 | L17/scrutins | 17 | 17080000322418 | 17080000322526 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000322567 | L17/scrutins | 17 | 17080000322544 | 17080000322566 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000322660 | L17/scrutins | 17 | 17080000322544 | 17080000322659 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000322699 | L17/scrutins | 17 | 17080000322676 | 17080000322698 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000322797 | L17/scrutins | 17 | 17080000322676 | 17080000322796 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000322838 | L17/scrutins | 17 | 17080000322813 | 17080000322837 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000322934 | L17/scrutins | 17 | 17080000322813 | 17080000322933 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000323021 | L17/scrutins | 17 | 17080000322952 | 17080000323020 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000323096 | L17/scrutins | 17 | 17080000322952 | 17080000323095 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000323170 | L17/scrutins | 17 | 17080000323145 | 17080000323169 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000323261 | L17/scrutins | 17 | 17080000323145 | 17080000323260 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000323302 | L17/scrutins | 17 | 17080000323277 | 17080000323301 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000323401 | L17/scrutins | 17 | 17080000323277 | 17080000323400 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000323445 | L17/scrutins | 17 | 17080000323419 | 17080000323444 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000323544 | L17/scrutins | 17 | 17080000323419 | 17080000323543 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000323587 | L17/scrutins | 17 | 17080000323563 | 17080000323586 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000323685 | L17/scrutins | 17 | 17080000323563 | 17080000323684 | 1 | PA720908 | PM843701 | False | 221 | PSE |