Aller au contenu
blackout

debats.compte_rendu_point

Chemin compteRendu.contenu.point · présence : L17 100 %, L16 100 %, L15 100 %

162 871 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…)
7_parent_recursif_idBIGINT_id de la ligne de même table qui contient celle-ci (structure récursive)
8_niveauBIGINTprofondeur dans la structure récursive (0 = premier niveau)
9orateurs_orateur_nomVARCHARcompteRendu.contenu.point.orateurs.orateur.nom · présence : L17 0 %
10orateurs_orateur_idBIGINTcompteRendu.contenu.point.orateurs.orateur.id · présence : L17 0 % · XSD 2016 : Identifiant du programme (dans l’amendement ? l'id est local à l'amendement ? je ne pense pas)
11orateurs_orateur_qualiteVARCHARcompteRendu.contenu.point.orateurs.orateur.qualite · présence : L17 0 % · XSD 2016 : Rapporteur, rapporteur pour avis, général, spécial, intervenant. Ne pas mettre auteur et cosignataire. Utilisé également pour la spécialité du rapporteur sur le PLF
12texteVARCHARcompteRendu.contenu.point.texte · présence : L17 100 %, L16 100 %, L15 100 %
13texte_xmlVARCHARcompteRendu.contenu.point.texte.#xml · présence : L17 91 %, L16 94 %, L15 96 %
14nivpointBIGINTcompteRendu.contenu.point.@nivpoint · présence : L17 100 %, L16 100 %, L15 100 %
15valeur_ptsodjBIGINTcompteRendu.contenu.point.@valeur_ptsodj · présence : L17 100 %, L16 100 %, L15 100 %
16ordinal_priseBIGINTcompteRendu.contenu.point.@ordinal_prise · présence : L17 100 %, L16 100 %, L15 100 %
17id_preparationBIGINTcompteRendu.contenu.point.@id_preparation · présence : L17 100 %, L16 100 %, L15 100 %
18ordre_absolu_seanceBIGINTcompteRendu.contenu.point.@ordre_absolu_seance · présence : L17 100 %, L16 100 %, L15 100 %
19code_grammaireVARCHARcompteRendu.contenu.point.@code_grammaire · présence : L17 100 %, L16 100 %, L15 100 %
20code_styleVARCHARcompteRendu.contenu.point.@code_style · présence : L17 100 %, L16 100 %, L15 100 %
21code_paroleVARCHARcompteRendu.contenu.point.@code_parole · présence : L17 100 %, L16 100 %, L15 100 %
22sommaireBIGINTcompteRendu.contenu.point.@sommaire · présence : L17 100 %, L16 100 %, L15 100 %
23id_syceronBIGINTcompteRendu.contenu.point.@id_syceron · présence : L17 100 %, L16 100 %, L15 100 %
24valeurVARCHARcompteRendu.contenu.point.@valeur · présence : L17 100 %, L16 100 %, L15 100 %
25bibardVARCHARcompteRendu.contenu.point.@bibard · présence : L17 82 %, L16 82 %, L15 87 %
26artVARCHARcompteRendu.contenu.point.@art · présence : L17 78 %, L16 77 %, L15 79 %
27adtVARCHARcompteRendu.contenu.point.@adt · présence : L17 78 %, L16 77 %, L15 79 %
28ssadtVARCHARcompteRendu.contenu.point.@ssadt · présence : L17 78 %, L16 77 %, L15 79 %
29structureVARCHARcompteRendu.contenu.point.@structure · présence : L17 75 %, L16 74 %, L15 75 %
30id_acteurVARCHARcompteRendu.contenu.point.@id_acteur · présence : L17 75 %, L16 74 %, L15 75 %
31id_mandatVARCHARcompteRendu.contenu.point.@id_mandat · présence : L17 75 %, L16 74 %, L15 75 %
32id_nomination_oeVARCHARcompteRendu.contenu.point.@id_nomination_oe · présence : L17 75 %, L16 74 %, L15 75 %
33id_nomination_opVARCHARcompteRendu.contenu.point.@id_nomination_op · présence : L17 75 %, L16 74 %, L15 75 %
34orateurVARCHARcompteRendu.contenu.point.@orateur · présence : L17 75 %, L16 74 %, L15 75 %
35type_debatVARCHARcompteRendu.contenu.point.@type_debat · présence : L17 15 %, L16 12 %, L15 18 %
36uid_adtVARCHARcompteRendu.contenu.point.@uid_adt · présence : L17 1 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordre_parent_recursif_id_niveauorateurs_orateur_nomorateurs_orateur_idorateurs_orateur_qualitetextetexte_xmlnivpointvaleur_ptsodjordinal_priseid_preparationordre_absolu_seancecode_grammairecode_stylecode_parolesommaireid_syceronvaleurbibardartadtssadtstructureid_acteurid_mandatid_nomination_oeid_nomination_oporateurtype_debatuid_adt
15130000452576L15/debats151513000045085715130000450857415130000451643341161059145921DISC_ARTICLES_3_9_1113012523018 (n[[o]] 971) 283018OuiPA721824PM723394-1PM732212
15130000452582L15/debats151513000045085715130000450857515130000451643341161059147923DISC_ARTICLES_3_11130125458 (n[[o]] 971) 2858OuiPA721824PM723394-1PM732212
15130000452588L15/debats151513000045085715130000450857615130000451643341161059150926DISC_ARTICLES_3_1113012572101 (n[[o]] 971) 282101OuiPA721824PM723394-1PM732212
15130000452594L15/debats151513000045085715130000450857715130000451643341161059152928DISC_ARTICLES_3_1113012592658 (n[[o]] 971) 282658OuiPA721824PM723394-1PM732212
15130000452618L15/debats151513000045085715130000450857815130000451643341161059162938DISC_ARTICLES_3_1113012693049 rectifié (n[[o]] 971) 283049 rectifiéOuiPA721824PM723394-1PM732212
15130000452645L15/debats151513000045085715130000450857915130000451643341171059374952DISC_ARTICLES_3_9_1113013112103 (n[[o]] 971) 282103OuiPA721824PM723394-1PM732212
15130000452651L15/debats1515130000450857151300004508571015130000451643341171059377955DISC_ARTICLES_3_1113013142659 (n[[o]] 971) 282659OuiPA721824PM723394-1PM732212
15130000452663L15/debats1515130000450857151300004508571115130000451643341171059384960DISC_ARTICLES_3_1113013212102 (n[[o]] 971) 282102OuiPA721824PM723394-1PM732212
15130000452680L15/debats1515130000450857151300004508571215130000451643341171059393967DISC_ARTICLES_3_9_1113013303206 (n[[o]] 971) 283206OuiPA721824PM723394-1PM732212
15130000452686L15/debats1515130000450857151300004508571315130000451643341171059395969DISC_ARTICLES_3_1113013322660 (n[[o]] 971) 282660OuiPA721824PM723394-1PM732212
15130000452711L15/debats1515130000450857151300004508571415130000451643341171059406980DISC_ARTICLES_3_9_1113013432104 (n[[o]] 971) 282104OuiPA721824PM723394-1PM732212
15130000452717L15/debats1515130000450857151300004508571515130000451643341171059408982DISC_ARTICLES_3_1113013452661 (n[[o]] 971) 282661OuiPA721824PM723394-1PM732212
15130000452724L15/debats1515130000450857151300004508571615130000451643341171059411985DISC_ARTICLES_3_1113013482662 (n[[o]] 971) 282662OuiPA721824PM723394-1PM732212
15130000452741L15/debats1515130000450857151300004508571715130000451643341171059421993DISC_ARTICLES_3_111301358920 (n[[o]] 971) 28920OuiPA721824PM723394-1PM732212
15130000452748L15/debats1515130000450857151300004508571815130000451643341171059424996DISC_ARTICLES_3_111301361325 (n[[o]] 971) 28325OuiPA721824PM723394-1PM732212
15130000452765L15/debats15151300004508571513000045085719151300004516433411710594361006DISC_ARTICLES_3_1113013732663 (n[[o]] 971) 282663OuiPA721824PM723394-1PM732212
15130000452782L15/debats15151300004508571513000045085720151300004516433411710594451013DISC_ARTICLES_3_1113013822664 (n[[o]] 971) 282664OuiPA721824PM723394-1PM732212
15130000452789L15/debats15151300004508571513000045085721151300004516433411710594481016DISC_ARTICLES_3_9_111301385276 (n[[o]] 971) 28276OuiPA721824PM723394-1PM732212
15130000452795L15/debats15151300004508571513000045085722151300004516433411710594501018DISC_ARTICLES_3_1113013871869 (n[[o]] 971) 281869OuiPA721824PM723394-1PM732212
15130000452801L15/debats15151300004508571513000045085723151300004516433411710594521020DISC_ARTICLES_3_1113013892665 (n[[o]] 971) 282665OuiPA721824PM723394-1PM732212
15130000452818L15/debats15151300004508571513000045085724151300004516433411710594651027DISC_ARTICLES_3_1113014021889 (n[[o]] 971) 281889OuiPA721824PM723394-1PM732212
15130000452825L15/debats15151300004508571513000045085725151300004516433411710594681030DISC_ARTICLES_3_9_111301405277 (n[[o]] 971) 28277OuiPA721824PM723394-1PM732212
15130000452831L15/debats15151300004508571513000045085726151300004516433411710594701032DISC_ARTICLES_3_1113014071870 (n[[o]] 971) 281870OuiPA721824PM723394-1PM732212
15130000452837L15/debats15151300004508571513000045085727151300004516433411710594721034DISC_ARTICLES_3_1113014091920 (n[[o]] 971) 281920OuiPA721824PM723394-1PM732212
15130000452843L15/debats15151300004508571513000045085728151300004516433411710594741036DISC_ARTICLES_3_1113014112666 (n[[o]] 971) 282666OuiPA721824PM723394-1PM732212
15130000452861L15/debats15151300004508571513000045085729151300004516433411710594881044DISC_ARTICLES_3_9_111301425318 (n[[o]] 971) 28318OuiPA721824PM723394-1PM732212
15130000452867L15/debats15151300004508571513000045085730151300004516433411710594901046DISC_ARTICLES_3_1113014271871 (n[[o]] 971) 281871OuiPA721824PM723394-1PM732212
15130000452873L15/debats15151300004508571513000045085731151300004516433411710594921048DISC_ARTICLES_3_1113014292839 (n[[o]] 971) 282839OuiPA721824PM723394-1PM732212
15130000452891L15/debats15151300004508571513000045085732151300004516433411710595061056DISC_ARTICLES_3_1113014432887 (n[[o]] 971) 282887OuiPA721824PM723394-1PM732212
15130000452908L15/debats15151300004508571513000045085733151300004516433411710595181066DISC_ARTICLES_3_1113014552667 (n[[o]] 971) 282667OuiPA721824PM723394-1PM732212
15130000452915L15/debats15151300004508571513000045085734151300004516433411710595211069DISC_ARTICLES_3_9_111301458278 (n[[o]] 971) 28278OuiPA721824PM723394-1PM732212
15130000452921L15/debats15151300004508571513000045085735151300004516433411710595231071DISC_ARTICLES_3_1113014601872 (n[[o]] 971) 281872OuiPA721824PM723394-1PM732212
15130000452927L15/debats15151300004508571513000045085736151300004516433411710595251073DISC_ARTICLES_3_1113014622668 (n[[o]] 971) 282668OuiPA721824PM723394-1PM732212
15130000452945L15/debats15151300004508571513000045085737151300004516433411710595391081DISC_ARTICLES_3_9_111301476279 (n[[o]] 971) 28279OuiPA721824PM723394-1PM732212
15130000452952L15/debats15151300004508571513000045085738151300004516433411710595421084DISC_ARTICLES_3_1113014791873 (n[[o]] 971) 281873OuiPA721824PM723394-1PM732212
15130000452958L15/debats15151300004508571513000045085739151300004516433411710595441086DISC_ARTICLES_3_1113014812669 (n[[o]] 971) 282669OuiPA721824PM723394-1PM732212
15130000452976L15/debats15151300004508571513000045085740151300004516433411810595561094DISC_ARTICLES_3_9_111301507320 (n[[o]] 971) 28320OuiPA721824PM723394-1PM732212
15130000452982L15/debats15151300004508571513000045085741151300004516433411810595581096DISC_ARTICLES_3_1113015091874 (n[[o]] 971) 281874OuiPA721824PM723394-1PM732212
15130000452988L15/debats15151300004508571513000045085742151300004516433411810595601098DISC_ARTICLES_3_1113015112840 (n[[o]] 971) 282840OuiPA721824PM723394-1PM732212
15130000453006L15/debats15151300004508571513000045085743151300004516433411810595721106DISC_ARTICLES_3_1113015232253 (n[[o]] 971) 282253OuiPA721824PM723394-1PM732212
15130000453013L15/debats15151300004508571513000045085744151300004516433411810595751109DISC_ARTICLES_3_9_1113015262110 (n[[o]] 971) 282110OuiPA721824PM723394-1PM732212
15130000453019L15/debats15151300004508571513000045085745151300004516433411810595771111DISC_ARTICLES_3_1113015282670 (n[[o]] 971) 282670OuiPA721824PM723394-1PM732212
15130000453026L15/debats15151300004508571513000045085746151300004516433411810595801114DISC_ARTICLES_3_1113015312112 (n[[o]] 971) 282112OuiPA721824PM723394-1PM732212
15130000453048L15/debats15151300004508571513000045085747151300004516433411810595871123DISC_ARTICLES_3_9_1113015382111 (n[[o]] 971) 282111OuiPA721824PM723394-1PM732212
15130000453054L15/debats15151300004508571513000045085748151300004516433411810595891125DISC_ARTICLES_3_1113015402671 (n[[o]] 971) 282671OuiPA721824PM723394-1PM732212
15130000453061L15/debats15151300004508571513000045085749151300004516433411810595941128DISC_ARTICLES_3_9_1113015433207 (n[[o]] 971) 283207OuiPA721824PM723394-1PM732212
15130000453067L15/debats15151300004508571513000045085750151300004516433411810595981130DISC_ARTICLES_3_1113015452672 (n[[o]] 971) 282672OuiPA721824PM723394-1PM732212
15130000453084L15/debats15151300004508571513000045085751151300004516433411810596121137DISC_ARTICLES_3_9_111301552921 (n[[o]] 971) 28921OuiPA721824PM723394-1PM732212
15130000453090L15/debats15151300004508571513000045085752151300004516433411810596181141DISC_ARTICLES_3_1113015562673 (n[[o]] 971) 282673OuiPA721824PM723394-1PM732212
15130000453102L15/debats15151300004508571513000045085753151300004516433411810596301148DISC_ARTICLES_3_9_111301563326 (n[[o]] 971) 28326OuiPA721824PM723394-1PM732212