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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000093987 | L14/dossiers | 14 | 14060000093977 | 14060000093986 | 1 | 2 | BTA | RIONANR5L14BTA0751 | |
| 14060000094005 | L14/dossiers | 14 | 14060000093995 | 14060000094004 | 1 | 2 | BTA | RIONANR5L14BTA0776 | |
| 14060000094058 | L14/dossiers | 14 | 14060000094037 | 14060000094057 | 1 | 2 | BTA | PRJLANR5L14BTA0047 | |
| 14060000094071 | L14/dossiers | 14 | 14060000094037 | 14060000094070 | 1 | 2 | BTA | PRJLSNR5S199BTA0060 | |
| 14060000094119 | L14/dossiers | 14 | 14060000094101 | 14060000094118 | 1 | 2 | BTA | PRJLANR5L14BTA0587 | |
| 14060000094131 | L14/dossiers | 14 | 14060000094101 | 14060000094130 | 1 | 2 | BTA | PRJLSNR5S259BTA0012 | |
| 14060000094166 | L14/dossiers | 14 | 14060000094152 | 14060000094165 | 1 | 2 | BTA | PRJLSNR5S279BTA0121 | |
| 14060000094179 | L14/dossiers | 14 | 14060000094152 | 14060000094178 | 1 | 2 | BTA | PRJLANR5L15BTA0021 | |
| 14060000094269 | L14/dossiers | 14 | 14060000094255 | 14060000094268 | 1 | 2 | BTA | PRJLSNR5S239BTA0019 | |
| 14060000094283 | L14/dossiers | 14 | 14060000094255 | 14060000094282 | 1 | 2 | BTA | PRJLANR5L14BTA0886 | |
| 14060000094329 | L14/dossiers | 14 | 14060000094310 | 14060000094328 | 1 | 2 | BTA | PRJLANR5L14BTA0137 | |
| 14060000094346 | L14/dossiers | 14 | 14060000094310 | 14060000094345 | 1 | 2 | BTA | PRJLSNR5S199BTA0152 | |
| 14060000094360 | L14/dossiers | 14 | 14060000094310 | 14060000094359 | 1 | 2 | BTA | PRJLANR5L14BTA0193 | |
| 14060000094364 | L14/dossiers | 14 | 14060000094310 | 14060000094363 | 1 | 2 | BTA | PRJLSNR5S199BTA0209 | |
| 14060000094396 | L14/dossiers | 14 | 14060000094381 | 14060000094395 | 1 | 2 | BTA | PIONANR5L14BTA0722 | |
| 14060000094443 | L14/dossiers | 14 | 14060000094430 | 14060000094442 | 1 | 2 | BTA | RIONANR5L14BTA0236 | |
| 14060000094500 | L14/dossiers | 14 | 14060000094485 | 14060000094499 | 1 | 2 | BTA | PIONSNR5S199BTA0089 | |
| 14060000094514 | L14/dossiers | 14 | 14060000094485 | 14060000094513 | 1 | 2 | BTA | PIONANR5L14BTA0097 | |
| 14060000094528 | L14/dossiers | 14 | 14060000094485 | 14060000094527 | 1 | 2 | BTA | PIONANR5L14BTA0134 | |
| 14060000094532 | L14/dossiers | 14 | 14060000094485 | 14060000094531 | 1 | 2 | BTA | PIONSNR5S199BTA0147 | |
| 14060000094575 | L14/dossiers | 14 | 14060000094555 | 14060000094574 | 1 | 2 | BTA | PRJLANR5L14BTA0785 | |
| 14060000094634 | L14/dossiers | 14 | 14060000094555 | 14060000094633 | 1 | 2 | BTA | PRJLSNR5S259BTA0172 | |
| 14060000094656 | L14/dossiers | 14 | 14060000094555 | 14060000094655 | 1 | 2 | BTA | PRJLANR5L14BTA0791 | |
| 14060000094666 | L14/dossiers | 14 | 14060000094555 | 14060000094665 | 1 | 2 | BTA | PRJLSNR5S259BTA0177 | |
| 14060000094676 | L14/dossiers | 14 | 14060000094555 | 14060000094675 | 1 | 2 | BTA | PRJLANR5L14BTA0794 | |
| 14060000094710 | L14/dossiers | 14 | 14060000094689 | 14060000094709 | 1 | 2 | BTA | PRJLSNR5S279BTA0065 | |
| 14060000094728 | L14/dossiers | 14 | 14060000094689 | 14060000094727 | 1 | 2 | BTA | PRJLANR5L14BTA0908 | |
| 14060000094742 | L14/dossiers | 14 | 14060000094689 | 14060000094741 | 1 | 2 | BTA | PRJLANR5L14BTA0915 | |
| 14060000094746 | L14/dossiers | 14 | 14060000094689 | 14060000094745 | 1 | 2 | BTA | PRJLSNR5S279BTA0095 | |
| 14060000094783 | L14/dossiers | 14 | 14060000094764 | 14060000094782 | 1 | 2 | BTA | RIONANR5L14BTA0903 | |
| 14060000094804 | L14/dossiers | 14 | 14060000094791 | 14060000094803 | 1 | 2 | BTA | PIONSNR5S199BTA0123 | |
| 14060000094818 | L14/dossiers | 14 | 14060000094791 | 14060000094817 | 1 | 2 | BTA | PIONANR5L14BTA0182 | |
| 14060000094868 | L14/dossiers | 14 | 14060000094851 | 14060000094867 | 1 | 2 | BTA | PIONANR5L14BTA0053 | |
| 14060000094881 | L14/dossiers | 14 | 14060000094851 | 14060000094880 | 1 | 2 | BTA | PIONSNR5S199BTA0047 | |
| 14060000094892 | L14/dossiers | 14 | 14060000094851 | 14060000094891 | 1 | 2 | BTA | PIONANR5L14BTA0075 | |
| 14060000094912 | L14/dossiers | 14 | 14060000094898 | 14060000094911 | 1 | 2 | BTA | PRJLSNR5S279BTA0048 | |
| 14060000094931 | L14/dossiers | 14 | 14060000094898 | 14060000094930 | 1 | 2 | BTA | PRJLANR5L15BTA0097 | |
| 14060000095042 | L14/dossiers | 14 | 14060000095010 | 14060000095041 | 1 | 2 | BTA | PRJLANR5L14BTA0327 | |
| 14060000095064 | L14/dossiers | 14 | 14060000095010 | 14060000095063 | 1 | 2 | BTA | PRJLSNR5S219BTA0121 | |
| 14060000095078 | L14/dossiers | 14 | 14060000095010 | 14060000095077 | 1 | 2 | BTA | PRJLSNR5S219BTA0128 | |
| 14060000095082 | L14/dossiers | 14 | 14060000095010 | 14060000095081 | 1 | 2 | BTA | PRJLANR5L14BTA0357 | |
| 14060000095110 | L14/dossiers | 14 | 14060000095093 | 14060000095109 | 1 | 2 | BTA | PIONANR5L14BTA0825 | |
| 14060000095168 | L14/dossiers | 14 | 14060000095152 | 14060000095167 | 1 | 2 | BTA | PIONANR5L14BTA0222 | |
| 14060000095198 | L14/dossiers | 14 | 14060000095179 | 14060000095197 | 1 | 2 | BTA | PRJLANR5L14BTA0624 | |
| 14060000095210 | L14/dossiers | 14 | 14060000095179 | 14060000095209 | 1 | 2 | BTA | PRJLSNR5S259BTA0057 | |
| 14060000095285 | L14/dossiers | 14 | 14060000095265 | 14060000095284 | 1 | 2 | BTA | PRJLANR5L14BTA0235 | |
| 14060000095297 | L14/dossiers | 14 | 14060000095265 | 14060000095296 | 1 | 2 | BTA | PRJLSNR5S219BTA0043 | |
| 14060000095308 | L14/dossiers | 14 | 14060000095300 | 14060000095307 | 1 | 2 | BTA | PNREANR5L14BTA0854 | |
| 14060000095335 | L14/dossiers | 14 | 14060000095321 | 14060000095334 | 1 | 2 | BTA | PRJLSNR5S299BTA0014 | |
| 14060000095348 | L14/dossiers | 14 | 14060000095321 | 14060000095347 | 1 | 2 | BTA | PRJLANR5L15BTA0095 |