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
16060000111923L16/dossiers16160600001118691606000011192122TAPPRJLANR5L16TAP0170
16060000111938L16/dossiers16160600001118691606000011193712BTAPRJLSNR5S419BTA0017
16060000111942L16/dossiers16160600001118691606000011194112BTAPRJLANR5L16BTA0181
16060000111943L16/dossiers16160600001118691606000011194122TAPPRJLANR5L16TAP0181
16060000112137L16/dossiers16160600001121191606000011213612BTARIONANR5L16BTA0197
16060000112138L16/dossiers16160600001121191606000011213622TAPRIONANR5L16TAP0197
16060000112216L16/dossiers16160600001122021606000011221512BTARIONANR5L16BTA0165
16060000112396L16/dossiers16160600001123771606000011239512BTAPRJLANR5L16BTA0190
16060000112408L16/dossiers16160600001123771606000011240712BTAPRJLSNR5S419BTA0075
16060000112742L16/dossiers16160600001127261606000011274112BTAPIONANR5L16BTA0209
16060000112743L16/dossiers16160600001127261606000011274122TAPPIONANR5L16TAP0209
16060000112755L16/dossiers16160600001127261606000011275412BTAPIONSNR5S419BTA0082
16060000113127L16/dossiers16160600001131091606000011312612BTAPRJLANR5L16BTA0166
16060000113138L16/dossiers16160600001131091606000011313712BTAPRJLSNR5S419BTA0045
16060000113154L16/dossiers16160600001131411606000011315312BTAPIONSNR5S419BTA0053
16060000113169L16/dossiers16160600001131411606000011316812BTAPIONANR5L16BTA0282
16060000113170L16/dossiers16160600001131411606000011316822TAPPIONANR5L16TAP0282
16060000113179L16/dossiers16160600001131411606000011317812BTAPIONSNR5S419BTA0128
16060000113403L16/dossiers16160600001133431606000011340212BTAPIONSNR5S419BTA0055
16060000113586L16/dossiers16160600001135731606000011358512BTAPRJLSNR5S399BTA0166
16060000113599L16/dossiers16160600001135731606000011359812BTAPRJLANR5L16BTA0163
16060000113600L16/dossiers16160600001135731606000011359822TAPPRJLANR5L16TAP0163
16060000113955L16/dossiers16160600001136991606000011395412BTAPRJLANR5L16BTA0178
16060000113956L16/dossiers16160600001136991606000011395422TAPPRJLANR5L16TAP0178
16060000114015L16/dossiers16160600001136991606000011401412BTAPRJLSNR5S419BTA0028
16060000114044L16/dossiers16160600001136991606000011404312BTAPRJLANR5L16BTA0219
16060000114045L16/dossiers16160600001136991606000011404322TAPPRJLANR5L16TAP0219
16060000114054L16/dossiers16160600001136991606000011405312BTAPRJLSNR5S419BTA0040
16060000114069L16/dossiers16160600001136991606000011406812BTAPRJLANR5L16BTA0223
16060000114070L16/dossiers16160600001136991606000011406822TAPPRJLANR5L16TAP0223
16060000114356L16/dossiers16160600001143401606000011435512BTAPIONANR5L16BTA0203
16060000114357L16/dossiers16160600001143401606000011435522TAPPIONANR5L16TAP0203
16060000114369L16/dossiers16160600001143401606000011436812BTAPIONSNR5S419BTA0081
16060000114383L16/dossiers16160600001143401606000011438212BTAPIONSNR5S419BTA0106
16060000114387L16/dossiers16160600001143401606000011438612BTAPIONANR5L16BTA0278
16060000114388L16/dossiers16160600001143401606000011438622TAPPIONANR5L16TAP0278
16060000114453L16/dossiers16160600001144341606000011445212BTAPIONANR5L16BTA0235
16060000114454L16/dossiers16160600001144341606000011445222TAPPIONANR5L16TAP0235
16060000114466L16/dossiers16160600001144341606000011446512BTAPIONSNR5S419BTA0083
16060000114480L16/dossiers16160600001144341606000011447912BTAPIONSNR5S419BTA0104
16060000114484L16/dossiers16160600001144341606000011448312BTAPIONANR5L16BTA0281
16060000114485L16/dossiers16160600001144341606000011448322TAPPIONANR5L16TAP0281
16060000114905L16/dossiers16160600001148891606000011490412BTAPIONANR5L16BTA0274
16060000114906L16/dossiers16160600001148891606000011490422TAPPIONANR5L16TAP0274
16060000114960L16/dossiers16160600001149471606000011495912BTAPIONSNR5S419BTA0056
16060000114976L16/dossiers16160600001149471606000011497512BTAPIONANR5L16BTA0296
16060000114977L16/dossiers16160600001149471606000011497522TAPPIONANR5L16TAP0296
16060000115073L16/dossiers16160600001150541606000011507212BTAPRJLANR5L16BTA0191
16060000115084L16/dossiers16160600001150541606000011508312BTAPRJLSNR5S419BTA0061
16060000115269L16/dossiers16160600001152321606000011526812BTAPIONSNR5S419BTA0026