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
16060000109321L16/dossiers16160600001092761606000010931922TAPPIONANR5L16TAP0297
16060000109324L16/dossiers16160600001092761606000010932312BTAPIONSNR5S419BTA0126
16060000109416L16/dossiers16160600001093981606000010941512BTAPIONANR5L16BTA0138
16060000109427L16/dossiers16160600001093981606000010942612BTAPIONSNR5S419BTA0008
16060000109441L16/dossiers16160600001093981606000010944012BTAPIONANR5L16BTA0184
16060000109442L16/dossiers16160600001093981606000010944022TAPPIONANR5L16TAP0184
16060000109445L16/dossiers16160600001093981606000010944412BTAPIONSNR5S419BTA0034
16060000109516L16/dossiers16160600001095001606000010951512BTARIONANR5L16BTA0194
16060000109558L16/dossiers16160600001095451606000010955712BTAPIONSNR5S399BTA0137
16060000109587L16/dossiers16160600001095711606000010958612BTAPIONANR5L16BTA0225
16060000109599L16/dossiers16160600001095711606000010959812BTAPIONSNR5S419BTA0097
16060000109622L16/dossiers16160600001096101606000010962112BTAPIONSNR5S399BTA0132
16060000109657L16/dossiers16160600001096501606000010965612BTARIONANR5L16BTA0132
16060000109692L16/dossiers16160600001096791606000010969112BTAPRJLSNR5S419BTA0013
16060000109707L16/dossiers16160600001096791606000010970612BTAPRJLANR5L16BTA0217
16060000109708L16/dossiers16160600001096791606000010970622TAPPRJLANR5L16TAP0217
16060000109726L16/dossiers16160600001097111606000010972512BTAPIONSNR5S399BTA0131
16060000109743L16/dossiers16160600001097111606000010974212BTAPIONANR5L16BTA0179
16060000109744L16/dossiers16160600001097111606000010974222TAPPIONANR5L16TAP0179
16060000109758L16/dossiers16160600001097111606000010975712BTAPIONANR5L16BTA0216
16060000109759L16/dossiers16160600001097111606000010975722TAPPIONANR5L16TAP0216
16060000109762L16/dossiers16160600001097111606000010976112BTAPIONSNR5S419BTA0036
16060000109790L16/dossiers16160600001097661606000010978912BTAPIONANR5L16BTA0137
16060000109791L16/dossiers16160600001097661606000010978922TAPPIONANR5L16TAP0137
16060000109802L16/dossiers16160600001097661606000010980112BTAPIONSNR5S419BTA0010
16060000109816L16/dossiers16160600001097661606000010981512BTAPIONANR5L16BTA0215
16060000109817L16/dossiers16160600001097661606000010981522TAPPIONANR5L16TAP0215
16060000109820L16/dossiers16160600001097661606000010981912BTAPIONSNR5S419BTA0038
16060000109843L16/dossiers16160600001098241606000010984212BTAPIONANR5L16BTA0231
16060000109844L16/dossiers16160600001098241606000010984222TAPPIONANR5L16TAP0231
16060000109856L16/dossiers16160600001098241606000010985512BTAPIONSNR5S419BTA0131
16060000109905L16/dossiers16160600001098661606000010990412BTAPIONSNR5S399BTA0133
16060000109922L16/dossiers16160600001098661606000010992112BTAPIONANR5L16BTA0183
16060000109923L16/dossiers16160600001098661606000010992122TAPPIONANR5L16TAP0183
16060000109936L16/dossiers16160600001098661606000010993512BTAPIONSNR5S419BTA0037
16060000109940L16/dossiers16160600001098661606000010993912BTAPIONANR5L16BTA0221
16060000109941L16/dossiers16160600001098661606000010993922TAPPIONANR5L16TAP0221
16060000110011L16/dossiers16160600001099931606000011001012BTAPRJLANR5L16BTA0146
16060000110022L16/dossiers16160600001099931606000011002112BTAPRJLSNR5S419BTA0046
16060000110039L16/dossiers16160600001100251606000011003812BTAPRJLSNR5S399BTA0129
16060000110085L16/dossiers16160600001100251606000011008412BTAPRJLANR5L16BTA0158
16060000110086L16/dossiers16160600001100251606000011008422TAPPRJLANR5L16TAP0158
16060000110102L16/dossiers16160600001100251606000011010112BTAPRJLANR5L16BTA0171
16060000110103L16/dossiers16160600001100251606000011010122TAPPRJLANR5L16TAP0171
16060000110106L16/dossiers16160600001100251606000011010512BTARAPPSNR5S419BTA0003
16060000110127L16/dossiers16160600001101131606000011012612BTAPRJLSNR5S399BTA0130
16060000110165L16/dossiers16160600001101131606000011016412BTAPRJLANR5L16BTA0159
16060000110166L16/dossiers16160600001101131606000011016422TAPPRJLANR5L16TAP0159
16060000110181L16/dossiers16160600001101131606000011018012BTAPRJLANR5L16BTA0172
16060000110182L16/dossiers16160600001101131606000011018022TAPPRJLANR5L16TAP0172