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
16060000102793L16/dossiers16160600001027811606000010279212BTAPIONSNR5S399BTA0075
16060000102821L16/dossiers16160600001028051606000010282012BTARIONANR5L16BTA0062
16060000102822L16/dossiers16160600001028051606000010282022TAPRIONANR5L16TAP0062
16060000102843L16/dossiers16160600001028231606000010284212BTAPRJLANR5L16BTA0089
16060000102855L16/dossiers16160600001028231606000010285412BTAPRJLSNR5S399BTA0161
16060000103069L16/dossiers16160600001030531606000010306812BTAPIONANR5L16BTA0077
16060000103124L16/dossiers16160600001031071606000010312312BTAPIONANR5L16BTA0079
16060000103125L16/dossiers16160600001031071606000010312322TAPPIONANR5L16TAP0079
16060000103136L16/dossiers16160600001031071606000010313512BTAPIONSNR5S399BTA0082
16060000103150L16/dossiers16160600001031071606000010314912BTAPIONANR5L16BTA0180
16060000103151L16/dossiers16160600001031071606000010314922TAPPIONANR5L16TAP0180
16060000103161L16/dossiers16160600001031071606000010316012BTAPIONSNR5S419BTA0063
16060000103175L16/dossiers16160600001031071606000010317412BTAPIONANR5L16BTA0256
16060000103176L16/dossiers16160600001031071606000010317422TAPPIONANR5L16TAP0256
16060000103180L16/dossiers16160600001031071606000010317912BTAPIONSNR5S419BTA0079
16060000103223L16/dossiers16160600001031911606000010322212BTAPIONANR5L16BTA0193
16060000103224L16/dossiers16160600001031911606000010322222TAPPIONANR5L16TAP0193
16060000103237L16/dossiers16160600001031911606000010323612BTAPIONSNR5S419BTA0062
16060000103253L16/dossiers16160600001031911606000010325212BTAPIONANR5L16BTA0265
16060000103254L16/dossiers16160600001031911606000010325222TAPPIONANR5L16TAP0265
16060000103258L16/dossiers16160600001031911606000010325712BTAPIONSNR5S419BTA0100
16060000103367L16/dossiers16160600001033391606000010336612BTAPIONSNR5S399BTA0076
16060000103395L16/dossiers16160600001033391606000010339412BTAPIONANR5L16BTA0142
16060000103396L16/dossiers16160600001033391606000010339422TAPPIONANR5L16TAP0142
16060000103412L16/dossiers16160600001033391606000010341112BTAPIONANR5L16BTA0156
16060000103413L16/dossiers16160600001033391606000010341122TAPPIONANR5L16TAP0156
16060000103417L16/dossiers16160600001033391606000010341612BTAPIONSNR5S399BTA0163
16060000103492L16/dossiers16160600001034731606000010349112BTAPIONANR5L16BTA0087
16060000103493L16/dossiers16160600001034731606000010349122TAPPIONANR5L16TAP0087
16060000103505L16/dossiers16160600001034731606000010350412BTAPIONSNR5S419BTA0064
16060000103527L16/dossiers16160600001035111606000010352612BTAPIONANR5L16BTA0080
16060000103528L16/dossiers16160600001035111606000010352622TAPPIONANR5L16TAP0080
16060000103594L16/dossiers16160600001035791606000010359312BTARIONANR5L16BTA0076
16060000103595L16/dossiers16160600001035791606000010359322TAPRIONANR5L16TAP0076
16060000103717L16/dossiers16160600001037031606000010371612BTAPRJLSNR5S399BTA0044
16060000103759L16/dossiers16160600001037031606000010375812BTAPRJLANR5L16BTA0096
16060000103760L16/dossiers16160600001037031606000010375822TAPPRJLANR5L16TAP0096
16060000103774L16/dossiers16160600001037031606000010377312BTAPRJLANR5L16BTA0104
16060000103775L16/dossiers16160600001037031606000010377322TAPPRJLANR5L16TAP0104
16060000103778L16/dossiers16160600001037031606000010377712BTAPRJLSNR5S399BTA0093
16060000103798L16/dossiers16160600001037851606000010379712BTAPRJLSNR5S399BTA0116
16060000103812L16/dossiers16160600001037851606000010381112BTAPRJLANR5L16BTA0160
16060000103840L16/dossiers16160600001038241606000010383912BTAPIONANR5L16BTA0078
16060000103841L16/dossiers16160600001038241606000010383922TAPPIONANR5L16TAP0078
16060000103853L16/dossiers16160600001038241606000010385212BTAPIONSNR5S399BTA0090
16060000103868L16/dossiers16160600001038241606000010386712BTAPIONANR5L16BTA0110
16060000103869L16/dossiers16160600001038241606000010386722TAPPIONANR5L16TAP0110
16060000103881L16/dossiers16160600001038241606000010388012BTAPIONSNR5S419BTA0054
16060000103893L16/dossiers16160600001038241606000010389212BTAPIONANR5L16BTA0243
16060000103894L16/dossiers16160600001038241606000010389222TAPPIONANR5L16TAP0243