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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000143314 | L15/dossiers | 15 | 15060000143240 | 15060000143313 | 1 | 2 | BTA | PIONANR5L15BTA0273 | |
| 15060000143315 | L15/dossiers | 15 | 15060000143240 | 15060000143313 | 2 | 2 | TAP | PIONANR5L15TAP0273 | |
| 15060000143325 | L15/dossiers | 15 | 15060000143240 | 15060000143324 | 1 | 2 | BTA | PIONSNR5S319BTA0115 | |
| 15060000143336 | L15/dossiers | 15 | 15060000143240 | 15060000143335 | 1 | 2 | BTA | PIONANR5L15BTA0311 | |
| 15060000143337 | L15/dossiers | 15 | 15060000143240 | 15060000143335 | 2 | 2 | TAP | PIONANR5L15TAP0311 | |
| 15060000143357 | L15/dossiers | 15 | 15060000143342 | 15060000143356 | 1 | 2 | BTA | PIONANR5L15BTA0248 | |
| 15060000143358 | L15/dossiers | 15 | 15060000143342 | 15060000143356 | 2 | 2 | TAP | PIONANR5L15TAP0248 | |
| 15060000143370 | L15/dossiers | 15 | 15060000143342 | 15060000143369 | 1 | 2 | BTA | PIONSNR5S319BTA0128 | |
| 15060000143382 | L15/dossiers | 15 | 15060000143342 | 15060000143381 | 1 | 2 | BTA | PIONANR5L15BTA0356 | |
| 15060000143383 | L15/dossiers | 15 | 15060000143342 | 15060000143381 | 2 | 2 | TAP | PIONANR5L15TAP0356 | |
| 15060000143392 | L15/dossiers | 15 | 15060000143342 | 15060000143391 | 1 | 2 | BTA | PIONSNR5S359BTA0109 | |
| 15060000143406 | L15/dossiers | 15 | 15060000143342 | 15060000143405 | 1 | 2 | BTA | PIONANR5L15BTA0637 | |
| 15060000143407 | L15/dossiers | 15 | 15060000143342 | 15060000143405 | 2 | 2 | TAP | PIONANR5L15TAP0637 | |
| 15060000143426 | L15/dossiers | 15 | 15060000143410 | 15060000143425 | 1 | 2 | BTA | PIONANR5L15BTA0198 | |
| 15060000143427 | L15/dossiers | 15 | 15060000143410 | 15060000143425 | 2 | 2 | TAP | PIONANR5L15TAP0198 | |
| 15060000143439 | L15/dossiers | 15 | 15060000143410 | 15060000143438 | 1 | 2 | BTA | PIONSNR5S319BTA0073 | |
| 15060000143451 | L15/dossiers | 15 | 15060000143410 | 15060000143450 | 1 | 2 | BTA | PIONANR5L15BTA0264 | |
| 15060000143452 | L15/dossiers | 15 | 15060000143410 | 15060000143450 | 2 | 2 | TAP | PIONANR5L15TAP0264 | |
| 15060000143470 | L15/dossiers | 15 | 15060000143455 | 15060000143469 | 1 | 2 | BTA | PIONANR5L15BTA0199 | |
| 15060000143471 | L15/dossiers | 15 | 15060000143455 | 15060000143469 | 2 | 2 | TAP | PIONANR5L15TAP0199 | |
| 15060000143483 | L15/dossiers | 15 | 15060000143455 | 15060000143482 | 1 | 2 | BTA | PIONSNR5S319BTA0123 | |
| 15060000143523 | L15/dossiers | 15 | 15060000143507 | 15060000143522 | 1 | 2 | BTA | PIONANR5L15BTA0204 | |
| 15060000143524 | L15/dossiers | 15 | 15060000143507 | 15060000143522 | 2 | 2 | TAP | PIONANR5L15TAP0204 | |
| 15060000143536 | L15/dossiers | 15 | 15060000143507 | 15060000143535 | 1 | 2 | BTA | PIONSNR5S319BTA0053 | |
| 15060000143585 | L15/dossiers | 15 | 15060000143568 | 15060000143584 | 1 | 2 | BTA | PIONANR5L15BTA0197 | |
| 15060000143586 | L15/dossiers | 15 | 15060000143568 | 15060000143584 | 2 | 2 | TAP | PIONANR5L15TAP0197 | |
| 15060000143598 | L15/dossiers | 15 | 15060000143568 | 15060000143597 | 1 | 2 | BTA | PIONSNR5S319BTA0069 | |
| 15060000143641 | L15/dossiers | 15 | 15060000143627 | 15060000143640 | 1 | 2 | BTA | PIONSNR5S319BTA0021 | |
| 15060000143666 | L15/dossiers | 15 | 15060000143627 | 15060000143665 | 1 | 2 | BTA | PIONANR5L15BTA0243 | |
| 15060000143667 | L15/dossiers | 15 | 15060000143627 | 15060000143665 | 2 | 2 | TAP | PIONANR5L15TAP0243 | |
| 15060000143681 | L15/dossiers | 15 | 15060000143627 | 15060000143680 | 1 | 2 | BTA | PIONSNR5S319BTA0116 | |
| 15060000143685 | L15/dossiers | 15 | 15060000143627 | 15060000143684 | 1 | 2 | BTA | PIONANR5L15BTA0312 | |
| 15060000143686 | L15/dossiers | 15 | 15060000143627 | 15060000143684 | 2 | 2 | TAP | PIONANR5L15TAP0312 | |
| 15060000143730 | L15/dossiers | 15 | 15060000143717 | 15060000143729 | 1 | 2 | BTA | PIONSNR5S319BTA0026 | |
| 15060000143749 | L15/dossiers | 15 | 15060000143736 | 15060000143748 | 1 | 2 | BTA | PIONSNR5S319BTA0027 | |
| 15060000143762 | L15/dossiers | 15 | 15060000143755 | 15060000143761 | 1 | 2 | BTA | PNREANR5L15BTA0203 | |
| 15060000143788 | L15/dossiers | 15 | 15060000143775 | 15060000143787 | 1 | 2 | BTA | PIONSNR5S319BTA0028 | |
| 15060000143882 | L15/dossiers | 15 | 15060000143868 | 15060000143881 | 1 | 2 | BTA | PRJLSNR5S319BTA0040 | |
| 15060000143902 | L15/dossiers | 15 | 15060000143868 | 15060000143901 | 1 | 2 | BTA | PRJLANR5L15BTA0230 | |
| 15060000143924 | L15/dossiers | 15 | 15060000143905 | 15060000143923 | 1 | 2 | BTA | PRJLANR5L15BTA0212 | |
| 15060000143936 | L15/dossiers | 15 | 15060000143905 | 15060000143935 | 1 | 2 | BTA | PRJLSNR5S319BTA0064 | |
| 15060000144061 | L15/dossiers | 15 | 15060000144043 | 15060000144060 | 1 | 2 | BTA | PIONANR5L15BTA0209 | |
| 15060000144073 | L15/dossiers | 15 | 15060000144043 | 15060000144072 | 1 | 2 | BTA | PIONSNR5S319BTA0041 | |
| 15060000144151 | L15/dossiers | 15 | 15060000144132 | 15060000144150 | 1 | 2 | BTA | PRJLANR5L15BTA0188 | |
| 15060000144152 | L15/dossiers | 15 | 15060000144132 | 15060000144150 | 2 | 2 | TAP | PRJLANR5L15TAP0188 | |
| 15060000144164 | L15/dossiers | 15 | 15060000144132 | 15060000144163 | 1 | 2 | BTA | PRJLSNR5S319BTA0024 | |
| 15060000144185 | L15/dossiers | 15 | 15060000144132 | 15060000144184 | 1 | 2 | BTA | PRJLANR5L15BTA0193 | |
| 15060000144186 | L15/dossiers | 15 | 15060000144132 | 15060000144184 | 2 | 2 | TAP | PRJLANR5L15TAP0193 | |
| 15060000144196 | L15/dossiers | 15 | 15060000144132 | 15060000144195 | 1 | 2 | BTA | PRJLSNR5S319BTA0029 | |
| 15060000144206 | L15/dossiers | 15 | 15060000144132 | 15060000144205 | 1 | 2 | BTA | PRJLANR5L15BTA0195 |