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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000186012 | L15/dossiers | 15 | 15060000186005 | 15060000186011 | 1 | 2 | BTA | RIONANR5L15BTA0814 | |
| 14060000089138 | L14/dossiers | 14 | 14060000089131 | 14060000089137 | 1 | 2 | BTA | RIONANR5L14BTA0300 | |
| 14060000089186 | L14/dossiers | 14 | 14060000089151 | 14060000089185 | 1 | 2 | BTA | PRJLANR5L14BTA0096 | |
| 14060000089211 | L14/dossiers | 14 | 14060000089151 | 14060000089210 | 1 | 2 | BTA | PRJLSNR5S199BTA0151 | |
| 14060000089228 | L14/dossiers | 14 | 14060000089151 | 14060000089227 | 1 | 2 | BTA | PRJLANR5L14BTA0147 | |
| 14060000089238 | L14/dossiers | 14 | 14060000089151 | 14060000089237 | 1 | 2 | BTA | PRJLSNR5S199BTA0178 | |
| 14060000089254 | L14/dossiers | 14 | 14060000089241 | 14060000089253 | 1 | 2 | BTA | PIONSNR5S259BTA0051 | |
| 14060000089270 | L14/dossiers | 14 | 14060000089241 | 14060000089269 | 1 | 2 | BTA | PIONANR5L14BTA0674 | |
| 14060000089280 | L14/dossiers | 14 | 14060000089241 | 14060000089279 | 1 | 2 | BTA | PIONSNR5S259BTA0114 | |
| 14060000089352 | L14/dossiers | 14 | 14060000089332 | 14060000089351 | 1 | 2 | BTA | PRJLANR5L14BTA0144 | |
| 14060000089365 | L14/dossiers | 14 | 14060000089332 | 14060000089364 | 1 | 2 | BTA | PRJLSNR5S199BTA0186 | |
| 14060000089380 | L14/dossiers | 14 | 14060000089332 | 14060000089379 | 1 | 2 | BTA | PRJLANR5L14BTA0720 | |
| 14060000089394 | L14/dossiers | 14 | 14060000089381 | 14060000089393 | 1 | 2 | BTA | PIONSNR5S259BTA0149 | |
| 14060000089423 | L14/dossiers | 14 | 14060000089405 | 14060000089422 | 1 | 2 | BTA | PRJLANR5L14BTA0585 | |
| 14060000089440 | L14/dossiers | 14 | 14060000089405 | 14060000089439 | 1 | 2 | BTA | PRJLSNR5S239BTA0146 | |
| 14060000089518 | L14/dossiers | 14 | 14060000089504 | 14060000089517 | 1 | 2 | BTA | PIONSNR5S219BTA0033 | |
| 14060000089534 | L14/dossiers | 14 | 14060000089504 | 14060000089533 | 1 | 2 | BTA | PIONANR5L14BTA0287 | |
| 14060000089544 | L14/dossiers | 14 | 14060000089504 | 14060000089543 | 1 | 2 | BTA | PIONSNR5S219BTA0090 | |
| 14060000089566 | L14/dossiers | 14 | 14060000089547 | 14060000089565 | 1 | 2 | BTA | PRJLANR5L14BTA0106 | |
| 14060000089578 | L14/dossiers | 14 | 14060000089547 | 14060000089577 | 1 | 2 | BTA | PRJLSNR5S199BTA0173 | |
| 14060000089691 | L14/dossiers | 14 | 14060000089673 | 14060000089690 | 1 | 2 | BTA | PRJLANR5L14BTA0871 | |
| 14060000089703 | L14/dossiers | 14 | 14060000089673 | 14060000089702 | 1 | 2 | BTA | PRJLSNR5S279BTA0118 | |
| 14060000089766 | L14/dossiers | 14 | 14060000089749 | 14060000089765 | 1 | 2 | BTA | PIONANR5L14BTA0254 | |
| 14060000089802 | L14/dossiers | 14 | 14060000089781 | 14060000089801 | 1 | 2 | BTA | PRJLANR5L14BTA0168 | |
| 14060000089814 | L14/dossiers | 14 | 14060000089781 | 14060000089813 | 1 | 2 | BTA | PRJLSNR5S219BTA0053 | |
| 14060000089904 | L14/dossiers | 14 | 14060000089884 | 14060000089903 | 1 | 2 | BTA | PRJLANR5L14BTA0859 | |
| 14060000089916 | L14/dossiers | 14 | 14060000089884 | 14060000089915 | 1 | 2 | BTA | PRJLSNR5S279BTA0066 | |
| 14060000089941 | L14/dossiers | 14 | 14060000089919 | 14060000089940 | 1 | 2 | BTA | PIONANR5L14BTA0281 | |
| 14060000089959 | L14/dossiers | 14 | 14060000089919 | 14060000089958 | 1 | 2 | BTA | PIONSNR5S219BTA0147 | |
| 14060000089970 | L14/dossiers | 14 | 14060000089919 | 14060000089969 | 1 | 2 | BTA | PIONANR5L14BTA0468 | |
| 14060000090019 | L14/dossiers | 14 | 14060000090006 | 14060000090018 | 1 | 2 | BTA | PIONSNR5S219BTA0032 | |
| 14060000090033 | L14/dossiers | 14 | 14060000090006 | 14060000090032 | 1 | 2 | BTA | PIONANR5L14BTA0280 | |
| 14060000090057 | L14/dossiers | 14 | 14060000090050 | 14060000090056 | 1 | 2 | BTA | RIONANR5L14BTA0611 | |
| 14060000090113 | L14/dossiers | 14 | 14060000090099 | 14060000090112 | 1 | 2 | BTA | PRJLSNR5S239BTA0043 | |
| 14060000090125 | L14/dossiers | 14 | 14060000090099 | 14060000090124 | 1 | 2 | BTA | PRJLANR5L14BTA0547 | |
| 14060000090149 | L14/dossiers | 14 | 14060000090128 | 14060000090148 | 1 | 2 | BTA | PRJLSNR5S199BTA0169 | |
| 14060000090164 | L14/dossiers | 14 | 14060000090128 | 14060000090163 | 1 | 2 | BTA | PRJLANR5L14BTA0195 | |
| 14060000090189 | L14/dossiers | 14 | 14060000090181 | 14060000090188 | 1 | 2 | BTA | RIONANR5L14BTA0844 | |
| 14060000090295 | L14/dossiers | 14 | 14060000090277 | 14060000090294 | 1 | 2 | BTA | PIONANR5L14BTA0765 | |
| 14060000090324 | L14/dossiers | 14 | 14060000090310 | 14060000090323 | 1 | 2 | BTA | PIONSNR5S199BTA0203 | |
| 14060000090338 | L14/dossiers | 14 | 14060000090310 | 14060000090337 | 1 | 2 | BTA | PIONANR5L14BTA0203 | |
| 14060000090355 | L14/dossiers | 14 | 14060000090341 | 14060000090354 | 1 | 2 | BTA | PIONSNR5S199BTA0036 | |
| 14060000090370 | L14/dossiers | 14 | 14060000090341 | 14060000090369 | 1 | 2 | BTA | PIONANR5L14BTA0063 | |
| 14060000090440 | L14/dossiers | 14 | 14060000090426 | 14060000090439 | 1 | 2 | BTA | RIONANR5L14BTA0752 | |
| 14060000090464 | L14/dossiers | 14 | 14060000090448 | 14060000090463 | 1 | 2 | BTA | PIONANR5L14BTA0253 | |
| 14060000090478 | L14/dossiers | 14 | 14060000090465 | 14060000090477 | 1 | 2 | BTA | PIONSNR5S259BTA0141 | |
| 14060000090492 | L14/dossiers | 14 | 14060000090465 | 14060000090491 | 1 | 2 | BTA | PIONANR5L14BTA0813 | |
| 14060000090502 | L14/dossiers | 14 | 14060000090465 | 14060000090501 | 1 | 2 | BTA | PIONSNR5S279BTA0003 | |
| 14060000090563 | L14/dossiers | 14 | 14060000090542 | 14060000090562 | 1 | 2 | BTA | PRJLANR5L14BTA0593 | |
| 14060000090580 | L14/dossiers | 14 | 14060000090542 | 14060000090579 | 1 | 2 | BTA | PRJLSNR5S259BTA0023 |