dossiers.dossier_parlementaire_acte_legislatif_acteur
Chemin dossierParlementaire.actesLegislatifs.acteLegislatif.initiateur.acteurs.acteur · présence : L17 2 %, L16 3 %, L15 3 %, L14 5 %
460 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 | acteur_ref | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.initiateur.acteurs.acteur.acteurRef · présence : L17 2 %, L16 3 %, L15 3 %, L14 5 % |
| 10 | mandat_ref | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.initiateur.acteurs.acteur.mandatRef · présence : L17 2 %, L16 3 %, L15 3 %, L14 5 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | _parent_recursif_id | _niveau | acteur_ref | mandat_ref |
|---|---|---|---|---|---|---|---|---|---|
| 15060000170444 | L15/dossiers | 15 | 15060000170406 | 15060000170443 | 1 | 1 | PA773441 | PM773491 | |
| 15060000171010 | L15/dossiers | 15 | 15060000170976 | 15060000171009 | 1 | 1 | PA773441 | PM773491 | |
| 15060000171460 | L15/dossiers | 15 | 15060000171426 | 15060000171459 | 1 | 1 | PA773441 | PM773491 | |
| 15060000171514 | L15/dossiers | 15 | 15060000171480 | 15060000171513 | 1 | 1 | PA773441 | PM773491 | |
| 15060000172194 | L15/dossiers | 15 | 15060000172103 | 15060000172193 | 1 | 1 | PA773441 | PM773491 | |
| 15060000172425 | L15/dossiers | 15 | 15060000172391 | 15060000172424 | 1 | 1 | PA773441 | PM773491 | |
| 15060000172673 | L15/dossiers | 15 | 15060000172640 | 15060000172672 | 1 | 1 | PA773441 | PM773491 | |
| 15060000172739 | L15/dossiers | 15 | 15060000172699 | 15060000172738 | 1 | 1 | PA773441 | PM773491 | |
| 15060000172865 | L15/dossiers | 15 | 15060000172817 | 15060000172864 | 1 | 1 | PA773441 | PM773491 | |
| 15060000173073 | L15/dossiers | 15 | 15060000173040 | 15060000173072 | 1 | 1 | PA773441 | PM773491 | |
| 15060000173182 | L15/dossiers | 15 | 15060000173150 | 15060000173181 | 1 | 1 | PA773441 | PM773491 | |
| 15060000173263 | L15/dossiers | 15 | 15060000173221 | 15060000173262 | 1 | 1 | PA773441 | PM773491 | |
| 15060000173549 | L15/dossiers | 15 | 15060000173513 | 15060000173548 | 1 | 1 | PA773441 | PM773491 | |
| 15060000174091 | L15/dossiers | 15 | 15060000174048 | 15060000174090 | 1 | 1 | PA773441 | PM773491 | |
| 15060000174685 | L15/dossiers | 15 | 15060000174643 | 15060000174684 | 1 | 1 | PA773441 | PM773491 | |
| 15060000174847 | L15/dossiers | 15 | 15060000174736 | 15060000174846 | 1 | 1 | PA773441 | PM773491 | |
| 15060000174958 | L15/dossiers | 15 | 15060000174926 | 15060000174957 | 1 | 1 | PA773441 | PM773491 | |
| 15060000175849 | L15/dossiers | 15 | 15060000175814 | 15060000175848 | 1 | 1 | PA773441 | PM773491 | |
| 15060000176071 | L15/dossiers | 15 | 15060000176036 | 15060000176070 | 1 | 1 | PA773441 | PM773491 | |
| 15060000176125 | L15/dossiers | 15 | 15060000176090 | 15060000176124 | 1 | 1 | PA773441 | PM773491 | |
| 15060000176625 | L15/dossiers | 15 | 15060000176588 | 15060000176624 | 1 | 1 | PA773441 | PM773491 | |
| 15060000176688 | L15/dossiers | 15 | 15060000176646 | 15060000176687 | 1 | 1 | PA773441 | PM773491 | |
| 15060000176963 | L15/dossiers | 15 | 15060000176832 | 15060000176962 | 1 | 1 | PA773441 | PM773491 | |
| 15060000177055 | L15/dossiers | 15 | 15060000177005 | 15060000177054 | 1 | 1 | PA773441 | PM773491 | |
| 15060000177129 | L15/dossiers | 15 | 15060000177079 | 15060000177128 | 1 | 1 | PA773441 | PM773491 | |
| 15060000177191 | L15/dossiers | 15 | 15060000177153 | 15060000177190 | 1 | 1 | PA773441 | PM773491 | |
| 15060000177473 | L15/dossiers | 15 | 15060000177424 | 15060000177472 | 1 | 1 | PA773441 | PM773491 | |
| 15060000177563 | L15/dossiers | 15 | 15060000177521 | 15060000177562 | 1 | 1 | PA773441 | PM773491 | |
| 15060000177671 | L15/dossiers | 15 | 15060000177636 | 15060000177670 | 1 | 1 | PA773441 | PM773491 | |
| 15060000177803 | L15/dossiers | 15 | 15060000177771 | 15060000177802 | 1 | 1 | PA773441 | PM773491 | |
| 15060000177878 | L15/dossiers | 15 | 15060000177844 | 15060000177877 | 1 | 1 | PA773441 | PM773491 | |
| 15060000177932 | L15/dossiers | 15 | 15060000177900 | 15060000177931 | 1 | 1 | PA773441 | PM773491 | |
| 15060000178259 | L15/dossiers | 15 | 15060000178176 | 15060000178258 | 1 | 1 | PA773441 | PM773491 | |
| 15060000178606 | L15/dossiers | 15 | 15060000178573 | 15060000178605 | 1 | 1 | PA773441 | PM773491 | |
| 15060000178963 | L15/dossiers | 15 | 15060000178921 | 15060000178962 | 1 | 1 | PA773441 | PM773491 | |
| 15060000179674 | L15/dossiers | 15 | 15060000179340 | 15060000179673 | 1 | 1 | PA773441 | PM773491 | |
| 15060000180437 | L15/dossiers | 15 | 15060000180402 | 15060000180436 | 1 | 1 | PA773441 | PM773491 | |
| 15060000180534 | L15/dossiers | 15 | 15060000180501 | 15060000180533 | 1 | 1 | PA773441 | PM773491 | |
| 15060000180606 | L15/dossiers | 15 | 15060000180573 | 15060000180605 | 1 | 1 | PA773441 | PM773491 | |
| 15060000180682 | L15/dossiers | 15 | 15060000180641 | 15060000180681 | 1 | 1 | PA773441 | PM773491 | |
| 15060000180752 | L15/dossiers | 15 | 15060000180705 | 15060000180751 | 1 | 1 | PA773441 | PM773491 | |
| 15060000181851 | L15/dossiers | 15 | 15060000181817 | 15060000181850 | 1 | 1 | PA773441 | PM773491 | |
| 15060000182139 | L15/dossiers | 15 | 15060000182080 | 15060000182138 | 1 | 1 | PA773441 | PM773491 | |
| 15060000182362 | L15/dossiers | 15 | 15060000182326 | 15060000182361 | 1 | 1 | PA773441 | PM773491 | |
| 15060000183108 | L15/dossiers | 15 | 15060000183074 | 15060000183107 | 1 | 1 | PA773441 | PM773491 | |
| 15060000183196 | L15/dossiers | 15 | 15060000183163 | 15060000183195 | 1 | 1 | PA773441 | PM773491 | |
| 15060000183288 | L15/dossiers | 15 | 15060000183252 | 15060000183287 | 1 | 1 | PA773441 | PM773491 | |
| 15060000183383 | L15/dossiers | 15 | 15060000183348 | 15060000183382 | 1 | 1 | PA773441 | PM773491 | |
| 15060000183478 | L15/dossiers | 15 | 15060000183446 | 15060000183477 | 1 | 1 | PA773441 | PM773491 | |
| 15060000184262 | L15/dossiers | 15 | 15060000184225 | 15060000184261 | 1 | 1 | PA773441 | PM773491 |