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
17130000338312L17/debats17171300003375091713000033750911713000033827725182995911494DISC_ARTICLES_4_5014150968 1035 (n[[o]] 2984) 2 839 1035OuiPA720468PM8403330PM873246
17130000338340L17/debats17171300003375091713000033750921713000033827725182995922510DISC_ARTICLES_4_5014150979 961 (n[[o]] 2984) 2 839 961OuiPA720468PM8403330PM873246
17130000338358L17/debats17171300003375091713000033750931713000033827725182995932520DISC_ARTICLES_4_5014150989 962 (n[[o]] 2984) 2 839 962OuiPA720468PM8403330PM873246
17130000338368L17/debats17171300003375091713000033750941713000033827725182995936526DISC_ARTICLES_4_5014150993 963 (n[[o]] 2984) 2 839 963OuiPA720468PM8403330PM873246
17130000338378L17/debats17171300003375091713000033750951713000033827725192996090534DISC_ARTICLES_4_5014151894 964 (n[[o]] 2984) 2 839 964OuiPA720468PM8403330PM873246
17130000338388L17/debats17171300003375091713000033750961713000033827725192996097541DISC_ARTICLES_4_5014151901 965 (n[[o]] 2984) 2 839 965OuiPA720468PM8403330PM873246
17130000338394L17/debats17171300003375091713000033750971713000033827725192996102547DISC_ARTICLES_4_5014151906 966 (n[[o]] 2984) 2 839 966OuiPA720468PM8403330PM873246
17130000338410L17/debats17171300003375091713000033750981713000033827725192996110556DISC_ARTICLES_4_5014151914 967 (n[[o]] 2984) 2 839 967OuiPA720468PM8403330PM873246
17130000338420L17/debats17171300003375091713000033750991713000033827725192996114563DISC_ARTICLES_4_5014151918 968 (n[[o]] 2984) 2 839 968OuiPA720468PM8403330PM873246
17130000338426L17/debats171713000033750917130000337509101713000033827725192996119568DISC_ARTICLES_4_5014151923 969 (n[[o]] 2984) 2 839 969OuiPA720468PM8403330PM873246
17130000338432L17/debats171713000033750917130000337509111713000033827725192996124573DISC_ARTICLES_4_5014151928 970 (n[[o]] 2984) 2 839 970OuiPA720468PM8403330PM873246
17130000338450L17/debats1717130000337509171300003375091217130000338277251102995837583DISC_ARTICLES_4_5014150887 971 (n[[o]] 2984) 2 839 971OuiPA720468PM8403330PM873246
17130000338456L17/debats1717130000337509171300003375091317130000338277251102995841588DISC_ARTICLES_4_5014150891 972 (n[[o]] 2984) 2 839 972OuiPA720468PM8403330PM873246
17130000338466L17/debats1717130000337509171300003375091417130000338277251102995847594DISC_ARTICLES_4_114150897 1021 (n[[o]] 2984) 2 839 1021OuiPA720468PM8403330PM873246
17130000338472L17/debats1717130000337509171300003375091517130000338277251102995850597DISC_ARTICLES_4_5014150900 1042 (n[[o]] 2984) 2 839 1042OuiPA720468PM8403330PM873246
17130000338482L17/debats1717130000337509171300003375091617130000338277251102995854603DISC_ARTICLES_4_114150904 987 (n[[o]] 2984) 2 839 987OuiPA720468PM8403330PM873246
17130000338488L17/debats1717130000337509171300003375091717130000338277251102995858607DISC_ARTICLES_4_5014150908 997 (n[[o]] 2984) 2 839 997OuiPA720468PM8403330PM873246
17130000338494L17/debats1717130000337509171300003375091817130000338277251102995860609DISC_ARTICLES_4_5014150910 1075 (n[[o]] 2984) 2 839 1075OuiPA720468PM8403330PM873246
17130000338514L17/debats1717130000337509171300003375091917130000338277251102995868620DISC_ARTICLES_4_5014150918 984 (n[[o]] 2984) 2 839 984OuiPA720468PM8403330PM873246
17130000338520L17/debats1717130000337509171300003375092017130000338277251112996051623DISC_ARTICLES_4_5014152701 1022 (n[[o]] 2984) 2 839 1022OuiPA720468PM8403330PM873246
17130000338528L17/debats1717130000337509171300003375092117130000338277251112996054626DISC_ARTICLES_4_5014152886 1043 (n[[o]] 2984) 2 839 1043OuiPA720468PM840333-1PM873246
17130000338534L17/debats1717130000337509171300003375092217130000338277251112996058630DISC_ARTICLES_4_5014152708 1077 (n[[o]] 2984) 2 839 1077OuiPA720468PM8403330PM873246
17130000338545L17/debats1717130000337509171300003375092317130000338277251112996062636DISC_ARTICLES_4_5014152712 998 (n[[o]] 2984) 2 839 998OuiPA720468PM8403330PM873246
17130000338585L17/debats171713000033750917130000337509117130000338575451122996029664DISC_ARTICLES_4_5014152974 1044 (n[[o]] 2984) 2 839 1044OuiPA720468PM8403330PM873246
17130000338591L17/debats171713000033750917130000337509217130000338575451122996031666DISC_ARTICLES_4_5014152976 1059 (n[[o]] 2984) 2 839 1059OuiPA720468PM8403330PM873246
17130000338597L17/debats171713000033750917130000337509317130000338575451122996033668DISC_ARTICLES_4_5014152978 1001 (n[[o]] 2984) 2 839 1001OuiPA720468PM8403330PM873246
17130000338611L17/debats171713000033750917130000337509417130000338575451122996039675DISC_ARTICLES_4_114152984 1024 (n[[o]] 2984) 2 839 1024OuiPA720468PM8403330PM873246
17130000338629L17/debats171713000033750917130000337509517130000338575451122996045683DISC_ARTICLES_4_5014152990 1045 (n[[o]] 2984) 2 839 1045OuiPA720468PM8403330PM873246
17130000338635L17/debats171713000033750917130000337509617130000338575451122996047686DISC_ARTICLES_4_5014152992 1046 (n[[o]] 2984) 2 839 1046OuiPA720468PM8403330PM873246
17130000338641L17/debats171713000033750917130000337509717130000338575451122996049688DISC_ARTICLES_4_5014152994 1049 (n[[o]] 2984) 2 839 1049OuiPA720468PM8403330PM873246
17130000338647L17/debats171713000033750917130000337509817130000338575451132996129690DISC_ARTICLES_4_5014153299 1004 (n[[o]] 2984) 2 839 1004OuiPA720468PM8403330PM873246
17130000338653L17/debats171713000033750917130000337509917130000338575451132996131692DISC_ARTICLES_4_5014153301 1026 (n[[o]] 2984) 2 839 1026OuiPA720468PM8403330PM873246
17130000338659L17/debats1717130000337509171300003375091017130000338575451132996133694DISC_ARTICLES_4_5014153303 973 (n[[o]] 2984) 2 839 973OuiPA720468PM8403330PM873246
17130000338665L17/debats1717130000337509171300003375091117130000338575451132996137700DISC_ARTICLES_4_5014153307 1027 (n[[o]] 2984) 2 839 1027OuiPA720468PM8403330PM873246
17130000338673L17/debats1717130000337509171300003375091217130000338575451132996140705DISC_ARTICLES_4_5014153310 974 (n[[o]] 2984) 2 839 974OuiPA720468PM8403330PM873246
17130000338695L17/debats1717130000337509171300003375091317130000338575451132996153718DISC_ARTICLES_4_5014153323 988 (n[[o]] 2984) 2 839 988OuiPA720468PM8403330PM873246
17130000338701L17/debats1717130000337509171300003375091417130000338575451132996155720DISC_ARTICLES_4_5014153325 1003 (n[[o]] 2984) 2 839 1003OuiPA720468PM8403330PM873246
17130000338707L17/debats1717130000337509171300003375091517130000338575451132996157722DISC_ARTICLES_4_5014153832 1025 (n[[o]] 2984) 2 839 1025OuiPA720468PM840333-1PM873246
17130000338713L17/debats1717130000337509171300003375091617130000338575451132996158724DISC_ARTICLES_4_5014153328 975 (n[[o]] 2984) 2 839 975OuiPA720468PM8403330PM873246
17130000338719L17/debats1717130000337509171300003375091717130000338575451132996161728DISC_ARTICLES_4_5014153331 976 (n[[o]] 2984) 2 839 976OuiPA720468PM8403330PM873246
17130000338729L17/debats1717130000337509171300003375091817130000338575451132996165734DISC_ARTICLES_4_5014153335 1000 (n[[o]] 2984) 2 839 1000OuiPA720468PM8403330PM873246
17130000338735L17/debats1717130000337509171300003375091917130000338575451132996167736DISC_ARTICLES_4_5014153337 1073 (n[[o]] 2984) 2 839 1073OuiPA720468PM8403330PM873246
17130000338753L17/debats1717130000337509171300003375092017130000338575451142996588745DISC_ARTICLES_4_1141516821028 (n[[o]] 2984) 2 8391028OuiPA720468PM8403330PM873246
17130000338759L17/debats1717130000337509171300003375092117130000338575451142996590747DISC_ARTICLES_4_5014151684 1047 (n[[o]] 2984) 2 839 1047OuiPA720468PM8403330PM873246
17130000338779L17/debats1717130000337509171300003375092217130000338575451142996602759DISC_ARTICLES_4_5014151696 1030 (n[[o]] 2984) 2 839 1030OuiPA720468PM8403330PM873246
17130000338801L17/debats1717130000337509171300003375092317130000338575451142996612769DISC_ARTICLES_4_5014151706 1048 (n[[o]] 2984) 2 839 1048OuiPA720468PM8403330PM873246
17130000338807L17/debats1717130000337509171300003375092417130000338575451142996615772DISC_ARTICLES_4_114151709 977 (n[[o]] 2984) 2 839 977OuiPA720468PM8403330PM873246
17130000338813L17/debats1717130000337509171300003375092517130000338575451142996618775DISC_ARTICLES_4_5014151712 1002 (n[[o]] 2984) 2 839 1002OuiPA720468PM8403330PM873246
17130000338827L17/debats1717130000337509171300003375092617130000338575451142996624781DISC_ARTICLES_4_5014151718 1031 (n[[o]] 2984) 2 839 1031OuiPA720468PM8403330PM873246
17130000338837L17/debats1717130000337509171300003375092717130000338575451142996628785DISC_ARTICLES_4_5014151722 1058 (n[[o]] 2984) 2 839 1058OuiPA720468PM8403330PM873246