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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000019908 | L17/scrutins | 17 | 17080000019715 | 17080000019906 | 2 | PA720480 | PM843101 | False | 245 | MG |
| 17080000019963 | L17/scrutins | 17 | 17080000019923 | 17080000019962 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000020012 | L17/scrutins | 17 | 17080000019923 | 17080000020011 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000020052 | L17/scrutins | 17 | 17080000020025 | 17080000020051 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000020101 | L17/scrutins | 17 | 17080000020025 | 17080000020100 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000020150 | L17/scrutins | 17 | 17080000020112 | 17080000020149 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000020196 | L17/scrutins | 17 | 17080000020112 | 17080000020195 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000020253 | L17/scrutins | 17 | 17080000020210 | 17080000020252 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000020301 | L17/scrutins | 17 | 17080000020210 | 17080000020300 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000020359 | L17/scrutins | 17 | 17080000020314 | 17080000020358 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000020408 | L17/scrutins | 17 | 17080000020314 | 17080000020407 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000020465 | L17/scrutins | 17 | 17080000020422 | 17080000020464 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000020504 | L17/scrutins | 17 | 17080000020422 | 17080000020503 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000020556 | L17/scrutins | 17 | 17080000020514 | 17080000020555 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000020597 | L17/scrutins | 17 | 17080000020514 | 17080000020596 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000020653 | L17/scrutins | 17 | 17080000020611 | 17080000020652 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000020696 | L17/scrutins | 17 | 17080000020611 | 17080000020695 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000020751 | L17/scrutins | 17 | 17080000020708 | 17080000020750 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000020793 | L17/scrutins | 17 | 17080000020708 | 17080000020792 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000020846 | L17/scrutins | 17 | 17080000020805 | 17080000020845 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000020892 | L17/scrutins | 17 | 17080000020805 | 17080000020891 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000020979 | L17/scrutins | 17 | 17080000020903 | 17080000020978 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000021071 | L17/scrutins | 17 | 17080000020903 | 17080000021070 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080000021101 | L17/scrutins | 17 | 17080000020903 | 17080000021100 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000021102 | L17/scrutins | 17 | 17080000020903 | 17080000021100 | 2 | PA720480 | PM843101 | False | 245 | MG |
| 17080000021163 | L17/scrutins | 17 | 17080000021122 | 17080000021162 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000021210 | L17/scrutins | 17 | 17080000021122 | 17080000021209 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000021267 | L17/scrutins | 17 | 17080000021225 | 17080000021266 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000021310 | L17/scrutins | 17 | 17080000021225 | 17080000021309 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000021366 | L17/scrutins | 17 | 17080000021324 | 17080000021365 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000021414 | L17/scrutins | 17 | 17080000021324 | 17080000021413 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000021461 | L17/scrutins | 17 | 17080000021426 | 17080000021460 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000021462 | L17/scrutins | 17 | 17080000021426 | 17080000021460 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000021569 | L17/scrutins | 17 | 17080000021526 | 17080000021568 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000021570 | L17/scrutins | 17 | 17080000021526 | 17080000021568 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000021678 | L17/scrutins | 17 | 17080000021635 | 17080000021677 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000021679 | L17/scrutins | 17 | 17080000021635 | 17080000021677 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000021786 | L17/scrutins | 17 | 17080000021742 | 17080000021785 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000021787 | L17/scrutins | 17 | 17080000021742 | 17080000021785 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000021889 | L17/scrutins | 17 | 17080000021851 | 17080000021888 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000021890 | L17/scrutins | 17 | 17080000021851 | 17080000021888 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000021997 | L17/scrutins | 17 | 17080000021955 | 17080000021996 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000021998 | L17/scrutins | 17 | 17080000021955 | 17080000021996 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000022105 | L17/scrutins | 17 | 17080000022061 | 17080000022104 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080000022106 | L17/scrutins | 17 | 17080000022061 | 17080000022104 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000022230 | L17/scrutins | 17 | 17080000022173 | 17080000022229 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000022304 | L17/scrutins | 17 | 17080000022173 | 17080000022303 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080000022332 | L17/scrutins | 17 | 17080000022173 | 17080000022331 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000022333 | L17/scrutins | 17 | 17080000022173 | 17080000022331 | 2 | PA720480 | PM843101 | False | 245 | MG |
| 17080000022395 | L17/scrutins | 17 | 17080000022351 | 17080000022394 | 1 | PA721134 | PM843797 | False | 268 | PSE |