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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080001291248 | L17/scrutins | 17 | 17080001291059 | 17080001291247 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080001291295 | L17/scrutins | 17 | 17080001291059 | 17080001291294 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080001291296 | L17/scrutins | 17 | 17080001291059 | 17080001291294 | 2 | PA720480 | PM843101 | False | 245 | MG |
| 17080001291400 | L17/scrutins | 17 | 17080001291320 | 17080001291399 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001291477 | L17/scrutins | 17 | 17080001291320 | 17080001291476 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080001291511 | L17/scrutins | 17 | 17080001291320 | 17080001291510 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080001291571 | L17/scrutins | 17 | 17080001291538 | 17080001291570 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001291614 | L17/scrutins | 17 | 17080001291538 | 17080001291613 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080001291679 | L17/scrutins | 17 | 17080001291677 | 17080001291678 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001291732 | L17/scrutins | 17 | 17080001291677 | 17080001291731 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001291916 | L17/scrutins | 17 | 17080001291914 | 17080001291915 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001291969 | L17/scrutins | 17 | 17080001291914 | 17080001291968 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001292153 | L17/scrutins | 17 | 17080001292151 | 17080001292152 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001292205 | L17/scrutins | 17 | 17080001292151 | 17080001292204 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001292391 | L17/scrutins | 17 | 17080001292389 | 17080001292390 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001292443 | L17/scrutins | 17 | 17080001292389 | 17080001292442 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001292628 | L17/scrutins | 17 | 17080001292626 | 17080001292627 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001292680 | L17/scrutins | 17 | 17080001292626 | 17080001292679 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001292859 | L17/scrutins | 17 | 17080001292857 | 17080001292858 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001292905 | L17/scrutins | 17 | 17080001292857 | 17080001292904 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001293053 | L17/scrutins | 17 | 17080001293051 | 17080001293052 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001293108 | L17/scrutins | 17 | 17080001293051 | 17080001293107 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001293284 | L17/scrutins | 17 | 17080001293282 | 17080001293283 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001293339 | L17/scrutins | 17 | 17080001293282 | 17080001293338 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001293514 | L17/scrutins | 17 | 17080001293512 | 17080001293513 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001293568 | L17/scrutins | 17 | 17080001293512 | 17080001293567 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001293741 | L17/scrutins | 17 | 17080001293739 | 17080001293740 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001293795 | L17/scrutins | 17 | 17080001293739 | 17080001293794 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001294001 | L17/scrutins | 17 | 17080001293968 | 17080001294000 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001294045 | L17/scrutins | 17 | 17080001293968 | 17080001294044 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080001294100 | L17/scrutins | 17 | 17080001294098 | 17080001294099 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001294154 | L17/scrutins | 17 | 17080001294098 | 17080001294153 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001294326 | L17/scrutins | 17 | 17080001294324 | 17080001294325 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001294380 | L17/scrutins | 17 | 17080001294324 | 17080001294379 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001294555 | L17/scrutins | 17 | 17080001294553 | 17080001294554 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001294610 | L17/scrutins | 17 | 17080001294553 | 17080001294609 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001294788 | L17/scrutins | 17 | 17080001294786 | 17080001294787 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001294843 | L17/scrutins | 17 | 17080001294786 | 17080001294842 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001295021 | L17/scrutins | 17 | 17080001295019 | 17080001295020 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001295076 | L17/scrutins | 17 | 17080001295019 | 17080001295075 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001295254 | L17/scrutins | 17 | 17080001295252 | 17080001295253 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001295309 | L17/scrutins | 17 | 17080001295252 | 17080001295308 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001295487 | L17/scrutins | 17 | 17080001295485 | 17080001295486 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001295542 | L17/scrutins | 17 | 17080001295485 | 17080001295541 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001295721 | L17/scrutins | 17 | 17080001295719 | 17080001295720 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001295776 | L17/scrutins | 17 | 17080001295719 | 17080001295775 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001295955 | L17/scrutins | 17 | 17080001295953 | 17080001295954 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001296008 | L17/scrutins | 17 | 17080001295953 | 17080001296007 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001296186 | L17/scrutins | 17 | 17080001296184 | 17080001296185 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001296242 | L17/scrutins | 17 | 17080001296184 | 17080001296241 | 1 | PA721908 | PM843467 | False | 391 | PAN |