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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000317097 | L17/scrutins | 17 | 17080000317059 | 17080000317096 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000317252 | L17/scrutins | 17 | 17080000317197 | 17080000317251 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000317374 | L17/scrutins | 17 | 17080000317197 | 17080000317373 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000317468 | L17/scrutins | 17 | 17080000317435 | 17080000317467 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000317596 | L17/scrutins | 17 | 17080000317563 | 17080000317595 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000317731 | L17/scrutins | 17 | 17080000317697 | 17080000317730 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000317874 | L17/scrutins | 17 | 17080000317838 | 17080000317873 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000318010 | L17/scrutins | 17 | 17080000317974 | 17080000318009 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000318136 | L17/scrutins | 17 | 17080000318100 | 17080000318135 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000318261 | L17/scrutins | 17 | 17080000318227 | 17080000318260 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000318276 | L17/scrutins | 17 | 17080000318227 | 17080000318275 | 1 | PA795228 | PM840447 | False | 627 | PSE |
| 17080000318399 | L17/scrutins | 17 | 17080000318364 | 17080000318398 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000318415 | L17/scrutins | 17 | 17080000318364 | 17080000318414 | 1 | PA795228 | PM840447 | False | 627 | PSE |
| 17080000318526 | L17/scrutins | 17 | 17080000318492 | 17080000318525 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000318542 | L17/scrutins | 17 | 17080000318492 | 17080000318541 | 1 | PA795228 | PM840447 | False | 627 | PSE |
| 17080000318655 | L17/scrutins | 17 | 17080000318620 | 17080000318654 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000318818 | L17/scrutins | 17 | 17080000318746 | 17080000318817 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000318834 | L17/scrutins | 17 | 17080000318746 | 17080000318833 | 1 | PA795228 | PM840447 | False | 627 | PSE |
| 17080000318875 | L17/scrutins | 17 | 17080000318746 | 17080000318874 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080000318905 | L17/scrutins | 17 | 17080000318746 | 17080000318904 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080000318979 | L17/scrutins | 17 | 17080000318930 | 17080000318978 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000319051 | L17/scrutins | 17 | 17080000318930 | 17080000319050 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000319105 | L17/scrutins | 17 | 17080000319092 | 17080000319104 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000319187 | L17/scrutins | 17 | 17080000319166 | 17080000319186 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000319216 | L17/scrutins | 17 | 17080000319166 | 17080000319215 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000319252 | L17/scrutins | 17 | 17080000319231 | 17080000319251 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000319289 | L17/scrutins | 17 | 17080000319231 | 17080000319288 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000319323 | L17/scrutins | 17 | 17080000319302 | 17080000319322 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000319361 | L17/scrutins | 17 | 17080000319302 | 17080000319360 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000319399 | L17/scrutins | 17 | 17080000319376 | 17080000319398 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000319440 | L17/scrutins | 17 | 17080000319376 | 17080000319439 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000319475 | L17/scrutins | 17 | 17080000319456 | 17080000319474 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000319519 | L17/scrutins | 17 | 17080000319456 | 17080000319518 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000319555 | L17/scrutins | 17 | 17080000319534 | 17080000319554 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000319599 | L17/scrutins | 17 | 17080000319534 | 17080000319598 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000319638 | L17/scrutins | 17 | 17080000319614 | 17080000319637 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000319682 | L17/scrutins | 17 | 17080000319614 | 17080000319681 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000319717 | L17/scrutins | 17 | 17080000319697 | 17080000319716 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000319790 | L17/scrutins | 17 | 17080000319771 | 17080000319789 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000319832 | L17/scrutins | 17 | 17080000319771 | 17080000319831 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000319912 | L17/scrutins | 17 | 17080000319848 | 17080000319911 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000319981 | L17/scrutins | 17 | 17080000319848 | 17080000319980 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000320050 | L17/scrutins | 17 | 17080000320031 | 17080000320049 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000320133 | L17/scrutins | 17 | 17080000320112 | 17080000320132 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000320185 | L17/scrutins | 17 | 17080000320112 | 17080000320184 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000320227 | L17/scrutins | 17 | 17080000320206 | 17080000320226 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000320271 | L17/scrutins | 17 | 17080000320206 | 17080000320270 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000320311 | L17/scrutins | 17 | 17080000320289 | 17080000320310 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000320354 | L17/scrutins | 17 | 17080000320289 | 17080000320353 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000320394 | L17/scrutins | 17 | 17080000320372 | 17080000320393 | 1 | PA721908 | PM843467 | False | 402 | PAN |