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 |
|---|---|---|---|---|---|---|---|---|---|
| 17060000149108 | L17/dossiers | 17 | 17060000149031 | 17060000149107 | 1 | 2 | BTA | PRJLSNR5S479BTA0145 | |
| 17060000149169 | L17/dossiers | 17 | 17060000149144 | 17060000149168 | 1 | 2 | BTA | PRJLANR5L17BTA0318 | |
| 17060000149170 | L17/dossiers | 17 | 17060000149144 | 17060000149168 | 2 | 2 | TAP | PRJLANR5L17TAP0318 | |
| 17060000149257 | L17/dossiers | 17 | 17060000149239 | 17060000149256 | 1 | 2 | BTA | PIONANR5L17BTA0294 | |
| 17060000149258 | L17/dossiers | 17 | 17060000149239 | 17060000149256 | 2 | 2 | TAP | PIONANR5L17TAP0294 | |
| 17060000149287 | L17/dossiers | 17 | 17060000149271 | 17060000149286 | 1 | 2 | BTA | PIONANR5L17BTA0311 | |
| 17060000149288 | L17/dossiers | 17 | 17060000149271 | 17060000149286 | 2 | 2 | TAP | PIONANR5L17TAP0311 | |
| 17060000149471 | L17/dossiers | 17 | 17060000149455 | 17060000149470 | 1 | 2 | BTA | RIONANR5L17BTA0344 | |
| 17060000149521 | L17/dossiers | 17 | 17060000149508 | 17060000149520 | 1 | 2 | BTA | PRJLSNR5S479BTA0139 | |
| 17060000149941 | L17/dossiers | 17 | 17060000149928 | 17060000149940 | 1 | 2 | BTA | PRJLSNR5S479BTA0126 | |
| 17060000150105 | L17/dossiers | 17 | 17060000150076 | 17060000150104 | 1 | 2 | BTA | PRJLANR5L17BTA0338 | |
| 17060000150106 | L17/dossiers | 17 | 17060000150076 | 17060000150104 | 2 | 2 | TAP | PRJLANR5L17TAP0338 | |
| 17060000150135 | L17/dossiers | 17 | 17060000150112 | 17060000150134 | 1 | 2 | BTA | PRJLANR5L17BTA0307 | |
| 17060000150146 | L17/dossiers | 17 | 17060000150112 | 17060000150145 | 1 | 2 | BTA | PRJLSNR5S479BTA0146 | |
| 17060000150206 | L17/dossiers | 17 | 17060000150193 | 17060000150205 | 1 | 2 | BTA | PRJLSNR5S479BTA0158 | |
| 17060000150234 | L17/dossiers | 17 | 17060000150219 | 17060000150233 | 1 | 2 | BTA | RIONANR5L17BTA0343 | |
| 17060000151053 | L17/dossiers | 17 | 17060000151040 | 17060000151052 | 1 | 2 | BTA | PRJLSNR5S479BTA0157 | |
| 17060000152982 | L17/dossiers | 17 | 17060000152969 | 17060000152981 | 1 | 2 | BTA | PIONSNR5S156BTA0070 | |
| 16060000089905 | L16/dossiers | 16 | 16060000089893 | 16060000089904 | 1 | 2 | BTA | PIONSNR5S167BTA0079 | |
| 16060000089949 | L16/dossiers | 16 | 16060000089931 | 16060000089948 | 1 | 2 | BTA | PIONANR5L11BTA0505 | |
| 16060000089961 | L16/dossiers | 16 | 16060000089931 | 16060000089960 | 1 | 2 | BTA | PIONSNR5S198BTA0021 | |
| 16060000089994 | L16/dossiers | 16 | 16060000089982 | 16060000089993 | 1 | 2 | BTA | PIONSNR5S170BTA0092 | |
| 16060000090037 | L16/dossiers | 16 | 16060000090025 | 16060000090036 | 1 | 2 | BTA | PIONSNR5S170BTA0103 | |
| 16060000090080 | L16/dossiers | 16 | 16060000090068 | 16060000090079 | 1 | 2 | BTA | PIONSNR5S170BTA0104 | |
| 16060000090123 | L16/dossiers | 16 | 16060000090111 | 16060000090122 | 1 | 2 | BTA | PIONSNR5S171BTA0061 | |
| 16060000090172 | L16/dossiers | 16 | 16060000090159 | 16060000090171 | 1 | 2 | BTA | PIONSNR5S190BTA0054 | |
| 16060000090211 | L16/dossiers | 16 | 16060000090198 | 16060000090210 | 1 | 2 | BTA | PIONSNR5S174BTA0118 | |
| 16060000090250 | L16/dossiers | 16 | 16060000090237 | 16060000090249 | 1 | 2 | BTA | PIONSNR5S194BTA0010 | |
| 16060000090284 | L16/dossiers | 16 | 16060000090271 | 16060000090283 | 1 | 2 | BTA | PIONSNR5S194BTA0079 | |
| 16060000090318 | L16/dossiers | 16 | 16060000090305 | 16060000090317 | 1 | 2 | BTA | PIONSNR5S196BTA0022 | |
| 16060000090354 | L16/dossiers | 16 | 16060000090341 | 16060000090353 | 1 | 2 | BTA | PIONSNR5S196BTA0093 | |
| 16060000090391 | L16/dossiers | 16 | 16060000090375 | 16060000090390 | 1 | 2 | BTA | PIONANR5L13BTA0489 | |
| 16060000090404 | L16/dossiers | 16 | 16060000090375 | 16060000090403 | 1 | 2 | BTA | PIONSNR5S197BTA0092 | |
| 16060000090438 | L16/dossiers | 16 | 16060000090425 | 16060000090437 | 1 | 2 | BTA | PIONSNR5S197BTA0102 | |
| 16060000090477 | L16/dossiers | 16 | 16060000090459 | 16060000090476 | 1 | 2 | BTA | PIONSNR5S197BTA0103 | |
| 16060000090511 | L16/dossiers | 16 | 16060000090498 | 16060000090510 | 1 | 2 | BTA | PIONSNR5S198BTA0050 | |
| 16060000090545 | L16/dossiers | 16 | 16060000090532 | 16060000090544 | 1 | 2 | BTA | PIONSNR5S199BTA0016 | |
| 16060000090574 | L16/dossiers | 16 | 16060000090561 | 16060000090573 | 1 | 2 | BTA | PIONSNR5S199BTA0079 | |
| 16060000090603 | L16/dossiers | 16 | 16060000090590 | 16060000090602 | 1 | 2 | BTA | PIONSNR5S199BTA0101 | |
| 16060000090638 | L16/dossiers | 16 | 16060000090624 | 16060000090637 | 1 | 2 | BTA | PIONSNR5S199BTA0102 | |
| 16060000090677 | L16/dossiers | 16 | 16060000090664 | 16060000090676 | 1 | 2 | BTA | PIONSNR5S199BTA0184 | |
| 16060000090708 | L16/dossiers | 16 | 16060000090693 | 16060000090707 | 1 | 2 | BTA | PIONSNR5S219BTA0004 | |
| 16060000090743 | L16/dossiers | 16 | 16060000090730 | 16060000090742 | 1 | 2 | BTA | PIONSNR5S219BTA0010 | |
| 16060000090772 | L16/dossiers | 16 | 16060000090759 | 16060000090771 | 1 | 2 | BTA | PIONSNR5S219BTA0068 | |
| 16060000090801 | L16/dossiers | 16 | 16060000090788 | 16060000090800 | 1 | 2 | BTA | PIONSNR5S219BTA0034 | |
| 16060000090835 | L16/dossiers | 16 | 16060000090817 | 16060000090834 | 1 | 2 | BTA | PIONSNR5S219BTA0125 | |
| 16060000090864 | L16/dossiers | 16 | 16060000090851 | 16060000090863 | 1 | 2 | BTA | PIONSNR5S219BTA0123 | |
| 16060000090893 | L16/dossiers | 16 | 16060000090880 | 16060000090892 | 1 | 2 | BTA | PIONSNR5S219BTA0134 | |
| 16060000090922 | L16/dossiers | 16 | 16060000090909 | 16060000090921 | 1 | 2 | BTA | PIONSNR5S219BTA0135 | |
| 16060000090952 | L16/dossiers | 16 | 16060000090938 | 16060000090951 | 1 | 2 | BTA | PIONSNR5S219BTA0138 |