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
17060000143137L17/dossiers17170600001430991706000014313612BTAPIONANR5L17BTA0277
17060000143138L17/dossiers17170600001430991706000014313622TAPPIONANR5L17TAP0277
17060000143192L17/dossiers17170600001431781706000014319112BTAPIONSNR5S479BTA0054
17060000143219L17/dossiers17170600001432121706000014321812BTARIONANR5L17BTA0238
17060000143289L17/dossiers17170600001432751706000014328812BTAPIONSNR5S479BTA0058
17060000143386L17/dossiers17170600001433741706000014338512BTAPRJLSNR5S479BTA0045
17060000143403L17/dossiers17170600001433741706000014340212BTAPRJLANR5L17BTA0275
17060000143458L17/dossiers17170600001434391706000014345712BTAPRJLANR5L17BTA0214
17060000143470L17/dossiers17170600001434391706000014346912BTAPRJLSNR5S479BTA0094
17060000143609L17/dossiers17170600001435921706000014360812BTAPIONANR5L17BTA0225
17060000143610L17/dossiers17170600001435921706000014360822TAPPIONANR5L17TAP0225
17060000143622L17/dossiers17170600001435921706000014362112BTAPIONSNR5S479BTA0122
17060000143661L17/dossiers17170600001436421706000014366012BTAPIONANR5L17BTA0222
17060000143673L17/dossiers17170600001436421706000014367212BTAPIONSNR5S479BTA0087
17060000143732L17/dossiers17170600001437071706000014373112BTAPIONANR5L17BTA0278
17060000143733L17/dossiers17170600001437071706000014373122TAPPIONANR5L17TAP0278
17060000143744L17/dossiers17170600001437071706000014374312BTAPIONSNR5S479BTA0116
17060000143757L17/dossiers17170600001437071706000014375612BTAPIONSNR5S479BTA0136
17060000143761L17/dossiers17170600001437071706000014376012BTAPIONANR5L17BTA0315
17060000143762L17/dossiers17170600001437071706000014376022TAPPIONANR5L17TAP0315
17060000143834L17/dossiers17170600001438191706000014383312BTAPIONSNR5S479BTA0041
17060000143901L17/dossiers17170600001438941706000014390012BTARIONANR5L17BTA0216
17060000143935L17/dossiers17170600001439231706000014393412BTAPIONSNR5S479BTA0050
17060000143950L17/dossiers17170600001439231706000014394912BTAPIONANR5L17BTA0310
17060000143969L17/dossiers17170600001439561706000014396812BTAPIONSNR5S479BTA0049
17060000143982L17/dossiers17170600001439561706000014398112BTAPIONANR5L17BTA0271
17060000143983L17/dossiers17170600001439561706000014398122TAPPIONANR5L17TAP0271
17060000144278L17/dossiers17170600001442651706000014427712BTAPIONSNR5S479BTA0088
17060000144291L17/dossiers17170600001442651706000014429012BTAPIONANR5L17BTA0291
17060000144292L17/dossiers17170600001442651706000014429022TAPPIONANR5L17TAP0291
17060000144318L17/dossiers17170600001442951706000014431712BTAPIONSNR5S479BTA0055
17060000144342L17/dossiers17170600001443241706000014434112BTAPIONSNR5S479BTA0085
17060000144415L17/dossiers17170600001444021706000014441412BTAPIONSNR5S479BTA0086
17060000144470L17/dossiers17170600001444631706000014446912BTARIONANR5L17BTA0229
17060000144549L17/dossiers17170600001445371706000014454812BTAPIONSNR5S479BTA0072
17060000144572L17/dossiers17170600001445551706000014457112BTAPRJLANR5L17BTA0207
17060000144573L17/dossiers17170600001445551706000014457122TAPPRJLANR5L17TAP0207
17060000144584L17/dossiers17170600001445551706000014458312BTAPRJLSNR5S479BTA0037
17060000144603L17/dossiers17170600001445871706000014460212BTARIONANR5L17BTA0257
17060000144616L17/dossiers17170600001446041706000014461512BTAPRJLSNR5S479BTA0046
17060000144728L17/dossiers17170600001447141706000014472712BTAPIONANR5L17BTA0312
17060000144729L17/dossiers17170600001447141706000014472722TAPPIONANR5L17TAP0312
17060000144945L17/dossiers17170600001449311706000014494412BTAPIONANR5L17BTA0265
17060000144946L17/dossiers17170600001449311706000014494422TAPPIONANR5L17TAP0265
17060000144957L17/dossiers17170600001449311706000014495612BTAPIONSNR5S479BTA0129
17060000144970L17/dossiers17170600001449311706000014496912BTAPIONSNR5S479BTA0159
17060000144974L17/dossiers17170600001449311706000014497312BTAPIONANR5L17BTA0335
17060000144975L17/dossiers17170600001449311706000014497322TAPPIONANR5L17TAP0335
17060000144995L17/dossiers17170600001449791706000014499412BTAPIONANR5L17BTA0236
17060000144996L17/dossiers17170600001449791706000014499422TAPPIONANR5L17TAP0236