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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080000836156 | L17/scrutins | 17 | 17080000835890 | 17080000836154 | 2 | PA794994 | PM843293 | False | 173 | MG |
| 17080000836157 | L17/scrutins | 17 | 17080000835890 | 17080000836154 | 3 | PA605991 | PM842540 | False | 205 | MG |
| 17080000836158 | L17/scrutins | 17 | 17080000835890 | 17080000836154 | 4 | PA643089 | PM843431 | False | 206 | MG |
| 17080000836204 | L17/scrutins | 17 | 17080000835890 | 17080000836203 | 1 | PA721836 | PM843458 | False | 358 | MG |
| 17080000836205 | L17/scrutins | 17 | 17080000835890 | 17080000836203 | 2 | PA795120 | PM843344 | False | 360 | MG |
| 17080000836206 | L17/scrutins | 17 | 17080000835890 | 17080000836203 | 3 | PA719914 | PM842864 | False | 361 | MG |
| 17080000836229 | L17/scrutins | 17 | 17080000835890 | 17080000836228 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080000836230 | L17/scrutins | 17 | 17080000835890 | 17080000836228 | 2 | PA642868 | PM843122 | False | 214 | MG |
| 17080000836231 | L17/scrutins | 17 | 17080000835890 | 17080000836228 | 3 | PA795270 | PM843401 | False | 219 | MG |
| 17080000836232 | L17/scrutins | 17 | 17080000835890 | 17080000836228 | 4 | PA720480 | PM843101 | False | 317 | MG |
| 17080000836254 | L17/scrutins | 17 | 17080000835890 | 17080000836253 | 1 | PA227089 | PM843131 | False | 395 | MG |
| 17080000836357 | L17/scrutins | 17 | 17080000836278 | 17080000836356 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000836384 | L17/scrutins | 17 | 17080000836278 | 17080000836383 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000836462 | L17/scrutins | 17 | 17080000836278 | 17080000836461 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080000836505 | L17/scrutins | 17 | 17080000836278 | 17080000836504 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080000836570 | L17/scrutins | 17 | 17080000836535 | 17080000836569 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000836612 | L17/scrutins | 17 | 17080000836535 | 17080000836611 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000836734 | L17/scrutins | 17 | 17080000836679 | 17080000836733 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000836816 | L17/scrutins | 17 | 17080000836679 | 17080000836815 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000836911 | L17/scrutins | 17 | 17080000836857 | 17080000836910 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000837079 | L17/scrutins | 17 | 17080000837024 | 17080000837078 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000837255 | L17/scrutins | 17 | 17080000837197 | 17080000837254 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000837402 | L17/scrutins | 17 | 17080000837374 | 17080000837401 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000837482 | L17/scrutins | 17 | 17080000837454 | 17080000837481 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000837587 | L17/scrutins | 17 | 17080000837531 | 17080000837586 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000837644 | L17/scrutins | 17 | 17080000837531 | 17080000837643 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000837724 | L17/scrutins | 17 | 17080000837667 | 17080000837723 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000837781 | L17/scrutins | 17 | 17080000837667 | 17080000837780 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000837880 | L17/scrutins | 17 | 17080000837810 | 17080000837879 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000837953 | L17/scrutins | 17 | 17080000837810 | 17080000837952 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000838063 | L17/scrutins | 17 | 17080000837993 | 17080000838062 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000838141 | L17/scrutins | 17 | 17080000837993 | 17080000838140 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000838220 | L17/scrutins | 17 | 17080000838183 | 17080000838219 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000838261 | L17/scrutins | 17 | 17080000838183 | 17080000838260 | 1 | PA795310 | PM840453 | False | 634 | PSE |
| 17080000838400 | L17/scrutins | 17 | 17080000838330 | 17080000838399 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000838485 | L17/scrutins | 17 | 17080000838330 | 17080000838484 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000838595 | L17/scrutins | 17 | 17080000838526 | 17080000838594 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000838672 | L17/scrutins | 17 | 17080000838526 | 17080000838671 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000838788 | L17/scrutins | 17 | 17080000838713 | 17080000838787 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000838883 | L17/scrutins | 17 | 17080000838713 | 17080000838882 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000838995 | L17/scrutins | 17 | 17080000838920 | 17080000838994 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000839192 | L17/scrutins | 17 | 17080000839119 | 17080000839191 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000839403 | L17/scrutins | 17 | 17080000839329 | 17080000839402 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000839607 | L17/scrutins | 17 | 17080000839541 | 17080000839606 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000839707 | L17/scrutins | 17 | 17080000839541 | 17080000839706 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000839800 | L17/scrutins | 17 | 17080000839745 | 17080000839799 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000839897 | L17/scrutins | 17 | 17080000839745 | 17080000839896 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000839995 | L17/scrutins | 17 | 17080000839937 | 17080000839994 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080000840084 | L17/scrutins | 17 | 17080000839937 | 17080000840083 | 1 | PA719024 | PM842390 | False | 344 | PSE |
| 17080000840184 | L17/scrutins | 17 | 17080000840126 | 17080000840183 | 1 | PA721908 | PM843467 | False | 402 | PAN |