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
17060000139213L17/dossiers17170600001391791706000013921212BTAPIONANR5L17BTA0174
17060000139228L17/dossiers17170600001391791706000013922712BTAPIONANR5L17BTA0176
17060000139229L17/dossiers17170600001391791706000013922722TAPPIONANR5L17TAP0176
17060000139232L17/dossiers17170600001391791706000013923112BTAPIONSNR5S479BTA0013
17060000139310L17/dossiers17170600001392961706000013930912BTAPIONSNR5S479BTA0015
17060000139323L17/dossiers17170600001393161706000013932212BTARIONANR5L17BTA0304
17060000139370L17/dossiers17170600001393541706000013936912BTARIONANR5L17BTA0186
17060000139471L17/dossiers17170600001394641706000013947012BTARIONANR5L17BTA0177
17060000139615L17/dossiers17170600001396031706000013961412BTAPIONSNR5S479BTA0017
17060000139651L17/dossiers17170600001396351706000013965012BTARIONANR5L17BTA0208
17060000139754L17/dossiers17170600001397361706000013975312BTAPIONANR5L17BTA0284
17060000139755L17/dossiers17170600001397361706000013975322TAPPIONANR5L17TAP0284
17060000139776L17/dossiers17170600001397611706000013977512BTAPIONANR5L17BTA0224
17060000139777L17/dossiers17170600001397611706000013977522TAPPIONANR5L17TAP0224
17060000139807L17/dossiers17170600001397901706000013980612BTAPIONANR5L17BTA0221
17060000139808L17/dossiers17170600001397901706000013980622TAPPIONANR5L17TAP0221
17060000139819L17/dossiers17170600001397901706000013981812BTAPIONSNR5S479BTA0133
17060000139833L17/dossiers17170600001397901706000013983212BTAPIONSNR5S479BTA0154
17060000139837L17/dossiers17170600001397901706000013983612BTAPIONANR5L17BTA0341
17060000139838L17/dossiers17170600001397901706000013983622TAPPIONANR5L17TAP0341
17060000139877L17/dossiers17170600001398591706000013987612BTAPIONANR5L17BTA0197
17060000139878L17/dossiers17170600001398591706000013987622TAPPIONANR5L17TAP0197
17060000139902L17/dossiers17170600001398841706000013990112BTAPIONANR5L17BTA0264
17060000139903L17/dossiers17170600001398841706000013990122TAPPIONANR5L17TAP0264
17060000140037L17/dossiers17170600001400211706000014003612BTAPIONANR5L17BTA0290
17060000140038L17/dossiers17170600001400211706000014003622TAPPIONANR5L17TAP0290
17060000140164L17/dossiers17170600001401481706000014016312BTAPIONANR5L17BTA0194
17060000140165L17/dossiers17170600001401481706000014016322TAPPIONANR5L17TAP0194
17060000140177L17/dossiers17170600001401481706000014017612BTAPIONSNR5S479BTA0123
17060000140188L17/dossiers17170600001401481706000014018712BTAPIONANR5L17BTA0324
17060000140189L17/dossiers17170600001401481706000014018722TAPPIONANR5L17TAP0324
17060000140247L17/dossiers17170600001402301706000014024612BTAPIONANR5L17BTA0178
17060000140388L17/dossiers17170600001403711706000014038712BTARIONANR5L17BTA0209
17060000140470L17/dossiers17170600001404461706000014046912BTARIONANR5L17BTA0282
17060000140471L17/dossiers17170600001404461706000014046922TAPRIONANR5L17TAP0282
17060000140546L17/dossiers17170600001405331706000014054512BTAPIONSNR5S479BTA0016
17060000140755L17/dossiers17170600001407401706000014075412BTARIONANR5L17BTA0248
17060000140869L17/dossiers17170600001408551706000014086812BTAPIONSNR5S479BTA0033
17060000141009L17/dossiers17170600001409381706000014100812BTAPRJLSNR5S479BTA0023
17060000141043L17/dossiers17170600001409381706000014104212BTAPRJLANR5L17BTA0188
17060000141044L17/dossiers17170600001409381706000014104222TAPPRJLANR5L17TAP0188
17060000141053L17/dossiers17170600001409381706000014105212BTAPRJLSNR5S479BTA0028
17060000141062L17/dossiers17170600001409381706000014106112BTAPRJLANR5L17BTA0199
17060000141063L17/dossiers17170600001409381706000014106122TAPPRJLANR5L17TAP0199
17060000141091L17/dossiers17170600001410761706000014109012BTAPIONANR5L17BTA0285
17060000141092L17/dossiers17170600001410761706000014109022TAPPIONANR5L17TAP0285
17060000141504L17/dossiers17170600001414891706000014150312BTAPIONANR5L17BTA0183
17060000141505L17/dossiers17170600001414891706000014150322TAPPIONANR5L17TAP0183
17060000141527L17/dossiers17170600001415111706000014152612BTAPIONANR5L17BTA0184
17060000141528L17/dossiers17170600001415111706000014152622TAPPIONANR5L17TAP0184