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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000138670 | L15/dossiers | 15 | 15060000138542 | 15060000138669 | 1 | 2 | BTA | PRJLANR5L15BTA0178 | |
| 15060000138671 | L15/dossiers | 15 | 15060000138542 | 15060000138669 | 2 | 2 | TAP | PRJLANR5L15TAP0178 | |
| 15060000138675 | L15/dossiers | 15 | 15060000138542 | 15060000138674 | 1 | 2 | BTA | PRJLSNR5S319BTA0006 | |
| 15060000138792 | L15/dossiers | 15 | 15060000138779 | 15060000138791 | 1 | 2 | BTA | PIONSNR5S299BTA0103 | |
| 15060000139142 | L15/dossiers | 15 | 15060000139082 | 15060000139141 | 1 | 2 | BTA | PRJLANR5L15BTA0128 | |
| 15060000139143 | L15/dossiers | 15 | 15060000139082 | 15060000139141 | 2 | 2 | TAP | PRJLANR5L15TAP0128 | |
| 15060000139167 | L15/dossiers | 15 | 15060000139082 | 15060000139166 | 1 | 2 | BTA | PRJLSNR5S299BTA0141 | |
| 15060000139194 | L15/dossiers | 15 | 15060000139082 | 15060000139193 | 1 | 2 | BTA | PRJLANR5L15BTA0161 | |
| 15060000139195 | L15/dossiers | 15 | 15060000139082 | 15060000139193 | 2 | 2 | TAP | PRJLANR5L15TAP0161 | |
| 15060000139205 | L15/dossiers | 15 | 15060000139082 | 15060000139204 | 1 | 2 | BTA | PRJLSNR5S299BTA0155 | |
| 15060000139214 | L15/dossiers | 15 | 15060000139082 | 15060000139213 | 1 | 2 | BTA | PRJLANR5L15BTA0167 | |
| 15060000139215 | L15/dossiers | 15 | 15060000139082 | 15060000139213 | 2 | 2 | TAP | PRJLANR5L15TAP0167 | |
| 15060000139289 | L15/dossiers | 15 | 15060000139271 | 15060000139288 | 1 | 2 | BTA | PIONANR5L15BTA0138 | |
| 15060000139430 | L15/dossiers | 15 | 15060000139413 | 15060000139429 | 1 | 2 | BTA | PIONANR5L15BTA0153 | |
| 15060000139431 | L15/dossiers | 15 | 15060000139413 | 15060000139429 | 2 | 2 | TAP | PIONANR5L15TAP0153 | |
| 15060000139443 | L15/dossiers | 15 | 15060000139413 | 15060000139442 | 1 | 2 | BTA | PIONSNR5S299BTA0151 | |
| 15060000139464 | L15/dossiers | 15 | 15060000139446 | 15060000139463 | 1 | 2 | BTA | PIONANR5L15BTA0122 | |
| 15060000139465 | L15/dossiers | 15 | 15060000139446 | 15060000139463 | 2 | 2 | TAP | PIONANR5L15TAP0122 | |
| 15060000139477 | L15/dossiers | 15 | 15060000139446 | 15060000139476 | 1 | 2 | BTA | PIONSNR5S299BTA0142 | |
| 15060000139491 | L15/dossiers | 15 | 15060000139446 | 15060000139490 | 1 | 2 | BTA | PIONSNR5S299BTA0149 | |
| 15060000139495 | L15/dossiers | 15 | 15060000139446 | 15060000139494 | 1 | 2 | BTA | PIONANR5L15BTA0163 | |
| 15060000139496 | L15/dossiers | 15 | 15060000139446 | 15060000139494 | 2 | 2 | TAP | PIONANR5L15TAP0163 | |
| 15060000139533 | L15/dossiers | 15 | 15060000139514 | 15060000139532 | 1 | 2 | BTA | PIONANR5L15BTA0186 | |
| 15060000139534 | L15/dossiers | 15 | 15060000139514 | 15060000139532 | 2 | 2 | TAP | PIONANR5L15TAP0186 | |
| 15060000139562 | L15/dossiers | 15 | 15060000139540 | 15060000139561 | 1 | 2 | BTA | PRJLSNR5S319BTA0007 | |
| 15060000139605 | L15/dossiers | 15 | 15060000139540 | 15060000139604 | 1 | 2 | BTA | PRJLANR5L15BTA0206 | |
| 15060000139606 | L15/dossiers | 15 | 15060000139540 | 15060000139604 | 2 | 2 | TAP | PRJLANR5L15TAP0206 | |
| 15060000139639 | L15/dossiers | 15 | 15060000139540 | 15060000139638 | 1 | 2 | BTA | PRJLANR5L15BTA0216 | |
| 15060000139640 | L15/dossiers | 15 | 15060000139540 | 15060000139638 | 2 | 2 | TAP | PRJLANR5L15TAP0216 | |
| 15060000139650 | L15/dossiers | 15 | 15060000139540 | 15060000139649 | 1 | 2 | BTA | PRJLSNR5S319BTA0061 | |
| 15060000139661 | L15/dossiers | 15 | 15060000139540 | 15060000139660 | 1 | 2 | BTA | PRJLANR5L15BTA0232 | |
| 15060000139662 | L15/dossiers | 15 | 15060000139540 | 15060000139660 | 2 | 2 | TAP | PRJLANR5L15TAP0232 | |
| 15060000139692 | L15/dossiers | 15 | 15060000139670 | 15060000139691 | 1 | 2 | BTA | PRJLSNR5S319BTA0008 | |
| 15060000139735 | L15/dossiers | 15 | 15060000139670 | 15060000139734 | 1 | 2 | BTA | PRJLANR5L15BTA0207 | |
| 15060000139736 | L15/dossiers | 15 | 15060000139670 | 15060000139734 | 2 | 2 | TAP | PRJLANR5L15TAP0207 | |
| 15060000139769 | L15/dossiers | 15 | 15060000139670 | 15060000139768 | 1 | 2 | BTA | PRJLANR5L15BTA0217 | |
| 15060000139770 | L15/dossiers | 15 | 15060000139670 | 15060000139768 | 2 | 2 | TAP | PRJLANR5L15TAP0217 | |
| 15060000139780 | L15/dossiers | 15 | 15060000139670 | 15060000139779 | 1 | 2 | BTA | PRJLSNR5S319BTA0062 | |
| 15060000139792 | L15/dossiers | 15 | 15060000139670 | 15060000139791 | 1 | 2 | BTA | PRJLANR5L15BTA0235 | |
| 15060000139793 | L15/dossiers | 15 | 15060000139670 | 15060000139791 | 2 | 2 | TAP | PRJLANR5L15TAP0235 | |
| 15060000139852 | L15/dossiers | 15 | 15060000139838 | 15060000139851 | 1 | 2 | BTA | RIONANR5L15BTA0142 | |
| 15060000139999 | L15/dossiers | 15 | 15060000139906 | 15060000139998 | 1 | 2 | BTA | PRJLANR5L15BTA0137 | |
| 15060000140000 | L15/dossiers | 15 | 15060000139906 | 15060000139998 | 2 | 2 | TAP | PRJLANR5L15TAP0137 | |
| 15060000140012 | L15/dossiers | 15 | 15060000139906 | 15060000140011 | 1 | 2 | BTA | PRJLSNR5S299BTA0138 | |
| 15060000140103 | L15/dossiers | 15 | 15060000140085 | 15060000140102 | 1 | 2 | BTA | PNREANR5L15BTA0139 | |
| 15060000140203 | L15/dossiers | 15 | 15060000140187 | 15060000140202 | 1 | 2 | BTA | RIONANR5L15BTA0150 | |
| 15060000140204 | L15/dossiers | 15 | 15060000140187 | 15060000140202 | 2 | 2 | TAP | RIONANR5L15TAP0150 | |
| 15060000140219 | L15/dossiers | 15 | 15060000140205 | 15060000140218 | 1 | 2 | BTA | PRJLSNR5S299BTA0143 | |
| 15060000140233 | L15/dossiers | 15 | 15060000140205 | 15060000140232 | 1 | 2 | BTA | PRJLANR5L15BTA0228 | |
| 15060000140323 | L15/dossiers | 15 | 15060000140310 | 15060000140322 | 1 | 2 | BTA | PIONSNR5S299BTA0114 |