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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000850815 | L17/scrutins | 17 | 17080000850813 | 17080000850814 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000850870 | L17/scrutins | 17 | 17080000850813 | 17080000850869 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000850993 | L17/scrutins | 17 | 17080000850952 | 17080000850992 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000851061 | L17/scrutins | 17 | 17080000850952 | 17080000851060 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000851116 | L17/scrutins | 17 | 17080000851114 | 17080000851115 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000851183 | L17/scrutins | 17 | 17080000851114 | 17080000851182 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000851357 | L17/scrutins | 17 | 17080000851355 | 17080000851356 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000851429 | L17/scrutins | 17 | 17080000851355 | 17080000851428 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000851614 | L17/scrutins | 17 | 17080000851612 | 17080000851613 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000851672 | L17/scrutins | 17 | 17080000851612 | 17080000851671 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000851805 | L17/scrutins | 17 | 17080000851803 | 17080000851804 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000851842 | L17/scrutins | 17 | 17080000851803 | 17080000851841 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000851975 | L17/scrutins | 17 | 17080000851973 | 17080000851974 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000852044 | L17/scrutins | 17 | 17080000851973 | 17080000852043 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000852237 | L17/scrutins | 17 | 17080000852235 | 17080000852236 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000852308 | L17/scrutins | 17 | 17080000852235 | 17080000852307 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000852503 | L17/scrutins | 17 | 17080000852501 | 17080000852502 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000852568 | L17/scrutins | 17 | 17080000852501 | 17080000852567 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000852769 | L17/scrutins | 17 | 17080000852767 | 17080000852768 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000852834 | L17/scrutins | 17 | 17080000852767 | 17080000852833 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000853042 | L17/scrutins | 17 | 17080000853040 | 17080000853041 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000853107 | L17/scrutins | 17 | 17080000853040 | 17080000853106 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000853311 | L17/scrutins | 17 | 17080000853309 | 17080000853310 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000853377 | L17/scrutins | 17 | 17080000853309 | 17080000853376 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000853658 | L17/scrutins | 17 | 17080000853577 | 17080000853657 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000853684 | L17/scrutins | 17 | 17080000853577 | 17080000853683 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000853754 | L17/scrutins | 17 | 17080000853577 | 17080000853753 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080000853795 | L17/scrutins | 17 | 17080000853577 | 17080000853794 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080000853861 | L17/scrutins | 17 | 17080000853818 | 17080000853860 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000853931 | L17/scrutins | 17 | 17080000853818 | 17080000853930 | 1 | PA794022 | PM842777 | False | 509 | PSE |
| 17080000853984 | L17/scrutins | 17 | 17080000853982 | 17080000853983 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000854051 | L17/scrutins | 17 | 17080000853982 | 17080000854050 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000854256 | L17/scrutins | 17 | 17080000854254 | 17080000854255 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000854322 | L17/scrutins | 17 | 17080000854254 | 17080000854321 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000854520 | L17/scrutins | 17 | 17080000854518 | 17080000854519 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000854587 | L17/scrutins | 17 | 17080000854518 | 17080000854586 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000854784 | L17/scrutins | 17 | 17080000854782 | 17080000854783 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000854847 | L17/scrutins | 17 | 17080000854782 | 17080000854846 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000855035 | L17/scrutins | 17 | 17080000855033 | 17080000855034 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000855093 | L17/scrutins | 17 | 17080000855033 | 17080000855092 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000855248 | L17/scrutins | 17 | 17080000855246 | 17080000855247 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000855309 | L17/scrutins | 17 | 17080000855246 | 17080000855308 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000855479 | L17/scrutins | 17 | 17080000855477 | 17080000855478 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000855546 | L17/scrutins | 17 | 17080000855477 | 17080000855545 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000855808 | L17/scrutins | 17 | 17080000855751 | 17080000855807 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000855993 | L17/scrutins | 17 | 17080000855991 | 17080000855992 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000856050 | L17/scrutins | 17 | 17080000855991 | 17080000856049 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000856168 | L17/scrutins | 17 | 17080000856166 | 17080000856167 | 1 | PA720468 | PM840333 | False | 028 | PSE |
| 17080000856225 | L17/scrutins | 17 | 17080000856166 | 17080000856224 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000856376 | L17/scrutins | 17 | 17080000856332 | 17080000856375 | 1 | PA721908 | PM843467 | False | 402 | PAN |