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
| # | Colonne | Type | Commentaire |
|---|---|---|---|
| 1 | _id | BIGINT | identifiant : code de la source × 10¹⁰ + rang |
| 2 | _source | VARCHAR | source du catalogue (catalogue.py) |
| 3 | _legislature | BIGINT | colonne constante de la source |
| 4 | _racine_id | BIGINT | _id de la ligne racine |
| 5 | _parent_id | BIGINT | _id de la ligne parente |
| 6 | _ordre | BIGINT | rang dans le tableau d'origine (1…) |
| 7 | _parent_recursif_id | BIGINT | _id de la ligne de même table qui contient celle-ci (structure récursive) |
| 8 | _niveau | BIGINT | profondeur dans la structure récursive (0 = premier niveau) |
| 9 | type_texte | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie.typeTexte · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 % |
| 10 | ref_texte_associe | VARCHAR | dossierParlementaire.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 | _niveau | type_texte | ref_texte_associe |
|---|---|---|---|---|---|---|---|---|---|
| 16060000090983 | L16/dossiers | 16 | 16060000090968 | 16060000090982 | 1 | 2 | BTA | PIONSNR5S239BTA0077 | |
| 16060000091015 | L16/dossiers | 16 | 16060000090999 | 16060000091014 | 1 | 2 | BTA | PIONANR5L14BTA0846 | |
| 16060000091027 | L16/dossiers | 16 | 16060000090999 | 16060000091026 | 1 | 2 | BTA | PIONSNR5S319BTA0036 | |
| 16060000091052 | L16/dossiers | 16 | 16060000091038 | 16060000091051 | 1 | 2 | BTA | PIONSNR5S239BTA0058 | |
| 16060000091081 | L16/dossiers | 16 | 16060000091068 | 16060000091080 | 1 | 2 | BTA | PIONSNR5S239BTA0075 | |
| 16060000091110 | L16/dossiers | 16 | 16060000091097 | 16060000091109 | 1 | 2 | BTA | PIONSNR5S239BTA0104 | |
| 16060000091139 | L16/dossiers | 16 | 16060000091126 | 16060000091138 | 1 | 2 | BTA | PIONSNR5S239BTA0105 | |
| 16060000091168 | L16/dossiers | 16 | 16060000091155 | 16060000091167 | 1 | 2 | BTA | PIONSNR5S259BTA0051 | |
| 16060000091184 | L16/dossiers | 16 | 16060000091155 | 16060000091183 | 1 | 2 | BTA | PIONANR5L14BTA0674 | |
| 16060000091194 | L16/dossiers | 16 | 16060000091155 | 16060000091193 | 1 | 2 | BTA | PIONSNR5S259BTA0114 | |
| 16060000091225 | L16/dossiers | 16 | 16060000091210 | 16060000091224 | 1 | 2 | BTA | PIONANR5L14BTA0658 | |
| 16060000091238 | L16/dossiers | 16 | 16060000091210 | 16060000091237 | 1 | 2 | BTA | PIONSNR5S259BTA0145 | |
| 16060000091267 | L16/dossiers | 16 | 16060000091254 | 16060000091266 | 1 | 2 | BTA | PIONSNR5S259BTA0064 | |
| 16060000091296 | L16/dossiers | 16 | 16060000091283 | 16060000091295 | 1 | 2 | BTA | PIONSNR5S259BTA0079 | |
| 16060000091325 | L16/dossiers | 16 | 16060000091312 | 16060000091324 | 1 | 2 | BTA | PIONSNR5S259BTA0082 | |
| 16060000091354 | L16/dossiers | 16 | 16060000091341 | 16060000091353 | 1 | 2 | BTA | PIONSNR5S259BTA0105 | |
| 16060000091383 | L16/dossiers | 16 | 16060000091370 | 16060000091382 | 1 | 2 | BTA | PIONSNR5S279BTA0007 | |
| 16060000091412 | L16/dossiers | 16 | 16060000091399 | 16060000091411 | 1 | 2 | BTA | PIONSNR5S279BTA0031 | |
| 16060000091441 | L16/dossiers | 16 | 16060000091428 | 16060000091440 | 1 | 2 | BTA | PIONSNR5S279BTA0072 | |
| 16060000091470 | L16/dossiers | 16 | 16060000091457 | 16060000091469 | 1 | 2 | BTA | PIONSNR5S279BTA0100 | |
| 16060000091508 | L16/dossiers | 16 | 16060000091495 | 16060000091507 | 1 | 2 | BTA | PIONSNR5S299BTA0053 | |
| 16060000091532 | L16/dossiers | 16 | 16060000091519 | 16060000091531 | 1 | 2 | BTA | PIONSNR5S299BTA0055 | |
| 16060000091565 | L16/dossiers | 16 | 16060000091551 | 16060000091564 | 1 | 2 | BTA | PIONSNR5S299BTA0008 | |
| 16060000091589 | L16/dossiers | 16 | 16060000091576 | 16060000091588 | 1 | 2 | BTA | PIONSNR5S299BTA0007 | |
| 16060000091613 | L16/dossiers | 16 | 16060000091600 | 16060000091612 | 1 | 2 | BTA | PIONSNR5S299BTA0009 | |
| 16060000091642 | L16/dossiers | 16 | 16060000091624 | 16060000091641 | 1 | 2 | BTA | PIONSNR5S299BTA0051 | |
| 16060000091666 | L16/dossiers | 16 | 16060000091653 | 16060000091665 | 1 | 2 | BTA | PIONSNR5S299BTA0072 | |
| 16060000091695 | L16/dossiers | 16 | 16060000091677 | 16060000091694 | 1 | 2 | BTA | PIONSNR5S299BTA0118 | |
| 16060000091725 | L16/dossiers | 16 | 16060000091706 | 16060000091724 | 1 | 2 | BTA | PIONSNR5S299BTA0122 | |
| 16060000091749 | L16/dossiers | 16 | 16060000091736 | 16060000091748 | 1 | 2 | BTA | PIONSNR5S299BTA0124 | |
| 16060000091773 | L16/dossiers | 16 | 16060000091760 | 16060000091772 | 1 | 2 | BTA | PIONSNR5S319BTA0027 | |
| 16060000091797 | L16/dossiers | 16 | 16060000091784 | 16060000091796 | 1 | 2 | BTA | PIONSNR5S319BTA0028 | |
| 16060000091897 | L16/dossiers | 16 | 16060000091808 | 16060000091896 | 1 | 2 | BTA | PIONSNR5S339BTA0002 | |
| 16060000091921 | L16/dossiers | 16 | 16060000091908 | 16060000091920 | 1 | 2 | BTA | PIONSNR5S319BTA0037 | |
| 16060000091944 | L16/dossiers | 16 | 16060000091932 | 16060000091943 | 1 | 2 | BTA | PIONSNR5S319BTA0051 | |
| 16060000091968 | L16/dossiers | 16 | 16060000091955 | 16060000091967 | 1 | 2 | BTA | PIONSNR5S319BTA0050 | |
| 16060000091992 | L16/dossiers | 16 | 16060000091979 | 16060000091991 | 1 | 2 | BTA | PIONSNR5S319BTA0054 | |
| 16060000092016 | L16/dossiers | 16 | 16060000092003 | 16060000092015 | 1 | 2 | BTA | PIONSNR5S319BTA0068 | |
| 16060000092040 | L16/dossiers | 16 | 16060000092027 | 16060000092039 | 1 | 2 | BTA | PIONSNR5S319BTA0071 | |
| 16060000092064 | L16/dossiers | 16 | 16060000092051 | 16060000092063 | 1 | 2 | BTA | PIONSNR5S319BTA0074 | |
| 16060000092088 | L16/dossiers | 16 | 16060000092075 | 16060000092087 | 1 | 2 | BTA | PIONSNR5S319BTA0087 | |
| 16060000092111 | L16/dossiers | 16 | 16060000092099 | 16060000092110 | 1 | 2 | BTA | PIONSNR5S319BTA0095 | |
| 16060000092135 | L16/dossiers | 16 | 16060000092122 | 16060000092134 | 1 | 2 | BTA | PIONSNR5S319BTA0098 | |
| 16060000092172 | L16/dossiers | 16 | 16060000092146 | 16060000092171 | 1 | 2 | BTA | PRJLANR5L15BTA0324 | |
| 16060000092183 | L16/dossiers | 16 | 16060000092146 | 16060000092182 | 1 | 2 | BTA | PRJLSNR5S419BTA0095 | |
| 16060000092197 | L16/dossiers | 16 | 16060000092184 | 16060000092196 | 1 | 2 | BTA | PIONSNR5S339BTA0010 | |
| 16060000092222 | L16/dossiers | 16 | 16060000092208 | 16060000092221 | 1 | 2 | BTA | PIONSNR5S339BTA0062 | |
| 16060000092259 | L16/dossiers | 16 | 16060000092233 | 16060000092258 | 1 | 2 | BTA | PIONSNR5S339BTA0011 | |
| 16060000092283 | L16/dossiers | 16 | 16060000092270 | 16060000092282 | 1 | 2 | BTA | PIONSNR5S339BTA0019 | |
| 16060000092307 | L16/dossiers | 16 | 16060000092294 | 16060000092306 | 1 | 2 | BTA | PIONSNR5S339BTA0047 |