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
15130000497941L15/debats1515130000496157151300004961571815130000497773241121087057862DISC_ARTICLES_3_111336343328(n[[o]] 1019)19328OuiPA1874PM722598-1PM747739
15130000497948L15/debats1515130000496157151300004961571915130000497773241121087061866DISC_ARTICLES_3_1113363471455(n[[o]] 1019)191455OuiPA1874PM722598-1PM747739
15130000497955L15/debats1515130000496157151300004961572015130000497773241121087064869DISC_ARTICLES_3_9_1113363501347(n[[o]] 1019)191347OuiPA1874PM722598-1PM747739
15130000497961L15/debats1515130000496157151300004961572115130000497773241121087068873DISC_ARTICLES_3_111336354439(n[[o]] 1019)19439OuiPA1874PM722598-1PM747739
15130000497967L15/debats1515130000496157151300004961572215130000497773241121087070875DISC_ARTICLES_3_111336356333(n[[o]] 1019)19333OuiPA1874PM722598-1PM747739
15130000497973L15/debats1515130000496157151300004961572315130000497773241121087072877DISC_ARTICLES_3_111336358902(n[[o]] 1019)19902OuiPA1874PM722598-1PM747739
15130000497990L15/debats1515130000496157151300004961572415130000497773241121087079884DISC_ARTICLES_3_1113363651498(n[[o]] 1019)191498OuiPA1874PM722598-1PM747739
15130000498018L15/debats1515130000496157151300004961572515130000497773241121087091896DISC_ARTICLES_3_1113363771572(n[[o]] 1019)191572OuiPA1874PM722598-1PM747739
15130000498025L15/debats1515130000496157151300004961572615130000497773241121087095900DISC_ARTICLES_3_1113363811002(n[[o]] 1019)191002OuiPA1874PM722598-1PM747739
15130000498030L15/debats1515130000496157151300004961572715130000497773241121087097902DISC_ARTICLES_3_111336383181(n[[o]] 1019)19181OuiPA1874PM722598-1PM747739
15130000498037L15/debats1515130000496157151300004961572815130000497773241121087100905DISC_ARTICLES_3_111336386182(n[[o]] 1019)19182OuiPA1874PM722598-1PM747739
15130000498044L15/debats1515130000496157151300004961572915130000497773241121087103908DISC_ARTICLES_3_111336389183(n[[o]] 1019)19183OuiPA1874PM722598-1PM747739
15130000498051L15/debats1515130000496157151300004961573015130000497773241121087106911DISC_ARTICLES_3_111336392593(n[[o]] 1019)19593OuiPA1874PM722598-1PM747739
15130000498058L15/debats1515130000496157151300004961573115130000497773241121087109914DISC_ARTICLES_3_1113363951447(n[[o]] 1019)191447OuiPA1874PM722598-1PM747739
15130000498065L15/debats1515130000496157151300004961573215130000497773241121087112917DISC_ARTICLES_3_1113363981778(n[[o]] 1019)191778OuiPA1874PM722598-1PM747739
15130000498072L15/debats1515130000496157151300004961573315130000497773241121087115920DISC_ARTICLES_3_1113364011785(n[[o]] 1019)191785OuiPA1874PM722598-1PM747739
15130000498079L15/debats1515130000496157151300004961573415130000497773241121087118923DISC_ARTICLES_3_1113364041779(n[[o]] 1019)191779OuiPA1874PM722598-1PM747739
15130000498086L15/debats1515130000496157151300004961573515130000497773241121087121926DISC_ARTICLES_3_111336407184(n[[o]] 1019)19184OuiPA1874PM722598-1PM747739
15130000498098L15/debats1515130000496157151300004961573615130000497773241121087127932DISC_ARTICLES_3_1113364131546(n[[o]] 1019)191546OuiPA1874PM722598-1PM747739
15130000498113L15/debats151513000049615715130000496157115130000498105351121087138943DISC_ARTICLES_4_50113364242230(n[[o]] 1019)1918402230OuiPA1874PM722598-1PM747739
15130000498119L15/debats151513000049615715130000496157215130000498105351121087140945DISC_ARTICLES_4_50113364262237(n[[o]] 1019)1918402237OuiPA1874PM722598-1PM747739
15130000498105L15/debats1515130000496157151300004961573715130000497773241121087132937DISC_ARTICLES_3_1113364181840(n[[o]] 1019)191840OuiPA1874PM722598-1PM747739
15130000498125L15/debats1515130000496157151300004961573815130000497773241121087142947DISC_ARTICLES_3_1113364281637(n[[o]] 1019)191637OuiPA1874PM722598-1PM747739
15130000498131L15/debats1515130000496157151300004961573915130000497773241121087144949DISC_ARTICLES_3_111336430425(n[[o]] 1019)19425OuiPA1874PM722598-1PM747739
15130000498137L15/debats1515130000496157151300004961574015130000497773241121087147952DISC_ARTICLES_3_111336433550(n[[o]] 1019)19550OuiPA1874PM722598-1PM747739
15130000498143L15/debats1515130000496157151300004961574115130000497773241131086621955DISC_ARTICLES_3_111336502532(n[[o]] 1019)19532OuiPA1874PM722598-1PM747739
15130000498152L15/debats1515130000496157151300004961574215130000497773241131086625959DISC_ARTICLES_3_1113365061799(n[[o]] 1019)191799OuiPA1874PM722598-1PM747739
15130000498158L15/debats1515130000496157151300004961574315130000497773241131086627961DISC_ARTICLES_3_1113365081545(n[[o]] 1019)191545OuiPA1874PM722598-1PM747739
15130000498182L15/debats1515130000496157151300004961574415130000497773241131086638972DISC_ARTICLES_3_1113365191164(n[[o]] 1019)191164OuiPA1874PM722598-1PM747739
15130000498189L15/debats1515130000496157151300004961574515130000497773241131086641975DISC_ARTICLES_3_1113365221692(n[[o]] 1019)191692OuiPA1874PM722598-1PM747739
15130000498211L15/debats1515130000496157151300004961574615130000497773241131086650984DISC_ARTICLES_3_111336531268(n[[o]] 1019)19268OuiPA1874PM722598-1PM747739
15130000498218L15/debats1515130000496157151300004961574715130000497773241131086653987DISC_ARTICLES_3_9_111336534709(n[[o]] 1019)19709OuiPA1874PM722598-1PM747739
15130000498224L15/debats1515130000496157151300004961574815130000497773241131086655989DISC_ARTICLES_3_1113365361504(n[[o]] 1019)191504OuiPA1874PM722598-1PM747739
15130000498236L15/debats1515130000496157151300004961574915130000497773241131086660994DISC_ARTICLES_3_1113365412182(n[[o]] 1019)192182OuiPA1874PM722598-1PM747739
15130000498243L15/debats1515130000496157151300004961575015130000497773241131086663997DISC_ARTICLES_3_1113365442177(n[[o]] 1019)192177OuiPA1874PM722598-1PM747739
15130000498265L15/debats15151300004961571513000049615751151300004977732411310866721006DISC_ARTICLES_3_9_1113365534, 3 et 2(n[[o]] 1019)194, 3 et 2OuiPA1874PM722598-1PM747739
15130000498272L15/debats15151300004961571513000049615752151300004977732411310866751009DISC_ARTICLES_3_9_111336556393(n[[o]] 1019)19393OuiPA1874PM722598-1PM747739
15130000498278L15/debats15151300004961571513000049615753151300004977732411310866781012DISC_ARTICLES_3_111336559533(n[[o]] 1019)19533OuiPA1874PM722598-1PM747739
15130000498284L15/debats15151300004961571513000049615754151300004977732411310866801014DISC_ARTICLES_3_111336561922(n[[o]] 1019)19922OuiPA1874PM722598-1PM747739
15130000498290L15/debats15151300004961571513000049615755151300004977732411310866821016DISC_ARTICLES_3_1113365631348(n[[o]] 1019)191348OuiPA1874PM722598-1PM747739
15130000498302L15/debats15151300004961571513000049615756151300004977732411310866871021DISC_ARTICLES_3_111336568402(n[[o]] 1019)19402OuiPA1874PM722598-1PM747739
15130000498309L15/debats15151300004961571513000049615757151300004977732411310866901024DISC_ARTICLES_3_9_1113365711510(n[[o]] 1019)191510OuiPA1874PM722598-1PM747739
15130000498315L15/debats15151300004961571513000049615758151300004977732411310866921026DISC_ARTICLES_3_1113365731191(n[[o]] 1019)191191OuiPA1874PM722598-1PM747739
15130000498328L15/debats15151300004961571513000049615759151300004977732411410868341032DISC_ARTICLES_3_9_1113368811835(n[[o]] 1019)191835OuiPA1874PM722598-1PM747739
15130000498334L15/debats15151300004961571513000049615760151300004977732411410868361034DISC_ARTICLES_3_1113368831978(n[[o]] 1019)191978OuiPA1874PM722598-1PM747739
15130000498340L15/debats15151300004961571513000049615761151300004977732411410868381036DISC_ARTICLES_3_1113368852127(n[[o]] 1019)192127OuiPA1874PM722598-1PM747739
15130000498352L15/debats15151300004961571513000049615762151300004977732411410868431041DISC_ARTICLES_3_1113368901349(n[[o]] 1019)191349OuiPA1874PM722598-1PM747739
15130000498359L15/debats15151300004961571513000049615763151300004977732411410868461044DISC_ARTICLES_3_111336893438(n[[o]] 1019)19438OuiPA1874PM722598-1PM747739
15130000498371L15/debats15151300004961571513000049615764151300004977732411410868511049DISC_ARTICLES_3_1113368981522(n[[o]] 1019)191522OuiPA1874PM722598-1PM747739
15130000498378L15/debats15151300004961571513000049615765151300004977732411410868561054DISC_ARTICLES_3_111336903926(n[[o]] 1019)19926OuiPA1874PM722598-1PM747739