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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000281318 | L17/scrutins | 17 | 17080000281248 | 17080000281317 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000281440 | L17/scrutins | 17 | 17080000281424 | 17080000281439 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000281460 | L17/scrutins | 17 | 17080000281424 | 17080000281459 | 1 | PA795228 | PM840447 | False | 627 | PSE |
| 17080000281547 | L17/scrutins | 17 | 17080000281510 | 17080000281546 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000281548 | L17/scrutins | 17 | 17080000281510 | 17080000281546 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000281655 | L17/scrutins | 17 | 17080000281620 | 17080000281654 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000281656 | L17/scrutins | 17 | 17080000281620 | 17080000281654 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000281761 | L17/scrutins | 17 | 17080000281727 | 17080000281760 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000281762 | L17/scrutins | 17 | 17080000281727 | 17080000281760 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000281866 | L17/scrutins | 17 | 17080000281831 | 17080000281865 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000281867 | L17/scrutins | 17 | 17080000281831 | 17080000281865 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000281974 | L17/scrutins | 17 | 17080000281937 | 17080000281973 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000281975 | L17/scrutins | 17 | 17080000281937 | 17080000281973 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000282123 | L17/scrutins | 17 | 17080000282043 | 17080000282122 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000282399 | L17/scrutins | 17 | 17080000282361 | 17080000282398 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000282400 | L17/scrutins | 17 | 17080000282361 | 17080000282398 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000282504 | L17/scrutins | 17 | 17080000282466 | 17080000282503 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000282505 | L17/scrutins | 17 | 17080000282466 | 17080000282503 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000282617 | L17/scrutins | 17 | 17080000282576 | 17080000282616 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000282618 | L17/scrutins | 17 | 17080000282576 | 17080000282616 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000282723 | L17/scrutins | 17 | 17080000282686 | 17080000282722 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000282724 | L17/scrutins | 17 | 17080000282686 | 17080000282722 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000282835 | L17/scrutins | 17 | 17080000282800 | 17080000282834 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000282836 | L17/scrutins | 17 | 17080000282800 | 17080000282834 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000282945 | L17/scrutins | 17 | 17080000282907 | 17080000282944 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000282946 | L17/scrutins | 17 | 17080000282907 | 17080000282944 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000283061 | L17/scrutins | 17 | 17080000283022 | 17080000283060 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000283062 | L17/scrutins | 17 | 17080000283022 | 17080000283060 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000283178 | L17/scrutins | 17 | 17080000283138 | 17080000283177 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000283179 | L17/scrutins | 17 | 17080000283138 | 17080000283177 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000283292 | L17/scrutins | 17 | 17080000283253 | 17080000283291 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000283293 | L17/scrutins | 17 | 17080000283253 | 17080000283291 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000283410 | L17/scrutins | 17 | 17080000283372 | 17080000283409 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000283411 | L17/scrutins | 17 | 17080000283372 | 17080000283409 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000283565 | L17/scrutins | 17 | 17080000283485 | 17080000283564 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000283840 | L17/scrutins | 17 | 17080000283802 | 17080000283839 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000283841 | L17/scrutins | 17 | 17080000283802 | 17080000283839 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000283953 | L17/scrutins | 17 | 17080000283917 | 17080000283952 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000283954 | L17/scrutins | 17 | 17080000283917 | 17080000283952 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000284065 | L17/scrutins | 17 | 17080000284029 | 17080000284064 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000284066 | L17/scrutins | 17 | 17080000284029 | 17080000284064 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000284266 | L17/scrutins | 17 | 17080000284141 | 17080000284265 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000284768 | L17/scrutins | 17 | 17080000284721 | 17080000284767 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000284841 | L17/scrutins | 17 | 17080000284721 | 17080000284840 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000284911 | L17/scrutins | 17 | 17080000284861 | 17080000284910 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000284990 | L17/scrutins | 17 | 17080000284861 | 17080000284989 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000285068 | L17/scrutins | 17 | 17080000285011 | 17080000285067 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000285147 | L17/scrutins | 17 | 17080000285011 | 17080000285146 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000285231 | L17/scrutins | 17 | 17080000285174 | 17080000285230 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000285309 | L17/scrutins | 17 | 17080000285174 | 17080000285308 | 1 | PA720908 | PM843701 | False | 221 | PSE |