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 411 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000682094 | L17/scrutins | 17 | 17080000682033 | 17080000682093 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000682241 | L17/scrutins | 17 | 17080000682033 | 17080000682240 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000682336 | L17/scrutins | 17 | 17080000682275 | 17080000682335 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000682482 | L17/scrutins | 17 | 17080000682275 | 17080000682481 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000682578 | L17/scrutins | 17 | 17080000682519 | 17080000682577 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000682725 | L17/scrutins | 17 | 17080000682519 | 17080000682724 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000682821 | L17/scrutins | 17 | 17080000682761 | 17080000682820 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000682968 | L17/scrutins | 17 | 17080000682761 | 17080000682967 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000683064 | L17/scrutins | 17 | 17080000683004 | 17080000683063 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000683213 | L17/scrutins | 17 | 17080000683004 | 17080000683212 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000683310 | L17/scrutins | 17 | 17080000683249 | 17080000683309 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000683461 | L17/scrutins | 17 | 17080000683249 | 17080000683460 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000683558 | L17/scrutins | 17 | 17080000683497 | 17080000683557 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000683709 | L17/scrutins | 17 | 17080000683497 | 17080000683708 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000683802 | L17/scrutins | 17 | 17080000683745 | 17080000683801 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000683950 | L17/scrutins | 17 | 17080000683745 | 17080000683949 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000684038 | L17/scrutins | 17 | 17080000683981 | 17080000684037 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000684185 | L17/scrutins | 17 | 17080000683981 | 17080000684184 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000684276 | L17/scrutins | 17 | 17080000684209 | 17080000684275 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000684302 | L17/scrutins | 17 | 17080000684209 | 17080000684301 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000684385 | L17/scrutins | 17 | 17080000684209 | 17080000684384 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080000684434 | L17/scrutins | 17 | 17080000684209 | 17080000684433 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080000684517 | L17/scrutins | 17 | 17080000684452 | 17080000684516 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000684534 | L17/scrutins | 17 | 17080000684452 | 17080000684533 | 1 | PA795228 | PM840447 | False | 627 | PSE |
| 17080000684687 | L17/scrutins | 17 | 17080000684634 | 17080000684686 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000684815 | L17/scrutins | 17 | 17080000684634 | 17080000684814 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000684893 | L17/scrutins | 17 | 17080000684841 | 17080000684892 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000685018 | L17/scrutins | 17 | 17080000684841 | 17080000685017 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000685099 | L17/scrutins | 17 | 17080000685044 | 17080000685098 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000685231 | L17/scrutins | 17 | 17080000685044 | 17080000685230 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000685314 | L17/scrutins | 17 | 17080000685258 | 17080000685313 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000685444 | L17/scrutins | 17 | 17080000685258 | 17080000685443 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000685528 | L17/scrutins | 17 | 17080000685471 | 17080000685527 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000685656 | L17/scrutins | 17 | 17080000685471 | 17080000685655 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000685740 | L17/scrutins | 17 | 17080000685683 | 17080000685739 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000685869 | L17/scrutins | 17 | 17080000685683 | 17080000685868 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000685954 | L17/scrutins | 17 | 17080000685896 | 17080000685953 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000686084 | L17/scrutins | 17 | 17080000685896 | 17080000686083 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000686169 | L17/scrutins | 17 | 17080000686111 | 17080000686168 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000686298 | L17/scrutins | 17 | 17080000686111 | 17080000686297 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000686384 | L17/scrutins | 17 | 17080000686325 | 17080000686383 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000686512 | L17/scrutins | 17 | 17080000686325 | 17080000686511 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000686597 | L17/scrutins | 17 | 17080000686539 | 17080000686596 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000686730 | L17/scrutins | 17 | 17080000686539 | 17080000686729 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000686822 | L17/scrutins | 17 | 17080000686757 | 17080000686821 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000686995 | L17/scrutins | 17 | 17080000686935 | 17080000686994 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000687127 | L17/scrutins | 17 | 17080000686935 | 17080000687126 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000687214 | L17/scrutins | 17 | 17080000687154 | 17080000687213 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000687346 | L17/scrutins | 17 | 17080000687154 | 17080000687345 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000687433 | L17/scrutins | 17 | 17080000687373 | 17080000687432 | 1 | PA721908 | PM843467 | False | 402 | PAN |