AN · données ouvertes
Explorateur / debats

debats.compte_rendu_point

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

159 557 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
16130000101245L16/debats16161300001003271613000010032711613000010123414392349740523DISC_ARTICLES_3_3013224818 397 (n[[o]] 1673) 2OuiPA720468PM796983-1PM801153
16130000101250L16/debats16161300001003271613000010032721613000010123414392349742525DISC_ARTICLES_3_113224820 1823 (n[[o]] 1673) 2 1823OuiPA720468PM796983-1PM801153
16130000101278L16/debats16161300001003271613000010032731613000010123414392349755538DISC_ARTICLES_3_113224833 1291 (n[[o]] 1673) 2 1291OuiPA720468PM796983-1PM801153
16130000101295L16/debats16161300001003271613000010032741613000010123414392349762545DISC_ARTICLES_3_113224840 1358 (n[[o]] 1673) 2 1358OuiPA720468PM796983-1PM801153
16130000101323L16/debats16161300001003271613000010032751613000010123414392349776559DISC_ARTICLES_3_113224854 638 (n[[o]] 1673) 2 638OuiPA720468PM796983-1PM801153
16130000101335L16/debats16161300001003271613000010032761613000010123414392349781564DISC_ARTICLES_3_113224859 496 (n[[o]] 1673) 2 496OuiPA720468PM796983-1PM801153
16130000101356L16/debats16161300001003271613000010032771613000010123414392349790575DISC_ARTICLES_3_113224868 537 (n[[o]] 1673) 2 537OuiPA720468PM796983-1PM801153
16130000101368L16/debats16161300001003271613000010032781613000010123414392349795580DISC_ARTICLES_3_113224873 497 (n[[o]] 1673) 2 497OuiPA720468PM796983-1PM801153
16130000101398L16/debats161613000010032716130000100327916130000101234143102349804593DISC_ARTICLES_3_9_113225075 512 (n[[o]] 1673) 2 512OuiPA720468PM796983-1PM801153
16130000101404L16/debats1616130000100327161300001003271016130000101234143102349806595DISC_ARTICLES_3_113225077 1145 (n[[o]] 1673) 2 1145OuiPA720468PM796983-1PM801153
16130000101412L16/debats1616130000100327161300001003271116130000101234143102349810599DISC_ARTICLES_3_113225081 203 (n[[o]] 1673) 2 203OuiPA720468PM796983-1PM801153
16130000101468L16/debats1616130000100327161300001003271216130000101234143102349838629DISC_ARTICLES_3_113225109 166 (n[[o]] 1673) 2 166OuiPA720468PM796983-1PM801153
16130000101494L16/debats1616130000100327161300001003271316130000101234143102349852643DISC_ARTICLES_3_9_113225123 204, 205 et 206 (n[[o]] 1673) 2 204, 205 et 206OuiPA720468PM796983-1PM801153
16130000101550L16/debats1616130000100327161300001003271416130000101234143112349929676DISC_ARTICLES_3_113225341 1730 (n[[o]] 1673) 2 1730OuiPA720468PM796983-1PM801153
16130000101562L16/debats1616130000100327161300001003271516130000101234143112349937684DISC_ARTICLES_3_113225349 375 (n[[o]] 1673) 2 375OuiPA720468PM796983-1PM801153
16130000101581L16/debats1616130000100327161300001003271616130000101234143112349946693DISC_ARTICLES_3_113225358 48 (n[[o]] 1673) 2 48OuiPA720468PM796983-1PM801153
16130000101620L16/debats1616130000100327161300001003271716130000101234143112349965714DISC_ARTICLES_3_113225377 538 (n[[o]] 1673) 2 538OuiPA720468PM796983-1PM801153
16130000101626L16/debats1616130000100327161300001003271816130000101234143122349875717DISC_ARTICLES_3_113225477 1146 (n[[o]] 1673) 2 1146OuiPA720468PM796983-1PM801153
16130000101636L16/debats1616130000100327161300001003271916130000101234143122349882724DISC_ARTICLES_3_113225484 1731 (n[[o]] 1673) 2 1731OuiPA720468PM796983-1PM801153
16130000101669L16/debats1616130000100327161300001003272016130000101234143122349903745DISC_ARTICLES_3_9_113225505 207 (n[[o]] 1673) 2 207OuiPA720468PM796983-1PM801153
16130000101675L16/debats1616130000100327161300001003272116130000101234143122349907749DISC_ARTICLES_3_113225510 539 (n[[o]] 1673) 2 539OuiPA720468PM796983-1PM801153
16130000101730L16/debats161613000010032716130000100327116130000101722343142350047782DISC_ARTICLES_3_113224887 1361 (n[[o]] 1673) 2 1361OuiPA720468PM796983-1PM801153
16130000101780L16/debats161613000010032716130000100327216130000101722343142350106814DISC_ARTICLES_3_9_113224920 168 (n[[o]] 1673) 2 168OuiPA720468PM796983-1PM801153
16130000101798L16/debats161613000010032716130000100327316130000101722343142350122823DISC_ARTICLES_3_3013224929 260 (n[[o]] 1673) 2 168OuiPA720468PM796983-1PM801153
16130000101870L16/debats161613000010032716130000100327416130000101722343152350176863DISC_ARTICLES_3_113224969 172 (n[[o]] 1673) 2 172OuiPA720468PM796983-1PM801153
16130000101892L16/debats161613000010032716130000100327516130000101722343152350185872DISC_ARTICLES_3_9_113224978 377 (n[[o]] 1673) 2 377OuiPA720468PM796983-1PM801153
16130000101900L16/debats161613000010032716130000100327616130000101722343152350189877DISC_ARTICLES_3_113224982 500 (n[[o]] 1673) 2 500OuiPA720468PM796983-1PM801153
16130000101945L16/debats161613000010032716130000100327716130000101722343152350212901DISC_ARTICLES_3_113225005 398 (n[[o]] 1673) 2 398OuiPA720468PM796983-1PM801153
16130000101952L16/debats161613000010032716130000100327816130000101722343152350215904DISC_ARTICLES_3_113225008 554 (n[[o]] 1673) 2 554OuiPA720468PM796983-1PM801153
16130000101984L16/debats161613000010032716130000100327916130000101722343162350230920DISC_ARTICLES_3_113225023 1364 (n[[o]] 1673) 2 1364OuiPA720468PM796983-1PM801153
16130000102023L16/debats1616130000100327161300001003271016130000101722343162350248939DISC_ARTICLES_3_113225041 1734 (n[[o]] 1673) 2 1734OuiPA720468PM796983-1PM801153
16130000102067L16/debats1616130000100327161300001003271116130000101722343162350272963DISC_ARTICLES_3_113225065 1156 (n[[o]] 1673) 2 1156OuiPA720468PM796983-1PM801153
16130000102079L16/debats1616130000100327161300001003271216130000101722343172350429970DISC_ARTICLES_3_9_113225527 173 (n[[o]] 1673) 2 173OuiPA720468PM796983-1PM801153
16130000102091L16/debats1616130000100327161300001003271316130000101722343172350434975DISC_ARTICLES_3_113225532 400 (n[[o]] 1673) 2 400OuiPA720468PM796983-1PM801153
16130000102109L16/debats1616130000100327161300001003271416130000101722343172350443985DISC_ARTICLES_3_113225541 581 (n[[o]] 1673) 2 581OuiPA720468PM796983-1PM801153
16130000102127L16/debats1616130000100327161300001003271516130000101722343172350451993DISC_ARTICLES_3_113225549 803 (n[[o]] 1673) 2 803OuiPA720468PM796983-1PM801153
16130000102133L16/debats1616130000100327161300001003271616130000101722343172350453995DISC_ARTICLES_3_113225551 1365 (n[[o]] 1673) 2 1365OuiPA720468PM796983-1PM801153
16130000102379L16/debats1616130000100327161300001003271161300001023534531923503701128DISC_ARTICLES_4_5013225684 1851 (n[[o]] 1673) 2 183 1851OuiPA720468PM796983-1PM801153
16130000102393L16/debats1616130000100327161300001003272161300001023534531923503771135DISC_ARTICLES_4_5013225691 1842 (n[[o]] 1673) 2 183 1842OuiPA720468PM796983-1PM801153
16130000102399L16/debats1616130000100327161300001003273161300001023534531923503811139DISC_ARTICLES_4_5013225695 1849 (n[[o]] 1673) 2 183 1849OuiPA720468PM796983-1PM801153
16130000102405L16/debats1616130000100327161300001003274161300001023534531923503831141DISC_ARTICLES_4_5013225697 1841 (n[[o]] 1673) 2 183 1841OuiPA720468PM796983-1PM801153
16130000102411L16/debats1616130000100327161300001003275161300001023534531923503851143DISC_ARTICLES_4_5013225699 1850 (n[[o]] 1673) 2 183 1850OuiPA720468PM796983-1PM801153
16130000102417L16/debats1616130000100327161300001003276161300001023534532023503891147DISC_ARTICLES_4_5013225703 1854 (n[[o]] 1673) 2 183 1854OuiPA720468PM796983-1PM801153
16130000102423L16/debats1616130000100327161300001003277161300001023534532023503911149DISC_ARTICLES_4_113226105 1844 (n[[o]] 1673) 2 183 1844OuiPA720468PM796983-1PM801153
16130000102441L16/debats1616130000100327161300001003278161300001023534532023504031160DISC_ARTICLES_4_5013225717 1852 (n[[o]] 1673) 2 183 1852OuiPA720468PM796983-1PM801153
16130000102447L16/debats1616130000100327161300001003279161300001023534532023504071164DISC_ARTICLES_4_113226170 1845 (n[[o]] 1673) 2 183 1845OuiPA720468PM796983-1PM801153
16130000102453L16/debats16161300001003271613000010032710161300001023534532023504101167DISC_ARTICLES_4_5013225724 1848 (n[[o]] 1673) 2 183 1848OuiPA720468PM796983-1PM801153
16130000102459L16/debats16161300001003271613000010032711161300001023534532023504131170DISC_ARTICLES_4_5013225727 1843 (n[[o]] 1673) 2 183 1843OuiPA720468PM796983-1PM801153
16130000102465L16/debats16161300001003271613000010032712161300001023534532023504171174DISC_ARTICLES_4_3013225731 1853 (n[[o]] 1673) 2 183 1843OuiPA720468PM796983-1PM801153
16130000102353L16/debats16161300001003271613000010032717161300001017223431923503551113DISC_ARTICLES_3_9_113225669 183 (n[[o]] 1673) 2 183OuiPA720468PM796983-1PM801153