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
16060000118492L16/dossiers16160600001184631606000011849112BTAPIONSNR5S419BTA0123
16060000118506L16/dossiers16160600001184631606000011850512BTAPIONSNR5S419BTA0144
16060000118510L16/dossiers16160600001184631606000011850912BTAPIONANR5L16BTA0309
16060000118511L16/dossiers16160600001184631606000011850922TAPPIONANR5L16TAP0309
16060000118553L16/dossiers16160600001185361606000011855212BTAPIONANR5L16BTA0226
16060000118554L16/dossiers16160600001185361606000011855222TAPPIONANR5L16TAP0226
16060000118672L16/dossiers16160600001186581606000011867112BTAPRJLSNR5S419BTA0074
16060000118687L16/dossiers16160600001186581606000011868612BTAPRJLANR5L16BTA0289
16060000118757L16/dossiers16160600001187371606000011875612BTAPRJLANR5L16BTA0233
16060000118769L16/dossiers16160600001187371606000011876812BTAPRJLSNR5S419BTA0073
16060000118775L16/dossiers16160600001187371606000011877412BTAPRJLCGR5L16BTA0000
16060000118803L16/dossiers16160600001187781606000011880212BTAPRJLANR5L16BTA0229
16060000118804L16/dossiers16160600001187781606000011880222TAPPRJLANR5L16TAP0229
16060000118816L16/dossiers16160600001187781606000011881512BTAPRJLSNR5S419BTA0076
16060000118831L16/dossiers16160600001187781606000011883012BTAPRJLANR5L16BTA0264
16060000118832L16/dossiers16160600001187781606000011883022TAPPRJLANR5L16TAP0264
16060000118836L16/dossiers16160600001187781606000011883512BTAPRJLSNR5S419BTA0099
16060000118859L16/dossiers16160600001188471606000011885812BTAPIONSNR5S419BTA0059
16060000118881L16/dossiers16160600001188741606000011888012BTARIONANR5L16BTA0295
16060000118902L16/dossiers16160600001188901606000011890112BTAPIONSNR5S419BTA0077
16060000118928L16/dossiers16160600001189121606000011892712BTAPIONANR5L16BTA0253
16060000118929L16/dossiers16160600001189121606000011892722TAPPIONANR5L16TAP0253
16060000118941L16/dossiers16160600001189121606000011894012BTAPIONSNR5S419BTA0132
16060000118967L16/dossiers16160600001189541606000011896612BTAPIONSNR5S419BTA0096
16060000119037L16/dossiers16160600001190231606000011903612BTAPRJLSNR5S419BTA0067
16060000119058L16/dossiers16160600001190231606000011905712BTAPRJLANR5L16BTA0263
16060000119059L16/dossiers16160600001190231606000011905722TAPPRJLANR5L16TAP0263
16060000119074L16/dossiers16160600001190231606000011907312BTAPRJLSNR5S419BTA0113
16060000119078L16/dossiers16160600001190231606000011907712BTAPRJLANR5L16BTA0284
16060000119079L16/dossiers16160600001190231606000011907722TAPPRJLANR5L16TAP0284
16060000119100L16/dossiers16160600001190861606000011909912BTAPRJLSNR5S419BTA0066
16060000119130L16/dossiers16160600001190861606000011912912BTAPRJLANR5L16BTA0262
16060000119131L16/dossiers16160600001190861606000011912922TAPPRJLANR5L16TAP0262
16060000119148L16/dossiers16160600001190861606000011914712BTARAPPSNR5S419BTA0112
16060000119152L16/dossiers16160600001190861606000011915112BTAPRJLANR5L16BTA0283
16060000119153L16/dossiers16160600001190861606000011915122TAPPRJLANR5L16TAP0283
16060000119266L16/dossiers16160600001192481606000011926512BTAPIONANR5L16BTA0293
16060000119267L16/dossiers16160600001192481606000011926522TAPPIONANR5L16TAP0293
16060000119391L16/dossiers16160600001193831606000011939012BTARIONANR5L16BTA0227
16060000119406L16/dossiers16160600001193921606000011940512BTAPIONSNR5S419BTA0068
16060000119483L16/dossiers16160600001194641606000011948212BTARIONANR5L16BTA0248
16060000119507L16/dossiers16160600001194911606000011950612BTAPIONANR5L16BTA0246
16060000119508L16/dossiers16160600001194911606000011950622TAPPIONANR5L16TAP0246
16060000119519L16/dossiers16160600001194911606000011951812BTAPIONSNR5S419BTA0125
16060000119554L16/dossiers16160600001195391606000011955312BTAPIONANR5L16BTA0247
16060000119555L16/dossiers16160600001195391606000011955322TAPPIONANR5L16TAP0247
16060000119587L16/dossiers16160600001195721606000011958612BTAPIONANR5L16BTA0245
16060000119588L16/dossiers16160600001195721606000011958622TAPPIONANR5L16TAP0245
16060000119669L16/dossiers16160600001196561606000011966812BTAPRJLSNR5S419BTA0087
16060000119804L16/dossiers16160600001197861606000011980312BTAPIONSNR5S419BTA0078