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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000131766 | L14/dossiers | 14 | 14060000131752 | 14060000131765 | 1 | 2 | BTA | PRJLSNR5S239BTA0145 | |
| 14060000131779 | L14/dossiers | 14 | 14060000131752 | 14060000131778 | 1 | 2 | BTA | PRJLANR5L14BTA0625 | |
| 14060000131850 | L14/dossiers | 14 | 14060000131833 | 14060000131849 | 1 | 2 | BTA | PIONANR5L14BTA0590 | |
| 14060000131867 | L14/dossiers | 14 | 14060000131833 | 14060000131866 | 1 | 2 | BTA | PIONSNR5S259BTA0026 | |
| 14060000131881 | L14/dossiers | 14 | 14060000131833 | 14060000131880 | 1 | 2 | BTA | PIONSNR5S259BTA0033 | |
| 14060000131885 | L14/dossiers | 14 | 14060000131833 | 14060000131884 | 1 | 2 | BTA | PIONANR5L14BTA0601 | |
| 14060000131915 | L14/dossiers | 14 | 14060000131892 | 14060000131914 | 1 | 2 | BTA | PRJLANR5L14BTA0196 | |
| 14060000131927 | L14/dossiers | 14 | 14060000131892 | 14060000131926 | 1 | 2 | BTA | PRJLSNR5S219BTA0001 | |
| 14060000131941 | L14/dossiers | 14 | 14060000131892 | 14060000131940 | 1 | 2 | BTA | PRJLSNR5S219BTA0017 | |
| 14060000131945 | L14/dossiers | 14 | 14060000131892 | 14060000131944 | 1 | 2 | BTA | PRJLANR5L14BTA0231 | |
| 14060000131982 | L14/dossiers | 14 | 14060000131966 | 14060000131981 | 1 | 2 | BTA | PIONANR5L14BTA0905 | |
| 14060000132050 | L14/dossiers | 14 | 14060000132033 | 14060000132049 | 1 | 2 | BTA | PIONANR5L14BTA0904 | |
| 14060000132139 | L14/dossiers | 14 | 14060000132099 | 14060000132138 | 1 | 2 | BTA | PRJLANR5L14BTA0623 | |
| 14060000132157 | L14/dossiers | 14 | 14060000132099 | 14060000132156 | 1 | 2 | BTA | PRJLSNR5S259BTA0052 | |
| 14060000132179 | L14/dossiers | 14 | 14060000132099 | 14060000132178 | 1 | 2 | BTA | PRJLANR5L14BTA0644 | |
| 14060000132189 | L14/dossiers | 14 | 14060000132099 | 14060000132188 | 1 | 2 | BTA | PRJLSNR5S259BTA0056 | |
| 14060000132200 | L14/dossiers | 14 | 14060000132099 | 14060000132199 | 1 | 2 | BTA | PRJLANR5L14BTA0649 | |
| 14060000132240 | L14/dossiers | 14 | 14060000132210 | 14060000132239 | 1 | 2 | BTA | PRJLANR5L14BTA0052 | |
| 14060000132263 | L14/dossiers | 14 | 14060000132210 | 14060000132262 | 1 | 2 | BTA | PRJLSNR5S199BTA0046 | |
| 14060000132277 | L14/dossiers | 14 | 14060000132210 | 14060000132276 | 1 | 2 | BTA | PRJLANR5L14BTA0070 | |
| 14060000132281 | L14/dossiers | 14 | 14060000132210 | 14060000132280 | 1 | 2 | BTA | PRJLSNR5S199BTA0064 | |
| 14060000132353 | L14/dossiers | 14 | 14060000132333 | 14060000132352 | 1 | 2 | BTA | PRJLSNR5S219BTA0102 | |
| 14060000132375 | L14/dossiers | 14 | 14060000132333 | 14060000132374 | 1 | 2 | BTA | PRJLANR5L14BTA0350 | |
| 14060000132389 | L14/dossiers | 14 | 14060000132333 | 14060000132388 | 1 | 2 | BTA | PRJLSNR5S219BTA0145 | |
| 14060000132393 | L14/dossiers | 14 | 14060000132333 | 14060000132392 | 1 | 2 | BTA | PRJLANR5L14BTA0366 | |
| 14060000132473 | L14/dossiers | 14 | 14060000132454 | 14060000132472 | 1 | 2 | BTA | PRJLANR5L14BTA0835 | |
| 14060000132485 | L14/dossiers | 14 | 14060000132454 | 14060000132484 | 1 | 2 | BTA | PRJLSNR5S279BTA0049 | |
| 14060000132504 | L14/dossiers | 14 | 14060000132488 | 14060000132503 | 1 | 2 | BTA | PRJLANR5L14BTA0110 | |
| 14060000132516 | L14/dossiers | 14 | 14060000132488 | 14060000132515 | 1 | 2 | BTA | PRJLSNR5S199BTA0176 | |
| 14060000132539 | L14/dossiers | 14 | 14060000132526 | 14060000132538 | 1 | 2 | BTA | RIONANR5L14BTA0102 | |
| 14060000132566 | L14/dossiers | 14 | 14060000132552 | 14060000132565 | 1 | 2 | BTA | RIONANR5L14BTA0401 | |
| 14060000132601 | L14/dossiers | 14 | 14060000132587 | 14060000132600 | 1 | 2 | BTA | PRJLSNR5S279BTA0019 | |
| 14060000132615 | L14/dossiers | 14 | 14060000132587 | 14060000132614 | 1 | 2 | BTA | PRJLANR5L14BTA0872 | |
| 14060000132628 | L14/dossiers | 14 | 14060000132621 | 14060000132627 | 1 | 2 | BTA | RIONANR5L14BTA0433 | |
| 14060000132642 | L14/dossiers | 14 | 14060000132629 | 14060000132641 | 1 | 2 | BTA | PIONSNR5S219BTA0135 | |
| 14060000132714 | L14/dossiers | 14 | 14060000132698 | 14060000132713 | 1 | 2 | BTA | PIONANR5L14BTA0846 | |
| 14060000132738 | L14/dossiers | 14 | 14060000132720 | 14060000132737 | 1 | 2 | BTA | PRJLANR5L14BTA0464 | |
| 14060000132750 | L14/dossiers | 14 | 14060000132720 | 14060000132749 | 1 | 2 | BTA | PRJLSNR5S239BTA0069 | |
| 14060000132773 | L14/dossiers | 14 | 14060000132760 | 14060000132772 | 1 | 2 | BTA | PIONSNR5S259BTA0079 | |
| 14060000132866 | L14/dossiers | 14 | 14060000132850 | 14060000132865 | 1 | 2 | BTA | PIONANR5L14BTA0595 | |
| 14060000132900 | L14/dossiers | 14 | 14060000132886 | 14060000132899 | 1 | 2 | BTA | PRJLSNR5S259BTA0108 | |
| 14060000132914 | L14/dossiers | 14 | 14060000132886 | 14060000132913 | 1 | 2 | BTA | PRJLANR5L14BTA0774 | |
| 14060000132933 | L14/dossiers | 14 | 14060000132917 | 14060000132932 | 1 | 2 | BTA | PIONANR5L14BTA0767 | |
| 14060000132950 | L14/dossiers | 14 | 14060000132937 | 14060000132949 | 1 | 2 | BTA | PIONSNR5S259BTA0034 | |
| 14060000132964 | L14/dossiers | 14 | 14060000132937 | 14060000132963 | 1 | 2 | BTA | PIONANR5L14BTA0627 | |
| 14060000133025 | L14/dossiers | 14 | 14060000133007 | 14060000133024 | 1 | 2 | BTA | PIONANR5L14BTA0310 | |
| 14060000133039 | L14/dossiers | 14 | 14060000133007 | 14060000133038 | 1 | 2 | BTA | PIONSNR5S219BTA0113 | |
| 14060000133053 | L14/dossiers | 14 | 14060000133007 | 14060000133052 | 1 | 2 | BTA | PIONSNR5S219BTA0132 | |
| 14060000133057 | L14/dossiers | 14 | 14060000133007 | 14060000133056 | 1 | 2 | BTA | PIONANR5L14BTA0368 | |
| 14060000133081 | L14/dossiers | 14 | 14060000133061 | 14060000133080 | 1 | 2 | BTA | PRJLANR5L14BTA0822 |