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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000185456 | L17/scrutins | 17 | 17080000185354 | 17080000185455 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000185547 | L17/scrutins | 17 | 17080000185505 | 17080000185546 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000185607 | L17/scrutins | 17 | 17080000185505 | 17080000185606 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000185675 | L17/scrutins | 17 | 17080000185655 | 17080000185674 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000185727 | L17/scrutins | 17 | 17080000185655 | 17080000185726 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000185789 | L17/scrutins | 17 | 17080000185766 | 17080000185788 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000185842 | L17/scrutins | 17 | 17080000185766 | 17080000185841 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000185912 | L17/scrutins | 17 | 17080000185885 | 17080000185911 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000185969 | L17/scrutins | 17 | 17080000185885 | 17080000185968 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000186042 | L17/scrutins | 17 | 17080000186016 | 17080000186041 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000186098 | L17/scrutins | 17 | 17080000186016 | 17080000186097 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000186181 | L17/scrutins | 17 | 17080000186147 | 17080000186180 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000186235 | L17/scrutins | 17 | 17080000186147 | 17080000186234 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000186309 | L17/scrutins | 17 | 17080000186276 | 17080000186308 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000186363 | L17/scrutins | 17 | 17080000186276 | 17080000186362 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000186461 | L17/scrutins | 17 | 17080000186404 | 17080000186460 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000186543 | L17/scrutins | 17 | 17080000186404 | 17080000186542 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000186633 | L17/scrutins | 17 | 17080000186600 | 17080000186632 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000186688 | L17/scrutins | 17 | 17080000186600 | 17080000186687 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000186762 | L17/scrutins | 17 | 17080000186730 | 17080000186761 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000186817 | L17/scrutins | 17 | 17080000186730 | 17080000186816 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000186893 | L17/scrutins | 17 | 17080000186857 | 17080000186892 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000186947 | L17/scrutins | 17 | 17080000186857 | 17080000186946 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000187027 | L17/scrutins | 17 | 17080000186990 | 17080000187026 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000187077 | L17/scrutins | 17 | 17080000186990 | 17080000187076 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000187158 | L17/scrutins | 17 | 17080000187121 | 17080000187157 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000187211 | L17/scrutins | 17 | 17080000187121 | 17080000187210 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000187283 | L17/scrutins | 17 | 17080000187255 | 17080000187282 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000187337 | L17/scrutins | 17 | 17080000187255 | 17080000187336 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000187404 | L17/scrutins | 17 | 17080000187375 | 17080000187403 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000187456 | L17/scrutins | 17 | 17080000187375 | 17080000187455 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000187527 | L17/scrutins | 17 | 17080000187495 | 17080000187526 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000187580 | L17/scrutins | 17 | 17080000187495 | 17080000187579 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000187646 | L17/scrutins | 17 | 17080000187620 | 17080000187645 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000187698 | L17/scrutins | 17 | 17080000187620 | 17080000187697 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000187768 | L17/scrutins | 17 | 17080000187734 | 17080000187767 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000187826 | L17/scrutins | 17 | 17080000187734 | 17080000187825 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000187947 | L17/scrutins | 17 | 17080000187867 | 17080000187946 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000188059 | L17/scrutins | 17 | 17080000187867 | 17080000188058 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000188162 | L17/scrutins | 17 | 17080000188128 | 17080000188161 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000188220 | L17/scrutins | 17 | 17080000188128 | 17080000188219 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000188289 | L17/scrutins | 17 | 17080000188261 | 17080000188288 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000188397 | L17/scrutins | 17 | 17080000188364 | 17080000188396 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000188513 | L17/scrutins | 17 | 17080000188473 | 17080000188512 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000188659 | L17/scrutins | 17 | 17080000188621 | 17080000188658 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000188804 | L17/scrutins | 17 | 17080000188764 | 17080000188803 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000188951 | L17/scrutins | 17 | 17080000188911 | 17080000188950 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000189097 | L17/scrutins | 17 | 17080000189065 | 17080000189096 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000189110 | L17/scrutins | 17 | 17080000189065 | 17080000189109 | 1 | PA795228 | PM840447 | False | 627 | PSE |
| 17080000189227 | L17/scrutins | 17 | 17080000189194 | 17080000189226 | 1 | PA721908 | PM843467 | False | 402 | PAN |