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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000059408 | L17/scrutins | 17 | 17080000059235 | 17080000059407 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000059504 | L17/scrutins | 17 | 17080000059461 | 17080000059503 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000059617 | L17/scrutins | 17 | 17080000059461 | 17080000059616 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000059717 | L17/scrutins | 17 | 17080000059674 | 17080000059716 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000059829 | L17/scrutins | 17 | 17080000059674 | 17080000059828 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000059916 | L17/scrutins | 17 | 17080000059881 | 17080000059915 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000060021 | L17/scrutins | 17 | 17080000059881 | 17080000060020 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000060098 | L17/scrutins | 17 | 17080000060062 | 17080000060097 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000060199 | L17/scrutins | 17 | 17080000060062 | 17080000060198 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000060346 | L17/scrutins | 17 | 17080000060243 | 17080000060345 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000060825 | L17/scrutins | 17 | 17080000060758 | 17080000060824 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000060924 | L17/scrutins | 17 | 17080000060758 | 17080000060923 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080000060964 | L17/scrutins | 17 | 17080000060758 | 17080000060963 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080000061030 | L17/scrutins | 17 | 17080000060990 | 17080000061029 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000061083 | L17/scrutins | 17 | 17080000060990 | 17080000061082 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000061174 | L17/scrutins | 17 | 17080000061134 | 17080000061173 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000061228 | L17/scrutins | 17 | 17080000061134 | 17080000061227 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000061320 | L17/scrutins | 17 | 17080000061279 | 17080000061319 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000061377 | L17/scrutins | 17 | 17080000061279 | 17080000061376 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000061467 | L17/scrutins | 17 | 17080000061431 | 17080000061466 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000061524 | L17/scrutins | 17 | 17080000061431 | 17080000061523 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000061621 | L17/scrutins | 17 | 17080000061583 | 17080000061620 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000061680 | L17/scrutins | 17 | 17080000061583 | 17080000061679 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000061773 | L17/scrutins | 17 | 17080000061734 | 17080000061772 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000061826 | L17/scrutins | 17 | 17080000061734 | 17080000061825 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000061917 | L17/scrutins | 17 | 17080000061877 | 17080000061916 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000061971 | L17/scrutins | 17 | 17080000061877 | 17080000061970 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000062063 | L17/scrutins | 17 | 17080000062020 | 17080000062062 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000062118 | L17/scrutins | 17 | 17080000062020 | 17080000062117 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000062204 | L17/scrutins | 17 | 17080000062167 | 17080000062203 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000062255 | L17/scrutins | 17 | 17080000062167 | 17080000062254 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000062343 | L17/scrutins | 17 | 17080000062305 | 17080000062342 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000062401 | L17/scrutins | 17 | 17080000062305 | 17080000062400 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000062522 | L17/scrutins | 17 | 17080000062448 | 17080000062521 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000062628 | L17/scrutins | 17 | 17080000062448 | 17080000062627 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080000062667 | L17/scrutins | 17 | 17080000062448 | 17080000062666 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080000062758 | L17/scrutins | 17 | 17080000062698 | 17080000062757 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000062866 | L17/scrutins | 17 | 17080000062698 | 17080000062865 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000063022 | L17/scrutins | 17 | 17080000062966 | 17080000063021 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000063132 | L17/scrutins | 17 | 17080000062966 | 17080000063131 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000063290 | L17/scrutins | 17 | 17080000063229 | 17080000063289 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000063384 | L17/scrutins | 17 | 17080000063229 | 17080000063383 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000063501 | L17/scrutins | 17 | 17080000063478 | 17080000063500 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000063569 | L17/scrutins | 17 | 17080000063478 | 17080000063568 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000063662 | L17/scrutins | 17 | 17080000063629 | 17080000063661 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000063739 | L17/scrutins | 17 | 17080000063629 | 17080000063738 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000063822 | L17/scrutins | 17 | 17080000063792 | 17080000063821 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000063864 | L17/scrutins | 17 | 17080000063792 | 17080000063863 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000063949 | L17/scrutins | 17 | 17080000063919 | 17080000063948 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000064010 | L17/scrutins | 17 | 17080000063919 | 17080000064009 | 1 | PA794022 | PM842777 | False | 509 | PSE |