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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000140342 | L15/dossiers | 15 | 15060000140329 | 15060000140341 | 1 | 2 | BTA | PIONSNR5S299BTA0115 | |
| 15060000140366 | L15/dossiers | 15 | 15060000140348 | 15060000140365 | 1 | 2 | BTA | PIONSNR5S299BTA0118 | |
| 15060000140407 | L15/dossiers | 15 | 15060000140388 | 15060000140406 | 1 | 2 | BTA | PIONSNR5S299BTA0122 | |
| 15060000140426 | L15/dossiers | 15 | 15060000140413 | 15060000140425 | 1 | 2 | BTA | PIONSNR5S299BTA0121 | |
| 15060000140440 | L15/dossiers | 15 | 15060000140413 | 15060000140439 | 1 | 2 | BTA | PIONANR5L15BTA0164 | |
| 15060000140441 | L15/dossiers | 15 | 15060000140413 | 15060000140439 | 2 | 2 | TAP | PIONANR5L15TAP0164 | |
| 15060000140454 | L15/dossiers | 15 | 15060000140447 | 15060000140453 | 1 | 2 | BTA | PNREANR5L15BTA0127 | |
| 15060000140479 | L15/dossiers | 15 | 15060000140455 | 15060000140478 | 1 | 2 | BTA | PIONSNR5S299BTA0125 | |
| 15060000140495 | L15/dossiers | 15 | 15060000140488 | 15060000140494 | 1 | 2 | BTA | PNREANR5L15BTA0130 | |
| 15060000140512 | L15/dossiers | 15 | 15060000140499 | 15060000140511 | 1 | 2 | BTA | PIONSNR5S299BTA0124 | |
| 15060000140553 | L15/dossiers | 15 | 15060000140546 | 15060000140552 | 1 | 2 | BTA | RIONANR5L15BTA0136 | |
| 15060000140561 | L15/dossiers | 15 | 15060000140554 | 15060000140560 | 1 | 2 | BTA | RIONANR5L15BTA0134 | |
| 15060000140562 | L15/dossiers | 15 | 15060000140554 | 15060000140560 | 2 | 2 | TAP | RIONANR5L15TAP0134 | |
| 15060000140570 | L15/dossiers | 15 | 15060000140563 | 15060000140569 | 1 | 2 | BTA | RIONANR5L15BTA0135 | |
| 15060000140578 | L15/dossiers | 15 | 15060000140571 | 15060000140577 | 1 | 2 | BTA | PNREANR5L15BTA0129 | |
| 15060000140586 | L15/dossiers | 15 | 15060000140579 | 15060000140585 | 1 | 2 | BTA | RIONANR5L15BTA0126 | |
| 15060000140602 | L15/dossiers | 15 | 15060000140595 | 15060000140601 | 1 | 2 | BTA | RIONANR5L15BTA0132 | |
| 15060000140610 | L15/dossiers | 15 | 15060000140603 | 15060000140609 | 1 | 2 | BTA | RIONANR5L15BTA0133 | |
| 15060000140629 | L15/dossiers | 15 | 15060000140622 | 15060000140628 | 1 | 2 | BTA | PNREANR5L15BTA0131 | |
| 15060000140676 | L15/dossiers | 15 | 15060000140658 | 15060000140675 | 1 | 2 | BTA | PIONANR5L15BTA0262 | |
| 15060000140677 | L15/dossiers | 15 | 15060000140658 | 15060000140675 | 2 | 2 | TAP | PIONANR5L15TAP0262 | |
| 15060000140790 | L15/dossiers | 15 | 15060000140732 | 15060000140789 | 1 | 2 | BTA | PRJLANR5L15BTA0179 | |
| 15060000140791 | L15/dossiers | 15 | 15060000140732 | 15060000140789 | 2 | 2 | TAP | PRJLANR5L15TAP0179 | |
| 15060000140811 | L15/dossiers | 15 | 15060000140732 | 15060000140810 | 1 | 2 | BTA | PRJLSNR5S319BTA0060 | |
| 15060000140851 | L15/dossiers | 15 | 15060000140732 | 15060000140850 | 1 | 2 | BTA | PRJLANR5L15BTA0244 | |
| 15060000140852 | L15/dossiers | 15 | 15060000140732 | 15060000140850 | 2 | 2 | TAP | PRJLANR5L15TAP0244 | |
| 15060000140862 | L15/dossiers | 15 | 15060000140732 | 15060000140861 | 1 | 2 | BTA | PRJLSNR5S319BTA0089 | |
| 15060000140871 | L15/dossiers | 15 | 15060000140732 | 15060000140870 | 1 | 2 | BTA | PRJLANR5L15BTA0258 | |
| 15060000140872 | L15/dossiers | 15 | 15060000140732 | 15060000140870 | 2 | 2 | TAP | PRJLANR5L15TAP0258 | |
| 15060000141163 | L15/dossiers | 15 | 15060000140896 | 15060000141162 | 1 | 2 | BTA | PRJLANR5L15BTA0189 | |
| 15060000141164 | L15/dossiers | 15 | 15060000140896 | 15060000141162 | 2 | 2 | TAP | PRJLANR5L15TAP0189 | |
| 15060000141191 | L15/dossiers | 15 | 15060000140896 | 15060000141190 | 1 | 2 | BTA | PRJLSNR5S319BTA0033 | |
| 15060000141214 | L15/dossiers | 15 | 15060000140896 | 15060000141213 | 1 | 2 | BTA | PRJLANR5L15BTA0211 | |
| 15060000141215 | L15/dossiers | 15 | 15060000140896 | 15060000141213 | 2 | 2 | TAP | PRJLANR5L15TAP0211 | |
| 15060000141225 | L15/dossiers | 15 | 15060000140896 | 15060000141224 | 1 | 2 | BTA | PRJLSNR5S319BTA0043 | |
| 15060000141235 | L15/dossiers | 15 | 15060000140896 | 15060000141234 | 1 | 2 | BTA | PRJLANR5L15BTA0213 | |
| 15060000141236 | L15/dossiers | 15 | 15060000140896 | 15060000141234 | 2 | 2 | TAP | PRJLANR5L15TAP0213 | |
| 15060000141670 | L15/dossiers | 15 | 15060000141654 | 15060000141669 | 1 | 2 | BTA | PIONANR5L15BTA0393 | |
| 15060000141671 | L15/dossiers | 15 | 15060000141654 | 15060000141669 | 2 | 2 | TAP | PIONANR5L15TAP0393 | |
| 15060000141682 | L15/dossiers | 15 | 15060000141654 | 15060000141681 | 1 | 2 | BTA | PIONSNR5S339BTA0068 | |
| 15060000141693 | L15/dossiers | 15 | 15060000141654 | 15060000141692 | 1 | 2 | BTA | PIONANR5L15BTA0422 | |
| 15060000141694 | L15/dossiers | 15 | 15060000141654 | 15060000141692 | 2 | 2 | TAP | PIONANR5L15TAP0422 | |
| 15060000141722 | L15/dossiers | 15 | 15060000141708 | 15060000141721 | 1 | 2 | BTA | PRJLSNR5S319BTA0019 | |
| 15060000141736 | L15/dossiers | 15 | 15060000141708 | 15060000141735 | 1 | 2 | BTA | PRJLANR5L15BTA0277 | |
| 15060000141880 | L15/dossiers | 15 | 15060000141865 | 15060000141879 | 1 | 2 | BTA | PIONANR5L15BTA0455 | |
| 15060000141881 | L15/dossiers | 15 | 15060000141865 | 15060000141879 | 2 | 2 | TAP | PIONANR5L15TAP0455 | |
| 15060000141938 | L15/dossiers | 15 | 15060000141921 | 15060000141937 | 1 | 2 | BTA | PRJLANR5L15BTA0309 | |
| 15060000141950 | L15/dossiers | 15 | 15060000141921 | 15060000141949 | 1 | 2 | BTA | PRJLSNR5S339BTA0005 | |
| 15060000142096 | L15/dossiers | 15 | 15060000142077 | 15060000142095 | 1 | 2 | BTA | PRJLANR5L15BTA0337 | |
| 15060000142107 | L15/dossiers | 15 | 15060000142077 | 15060000142106 | 1 | 2 | BTA | PRJLSNR5S339BTA0050 |