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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000224236 | L17/scrutins | 17 | 17080000224200 | 17080000224234 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000224353 | L17/scrutins | 17 | 17080000224318 | 17080000224352 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000224354 | L17/scrutins | 17 | 17080000224318 | 17080000224352 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000224477 | L17/scrutins | 17 | 17080000224441 | 17080000224476 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000224478 | L17/scrutins | 17 | 17080000224441 | 17080000224476 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000224616 | L17/scrutins | 17 | 17080000224565 | 17080000224615 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000224712 | L17/scrutins | 17 | 17080000224565 | 17080000224711 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000224759 | L17/scrutins | 17 | 17080000224729 | 17080000224758 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000224760 | L17/scrutins | 17 | 17080000224729 | 17080000224758 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000224890 | L17/scrutins | 17 | 17080000224857 | 17080000224889 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000224891 | L17/scrutins | 17 | 17080000224857 | 17080000224889 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000225025 | L17/scrutins | 17 | 17080000224992 | 17080000225024 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000225026 | L17/scrutins | 17 | 17080000224992 | 17080000225024 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000225167 | L17/scrutins | 17 | 17080000225131 | 17080000225166 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000225168 | L17/scrutins | 17 | 17080000225131 | 17080000225166 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000225320 | L17/scrutins | 17 | 17080000225284 | 17080000225319 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000225321 | L17/scrutins | 17 | 17080000225284 | 17080000225319 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000225473 | L17/scrutins | 17 | 17080000225438 | 17080000225472 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000225474 | L17/scrutins | 17 | 17080000225438 | 17080000225472 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000225629 | L17/scrutins | 17 | 17080000225593 | 17080000225628 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000225630 | L17/scrutins | 17 | 17080000225593 | 17080000225628 | 2 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000225797 | L17/scrutins | 17 | 17080000225753 | 17080000225796 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000225917 | L17/scrutins | 17 | 17080000225753 | 17080000225916 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000226027 | L17/scrutins | 17 | 17080000226003 | 17080000226026 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000226080 | L17/scrutins | 17 | 17080000226003 | 17080000226079 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000226156 | L17/scrutins | 17 | 17080000226124 | 17080000226155 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000226219 | L17/scrutins | 17 | 17080000226124 | 17080000226218 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000226316 | L17/scrutins | 17 | 17080000226267 | 17080000226315 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000226412 | L17/scrutins | 17 | 17080000226267 | 17080000226411 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000226468 | L17/scrutins | 17 | 17080000226429 | 17080000226467 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000226538 | L17/scrutins | 17 | 17080000226429 | 17080000226537 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000226636 | L17/scrutins | 17 | 17080000226594 | 17080000226635 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000226712 | L17/scrutins | 17 | 17080000226594 | 17080000226711 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000226817 | L17/scrutins | 17 | 17080000226775 | 17080000226816 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000226896 | L17/scrutins | 17 | 17080000226775 | 17080000226895 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000226993 | L17/scrutins | 17 | 17080000226963 | 17080000226992 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000227034 | L17/scrutins | 17 | 17080000226963 | 17080000227033 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000227124 | L17/scrutins | 17 | 17080000227088 | 17080000227123 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000227172 | L17/scrutins | 17 | 17080000227088 | 17080000227171 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000227265 | L17/scrutins | 17 | 17080000227228 | 17080000227264 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000227314 | L17/scrutins | 17 | 17080000227228 | 17080000227313 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000227406 | L17/scrutins | 17 | 17080000227375 | 17080000227405 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000227451 | L17/scrutins | 17 | 17080000227375 | 17080000227450 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000227540 | L17/scrutins | 17 | 17080000227511 | 17080000227539 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000227582 | L17/scrutins | 17 | 17080000227511 | 17080000227581 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000227665 | L17/scrutins | 17 | 17080000227635 | 17080000227664 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000227704 | L17/scrutins | 17 | 17080000227635 | 17080000227703 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000227780 | L17/scrutins | 17 | 17080000227751 | 17080000227779 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000227825 | L17/scrutins | 17 | 17080000227751 | 17080000227824 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000227926 | L17/scrutins | 17 | 17080000227877 | 17080000227925 | 1 | PA721908 | PM843467 | False | 402 | PAN |