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
17060000119179L17/dossiers17170600001191661706000011917812BTAPIONSNR5S419BTA0139
17060000119202L17/dossiers17170600001191901706000011920112BTAPIONSNR5S459BTA0023
17060000119223L17/dossiers17170600001192081706000011922212BTAPIONSNR5S459BTA0002
17060000119238L17/dossiers17170600001192081706000011923712BTAPIONANR5L17BTA0044
17060000119239L17/dossiers17170600001192081706000011923722TAPPIONANR5L17TAP0044
17060000119259L17/dossiers17170600001192421706000011925812BTAPIONANR5L16BTA0307
17060000119260L17/dossiers17170600001192421706000011925822TAPPIONANR5L16TAP0307
17060000119271L17/dossiers17170600001192421706000011927012BTAPIONSNR5S459BTA0014
17060000119286L17/dossiers17170600001192421706000011928512BTAPIONANR5L17BTA0035
17060000119287L17/dossiers17170600001192421706000011928522TAPPIONANR5L17TAP0035
17060000119304L17/dossiers17170600001192901706000011930312BTAPRJLSNR5S459BTA0018
17060000119326L17/dossiers17170600001192901706000011932512BTAPRJLANR5L17BTA0078
17060000119343L17/dossiers17170600001193291706000011934212BTAPRJLSNR5S459BTA0017
17060000119358L17/dossiers17170600001193291706000011935712BTAPRJLANR5L17BTA0076
17060000119377L17/dossiers17170600001193611706000011937612BTAPIONSNR5S459BTA0003
17060000119392L17/dossiers17170600001193611706000011939112BTAPIONANR5L17BTA0045
17060000119393L17/dossiers17170600001193611706000011939122TAPPIONANR5L17TAP0045
17060000119411L17/dossiers17170600001193961706000011941012BTAPIONSNR5S459BTA0004
17060000119447L17/dossiers17170600001193961706000011944612BTAPIONANR5L17BTA0149
17060000119456L17/dossiers17170600001193961706000011945512BTAPIONSNR5S459BTA0167
17060000119476L17/dossiers17170600001194641706000011947512BTAPIONSNR5S459BTA0001
17060000119492L17/dossiers17170600001194641706000011949112BTAPIONANR5L17BTA0072
17060000119493L17/dossiers17170600001194641706000011949122TAPPIONANR5L17TAP0072
17060000119513L17/dossiers17170600001194991706000011951212BTAPRJLSNR5S459BTA0008
17060000119553L17/dossiers17170600001194991706000011955212BTAPRJLANR5L17BTA0144
17060000119554L17/dossiers17170600001194991706000011955222TAPPRJLANR5L17TAP0144
17060000119570L17/dossiers17170600001194991706000011956912BTAPRJLANR5L17BTA0273
17060000119571L17/dossiers17170600001194991706000011956922TAPPRJLANR5L17TAP0273
17060000119575L17/dossiers17170600001194991706000011957412BTAPRJLSNR5S479BTA0095
17060000119597L17/dossiers17170600001195831706000011959612BTAPIONSNR5S459BTA0007
17060000119612L17/dossiers17170600001195831706000011961112BTAPIONANR5L17BTA0071
17060000119613L17/dossiers17170600001195831706000011961122TAPPIONANR5L17TAP0071
17060000119623L17/dossiers17170600001195831706000011962212BTAPIONSNR5S459BTA0096
17060000119644L17/dossiers17170600001196261706000011964312BTAPRJLANR5L16BTA0302
17060000119656L17/dossiers17170600001196261706000011965512BTAPRJLSNR5S459BTA0020
17060000119681L17/dossiers17170600001196691706000011968012BTAPIONSNR5S459BTA0013
17060000119702L17/dossiers17170600001196871706000011970112BTAPIONSNR5S459BTA0006
17060000119716L17/dossiers17170600001196871706000011971512BTAPIONANR5L17BTA0011
17060000119717L17/dossiers17170600001196871706000011971522TAPPIONANR5L17TAP0011
17060000119767L17/dossiers17170600001197541706000011976612BTAPRJLSNR5S459BTA0055
17060000119783L17/dossiers17170600001197541706000011978212BTAPRJLANR5L17BTA0173
17060000119938L17/dossiers17170600001199221706000011993712BTAPIONSNR5S459BTA0012
17060000119957L17/dossiers17170600001199221706000011995612BTAPIONANR5L17BTA0010
17060000119958L17/dossiers17170600001199221706000011995622TAPPIONANR5L17TAP0010
17060000119979L17/dossiers17170600001199641706000011997812BTAPIONSNR5S459BTA0045
17060000120018L17/dossiers17170600001199641706000012001712BTAPIONANR5L17BTA0083
17060000120019L17/dossiers17170600001199641706000012001722TAPPIONANR5L17TAP0083
17060000120034L17/dossiers17170600001199641706000012003312BTARAPPSNR5S459BTA0108
17060000120038L17/dossiers17170600001199641706000012003712BTAPIONANR5L17BTA0102
17060000120039L17/dossiers17170600001199641706000012003722TAPPIONANR5L17TAP0102