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
16060000115330L16/dossiers16160600001153141606000011532912BTAPIONANR5L16BTA0238
16060000115331L16/dossiers16160600001153141606000011532922TAPPIONANR5L16TAP0238
16060000115343L16/dossiers16160600001153141606000011534212BTAPIONSNR5S419BTA0092
16060000115390L16/dossiers16160600001153781606000011538912BTAPIONSNR5S419BTA0015
16060000115410L16/dossiers16160600001153961606000011540912BTAPIONSNR5S419BTA0031
16060000115424L16/dossiers16160600001153961606000011542312BTAPIONANR5L16BTA0268
16060000115425L16/dossiers16160600001153961606000011542322TAPPIONANR5L16TAP0268
16060000115463L16/dossiers16160600001154421606000011546212BTAPIONSNR5S419BTA0030
16060000115478L16/dossiers16160600001154421606000011547712BTAPIONANR5L16BTA0272
16060000115479L16/dossiers16160600001154421606000011547722TAPPIONANR5L16TAP0272
16060000115606L16/dossiers16160600001155901606000011560512BTAPIONANR5L16BTA0251
16060000115607L16/dossiers16160600001155901606000011560522TAPPIONANR5L16TAP0251
16060000115768L16/dossiers16160600001157461606000011576712BTAPRJLANR5L16BTA0169
16060000115769L16/dossiers16160600001157461606000011576722TAPPRJLANR5L16TAP0169
16060000115780L16/dossiers16160600001157461606000011577912BTAPRJLSNR5S419BTA0014
16060000115794L16/dossiers16160600001157461606000011579312BTAPRJLSNR5S419BTA0018
16060000115798L16/dossiers16160600001157461606000011579712BTAPRJLANR5L16BTA0182
16060000115799L16/dossiers16160600001157461606000011579722TAPPRJLANR5L16TAP0182
16060000115860L16/dossiers16160600001158061606000011585912BTAPRJLANR5L16BTA0176
16060000115861L16/dossiers16160600001158061606000011585922TAPPRJLANR5L16TAP0176
16060000115878L16/dossiers16160600001158061606000011587712BTAPRJLSNR5S419BTA0022
16060000115906L16/dossiers16160600001158061606000011590512BTAPRJLANR5L16BTA0196
16060000115907L16/dossiers16160600001158061606000011590522TAPPRJLANR5L16TAP0196
16060000115917L16/dossiers16160600001158061606000011591612BTAPRJLSNR5S419BTA0027
16060000115928L16/dossiers16160600001158061606000011592712BTAPRJLANR5L16BTA0201
16060000115929L16/dossiers16160600001158061606000011592722TAPPRJLANR5L16TAP0201
16060000115967L16/dossiers16160600001159511606000011596612BTAPIONSNR5S419BTA0071
16060000116011L16/dossiers16160600001159981606000011601012BTAPIONSNR5S419BTA0009
16060000116027L16/dossiers16160600001159981606000011602612BTAPIONANR5L16BTA0189
16060000116028L16/dossiers16160600001159981606000011602622TAPPIONANR5L16TAP0189
16060000116042L16/dossiers16160600001159981606000011604112BTAPIONANR5L16BTA0214
16060000116043L16/dossiers16160600001159981606000011604122TAPPIONANR5L16TAP0214
16060000116046L16/dossiers16160600001159981606000011604512BTAPIONSNR5S419BTA0035
16060000116082L16/dossiers16160600001160691606000011608112BTAPIONSNR5S419BTA0070
16060000116190L16/dossiers16160600001161741606000011618912BTARIONANR5L16BTA0198
16060000116191L16/dossiers16160600001161741606000011618922TAPRIONANR5L16TAP0198
16060000116238L16/dossiers16160600001162251606000011623712BTAPIONSNR5S419BTA0111
16060000116341L16/dossiers16160600001163211606000011634012BTAPIONANR5L16BTA0234
16060000116342L16/dossiers16160600001163211606000011634022TAPPIONANR5L16TAP0234
16060000116353L16/dossiers16160600001163211606000011635212BTAPIONSNR5S419BTA0101
16060000116419L16/dossiers16160600001164041606000011641812BTAPIONANR5L16BTA0271
16060000116512L16/dossiers16160600001164971606000011651112BTAPIONANR5L16BTA0211
16060000116513L16/dossiers16160600001164971606000011651122TAPPIONANR5L16TAP0211
16060000116581L16/dossiers16160600001165641606000011658012BTAPIONANR5L16BTA0200
16060000116582L16/dossiers16160600001165641606000011658022TAPPIONANR5L16TAP0200
16060000116629L16/dossiers16160600001166121606000011662812BTAPIONANR5L16BTA0199
16060000116655L16/dossiers16160600001166421606000011665412BTAPIONSNR5S419BTA0032
16060000116684L16/dossiers16160600001166771606000011668312BTARIONANR5L16BTA0212
16060000116705L16/dossiers16160600001166921606000011670412BTAPRJLSNR5S419BTA0060
16060000116720L16/dossiers16160600001166921606000011671912BTAPRJLANR5L16BTA0266