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
17060000147661L17/dossiers17170600001476461706000014766012BTAPRJLSNR5S479BTA0091
17060000147684L17/dossiers17170600001476461706000014768312BTAPRJLANR5L17BTA0327
17060000147685L17/dossiers17170600001476461706000014768322TAPPRJLANR5L17TAP0327
17060000147700L17/dossiers17170600001476461706000014769912BTAPRJLANR5L17BTA0330
17060000147701L17/dossiers17170600001476461706000014769922TAPPRJLANR5L17TAP0330
17060000147704L17/dossiers17170600001476461706000014770312BTAPRJLSNR5S479BTA0161
17060000147728L17/dossiers17170600001477111706000014772712BTAPIONSNR5S479BTA0102
17060000147748L17/dossiers17170600001477341706000014774712BTAPIONSNR5S479BTA0128
17060000147773L17/dossiers17170600001477571706000014777212BTARIONANR5L17BTA0289
17060000147789L17/dossiers17170600001477741706000014778812BTAPRJLSNR5S479BTA0118
17060000147816L17/dossiers17170600001477741706000014781512BTAPRJLANR5L17BTA0331
17060000147817L17/dossiers17170600001477741706000014781522TAPPRJLANR5L17TAP0331
17060000147833L17/dossiers17170600001477741706000014783212BTAPRJLSNR5S479BTA0164
17060000147837L17/dossiers17170600001477741706000014783612BTAPRJLANR5L17BTA0340
17060000147838L17/dossiers17170600001477741706000014783622TAPPRJLANR5L17TAP0340
17060000147860L17/dossiers17170600001478461706000014785912BTAPRJLSNR5S479BTA0080
17060000147871L17/dossiers17170600001478461706000014787012BTAPRJLANR5L17BTA0274
17060000147880L17/dossiers17170600001478461706000014787912BTAPRJLSNR5S479BTA0114
17060000147891L17/dossiers17170600001478461706000014789012BTAPRJLANR5L17BTA0296
17060000147892L17/dossiers17170600001478461706000014789022TAPPRJLANR5L17TAP0296
17060000148001L17/dossiers17170600001479831706000014800012BTAPIONANR5L17BTA0286
17060000148002L17/dossiers17170600001479831706000014800022TAPPIONANR5L17TAP0286
17060000148013L17/dossiers17170600001479831706000014801212BTAPIONSNR5S479BTA0155
17060000148028L17/dossiers17170600001479831706000014802712BTAPIONANR5L17BTA0336
17060000148029L17/dossiers17170600001479831706000014802722TAPPIONANR5L17TAP0336
17060000148033L17/dossiers17170600001479831706000014803212BTAPIONSNR5S479BTA0165
17060000148168L17/dossiers17170600001481551706000014816712BTAPIONSNR5S479BTA0120
17060000148297L17/dossiers17170600001482311706000014829612BTAPRJLANR5L17BTA0287
17060000148298L17/dossiers17170600001482311706000014829622TAPPRJLANR5L17TAP0287
17060000148310L17/dossiers17170600001482311706000014830912BTAPRJLSNR5S479BTA0127
17060000148324L17/dossiers17170600001482311706000014832312BTAPRJLSNR5S479BTA0151
17060000148328L17/dossiers17170600001482311706000014832712BTAPRJLANR5L17BTA0325
17060000148329L17/dossiers17170600001482311706000014832722TAPPRJLANR5L17TAP0325
17060000148387L17/dossiers17170600001483361706000014838612BTAPRJLANR5L17BTA0295
17060000148388L17/dossiers17170600001483361706000014838622TAPPRJLANR5L17TAP0295
17060000148401L17/dossiers17170600001483361706000014840012BTAPRJLSNR5S479BTA0152
17060000148418L17/dossiers17170600001483361706000014841712BTAPRJLANR5L17BTA0337
17060000148419L17/dossiers17170600001483361706000014841722TAPPRJLANR5L17TAP0337
17060000148423L17/dossiers17170600001483361706000014842212BTAPRJLSNR5S479BTA0166
17060000148462L17/dossiers17170600001484461706000014846112BTARIONANR5L17BTA0342
17060000148477L17/dossiers17170600001484631706000014847612BTAPRJLSNR5S479BTA0117
17060000148505L17/dossiers17170600001484931706000014850412BTAPIONSNR5S479BTA0137
17060000148733L17/dossiers17170600001487181706000014873212BTAPIONANR5L17BTA0292
17060000148734L17/dossiers17170600001487181706000014873222TAPPIONANR5L17TAP0292
17060000148778L17/dossiers17170600001487611706000014877712BTAPIONANR5L17BTA0300
17060000148779L17/dossiers17170600001487611706000014877722TAPPIONANR5L17TAP0300
17060000148848L17/dossiers17170600001488331706000014884712BTAPRJLSNR5S479BTA0149
17060000148885L17/dossiers17170600001488711706000014888412BTAPRJLSNR5S479BTA0147
17060000148909L17/dossiers17170600001488951706000014890812BTAPRJLSNR5S479BTA0148
17060000149049L17/dossiers17170600001490311706000014904812BTAPRJLANR5L17BTA0306