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
17060000127732L17/dossiers17170600001277141706000012773022TAPPIONANR5L17TAP0058
17060000127743L17/dossiers17170600001277141706000012774212BTAPIONSNR5S459BTA0143
17060000127819L17/dossiers17170600001277961706000012781812BTAPRJLANR5L17BTA0024
17060000127820L17/dossiers17170600001277961706000012781822TAPPRJLANR5L17TAP0024
17060000127832L17/dossiers17170600001277961706000012783112BTAPRJLSNR5S459BTA0047
17060000127846L17/dossiers17170600001277961706000012784512BTAPRJLANR5L17BTA0048
17060000127847L17/dossiers17170600001277961706000012784522TAPPRJLANR5L17TAP0048
17060000127850L17/dossiers17170600001277961706000012784912BTAPRJLSNR5S459BTA0053
17060000127875L17/dossiers17170600001278621706000012787412BTAPIONSNR5S459BTA0062
17060000127894L17/dossiers17170600001278811706000012789312BTAPIONSNR5S459BTA0120
17060000127921L17/dossiers17170600001279071706000012792012BTAPRJLSNR5S459BTA0074
17060000127936L17/dossiers17170600001279071706000012793512BTAPRJLANR5L17BTA0099
17060000127952L17/dossiers17170600001279391706000012795112BTAPIONSNR5S459BTA0065
17060000128045L17/dossiers17170600001280301706000012804412BTARIONANR5L17BTA0073
17060000128046L17/dossiers17170600001280301706000012804422TAPRIONANR5L17TAP0073
17060000128070L17/dossiers17170600001280571706000012806912BTAPIONSNR5S459BTA0122
17060000128236L17/dossiers17170600001282191706000012823512BTAPIONANR5L17BTA0068
17060000128237L17/dossiers17170600001282191706000012823522TAPPIONANR5L17TAP0068
17060000128373L17/dossiers17170600001283551706000012837212BTAPIONANR5L17BTA0062
17060000128374L17/dossiers17170600001283551706000012837222TAPPIONANR5L17TAP0062
17060000128386L17/dossiers17170600001283551706000012838512BTAPIONSNR5S459BTA0134
17060000128406L17/dossiers17170600001283891706000012840512BTAPIONANR5L17BTA0063
17060000128407L17/dossiers17170600001283891706000012840522TAPPIONANR5L17TAP0063
17060000128419L17/dossiers17170600001283891706000012841812BTAPIONSNR5S479BTA0035
17060000128433L17/dossiers17170600001283891706000012843212BTAPIONANR5L17BTA0251
17060000128434L17/dossiers17170600001283891706000012843222TAPPIONANR5L17TAP0251
17060000128453L17/dossiers17170600001284371706000012845212BTAPIONANR5L17BTA0250
17060000128454L17/dossiers17170600001284371706000012845222TAPPIONANR5L17TAP0250
17060000128465L17/dossiers17170600001284371706000012846412BTAPIONSNR5S479BTA0141
17060000128599L17/dossiers17170600001285821706000012859812BTAPIONANR5L17BTA0060
17060000128600L17/dossiers17170600001285821706000012859822TAPPIONANR5L17TAP0060
17060000128612L17/dossiers17170600001285821706000012861112BTAPIONSNR5S459BTA0115
17060000128623L17/dossiers17170600001285821706000012862212BTAPIONANR5L17BTA0249
17060000128624L17/dossiers17170600001285821706000012862222TAPPIONANR5L17TAP0249
17060000128662L17/dossiers17170600001286411706000012866112BTAPIONANR5L17BTA0086
17060000128663L17/dossiers17170600001286411706000012866122TAPPIONANR5L17TAP0086
17060000128675L17/dossiers17170600001286411706000012867412BTAPIONSNR5S459BTA0147
17060000128689L17/dossiers17170600001286411706000012868812BTAPIONANR5L17BTA0175
17060000128690L17/dossiers17170600001286411706000012868822TAPPIONANR5L17TAP0175
17060000128693L17/dossiers17170600001286411706000012869212BTAPIONSNR5S479BTA0008
17060000128784L17/dossiers17170600001287041706000012878312BTAPIONSNR5S459BTA0088
17060000128800L17/dossiers17170600001287041706000012879912BTAPIONANR5L17BTA0205
17060000128801L17/dossiers17170600001287041706000012879922TAPPIONANR5L17TAP0205
17060000128823L17/dossiers17170600001288041706000012882212BTAPRJLANR5L17BTA0167
17060000128834L17/dossiers17170600001288041706000012883312BTAPRJLSNR5S479BTA0025
17060000128852L17/dossiers17170600001288401706000012885112BTAPRJLSNR5S459BTA0051
17060000128867L17/dossiers17170600001288401706000012886612BTAPRJLANR5L17BTA0101
17060000128880L17/dossiers17170600001288401706000012887912BTAPRJLSNR5S459BTA0130
17060000128884L17/dossiers17170600001288401706000012888312BTAPRJLANR5L17BTA0145
17060000128924L17/dossiers17170600001289021706000012892312BTARIONANR5L17BTA0107