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 323 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000235171 | L17/scrutins | 17 | 17080000235126 | 17080000235170 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000235206 | L17/scrutins | 17 | 17080000235188 | 17080000235205 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000235234 | L17/scrutins | 17 | 17080000235188 | 17080000235233 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000235316 | L17/scrutins | 17 | 17080000235251 | 17080000235315 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000235481 | L17/scrutins | 17 | 17080000235473 | 17080000235480 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000235495 | L17/scrutins | 17 | 17080000235473 | 17080000235494 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000235517 | L17/scrutins | 17 | 17080000235506 | 17080000235516 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000235542 | L17/scrutins | 17 | 17080000235506 | 17080000235541 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000235575 | L17/scrutins | 17 | 17080000235556 | 17080000235574 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000235604 | L17/scrutins | 17 | 17080000235556 | 17080000235603 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000235640 | L17/scrutins | 17 | 17080000235623 | 17080000235639 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000235670 | L17/scrutins | 17 | 17080000235623 | 17080000235669 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000235708 | L17/scrutins | 17 | 17080000235689 | 17080000235707 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000235735 | L17/scrutins | 17 | 17080000235689 | 17080000235734 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000235775 | L17/scrutins | 17 | 17080000235756 | 17080000235774 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000235803 | L17/scrutins | 17 | 17080000235756 | 17080000235802 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000235840 | L17/scrutins | 17 | 17080000235824 | 17080000235839 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000235870 | L17/scrutins | 17 | 17080000235824 | 17080000235869 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000235907 | L17/scrutins | 17 | 17080000235891 | 17080000235906 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000235932 | L17/scrutins | 17 | 17080000235891 | 17080000235931 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000235970 | L17/scrutins | 17 | 17080000235953 | 17080000235969 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236001 | L17/scrutins | 17 | 17080000235953 | 17080000236000 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000236040 | L17/scrutins | 17 | 17080000236023 | 17080000236039 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236069 | L17/scrutins | 17 | 17080000236023 | 17080000236068 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000236143 | L17/scrutins | 17 | 17080000236089 | 17080000236142 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236302 | L17/scrutins | 17 | 17080000236285 | 17080000236301 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236332 | L17/scrutins | 17 | 17080000236285 | 17080000236331 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000236369 | L17/scrutins | 17 | 17080000236352 | 17080000236368 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236399 | L17/scrutins | 17 | 17080000236352 | 17080000236398 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000236435 | L17/scrutins | 17 | 17080000236419 | 17080000236434 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236463 | L17/scrutins | 17 | 17080000236419 | 17080000236462 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000236499 | L17/scrutins | 17 | 17080000236485 | 17080000236498 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236528 | L17/scrutins | 17 | 17080000236485 | 17080000236527 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000236567 | L17/scrutins | 17 | 17080000236553 | 17080000236566 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236596 | L17/scrutins | 17 | 17080000236553 | 17080000236595 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000236633 | L17/scrutins | 17 | 17080000236619 | 17080000236632 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236660 | L17/scrutins | 17 | 17080000236619 | 17080000236659 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000236696 | L17/scrutins | 17 | 17080000236682 | 17080000236695 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236723 | L17/scrutins | 17 | 17080000236682 | 17080000236722 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000236756 | L17/scrutins | 17 | 17080000236742 | 17080000236755 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236782 | L17/scrutins | 17 | 17080000236742 | 17080000236781 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000236813 | L17/scrutins | 17 | 17080000236802 | 17080000236812 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236840 | L17/scrutins | 17 | 17080000236802 | 17080000236839 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000236871 | L17/scrutins | 17 | 17080000236860 | 17080000236870 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000236898 | L17/scrutins | 17 | 17080000236860 | 17080000236897 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000236966 | L17/scrutins | 17 | 17080000236917 | 17080000236965 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000237112 | L17/scrutins | 17 | 17080000237099 | 17080000237111 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000237138 | L17/scrutins | 17 | 17080000237099 | 17080000237137 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000237170 | L17/scrutins | 17 | 17080000237157 | 17080000237169 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000237196 | L17/scrutins | 17 | 17080000237157 | 17080000237195 | 1 | PA330008 | PM842366 | False | 171 | PSE |