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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000146792 | L15/dossiers | 15 | 15060000146740 | 15060000146791 | 1 | 2 | BTA | PIONSNR5S319BTA0127 | |
| 15060000146837 | L15/dossiers | 15 | 15060000146824 | 15060000146836 | 1 | 2 | BTA | PIONSNR5S319BTA0068 | |
| 15060000146863 | L15/dossiers | 15 | 15060000146850 | 15060000146862 | 1 | 2 | BTA | PIONSNR5S319BTA0071 | |
| 15060000146894 | L15/dossiers | 15 | 15060000146879 | 15060000146893 | 1 | 2 | BTA | PIONSNR5S319BTA0110 | |
| 15060000146954 | L15/dossiers | 15 | 15060000146941 | 15060000146953 | 1 | 2 | BTA | PIONSNR5S319BTA0074 | |
| 15060000146973 | L15/dossiers | 15 | 15060000146960 | 15060000146972 | 1 | 2 | BTA | PIONSNR5S319BTA0075 | |
| 15060000147031 | L15/dossiers | 15 | 15060000147018 | 15060000147030 | 1 | 2 | BTA | PIONSNR5S319BTA0079 | |
| 15060000147046 | L15/dossiers | 15 | 15060000147018 | 15060000147045 | 1 | 2 | BTA | PIONANR5L15BTA0355 | |
| 15060000147047 | L15/dossiers | 15 | 15060000147018 | 15060000147045 | 2 | 2 | TAP | PIONANR5L15TAP0355 | |
| 15060000147118 | L15/dossiers | 15 | 15060000147071 | 15060000147117 | 1 | 2 | BTA | PRJLANR5L15BTA0245 | |
| 15060000147119 | L15/dossiers | 15 | 15060000147071 | 15060000147117 | 2 | 2 | TAP | PRJLANR5L15TAP0245 | |
| 15060000147146 | L15/dossiers | 15 | 15060000147071 | 15060000147145 | 1 | 2 | BTA | PRJLSNR5S319BTA0109 | |
| 15060000147161 | L15/dossiers | 15 | 15060000147071 | 15060000147160 | 1 | 2 | BTA | PRJLANR5L15BTA0315 | |
| 15060000147162 | L15/dossiers | 15 | 15060000147071 | 15060000147160 | 2 | 2 | TAP | PRJLANR5L15TAP0315 | |
| 15060000147166 | L15/dossiers | 15 | 15060000147071 | 15060000147165 | 1 | 2 | BTA | PRJLSNR5S319BTA0134 | |
| 15060000147240 | L15/dossiers | 15 | 15060000147226 | 15060000147239 | 1 | 2 | BTA | PRJLSNR5S319BTA0082 | |
| 15060000147261 | L15/dossiers | 15 | 15060000147226 | 15060000147260 | 1 | 2 | BTA | PRJLANR5L15BTA0276 | |
| 15060000147370 | L15/dossiers | 15 | 15060000147347 | 15060000147369 | 1 | 2 | BTA | PIONANR5L15BTA0296 | |
| 15060000147394 | L15/dossiers | 15 | 15060000147371 | 15060000147393 | 1 | 2 | BTA | PIONANR5L15BTA0257 | |
| 15060000147395 | L15/dossiers | 15 | 15060000147371 | 15060000147393 | 2 | 2 | TAP | PIONANR5L15TAP0257 | |
| 15060000147409 | L15/dossiers | 15 | 15060000147371 | 15060000147408 | 1 | 2 | BTA | PIONSNR5S319BTA0120 | |
| 15060000147423 | L15/dossiers | 15 | 15060000147371 | 15060000147422 | 1 | 2 | BTA | PIONANR5L15BTA0322 | |
| 15060000147424 | L15/dossiers | 15 | 15060000147371 | 15060000147422 | 2 | 2 | TAP | PIONANR5L15TAP0322 | |
| 15060000147428 | L15/dossiers | 15 | 15060000147371 | 15060000147427 | 1 | 2 | BTA | PIONSNR5S319BTA0142 | |
| 15060000147496 | L15/dossiers | 15 | 15060000147482 | 15060000147495 | 1 | 2 | BTA | PRJLSNR5S319BTA0102 | |
| 15060000147510 | L15/dossiers | 15 | 15060000147482 | 15060000147509 | 1 | 2 | BTA | PRJLANR5L15BTA0364 | |
| 15060000147555 | L15/dossiers | 15 | 15060000147541 | 15060000147554 | 1 | 2 | BTA | PIONSNR5S319BTA0085 | |
| 15060000147602 | L15/dossiers | 15 | 15060000147589 | 15060000147601 | 1 | 2 | BTA | PIONSNR5S319BTA0094 | |
| 15060000147616 | L15/dossiers | 15 | 15060000147608 | 15060000147615 | 1 | 2 | BTA | RIONANR5L15BTA0241 | |
| 15060000147661 | L15/dossiers | 15 | 15060000147643 | 15060000147660 | 1 | 2 | BTA | PRJLSNR5S319BTA0088 | |
| 15060000147683 | L15/dossiers | 15 | 15060000147643 | 15060000147682 | 1 | 2 | BTA | PRJLANR5L15BTA0299 | |
| 15060000147684 | L15/dossiers | 15 | 15060000147643 | 15060000147682 | 2 | 2 | TAP | PRJLANR5L15TAP0299 | |
| 15060000147698 | L15/dossiers | 15 | 15060000147643 | 15060000147697 | 1 | 2 | BTA | PRJLSNR5S319BTA0139 | |
| 15060000147702 | L15/dossiers | 15 | 15060000147643 | 15060000147701 | 1 | 2 | BTA | PRJLANR5L15BTA0328 | |
| 15060000147703 | L15/dossiers | 15 | 15060000147643 | 15060000147701 | 2 | 2 | TAP | PRJLANR5L15TAP0328 | |
| 15060000147728 | L15/dossiers | 15 | 15060000147714 | 15060000147727 | 1 | 2 | BTA | RIONANR5L15BTA0246 | |
| 15060000147729 | L15/dossiers | 15 | 15060000147714 | 15060000147727 | 2 | 2 | TAP | RIONANR5L15TAP0246 | |
| 15060000147846 | L15/dossiers | 15 | 15060000147827 | 15060000147845 | 1 | 2 | BTA | PRJLANR5L15BTA0307 | |
| 15060000147858 | L15/dossiers | 15 | 15060000147827 | 15060000147857 | 1 | 2 | BTA | PRJLSNR5S339BTA0006 | |
| 15060000147899 | L15/dossiers | 15 | 15060000147864 | 15060000147898 | 1 | 2 | BTA | PRJLANR5L15BTA0256 | |
| 15060000147900 | L15/dossiers | 15 | 15060000147864 | 15060000147898 | 2 | 2 | TAP | PRJLANR5L15TAP0256 | |
| 15060000147912 | L15/dossiers | 15 | 15060000147864 | 15060000147911 | 1 | 2 | BTA | PRJLSNR5S319BTA0101 | |
| 15060000147926 | L15/dossiers | 15 | 15060000147864 | 15060000147925 | 1 | 2 | BTA | PRJLANR5L15BTA0304 | |
| 15060000147927 | L15/dossiers | 15 | 15060000147864 | 15060000147925 | 2 | 2 | TAP | PRJLANR5L15TAP0304 | |
| 15060000147931 | L15/dossiers | 15 | 15060000147864 | 15060000147930 | 1 | 2 | BTA | PRJLSNR5S319BTA0132 | |
| 15060000148001 | L15/dossiers | 15 | 15060000147988 | 15060000148000 | 1 | 2 | BTA | PIONSNR5S319BTA0086 | |
| 15060000148015 | L15/dossiers | 15 | 15060000147988 | 15060000148014 | 1 | 2 | BTA | PIONANR5L15BTA0268 | |
| 15060000148016 | L15/dossiers | 15 | 15060000147988 | 15060000148014 | 2 | 2 | TAP | PIONANR5L15TAP0268 | |
| 15060000148032 | L15/dossiers | 15 | 15060000148019 | 15060000148031 | 1 | 2 | BTA | PIONSNR5S319BTA0087 | |
| 15060000148117 | L15/dossiers | 15 | 15060000148086 | 15060000148116 | 1 | 2 | BTA | PIONANR5L15BTA0310 |