AN · données ouvertes
Explorateur / scrutins

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

#ColonneTypeCommentaire
1_idBIGINTidentifiant : code de la source × 10¹⁰ + rang
2_sourceVARCHARsource du catalogue (catalogue.py)
3_legislatureBIGINTcolonne constante de la source
4_racine_idBIGINT_id de la ligne racine
5_parent_idBIGINT_id de la ligne parente
6_ordreBIGINTrang dans le tableau d'origine (1…)
7acteur_refVARCHARscrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.acteurRef · présence : L17 99 %, L16 96 %, L15 99 %, L14 100 %
8mandat_refVARCHARscrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.mandatRef · présence : L17 99 %, L16 96 %, L15 99 %, L14 100 %
9par_delegationBOOLEANscrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.parDelegation · présence : L17 99 %
10num_placeVARCHARscrutin.ventilationVotes.organe.groupes.groupe.vote.decompteNominatif.nonVotants.votant.numPlace · présence : L17 99 %
11cause_position_voteVARCHARscrutin.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_ordreacteur_refmandat_refpar_delegationnum_placecause_position_vote
16080000601835L16/scrutins1616080000601595160800006018341PA720908PM797556PSE
16080000601948L16/scrutins1616080000601887160800006019471PA720286PM796878PSE
16080000602067L16/scrutins1616080000602004160800006020661PA720286PM796878PSE
16080000602187L16/scrutins1616080000602123160800006021861PA720286PM796878PSE
16080000602309L16/scrutins1616080000602245160800006023081PA720286PM796878PSE
16080000602432L16/scrutins1616080000602373160800006024311PA720286PM796878PSE
16080000602561L16/scrutins1616080000602495160800006025601PA720286PM796878PSE
16080000602689L16/scrutins1616080000602623160800006026881PA720286PM796878PSE
16080000602819L16/scrutins1616080000602757160800006028181PA720286PM796878PSE
16080000602926L16/scrutins1616080000602872160800006029251PA720286PM796878PSE
16080000603037L16/scrutins1616080000602984160800006030361PA720286PM796878PSE
16080000603492L16/scrutins1616080000603085160800006034911PA720908PM797556PSE
16080000603632L16/scrutins1616080000603576160800006036311PA719874PM796674PSE
16080000603722L16/scrutins1616080000603664160800006037211PA719874PM796674PSE
16080000603818L16/scrutins1616080000603756160800006038171PA719874PM796674PSE
16080000603934L16/scrutins1616080000603855160800006039331PA719874PM796674PSE
16080000604036L16/scrutins1616080000603964160800006040351PA719874PM796674PSE
16080000604136L16/scrutins1616080000604067160800006041351PA719874PM796674PSE
16080000604217L16/scrutins1616080000604165160800006042161PA719874PM796674PSE
16080000604296L16/scrutins1616080000604252160800006042951PA720286PM796878PSE
16080000604386L16/scrutins1616080000604338160800006043851PA719874PM796674PSE
16080000604463L16/scrutins1616080000604410160800006044621PA719874PM796674PSE
16080000604592L16/scrutins1616080000604482160800006045911PA720286PM796878PSE
16080000604743L16/scrutins1616080000604692160800006047421PA719874PM796674PSE
16080000604819L16/scrutins1616080000604764160800006048181PA719874PM796674PSE
16080000604842L16/scrutins1616080000604840160800006048411PA721908PM797568PSE
16080000605597L16/scrutins1616080000605531160800006055961PA720468PM796983PSE
16080000605823L16/scrutins1616080000605759160800006058221PA720468PM796983PSE
16080000606041L16/scrutins1616080000605967160800006060401PA720468PM796983PSE
16080000606396L16/scrutins1616080000606197160800006063951PA720908PM797556PSE
16080000606621L16/scrutins1616080000606429160800006066201PA720908PM797556PSE
16080000606823L16/scrutins1616080000606646160800006068221PA720908PM797556PSE
16080000606989L16/scrutins1616080000606852160800006069881PA609590PM797742PSE
16080000607216L16/scrutins1616080000607029160800006072151PA720908PM797556PSE
16080000607423L16/scrutins1616080000607244160800006074221PA720908PM797556PSE
16080000607542L16/scrutins1616080000607453160800006075411PA720286PM796878PSE
16080000607696L16/scrutins1616080000607600160800006076951PA720286PM796878PSE
16080000607853L16/scrutins1616080000607757160800006078521PA720286PM796878PSE
16080000607991L16/scrutins1616080000607916160800006079901PA720286PM796878PSE
16080000608123L16/scrutins1616080000608034160800006081221PA720286PM796878PSE
16080000608256L16/scrutins1616080000608174160800006082551PA720286PM796878PSE
16080000608394L16/scrutins1616080000608308160800006083931PA720286PM796878PSE
16080000608518L16/scrutins1616080000608449160800006085171PA720286PM796878PSE
16080000608776L16/scrutins1616080000608573160800006087751PA609590PM797742PSE
16080000609069L16/scrutins1616080000608820160800006090681PA609590PM797742PSE
16080000609214L16/scrutins1616080000609134160800006092131PA720468PM796983PSE
16080000609440L16/scrutins1616080000609337160800006094391PA720468PM796983PSE
16080000609704L16/scrutins1616080000609590160800006097031PA720468PM796983PSE
16080000609949L16/scrutins1616080000609840160800006099481PA719874PM796674PSE
16080000610088L16/scrutins1616080000609987160800006100871PA719874PM796674PSE