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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000311676 | L17/scrutins | 17 | 17080000311648 | 17080000311675 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000311740 | L17/scrutins | 17 | 17080000311711 | 17080000311739 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000311744 | L17/scrutins | 17 | 17080000311711 | 17080000311743 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000311802 | L17/scrutins | 17 | 17080000311775 | 17080000311801 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000311864 | L17/scrutins | 17 | 17080000311838 | 17080000311863 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000311989 | L17/scrutins | 17 | 17080000311903 | 17080000311988 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000312095 | L17/scrutins | 17 | 17080000311903 | 17080000312094 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000312188 | L17/scrutins | 17 | 17080000312162 | 17080000312187 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000312254 | L17/scrutins | 17 | 17080000312226 | 17080000312253 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000312321 | L17/scrutins | 17 | 17080000312293 | 17080000312320 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000312385 | L17/scrutins | 17 | 17080000312359 | 17080000312384 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000312389 | L17/scrutins | 17 | 17080000312359 | 17080000312388 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000312449 | L17/scrutins | 17 | 17080000312421 | 17080000312448 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000312453 | L17/scrutins | 17 | 17080000312421 | 17080000312452 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000312511 | L17/scrutins | 17 | 17080000312483 | 17080000312510 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000312515 | L17/scrutins | 17 | 17080000312483 | 17080000312514 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000312576 | L17/scrutins | 17 | 17080000312548 | 17080000312575 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000312580 | L17/scrutins | 17 | 17080000312548 | 17080000312579 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000312640 | L17/scrutins | 17 | 17080000312612 | 17080000312639 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000312644 | L17/scrutins | 17 | 17080000312612 | 17080000312643 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000312708 | L17/scrutins | 17 | 17080000312679 | 17080000312707 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000312712 | L17/scrutins | 17 | 17080000312679 | 17080000312711 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000312771 | L17/scrutins | 17 | 17080000312742 | 17080000312770 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000312775 | L17/scrutins | 17 | 17080000312742 | 17080000312774 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000312889 | L17/scrutins | 17 | 17080000312808 | 17080000312888 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000312958 | L17/scrutins | 17 | 17080000312808 | 17080000312957 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000313039 | L17/scrutins | 17 | 17080000313010 | 17080000313038 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000313043 | L17/scrutins | 17 | 17080000313010 | 17080000313042 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000313108 | L17/scrutins | 17 | 17080000313079 | 17080000313107 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000313112 | L17/scrutins | 17 | 17080000313079 | 17080000313111 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000313172 | L17/scrutins | 17 | 17080000313143 | 17080000313171 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000313176 | L17/scrutins | 17 | 17080000313143 | 17080000313175 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000313228 | L17/scrutins | 17 | 17080000313209 | 17080000313227 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000314480 | L17/scrutins | 17 | 17080000314477 | 17080000314479 | 1 | PA721908 | PM843467 | False | 402 | PSE |
| 17080000314739 | L17/scrutins | 17 | 17080000314680 | 17080000314738 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000314851 | L17/scrutins | 17 | 17080000314680 | 17080000314850 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000314947 | L17/scrutins | 17 | 17080000314914 | 17080000314946 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000315014 | L17/scrutins | 17 | 17080000314914 | 17080000315013 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000315106 | L17/scrutins | 17 | 17080000315041 | 17080000315105 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000315353 | L17/scrutins | 17 | 17080000315281 | 17080000315352 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000315431 | L17/scrutins | 17 | 17080000315281 | 17080000315430 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000315596 | L17/scrutins | 17 | 17080000315476 | 17080000315595 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000315992 | L17/scrutins | 17 | 17080000315953 | 17080000315991 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000316121 | L17/scrutins | 17 | 17080000316083 | 17080000316120 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000316253 | L17/scrutins | 17 | 17080000316212 | 17080000316252 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000316396 | L17/scrutins | 17 | 17080000316356 | 17080000316395 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000316536 | L17/scrutins | 17 | 17080000316498 | 17080000316535 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000316679 | L17/scrutins | 17 | 17080000316641 | 17080000316678 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000316820 | L17/scrutins | 17 | 17080000316782 | 17080000316819 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000316961 | L17/scrutins | 17 | 17080000316923 | 17080000316960 | 1 | PA721908 | PM843467 | False | 402 | PAN |