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
16060000116799L16/dossiers16160600001167791606000011679812BTAPIONANR5L16BTA0237
16060000116800L16/dossiers16160600001167791606000011679822TAPPIONANR5L16TAP0237
16060000117053L16/dossiers16160600001170321606000011705212BTAPRJLANR5L16BTA0230
16060000117064L16/dossiers16160600001170321606000011706312BTAPRJLSNR5S419BTA0088
16060000117084L16/dossiers16160600001170671606000011708312BTAPRJLANR5L16BTA0177
16060000117085L16/dossiers16160600001170671606000011708322TAPPRJLANR5L16TAP0177
16060000117096L16/dossiers16160600001170671606000011709512BTAPRJLSNR5S419BTA0021
16060000117109L16/dossiers16160600001170671606000011710812BTAPRJLSNR5S419BTA0024
16060000117112L16/dossiers16160600001170671606000011711112BTAPRJLANR5L16BTA0188
16060000117113L16/dossiers16160600001170671606000011711122TAPPRJLANR5L16TAP0188
16060000117454L16/dossiers16160600001174401606000011745312BTAPRJLSNR5S419BTA0047
16060000117488L16/dossiers16160600001174401606000011748712BTAPRJLANR5L16BTA0261
16060000117489L16/dossiers16160600001174401606000011748722TAPPRJLANR5L16TAP0261
16060000117505L16/dossiers16160600001174401606000011750412BTAPRJLSNR5S419BTA0114
16060000117509L16/dossiers16160600001174401606000011750812BTAPRJLANR5L16BTA0287
16060000117510L16/dossiers16160600001174401606000011750822TAPPRJLANR5L16TAP0287
16060000117527L16/dossiers16160600001175141606000011752612BTAPRJLSNR5S419BTA0044
16060000117544L16/dossiers16160600001175141606000011754312BTAPRJLANR5L16BTA0241
16060000117545L16/dossiers16160600001175141606000011754322TAPPRJLANR5L16TAP0241
16060000117569L16/dossiers16160600001175141606000011756812BTAPRJLANR5L16BTA0267
16060000117570L16/dossiers16160600001175141606000011756822TAPPRJLANR5L16TAP0267
16060000117580L16/dossiers16160600001175141606000011757912BTAPRJLSNR5S419BTA0105
16060000117589L16/dossiers16160600001175141606000011758812BTAPRJLANR5L16BTA0285
16060000117590L16/dossiers16160600001175141606000011758822TAPPRJLANR5L16TAP0285
16060000117758L16/dossiers16160600001177421606000011775712BTAPIONANR5L16BTA0192
16060000117769L16/dossiers16160600001177421606000011776812BTAPIONSNR5S419BTA0039
16060000117807L16/dossiers16160600001177941606000011780612BTAPIONSNR5S419BTA0069
16060000118029L16/dossiers16160600001180141606000011802812BTARIONANR5L16BTA0291
16060000118043L16/dossiers16160600001180331606000011804212BTARIONANR5L16BTA0224
16060000118095L16/dossiers16160600001180821606000011809412BTAPRJLSNR5S419BTA0089
16060000118110L16/dossiers16160600001180821606000011810912BTAPRJLANR5L16BTA0280
16060000118111L16/dossiers16160600001180821606000011810922TAPPRJLANR5L16TAP0280
16060000118120L16/dossiers16160600001180821606000011811912BTAPRJLSNR5S419BTA0127
16060000118163L16/dossiers16160600001181461606000011816212BTARIONANR5L16BTA0275
16060000118186L16/dossiers16160600001181791606000011818512BTARIONANR5L16BTA0202
16060000118256L16/dossiers16160600001182491606000011825512BTARIONANR5L16BTA0303
16060000118269L16/dossiers16160600001182571606000011826812BTAPIONSNR5S419BTA0094
16060000118305L16/dossiers16160600001182891606000011830412BTARIONANR5L16BTA0249
16060000118306L16/dossiers16160600001182891606000011830422TAPRIONANR5L16TAP0249
16060000118345L16/dossiers16160600001183281606000011834412BTAPIONANR5L16BTA0242
16060000118346L16/dossiers16160600001183281606000011834422TAPPIONANR5L16TAP0242
16060000118358L16/dossiers16160600001183281606000011835712BTAPIONSNR5S419BTA0080
16060000118385L16/dossiers16160600001183681606000011838412BTAPIONANR5L16BTA0228
16060000118386L16/dossiers16160600001183681606000011838422TAPPIONANR5L16TAP0228
16060000118397L16/dossiers16160600001183681606000011839612BTAPIONSNR5S419BTA0093
16060000118411L16/dossiers16160600001183681606000011841012BTAPIONSNR5S419BTA0134
16060000118415L16/dossiers16160600001183681606000011841412BTAPIONANR5L16BTA0299
16060000118416L16/dossiers16160600001183681606000011841422TAPPIONANR5L16TAP0299
16060000118480L16/dossiers16160600001184631606000011847912BTAPIONANR5L16BTA0250
16060000118481L16/dossiers16160600001184631606000011847922TAPPIONANR5L16TAP0250