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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000149352 | L15/dossiers | 15 | 15060000149333 | 15060000149350 | 2 | 2 | TAP | PRJLANR5L15TAP0271 | |
| 15060000149364 | L15/dossiers | 15 | 15060000149333 | 15060000149363 | 1 | 2 | BTA | PRJLSNR5S319BTA0099 | |
| 15060000149403 | L15/dossiers | 15 | 15060000149374 | 15060000149402 | 1 | 2 | BTA | PRJLANR5L15BTA0270 | |
| 15060000149404 | L15/dossiers | 15 | 15060000149374 | 15060000149402 | 2 | 2 | TAP | PRJLANR5L15TAP0270 | |
| 15060000149422 | L15/dossiers | 15 | 15060000149374 | 15060000149421 | 1 | 2 | BTA | PRJLSNR5S319BTA0107 | |
| 15060000149451 | L15/dossiers | 15 | 15060000149374 | 15060000149450 | 1 | 2 | BTA | PRJLANR5L15BTA0303 | |
| 15060000149452 | L15/dossiers | 15 | 15060000149374 | 15060000149450 | 2 | 2 | TAP | PRJLANR5L15TAP0303 | |
| 15060000149462 | L15/dossiers | 15 | 15060000149374 | 15060000149461 | 1 | 2 | BTA | PRJLSNR5S319BTA0130 | |
| 15060000149472 | L15/dossiers | 15 | 15060000149374 | 15060000149471 | 1 | 2 | BTA | PRJLANR5L15BTA0318 | |
| 15060000149473 | L15/dossiers | 15 | 15060000149374 | 15060000149471 | 2 | 2 | TAP | PRJLANR5L15TAP0318 | |
| 15060000149538 | L15/dossiers | 15 | 15060000149518 | 15060000149537 | 1 | 2 | BTA | PIONANR5L15BTA0298 | |
| 15060000149569 | L15/dossiers | 15 | 15060000149546 | 15060000149568 | 1 | 2 | BTA | RIONANR5L15BTA0281 | |
| 15060000149570 | L15/dossiers | 15 | 15060000149546 | 15060000149568 | 2 | 2 | TAP | RIONANR5L15TAP0281 | |
| 15060000149614 | L15/dossiers | 15 | 15060000149574 | 15060000149613 | 1 | 2 | BTA | PRJLANR5L15BTA0301 | |
| 15060000149615 | L15/dossiers | 15 | 15060000149574 | 15060000149613 | 2 | 2 | TAP | PRJLANR5L15TAP0301 | |
| 15060000149634 | L15/dossiers | 15 | 15060000149574 | 15060000149633 | 1 | 2 | BTA | PRJLSNR5S319BTA0137 | |
| 15060000149648 | L15/dossiers | 15 | 15060000149574 | 15060000149647 | 1 | 2 | BTA | PRJLANR5L15BTA0330 | |
| 15060000149649 | L15/dossiers | 15 | 15060000149574 | 15060000149647 | 2 | 2 | TAP | PRJLANR5L15TAP0330 | |
| 15060000149653 | L15/dossiers | 15 | 15060000149574 | 15060000149652 | 1 | 2 | BTA | PRJLSNR5S319BTA0146 | |
| 15060000149708 | L15/dossiers | 15 | 15060000149689 | 15060000149707 | 1 | 2 | BTA | PIONANR5L15BTA0297 | |
| 15060000149835 | L15/dossiers | 15 | 15060000149764 | 15060000149834 | 1 | 2 | BTA | PRJLANR5L15BTA0295 | |
| 15060000149836 | L15/dossiers | 15 | 15060000149764 | 15060000149834 | 2 | 2 | TAP | PRJLANR5L15TAP0295 | |
| 15060000149848 | L15/dossiers | 15 | 15060000149764 | 15060000149847 | 1 | 2 | BTA | PRJLSNR5S319BTA0133 | |
| 15060000149869 | L15/dossiers | 15 | 15060000149764 | 15060000149868 | 1 | 2 | BTA | PRJLANR5L15BTA0323 | |
| 15060000149879 | L15/dossiers | 15 | 15060000149764 | 15060000149878 | 1 | 2 | BTA | PRJLSNR5S319BTA0141 | |
| 15060000149888 | L15/dossiers | 15 | 15060000149764 | 15060000149887 | 1 | 2 | BTA | PRJLANR5L15BTA0327 | |
| 15060000149889 | L15/dossiers | 15 | 15060000149764 | 15060000149887 | 2 | 2 | TAP | PRJLANR5L15TAP0327 | |
| 15060000149931 | L15/dossiers | 15 | 15060000149913 | 15060000149930 | 1 | 2 | BTA | PIONANR5L15BTA0378 | |
| 15060000149932 | L15/dossiers | 15 | 15060000149913 | 15060000149930 | 2 | 2 | TAP | PIONANR5L15TAP0378 | |
| 15060000149944 | L15/dossiers | 15 | 15060000149913 | 15060000149943 | 1 | 2 | BTA | PIONSNR5S339BTA0123 | |
| 15060000150015 | L15/dossiers | 15 | 15060000150002 | 15060000150014 | 1 | 2 | BTA | PIONSNR5S319BTA0108 | |
| 15060000150029 | L15/dossiers | 15 | 15060000150002 | 15060000150028 | 1 | 2 | BTA | PIONANR5L15BTA0320 | |
| 15060000150030 | L15/dossiers | 15 | 15060000150002 | 15060000150028 | 2 | 2 | TAP | PIONANR5L15TAP0320 | |
| 15060000150102 | L15/dossiers | 15 | 15060000150089 | 15060000150101 | 1 | 2 | BTA | PIONSNR5S319BTA0111 | |
| 15060000150133 | L15/dossiers | 15 | 15060000150118 | 15060000150132 | 1 | 2 | BTA | PRJLSNR5S319BTA0113 | |
| 15060000150147 | L15/dossiers | 15 | 15060000150118 | 15060000150146 | 1 | 2 | BTA | PRJLANR5L15BTA0382 | |
| 15060000150189 | L15/dossiers | 15 | 15060000150180 | 15060000150188 | 1 | 2 | BTA | RIONANR5L15BTA0282 | |
| 15060000150314 | L15/dossiers | 15 | 15060000150307 | 15060000150313 | 1 | 2 | BTA | PNREANR5L15BTA0288 | |
| 15060000150341 | L15/dossiers | 15 | 15060000150334 | 15060000150340 | 1 | 2 | BTA | RIONANR5L15BTA0283 | |
| 15060000150349 | L15/dossiers | 15 | 15060000150342 | 15060000150348 | 1 | 2 | BTA | RIONANR5L15BTA0294 | |
| 15060000150357 | L15/dossiers | 15 | 15060000150350 | 15060000150356 | 1 | 2 | BTA | RIONANR5L15BTA0292 | |
| 15060000150365 | L15/dossiers | 15 | 15060000150358 | 15060000150364 | 1 | 2 | BTA | RIONANR5L15BTA0290 | |
| 15060000150373 | L15/dossiers | 15 | 15060000150366 | 15060000150372 | 1 | 2 | BTA | RIONANR5L15BTA0287 | |
| 15060000150381 | L15/dossiers | 15 | 15060000150374 | 15060000150380 | 1 | 2 | BTA | RIONANR5L15BTA0291 | |
| 15060000150389 | L15/dossiers | 15 | 15060000150382 | 15060000150388 | 1 | 2 | BTA | PNREANR5L15BTA0285 | |
| 15060000150397 | L15/dossiers | 15 | 15060000150390 | 15060000150396 | 1 | 2 | BTA | PNREANR5L15BTA0289 | |
| 15060000150405 | L15/dossiers | 15 | 15060000150398 | 15060000150404 | 1 | 2 | BTA | RIONANR5L15BTA0293 | |
| 15060000150413 | L15/dossiers | 15 | 15060000150406 | 15060000150412 | 1 | 2 | BTA | PNREANR5L15BTA0284 | |
| 15060000150496 | L15/dossiers | 15 | 15060000150480 | 15060000150495 | 1 | 2 | BTA | RIONANR5L15BTA0306 | |
| 15060000150608 | L15/dossiers | 15 | 15060000150583 | 15060000150607 | 1 | 2 | BTA | PRJLANR5L15BTA0365 |