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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080001306013 | L17/scrutins | 17 | 17080001305977 | 17080001306012 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001306084 | L17/scrutins | 17 | 17080001305977 | 17080001306083 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001306151 | L17/scrutins | 17 | 17080001306115 | 17080001306150 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001306287 | L17/scrutins | 17 | 17080001306256 | 17080001306286 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001306357 | L17/scrutins | 17 | 17080001306256 | 17080001306356 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001306413 | L17/scrutins | 17 | 17080001306383 | 17080001306412 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001306475 | L17/scrutins | 17 | 17080001306383 | 17080001306474 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001306530 | L17/scrutins | 17 | 17080001306500 | 17080001306529 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001306591 | L17/scrutins | 17 | 17080001306500 | 17080001306590 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001306644 | L17/scrutins | 17 | 17080001306615 | 17080001306643 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001306707 | L17/scrutins | 17 | 17080001306615 | 17080001306706 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001306757 | L17/scrutins | 17 | 17080001306730 | 17080001306756 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001306817 | L17/scrutins | 17 | 17080001306730 | 17080001306816 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001306869 | L17/scrutins | 17 | 17080001306842 | 17080001306868 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001306928 | L17/scrutins | 17 | 17080001306842 | 17080001306927 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001306982 | L17/scrutins | 17 | 17080001306953 | 17080001306981 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001307039 | L17/scrutins | 17 | 17080001306953 | 17080001307038 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080001307080 | L17/scrutins | 17 | 17080001307061 | 17080001307079 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001307126 | L17/scrutins | 17 | 17080001307061 | 17080001307125 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001307150 | L17/scrutins | 17 | 17080001307140 | 17080001307149 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080001307151 | L17/scrutins | 17 | 17080001307140 | 17080001307149 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001307219 | L17/scrutins | 17 | 17080001307199 | 17080001307218 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001307281 | L17/scrutins | 17 | 17080001307199 | 17080001307280 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001307320 | L17/scrutins | 17 | 17080001307298 | 17080001307319 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001307394 | L17/scrutins | 17 | 17080001307298 | 17080001307393 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001307437 | L17/scrutins | 17 | 17080001307413 | 17080001307436 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001307512 | L17/scrutins | 17 | 17080001307413 | 17080001307511 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001307556 | L17/scrutins | 17 | 17080001307532 | 17080001307555 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001307633 | L17/scrutins | 17 | 17080001307532 | 17080001307632 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001307679 | L17/scrutins | 17 | 17080001307653 | 17080001307678 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001307763 | L17/scrutins | 17 | 17080001307653 | 17080001307762 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001307807 | L17/scrutins | 17 | 17080001307782 | 17080001307806 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001307887 | L17/scrutins | 17 | 17080001307782 | 17080001307886 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001307930 | L17/scrutins | 17 | 17080001307905 | 17080001307929 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001308016 | L17/scrutins | 17 | 17080001307905 | 17080001308015 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001308066 | L17/scrutins | 17 | 17080001308035 | 17080001308065 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001308162 | L17/scrutins | 17 | 17080001308035 | 17080001308161 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001308214 | L17/scrutins | 17 | 17080001308181 | 17080001308213 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001308311 | L17/scrutins | 17 | 17080001308181 | 17080001308310 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001308364 | L17/scrutins | 17 | 17080001308331 | 17080001308363 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001308461 | L17/scrutins | 17 | 17080001308331 | 17080001308460 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001308492 | L17/scrutins | 17 | 17080001308481 | 17080001308491 | 1 | PA721134 | PM843797 | False | 268 | PSE |
| 17080001308493 | L17/scrutins | 17 | 17080001308481 | 17080001308491 | 2 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001308576 | L17/scrutins | 17 | 17080001308544 | 17080001308575 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001308669 | L17/scrutins | 17 | 17080001308544 | 17080001308668 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001308721 | L17/scrutins | 17 | 17080001308688 | 17080001308720 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001308815 | L17/scrutins | 17 | 17080001308688 | 17080001308814 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001308868 | L17/scrutins | 17 | 17080001308835 | 17080001308867 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001308963 | L17/scrutins | 17 | 17080001308835 | 17080001308962 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001309016 | L17/scrutins | 17 | 17080001308983 | 17080001309015 | 1 | PA721908 | PM843467 | False | 391 | PAN |