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
17060000145008L17/dossiers17170600001449791706000014500712BTAPIONSNR5S479BTA0104
17060000145057L17/dossiers17170600001450421706000014505612BTAPIONSNR5S479BTA0052
17060000145212L17/dossiers17170600001451921706000014521112BTAPIONANR5L17BTA0235
17060000145213L17/dossiers17170600001451921706000014521122TAPPIONANR5L17TAP0235
17060000145227L17/dossiers17170600001451921706000014522612BTAPIONSNR5S479BTA0089
17060000145242L17/dossiers17170600001451921706000014524112BTAPIONSNR5S479BTA0138
17060000145246L17/dossiers17170600001451921706000014524512BTAPIONANR5L17BTA0317
17060000145247L17/dossiers17170600001451921706000014524522TAPPIONANR5L17TAP0317
17060000145338L17/dossiers17170600001453261706000014533712BTAPIONSNR5S479BTA0099
17060000145394L17/dossiers17170600001453801706000014539312BTAPRJLSNR5S479BTA0078
17060000145408L17/dossiers17170600001453801706000014540712BTAPRJLANR5L17BTA0314
17060000145409L17/dossiers17170600001453801706000014540722TAPPRJLANR5L17TAP0314
17060000145532L17/dossiers17170600001455171706000014553112BTAPIONSNR5S479BTA0083
17060000145656L17/dossiers17170600001456401706000014565512BTAPIONANR5L17BTA0254
17060000145657L17/dossiers17170600001456401706000014565522TAPPIONANR5L17TAP0254
17060000145780L17/dossiers17170600001457591706000014577912BTAPIONSNR5S479BTA0066
17060000145793L17/dossiers17170600001457591706000014579212BTAPIONANR5L17BTA0258
17060000145794L17/dossiers17170600001457591706000014579222TAPPIONANR5L17TAP0258
17060000145862L17/dossiers17170600001458461706000014586112BTAPIONSNR5S479BTA0081
17060000145920L17/dossiers17170600001459071706000014591912BTAPRJLSNR5S479BTA0067
17060000146005L17/dossiers17170600001459881706000014600412BTAPIONANR5L17BTA0252
17060000146006L17/dossiers17170600001459881706000014600422TAPPIONANR5L17TAP0252
17060000146033L17/dossiers17170600001460191706000014603212BTAPIONANR5L17BTA0256
17060000146034L17/dossiers17170600001460191706000014603222TAPPIONANR5L17TAP0256
17060000146070L17/dossiers17170600001460541706000014606912BTAPIONANR5L17BTA0255
17060000146071L17/dossiers17170600001460541706000014606922TAPPIONANR5L17TAP0255
17060000146155L17/dossiers17170600001461411706000014615412BTAPRJLSNR5S479BTA0062
17060000146168L17/dossiers17170600001461411706000014616712BTAPRJLANR5L17BTA0260
17060000146207L17/dossiers17170600001461921706000014620612BTARIONANR5L17BTA0261
17060000146423L17/dossiers17170600001464071706000014642212BTAPIONANR5L17BTA0269
17060000146424L17/dossiers17170600001464071706000014642222TAPPIONANR5L17TAP0269
17060000146496L17/dossiers17170600001464821706000014649512BTAPIONANR5L17BTA0267
17060000146497L17/dossiers17170600001464821706000014649522TAPPIONANR5L17TAP0267
17060000146580L17/dossiers17170600001465671706000014657912BTAPRJLSNR5S479BTA0096
17060000146621L17/dossiers17170600001466081706000014662012BTAPIONSNR5S479BTA0082
17060000146787L17/dossiers17170600001467731706000014678612BTAPIONSNR5S479BTA0119
17060000146870L17/dossiers17170600001468561706000014686912BTAPRJLSNR5S479BTA0092
17060000146885L17/dossiers17170600001468561706000014688412BTAPRJLANR5L17BTA0320
17060000146909L17/dossiers17170600001468951706000014690812BTAPIONSNR5S479BTA0124
17060000146937L17/dossiers17170600001469231706000014693612BTAPRJLSNR5S479BTA0093
17060000146951L17/dossiers17170600001469231706000014695012BTAPRJLANR5L17BTA0333
17060000147048L17/dossiers17170600001469721706000014704712BTAPIONSNR5S479BTA0134
17060000147403L17/dossiers17170600001473861706000014740212BTAPIONSNR5S479BTA0121
17060000147495L17/dossiers17170600001474811706000014749412BTAPIONSNR5S479BTA0101
17060000147551L17/dossiers17170600001475361706000014755012BTAPRJLSNR5S479BTA0090
17060000147574L17/dossiers17170600001475361706000014757312BTAPRJLANR5L17BTA0326
17060000147575L17/dossiers17170600001475361706000014757322TAPPRJLANR5L17TAP0326
17060000147590L17/dossiers17170600001475361706000014758912BTAPRJLANR5L17BTA0329
17060000147591L17/dossiers17170600001475361706000014758922TAPPRJLANR5L17TAP0329
17060000147594L17/dossiers17170600001475361706000014759312BTARAPPSNR5S479BTA0160