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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000230911 | L17/scrutins | 17 | 17080000230826 | 17080000230910 | 1 | PA795228 | PM840447 | False | 627 | PSE |
| 17080000230965 | L17/scrutins | 17 | 17080000230826 | 17080000230964 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080000230996 | L17/scrutins | 17 | 17080000230826 | 17080000230995 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080000231081 | L17/scrutins | 17 | 17080000231022 | 17080000231080 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000231101 | L17/scrutins | 17 | 17080000231022 | 17080000231100 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000231214 | L17/scrutins | 17 | 17080000231196 | 17080000231213 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000231281 | L17/scrutins | 17 | 17080000231263 | 17080000231280 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000231346 | L17/scrutins | 17 | 17080000231328 | 17080000231345 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000231413 | L17/scrutins | 17 | 17080000231395 | 17080000231412 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000231481 | L17/scrutins | 17 | 17080000231463 | 17080000231480 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000231549 | L17/scrutins | 17 | 17080000231531 | 17080000231548 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000231617 | L17/scrutins | 17 | 17080000231599 | 17080000231616 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000231685 | L17/scrutins | 17 | 17080000231667 | 17080000231684 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000231748 | L17/scrutins | 17 | 17080000231735 | 17080000231747 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000231812 | L17/scrutins | 17 | 17080000231799 | 17080000231811 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000231920 | L17/scrutins | 17 | 17080000231859 | 17080000231919 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000231942 | L17/scrutins | 17 | 17080000231859 | 17080000231941 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000232048 | L17/scrutins | 17 | 17080000232037 | 17080000232047 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232078 | L17/scrutins | 17 | 17080000232037 | 17080000232077 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000232106 | L17/scrutins | 17 | 17080000232095 | 17080000232105 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232135 | L17/scrutins | 17 | 17080000232095 | 17080000232134 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000232165 | L17/scrutins | 17 | 17080000232155 | 17080000232164 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232195 | L17/scrutins | 17 | 17080000232155 | 17080000232194 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000232226 | L17/scrutins | 17 | 17080000232215 | 17080000232225 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232258 | L17/scrutins | 17 | 17080000232215 | 17080000232257 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000232292 | L17/scrutins | 17 | 17080000232278 | 17080000232291 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232327 | L17/scrutins | 17 | 17080000232278 | 17080000232326 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000232362 | L17/scrutins | 17 | 17080000232348 | 17080000232361 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232398 | L17/scrutins | 17 | 17080000232348 | 17080000232397 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000232434 | L17/scrutins | 17 | 17080000232420 | 17080000232433 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232470 | L17/scrutins | 17 | 17080000232420 | 17080000232469 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000232506 | L17/scrutins | 17 | 17080000232492 | 17080000232505 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232542 | L17/scrutins | 17 | 17080000232492 | 17080000232541 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000232578 | L17/scrutins | 17 | 17080000232564 | 17080000232577 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232610 | L17/scrutins | 17 | 17080000232564 | 17080000232609 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000232648 | L17/scrutins | 17 | 17080000232636 | 17080000232647 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232676 | L17/scrutins | 17 | 17080000232636 | 17080000232675 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000232757 | L17/scrutins | 17 | 17080000232698 | 17080000232756 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232780 | L17/scrutins | 17 | 17080000232698 | 17080000232779 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000232892 | L17/scrutins | 17 | 17080000232878 | 17080000232891 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232922 | L17/scrutins | 17 | 17080000232878 | 17080000232921 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000232961 | L17/scrutins | 17 | 17080000232946 | 17080000232960 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000232994 | L17/scrutins | 17 | 17080000232946 | 17080000232993 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000233034 | L17/scrutins | 17 | 17080000233017 | 17080000233033 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000233068 | L17/scrutins | 17 | 17080000233017 | 17080000233067 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000233106 | L17/scrutins | 17 | 17080000233091 | 17080000233105 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000233140 | L17/scrutins | 17 | 17080000233091 | 17080000233139 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000233179 | L17/scrutins | 17 | 17080000233162 | 17080000233178 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000233210 | L17/scrutins | 17 | 17080000233162 | 17080000233209 | 1 | PA330008 | PM842366 | False | 171 | PSE |
| 17080000233252 | L17/scrutins | 17 | 17080000233235 | 17080000233251 | 1 | PA721908 | PM843467 | False | 402 | PAN |