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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080001199769 | L17/scrutins | 17 | 17080001199761 | 17080001199768 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001199837 | L17/scrutins | 17 | 17080001199835 | 17080001199836 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001199844 | L17/scrutins | 17 | 17080001199835 | 17080001199843 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001199963 | L17/scrutins | 17 | 17080001199889 | 17080001199962 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001199981 | L17/scrutins | 17 | 17080001199889 | 17080001199980 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080001200040 | L17/scrutins | 17 | 17080001199889 | 17080001200039 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080001200066 | L17/scrutins | 17 | 17080001199889 | 17080001200065 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080001200115 | L17/scrutins | 17 | 17080001200085 | 17080001200114 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080001200116 | L17/scrutins | 17 | 17080001200085 | 17080001200114 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001200194 | L17/scrutins | 17 | 17080001200192 | 17080001200193 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001200201 | L17/scrutins | 17 | 17080001200192 | 17080001200200 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001200248 | L17/scrutins | 17 | 17080001200246 | 17080001200247 | 1 | PA720468 | PM840333 | False | 027 | PSE |
| 17080001200255 | L17/scrutins | 17 | 17080001200246 | 17080001200254 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001200380 | L17/scrutins | 17 | 17080001200301 | 17080001200379 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001200721 | L17/scrutins | 17 | 17080001200637 | 17080001200720 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001201100 | L17/scrutins | 17 | 17080001201017 | 17080001201099 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001201514 | L17/scrutins | 17 | 17080001201394 | 17080001201513 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001202022 | L17/scrutins | 17 | 17080001201941 | 17080001202021 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001202310 | L17/scrutins | 17 | 17080001202228 | 17080001202309 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001202610 | L17/scrutins | 17 | 17080001202518 | 17080001202609 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001203096 | L17/scrutins | 17 | 17080001203009 | 17080001203095 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001203521 | L17/scrutins | 17 | 17080001203490 | 17080001203520 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080001203522 | L17/scrutins | 17 | 17080001203490 | 17080001203520 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001203630 | L17/scrutins | 17 | 17080001203602 | 17080001203629 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001203754 | L17/scrutins | 17 | 17080001203722 | 17080001203753 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001203880 | L17/scrutins | 17 | 17080001203857 | 17080001203879 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001203992 | L17/scrutins | 17 | 17080001203857 | 17080001203991 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001204038 | L17/scrutins | 17 | 17080001204015 | 17080001204037 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001204148 | L17/scrutins | 17 | 17080001204015 | 17080001204147 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001204196 | L17/scrutins | 17 | 17080001204173 | 17080001204195 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001204292 | L17/scrutins | 17 | 17080001204173 | 17080001204291 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001204334 | L17/scrutins | 17 | 17080001204314 | 17080001204333 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001204412 | L17/scrutins | 17 | 17080001204314 | 17080001204411 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001204456 | L17/scrutins | 17 | 17080001204432 | 17080001204455 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001204551 | L17/scrutins | 17 | 17080001204432 | 17080001204550 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001204597 | L17/scrutins | 17 | 17080001204575 | 17080001204596 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001204691 | L17/scrutins | 17 | 17080001204575 | 17080001204690 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001204730 | L17/scrutins | 17 | 17080001204714 | 17080001204729 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001204812 | L17/scrutins | 17 | 17080001204714 | 17080001204811 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001204841 | L17/scrutins | 17 | 17080001204830 | 17080001204840 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001204953 | L17/scrutins | 17 | 17080001204918 | 17080001204952 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080001204954 | L17/scrutins | 17 | 17080001204918 | 17080001204952 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001205041 | L17/scrutins | 17 | 17080001205030 | 17080001205040 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001205119 | L17/scrutins | 17 | 17080001205108 | 17080001205118 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001205208 | L17/scrutins | 17 | 17080001205197 | 17080001205207 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001205294 | L17/scrutins | 17 | 17080001205292 | 17080001205293 | 1 | PA794354 | PM842960 | False | 028 | PSE |
| 17080001205309 | L17/scrutins | 17 | 17080001205292 | 17080001205308 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001205410 | L17/scrutins | 17 | 17080001205408 | 17080001205409 | 1 | PA794354 | PM842960 | False | 028 | PSE |
| 17080001205425 | L17/scrutins | 17 | 17080001205408 | 17080001205424 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001205524 | L17/scrutins | 17 | 17080001205522 | 17080001205523 | 1 | PA794354 | PM842960 | False | 028 | PSE |