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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000966935 | L17/scrutins | 17 | 17080000966923 | 17080000966933 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000966990 | L17/scrutins | 17 | 17080000966988 | 17080000966989 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000967000 | L17/scrutins | 17 | 17080000966988 | 17080000966999 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000967001 | L17/scrutins | 17 | 17080000966988 | 17080000966999 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000967053 | L17/scrutins | 17 | 17080000967051 | 17080000967052 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000967062 | L17/scrutins | 17 | 17080000967051 | 17080000967061 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000967063 | L17/scrutins | 17 | 17080000967051 | 17080000967061 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000967117 | L17/scrutins | 17 | 17080000967115 | 17080000967116 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000967129 | L17/scrutins | 17 | 17080000967115 | 17080000967128 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000967130 | L17/scrutins | 17 | 17080000967115 | 17080000967128 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000967182 | L17/scrutins | 17 | 17080000967180 | 17080000967181 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000967193 | L17/scrutins | 17 | 17080000967180 | 17080000967192 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000967194 | L17/scrutins | 17 | 17080000967180 | 17080000967192 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000967245 | L17/scrutins | 17 | 17080000967243 | 17080000967244 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000967255 | L17/scrutins | 17 | 17080000967243 | 17080000967254 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000967256 | L17/scrutins | 17 | 17080000967243 | 17080000967254 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000967309 | L17/scrutins | 17 | 17080000967307 | 17080000967308 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000967318 | L17/scrutins | 17 | 17080000967307 | 17080000967317 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000967319 | L17/scrutins | 17 | 17080000967307 | 17080000967317 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000967368 | L17/scrutins | 17 | 17080000967366 | 17080000967367 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000967380 | L17/scrutins | 17 | 17080000967366 | 17080000967379 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000967381 | L17/scrutins | 17 | 17080000967366 | 17080000967379 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000967440 | L17/scrutins | 17 | 17080000967438 | 17080000967439 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000967452 | L17/scrutins | 17 | 17080000967438 | 17080000967451 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000967453 | L17/scrutins | 17 | 17080000967438 | 17080000967451 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000967590 | L17/scrutins | 17 | 17080000967507 | 17080000967589 | 1 | PA607846 | PM843113 | False | 266 | MG |
| 17080000967591 | L17/scrutins | 17 | 17080000967507 | 17080000967589 | 2 | PA722046 | PM843482 | False | 270 | MG |
| 17080000967592 | L17/scrutins | 17 | 17080000967507 | 17080000967589 | 3 | PA717161 | PM842396 | False | 400 | MG |
| 17080000967593 | L17/scrutins | 17 | 17080000967507 | 17080000967589 | 4 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000967689 | L17/scrutins | 17 | 17080000967507 | 17080000967688 | 1 | PA608016 | PM843155 | False | 173 | MG |
| 17080000967690 | L17/scrutins | 17 | 17080000967507 | 17080000967688 | 2 | PA794038 | PM842783 | False | 186 | MG |
| 17080000967722 | L17/scrutins | 17 | 17080000967507 | 17080000967721 | 1 | PA605782 | PM842666 | False | 222 | MG |
| 17080000967750 | L17/scrutins | 17 | 17080000967748 | 17080000967749 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000967763 | L17/scrutins | 17 | 17080000967748 | 17080000967762 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000967764 | L17/scrutins | 17 | 17080000967748 | 17080000967762 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000967819 | L17/scrutins | 17 | 17080000967817 | 17080000967818 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000967830 | L17/scrutins | 17 | 17080000967817 | 17080000967829 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000967831 | L17/scrutins | 17 | 17080000967817 | 17080000967829 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000967881 | L17/scrutins | 17 | 17080000967879 | 17080000967880 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000967891 | L17/scrutins | 17 | 17080000967879 | 17080000967890 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000967892 | L17/scrutins | 17 | 17080000967879 | 17080000967890 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000967942 | L17/scrutins | 17 | 17080000967940 | 17080000967941 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000967952 | L17/scrutins | 17 | 17080000967940 | 17080000967951 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000967953 | L17/scrutins | 17 | 17080000967940 | 17080000967951 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000967994 | L17/scrutins | 17 | 17080000967992 | 17080000967993 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000968006 | L17/scrutins | 17 | 17080000967992 | 17080000968005 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000968007 | L17/scrutins | 17 | 17080000967992 | 17080000968005 | 2 | PA720066 | PM878039 | False | 304 | MG |
| 17080000968052 | L17/scrutins | 17 | 17080000968050 | 17080000968051 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080000968062 | L17/scrutins | 17 | 17080000968050 | 17080000968061 | 1 | PA721908 | PM843467 | False | 380 | PAN |
| 17080000968063 | L17/scrutins | 17 | 17080000968050 | 17080000968061 | 2 | PA720066 | PM878039 | False | 304 | MG |