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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000129079 | L14/dossiers | 14 | 14060000129006 | 14060000129078 | 1 | 2 | BTA | PRJLSNR5S219BTA0166 | |
| 14060000129098 | L14/dossiers | 14 | 14060000129085 | 14060000129097 | 1 | 2 | BTA | PIONSNR5S279BTA0072 | |
| 14060000129136 | L14/dossiers | 14 | 14060000129116 | 14060000129135 | 1 | 2 | BTA | RIONANR5L14BTA0522 | |
| 14060000129145 | L14/dossiers | 14 | 14060000129137 | 14060000129144 | 1 | 2 | BTA | RIONANR5L14BTA0160 | |
| 14060000129181 | L14/dossiers | 14 | 14060000129167 | 14060000129180 | 1 | 2 | BTA | PRJLSNR5S239BTA0118 | |
| 14060000129204 | L14/dossiers | 14 | 14060000129190 | 14060000129203 | 1 | 2 | BTA | RIONANR5L14BTA0400 | |
| 14060000129221 | L14/dossiers | 14 | 14060000129205 | 14060000129220 | 1 | 2 | BTA | PIONANR5L14BTA0899 | |
| 14060000129281 | L14/dossiers | 14 | 14060000129268 | 14060000129280 | 1 | 2 | BTA | RIONANR5L14BTA0154 | |
| 14060000129305 | L14/dossiers | 14 | 14060000129292 | 14060000129304 | 1 | 2 | BTA | PRJLSNR5S299BTA0005 | |
| 14060000129319 | L14/dossiers | 14 | 14060000129292 | 14060000129318 | 1 | 2 | BTA | PRJLANR5L15BTA0046 | |
| 14060000129320 | L14/dossiers | 14 | 14060000129292 | 14060000129318 | 2 | 2 | TAP | PRJLANR5L15TAP0046 | |
| 14060000129330 | L14/dossiers | 14 | 14060000129292 | 14060000129329 | 1 | 2 | BTA | PRJLSNR5S299BTA0054 | |
| 14060000129343 | L14/dossiers | 14 | 14060000129292 | 14060000129342 | 1 | 2 | BTA | PRJLANR5L15BTA0091 | |
| 14060000129344 | L14/dossiers | 14 | 14060000129292 | 14060000129342 | 2 | 2 | TAP | PRJLANR5L15TAP0091 | |
| 14060000129368 | L14/dossiers | 14 | 14060000129357 | 14060000129367 | 1 | 2 | BTA | RIONANR5L14BTA0889 | |
| 14060000129384 | L14/dossiers | 14 | 14060000129369 | 14060000129383 | 1 | 2 | BTA | PRJLSNR5S199BTA0071 | |
| 14060000129396 | L14/dossiers | 14 | 14060000129369 | 14060000129395 | 1 | 2 | BTA | PRJLANR5L14BTA0078 | |
| 14060000129434 | L14/dossiers | 14 | 14060000129417 | 14060000129433 | 1 | 2 | BTA | PIONANR5L14BTA0152 | |
| 14060000129502 | L14/dossiers | 14 | 14060000129463 | 14060000129501 | 1 | 2 | BTA | PRJLANR5L14BTA0002 | |
| 14060000129527 | L14/dossiers | 14 | 14060000129463 | 14060000129526 | 1 | 2 | BTA | PRJLSNR5S198BTA0134 | |
| 14060000129541 | L14/dossiers | 14 | 14060000129463 | 14060000129540 | 1 | 2 | BTA | PRJLANR5L14BTA0013 | |
| 14060000129545 | L14/dossiers | 14 | 14060000129463 | 14060000129544 | 1 | 2 | BTA | PRJLSNR5S198BTA0138 | |
| 14060000129587 | L14/dossiers | 14 | 14060000129578 | 14060000129586 | 1 | 2 | BTA | RIONANR5L14BTA0655 | |
| 14060000129622 | L14/dossiers | 14 | 14060000129605 | 14060000129621 | 1 | 2 | BTA | PRJLANR5L14BTA0291 | |
| 14060000129634 | L14/dossiers | 14 | 14060000129605 | 14060000129633 | 1 | 2 | BTA | PRJLSNR5S219BTA0108 | |
| 14060000129667 | L14/dossiers | 14 | 14060000129637 | 14060000129666 | 1 | 2 | BTA | PIONANR5L14BTA0495 | |
| 14060000129682 | L14/dossiers | 14 | 14060000129637 | 14060000129681 | 1 | 2 | BTA | PIONSNR5S259BTA0070 | |
| 14060000129698 | L14/dossiers | 14 | 14060000129637 | 14060000129697 | 1 | 2 | BTA | PIONANR5L14BTA0804 | |
| 14060000129725 | L14/dossiers | 14 | 14060000129711 | 14060000129724 | 1 | 2 | BTA | PRJLSNR5S199BTA0012 | |
| 14060000129743 | L14/dossiers | 14 | 14060000129711 | 14060000129742 | 1 | 2 | BTA | PRJLANR5L14BTA0049 | |
| 14060000129757 | L14/dossiers | 14 | 14060000129711 | 14060000129756 | 1 | 2 | BTA | PRJLSNR5S199BTA0044 | |
| 14060000129761 | L14/dossiers | 14 | 14060000129711 | 14060000129760 | 1 | 2 | BTA | PRJLANR5L14BTA0064 | |
| 14060000129801 | L14/dossiers | 14 | 14060000129787 | 14060000129800 | 1 | 2 | BTA | PRJLSNR5S219BTA0082 | |
| 14060000129814 | L14/dossiers | 14 | 14060000129787 | 14060000129813 | 1 | 2 | BTA | PRJLANR5L14BTA0476 | |
| 14060000129882 | L14/dossiers | 14 | 14060000129866 | 14060000129881 | 1 | 2 | BTA | PRJLANR5L14BTA0667 | |
| 14060000129894 | L14/dossiers | 14 | 14060000129866 | 14060000129893 | 1 | 2 | BTA | PRJLSNR5S259BTA0134 | |
| 14060000129956 | L14/dossiers | 14 | 14060000129939 | 14060000129955 | 1 | 2 | BTA | PRJLANR5L14BTA0405 | |
| 14060000129968 | L14/dossiers | 14 | 14060000129939 | 14060000129967 | 1 | 2 | BTA | PRJLSNR5S239BTA0046 | |
| 14060000130012 | L14/dossiers | 14 | 14060000129995 | 14060000130011 | 1 | 2 | BTA | PRJLANR5L14BTA0550 | |
| 14060000130024 | L14/dossiers | 14 | 14060000129995 | 14060000130023 | 1 | 2 | BTA | PRJLSNR5S239BTA0132 | |
| 14060000130050 | L14/dossiers | 14 | 14060000130030 | 14060000130049 | 1 | 2 | BTA | PRJLANR5L14BTA0705 | |
| 14060000130062 | L14/dossiers | 14 | 14060000130030 | 14060000130061 | 1 | 2 | BTA | PRJLSNR5S259BTA0144 | |
| 14060000130096 | L14/dossiers | 14 | 14060000130079 | 14060000130095 | 1 | 2 | BTA | PIONSNR5S239BTA0112 | |
| 14060000130111 | L14/dossiers | 14 | 14060000130079 | 14060000130110 | 1 | 2 | BTA | PIONANR5L14BTA0543 | |
| 14060000130131 | L14/dossiers | 14 | 14060000130117 | 14060000130130 | 1 | 2 | BTA | RIONANR5L14BTA0321 | |
| 14060000130148 | L14/dossiers | 14 | 14060000130135 | 14060000130147 | 1 | 2 | BTA | PIONSNR5S279BTA0007 | |
| 14060000130195 | L14/dossiers | 14 | 14060000130176 | 14060000130194 | 1 | 2 | BTA | PRJLANR5L14BTA0876 | |
| 14060000130207 | L14/dossiers | 14 | 14060000130176 | 14060000130206 | 1 | 2 | BTA | PRJLSNR5S279BTA0068 | |
| 14060000130280 | L14/dossiers | 14 | 14060000130264 | 14060000130279 | 1 | 2 | BTA | PRJLANR5L14BTA0376 | |
| 14060000130292 | L14/dossiers | 14 | 14060000130264 | 14060000130291 | 1 | 2 | BTA | PRJLSNR5S219BTA0155 |