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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080001002833 | L17/scrutins | 17 | 17080001002781 | 17080001002832 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001002931 | L17/scrutins | 17 | 17080001002781 | 17080001002930 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001003024 | L17/scrutins | 17 | 17080001002957 | 17080001003023 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001003176 | L17/scrutins | 17 | 17080001002957 | 17080001003175 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001003232 | L17/scrutins | 17 | 17080001003215 | 17080001003231 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001003265 | L17/scrutins | 17 | 17080001003215 | 17080001003264 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001003294 | L17/scrutins | 17 | 17080001003276 | 17080001003293 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001003332 | L17/scrutins | 17 | 17080001003276 | 17080001003331 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001003365 | L17/scrutins | 17 | 17080001003344 | 17080001003364 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001003415 | L17/scrutins | 17 | 17080001003344 | 17080001003414 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001003454 | L17/scrutins | 17 | 17080001003433 | 17080001003453 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001003504 | L17/scrutins | 17 | 17080001003433 | 17080001003503 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001003547 | L17/scrutins | 17 | 17080001003522 | 17080001003546 | 1 | PA607846 | PM843113 | False | 266 | MG |
| 17080001003548 | L17/scrutins | 17 | 17080001003522 | 17080001003546 | 2 | PA722046 | PM843482 | False | 270 | MG |
| 17080001003549 | L17/scrutins | 17 | 17080001003522 | 17080001003546 | 3 | PA717161 | PM842396 | False | 400 | MG |
| 17080001003550 | L17/scrutins | 17 | 17080001003522 | 17080001003546 | 4 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001003648 | L17/scrutins | 17 | 17080001003522 | 17080001003647 | 1 | PA608016 | PM843155 | False | 173 | MG |
| 17080001003649 | L17/scrutins | 17 | 17080001003522 | 17080001003647 | 2 | PA794038 | PM842783 | False | 186 | MG |
| 17080001003681 | L17/scrutins | 17 | 17080001003522 | 17080001003680 | 1 | PA605782 | PM842666 | False | 222 | MG |
| 17080001003721 | L17/scrutins | 17 | 17080001003700 | 17080001003720 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001003771 | L17/scrutins | 17 | 17080001003700 | 17080001003770 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001003810 | L17/scrutins | 17 | 17080001003789 | 17080001003809 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001003860 | L17/scrutins | 17 | 17080001003789 | 17080001003859 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001003900 | L17/scrutins | 17 | 17080001003880 | 17080001003899 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001003953 | L17/scrutins | 17 | 17080001003880 | 17080001003952 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001003991 | L17/scrutins | 17 | 17080001003968 | 17080001003990 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001004043 | L17/scrutins | 17 | 17080001003968 | 17080001004042 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001004086 | L17/scrutins | 17 | 17080001004063 | 17080001004085 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001004138 | L17/scrutins | 17 | 17080001004063 | 17080001004137 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001004180 | L17/scrutins | 17 | 17080001004156 | 17080001004179 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001004231 | L17/scrutins | 17 | 17080001004156 | 17080001004230 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001004277 | L17/scrutins | 17 | 17080001004253 | 17080001004276 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001004329 | L17/scrutins | 17 | 17080001004253 | 17080001004328 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001004377 | L17/scrutins | 17 | 17080001004349 | 17080001004376 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001004426 | L17/scrutins | 17 | 17080001004349 | 17080001004425 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001004477 | L17/scrutins | 17 | 17080001004449 | 17080001004476 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001004531 | L17/scrutins | 17 | 17080001004449 | 17080001004530 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001004583 | L17/scrutins | 17 | 17080001004554 | 17080001004582 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001004640 | L17/scrutins | 17 | 17080001004554 | 17080001004639 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001004692 | L17/scrutins | 17 | 17080001004665 | 17080001004691 | 1 | PA607846 | PM843113 | False | 266 | MG |
| 17080001004693 | L17/scrutins | 17 | 17080001004665 | 17080001004691 | 2 | PA722046 | PM843482 | False | 270 | MG |
| 17080001004694 | L17/scrutins | 17 | 17080001004665 | 17080001004691 | 3 | PA717161 | PM842396 | False | 400 | MG |
| 17080001004695 | L17/scrutins | 17 | 17080001004665 | 17080001004691 | 4 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001004802 | L17/scrutins | 17 | 17080001004665 | 17080001004801 | 1 | PA608016 | PM843155 | False | 173 | MG |
| 17080001004803 | L17/scrutins | 17 | 17080001004665 | 17080001004801 | 2 | PA794038 | PM842783 | False | 186 | MG |
| 17080001004841 | L17/scrutins | 17 | 17080001004665 | 17080001004840 | 1 | PA605782 | PM842666 | False | 222 | MG |
| 17080001004888 | L17/scrutins | 17 | 17080001004858 | 17080001004887 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001004946 | L17/scrutins | 17 | 17080001004858 | 17080001004945 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001005005 | L17/scrutins | 17 | 17080001004974 | 17080001005004 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001005073 | L17/scrutins | 17 | 17080001004974 | 17080001005072 | 1 | PA795270 | PM858399 | False | 217 | PSE |