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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000132599 | L15/dossiers | 15 | 15060000132533 | 15060000132598 | 1 | 2 | BTA | PRJLSNR5S299BTA0020 | |
| 15060000132624 | L15/dossiers | 15 | 15060000132533 | 15060000132623 | 1 | 2 | BTA | PRJLANR5L15BTA0037 | |
| 15060000132625 | L15/dossiers | 15 | 15060000132533 | 15060000132623 | 2 | 2 | TAP | PRJLANR5L15TAP0037 | |
| 15060000132635 | L15/dossiers | 15 | 15060000132533 | 15060000132634 | 1 | 2 | BTA | PRJLSNR5S299BTA0023 | |
| 15060000132645 | L15/dossiers | 15 | 15060000132533 | 15060000132644 | 1 | 2 | BTA | PRJLANR5L15BTA0041 | |
| 15060000132646 | L15/dossiers | 15 | 15060000132533 | 15060000132644 | 2 | 2 | TAP | PRJLANR5L15TAP0041 | |
| 15060000132673 | L15/dossiers | 15 | 15060000132654 | 15060000132672 | 1 | 2 | BTA | PRJLANR5L15BTA0055 | |
| 15060000132685 | L15/dossiers | 15 | 15060000132654 | 15060000132684 | 1 | 2 | BTA | PRJLSNR5S299BTA0061 | |
| 15060000132831 | L15/dossiers | 15 | 15060000132814 | 15060000132830 | 1 | 2 | BTA | PIONANR5L15BTA0039 | |
| 15060000132832 | L15/dossiers | 15 | 15060000132814 | 15060000132830 | 2 | 2 | TAP | PIONANR5L15TAP0039 | |
| 15060000132844 | L15/dossiers | 15 | 15060000132814 | 15060000132843 | 1 | 2 | BTA | PIONSNR5S299BTA0031 | |
| 15060000132858 | L15/dossiers | 15 | 15060000132814 | 15060000132857 | 1 | 2 | BTA | PIONSNR5S299BTA0041 | |
| 15060000132862 | L15/dossiers | 15 | 15060000132814 | 15060000132861 | 1 | 2 | BTA | PIONANR5L15BTA0068 | |
| 15060000132863 | L15/dossiers | 15 | 15060000132814 | 15060000132861 | 2 | 2 | TAP | PIONANR5L15TAP0068 | |
| 15060000133013 | L15/dossiers | 15 | 15060000133004 | 15060000133012 | 1 | 2 | BTA | RIONANR5L15BTA0042 | |
| 15060000133036 | L15/dossiers | 15 | 15060000133021 | 15060000133035 | 1 | 2 | BTA | PRJLSNR5S299BTA0016 | |
| 15060000133049 | L15/dossiers | 15 | 15060000133021 | 15060000133048 | 1 | 2 | BTA | PRJLANR5L15BTA0056 | |
| 15060000133076 | L15/dossiers | 15 | 15060000133059 | 15060000133075 | 1 | 2 | BTA | PIONANR5L15BTA0045 | |
| 15060000133077 | L15/dossiers | 15 | 15060000133059 | 15060000133075 | 2 | 2 | TAP | PIONANR5L15TAP0045 | |
| 15060000133089 | L15/dossiers | 15 | 15060000133059 | 15060000133088 | 1 | 2 | BTA | PIONSNR5S299BTA0049 | |
| 15060000133102 | L15/dossiers | 15 | 15060000133059 | 15060000133101 | 1 | 2 | BTA | PIONANR5L15BTA0090 | |
| 15060000133103 | L15/dossiers | 15 | 15060000133059 | 15060000133101 | 2 | 2 | TAP | PIONANR5L15TAP0090 | |
| 15060000133182 | L15/dossiers | 15 | 15060000133164 | 15060000133181 | 1 | 2 | BTA | PRJLANR5L15BTA0119 | |
| 15060000133194 | L15/dossiers | 15 | 15060000133164 | 15060000133193 | 1 | 2 | BTA | PRJLSNR5S299BTA0148 | |
| 15060000133215 | L15/dossiers | 15 | 15060000133197 | 15060000133214 | 1 | 2 | BTA | PRJLANR5L15BTA0146 | |
| 15060000133227 | L15/dossiers | 15 | 15060000133197 | 15060000133226 | 1 | 2 | BTA | PRJLSNR5S319BTA0018 | |
| 15060000133248 | L15/dossiers | 15 | 15060000133230 | 15060000133247 | 1 | 2 | BTA | PRJLANR5L15BTA0145 | |
| 15060000133260 | L15/dossiers | 15 | 15060000133230 | 15060000133259 | 1 | 2 | BTA | PRJLSNR5S319BTA0004 | |
| 15060000133358 | L15/dossiers | 15 | 15060000133351 | 15060000133357 | 1 | 2 | BTA | RIONANR5L15BTA0038 | |
| 15060000133458 | L15/dossiers | 15 | 15060000133440 | 15060000133457 | 1 | 2 | BTA | PRJLANR5L15BTA0030 | |
| 15060000133470 | L15/dossiers | 15 | 15060000133440 | 15060000133469 | 1 | 2 | BTA | PRJLSNR5S299BTA0018 | |
| 15060000133491 | L15/dossiers | 15 | 15060000133440 | 15060000133490 | 1 | 2 | BTA | PRJLANR5L15BTA0031 | |
| 15060000133501 | L15/dossiers | 15 | 15060000133440 | 15060000133500 | 1 | 2 | BTA | PRJLSNR5S299BTA0019 | |
| 15060000133511 | L15/dossiers | 15 | 15060000133440 | 15060000133510 | 1 | 2 | BTA | PRJLANR5L15BTA0032 | |
| 15060000133561 | L15/dossiers | 15 | 15060000133554 | 15060000133560 | 1 | 2 | BTA | RIONANR5L15BTA0035 | |
| 15060000133576 | L15/dossiers | 15 | 15060000133562 | 15060000133575 | 1 | 2 | BTA | PRJLSNR5S299BTA0062 | |
| 15060000133589 | L15/dossiers | 15 | 15060000133562 | 15060000133588 | 1 | 2 | BTA | PRJLANR5L15BTA0109 | |
| 15060000133667 | L15/dossiers | 15 | 15060000133649 | 15060000133666 | 1 | 2 | BTA | PRJLANR5L15BTA0083 | |
| 15060000133668 | L15/dossiers | 15 | 15060000133649 | 15060000133666 | 2 | 2 | TAP | PRJLANR5L15TAP0083 | |
| 15060000133680 | L15/dossiers | 15 | 15060000133649 | 15060000133679 | 1 | 2 | BTA | PRJLSNR5S299BTA0080 | |
| 15060000133703 | L15/dossiers | 15 | 15060000133649 | 15060000133702 | 1 | 2 | BTA | PRJLANR5L15BTA0154 | |
| 15060000133704 | L15/dossiers | 15 | 15060000133649 | 15060000133702 | 2 | 2 | TAP | PRJLANR5L15TAP0154 | |
| 15060000133714 | L15/dossiers | 15 | 15060000133649 | 15060000133713 | 1 | 2 | BTA | PRJLSNR5S299BTA0146 | |
| 15060000133731 | L15/dossiers | 15 | 15060000133717 | 15060000133730 | 1 | 2 | BTA | PRJLSNR5S299BTA0046 | |
| 15060000133745 | L15/dossiers | 15 | 15060000133717 | 15060000133744 | 1 | 2 | BTA | PRJLANR5L15BTA0174 | |
| 15060000133824 | L15/dossiers | 15 | 15060000133789 | 15060000133823 | 1 | 2 | BTA | PRJLANR5L15BTA0064 | |
| 15060000133825 | L15/dossiers | 15 | 15060000133789 | 15060000133823 | 2 | 2 | TAP | PRJLANR5L15TAP0064 | |
| 15060000133852 | L15/dossiers | 15 | 15060000133789 | 15060000133851 | 1 | 2 | BTA | PRJLSNR5S299BTA0057 | |
| 15060000133866 | L15/dossiers | 15 | 15060000133789 | 15060000133865 | 1 | 2 | BTA | PRJLANR5L15BTA0101 | |
| 15060000133867 | L15/dossiers | 15 | 15060000133789 | 15060000133865 | 2 | 2 | TAP | PRJLANR5L15TAP0101 |