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
16060000107587L16/dossiers16160600001075741606000010758612BTAPIONSNR5S419BTA0057
16060000107626L16/dossiers16160600001076141606000010762512BTAPIONSNR5S419BTA0025
16060000107699L16/dossiers16160600001076851606000010769812BTARIONANR5L16BTA0119
16060000107725L16/dossiers16160600001077111606000010772412BTARIONANR5L16BTA0120
16060000107925L16/dossiers16160600001079181606000010792412BTARIONANR5L16BTA0111
16060000107990L16/dossiers16160600001079261606000010798912BTAPRJLANR5L16BTA0127
16060000107991L16/dossiers16160600001079261606000010798922TAPPRJLANR5L16TAP0127
16060000108002L16/dossiers16160600001079261606000010800112BTAPRJLSNR5S399BTA0148
16060000108018L16/dossiers16160600001079261606000010801712BTAPRJLANR5L16BTA0155
16060000108019L16/dossiers16160600001079261606000010801722TAPPRJLANR5L16TAP0155
16060000108023L16/dossiers16160600001079261606000010802212BTAPRJLSNR5S399BTA0162
16060000108047L16/dossiers16160600001080301606000010804612BTARIONANR5L16BTA0113
16060000108099L16/dossiers16160600001080721606000010809812BTAPIONSNR5S399BTA0135
16060000108116L16/dossiers16160600001080721606000010811512BTAPIONANR5L16BTA0208
16060000108117L16/dossiers16160600001080721606000010811522TAPPIONANR5L16TAP0208
16060000108133L16/dossiers16160600001081201606000010813212BTAPIONSNR5S399BTA0128
16060000108158L16/dossiers16160600001081461606000010815712BTAPIONSNR5S419BTA0001
16060000108322L16/dossiers16160600001083151606000010832112BTAPNREANR5L16BTA0108
16060000108425L16/dossiers16160600001084091606000010842412BTAPRJLANR5L16BTA0124
16060000108436L16/dossiers16160600001084091606000010843512BTAPRJLSNR5S399BTA0152
16060000108455L16/dossiers16160600001084371606000010845412BTAPRJLANR5L16BTA0125
16060000108514L16/dossiers16160600001084371606000010851312BTAPRJLSNR5S399BTA0153
16060000108535L16/dossiers16160600001085221606000010853412BTAPRJLSNR5S399BTA0119
16060000108561L16/dossiers16160600001085221606000010856012BTAPRJLANR5L16BTA0141
16060000108562L16/dossiers16160600001085221606000010856022TAPPRJLANR5L16TAP0141
16060000108575L16/dossiers16160600001085221606000010857412BTAPRJLSNR5S399BTA0150
16060000108579L16/dossiers16160600001085221606000010857812BTAPRJLANR5L16BTA0152
16060000108580L16/dossiers16160600001085221606000010857822TAPPRJLANR5L16TAP0152
16060000108796L16/dossiers16160600001087801606000010879512BTAPIONANR5L16BTA0270
16060000108797L16/dossiers16160600001087801606000010879522TAPPIONANR5L16TAP0270
16060000108910L16/dossiers16160600001088931606000010890912BTAPIONANR5L16BTA0254
16060000108911L16/dossiers16160600001088931606000010890922TAPPIONANR5L16TAP0254
16060000109027L16/dossiers16160600001090141606000010902612BTAPRJLSNR5S399BTA0106
16060000109040L16/dossiers16160600001090141606000010903912BTAPRJLANR5L16BTA0140
16060000109041L16/dossiers16160600001090141606000010903922TAPPRJLANR5L16TAP0140
16060000109054L16/dossiers16160600001090141606000010905312BTAPRJLSNR5S399BTA0151
16060000109058L16/dossiers16160600001090141606000010905712BTAPRJLANR5L16BTA0151
16060000109059L16/dossiers16160600001090141606000010905722TAPPRJLANR5L16TAP0151
16060000109077L16/dossiers16160600001090631606000010907612BTAPRJLSNR5S399BTA0113
16060000109093L16/dossiers16160600001090631606000010909212BTAPRJLANR5L16BTA0150
16060000109094L16/dossiers16160600001090631606000010909222TAPPRJLANR5L16TAP0150
16060000109108L16/dossiers16160600001090631606000010910712BTAPRJLSNR5S399BTA0164
16060000109112L16/dossiers16160600001090631606000010911112BTAPRJLANR5L16BTA0157
16060000109113L16/dossiers16160600001090631606000010911122TAPPRJLANR5L16TAP0157
16060000109255L16/dossiers16160600001092371606000010925412BTAPIONANR5L16BTA0130
16060000109256L16/dossiers16160600001092371606000010925422TAPPIONANR5L16TAP0130
16060000109293L16/dossiers16160600001092761606000010929212BTAPIONANR5L16BTA0206
16060000109294L16/dossiers16160600001092761606000010929222TAPPIONANR5L16TAP0206
16060000109306L16/dossiers16160600001092761606000010930512BTAPIONSNR5S419BTA0098
16060000109320L16/dossiers16160600001092761606000010931912BTAPIONANR5L16BTA0297