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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000113723 | L14/dossiers | 14 | 14060000113710 | 14060000113722 | 1 | 2 | BTA | PIONSNR5S219BTA0124 | |
| 14060000113815 | L14/dossiers | 14 | 14060000113796 | 14060000113814 | 1 | 2 | BTA | PIONANR5L14BTA0743 | |
| 14060000113827 | L14/dossiers | 14 | 14060000113796 | 14060000113826 | 1 | 2 | BTA | PIONSNR5S259BTA0162 | |
| 14060000113842 | L14/dossiers | 14 | 14060000113796 | 14060000113841 | 1 | 2 | BTA | PIONANR5L14BTA0798 | |
| 14060000113846 | L14/dossiers | 14 | 14060000113796 | 14060000113845 | 1 | 2 | BTA | PIONSNR5S259BTA0180 | |
| 14060000113927 | L14/dossiers | 14 | 14060000113876 | 14060000113926 | 1 | 2 | BTA | PRJLANR5L14BTA0755 | |
| 14060000113953 | L14/dossiers | 14 | 14060000113876 | 14060000113952 | 1 | 2 | BTA | PRJLSNR5S259BTA0174 | |
| 14060000113990 | L14/dossiers | 14 | 14060000113876 | 14060000113989 | 1 | 2 | BTA | PRJLANR5L14BTA0818 | |
| 14060000114000 | L14/dossiers | 14 | 14060000113876 | 14060000113999 | 1 | 2 | BTA | PRJLSNR5S279BTA0014 | |
| 14060000114011 | L14/dossiers | 14 | 14060000113876 | 14060000114010 | 1 | 2 | BTA | PRJLANR5L14BTA0830 | |
| 14060000114037 | L14/dossiers | 14 | 14060000114020 | 14060000114036 | 1 | 2 | BTA | PRJLANR5L14BTA0006 | |
| 14060000114049 | L14/dossiers | 14 | 14060000114020 | 14060000114048 | 1 | 2 | BTA | PRJLSNR5S199BTA0027 | |
| 14060000114080 | L14/dossiers | 14 | 14060000114067 | 14060000114079 | 1 | 2 | BTA | PIONSNR5S219BTA0034 | |
| 14060000114275 | L14/dossiers | 14 | 14060000114226 | 14060000114274 | 1 | 2 | BTA | PRJLANR5L14BTA0273 | |
| 14060000114303 | L14/dossiers | 14 | 14060000114226 | 14060000114302 | 1 | 2 | BTA | PRJLSNR5S219BTA0098 | |
| 14060000114323 | L14/dossiers | 14 | 14060000114226 | 14060000114322 | 1 | 2 | BTA | PRJLANR5L14BTA0377 | |
| 14060000114335 | L14/dossiers | 14 | 14060000114226 | 14060000114334 | 1 | 2 | BTA | PRJLSNR5S219BTA0162 | |
| 14060000114350 | L14/dossiers | 14 | 14060000114226 | 14060000114349 | 1 | 2 | BTA | PRJLSNR5S219BTA0171 | |
| 14060000114354 | L14/dossiers | 14 | 14060000114226 | 14060000114353 | 1 | 2 | BTA | PRJLANR5L14BTA0402 | |
| 14060000114382 | L14/dossiers | 14 | 14060000114367 | 14060000114381 | 1 | 2 | BTA | PIONANR5L14BTA0902 | |
| 14060000114412 | L14/dossiers | 14 | 14060000114398 | 14060000114411 | 1 | 2 | BTA | PRJLSNR5S239BTA0110 | |
| 14060000114425 | L14/dossiers | 14 | 14060000114398 | 14060000114424 | 1 | 2 | BTA | PRJLANR5L14BTA0669 | |
| 14060000114451 | L14/dossiers | 14 | 14060000114435 | 14060000114450 | 1 | 2 | BTA | PIONANR5L14BTA0025 | |
| 14060000114473 | L14/dossiers | 14 | 14060000114459 | 14060000114472 | 1 | 2 | BTA | PIONSNR5S259BTA0038 | |
| 14060000114488 | L14/dossiers | 14 | 14060000114459 | 14060000114487 | 1 | 2 | BTA | PIONANR5L14BTA0693 | |
| 14060000114525 | L14/dossiers | 14 | 14060000114505 | 14060000114524 | 1 | 2 | BTA | PRJLANR5L14BTA0170 | |
| 14060000114537 | L14/dossiers | 14 | 14060000114505 | 14060000114536 | 1 | 2 | BTA | PRJLSNR5S219BTA0052 | |
| 14060000114563 | L14/dossiers | 14 | 14060000114547 | 14060000114562 | 1 | 2 | BTA | PIONANR5L14BTA0220 | |
| 14060000114591 | L14/dossiers | 14 | 14060000114571 | 14060000114590 | 1 | 2 | BTA | RIONANR5L14BTA0155 | |
| 14060000114623 | L14/dossiers | 14 | 14060000114606 | 14060000114622 | 1 | 2 | BTA | PIONANR5L14BTA0762 | |
| 14060000114682 | L14/dossiers | 14 | 14060000114668 | 14060000114681 | 1 | 2 | BTA | RIONANR5L14BTA0256 | |
| 14060000114699 | L14/dossiers | 14 | 14060000114686 | 14060000114698 | 1 | 2 | BTA | PRJLSNR5S199BTA0156 | |
| 14060000114711 | L14/dossiers | 14 | 14060000114686 | 14060000114710 | 1 | 2 | BTA | PRJLANR5L14BTA0584 | |
| 14060000114777 | L14/dossiers | 14 | 14060000114756 | 14060000114776 | 1 | 2 | BTA | PRJLANR5L14BTA0145 | |
| 14060000114790 | L14/dossiers | 14 | 14060000114756 | 14060000114789 | 1 | 2 | BTA | PRJLSNR5S199BTA0187 | |
| 14060000114802 | L14/dossiers | 14 | 14060000114756 | 14060000114801 | 1 | 2 | BTA | PRJLANR5L14BTA0183 | |
| 14060000114812 | L14/dossiers | 14 | 14060000114756 | 14060000114811 | 1 | 2 | BTA | PRJLSNR5S199BTA0196 | |
| 14060000114860 | L14/dossiers | 14 | 14060000114847 | 14060000114859 | 1 | 2 | BTA | PIONSNR5S219BTA0126 | |
| 14060000114876 | L14/dossiers | 14 | 14060000114847 | 14060000114875 | 1 | 2 | BTA | PIONANR5L14BTA0440 | |
| 14060000114976 | L14/dossiers | 14 | 14060000114950 | 14060000114975 | 1 | 2 | BTA | PRJLANR5L14BTA0178 | |
| 14060000114989 | L14/dossiers | 14 | 14060000114950 | 14060000114988 | 1 | 2 | BTA | PRJLSNR5S199BTA0216 | |
| 14060000115013 | L14/dossiers | 14 | 14060000114950 | 14060000115012 | 1 | 2 | BTA | PRJLANR5L14BTA0242 | |
| 14060000115023 | L14/dossiers | 14 | 14060000114950 | 14060000115022 | 1 | 2 | BTA | PRJLSNR5S219BTA0061 | |
| 14060000115034 | L14/dossiers | 14 | 14060000114950 | 14060000115033 | 1 | 2 | BTA | PRJLANR5L14BTA0278 | |
| 14060000115047 | L14/dossiers | 14 | 14060000115040 | 14060000115046 | 1 | 2 | BTA | PNREANR5L14BTA0121 | |
| 14060000115064 | L14/dossiers | 14 | 14060000115048 | 14060000115063 | 1 | 2 | BTA | PRJLANR5L14BTA0668 | |
| 14060000115076 | L14/dossiers | 14 | 14060000115048 | 14060000115075 | 1 | 2 | BTA | PRJLSNR5S259BTA0110 | |
| 14060000115104 | L14/dossiers | 14 | 14060000115086 | 14060000115103 | 1 | 2 | BTA | PRJLANR5L14BTA0641 | |
| 14060000115116 | L14/dossiers | 14 | 14060000115086 | 14060000115115 | 1 | 2 | BTA | PRJLSNR5S259BTA0076 | |
| 14060000115130 | L14/dossiers | 14 | 14060000115086 | 14060000115129 | 1 | 2 | BTA | PRJLANR5L14BTA0682 |