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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000154115 | L15/dossiers | 15 | 15060000154072 | 15060000154114 | 1 | 2 | BTA | PIONSNR5S379BTA0112 | |
| 15060000154131 | L15/dossiers | 15 | 15060000154118 | 15060000154130 | 1 | 2 | BTA | PIONSNR5S339BTA0019 | |
| 15060000154174 | L15/dossiers | 15 | 15060000154159 | 15060000154173 | 1 | 2 | BTA | PIONANR5L15BTA0357 | |
| 15060000154175 | L15/dossiers | 15 | 15060000154159 | 15060000154173 | 2 | 2 | TAP | PIONANR5L15TAP0357 | |
| 15060000154250 | L15/dossiers | 15 | 15060000154237 | 15060000154249 | 1 | 2 | BTA | PIONSNR5S339BTA0093 | |
| 15060000154314 | L15/dossiers | 15 | 15060000154298 | 15060000154313 | 1 | 2 | BTA | RIONANR5L15BTA0359 | |
| 15060000154444 | L15/dossiers | 15 | 15060000154428 | 15060000154443 | 1 | 2 | BTA | PIONANR5L15BTA0368 | |
| 15060000154462 | L15/dossiers | 15 | 15060000154445 | 15060000154461 | 1 | 2 | BTA | PIONANR5L15BTA0369 | |
| 15060000154479 | L15/dossiers | 15 | 15060000154463 | 15060000154478 | 1 | 2 | BTA | PIONANR5L15BTA0370 | |
| 15060000154480 | L15/dossiers | 15 | 15060000154463 | 15060000154478 | 2 | 2 | TAP | PIONANR5L15TAP0370 | |
| 15060000154502 | L15/dossiers | 15 | 15060000154486 | 15060000154501 | 1 | 2 | BTA | PIONANR5L15BTA0371 | |
| 15060000154517 | L15/dossiers | 15 | 15060000154503 | 15060000154516 | 1 | 2 | BTA | PIONANR5L15BTA0366 | |
| 15060000154567 | L15/dossiers | 15 | 15060000154553 | 15060000154566 | 1 | 2 | BTA | RIONANR5L15BTA0346 | |
| 15060000154590 | L15/dossiers | 15 | 15060000154575 | 15060000154589 | 1 | 2 | BTA | PIONSNR5S339BTA0028 | |
| 15060000154605 | L15/dossiers | 15 | 15060000154575 | 15060000154604 | 1 | 2 | BTA | PIONANR5L15BTA0522 | |
| 15060000154643 | L15/dossiers | 15 | 15060000154630 | 15060000154642 | 1 | 2 | BTA | PIONSNR5S339BTA0029 | |
| 15060000154686 | L15/dossiers | 15 | 15060000154671 | 15060000154685 | 1 | 2 | BTA | PIONANR5L15BTA0407 | |
| 15060000154687 | L15/dossiers | 15 | 15060000154671 | 15060000154685 | 2 | 2 | TAP | PIONANR5L15TAP0407 | |
| 15060000154696 | L15/dossiers | 15 | 15060000154671 | 15060000154695 | 1 | 2 | BTA | PIONSNR5S339BTA0108 | |
| 15060000154821 | L15/dossiers | 15 | 15060000154797 | 15060000154820 | 1 | 2 | BTA | PRJLANR5L15BTA0534 | |
| 15060000154822 | L15/dossiers | 15 | 15060000154797 | 15060000154820 | 2 | 2 | TAP | PRJLANR5L15TAP0534 | |
| 15060000154834 | L15/dossiers | 15 | 15060000154797 | 15060000154833 | 1 | 2 | BTA | PRJLSNR5S359BTA0050 | |
| 15060000154848 | L15/dossiers | 15 | 15060000154797 | 15060000154847 | 1 | 2 | BTA | PRJLSNR5S359BTA0062 | |
| 15060000154854 | L15/dossiers | 15 | 15060000154797 | 15060000154853 | 1 | 2 | BTA | PRJLANR5L15BTA0566 | |
| 15060000154855 | L15/dossiers | 15 | 15060000154797 | 15060000154853 | 2 | 2 | TAP | PRJLANR5L15TAP0566 | |
| 15060000154943 | L15/dossiers | 15 | 15060000154935 | 15060000154942 | 1 | 2 | BTA | RIONANR5L15BTA0389 | |
| 15060000154986 | L15/dossiers | 15 | 15060000154979 | 15060000154985 | 1 | 2 | BTA | RIONANR5L15BTA0377 | |
| 15060000155004 | L15/dossiers | 15 | 15060000154987 | 15060000155003 | 1 | 2 | BTA | PRJLANR5L15BTA0347 | |
| 15060000155005 | L15/dossiers | 15 | 15060000154987 | 15060000155003 | 2 | 2 | TAP | PRJLANR5L15TAP0347 | |
| 15060000155016 | L15/dossiers | 15 | 15060000154987 | 15060000155015 | 1 | 2 | BTA | PRJLSNR5S339BTA0027 | |
| 15060000155031 | L15/dossiers | 15 | 15060000154987 | 15060000155030 | 1 | 2 | BTA | PRJLANR5L15BTA0351 | |
| 15060000155032 | L15/dossiers | 15 | 15060000154987 | 15060000155030 | 2 | 2 | TAP | PRJLANR5L15TAP0351 | |
| 15060000155036 | L15/dossiers | 15 | 15060000154987 | 15060000155035 | 1 | 2 | BTA | PRJLSNR5S339BTA0030 | |
| 15060000155083 | L15/dossiers | 15 | 15060000155075 | 15060000155082 | 1 | 2 | BTA | RIONANR5L15BTA0361 | |
| 15060000155193 | L15/dossiers | 15 | 15060000155179 | 15060000155192 | 1 | 2 | BTA | PRJLSNR5S339BTA0035 | |
| 15060000155207 | L15/dossiers | 15 | 15060000155179 | 15060000155206 | 1 | 2 | BTA | PRJLANR5L15BTA0387 | |
| 15060000155208 | L15/dossiers | 15 | 15060000155179 | 15060000155206 | 2 | 2 | TAP | PRJLANR5L15TAP0387 | |
| 15060000155222 | L15/dossiers | 15 | 15060000155179 | 15060000155221 | 1 | 2 | BTA | PRJLANR5L15BTA0400 | |
| 15060000155223 | L15/dossiers | 15 | 15060000155179 | 15060000155221 | 2 | 2 | TAP | PRJLANR5L15TAP0400 | |
| 15060000155226 | L15/dossiers | 15 | 15060000155179 | 15060000155225 | 1 | 2 | BTA | RAPPSNR5S339BTA0066 | |
| 15060000155247 | L15/dossiers | 15 | 15060000155233 | 15060000155246 | 1 | 2 | BTA | PRJLSNR5S339BTA0034 | |
| 15060000155261 | L15/dossiers | 15 | 15060000155233 | 15060000155260 | 1 | 2 | BTA | PRJLANR5L15BTA0386 | |
| 15060000155262 | L15/dossiers | 15 | 15060000155233 | 15060000155260 | 2 | 2 | TAP | PRJLANR5L15TAP0386 | |
| 15060000155276 | L15/dossiers | 15 | 15060000155233 | 15060000155275 | 1 | 2 | BTA | PRJLANR5L15BTA0399 | |
| 15060000155277 | L15/dossiers | 15 | 15060000155233 | 15060000155275 | 2 | 2 | TAP | PRJLANR5L15TAP0399 | |
| 15060000155280 | L15/dossiers | 15 | 15060000155233 | 15060000155279 | 1 | 2 | BTA | PRJLSNR5S339BTA0065 | |
| 15060000155346 | L15/dossiers | 15 | 15060000155326 | 15060000155345 | 1 | 2 | BTA | PRJLANR5L15BTA0424 | |
| 15060000155358 | L15/dossiers | 15 | 15060000155326 | 15060000155357 | 1 | 2 | BTA | PRJLSNR5S359BTA0016 | |
| 15060000155380 | L15/dossiers | 15 | 15060000155361 | 15060000155379 | 1 | 2 | BTA | PIONSNR5S339BTA0033 | |
| 15060000155395 | L15/dossiers | 15 | 15060000155361 | 15060000155394 | 1 | 2 | BTA | PIONANR5L15BTA0585 |