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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000095389 | L14/dossiers | 14 | 14060000095372 | 14060000095388 | 1 | 2 | BTA | RIONANR5L14BTA0736 | |
| 14060000095408 | L14/dossiers | 14 | 14060000095390 | 14060000095407 | 1 | 2 | BTA | PRJLANR5L14BTA0034 | |
| 14060000095420 | L14/dossiers | 14 | 14060000095390 | 14060000095419 | 1 | 2 | BTA | PRJLSNR5S199BTA0057 | |
| 14060000095596 | L14/dossiers | 14 | 14060000095579 | 14060000095595 | 1 | 2 | BTA | PIONANR5L14BTA0826 | |
| 14060000095728 | L14/dossiers | 14 | 14060000095706 | 14060000095727 | 1 | 2 | BTA | PIONANR5L14BTA0756 | |
| 14060000095744 | L14/dossiers | 14 | 14060000095706 | 14060000095743 | 1 | 2 | BTA | PIONSNR5S259BTA0175 | |
| 14060000095767 | L14/dossiers | 14 | 14060000095706 | 14060000095766 | 1 | 2 | BTA | PIONANR5L14BTA0819 | |
| 14060000095777 | L14/dossiers | 14 | 14060000095706 | 14060000095776 | 1 | 2 | BTA | PIONSNR5S279BTA0015 | |
| 14060000095788 | L14/dossiers | 14 | 14060000095706 | 14060000095787 | 1 | 2 | BTA | PIONANR5L14BTA0831 | |
| 14060000095835 | L14/dossiers | 14 | 14060000095820 | 14060000095834 | 1 | 2 | BTA | PIONANR5L14BTA0098 | |
| 14060000095847 | L14/dossiers | 14 | 14060000095820 | 14060000095846 | 1 | 2 | BTA | PIONSNR5S199BTA0148 | |
| 14060000095905 | L14/dossiers | 14 | 14060000095889 | 14060000095904 | 1 | 2 | BTA | PIONANR5L14BTA0719 | |
| 14060000095922 | L14/dossiers | 14 | 14060000095889 | 14060000095921 | 1 | 2 | BTA | PIONSNR5S259BTA0133 | |
| 14060000095936 | L14/dossiers | 14 | 14060000095889 | 14060000095935 | 1 | 2 | BTA | PIONANR5L14BTA0746 | |
| 14060000095940 | L14/dossiers | 14 | 14060000095889 | 14060000095939 | 1 | 2 | BTA | PIONSNR5S259BTA0155 | |
| 14060000096336 | L14/dossiers | 14 | 14060000096000 | 14060000096335 | 1 | 2 | BTA | PRJLANR5L14BTA0833 | |
| 14060000096350 | L14/dossiers | 14 | 14060000096000 | 14060000096349 | 1 | 2 | BTA | PRJLSNR5S279BTA0028 | |
| 14060000096375 | L14/dossiers | 14 | 14060000096000 | 14060000096374 | 1 | 2 | BTA | PRJLANR5L14BTA0860 | |
| 14060000096385 | L14/dossiers | 14 | 14060000096000 | 14060000096384 | 1 | 2 | BTA | PRJLSNR5S279BTA0041 | |
| 14060000096397 | L14/dossiers | 14 | 14060000096000 | 14060000096396 | 1 | 2 | BTA | PRJLANR5L14BTA0865 | |
| 14060000096762 | L14/dossiers | 14 | 14060000096753 | 14060000096761 | 1 | 2 | BTA | RIONANR5L14BTA0850 | |
| 14060000096788 | L14/dossiers | 14 | 14060000096773 | 14060000096787 | 1 | 2 | BTA | PRJLSNR5S259BTA0074 | |
| 14060000096802 | L14/dossiers | 14 | 14060000096773 | 14060000096801 | 1 | 2 | BTA | PRJLANR5L14BTA0701 | |
| 14060000096832 | L14/dossiers | 14 | 14060000096815 | 14060000096831 | 1 | 2 | BTA | PIONANR5L14BTA0613 | |
| 14060000096869 | L14/dossiers | 14 | 14060000096854 | 14060000096868 | 1 | 2 | BTA | RIONANR5L14BTA0345 | |
| 14060000096913 | L14/dossiers | 14 | 14060000096898 | 14060000096912 | 1 | 2 | BTA | PRJLANR5L14BTA0364 | |
| 14060000096925 | L14/dossiers | 14 | 14060000096898 | 14060000096924 | 1 | 2 | BTA | PRJLSNR5S239BTA0009 | |
| 14060000096995 | L14/dossiers | 14 | 14060000096976 | 14060000096994 | 1 | 2 | BTA | PRJLANR5L14BTA0836 | |
| 14060000097007 | L14/dossiers | 14 | 14060000096976 | 14060000097006 | 1 | 2 | BTA | PRJLSNR5S279BTA0050 | |
| 14060000097024 | L14/dossiers | 14 | 14060000097010 | 14060000097023 | 1 | 2 | BTA | PRJLSNR5S259BTA0138 | |
| 14060000097037 | L14/dossiers | 14 | 14060000097010 | 14060000097036 | 1 | 2 | BTA | PRJLANR5L14BTA0783 | |
| 14060000097064 | L14/dossiers | 14 | 14060000097048 | 14060000097063 | 1 | 2 | BTA | PIONANR5L14BTA0326 | |
| 14060000097099 | L14/dossiers | 14 | 14060000097086 | 14060000097098 | 1 | 2 | BTA | PRJLSNR5S279BTA0092 | |
| 14060000097118 | L14/dossiers | 14 | 14060000097086 | 14060000097117 | 1 | 2 | BTA | PRJLANR5L15BTA0013 | |
| 14060000097181 | L14/dossiers | 14 | 14060000097157 | 14060000097180 | 1 | 2 | BTA | PRJLANR5L14BTA0140 | |
| 14060000097198 | L14/dossiers | 14 | 14060000097157 | 14060000097197 | 1 | 2 | BTA | PRJLSNR5S199BTA0153 | |
| 14060000097212 | L14/dossiers | 14 | 14060000097157 | 14060000097211 | 1 | 2 | BTA | PRJLSNR5S199BTA0180 | |
| 14060000097216 | L14/dossiers | 14 | 14060000097157 | 14060000097215 | 1 | 2 | BTA | PRJLANR5L14BTA0174 | |
| 14060000097251 | L14/dossiers | 14 | 14060000097235 | 14060000097250 | 1 | 2 | BTA | PRJLANR5L14BTA0554 | |
| 14060000097263 | L14/dossiers | 14 | 14060000097235 | 14060000097262 | 1 | 2 | BTA | PRJLSNR5S259BTA0028 | |
| 14060000097316 | L14/dossiers | 14 | 14060000097301 | 14060000097315 | 1 | 2 | BTA | PIONANR5L14BTA0676 | |
| 14060000097333 | L14/dossiers | 14 | 14060000097301 | 14060000097332 | 1 | 2 | BTA | PIONSNR5S259BTA0119 | |
| 14060000097345 | L14/dossiers | 14 | 14060000097301 | 14060000097344 | 1 | 2 | BTA | PIONANR5L14BTA0723 | |
| 14060000097422 | L14/dossiers | 14 | 14060000097405 | 14060000097421 | 1 | 2 | BTA | PIONANR5L14BTA0619 | |
| 14060000097530 | L14/dossiers | 14 | 14060000097487 | 14060000097529 | 1 | 2 | BTA | PRJLANR5L14BTA0207 | |
| 14060000097562 | L14/dossiers | 14 | 14060000097487 | 14060000097561 | 1 | 2 | BTA | PRJLSNR5S219BTA0025 | |
| 14060000097582 | L14/dossiers | 14 | 14060000097487 | 14060000097581 | 1 | 2 | BTA | PRJLANR5L14BTA0274 | |
| 14060000097594 | L14/dossiers | 14 | 14060000097487 | 14060000097593 | 1 | 2 | BTA | PRJLSNR5S219BTA0072 | |
| 14060000097611 | L14/dossiers | 14 | 14060000097487 | 14060000097610 | 1 | 2 | BTA | PRJLANR5L14BTA0302 | |
| 14060000097615 | L14/dossiers | 14 | 14060000097487 | 14060000097614 | 1 | 2 | BTA | PRJLSNR5S219BTA0084 |