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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080001049787 | L17/scrutins | 17 | 17080001049691 | 17080001049786 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001049844 | L17/scrutins | 17 | 17080001049809 | 17080001049843 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001049905 | L17/scrutins | 17 | 17080001049809 | 17080001049904 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001049956 | L17/scrutins | 17 | 17080001049926 | 17080001049955 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001050011 | L17/scrutins | 17 | 17080001049926 | 17080001050010 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001050057 | L17/scrutins | 17 | 17080001050028 | 17080001050056 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001050094 | L17/scrutins | 17 | 17080001050028 | 17080001050093 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080001050140 | L17/scrutins | 17 | 17080001050121 | 17080001050139 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001050159 | L17/scrutins | 17 | 17080001050121 | 17080001050158 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001050193 | L17/scrutins | 17 | 17080001050168 | 17080001050192 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001050221 | L17/scrutins | 17 | 17080001050168 | 17080001050220 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001050258 | L17/scrutins | 17 | 17080001050230 | 17080001050257 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001050293 | L17/scrutins | 17 | 17080001050230 | 17080001050292 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001050335 | L17/scrutins | 17 | 17080001050305 | 17080001050334 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001050369 | L17/scrutins | 17 | 17080001050305 | 17080001050368 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001050414 | L17/scrutins | 17 | 17080001050384 | 17080001050413 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001050448 | L17/scrutins | 17 | 17080001050384 | 17080001050447 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001050501 | L17/scrutins | 17 | 17080001050465 | 17080001050500 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001050542 | L17/scrutins | 17 | 17080001050465 | 17080001050541 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001050602 | L17/scrutins | 17 | 17080001050563 | 17080001050601 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001050663 | L17/scrutins | 17 | 17080001050563 | 17080001050662 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001050728 | L17/scrutins | 17 | 17080001050689 | 17080001050727 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001050785 | L17/scrutins | 17 | 17080001050689 | 17080001050784 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001050851 | L17/scrutins | 17 | 17080001050812 | 17080001050850 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001050910 | L17/scrutins | 17 | 17080001050812 | 17080001050909 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001050977 | L17/scrutins | 17 | 17080001050937 | 17080001050976 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001051038 | L17/scrutins | 17 | 17080001050937 | 17080001051037 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001051098 | L17/scrutins | 17 | 17080001051066 | 17080001051097 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001051142 | L17/scrutins | 17 | 17080001051066 | 17080001051141 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080001051214 | L17/scrutins | 17 | 17080001051175 | 17080001051213 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001051276 | L17/scrutins | 17 | 17080001051175 | 17080001051275 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001051346 | L17/scrutins | 17 | 17080001051306 | 17080001051345 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001051410 | L17/scrutins | 17 | 17080001051306 | 17080001051409 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001051479 | L17/scrutins | 17 | 17080001051440 | 17080001051478 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001051544 | L17/scrutins | 17 | 17080001051440 | 17080001051543 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001051615 | L17/scrutins | 17 | 17080001051574 | 17080001051614 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001051674 | L17/scrutins | 17 | 17080001051574 | 17080001051673 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001051747 | L17/scrutins | 17 | 17080001051708 | 17080001051746 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001051806 | L17/scrutins | 17 | 17080001051708 | 17080001051805 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001051876 | L17/scrutins | 17 | 17080001051837 | 17080001051875 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001051938 | L17/scrutins | 17 | 17080001051837 | 17080001051937 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001052007 | L17/scrutins | 17 | 17080001051969 | 17080001052006 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001052072 | L17/scrutins | 17 | 17080001051969 | 17080001052071 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001052142 | L17/scrutins | 17 | 17080001052103 | 17080001052141 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001052214 | L17/scrutins | 17 | 17080001052103 | 17080001052213 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001052284 | L17/scrutins | 17 | 17080001052245 | 17080001052283 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001052362 | L17/scrutins | 17 | 17080001052245 | 17080001052361 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001052434 | L17/scrutins | 17 | 17080001052395 | 17080001052433 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001052511 | L17/scrutins | 17 | 17080001052395 | 17080001052510 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001052575 | L17/scrutins | 17 | 17080001052544 | 17080001052574 | 1 | PA721908 | PM843467 | False | 402 | PAN |