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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000840276 | L17/scrutins | 17 | 17080000840126 | 17080000840275 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000840356 | L17/scrutins | 17 | 17080000840318 | 17080000840355 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000840415 | L17/scrutins | 17 | 17080000840318 | 17080000840414 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000840538 | L17/scrutins | 17 | 17080000840479 | 17080000840537 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000840630 | L17/scrutins | 17 | 17080000840479 | 17080000840629 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000840727 | L17/scrutins | 17 | 17080000840672 | 17080000840726 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000840804 | L17/scrutins | 17 | 17080000840672 | 17080000840803 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000840863 | L17/scrutins | 17 | 17080000840837 | 17080000840862 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000840923 | L17/scrutins | 17 | 17080000840837 | 17080000840922 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000840986 | L17/scrutins | 17 | 17080000840935 | 17080000840985 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000841073 | L17/scrutins | 17 | 17080000840935 | 17080000841072 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000841139 | L17/scrutins | 17 | 17080000841088 | 17080000841138 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000841223 | L17/scrutins | 17 | 17080000841088 | 17080000841222 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000841289 | L17/scrutins | 17 | 17080000841239 | 17080000841288 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000841370 | L17/scrutins | 17 | 17080000841239 | 17080000841369 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000841437 | L17/scrutins | 17 | 17080000841386 | 17080000841436 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000841526 | L17/scrutins | 17 | 17080000841386 | 17080000841525 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000841595 | L17/scrutins | 17 | 17080000841543 | 17080000841594 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000841684 | L17/scrutins | 17 | 17080000841543 | 17080000841683 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000841751 | L17/scrutins | 17 | 17080000841701 | 17080000841750 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000841842 | L17/scrutins | 17 | 17080000841701 | 17080000841841 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000841915 | L17/scrutins | 17 | 17080000841859 | 17080000841914 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000842007 | L17/scrutins | 17 | 17080000841859 | 17080000842006 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000842076 | L17/scrutins | 17 | 17080000842025 | 17080000842075 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000842123 | L17/scrutins | 17 | 17080000842025 | 17080000842122 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000842222 | L17/scrutins | 17 | 17080000842167 | 17080000842221 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000842306 | L17/scrutins | 17 | 17080000842167 | 17080000842305 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000842385 | L17/scrutins | 17 | 17080000842324 | 17080000842384 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000842461 | L17/scrutins | 17 | 17080000842324 | 17080000842460 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000842537 | L17/scrutins | 17 | 17080000842475 | 17080000842536 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000842613 | L17/scrutins | 17 | 17080000842475 | 17080000842612 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000842686 | L17/scrutins | 17 | 17080000842628 | 17080000842685 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000842763 | L17/scrutins | 17 | 17080000842628 | 17080000842762 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000842839 | L17/scrutins | 17 | 17080000842783 | 17080000842838 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000842913 | L17/scrutins | 17 | 17080000842783 | 17080000842912 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000842995 | L17/scrutins | 17 | 17080000842936 | 17080000842994 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000843068 | L17/scrutins | 17 | 17080000842936 | 17080000843067 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000843156 | L17/scrutins | 17 | 17080000843092 | 17080000843155 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000843236 | L17/scrutins | 17 | 17080000843092 | 17080000843235 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000843320 | L17/scrutins | 17 | 17080000843256 | 17080000843319 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000843390 | L17/scrutins | 17 | 17080000843256 | 17080000843389 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000843473 | L17/scrutins | 17 | 17080000843410 | 17080000843472 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000843543 | L17/scrutins | 17 | 17080000843410 | 17080000843542 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000843624 | L17/scrutins | 17 | 17080000843563 | 17080000843623 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000843700 | L17/scrutins | 17 | 17080000843563 | 17080000843699 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000843772 | L17/scrutins | 17 | 17080000843720 | 17080000843771 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000843828 | L17/scrutins | 17 | 17080000843720 | 17080000843827 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000843934 | L17/scrutins | 17 | 17080000843880 | 17080000843933 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000844003 | L17/scrutins | 17 | 17080000843880 | 17080000844002 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080000844098 | L17/scrutins | 17 | 17080000844024 | 17080000844097 | 1 | PA721908 | PM843467 | False | 402 | PAN |