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
15130000449990L15/debats151513000044936015130000449360241513000044939534191058117407DISC_ARTICLES_3_111299328 2067(n[[o]] 971)25 2067OuiPA721824PM723394-1PM732212
15130000450019L15/debats151513000044936015130000449360251513000044939534191058131420DISC_ARTICLES_3_111299342 2061(n[[o]] 971)25 2061OuiPA721824PM723394-1PM732212
15130000450057L15/debats151513000044936015130000449360261513000044939534191058155443DISC_ARTICLES_3_111299366 2062(n[[o]] 971)25 2062OuiPA721824PM723394-1PM732212
15130000450069L15/debats151513000044936015130000449360271513000044939534191058160448DISC_ARTICLES_3_111299371 2638(n[[o]] 971)25 2638OuiPA721824PM723394-1PM732212
15130000450081L15/debats1515130000449360151300004493602815130000449395341101058502453DISC_ARTICLES_3_111299539 2063(n[[o]] 971)25 2063OuiPA721824PM723394-1PM732212
15130000450093L15/debats1515130000449360151300004493602915130000449395341101058507458DISC_ARTICLES_3_111299544 1844(n[[o]] 971)25 1844OuiPA721824PM723394-1PM732212
15130000450100L15/debats1515130000449360151300004493603015130000449395341101058510461DISC_ARTICLES_3_111299547 2872(n[[o]] 971)25 2872OuiPA721824PM723394-1PM732212
15130000450112L15/debats1515130000449360151300004493603115130000449395341101058515466DISC_ARTICLES_3_111299552 1708(n[[o]] 971)25 1708OuiPA721824PM723394-1PM732212
15130000450126L15/debats1515130000449360151300004493603215130000449395341101058521472DISC_ARTICLES_3_9_111299558 2236(n[[o]] 971)25 2236OuiPA721824PM723394-1PM732212
15130000450132L15/debats1515130000449360151300004493603315130000449395341101058523479DISC_ARTICLES_3_111299560 2064(n[[o]] 971)25 2064OuiPA721824PM723394-1PM732212
15130000450180L15/debats1515130000449360151300004493603415130000449395341101058546505DISC_ARTICLES_3_111299583 1707(n[[o]] 971)25 1707OuiPA721824PM723394-1PM732212
15130000450194L15/debats1515130000449360151300004493603515130000449395341101058551511DISC_ARTICLES_3_111299588 2825(n[[o]] 971)25 2825OuiPA721824PM723394-1PM732212
15130000450201L15/debats1515130000449360151300004493603615130000449395341101058554514DISC_ARTICLES_3_111299591 1346(n[[o]] 971)25 1346OuiPA721824PM723394-1PM732212
15130000450223L15/debats1515130000449360151300004493603715130000449395341111058170527DISC_ARTICLES_3_9_111299629 895(n[[o]] 971)25 895OuiPA721824PM723394-1PM732212
15130000450229L15/debats1515130000449360151300004493603815130000449395341111058173530DISC_ARTICLES_3_111299632 1682(n[[o]] 971)25 1682OuiPA721824PM723394-1PM732212
15130000450235L15/debats1515130000449360151300004493603915130000449395341111058176533DISC_ARTICLES_3_111299635 2066(n[[o]] 971)25 2066OuiPA721824PM723394-1PM732212
15130000450241L15/debats1515130000449360151300004493604015130000449395341111058179536DISC_ARTICLES_3_111299638 2636(n[[o]] 971)25 2636OuiPA721824PM723394-1PM732212
15130000450258L15/debats1515130000449360151300004493604115130000449395341111058189546DISC_ARTICLES_3_111299648 3221(n[[o]] 971)25 3221OuiPA721824PM723394-1PM732212
15130000450280L15/debats1515130000449360151300004493604215130000449395341111058201559DISC_ARTICLES_3_111299660 393(n[[o]] 971)25 393OuiPA721824PM723394-1PM732212
15130000450302L15/debats1515130000449360151300004493604315130000449395341111058211569DISC_ARTICLES_3_111299670 2556(n[[o]] 971)25 2556OuiPA721824PM723394-1PM732212
15130000450309L15/debats1515130000449360151300004493604415130000449395341111058214572DISC_ARTICLES_3_9_111299673 503(n[[o]] 971)25 503OuiPA721824PM723394-1PM732212
15130000450315L15/debats1515130000449360151300004493604515130000449395341111058216574DISC_ARTICLES_3_111299675 896(n[[o]] 971)25 896OuiPA721824PM723394-1PM732212
15130000450321L15/debats1515130000449360151300004493604615130000449395341111058218576DISC_ARTICLES_3_111299677 2424(n[[o]] 971)25 2424OuiPA721824PM723394-1PM732212
15130000450327L15/debats1515130000449360151300004493604715130000449395341121058426578DISC_ARTICLES_3_111299907 2637(n[[o]] 971)25 2637OuiPA721824PM723394-1PM732212
15130000450334L15/debats1515130000449360151300004493604815130000449395341121058429581DISC_ARTICLES_3_111299910 2068(n[[o]] 971)25 2068OuiPA721824PM723394-1PM732212
15130000450341L15/debats1515130000449360151300004493604915130000449395341121058433584DISC_ARTICLES_3_9_111299914 323(n[[o]] 971)25 323OuiPA721824PM723394-1PM732212
15130000450351L15/debats1515130000449360151300004493605015130000449395341121058437590DISC_ARTICLES_3_111299918 777(n[[o]] 971)25 777OuiPA721824PM723394-1PM732212
15130000450392L15/debats1515130000449360151300004493605115130000449395341121058465618DISC_ARTICLES_3_9_111299946 1106(n[[o]] 971)25 1106OuiPA721824PM723394-1PM732212
15130000450398L15/debats1515130000449360151300004493605215130000449395341121058469623DISC_ARTICLES_3_111299950 1448(n[[o]] 971)25 1448OuiPA721824PM723394-1PM732212
15130000450404L15/debats1515130000449360151300004493605315130000449395341121058471625DISC_ARTICLES_3_111299952 2581(n[[o]] 971)25 2581OuiPA721824PM723394-1PM732212
15130000450430L15/debats1515130000449360151300004493605415130000449395341121058483637DISC_ARTICLES_3_9_111299964 975(n[[o]] 971)25 975OuiPA721824PM723394-1PM732212
15130000450436L15/debats1515130000449360151300004493605515130000449395341121058485639DISC_ARTICLES_3_111299966 976(n[[o]] 971)25 976OuiPA721824PM723394-1PM732212
15130000450442L15/debats1515130000449360151300004493605615130000449395341121058487641DISC_ARTICLES_3_111299968 1185(n[[o]] 971)25 1185OuiPA721824PM723394-1PM732212
15130000450448L15/debats1515130000449360151300004493605715130000449395341121058489643DISC_ARTICLES_3_111299970 2070(n[[o]] 971)25 2070OuiPA721824PM723394-1PM732212
15130000450454L15/debats1515130000449360151300004493605815130000449395341121058493647DISC_ARTICLES_3_111299974 977(n[[o]] 971)25 977OuiPA721824PM723394-1PM732212
15130000450460L15/debats1515130000449360151300004493605915130000449395341121058495649DISC_ARTICLES_3_111299976 1683(n[[o]] 971)25 1683OuiPA721824PM723394-1PM732212
15130000450466L15/debats1515130000449360151300004493606015130000449395341121058497651DISC_ARTICLES_3_111299978 322(n[[o]] 971)25 322OuiPA721824PM723394-1PM732212
15130000450472L15/debats1515130000449360151300004493606115130000449395341131058348658DISC_ARTICLES_3_111300002 2071(n[[o]] 971)25 2071OuiPA721824PM723394-1PM732212
15130000450489L15/debats1515130000449360151300004493606215130000449395341131058358667DISC_ARTICLES_3_111300012 1992(n[[o]] 971)25 1992OuiPA721824PM723394-1PM732212
15130000450506L15/debats1515130000449360151300004493606315130000449395341131058365674DISC_ARTICLES_3_111300019 739(n[[o]] 971)25 739OuiPA721824PM723394-1PM732212
15130000450513L15/debats1515130000449360151300004493606415130000449395341131058369678DISC_ARTICLES_3_111300023 2562(n[[o]] 971)25 2562OuiPA721824PM723394-1PM732212
15130000450520L15/debats1515130000449360151300004493606515130000449395341131058372681DISC_ARTICLES_3_9_111300026 978(n[[o]] 971)25 978OuiPA721824PM723394-1PM732212
15130000450526L15/debats1515130000449360151300004493606615130000449395341131058375684DISC_ARTICLES_3_111300029 1364(n[[o]] 971)25 1364OuiPA721824PM723394-1PM732212
15130000450532L15/debats1515130000449360151300004493606715130000449395341131058377686DISC_ARTICLES_3_111300031 979(n[[o]] 971)25 979OuiPA721824PM723394-1PM732212
15130000450538L15/debats1515130000449360151300004493606815130000449395341131058379688DISC_ARTICLES_3_111300033 1366(n[[o]] 971)25 1366OuiPA721824PM723394-1PM732212
15130000450555L15/debats1515130000449360151300004493606915130000449395341131058386695DISC_ARTICLES_3_111300040 1052(n[[o]] 971)25 1052OuiPA721824PM723394-1PM732212
15130000450562L15/debats1515130000449360151300004493607015130000449395341131058389698DISC_ARTICLES_3_111300043 1053(n[[o]] 971)25 1053OuiPA721824PM723394-1PM732212
15130000450569L15/debats1515130000449360151300004493607115130000449395341131058392701DISC_ARTICLES_3_9_111300046 324(n[[o]] 971)25 324OuiPA721824PM723394-1PM732212
15130000450575L15/debats1515130000449360151300004493607215130000449395341131058394703DISC_ARTICLES_3_111300048 899(n[[o]] 971)25 899OuiPA721824PM723394-1PM732212
15130000450581L15/debats1515130000449360151300004493607315130000449395341131058396705DISC_ARTICLES_3_111300050 2639(n[[o]] 971)25 2639OuiPA721824PM723394-1PM732212