AN · données ouvertes
Explorateur / dossiers

dossiers.dossier_parlementaire_acte_legislatif_texte_associe

Chemin dossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 %

5 606 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)
9type_texteVARCHARdossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie.typeTexte · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 %
10ref_texte_associeVARCHARdossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie.refTexteAssocie · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordre_parent_recursif_id_niveautype_texteref_texte_associe
17060000134193L17/dossiers17170600001341761706000013419122TAPPIONANR5L17TAP0126
17060000134204L17/dossiers17170600001341761706000013420312BTAPIONSNR5S479BTA0006
17060000134227L17/dossiers17170600001342141706000013422612BTAPIONSNR5S459BTA0141
17060000134283L17/dossiers17170600001342681706000013428212BTAPIONANR5L17BTA0135
17060000134284L17/dossiers17170600001342681706000013428222TAPPIONANR5L17TAP0135
17060000134312L17/dossiers17170600001342971706000013431112BTAPIONANR5L17BTA0308
17060000134313L17/dossiers17170600001342971706000013431122TAPPIONANR5L17TAP0308
17060000134350L17/dossiers17170600001343341706000013434912BTAPIONSNR5S479BTA0057
17060000134370L17/dossiers17170600001343561706000013436912BTAPRJLSNR5S459BTA0129
17060000134394L17/dossiers17170600001343561706000013439312BTAPRJLANR5L17BTA0155
17060000134395L17/dossiers17170600001343561706000013439322TAPPRJLANR5L17TAP0155
17060000134410L17/dossiers17170600001343561706000013440912BTAPRJLANR5L17BTA0165
17060000134411L17/dossiers17170600001343561706000013440922TAPPRJLANR5L17TAP0165
17060000134414L17/dossiers17170600001343561706000013441312BTARAPPSNR5S459BTA0173
17060000134435L17/dossiers17170600001344211706000013443412BTAPRJLSNR5S459BTA0128
17060000134476L17/dossiers17170600001344211706000013447512BTAPRJLANR5L17BTA0154
17060000134477L17/dossiers17170600001344211706000013447522TAPPRJLANR5L17TAP0154
17060000134492L17/dossiers17170600001344211706000013449112BTAPRJLANR5L17BTA0164
17060000134493L17/dossiers17170600001344211706000013449122TAPPRJLANR5L17TAP0164
17060000134496L17/dossiers17170600001344211706000013449512BTAPRJLSNR5S459BTA0172
17060000134518L17/dossiers17170600001345051706000013451712BTAPRJLSNR5S459BTA0123
17060000134530L17/dossiers17170600001345051706000013452912BTAPRJLANR5L17BTA0119
17060000134531L17/dossiers17170600001345051706000013452922TAPPRJLANR5L17TAP0119
17060000134548L17/dossiers17170600001345341706000013454712BTAPIONSNR5S459BTA0164
17060000134563L17/dossiers17170600001345341706000013456212BTAPIONANR5L17BTA0270
17060000134625L17/dossiers17170600001346181706000013462412BTARIONANR5L17BTA0133
17060000134639L17/dossiers17170600001346261706000013463812BTAPRJLSNR5S459BTA0153
17060000134654L17/dossiers17170600001346261706000013465312BTAPRJLANR5L17BTA0319
17060000134680L17/dossiers17170600001346671706000013467912BTAPRJLSNR5S459BTA0131
17060000134694L17/dossiers17170600001346671706000013469312BTAPRJLANR5L17BTA0157
17060000134695L17/dossiers17170600001346671706000013469322TAPPRJLANR5L17TAP0157
17060000134867L17/dossiers17170600001348511706000013486612BTAPIONANR5L17BTA0124
17060000134868L17/dossiers17170600001348511706000013486622TAPPIONANR5L17TAP0124
17060000134879L17/dossiers17170600001348511706000013487812BTAPIONSNR5S479BTA0018
17060000134915L17/dossiers17170600001349001706000013491412BTAPRJLSNR5S459BTA0133
17060000134933L17/dossiers17170600001349001706000013493212BTAPRJLANR5L17BTA0158
17060000134934L17/dossiers17170600001349001706000013493222TAPPRJLANR5L17TAP0158
17060000134949L17/dossiers17170600001349001706000013494812BTAPRJLSNR5S459BTA0174
17060000134953L17/dossiers17170600001349001706000013495212BTAPRJLANR5L17BTA0171
17060000134954L17/dossiers17170600001349001706000013495222TAPPRJLANR5L17TAP0171
17060000134973L17/dossiers17170600001349581706000013497212BTARIONANR5L17BTA0169
17060000135360L17/dossiers17170600001353411706000013535912BTAPRJLANR5L17BTA0202
17060000135372L17/dossiers17170600001353411706000013537112BTAPRJLSNR5S479BTA0061
17060000135388L17/dossiers17170600001353751706000013538712BTAPRJLSNR5S459BTA0158
17060000135438L17/dossiers17170600001353751706000013543712BTAPRJLANR5L17BTA0211
17060000135439L17/dossiers17170600001353751706000013543722TAPPRJLANR5L17TAP0211
17060000135456L17/dossiers17170600001353751706000013545512BTAPRJLANR5L17BTA0228
17060000135457L17/dossiers17170600001353751706000013545522TAPPRJLANR5L17TAP0228
17060000135460L17/dossiers17170600001353751706000013545912BTAPRJLSNR5S479BTA0051
17060000135511L17/dossiers17170600001354981706000013551012BTAPRJLSNR5S459BTA0155