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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000163461 | L15/dossiers | 15 | 15060000163428 | 15060000163459 | 2 | 2 | TAP | PRJLANR5L15TAP0417 | |
| 15060000163475 | L15/dossiers | 15 | 15060000163428 | 15060000163474 | 1 | 2 | BTA | PRJLSNR5S339BTA0086 | |
| 15060000163479 | L15/dossiers | 15 | 15060000163428 | 15060000163478 | 1 | 2 | BTA | PRJLANR5L15BTA0418 | |
| 15060000163480 | L15/dossiers | 15 | 15060000163428 | 15060000163478 | 2 | 2 | TAP | PRJLANR5L15TAP0418 | |
| 15060000163650 | L15/dossiers | 15 | 15060000163635 | 15060000163649 | 1 | 2 | BTA | RIONANR5L15BTA0475 | |
| 15060000163683 | L15/dossiers | 15 | 15060000163662 | 15060000163682 | 1 | 2 | BTA | PRJLANR5L15BTA0420 | |
| 15060000163684 | L15/dossiers | 15 | 15060000163662 | 15060000163682 | 2 | 2 | TAP | PRJLANR5L15TAP0420 | |
| 15060000163695 | L15/dossiers | 15 | 15060000163662 | 15060000163694 | 1 | 2 | BTA | PRJLSNR5S339BTA0091 | |
| 15060000163709 | L15/dossiers | 15 | 15060000163662 | 15060000163708 | 1 | 2 | BTA | PRJLANR5L15BTA0426 | |
| 15060000163710 | L15/dossiers | 15 | 15060000163662 | 15060000163708 | 2 | 2 | TAP | PRJLANR5L15TAP0426 | |
| 15060000163713 | L15/dossiers | 15 | 15060000163662 | 15060000163712 | 1 | 2 | BTA | PRJLSNR5S339BTA0098 | |
| 15060000163768 | L15/dossiers | 15 | 15060000163750 | 15060000163767 | 1 | 2 | BTA | PIONANR5L15BTA0452 | |
| 15060000163769 | L15/dossiers | 15 | 15060000163750 | 15060000163767 | 2 | 2 | TAP | PIONANR5L15TAP0452 | |
| 15060000163780 | L15/dossiers | 15 | 15060000163750 | 15060000163779 | 1 | 2 | BTA | PIONSNR5S359BTA0076 | |
| 15060000163793 | L15/dossiers | 15 | 15060000163750 | 15060000163792 | 1 | 2 | BTA | PIONANR5L15BTA0668 | |
| 15060000163794 | L15/dossiers | 15 | 15060000163750 | 15060000163792 | 2 | 2 | TAP | PIONANR5L15TAP0668 | |
| 15060000163803 | L15/dossiers | 15 | 15060000163750 | 15060000163802 | 1 | 2 | BTA | PIONSNR5S379BTA0010 | |
| 15060000163817 | L15/dossiers | 15 | 15060000163750 | 15060000163816 | 1 | 2 | BTA | PIONSNR5S379BTA0044 | |
| 15060000163822 | L15/dossiers | 15 | 15060000163750 | 15060000163821 | 1 | 2 | BTA | PIONANR5L15BTA0732 | |
| 15060000163823 | L15/dossiers | 15 | 15060000163750 | 15060000163821 | 2 | 2 | TAP | PIONANR5L15TAP0732 | |
| 15060000163882 | L15/dossiers | 15 | 15060000163875 | 15060000163881 | 1 | 2 | BTA | PNREANR5L15BTA0427 | |
| 15060000163891 | L15/dossiers | 15 | 15060000163883 | 15060000163890 | 1 | 2 | BTA | PNREANR5L15BTA0429 | |
| 15060000164110 | L15/dossiers | 15 | 15060000164095 | 15060000164109 | 1 | 2 | BTA | PIONANR5L15BTA0434 | |
| 15060000164142 | L15/dossiers | 15 | 15060000164135 | 15060000164141 | 1 | 2 | BTA | RIONANR5L15BTA0421 | |
| 15060000164173 | L15/dossiers | 15 | 15060000164157 | 15060000164172 | 1 | 2 | BTA | PIONANR5L15BTA0425 | |
| 15060000164174 | L15/dossiers | 15 | 15060000164157 | 15060000164172 | 2 | 2 | TAP | PIONANR5L15TAP0425 | |
| 15060000164185 | L15/dossiers | 15 | 15060000164157 | 15060000164184 | 1 | 2 | BTA | PIONSNR5S339BTA0100 | |
| 15060000164198 | L15/dossiers | 15 | 15060000164157 | 15060000164197 | 1 | 2 | BTA | PIONANR5L15BTA0463 | |
| 15060000164199 | L15/dossiers | 15 | 15060000164157 | 15060000164197 | 2 | 2 | TAP | PIONANR5L15TAP0463 | |
| 15060000164203 | L15/dossiers | 15 | 15060000164157 | 15060000164202 | 1 | 2 | BTA | PIONSNR5S339BTA0130 | |
| 15060000164292 | L15/dossiers | 15 | 15060000164277 | 15060000164291 | 1 | 2 | BTA | PIONANR5L15BTA0437 | |
| 15060000164336 | L15/dossiers | 15 | 15060000164321 | 15060000164335 | 1 | 2 | BTA | PIONANR5L15BTA0433 | |
| 15060000164344 | L15/dossiers | 15 | 15060000164337 | 15060000164343 | 1 | 2 | BTA | PNREANR5L15BTA0448 | |
| 15060000164366 | L15/dossiers | 15 | 15060000164352 | 15060000164365 | 1 | 2 | BTA | PIONANR5L15BTA0436 | |
| 15060000164381 | L15/dossiers | 15 | 15060000164367 | 15060000164380 | 1 | 2 | BTA | PIONANR5L15BTA0435 | |
| 15060000164447 | L15/dossiers | 15 | 15060000164433 | 15060000164446 | 1 | 2 | BTA | PIONANR5L15BTA0446 | |
| 15060000164464 | L15/dossiers | 15 | 15060000164448 | 15060000164463 | 1 | 2 | BTA | PIONANR5L15BTA0444 | |
| 15060000164481 | L15/dossiers | 15 | 15060000164465 | 15060000164480 | 1 | 2 | BTA | PIONANR5L15BTA0447 | |
| 15060000164496 | L15/dossiers | 15 | 15060000164482 | 15060000164495 | 1 | 2 | BTA | PIONANR5L15BTA0438 | |
| 15060000164533 | L15/dossiers | 15 | 15060000164511 | 15060000164532 | 1 | 2 | BTA | PRJLANR5L15BTA0530 | |
| 15060000164545 | L15/dossiers | 15 | 15060000164511 | 15060000164544 | 1 | 2 | BTA | PRJLSNR5S359BTA0052 | |
| 15060000164663 | L15/dossiers | 15 | 15060000164645 | 15060000164662 | 1 | 2 | BTA | PRJLANR5L15BTA0669 | |
| 15060000164674 | L15/dossiers | 15 | 15060000164645 | 15060000164673 | 1 | 2 | BTA | PRJLSNR5S379BTA0056 | |
| 15060000164707 | L15/dossiers | 15 | 15060000164685 | 15060000164706 | 1 | 2 | BTA | PRJLANR5L15BTA0439 | |
| 15060000164708 | L15/dossiers | 15 | 15060000164685 | 15060000164706 | 2 | 2 | TAP | PRJLANR5L15TAP0439 | |
| 15060000164720 | L15/dossiers | 15 | 15060000164685 | 15060000164719 | 1 | 2 | BTA | PRJLSNR5S339BTA0115 | |
| 15060000164740 | L15/dossiers | 15 | 15060000164685 | 15060000164739 | 1 | 2 | BTA | PRJLANR5L15BTA0464 | |
| 15060000164741 | L15/dossiers | 15 | 15060000164685 | 15060000164739 | 2 | 2 | TAP | PRJLANR5L15TAP0464 | |
| 15060000164752 | L15/dossiers | 15 | 15060000164685 | 15060000164751 | 1 | 2 | BTA | PRJLSNR5S339BTA0131 | |
| 15060000164761 | L15/dossiers | 15 | 15060000164685 | 15060000164760 | 1 | 2 | BTA | PRJLANR5L15BTA0468 |