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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000137887 | L17/scrutins | 17 | 17080000137784 | 17080000137886 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000137961 | L17/scrutins | 17 | 17080000137929 | 17080000137960 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000138017 | L17/scrutins | 17 | 17080000137929 | 17080000138016 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000138114 | L17/scrutins | 17 | 17080000138052 | 17080000138113 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000138115 | L17/scrutins | 17 | 17080000138052 | 17080000138113 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000138306 | L17/scrutins | 17 | 17080000138273 | 17080000138305 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000138359 | L17/scrutins | 17 | 17080000138273 | 17080000138358 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000138423 | L17/scrutins | 17 | 17080000138396 | 17080000138422 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000138471 | L17/scrutins | 17 | 17080000138396 | 17080000138470 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000138530 | L17/scrutins | 17 | 17080000138503 | 17080000138529 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000138575 | L17/scrutins | 17 | 17080000138503 | 17080000138574 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000138632 | L17/scrutins | 17 | 17080000138605 | 17080000138631 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000138677 | L17/scrutins | 17 | 17080000138605 | 17080000138676 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000138729 | L17/scrutins | 17 | 17080000138709 | 17080000138728 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000138841 | L17/scrutins | 17 | 17080000138816 | 17080000138840 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000138962 | L17/scrutins | 17 | 17080000138938 | 17080000138961 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000138980 | L17/scrutins | 17 | 17080000138938 | 17080000138979 | 1 | PA795228 | PM840447 | False | 627 | PSE |
| 17080000139094 | L17/scrutins | 17 | 17080000139058 | 17080000139093 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000139233 | L17/scrutins | 17 | 17080000139200 | 17080000139232 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000139366 | L17/scrutins | 17 | 17080000139329 | 17080000139365 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000139576 | L17/scrutins | 17 | 17080000139482 | 17080000139575 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000139764 | L17/scrutins | 17 | 17080000139482 | 17080000139763 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000139949 | L17/scrutins | 17 | 17080000139913 | 17080000139948 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000140092 | L17/scrutins | 17 | 17080000140056 | 17080000140091 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000140237 | L17/scrutins | 17 | 17080000140201 | 17080000140236 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000140380 | L17/scrutins | 17 | 17080000140344 | 17080000140379 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000140520 | L17/scrutins | 17 | 17080000140487 | 17080000140519 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000140660 | L17/scrutins | 17 | 17080000140628 | 17080000140659 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000140808 | L17/scrutins | 17 | 17080000140758 | 17080000140807 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000140976 | L17/scrutins | 17 | 17080000140927 | 17080000140975 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000141151 | L17/scrutins | 17 | 17080000141097 | 17080000141150 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000141336 | L17/scrutins | 17 | 17080000141282 | 17080000141335 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000141521 | L17/scrutins | 17 | 17080000141468 | 17080000141520 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000141590 | L17/scrutins | 17 | 17080000141468 | 17080000141589 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000141701 | L17/scrutins | 17 | 17080000141650 | 17080000141700 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000141879 | L17/scrutins | 17 | 17080000141828 | 17080000141878 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000142058 | L17/scrutins | 17 | 17080000142006 | 17080000142057 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000142240 | L17/scrutins | 17 | 17080000142182 | 17080000142239 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000142426 | L17/scrutins | 17 | 17080000142368 | 17080000142425 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000142607 | L17/scrutins | 17 | 17080000142549 | 17080000142606 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000142789 | L17/scrutins | 17 | 17080000142731 | 17080000142788 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000142971 | L17/scrutins | 17 | 17080000142915 | 17080000142970 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000143145 | L17/scrutins | 17 | 17080000143091 | 17080000143144 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000143327 | L17/scrutins | 17 | 17080000143276 | 17080000143326 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000143513 | L17/scrutins | 17 | 17080000143457 | 17080000143512 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000143584 | L17/scrutins | 17 | 17080000143457 | 17080000143583 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000143699 | L17/scrutins | 17 | 17080000143641 | 17080000143698 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000143890 | L17/scrutins | 17 | 17080000143833 | 17080000143889 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000144080 | L17/scrutins | 17 | 17080000144022 | 17080000144079 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000144276 | L17/scrutins | 17 | 17080000144217 | 17080000144275 | 1 | PA721908 | PM843467 | False | 402 | PSE |