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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000148133 | L15/dossiers | 15 | 15060000148086 | 15060000148132 | 1 | 1 | PA345619 | PM725692 | |
| 15060000148444 | L15/dossiers | 15 | 15060000148409 | 15060000148443 | 1 | 1 | PA345619 | PM725692 | |
| 15060000148543 | L15/dossiers | 15 | 15060000148481 | 15060000148542 | 1 | 1 | PA345619 | PM725692 | |
| 15060000149121 | L15/dossiers | 15 | 15060000149084 | 15060000149120 | 1 | 1 | PA345619 | PM725692 | |
| 15060000149425 | L15/dossiers | 15 | 15060000149374 | 15060000149424 | 1 | 1 | PA345619 | PM725692 | |
| 15060000149638 | L15/dossiers | 15 | 15060000149574 | 15060000149637 | 1 | 1 | PA345619 | PM725692 | |
| 15060000149851 | L15/dossiers | 15 | 15060000149764 | 15060000149850 | 1 | 1 | PA345619 | PM725692 | |
| 15060000150676 | L15/dossiers | 15 | 15060000150635 | 15060000150675 | 1 | 1 | PA345619 | PM725692 | |
| 15060000151376 | L15/dossiers | 15 | 15060000151041 | 15060000151375 | 1 | 1 | PA345619 | PM725692 | |
| 15060000152027 | L15/dossiers | 15 | 15060000151952 | 15060000152026 | 1 | 1 | PA345619 | PM725692 | |
| 15060000152248 | L15/dossiers | 15 | 15060000152188 | 15060000152247 | 1 | 1 | PA345619 | PM725692 | |
| 15060000152489 | L15/dossiers | 15 | 15060000152330 | 15060000152488 | 1 | 1 | PA773441 | PM773491 | |
| 15060000152802 | L15/dossiers | 15 | 15060000152764 | 15060000152801 | 1 | 1 | PA345619 | PM725692 | |
| 15060000153805 | L15/dossiers | 15 | 15060000153738 | 15060000153804 | 1 | 1 | PA345619 | PM725692 | |
| 15060000154838 | L15/dossiers | 15 | 15060000154797 | 15060000154837 | 1 | 1 | PA773441 | PM773491 | |
| 15060000155020 | L15/dossiers | 15 | 15060000154987 | 15060000155019 | 1 | 1 | PA345619 | PM725692 | |
| 15060000155212 | L15/dossiers | 15 | 15060000155179 | 15060000155211 | 1 | 1 | PA345619 | PM725692 | |
| 15060000155266 | L15/dossiers | 15 | 15060000155233 | 15060000155265 | 1 | 1 | PA345619 | PM725692 | |
| 15060000158744 | L15/dossiers | 15 | 15060000158707 | 15060000158743 | 1 | 1 | PA345619 | PM725692 | |
| 15060000159991 | L15/dossiers | 15 | 15060000159958 | 15060000159990 | 1 | 1 | PA773441 | PM773491 | |
| 15060000160668 | L15/dossiers | 15 | 15060000160623 | 15060000160667 | 1 | 1 | PA773441 | PM773491 | |
| 15060000161030 | L15/dossiers | 15 | 15060000160984 | 15060000161029 | 1 | 1 | PA773441 | PM773491 | |
| 15060000161373 | L15/dossiers | 15 | 15060000161328 | 15060000161372 | 1 | 1 | PA773441 | PM773491 | |
| 15060000161856 | L15/dossiers | 15 | 15060000161821 | 15060000161855 | 1 | 1 | PA773441 | PM773491 | |
| 15060000162081 | L15/dossiers | 15 | 15060000162047 | 15060000162080 | 1 | 1 | PA345619 | PM725692 | |
| 15060000162708 | L15/dossiers | 15 | 15060000162672 | 15060000162707 | 1 | 1 | PA345619 | PM725692 | |
| 15060000163385 | L15/dossiers | 15 | 15060000163302 | 15060000163384 | 1 | 1 | PA773441 | PM773491 | |
| 15060000163465 | L15/dossiers | 15 | 15060000163428 | 15060000163464 | 1 | 1 | PA345619 | PM725692 | |
| 15060000163699 | L15/dossiers | 15 | 15060000163662 | 15060000163698 | 1 | 1 | PA345619 | PM725692 | |
| 15060000163807 | L15/dossiers | 15 | 15060000163750 | 15060000163806 | 1 | 1 | PA773441 | PM773491 | |
| 15060000164189 | L15/dossiers | 15 | 15060000164157 | 15060000164188 | 1 | 1 | PA345619 | PM725692 | |
| 15060000164723 | L15/dossiers | 15 | 15060000164685 | 15060000164722 | 1 | 1 | PA345619 | PM725692 | |
| 15060000164805 | L15/dossiers | 15 | 15060000164768 | 15060000164804 | 1 | 1 | PA345619 | PM725692 | |
| 15060000164881 | L15/dossiers | 15 | 15060000164846 | 15060000164880 | 1 | 1 | PA345619 | PM725692 | |
| 15060000165440 | L15/dossiers | 15 | 15060000165391 | 15060000165439 | 1 | 1 | PA773441 | PM773491 | |
| 15060000165491 | L15/dossiers | 15 | 15060000165458 | 15060000165490 | 1 | 1 | PA345619 | PM725692 | |
| 15060000165652 | L15/dossiers | 15 | 15060000165616 | 15060000165651 | 1 | 1 | PA773441 | PM773491 | |
| 15060000165796 | L15/dossiers | 15 | 15060000165755 | 15060000165795 | 1 | 1 | PA773441 | PM773491 | |
| 15060000166170 | L15/dossiers | 15 | 15060000166133 | 15060000166169 | 1 | 1 | PA773441 | PM773491 | |
| 15060000166282 | L15/dossiers | 15 | 15060000166243 | 15060000166281 | 1 | 1 | PA773441 | PM773491 | |
| 15060000166589 | L15/dossiers | 15 | 15060000166549 | 15060000166588 | 1 | 1 | PA773441 | PM773491 | |
| 15060000166886 | L15/dossiers | 15 | 15060000166843 | 15060000166885 | 1 | 1 | PA773441 | PM773491 | |
| 15060000167106 | L15/dossiers | 15 | 15060000167051 | 15060000167105 | 1 | 1 | PA773441 | PM773491 | |
| 15060000167779 | L15/dossiers | 15 | 15060000167441 | 15060000167778 | 1 | 1 | PA773441 | PM773491 | |
| 15060000168459 | L15/dossiers | 15 | 15060000168398 | 15060000168458 | 1 | 1 | PA773441 | PM773491 | |
| 15060000168718 | L15/dossiers | 15 | 15060000168673 | 15060000168717 | 1 | 1 | PA773441 | PM773491 | |
| 15060000169679 | L15/dossiers | 15 | 15060000169614 | 15060000169678 | 1 | 1 | PA773441 | PM773491 | |
| 15060000169797 | L15/dossiers | 15 | 15060000169762 | 15060000169796 | 1 | 1 | PA773441 | PM773491 | |
| 15060000170231 | L15/dossiers | 15 | 15060000170177 | 15060000170230 | 1 | 1 | PA773441 | PM773491 | |
| 15060000170358 | L15/dossiers | 15 | 15060000170325 | 15060000170357 | 1 | 1 | PA773441 | PM773491 |