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
17060000118393L17/dossiers17170600001183661706000011839212BTAPIONSNR5S459BTA0142
17060000118406L17/dossiers17170600001183661706000011840512BTAPIONANR5L17BTA0297
17060000118407L17/dossiers17170600001183661706000011840522TAPPIONANR5L17TAP0297
17060000118423L17/dossiers17170600001184101706000011842212BTAPRJLSNR5S419BTA0087
17060000118446L17/dossiers17170600001184101706000011844512BTAPRJLANR5L17BTA0051
17060000118467L17/dossiers17170600001184491706000011846612BTAPIONSNR5S419BTA0078
17060000118496L17/dossiers17170600001184491706000011849512BTAPIONANR5L17BTA0168
17060000118497L17/dossiers17170600001184491706000011849522TAPPIONANR5L17TAP0168
17060000118508L17/dossiers17170600001184491706000011850712BTAPIONSNR5S479BTA0005
17060000118520L17/dossiers17170600001184491706000011851912BTAPIONANR5L17BTA0187
17060000118521L17/dossiers17170600001184491706000011851922TAPPIONANR5L17TAP0187
17060000118541L17/dossiers17170600001185241706000011854012BTAPIONANR5L16BTA0259
17060000118542L17/dossiers17170600001185241706000011854022TAPPIONANR5L16TAP0259
17060000118554L17/dossiers17170600001185241706000011855312BTAPIONSNR5S459BTA0117
17060000118567L17/dossiers17170600001185241706000011856612BTAPIONSNR5S459BTA0146
17060000118571L17/dossiers17170600001185241706000011857012BTAPIONANR5L17BTA0151
17060000118572L17/dossiers17170600001185241706000011857022TAPPIONANR5L17TAP0151
17060000118592L17/dossiers17170600001185761706000011859112BTAPIONANR5L16BTA0258
17060000118593L17/dossiers17170600001185761706000011859122TAPPIONANR5L16TAP0258
17060000118605L17/dossiers17170600001185761706000011860412BTAPIONSNR5S459BTA0136
17060000118619L17/dossiers17170600001185761706000011861812BTAPIONANR5L17BTA0321
17060000118620L17/dossiers17170600001185761706000011861822TAPPIONANR5L17TAP0321
17060000118623L17/dossiers17170600001185761706000011862212BTAPIONSNR5S479BTA0150
17060000118643L17/dossiers17170600001186271706000011864212BTAPIONSNR5S419BTA0091
17060000118674L17/dossiers17170600001186541706000011867312BTAPIONANR5L16BTA0269
17060000118675L17/dossiers17170600001186541706000011867322TAPPIONANR5L16TAP0269
17060000118687L17/dossiers17170600001186541706000011868612BTAPIONSNR5S419BTA0135
17060000118701L17/dossiers17170600001186541706000011870012BTAPIONSNR5S419BTA0143
17060000118705L17/dossiers17170600001186541706000011870412BTAPIONANR5L16BTA0310
17060000118706L17/dossiers17170600001186541706000011870422TAPPIONANR5L16TAP0310
17060000118731L17/dossiers17170600001187121706000011873012BTAPRJLANR5L16BTA0288
17060000118743L17/dossiers17170600001187121706000011874212BTAPRJLSNR5S459BTA0019
17060000118759L17/dossiers17170600001187461706000011875812BTAPIONSNR5S419BTA0110
17060000118792L17/dossiers17170600001187751706000011879112BTAPIONANR5L16BTA0276
17060000118793L17/dossiers17170600001187751706000011879122TAPPIONANR5L16TAP0276
17060000118804L17/dossiers17170600001187751706000011880312BTAPIONSNR5S419BTA0140
17060000118824L17/dossiers17170600001187751706000011882312BTAPIONANR5L17BTA0057
17060000118825L17/dossiers17170600001187751706000011882322TAPPIONANR5L17TAP0057
17060000118842L17/dossiers17170600001188281706000011884112BTAPIONSNR5S419BTA0117
17060000118866L17/dossiers17170600001188531706000011886512BTAPIONSNR5S419BTA0116
17060000118887L17/dossiers17170600001188531706000011888612BTAPIONANR5L17BTA0061
17060000118888L17/dossiers17170600001188531706000011888622TAPPIONANR5L17TAP0061
17060000118905L17/dossiers17170600001188911706000011890412BTAPRJLSNR5S419BTA0133
17060000118927L17/dossiers17170600001188911706000011892612BTAPRJLANR5L17BTA0050
17060000119033L17/dossiers17170600001189301706000011903212BTAPIONSNR5S459BTA0058
17060000119052L17/dossiers17170600001190391706000011905112BTAPIONSNR5S419BTA0138
17060000119128L17/dossiers17170600001190741706000011912712BTAPRJLANR5L16BTA0300
17060000119129L17/dossiers17170600001190741706000011912722TAPPRJLANR5L16TAP0300
17060000119142L17/dossiers17170600001190741706000011914112BTAPRJLSNR5S459BTA0057
17060000119158L17/dossiers17170600001190741706000011915712BTAPRJLSNR5S459BTA0061