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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000206534 | L17/scrutins | 17 | 17080000206476 | 17080000206533 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000206535 | L17/scrutins | 17 | 17080000206476 | 17080000206533 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000206679 | L17/scrutins | 17 | 17080000206621 | 17080000206678 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000206680 | L17/scrutins | 17 | 17080000206621 | 17080000206678 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000206843 | L17/scrutins | 17 | 17080000206785 | 17080000206842 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000206844 | L17/scrutins | 17 | 17080000206785 | 17080000206842 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000207010 | L17/scrutins | 17 | 17080000206952 | 17080000207009 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000207011 | L17/scrutins | 17 | 17080000206952 | 17080000207009 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000207181 | L17/scrutins | 17 | 17080000207122 | 17080000207180 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000207182 | L17/scrutins | 17 | 17080000207122 | 17080000207180 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000207352 | L17/scrutins | 17 | 17080000207293 | 17080000207351 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000207353 | L17/scrutins | 17 | 17080000207293 | 17080000207351 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000207523 | L17/scrutins | 17 | 17080000207464 | 17080000207522 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000207524 | L17/scrutins | 17 | 17080000207464 | 17080000207522 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000207722 | L17/scrutins | 17 | 17080000207612 | 17080000207721 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000207848 | L17/scrutins | 17 | 17080000207612 | 17080000207847 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000208013 | L17/scrutins | 17 | 17080000207954 | 17080000208012 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000208014 | L17/scrutins | 17 | 17080000207954 | 17080000208012 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000208183 | L17/scrutins | 17 | 17080000208126 | 17080000208182 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000208184 | L17/scrutins | 17 | 17080000208126 | 17080000208182 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000208353 | L17/scrutins | 17 | 17080000208294 | 17080000208352 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000208354 | L17/scrutins | 17 | 17080000208294 | 17080000208352 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000208522 | L17/scrutins | 17 | 17080000208463 | 17080000208521 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000208523 | L17/scrutins | 17 | 17080000208463 | 17080000208521 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000208689 | L17/scrutins | 17 | 17080000208630 | 17080000208688 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000208690 | L17/scrutins | 17 | 17080000208630 | 17080000208688 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000208859 | L17/scrutins | 17 | 17080000208800 | 17080000208858 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000208860 | L17/scrutins | 17 | 17080000208800 | 17080000208858 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000209029 | L17/scrutins | 17 | 17080000208970 | 17080000209028 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000209030 | L17/scrutins | 17 | 17080000208970 | 17080000209028 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000209199 | L17/scrutins | 17 | 17080000209140 | 17080000209198 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000209200 | L17/scrutins | 17 | 17080000209140 | 17080000209198 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000209367 | L17/scrutins | 17 | 17080000209310 | 17080000209366 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000209368 | L17/scrutins | 17 | 17080000209310 | 17080000209366 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000209536 | L17/scrutins | 17 | 17080000209477 | 17080000209535 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000209537 | L17/scrutins | 17 | 17080000209477 | 17080000209535 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000209769 | L17/scrutins | 17 | 17080000209645 | 17080000209768 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000209883 | L17/scrutins | 17 | 17080000209645 | 17080000209882 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000210054 | L17/scrutins | 17 | 17080000209995 | 17080000210053 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000210055 | L17/scrutins | 17 | 17080000209995 | 17080000210053 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000210224 | L17/scrutins | 17 | 17080000210165 | 17080000210223 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000210225 | L17/scrutins | 17 | 17080000210165 | 17080000210223 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000210394 | L17/scrutins | 17 | 17080000210335 | 17080000210393 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000210395 | L17/scrutins | 17 | 17080000210335 | 17080000210393 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000210563 | L17/scrutins | 17 | 17080000210504 | 17080000210562 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000210564 | L17/scrutins | 17 | 17080000210504 | 17080000210562 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000210734 | L17/scrutins | 17 | 17080000210675 | 17080000210733 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000210735 | L17/scrutins | 17 | 17080000210675 | 17080000210733 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000210904 | L17/scrutins | 17 | 17080000210847 | 17080000210903 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000210905 | L17/scrutins | 17 | 17080000210847 | 17080000210903 | 2 | PA721134 | PM843797 | False | 268 | PSE |