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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17080001134411 | L17/scrutins | 17 | 17080001134363 | 17080001134410 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001134504 | L17/scrutins | 17 | 17080001134363 | 17080001134503 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001134575 | L17/scrutins | 17 | 17080001134530 | 17080001134574 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001134671 | L17/scrutins | 17 | 17080001134530 | 17080001134670 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001134738 | L17/scrutins | 17 | 17080001134693 | 17080001134737 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001134835 | L17/scrutins | 17 | 17080001134693 | 17080001134834 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001134902 | L17/scrutins | 17 | 17080001134858 | 17080001134901 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001134997 | L17/scrutins | 17 | 17080001134858 | 17080001134996 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001135119 | L17/scrutins | 17 | 17080001135020 | 17080001135118 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001135349 | L17/scrutins | 17 | 17080001135304 | 17080001135348 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001135442 | L17/scrutins | 17 | 17080001135304 | 17080001135441 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001135508 | L17/scrutins | 17 | 17080001135465 | 17080001135507 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001135597 | L17/scrutins | 17 | 17080001135465 | 17080001135596 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001135660 | L17/scrutins | 17 | 17080001135620 | 17080001135659 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001135744 | L17/scrutins | 17 | 17080001135620 | 17080001135743 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001135811 | L17/scrutins | 17 | 17080001135768 | 17080001135810 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001135926 | L17/scrutins | 17 | 17080001135768 | 17080001135925 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001136020 | L17/scrutins | 17 | 17080001135972 | 17080001136019 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001136146 | L17/scrutins | 17 | 17080001135972 | 17080001136145 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001136242 | L17/scrutins | 17 | 17080001136195 | 17080001136241 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001136370 | L17/scrutins | 17 | 17080001136195 | 17080001136369 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001136464 | L17/scrutins | 17 | 17080001136418 | 17080001136463 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001136588 | L17/scrutins | 17 | 17080001136418 | 17080001136587 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001136679 | L17/scrutins | 17 | 17080001136628 | 17080001136678 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001136815 | L17/scrutins | 17 | 17080001136628 | 17080001136814 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001136909 | L17/scrutins | 17 | 17080001136858 | 17080001136908 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001137043 | L17/scrutins | 17 | 17080001136858 | 17080001137042 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001137138 | L17/scrutins | 17 | 17080001137087 | 17080001137137 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001137273 | L17/scrutins | 17 | 17080001137087 | 17080001137272 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001137377 | L17/scrutins | 17 | 17080001137318 | 17080001137376 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001137473 | L17/scrutins | 17 | 17080001137318 | 17080001137472 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080001137507 | L17/scrutins | 17 | 17080001137318 | 17080001137506 | 1 | PA720908 | PM843701 | False | 221 | PSE |
| 17080001137508 | L17/scrutins | 17 | 17080001137318 | 17080001137506 | 2 | PA720480 | PM843101 | False | 245 | MG |
| 17080001137556 | L17/scrutins | 17 | 17080001137531 | 17080001137555 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001137604 | L17/scrutins | 17 | 17080001137531 | 17080001137603 | 1 | PA643089 | PM843431 | False | 206 | MG |
| 17080001137626 | L17/scrutins | 17 | 17080001137531 | 17080001137625 | 1 | PA720480 | PM843101 | False | 245 | MG |
| 17080001137748 | L17/scrutins | 17 | 17080001137648 | 17080001137747 | 1 | PA721908 | PM843467 | False | 402 | PAN |
| 17080001137982 | L17/scrutins | 17 | 17080001137931 | 17080001137981 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001138119 | L17/scrutins | 17 | 17080001137931 | 17080001138118 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001138214 | L17/scrutins | 17 | 17080001138164 | 17080001138213 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001138346 | L17/scrutins | 17 | 17080001138164 | 17080001138345 | 1 | PA795270 | PM858399 | False | 217 | PSE |
| 17080001138444 | L17/scrutins | 17 | 17080001138393 | 17080001138443 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001138691 | L17/scrutins | 17 | 17080001138661 | 17080001138690 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001138801 | L17/scrutins | 17 | 17080001138763 | 17080001138800 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001138941 | L17/scrutins | 17 | 17080001138900 | 17080001138940 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001139060 | L17/scrutins | 17 | 17080001139017 | 17080001139059 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001139181 | L17/scrutins | 17 | 17080001139136 | 17080001139180 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001139307 | L17/scrutins | 17 | 17080001139267 | 17080001139306 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001139438 | L17/scrutins | 17 | 17080001139397 | 17080001139437 | 1 | PA721908 | PM843467 | False | 391 | PAN |
| 17080001139627 | L17/scrutins | 17 | 17080001139527 | 17080001139626 | 1 | PA721908 | PM843467 | False | 402 | PAN |