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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000154624 | L17/scrutins | 17 | 17080000154549 | 17080000154623 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000154895 | L17/scrutins | 17 | 17080000154822 | 17080000154894 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000155155 | L17/scrutins | 17 | 17080000155077 | 17080000155154 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000155406 | L17/scrutins | 17 | 17080000155336 | 17080000155405 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000155510 | L17/scrutins | 17 | 17080000155336 | 17080000155509 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000155656 | L17/scrutins | 17 | 17080000155584 | 17080000155655 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000155910 | L17/scrutins | 17 | 17080000155843 | 17080000155909 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000156166 | L17/scrutins | 17 | 17080000156097 | 17080000156165 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000156429 | L17/scrutins | 17 | 17080000156358 | 17080000156428 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000156700 | L17/scrutins | 17 | 17080000156620 | 17080000156699 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000156985 | L17/scrutins | 17 | 17080000156905 | 17080000156984 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000157268 | L17/scrutins | 17 | 17080000157189 | 17080000157267 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000157549 | L17/scrutins | 17 | 17080000157475 | 17080000157548 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000157832 | L17/scrutins | 17 | 17080000157752 | 17080000157831 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000157869 | L17/scrutins | 17 | 17080000157752 | 17080000157868 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000158121 | L17/scrutins | 17 | 17080000158045 | 17080000158120 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000158393 | L17/scrutins | 17 | 17080000158343 | 17080000158392 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000158423 | L17/scrutins | 17 | 17080000158343 | 17080000158422 | 1 | PA795228 | PM840447 | False | 627 | PSE |
| 17080000158477 | L17/scrutins | 17 | 17080000158343 | 17080000158476 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080000158507 | L17/scrutins | 17 | 17080000158343 | 17080000158506 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080000158607 | L17/scrutins | 17 | 17080000158531 | 17080000158606 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000158704 | L17/scrutins | 17 | 17080000158531 | 17080000158703 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000158847 | L17/scrutins | 17 | 17080000158770 | 17080000158846 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000159142 | L17/scrutins | 17 | 17080000159067 | 17080000159141 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000159179 | L17/scrutins | 17 | 17080000159067 | 17080000159178 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000159414 | L17/scrutins | 17 | 17080000159350 | 17080000159413 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000159689 | L17/scrutins | 17 | 17080000159628 | 17080000159688 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000159956 | L17/scrutins | 17 | 17080000159903 | 17080000159955 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000160176 | L17/scrutins | 17 | 17080000160124 | 17080000160175 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000160388 | L17/scrutins | 17 | 17080000160340 | 17080000160387 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000160581 | L17/scrutins | 17 | 17080000160546 | 17080000160580 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000160631 | L17/scrutins | 17 | 17080000160546 | 17080000160630 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000160707 | L17/scrutins | 17 | 17080000160665 | 17080000160706 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000160755 | L17/scrutins | 17 | 17080000160665 | 17080000160754 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000160847 | L17/scrutins | 17 | 17080000160791 | 17080000160846 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000160942 | L17/scrutins | 17 | 17080000160791 | 17080000160941 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000161044 | L17/scrutins | 17 | 17080000160998 | 17080000161043 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000161143 | L17/scrutins | 17 | 17080000160998 | 17080000161142 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000161248 | L17/scrutins | 17 | 17080000161204 | 17080000161247 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000161332 | L17/scrutins | 17 | 17080000161204 | 17080000161331 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000161426 | L17/scrutins | 17 | 17080000161376 | 17080000161425 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000161510 | L17/scrutins | 17 | 17080000161376 | 17080000161509 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000161611 | L17/scrutins | 17 | 17080000161559 | 17080000161610 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000161690 | L17/scrutins | 17 | 17080000161559 | 17080000161689 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000161787 | L17/scrutins | 17 | 17080000161739 | 17080000161786 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000161873 | L17/scrutins | 17 | 17080000161739 | 17080000161872 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000161971 | L17/scrutins | 17 | 17080000161921 | 17080000161970 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000162057 | L17/scrutins | 17 | 17080000161921 | 17080000162056 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000162149 | L17/scrutins | 17 | 17080000162107 | 17080000162148 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000162232 | L17/scrutins | 17 | 17080000162107 | 17080000162231 | 1 | PA794022 | PM842777 | False | 509 | PSE |