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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000142204 | L15/dossiers | 15 | 15060000142194 | 15060000142203 | 1 | 2 | BTA | RIONANR5L15BTA0170 | |
| 15060000142284 | L15/dossiers | 15 | 15060000142270 | 15060000142283 | 1 | 2 | BTA | PRJLSNR5S319BTA0017 | |
| 15060000142297 | L15/dossiers | 15 | 15060000142270 | 15060000142296 | 1 | 2 | BTA | PRJLANR5L15BTA0305 | |
| 15060000142320 | L15/dossiers | 15 | 15060000142300 | 15060000142319 | 1 | 2 | BTA | PIONANR5L15BTA0183 | |
| 15060000142340 | L15/dossiers | 15 | 15060000142321 | 15060000142339 | 1 | 2 | BTA | PIONANR5L15BTA0184 | |
| 15060000142387 | L15/dossiers | 15 | 15060000142369 | 15060000142386 | 1 | 2 | BTA | PRJLANR5L15BTA0218 | |
| 15060000142399 | L15/dossiers | 15 | 15060000142369 | 15060000142398 | 1 | 2 | BTA | PRJLSNR5S319BTA0081 | |
| 15060000142497 | L15/dossiers | 15 | 15060000142483 | 15060000142496 | 1 | 2 | BTA | PRJLSNR5S319BTA0056 | |
| 15060000142511 | L15/dossiers | 15 | 15060000142483 | 15060000142510 | 1 | 2 | BTA | PRJLANR5L15BTA0335 | |
| 15060000142661 | L15/dossiers | 15 | 15060000142644 | 15060000142660 | 1 | 2 | BTA | PIONANR5L15BTA0201 | |
| 15060000142662 | L15/dossiers | 15 | 15060000142644 | 15060000142660 | 2 | 2 | TAP | PIONANR5L15TAP0201 | |
| 15060000142674 | L15/dossiers | 15 | 15060000142644 | 15060000142673 | 1 | 2 | BTA | PIONSNR5S319BTA0070 | |
| 15060000142687 | L15/dossiers | 15 | 15060000142644 | 15060000142686 | 1 | 2 | BTA | PIONANR5L15BTA0394 | |
| 15060000142688 | L15/dossiers | 15 | 15060000142644 | 15060000142686 | 2 | 2 | TAP | PIONANR5L15TAP0394 | |
| 15060000142697 | L15/dossiers | 15 | 15060000142644 | 15060000142696 | 1 | 2 | BTA | PIONSNR5S339BTA0096 | |
| 15060000142711 | L15/dossiers | 15 | 15060000142644 | 15060000142710 | 1 | 2 | BTA | PIONSNR5S339BTA0118 | |
| 15060000142715 | L15/dossiers | 15 | 15060000142644 | 15060000142714 | 1 | 2 | BTA | PIONANR5L15BTA0461 | |
| 15060000142716 | L15/dossiers | 15 | 15060000142644 | 15060000142714 | 2 | 2 | TAP | PIONANR5L15TAP0461 | |
| 15060000142750 | L15/dossiers | 15 | 15060000142737 | 15060000142749 | 1 | 2 | BTA | PIONSNR5S319BTA0009 | |
| 15060000142772 | L15/dossiers | 15 | 15060000142737 | 15060000142771 | 1 | 2 | BTA | PIONANR5L15BTA0226 | |
| 15060000142773 | L15/dossiers | 15 | 15060000142737 | 15060000142771 | 2 | 2 | TAP | PIONANR5L15TAP0226 | |
| 15060000142783 | L15/dossiers | 15 | 15060000142737 | 15060000142782 | 1 | 2 | BTA | PIONSNR5S319BTA0077 | |
| 15060000142858 | L15/dossiers | 15 | 15060000142817 | 15060000142857 | 1 | 2 | BTA | PRJLANR5L15BTA0187 | |
| 15060000142859 | L15/dossiers | 15 | 15060000142817 | 15060000142857 | 2 | 2 | TAP | PRJLANR5L15TAP0187 | |
| 15060000142886 | L15/dossiers | 15 | 15060000142817 | 15060000142885 | 1 | 2 | BTA | PRJLSNR5S319BTA0025 | |
| 15060000142911 | L15/dossiers | 15 | 15060000142817 | 15060000142910 | 1 | 2 | BTA | PRJLANR5L15BTA0196 | |
| 15060000142912 | L15/dossiers | 15 | 15060000142817 | 15060000142910 | 2 | 2 | TAP | PRJLANR5L15TAP0196 | |
| 15060000142922 | L15/dossiers | 15 | 15060000142817 | 15060000142921 | 1 | 2 | BTA | PRJLSNR5S319BTA0030 | |
| 15060000142930 | L15/dossiers | 15 | 15060000142817 | 15060000142929 | 1 | 2 | BTA | PRJLANR5L15BTA0200 | |
| 15060000142931 | L15/dossiers | 15 | 15060000142817 | 15060000142929 | 2 | 2 | TAP | PRJLANR5L15TAP0200 | |
| 15060000142965 | L15/dossiers | 15 | 15060000142949 | 15060000142964 | 1 | 2 | BTA | RIONANR5L15BTA0194 | |
| 15060000143068 | L15/dossiers | 15 | 15060000143050 | 15060000143067 | 1 | 2 | BTA | PRJLSNR5S319BTA0016 | |
| 15060000143096 | L15/dossiers | 15 | 15060000143081 | 15060000143095 | 1 | 2 | BTA | PRJLSNR5S319BTA0015 | |
| 15060000143110 | L15/dossiers | 15 | 15060000143081 | 15060000143109 | 1 | 2 | BTA | PRJLANR5L15BTA0205 | |
| 15060000143111 | L15/dossiers | 15 | 15060000143081 | 15060000143109 | 2 | 2 | TAP | PRJLANR5L15TAP0205 | |
| 15060000143126 | L15/dossiers | 15 | 15060000143081 | 15060000143125 | 1 | 2 | BTA | PRJLANR5L15BTA0215 | |
| 15060000143127 | L15/dossiers | 15 | 15060000143081 | 15060000143125 | 2 | 2 | TAP | PRJLANR5L15TAP0215 | |
| 15060000143131 | L15/dossiers | 15 | 15060000143081 | 15060000143130 | 1 | 2 | BTA | PRJLSNR5S319BTA0048 | |
| 15060000143165 | L15/dossiers | 15 | 15060000143152 | 15060000143164 | 1 | 2 | BTA | PIONSNR5S319BTA0011 | |
| 15060000143181 | L15/dossiers | 15 | 15060000143152 | 15060000143180 | 1 | 2 | BTA | PIONANR5L15BTA0202 | |
| 15060000143182 | L15/dossiers | 15 | 15060000143152 | 15060000143180 | 2 | 2 | TAP | PIONANR5L15TAP0202 | |
| 15060000143192 | L15/dossiers | 15 | 15060000143152 | 15060000143191 | 1 | 2 | BTA | PIONSNR5S319BTA0078 | |
| 15060000143206 | L15/dossiers | 15 | 15060000143152 | 15060000143205 | 1 | 2 | BTA | PIONANR5L15BTA0265 | |
| 15060000143207 | L15/dossiers | 15 | 15060000143152 | 15060000143205 | 2 | 2 | TAP | PIONANR5L15TAP0265 | |
| 15060000143224 | L15/dossiers | 15 | 15060000143210 | 15060000143223 | 1 | 2 | BTA | PIONSNR5S319BTA0012 | |
| 15060000143236 | L15/dossiers | 15 | 15060000143210 | 15060000143235 | 1 | 2 | BTA | PIONANR5L15BTA0247 | |
| 15060000143237 | L15/dossiers | 15 | 15060000143210 | 15060000143235 | 2 | 2 | TAP | PIONANR5L15TAP0247 | |
| 15060000143255 | L15/dossiers | 15 | 15060000143240 | 15060000143254 | 1 | 2 | BTA | PIONSNR5S319BTA0020 | |
| 15060000143289 | L15/dossiers | 15 | 15060000143240 | 15060000143288 | 1 | 2 | BTA | PIONANR5L15BTA0242 | |
| 15060000143290 | L15/dossiers | 15 | 15060000143240 | 15060000143288 | 2 | 2 | TAP | PIONANR5L15TAP0242 |