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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000119289 | L14/dossiers | 14 | 14060000119248 | 14060000119288 | 1 | 2 | BTA | PRJLSNR5S219BTA0151 | |
| 14060000119311 | L14/dossiers | 14 | 14060000119248 | 14060000119310 | 1 | 2 | BTA | PRJLANR5L14BTA0381 | |
| 14060000119321 | L14/dossiers | 14 | 14060000119248 | 14060000119320 | 1 | 2 | BTA | PRJLSNR5S219BTA0161 | |
| 14060000119331 | L14/dossiers | 14 | 14060000119248 | 14060000119330 | 1 | 2 | BTA | PRJLANR5L14BTA0395 | |
| 14060000119374 | L14/dossiers | 14 | 14060000119358 | 14060000119373 | 1 | 2 | BTA | PIONANR5L14BTA0517 | |
| 14060000119411 | L14/dossiers | 14 | 14060000119398 | 14060000119410 | 1 | 2 | BTA | PIONSNR5S299BTA0010 | |
| 14060000119427 | L14/dossiers | 14 | 14060000119417 | 14060000119426 | 1 | 2 | BTA | RIONANR5L14BTA0788 | |
| 14060000119474 | L14/dossiers | 14 | 14060000119457 | 14060000119473 | 1 | 2 | BTA | PRJLANR5L14BTA0858 | |
| 14060000119486 | L14/dossiers | 14 | 14060000119457 | 14060000119485 | 1 | 2 | BTA | PRJLSNR5S279BTA0037 | |
| 14060000119508 | L14/dossiers | 14 | 14060000119489 | 14060000119507 | 1 | 2 | BTA | PRJLANR5L14BTA0812 | |
| 14060000119520 | L14/dossiers | 14 | 14060000119489 | 14060000119519 | 1 | 2 | BTA | PRJLSNR5S279BTA0016 | |
| 14060000119534 | L14/dossiers | 14 | 14060000119489 | 14060000119533 | 1 | 2 | BTA | PRJLANR5L14BTA0861 | |
| 14060000119538 | L14/dossiers | 14 | 14060000119489 | 14060000119537 | 1 | 2 | BTA | PRJLSNR5S279BTA0044 | |
| 14060000119558 | L14/dossiers | 14 | 14060000119542 | 14060000119557 | 1 | 2 | BTA | PIONANR5L14BTA0690 | |
| 14060000119572 | L14/dossiers | 14 | 14060000119542 | 14060000119571 | 1 | 2 | BTA | PIONSNR5S279BTA0002 | |
| 14060000119583 | L14/dossiers | 14 | 14060000119542 | 14060000119582 | 1 | 2 | BTA | PIONANR5L14BTA0881 | |
| 14060000119593 | L14/dossiers | 14 | 14060000119542 | 14060000119592 | 1 | 2 | BTA | PIONSNR5S279BTA0077 | |
| 14060000119614 | L14/dossiers | 14 | 14060000119542 | 14060000119613 | 1 | 2 | BTA | PIONANR5L14BTA0914 | |
| 14060000119624 | L14/dossiers | 14 | 14060000119542 | 14060000119623 | 1 | 2 | BTA | PIONSNR5S279BTA0090 | |
| 14060000119634 | L14/dossiers | 14 | 14060000119542 | 14060000119633 | 1 | 2 | BTA | PIONANR5L14BTA0921 | |
| 14060000119679 | L14/dossiers | 14 | 14060000119672 | 14060000119678 | 1 | 2 | BTA | RIONANR5L14BTA0926 | |
| 14060000119708 | L14/dossiers | 14 | 14060000119694 | 14060000119707 | 1 | 2 | BTA | PRJLSNR5S259BTA0178 | |
| 14060000119722 | L14/dossiers | 14 | 14060000119694 | 14060000119721 | 1 | 2 | BTA | PRJLANR5L14BTA0814 | |
| 14060000119746 | L14/dossiers | 14 | 14060000119733 | 14060000119745 | 1 | 2 | BTA | PIONSNR5S259BTA0015 | |
| 14060000119807 | L14/dossiers | 14 | 14060000119790 | 14060000119806 | 1 | 2 | BTA | PRJLSNR5S219BTA0150 | |
| 14060000119836 | L14/dossiers | 14 | 14060000119790 | 14060000119835 | 1 | 2 | BTA | PRJLANR5L14BTA0390 | |
| 14060000119850 | L14/dossiers | 14 | 14060000119790 | 14060000119849 | 1 | 2 | BTA | PRJLSNR5S239BTA0013 | |
| 14060000119868 | L14/dossiers | 14 | 14060000119790 | 14060000119867 | 1 | 2 | BTA | PRJLANR5L14BTA0429 | |
| 14060000119897 | L14/dossiers | 14 | 14060000119790 | 14060000119896 | 1 | 2 | BTA | PRJLANR5L14BTA0448 | |
| 14060000119907 | L14/dossiers | 14 | 14060000119790 | 14060000119906 | 1 | 2 | BTA | PRJLSNR5S239BTA0035 | |
| 14060000119916 | L14/dossiers | 14 | 14060000119790 | 14060000119915 | 1 | 2 | BTA | PRJLANR5L14BTA0455 | |
| 14060000119941 | L14/dossiers | 14 | 14060000119924 | 14060000119940 | 1 | 2 | BTA | PRJLANR5L14BTA0331 | |
| 14060000119953 | L14/dossiers | 14 | 14060000119924 | 14060000119952 | 1 | 2 | BTA | PRJLSNR5S219BTA0118 | |
| 14060000120019 | L14/dossiers | 14 | 14060000120005 | 14060000120018 | 1 | 2 | BTA | PIONSNR5S239BTA0058 | |
| 14060000120052 | L14/dossiers | 14 | 14060000120033 | 14060000120051 | 1 | 2 | BTA | PRJLANR5L14BTA0018 | |
| 14060000120065 | L14/dossiers | 14 | 14060000120033 | 14060000120064 | 1 | 2 | BTA | PRJLSNR5S199BTA0009 | |
| 14060000120194 | L14/dossiers | 14 | 14060000120161 | 14060000120193 | 1 | 2 | BTA | PRJLANR5L14BTA0163 | |
| 14060000120213 | L14/dossiers | 14 | 14060000120161 | 14060000120212 | 1 | 2 | BTA | PRJLSNR5S199BTA0198 | |
| 14060000120240 | L14/dossiers | 14 | 14060000120161 | 14060000120239 | 1 | 2 | BTA | PRJLANR5L14BTA0210 | |
| 14060000120250 | L14/dossiers | 14 | 14060000120161 | 14060000120249 | 1 | 2 | BTA | PRJLSNR5S219BTA0006 | |
| 14060000120261 | L14/dossiers | 14 | 14060000120161 | 14060000120260 | 1 | 2 | BTA | PRJLANR5L14BTA0237 | |
| 14060000120335 | L14/dossiers | 14 | 14060000120322 | 14060000120334 | 1 | 2 | BTA | PIONSNR5S219BTA0047 | |
| 14060000120351 | L14/dossiers | 14 | 14060000120322 | 14060000120350 | 1 | 2 | BTA | PIONANR5L14BTA0336 | |
| 14060000120361 | L14/dossiers | 14 | 14060000120322 | 14060000120360 | 1 | 2 | BTA | PIONSNR5S219BTA0137 | |
| 14060000120395 | L14/dossiers | 14 | 14060000120381 | 14060000120394 | 1 | 2 | BTA | PIONSNR5S199BTA0077 | |
| 14060000120411 | L14/dossiers | 14 | 14060000120381 | 14060000120410 | 1 | 2 | BTA | PIONANR5L14BTA0213 | |
| 14060000120421 | L14/dossiers | 14 | 14060000120381 | 14060000120420 | 1 | 2 | BTA | PIONSNR5S219BTA0003 | |
| 14060000120539 | L14/dossiers | 14 | 14060000120509 | 14060000120538 | 1 | 2 | BTA | PRJLSNR5S219BTA0029 | |
| 14060000120602 | L14/dossiers | 14 | 14060000120509 | 14060000120601 | 1 | 2 | BTA | PRJLANR5L14BTA0338 | |
| 14060000120612 | L14/dossiers | 14 | 14060000120509 | 14060000120611 | 1 | 2 | BTA | PRJLSNR5S219BTA0130 |