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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000064095 | L17/scrutins | 17 | 17080000064065 | 17080000064094 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000064156 | L17/scrutins | 17 | 17080000064065 | 17080000064155 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000064237 | L17/scrutins | 17 | 17080000064207 | 17080000064236 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000064300 | L17/scrutins | 17 | 17080000064207 | 17080000064299 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000064385 | L17/scrutins | 17 | 17080000064355 | 17080000064384 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000064449 | L17/scrutins | 17 | 17080000064355 | 17080000064448 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000064576 | L17/scrutins | 17 | 17080000064504 | 17080000064575 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000064670 | L17/scrutins | 17 | 17080000064504 | 17080000064669 | 1 | PA643089 | PM843431 | False | MG | |
| 17080000064710 | L17/scrutins | 17 | 17080000064504 | 17080000064709 | 1 | PA720480 | PM843101 | False | MG | |
| 17080000064782 | L17/scrutins | 17 | 17080000064741 | 17080000064781 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000064854 | L17/scrutins | 17 | 17080000064741 | 17080000064853 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000064959 | L17/scrutins | 17 | 17080000064918 | 17080000064958 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000065023 | L17/scrutins | 17 | 17080000064918 | 17080000065022 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000065126 | L17/scrutins | 17 | 17080000065085 | 17080000065125 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000065189 | L17/scrutins | 17 | 17080000065085 | 17080000065188 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000065287 | L17/scrutins | 17 | 17080000065247 | 17080000065286 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000065348 | L17/scrutins | 17 | 17080000065247 | 17080000065347 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000065433 | L17/scrutins | 17 | 17080000065399 | 17080000065432 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000065496 | L17/scrutins | 17 | 17080000065399 | 17080000065495 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000065560 | L17/scrutins | 17 | 17080000065547 | 17080000065559 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000065647 | L17/scrutins | 17 | 17080000065625 | 17080000065646 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000065795 | L17/scrutins | 17 | 17080000065763 | 17080000065794 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000065951 | L17/scrutins | 17 | 17080000065918 | 17080000065950 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000066099 | L17/scrutins | 17 | 17080000066065 | 17080000066098 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000066261 | L17/scrutins | 17 | 17080000066215 | 17080000066260 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000066320 | L17/scrutins | 17 | 17080000066215 | 17080000066319 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080000066346 | L17/scrutins | 17 | 17080000066215 | 17080000066345 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080000066405 | L17/scrutins | 17 | 17080000066369 | 17080000066404 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000066598 | L17/scrutins | 17 | 17080000066546 | 17080000066597 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000066799 | L17/scrutins | 17 | 17080000066772 | 17080000066798 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000066910 | L17/scrutins | 17 | 17080000066887 | 17080000066909 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000067020 | L17/scrutins | 17 | 17080000066997 | 17080000067019 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000067128 | L17/scrutins | 17 | 17080000067102 | 17080000067127 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000067140 | L17/scrutins | 17 | 17080000067102 | 17080000067139 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000067240 | L17/scrutins | 17 | 17080000067212 | 17080000067239 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000067361 | L17/scrutins | 17 | 17080000067333 | 17080000067360 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000067479 | L17/scrutins | 17 | 17080000067461 | 17080000067478 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000067579 | L17/scrutins | 17 | 17080000067556 | 17080000067578 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000067718 | L17/scrutins | 17 | 17080000067668 | 17080000067717 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000067792 | L17/scrutins | 17 | 17080000067668 | 17080000067791 | 1 | PA643089 | PM843431 | False | MG | |
| 17080000067824 | L17/scrutins | 17 | 17080000067668 | 17080000067823 | 1 | PA720480 | PM843101 | False | MG | |
| 17080000067878 | L17/scrutins | 17 | 17080000067857 | 17080000067877 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000067995 | L17/scrutins | 17 | 17080000067973 | 17080000067994 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000068122 | L17/scrutins | 17 | 17080000068099 | 17080000068121 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000068252 | L17/scrutins | 17 | 17080000068228 | 17080000068251 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000068381 | L17/scrutins | 17 | 17080000068354 | 17080000068380 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000068508 | L17/scrutins | 17 | 17080000068483 | 17080000068507 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000068614 | L17/scrutins | 17 | 17080000068604 | 17080000068613 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000068694 | L17/scrutins | 17 | 17080000068682 | 17080000068693 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000068793 | L17/scrutins | 17 | 17080000068774 | 17080000068792 | 1 | PA721908 | PM843467 | False | 402 | PAN |