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
16060000097419L16/dossiers16160600000974031606000009741812BTAPIONANR5L16BTA0017
16060000097420L16/dossiers16160600000974031606000009741822TAPPIONANR5L16TAP0017
16060000097555L16/dossiers16160600000974621606000009755412BTAPIONSNR5S419BTA0023
16060000097570L16/dossiers16160600000974621606000009756912BTAPIONANR5L16BTA0252
16060000097571L16/dossiers16160600000974621606000009756922TAPPIONANR5L16TAP0252
16060000097648L16/dossiers16160600000976341606000009764712BTAPIONANR5L16BTA0020
16060000097649L16/dossiers16160600000976341606000009764722TAPPIONANR5L16TAP0020
16060000097679L16/dossiers16160600000976621606000009767812BTAPIONANR5L16BTA0019
16060000097680L16/dossiers16160600000976621606000009767822TAPPIONANR5L16TAP0019
16060000097691L16/dossiers16160600000976621606000009769012BTAPIONSNR5S399BTA0034
16060000097745L16/dossiers16160600000977251606000009774412BTAPRJLANR5L16BTA0074
16060000097756L16/dossiers16160600000977251606000009775512BTAPRJLSNR5S399BTA0117
16060000097778L16/dossiers16160600000977591606000009777712BTAPRJLANR5L16BTA0030
16060000097789L16/dossiers16160600000977591606000009778812BTAPRJLSNR5S399BTA0042
16060000097982L16/dossiers16160600000979661606000009798112BTAPIONANR5L16BTA0056
16060000098142L16/dossiers16160600000981141606000009814112BTAPRJLANR5L16BTA0021
16060000098143L16/dossiers16160600000981141606000009814122TAPPRJLANR5L16TAP0021
16060000098155L16/dossiers16160600000981141606000009815412BTAPRJLSNR5S399BTA0009
16060000098170L16/dossiers16160600000981141606000009816912BTAPRJLANR5L16BTA0029
16060000098171L16/dossiers16160600000981141606000009816922TAPPRJLANR5L16TAP0029
16060000098174L16/dossiers16160600000981141606000009817312BTAPRJLSNR5S399BTA0027
16060000098210L16/dossiers16160600000981961606000009820912BTAPRJLSNR5S399BTA0002
16060000098248L16/dossiers16160600000981961606000009824712BTAPRJLANR5L16BTA0032
16060000098249L16/dossiers16160600000981961606000009824722TAPPRJLANR5L16TAP0032
16060000098263L16/dossiers16160600000981961606000009826212BTAPRJLANR5L16BTA0047
16060000098264L16/dossiers16160600000981961606000009826222TAPPRJLANR5L16TAP0047
16060000098268L16/dossiers16160600000981961606000009826712BTAPRJLSNR5S399BTA0038
16060000098287L16/dossiers16160600000982751606000009828612BTAPIONSNR5S399BTA0006
16060000098303L16/dossiers16160600000982751606000009830212BTAPIONANR5L16BTA0058
16060000098304L16/dossiers16160600000982751606000009830222TAPPIONANR5L16TAP0058
16060000098313L16/dossiers16160600000982751606000009831212BTAPIONSNR5S399BTA0061
16060000098329L16/dossiers16160600000983161606000009832812BTAPIONSNR5S399BTA0007
16060000098345L16/dossiers16160600000983161606000009834412BTAPIONANR5L16BTA0028
16060000098346L16/dossiers16160600000983161606000009834422TAPPIONANR5L16TAP0028
16060000098386L16/dossiers16160600000983671606000009838512BTAPIONANR5L16BTA0054
16060000098452L16/dossiers16160600000984401606000009845112BTAPIONSNR5S399BTA0120
16060000098854L16/dossiers16160600000988301606000009885312BTAPRJLANR5L16BTA0024
16060000098865L16/dossiers16160600000988301606000009886412BTAPRJLSNR5S399BTA0015
16060000098892L16/dossiers16160600000988301606000009889112BTAPRJLANR5L16BTA0168
16060000098893L16/dossiers16160600000988301606000009889122TAPPRJLANR5L16TAP0168
16060000098902L16/dossiers16160600000988301606000009890112BTAPRJLSNR5S419BTA0006
16060000098917L16/dossiers16160600000988301606000009891612BTAPRJLANR5L16BTA0186
16060000098918L16/dossiers16160600000988301606000009891622TAPPRJLANR5L16TAP0186
16060000098977L16/dossiers16160600000989241606000009897612BTAPRJLANR5L16BTA0025
16060000098978L16/dossiers16160600000989241606000009897622TAPPRJLANR5L16TAP0025
16060000098995L16/dossiers16160600000989241606000009899412BTAPRJLSNR5S399BTA0018
16060000099027L16/dossiers16160600000989241606000009902612BTAPRJLANR5L16BTA0036
16060000099028L16/dossiers16160600000989241606000009902622TAPPRJLANR5L16TAP0036
16060000099038L16/dossiers16160600000989241606000009903712BTAPRJLSNR5S399BTA0029
16060000099052L16/dossiers16160600000989241606000009905112BTAPRJLANR5L16BTA0046