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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000135006 | L15/dossiers | 15 | 15060000134988 | 15060000135005 | 1 | 2 | BTA | PIONSNR5S299BTA0051 | |
| 15060000135044 | L15/dossiers | 15 | 15060000135026 | 15060000135043 | 1 | 2 | BTA | PRJLANR5L15BTA0085 | |
| 15060000135056 | L15/dossiers | 15 | 15060000135026 | 15060000135055 | 1 | 2 | BTA | PRJLSNR5S299BTA0098 | |
| 15060000135077 | L15/dossiers | 15 | 15060000135059 | 15060000135076 | 1 | 2 | BTA | PRJLANR5L15BTA0086 | |
| 15060000135089 | L15/dossiers | 15 | 15060000135059 | 15060000135088 | 1 | 2 | BTA | PRJLSNR5S299BTA0078 | |
| 15060000135110 | L15/dossiers | 15 | 15060000135095 | 15060000135109 | 1 | 2 | BTA | RIONANR5L15BTA0075 | |
| 15060000135141 | L15/dossiers | 15 | 15060000135125 | 15060000135140 | 1 | 2 | BTA | PIONANR5L15BTA0074 | |
| 15060000135142 | L15/dossiers | 15 | 15060000135125 | 15060000135140 | 2 | 2 | TAP | PIONANR5L15TAP0074 | |
| 15060000135154 | L15/dossiers | 15 | 15060000135125 | 15060000135153 | 1 | 2 | BTA | PIONSNR5S299BTA0094 | |
| 15060000135177 | L15/dossiers | 15 | 15060000135125 | 15060000135176 | 1 | 2 | BTA | PIONANR5L15BTA0158 | |
| 15060000135178 | L15/dossiers | 15 | 15060000135125 | 15060000135176 | 2 | 2 | TAP | PIONANR5L15TAP0158 | |
| 15060000135188 | L15/dossiers | 15 | 15060000135125 | 15060000135187 | 1 | 2 | BTA | PIONSNR5S299BTA0154 | |
| 15060000135196 | L15/dossiers | 15 | 15060000135125 | 15060000135195 | 1 | 2 | BTA | PIONANR5L15BTA0166 | |
| 15060000135197 | L15/dossiers | 15 | 15060000135125 | 15060000135195 | 2 | 2 | TAP | PIONANR5L15TAP0166 | |
| 15060000135249 | L15/dossiers | 15 | 15060000135225 | 15060000135248 | 1 | 2 | BTA | PRJLANR5L15BTA0092 | |
| 15060000135262 | L15/dossiers | 15 | 15060000135225 | 15060000135261 | 1 | 2 | BTA | PRJLSNR5S299BTA0093 | |
| 15060000135276 | L15/dossiers | 15 | 15060000135225 | 15060000135275 | 1 | 2 | BTA | PRJLANR5L15BTA0114 | |
| 15060000135277 | L15/dossiers | 15 | 15060000135225 | 15060000135275 | 2 | 2 | TAP | PRJLANR5L15TAP0114 | |
| 15060000135281 | L15/dossiers | 15 | 15060000135225 | 15060000135280 | 1 | 2 | BTA | PRJLSNR5S299BTA0107 | |
| 15060000135309 | L15/dossiers | 15 | 15060000135302 | 15060000135308 | 1 | 2 | BTA | RIONANR5L15BTA0072 | |
| 15060000135383 | L15/dossiers | 15 | 15060000135368 | 15060000135382 | 1 | 2 | BTA | PIONANR5L15BTA0117 | |
| 15060000135384 | L15/dossiers | 15 | 15060000135368 | 15060000135382 | 2 | 2 | TAP | PIONANR5L15TAP0117 | |
| 15060000135567 | L15/dossiers | 15 | 15060000135553 | 15060000135566 | 1 | 2 | BTA | PRJLSNR5S299BTA0099 | |
| 15060000135589 | L15/dossiers | 15 | 15060000135553 | 15060000135588 | 1 | 2 | BTA | PRJLANR5L15BTA0155 | |
| 15060000135616 | L15/dossiers | 15 | 15060000135599 | 15060000135615 | 1 | 2 | BTA | PIONANR5L15BTA0099 | |
| 15060000135727 | L15/dossiers | 15 | 15060000135707 | 15060000135726 | 1 | 2 | BTA | PRJLANR5L15BTA0157 | |
| 15060000135739 | L15/dossiers | 15 | 15060000135707 | 15060000135738 | 1 | 2 | BTA | PRJLSNR5S319BTA0005 | |
| 15060000135783 | L15/dossiers | 15 | 15060000135770 | 15060000135782 | 1 | 2 | BTA | RIONANR5L15BTA0100 | |
| 15060000135847 | L15/dossiers | 15 | 15060000135833 | 15060000135846 | 1 | 2 | BTA | PRJLSNR5S299BTA0077 | |
| 15060000135861 | L15/dossiers | 15 | 15060000135833 | 15060000135860 | 1 | 2 | BTA | PRJLANR5L15BTA0175 | |
| 15060000135962 | L15/dossiers | 15 | 15060000135941 | 15060000135961 | 1 | 2 | BTA | PRJLANR5L15BTA0156 | |
| 15060000135974 | L15/dossiers | 15 | 15060000135941 | 15060000135973 | 1 | 2 | BTA | PRJLSNR5S319BTA0058 | |
| 15060000135994 | L15/dossiers | 15 | 15060000135977 | 15060000135993 | 1 | 2 | BTA | PRJLSNR5S299BTA0067 | |
| 15060000136009 | L15/dossiers | 15 | 15060000135977 | 15060000136008 | 1 | 2 | BTA | PRJLANR5L15BTA0102 | |
| 15060000136010 | L15/dossiers | 15 | 15060000135977 | 15060000136008 | 2 | 2 | TAP | PRJLANR5L15TAP0102 | |
| 15060000136085 | L15/dossiers | 15 | 15060000136023 | 15060000136084 | 1 | 2 | BTA | PRJLANR5L15BTA0121 | |
| 15060000136086 | L15/dossiers | 15 | 15060000136023 | 15060000136084 | 2 | 2 | TAP | PRJLANR5L15TAP0121 | |
| 15060000136107 | L15/dossiers | 15 | 15060000136023 | 15060000136106 | 1 | 2 | BTA | PRJLSNR5S299BTA0132 | |
| 15060000136139 | L15/dossiers | 15 | 15060000136023 | 15060000136138 | 1 | 2 | BTA | PRJLANR5L15BTA0171 | |
| 15060000136140 | L15/dossiers | 15 | 15060000136023 | 15060000136138 | 2 | 2 | TAP | PRJLANR5L15TAP0171 | |
| 15060000136150 | L15/dossiers | 15 | 15060000136023 | 15060000136149 | 1 | 2 | BTA | PRJLSNR5S299BTA0158 | |
| 15060000136160 | L15/dossiers | 15 | 15060000136023 | 15060000136159 | 1 | 2 | BTA | PRJLANR5L15BTA0177 | |
| 15060000136161 | L15/dossiers | 15 | 15060000136023 | 15060000136159 | 2 | 2 | TAP | PRJLANR5L15TAP0177 | |
| 15060000136219 | L15/dossiers | 15 | 15060000136203 | 15060000136218 | 1 | 2 | BTA | PIONANR5L15BTA0521 | |
| 15060000136240 | L15/dossiers | 15 | 15060000136220 | 15060000136239 | 1 | 2 | BTA | RIONANR5L15BTA0093 | |
| 15060000136241 | L15/dossiers | 15 | 15060000136220 | 15060000136239 | 2 | 2 | TAP | RIONANR5L15TAP0093 | |
| 15060000136289 | L15/dossiers | 15 | 15060000136270 | 15060000136288 | 1 | 2 | BTA | PIONANR5L15BTA0185 | |
| 15060000136317 | L15/dossiers | 15 | 15060000136304 | 15060000136316 | 1 | 2 | BTA | PIONSNR5S299BTA0070 | |
| 15060000136386 | L15/dossiers | 15 | 15060000136370 | 15060000136385 | 1 | 2 | BTA | RIONANR5L15BTA0094 | |
| 15060000136387 | L15/dossiers | 15 | 15060000136370 | 15060000136385 | 2 | 2 | TAP | RIONANR5L15TAP0094 |