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
16060000101175L16/dossiers16160600001011571606000010117412BTAPRJLANR5L16BTA0027
16060000101176L16/dossiers16160600001011571606000010117422TAPPRJLANR5L16TAP0027
16060000101187L16/dossiers16160600001011571606000010118612BTAPRJLSNR5S399BTA0022
16060000101201L16/dossiers16160600001011571606000010120012BTAPRJLANR5L16BTA0033
16060000101202L16/dossiers16160600001011571606000010120022TAPPRJLANR5L16TAP0033
16060000101205L16/dossiers16160600001011571606000010120412BTAPRJLSNR5S399BTA0028
16060000101249L16/dossiers16160600001012351606000010124812BTAPRJLSNR5S399BTA0040
16060000101285L16/dossiers16160600001012351606000010128412BTAPRJLANR5L16BTA0092
16060000101286L16/dossiers16160600001012351606000010128422TAPPRJLANR5L16TAP0092
16060000101300L16/dossiers16160600001012351606000010129912BTAPRJLSNR5S399BTA0102
16060000101305L16/dossiers16160600001012351606000010130412BTAPRJLANR5L16BTA0117
16060000101306L16/dossiers16160600001012351606000010130422TAPPRJLANR5L16TAP0117
16060000101378L16/dossiers16160600001013711606000010137712BTARIONANR5L16BTA0061
16060000101452L16/dossiers16160600001014021606000010145112BTAPIONSNR5S399BTA0047
16060000101502L16/dossiers16160600001014851606000010150112BTAPIONANR5L16BTA0205
16060000101503L16/dossiers16160600001014851606000010150122TAPPIONANR5L16TAP0205
16060000101515L16/dossiers16160600001014851606000010151412BTAPIONSNR5S419BTA0065
16060000101750L16/dossiers16160600001017381606000010174912BTAPIONSNR5S399BTA0066
16060000101772L16/dossiers16160600001017561606000010177112BTAPIONSNR5S399BTA0088
16060000101788L16/dossiers16160600001017561606000010178712BTAPIONANR5L16BTA0136
16060000101789L16/dossiers16160600001017561606000010178722TAPPIONANR5L16TAP0136
16060000101804L16/dossiers16160600001017561606000010180312BTAPIONSNR5S399BTA0157
16060000101850L16/dossiers16160600001018431606000010184912BTARIONANR5L16BTA0035
16060000101929L16/dossiers16160600001019071606000010192812BTAPNREANR5L16BTA0195
16060000101980L16/dossiers16160600001019661606000010197912BTAPRJLSNR5S399BTA0037
16060000102016L16/dossiers16160600001019661606000010201512BTAPRJLANR5L16BTA0067
16060000102017L16/dossiers16160600001019661606000010201522TAPPRJLANR5L16TAP0067
16060000102030L16/dossiers16160600001019661606000010202912BTAPRJLSNR5S399BTA0062
16060000102034L16/dossiers16160600001019661606000010203312BTAPRJLANR5L16BTA0081
16060000102035L16/dossiers16160600001019661606000010203322TAPPRJLANR5L16TAP0081
16060000102136L16/dossiers16160600001021211606000010213512BTAPIONANR5L16BTA0059
16060000102137L16/dossiers16160600001021211606000010213522TAPPIONANR5L16TAP0059
16060000102160L16/dossiers16160600001021431606000010215912BTAPIONANR5L16BTA0064
16060000102161L16/dossiers16160600001021431606000010215922TAPPIONANR5L16TAP0064
16060000102172L16/dossiers16160600001021431606000010217112BTAPIONSNR5S399BTA0058
16060000102185L16/dossiers16160600001021431606000010218412BTAPIONSNR5S399BTA0081
16060000102189L16/dossiers16160600001021431606000010218812BTAPIONANR5L16BTA0093
16060000102190L16/dossiers16160600001021431606000010218822TAPPIONANR5L16TAP0093
16060000102227L16/dossiers16160600001022081606000010222612BTAPIONANR5L16BTA0066
16060000102228L16/dossiers16160600001022081606000010222622TAPPIONANR5L16TAP0066
16060000102239L16/dossiers16160600001022081606000010223812BTAPIONSNR5S399BTA0063
16060000102252L16/dossiers16160600001022081606000010225112BTAPIONSNR5S399BTA0080
16060000102256L16/dossiers16160600001022081606000010225512BTAPIONANR5L16BTA0094
16060000102257L16/dossiers16160600001022081606000010225522TAPPIONANR5L16TAP0094
16060000102332L16/dossiers16160600001023141606000010233112BTAPIONANR5L16BTA0053
16060000102387L16/dossiers16160600001023701606000010238612BTAPIONANR5L16BTA0115
16060000102388L16/dossiers16160600001023701606000010238622TAPPIONANR5L16TAP0115
16060000102399L16/dossiers16160600001023701606000010239812BTAPIONSNR5S419BTA0041
16060000102491L16/dossiers16160600001024731606000010249012BTAPIONANR5L16BTA0055
16060000102517L16/dossiers16160600001024991606000010251612BTAPIONANR5L16BTA0057