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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000150620 | L15/dossiers | 15 | 15060000150583 | 15060000150619 | 1 | 2 | BTA | PRJLSNR5S339BTA0071 | |
| 15060000150656 | L15/dossiers | 15 | 15060000150635 | 15060000150655 | 1 | 2 | BTA | PRJLSNR5S319BTA0122 | |
| 15060000150671 | L15/dossiers | 15 | 15060000150635 | 15060000150670 | 1 | 2 | BTA | PRJLANR5L15BTA0319 | |
| 15060000150672 | L15/dossiers | 15 | 15060000150635 | 15060000150670 | 2 | 2 | TAP | PRJLANR5L15TAP0319 | |
| 15060000150686 | L15/dossiers | 15 | 15060000150635 | 15060000150685 | 1 | 2 | BTA | PRJLSNR5S319BTA0143 | |
| 15060000150689 | L15/dossiers | 15 | 15060000150635 | 15060000150688 | 1 | 2 | BTA | PRJLANR5L15BTA0329 | |
| 15060000150690 | L15/dossiers | 15 | 15060000150635 | 15060000150688 | 2 | 2 | TAP | PRJLANR5L15TAP0329 | |
| 15060000150830 | L15/dossiers | 15 | 15060000150814 | 15060000150829 | 1 | 2 | BTA | PRJLSNR5S339BTA0022 | |
| 15060000150847 | L15/dossiers | 15 | 15060000150814 | 15060000150846 | 1 | 2 | BTA | PRJLANR5L15BTA0401 | |
| 15060000150848 | L15/dossiers | 15 | 15060000150814 | 15060000150846 | 2 | 2 | TAP | PRJLANR5L15TAP0401 | |
| 15060000150873 | L15/dossiers | 15 | 15060000150858 | 15060000150872 | 1 | 2 | BTA | PRJLSNR5S319BTA0124 | |
| 15060000150888 | L15/dossiers | 15 | 15060000150858 | 15060000150887 | 1 | 2 | BTA | PRJLANR5L15BTA0340 | |
| 15060000150910 | L15/dossiers | 15 | 15060000150895 | 15060000150909 | 1 | 2 | BTA | PIONANR5L15BTA0317 | |
| 15060000150911 | L15/dossiers | 15 | 15060000150895 | 15060000150909 | 2 | 2 | TAP | PIONANR5L15TAP0317 | |
| 15060000150923 | L15/dossiers | 15 | 15060000150895 | 15060000150922 | 1 | 2 | BTA | PIONSNR5S319BTA0138 | |
| 15060000150992 | L15/dossiers | 15 | 15060000150966 | 15060000150991 | 1 | 2 | BTA | PRJLANR5L15BTA0324 | |
| 15060000151313 | L15/dossiers | 15 | 15060000151041 | 15060000151312 | 1 | 2 | BTA | PRJLANR5L15BTA0348 | |
| 15060000151314 | L15/dossiers | 15 | 15060000151041 | 15060000151312 | 2 | 2 | TAP | PRJLANR5L15TAP0348 | |
| 15060000151373 | L15/dossiers | 15 | 15060000151041 | 15060000151372 | 1 | 2 | BTA | PRJLSNR5S339BTA0032 | |
| 15060000151396 | L15/dossiers | 15 | 15060000151041 | 15060000151395 | 1 | 2 | BTA | PRJLANR5L15BTA0373 | |
| 15060000151397 | L15/dossiers | 15 | 15060000151041 | 15060000151395 | 2 | 2 | TAP | PRJLANR5L15TAP0373 | |
| 15060000151406 | L15/dossiers | 15 | 15060000151041 | 15060000151405 | 1 | 2 | BTA | PRJLSNR5S339BTA0039 | |
| 15060000151415 | L15/dossiers | 15 | 15060000151041 | 15060000151414 | 1 | 2 | BTA | PRJLANR5L15BTA0374 | |
| 15060000151416 | L15/dossiers | 15 | 15060000151041 | 15060000151414 | 2 | 2 | TAP | PRJLANR5L15TAP0374 | |
| 15060000151757 | L15/dossiers | 15 | 15060000151743 | 15060000151756 | 1 | 2 | BTA | PIONANR5L15BTA0354 | |
| 15060000151758 | L15/dossiers | 15 | 15060000151743 | 15060000151756 | 2 | 2 | TAP | PIONANR5L15TAP0354 | |
| 15060000151769 | L15/dossiers | 15 | 15060000151743 | 15060000151768 | 1 | 2 | BTA | PIONSNR5S339BTA0043 | |
| 15060000151798 | L15/dossiers | 15 | 15060000151782 | 15060000151797 | 1 | 2 | BTA | PIONANR5L15BTA0367 | |
| 15060000151799 | L15/dossiers | 15 | 15060000151782 | 15060000151797 | 2 | 2 | TAP | PIONANR5L15TAP0367 | |
| 15060000151919 | L15/dossiers | 15 | 15060000151902 | 15060000151918 | 1 | 2 | BTA | PIONANR5L15BTA0392 | |
| 15060000151920 | L15/dossiers | 15 | 15060000151902 | 15060000151918 | 2 | 2 | TAP | PIONANR5L15TAP0392 | |
| 15060000151931 | L15/dossiers | 15 | 15060000151902 | 15060000151930 | 1 | 2 | BTA | PIONSNR5S359BTA0047 | |
| 15060000151976 | L15/dossiers | 15 | 15060000151952 | 15060000151975 | 1 | 2 | BTA | PRJLSNR5S319BTA0148 | |
| 15060000152022 | L15/dossiers | 15 | 15060000151952 | 15060000152021 | 1 | 2 | BTA | PRJLANR5L15BTA0376 | |
| 15060000152023 | L15/dossiers | 15 | 15060000151952 | 15060000152021 | 2 | 2 | TAP | PRJLANR5L15TAP0376 | |
| 15060000152038 | L15/dossiers | 15 | 15060000151952 | 15060000152037 | 1 | 2 | BTA | PRJLANR5L15BTA0385 | |
| 15060000152039 | L15/dossiers | 15 | 15060000151952 | 15060000152037 | 2 | 2 | TAP | PRJLANR5L15TAP0385 | |
| 15060000152042 | L15/dossiers | 15 | 15060000151952 | 15060000152041 | 1 | 2 | BTA | PRJLSNR5S339BTA0054 | |
| 15060000152166 | L15/dossiers | 15 | 15060000152151 | 15060000152165 | 1 | 2 | BTA | PRJLSNR5S339BTA0007 | |
| 15060000152185 | L15/dossiers | 15 | 15060000152151 | 15060000152184 | 1 | 2 | BTA | PRJLANR5L15BTA0350 | |
| 15060000152212 | L15/dossiers | 15 | 15060000152188 | 15060000152211 | 1 | 2 | BTA | PRJLSNR5S339BTA0008 | |
| 15060000152243 | L15/dossiers | 15 | 15060000152188 | 15060000152242 | 1 | 2 | BTA | PRJLANR5L15BTA0352 | |
| 15060000152244 | L15/dossiers | 15 | 15060000152188 | 15060000152242 | 2 | 2 | TAP | PRJLANR5L15TAP0352 | |
| 15060000152259 | L15/dossiers | 15 | 15060000152188 | 15060000152258 | 1 | 2 | BTA | PRJLSNR5S339BTA0041 | |
| 15060000152263 | L15/dossiers | 15 | 15060000152188 | 15060000152262 | 1 | 2 | BTA | PRJLANR5L15BTA0375 | |
| 15060000152264 | L15/dossiers | 15 | 15060000152188 | 15060000152262 | 2 | 2 | TAP | PRJLANR5L15TAP0375 | |
| 15060000152420 | L15/dossiers | 15 | 15060000152330 | 15060000152419 | 1 | 2 | BTA | PRJLANR5L15BTA0343 | |
| 15060000152439 | L15/dossiers | 15 | 15060000152330 | 15060000152438 | 1 | 2 | BTA | PRJLSNR5S339BTA0055 | |
| 15060000152470 | L15/dossiers | 15 | 15060000152330 | 15060000152469 | 1 | 2 | BTA | PRJLANR5L15BTA0474 | |
| 15060000152471 | L15/dossiers | 15 | 15060000152330 | 15060000152469 | 2 | 2 | TAP | PRJLANR5L15TAP0474 |