dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 249 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 | acteur_ref | VARCHAR | dossierParlementaire.initiateur.acteurs.acteur.acteurRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 % |
| 8 | mandat_ref | VARCHAR | dossierParlementaire.initiateur.acteurs.acteur.mandatRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_ref | mandat_ref |
|---|---|---|---|---|---|---|---|
| 16060000123531 | L16/dossiers | 16 | 16060000123521 | 16060000123521 | 10 | PA775252 | PM775558 |
| 16060000123532 | L16/dossiers | 16 | 16060000123521 | 16060000123521 | 11 | PA827968 | PM828750 |
| 16060000123533 | L16/dossiers | 16 | 16060000123521 | 16060000123521 | 12 | PA827978 | PM828730 |
| 16060000123534 | L16/dossiers | 16 | 16060000123521 | 16060000123521 | 13 | PA775272 | PM775562 |
| 16060000123535 | L16/dossiers | 16 | 16060000123521 | 16060000123521 | 14 | PA775282 | PM775584 |
| 16060000123536 | L16/dossiers | 16 | 16060000123521 | 16060000123521 | 15 | PA828000 | PM828850 |
| 16060000123537 | L16/dossiers | 16 | 16060000123521 | 16060000123521 | 16 | PA785857 | PM785867 |
| 16060000123544 | L16/dossiers | 16 | 16060000123543 | 16060000123543 | 1 | PA717379 | PM797265 |
| 16060000123552 | L16/dossiers | 16 | 16060000123551 | 16060000123551 | 1 | PA341381 | PM775747 |
| 16060000123559 | L16/dossiers | 16 | 16060000123558 | 16060000123558 | 1 | PA793736 | PM796503 |
| 16060000123566 | L16/dossiers | 16 | 16060000123565 | 16060000123565 | 1 | PA721442 | PM797253 |
| 16060000123577 | L16/dossiers | 16 | 16060000123576 | 16060000123576 | 1 | PA785857 | PM785867 |
| 16060000123578 | L16/dossiers | 16 | 16060000123576 | 16060000123576 | 2 | PA827978 | PM828730 |
| 16060000123579 | L16/dossiers | 16 | 16060000123576 | 16060000123576 | 3 | PA721166 | PM785865 |
| 16060000123580 | L16/dossiers | 16 | 16060000123576 | 16060000123576 | 4 | PA785855 | PM785869 |
| 16060000123581 | L16/dossiers | 16 | 16060000123576 | 16060000123576 | 5 | PA429835 | PM829719 |
| 16060000123582 | L16/dossiers | 16 | 16060000123576 | 16060000123576 | 6 | PA827990 | PM828794 |
| 16060000123589 | L16/dossiers | 16 | 16060000123588 | 16060000123588 | 1 | PA703500 | PM775643 |
| 16060000123590 | L16/dossiers | 16 | 16060000123588 | 16060000123588 | 2 | PA703518 | PM775673 |
| 16060000123601 | L16/dossiers | 16 | 16060000123600 | 16060000123600 | 1 | PA335612 | PM797391 |
| 16060000123608 | L16/dossiers | 16 | 16060000123607 | 16060000123607 | 1 | PA605745 | PM796419 |
| 16060000123618 | L16/dossiers | 16 | 16060000123617 | 16060000123617 | 1 | PA796010 | PM797802 |
| 16060000123641 | L16/dossiers | 16 | 16060000123640 | 16060000123640 | 1 | PA796106 | PM833657 |
| 16060000123657 | L16/dossiers | 16 | 16060000123656 | 16060000123656 | 1 | PA720692 | PM796986 |
| 16060000123681 | L16/dossiers | 16 | 16060000123680 | 16060000123680 | 1 | PA313924 | PM775727 |
| 16060000123682 | L16/dossiers | 16 | 16060000123680 | 16060000123680 | 2 | PA736218 | PM829869 |
| 16060000123683 | L16/dossiers | 16 | 16060000123680 | 16060000123680 | 3 | PA703530 | PM775689 |
| 16060000123690 | L16/dossiers | 16 | 16060000123689 | 16060000123689 | 1 | PA722190 | PM833697 |
| 16060000123691 | L16/dossiers | 16 | 16060000123689 | 16060000123689 | 2 | PA331481 | PM833713 |
| 16060000123692 | L16/dossiers | 16 | 16060000123689 | 16060000123689 | 3 | PA793940 | PM834771 |
| 16060000123704 | L16/dossiers | 16 | 16060000123703 | 16060000123703 | 1 | PA795580 | PM797574 |
| 16060000123708 | L16/dossiers | 16 | 16060000123707 | 16060000123707 | 1 | PA722190 | PM833697 |
| 16060000123716 | L16/dossiers | 16 | 16060000123715 | 16060000123715 | 1 | PA722190 | PM833697 |
| 16060000123727 | L16/dossiers | 16 | 16060000123726 | 16060000123726 | 1 | PA795050 | PM797274 |
| 16060000123734 | L16/dossiers | 16 | 16060000123733 | 16060000123733 | 1 | PA795228 | PM797370 |
| 16060000123738 | L16/dossiers | 16 | 16060000123737 | 16060000123737 | 1 | PA382672 | PM829681 |
| 16060000123745 | L16/dossiers | 16 | 16060000123744 | 16060000123744 | 1 | PA267075 | PM775610 |
| 16060000123752 | L16/dossiers | 16 | 16060000123751 | 16060000123751 | 1 | PA719930 | PM796770 |
| 16060000123769 | L16/dossiers | 16 | 16060000123768 | 16060000123768 | 1 | PA793892 | PM796590 |
| 16060000123773 | L16/dossiers | 16 | 16060000123772 | 16060000123772 | 1 | PA266788 | PM796788 |
| 16060000123777 | L16/dossiers | 16 | 16060000123776 | 16060000123776 | 1 | PA267794 | PM796272 |
| 16060000123784 | L16/dossiers | 16 | 16060000123783 | 16060000123783 | 1 | PA605888 | PM775604 |
| 16060000123785 | L16/dossiers | 16 | 16060000123783 | 16060000123783 | 2 | PA827920 | PM828574 |
| 16060000123786 | L16/dossiers | 16 | 16060000123783 | 16060000123783 | 3 | PA702993 | PM829493 |
| 16060000123787 | L16/dossiers | 16 | 16060000123783 | 16060000123783 | 4 | PA736234 | PM829887 |
| 16060000123788 | L16/dossiers | 16 | 16060000123783 | 16060000123783 | 5 | PA708633 | PM775669 |
| 16060000123789 | L16/dossiers | 16 | 16060000123783 | 16060000123783 | 6 | PA415477 | PM775809 |
| 16060000123790 | L16/dossiers | 16 | 16060000123783 | 16060000123783 | 7 | PA736225 | PM829907 |
| 16060000123791 | L16/dossiers | 16 | 16060000123783 | 16060000123783 | 8 | PA342564 | PM829509 |
| 16060000123792 | L16/dossiers | 16 | 16060000123783 | 16060000123783 | 9 | PA606375 | PM775602 |