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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000134478 | L14/dossiers | 14 | 14060000134449 | 14060000134477 | 1 | 2 | BTA | PIONSNR5S279BTA0013 | |
| 14060000134492 | L14/dossiers | 14 | 14060000134449 | 14060000134491 | 1 | 2 | BTA | PIONANR5L14BTA0862 | |
| 14060000134496 | L14/dossiers | 14 | 14060000134449 | 14060000134495 | 1 | 2 | BTA | PIONSNR5S279BTA0053 | |
| 14060000134517 | L14/dossiers | 14 | 14060000134500 | 14060000134516 | 1 | 2 | BTA | PRJLANR5L14BTA0446 | |
| 14060000134529 | L14/dossiers | 14 | 14060000134500 | 14060000134528 | 1 | 2 | BTA | PRJLSNR5S239BTA0040 | |
| 14060000134549 | L14/dossiers | 14 | 14060000134500 | 14060000134548 | 1 | 2 | BTA | PRJLANR5L14BTA0463 | |
| 14060000134559 | L14/dossiers | 14 | 14060000134500 | 14060000134558 | 1 | 2 | BTA | PRJLSNR5S239BTA0066 | |
| 14060000134569 | L14/dossiers | 14 | 14060000134500 | 14060000134568 | 1 | 2 | BTA | PRJLANR5L14BTA0474 | |
| 14060000134601 | L14/dossiers | 14 | 14060000134579 | 14060000134600 | 1 | 2 | BTA | PRJLSNR5S198BTA0141 | |
| 14060000134629 | L14/dossiers | 14 | 14060000134579 | 14060000134628 | 1 | 2 | BTA | PRJLANR5L14BTA0016 | |
| 14060000134643 | L14/dossiers | 14 | 14060000134579 | 14060000134642 | 1 | 2 | BTA | PRJLSNR5S199BTA0007 | |
| 14060000134648 | L14/dossiers | 14 | 14060000134579 | 14060000134647 | 1 | 2 | BTA | PRJLANR5L14BTA0021 | |
| 14060000134731 | L14/dossiers | 14 | 14060000134722 | 14060000134730 | 1 | 2 | BTA | RIONANR5L14BTA0879 | |
| 14060000134774 | L14/dossiers | 14 | 14060000134761 | 14060000134773 | 1 | 2 | BTA | PIONANR5L14BTA0056 | |
| 14060000134810 | L14/dossiers | 14 | 14060000134789 | 14060000134809 | 1 | 2 | BTA | PIONANR5L14BTA0557 | |
| 14060000134822 | L14/dossiers | 14 | 14060000134789 | 14060000134821 | 1 | 2 | BTA | PIONSNR5S259BTA0013 | |
| 14060000134836 | L14/dossiers | 14 | 14060000134789 | 14060000134835 | 1 | 2 | BTA | PIONANR5L14BTA0606 | |
| 14060000134840 | L14/dossiers | 14 | 14060000134789 | 14060000134839 | 1 | 2 | BTA | PIONSNR5S259BTA0043 | |
| 14060000134871 | L14/dossiers | 14 | 14060000134858 | 14060000134870 | 1 | 2 | BTA | PIONSNR5S259BTA0167 | |
| 14060000134886 | L14/dossiers | 14 | 14060000134858 | 14060000134885 | 1 | 2 | BTA | PIONANR5L14BTA0840 | |
| 14060000134903 | L14/dossiers | 14 | 14060000134889 | 14060000134902 | 1 | 2 | BTA | PRJLSNR5S239BTA0017 | |
| 14060000134917 | L14/dossiers | 14 | 14060000134889 | 14060000134916 | 1 | 2 | BTA | PRJLANR5L14BTA0731 | |
| 14060000134936 | L14/dossiers | 14 | 14060000134923 | 14060000134935 | 1 | 2 | BTA | PIONSNR5S259BTA0104 | |
| 14060000134950 | L14/dossiers | 14 | 14060000134923 | 14060000134949 | 1 | 2 | BTA | PIONANR5L14BTA0749 | |
| 14060000134960 | L14/dossiers | 14 | 14060000134923 | 14060000134959 | 1 | 2 | BTA | PIONSNR5S279BTA0005 | |
| 14060000134978 | L14/dossiers | 14 | 14060000134963 | 14060000134977 | 1 | 2 | BTA | PIONANR5L14BTA0470 | |
| 14060000134990 | L14/dossiers | 14 | 14060000134963 | 14060000134989 | 1 | 2 | BTA | PIONSNR5S239BTA0102 | |
| 14060000135060 | L14/dossiers | 14 | 14060000135007 | 14060000135059 | 1 | 2 | BTA | PRJLANR5L14BTA0787 | |
| 14060000135079 | L14/dossiers | 14 | 14060000135007 | 14060000135078 | 1 | 2 | BTA | PRJLSNR5S279BTA0004 | |
| 14060000135109 | L14/dossiers | 14 | 14060000135007 | 14060000135108 | 1 | 2 | BTA | PRJLANR5L14BTA0838 | |
| 14060000135119 | L14/dossiers | 14 | 14060000135007 | 14060000135118 | 1 | 2 | BTA | PRJLSNR5S279BTA0040 | |
| 14060000135128 | L14/dossiers | 14 | 14060000135007 | 14060000135127 | 1 | 2 | BTA | PRJLANR5L14BTA0878 | |
| 14060000135152 | L14/dossiers | 14 | 14060000135143 | 14060000135151 | 1 | 2 | BTA | RIONANR5L14BTA0399 | |
| 14060000135195 | L14/dossiers | 14 | 14060000135181 | 14060000135194 | 1 | 2 | BTA | PRJLSNR5S279BTA0010 | |
| 14060000135210 | L14/dossiers | 14 | 14060000135181 | 14060000135209 | 1 | 2 | BTA | PRJLANR5L14BTA0834 | |
| 14060000135225 | L14/dossiers | 14 | 14060000135181 | 14060000135224 | 1 | 2 | BTA | PRJLANR5L14BTA0894 | |
| 14060000135229 | L14/dossiers | 14 | 14060000135181 | 14060000135228 | 1 | 2 | BTA | PRJLSNR5S279BTA0084 | |
| 14060000135289 | L14/dossiers | 14 | 14060000135261 | 14060000135288 | 1 | 2 | BTA | PRJLANR5L14BTA0060 | |
| 14060000135302 | L14/dossiers | 14 | 14060000135261 | 14060000135301 | 1 | 2 | BTA | PRJLSNR5S199BTA0051 | |
| 14060000135324 | L14/dossiers | 14 | 14060000135261 | 14060000135323 | 1 | 2 | BTA | PRJLANR5L14BTA0067 | |
| 14060000135334 | L14/dossiers | 14 | 14060000135261 | 14060000135333 | 1 | 2 | BTA | PRJLSNR5S199BTA0062 | |
| 14060000135345 | L14/dossiers | 14 | 14060000135261 | 14060000135344 | 1 | 2 | BTA | PRJLANR5L14BTA0071 | |
| 14060000135376 | L14/dossiers | 14 | 14060000135363 | 14060000135375 | 1 | 2 | BTA | PIONSNR5S239BTA0031 | |
| 14060000135391 | L14/dossiers | 14 | 14060000135363 | 14060000135390 | 1 | 2 | BTA | PIONANR5L14BTA0531 | |
| 14060000135412 | L14/dossiers | 14 | 14060000135394 | 14060000135411 | 1 | 2 | BTA | PRJLANR5L14BTA0330 | |
| 14060000135424 | L14/dossiers | 14 | 14060000135394 | 14060000135423 | 1 | 2 | BTA | PRJLSNR5S219BTA0117 | |
| 14060000135434 | L14/dossiers | 14 | 14060000135427 | 14060000135433 | 1 | 2 | BTA | RIONANR5L14BTA0612 | |
| 14060000135472 | L14/dossiers | 14 | 14060000135456 | 14060000135471 | 1 | 2 | BTA | PIONANR5L14BTA0059 | |
| 14060000135501 | L14/dossiers | 14 | 14060000135487 | 14060000135500 | 1 | 2 | BTA | PRJLSNR5S259BTA0077 | |
| 14060000135515 | L14/dossiers | 14 | 14060000135487 | 14060000135514 | 1 | 2 | BTA | PRJLANR5L14BTA0680 |