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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000159685 | L15/dossiers | 15 | 15060000159618 | 15060000159684 | 1 | 2 | BTA | PIONANR5L15BTA0725 | |
| 15060000159686 | L15/dossiers | 15 | 15060000159618 | 15060000159684 | 2 | 2 | TAP | PIONANR5L15TAP0725 | |
| 15060000159718 | L15/dossiers | 15 | 15060000159699 | 15060000159717 | 1 | 2 | BTA | PRJLANR5L15BTA0547 | |
| 15060000159729 | L15/dossiers | 15 | 15060000159699 | 15060000159728 | 1 | 2 | BTA | PRJLSNR5S359BTA0082 | |
| 15060000159818 | L15/dossiers | 15 | 15060000159804 | 15060000159817 | 1 | 2 | BTA | PRJLSNR5S339BTA0126 | |
| 15060000159833 | L15/dossiers | 15 | 15060000159804 | 15060000159832 | 1 | 2 | BTA | PRJLANR5L15BTA0543 | |
| 15060000159974 | L15/dossiers | 15 | 15060000159958 | 15060000159973 | 1 | 2 | BTA | PIONANR5L15BTA0551 | |
| 15060000159975 | L15/dossiers | 15 | 15060000159958 | 15060000159973 | 2 | 2 | TAP | PIONANR5L15TAP0551 | |
| 15060000159987 | L15/dossiers | 15 | 15060000159958 | 15060000159986 | 1 | 2 | BTA | PIONSNR5S359BTA0060 | |
| 15060000160002 | L15/dossiers | 15 | 15060000159958 | 15060000160001 | 1 | 2 | BTA | PIONANR5L15BTA0579 | |
| 15060000160003 | L15/dossiers | 15 | 15060000159958 | 15060000160001 | 2 | 2 | TAP | PIONANR5L15TAP0579 | |
| 15060000160006 | L15/dossiers | 15 | 15060000159958 | 15060000160005 | 1 | 2 | BTA | PIONSNR5S359BTA0088 | |
| 15060000160048 | L15/dossiers | 15 | 15060000160032 | 15060000160047 | 1 | 2 | BTA | PIONANR5L15BTA0428 | |
| 15060000160133 | L15/dossiers | 15 | 15060000160121 | 15060000160132 | 1 | 2 | BTA | PIONSNR5S359BTA0073 | |
| 15060000160147 | L15/dossiers | 15 | 15060000160121 | 15060000160146 | 1 | 2 | BTA | PIONANR5L15BTA0752 | |
| 15060000160148 | L15/dossiers | 15 | 15060000160121 | 15060000160146 | 2 | 2 | TAP | PIONANR5L15TAP0752 | |
| 15060000160158 | L15/dossiers | 15 | 15060000160121 | 15060000160157 | 1 | 2 | BTA | PIONSNR5S379BTA0115 | |
| 15060000160464 | L15/dossiers | 15 | 15060000160383 | 15060000160463 | 1 | 2 | BTA | PRJLANR5L15BTA0410 | |
| 15060000160465 | L15/dossiers | 15 | 15060000160383 | 15060000160463 | 2 | 2 | TAP | PRJLANR5L15TAP0410 | |
| 15060000160565 | L15/dossiers | 15 | 15060000160471 | 15060000160564 | 1 | 2 | BTA | PRJLANR5L15BTA0409 | |
| 15060000160566 | L15/dossiers | 15 | 15060000160471 | 15060000160564 | 2 | 2 | TAP | PRJLANR5L15TAP0409 | |
| 15060000160585 | L15/dossiers | 15 | 15060000160572 | 15060000160584 | 1 | 2 | BTA | PRJLSNR5S339BTA0069 | |
| 15060000160598 | L15/dossiers | 15 | 15060000160572 | 15060000160597 | 1 | 2 | BTA | PRJLANR5L15BTA0481 | |
| 15060000160637 | L15/dossiers | 15 | 15060000160623 | 15060000160636 | 1 | 2 | BTA | PRJLSNR5S339BTA0067 | |
| 15060000160663 | L15/dossiers | 15 | 15060000160623 | 15060000160662 | 1 | 2 | BTA | PRJLANR5L15BTA0529 | |
| 15060000160664 | L15/dossiers | 15 | 15060000160623 | 15060000160662 | 2 | 2 | TAP | PRJLANR5L15TAP0529 | |
| 15060000160678 | L15/dossiers | 15 | 15060000160623 | 15060000160677 | 1 | 2 | BTA | PRJLSNR5S359BTA0039 | |
| 15060000160682 | L15/dossiers | 15 | 15060000160623 | 15060000160681 | 1 | 2 | BTA | PRJLANR5L15BTA0537 | |
| 15060000160683 | L15/dossiers | 15 | 15060000160623 | 15060000160681 | 2 | 2 | TAP | PRJLANR5L15TAP0537 | |
| 15060000160859 | L15/dossiers | 15 | 15060000160845 | 15060000160858 | 1 | 2 | BTA | PIONSNR5S359BTA0004 | |
| 15060000160874 | L15/dossiers | 15 | 15060000160845 | 15060000160873 | 1 | 2 | BTA | PIONANR5L15BTA0519 | |
| 15060000160997 | L15/dossiers | 15 | 15060000160984 | 15060000160996 | 1 | 2 | BTA | PRJLSNR5S339BTA0074 | |
| 15060000161025 | L15/dossiers | 15 | 15060000160984 | 15060000161024 | 1 | 2 | BTA | PRJLANR5L15BTA0484 | |
| 15060000161026 | L15/dossiers | 15 | 15060000160984 | 15060000161024 | 2 | 2 | TAP | PRJLANR5L15TAP0484 | |
| 15060000161040 | L15/dossiers | 15 | 15060000160984 | 15060000161039 | 1 | 2 | BTA | PRJLSNR5S359BTA0010 | |
| 15060000161044 | L15/dossiers | 15 | 15060000160984 | 15060000161043 | 1 | 2 | BTA | PRJLANR5L15BTA0491 | |
| 15060000161045 | L15/dossiers | 15 | 15060000160984 | 15060000161043 | 2 | 2 | TAP | PRJLANR5L15TAP0491 | |
| 15060000161240 | L15/dossiers | 15 | 15060000161207 | 15060000161239 | 1 | 2 | BTA | PIONSNR5S339BTA0089 | |
| 15060000161260 | L15/dossiers | 15 | 15060000161246 | 15060000161259 | 1 | 2 | BTA | PIONSNR5S339BTA0114 | |
| 15060000161311 | L15/dossiers | 15 | 15060000161298 | 15060000161310 | 1 | 2 | BTA | PRJLSNR5S339BTA0072 | |
| 15060000161325 | L15/dossiers | 15 | 15060000161298 | 15060000161324 | 1 | 2 | BTA | PRJLANR5L15BTA0480 | |
| 15060000161342 | L15/dossiers | 15 | 15060000161328 | 15060000161341 | 1 | 2 | BTA | PRJLSNR5S339BTA0120 | |
| 15060000161368 | L15/dossiers | 15 | 15060000161328 | 15060000161367 | 1 | 2 | BTA | PRJLANR5L15BTA0487 | |
| 15060000161369 | L15/dossiers | 15 | 15060000161328 | 15060000161367 | 2 | 2 | TAP | PRJLANR5L15TAP0487 | |
| 15060000161405 | L15/dossiers | 15 | 15060000161328 | 15060000161404 | 1 | 2 | BTA | PRJLANR5L15BTA0495 | |
| 15060000161406 | L15/dossiers | 15 | 15060000161328 | 15060000161404 | 2 | 2 | TAP | PRJLANR5L15TAP0495 | |
| 15060000161416 | L15/dossiers | 15 | 15060000161328 | 15060000161415 | 1 | 2 | BTA | PRJLSNR5S359BTA0023 | |
| 15060000161425 | L15/dossiers | 15 | 15060000161328 | 15060000161424 | 1 | 2 | BTA | PRJLANR5L15BTA0502 | |
| 15060000161426 | L15/dossiers | 15 | 15060000161328 | 15060000161424 | 2 | 2 | TAP | PRJLANR5L15TAP0502 | |
| 15060000161503 | L15/dossiers | 15 | 15060000161484 | 15060000161502 | 1 | 2 | BTA | PRJLANR5L15BTA0527 |