dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 17060000152581 | L17/dossiers | 17 | 17060000152580 | 17060000152580 | 1 | PA720342 | PM842999 |
| 17060000152588 | L17/dossiers | 17 | 17060000152587 | 17060000152587 | 1 | PA842187 | PM843704 |
| 17060000152595 | L17/dossiers | 17 | 17060000152594 | 17060000152594 | 1 | PA720430 | PM843092 |
| 17060000152602 | L17/dossiers | 17 | 17060000152601 | 17060000152601 | 1 | PA793744 | PM842696 |
| 17060000152609 | L17/dossiers | 17 | 17060000152608 | 17060000152608 | 1 | PA795228 | PM840447 |
| 17060000152616 | L17/dossiers | 17 | 17060000152615 | 17060000152615 | 1 | PA720892 | PM840420 |
| 17060000152623 | L17/dossiers | 17 | 17060000152622 | 17060000152622 | 1 | PA796062 | PM843668 |
| 17060000152630 | L17/dossiers | 17 | 17060000152629 | 17060000152629 | 1 | PA795046 | PM843818 |
| 17060000152637 | L17/dossiers | 17 | 17060000152636 | 17060000152636 | 1 | PA794710 | PM867916 |
| 17060000152644 | L17/dossiers | 17 | 17060000152643 | 17060000152643 | 1 | PA793736 | PM842693 |
| 17060000152651 | L17/dossiers | 17 | 17060000152650 | 17060000152650 | 1 | PA795164 | PM840444 |
| 17060000152664 | L17/dossiers | 17 | 17060000152663 | 17060000152663 | 1 | PA335054 | PM843332 |
| 17060000152671 | L17/dossiers | 17 | 17060000152670 | 17060000152670 | 1 | PA267763 | PM843125 |
| 17060000152681 | L17/dossiers | 17 | 17060000152680 | 17060000152680 | 1 | PA643210 | PM873637 |
| 17060000152689 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 1 | PA827978 | PM828730 |
| 17060000152690 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 2 | PA775180 | PM775466 |
| 17060000152691 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 3 | PA429845 | PM829729 |
| 17060000152692 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 4 | PA775214 | PM775498 |
| 17060000152693 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 5 | PA775224 | PM775512 |
| 17060000152694 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 6 | PA736177 | PM829835 |
| 17060000152695 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 7 | PA827946 | PM828614 |
| 17060000152696 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 8 | PA827950 | PM828598 |
| 17060000152697 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 9 | PA775252 | PM775558 |
| 17060000152698 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 10 | PA827968 | PM828750 |
| 17060000152699 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 11 | PA775272 | PM775562 |
| 17060000152700 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 12 | PA775282 | PM775584 |
| 17060000152701 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 13 | PA828000 | PM828850 |
| 17060000152702 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 14 | PA828004 | PM828838 |
| 17060000152703 | L17/dossiers | 17 | 17060000152688 | 17060000152688 | 15 | PA785857 | PM785867 |
| 17060000152710 | L17/dossiers | 17 | 17060000152709 | 17060000152709 | 1 | PA775174 | PM775472 |
| 17060000152717 | L17/dossiers | 17 | 17060000152716 | 17060000152716 | 1 | PA610968 | PM840381 |
| 17060000152724 | L17/dossiers | 17 | 17060000152723 | 17060000152723 | 1 | PA795778 | PM843509 |
| 17060000152732 | L17/dossiers | 17 | 17060000152731 | 17060000152731 | 1 | PA721110 | PM843782 |
| 17060000152739 | L17/dossiers | 17 | 17060000152738 | 17060000152738 | 1 | PA332523 | PM868378 |
| 17060000152743 | L17/dossiers | 17 | 17060000152742 | 17060000152742 | 1 | PA793736 | PM842693 |
| 17060000152747 | L17/dossiers | 17 | 17060000152746 | 17060000152746 | 1 | PA841717 | PM843278 |
| 17060000152751 | L17/dossiers | 17 | 17060000152750 | 17060000152750 | 1 | PA775252 | PM775558 |
| 17060000152758 | L17/dossiers | 17 | 17060000152757 | 17060000152757 | 1 | PA382672 | PM829681 |
| 17060000152765 | L17/dossiers | 17 | 17060000152764 | 17060000152764 | 1 | PA643210 | PM873637 |
| 17060000152773 | L17/dossiers | 17 | 17060000152772 | 17060000152772 | 1 | PA606375 | PM775602 |
| 17060000152774 | L17/dossiers | 17 | 17060000152772 | 17060000152772 | 2 | PA827920 | PM828574 |
| 17060000152781 | L17/dossiers | 17 | 17060000152780 | 17060000152780 | 1 | PA643210 | PM873637 |
| 17060000152792 | L17/dossiers | 17 | 17060000152791 | 17060000152791 | 1 | PA1744 | PM775781 |
| 17060000152793 | L17/dossiers | 17 | 17060000152791 | 17060000152791 | 2 | PA827922 | PM856930 |
| 17060000152794 | L17/dossiers | 17 | 17060000152791 | 17060000152791 | 3 | PA331381 | PM775739 |
| 17060000152795 | L17/dossiers | 17 | 17060000152791 | 17060000152791 | 4 | PA415495 | PM775635 |
| 17060000152796 | L17/dossiers | 17 | 17060000152791 | 17060000152791 | 5 | PA341381 | PM775747 |
| 17060000152797 | L17/dossiers | 17 | 17060000152791 | 17060000152791 | 6 | PA703521 | PM775707 |
| 17060000152804 | L17/dossiers | 17 | 17060000152803 | 17060000152803 | 1 | PA736227 | PM829901 |
| 17060000152811 | L17/dossiers | 17 | 17060000152810 | 17060000152810 | 1 | PA795616 | PM840462 |