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 |
|---|---|---|---|---|---|---|---|
| 16060000117743 | L16/dossiers | 16 | 16060000117742 | 16060000117742 | 1 | PA719372 | PM796446 |
| 16060000117773 | L16/dossiers | 16 | 16060000117772 | 16060000117772 | 1 | PA720386 | PM796908 |
| 16060000117781 | L16/dossiers | 16 | 16060000117780 | 16060000117780 | 1 | PA827996 | PM828764 |
| 16060000117788 | L16/dossiers | 16 | 16060000117787 | 16060000117787 | 1 | PA736229 | PM829923 |
| 16060000117795 | L16/dossiers | 16 | 16060000117794 | 16060000117794 | 1 | PA828016 | PM828876 |
| 16060000117850 | L16/dossiers | 16 | 16060000117849 | 16060000117849 | 1 | PA720430 | PM797025 |
| 16060000117857 | L16/dossiers | 16 | 16060000117856 | 16060000117856 | 1 | PA793322 | PM796260 |
| 16060000117864 | L16/dossiers | 16 | 16060000117863 | 16060000117863 | 1 | PA795808 | PM797694 |
| 16060000117871 | L16/dossiers | 16 | 16060000117870 | 16060000117870 | 1 | PA794322 | PM796851 |
| 16060000117878 | L16/dossiers | 16 | 16060000117877 | 16060000117877 | 1 | PA719608 | PM796593 |
| 16060000117885 | L16/dossiers | 16 | 16060000117884 | 16060000117884 | 1 | PA793298 | PM796251 |
| 16060000117892 | L16/dossiers | 16 | 16060000117891 | 16060000117891 | 1 | PA795362 | PM797442 |
| 16060000117899 | L16/dossiers | 16 | 16060000117898 | 16060000117898 | 1 | PA794778 | PM797115 |
| 16060000117912 | L16/dossiers | 16 | 16060000117911 | 16060000117911 | 1 | PA795430 | PM797481 |
| 16060000117919 | L16/dossiers | 16 | 16060000117918 | 16060000117918 | 1 | PA643089 | PM797439 |
| 16060000117926 | L16/dossiers | 16 | 16060000117925 | 16060000117925 | 1 | PA793322 | PM796260 |
| 16060000117933 | L16/dossiers | 16 | 16060000117932 | 16060000117932 | 1 | PA793322 | PM796260 |
| 16060000117940 | L16/dossiers | 16 | 16060000117939 | 16060000117939 | 1 | PA793680 | PM796476 |
| 16060000117947 | L16/dossiers | 16 | 16060000117946 | 16060000117946 | 1 | PA793290 | PM796248 |
| 16060000117954 | L16/dossiers | 16 | 16060000117953 | 16060000117953 | 1 | PA1592 | PM797160 |
| 16060000117961 | L16/dossiers | 16 | 16060000117960 | 16060000117960 | 1 | PA793756 | PM796512 |
| 16060000117968 | L16/dossiers | 16 | 16060000117967 | 16060000117967 | 1 | PA722202 | PM797358 |
| 16060000117975 | L16/dossiers | 16 | 16060000117974 | 16060000117974 | 1 | PA719558 | PM796554 |
| 16060000117987 | L16/dossiers | 16 | 16060000117986 | 16060000117986 | 1 | PA794066 | PM796689 |
| 16060000117994 | L16/dossiers | 16 | 16060000117993 | 16060000117993 | 1 | PA720386 | PM796908 |
| 16060000118001 | L16/dossiers | 16 | 16060000118000 | 16060000118000 | 1 | PA266788 | PM796788 |
| 16060000118008 | L16/dossiers | 16 | 16060000118007 | 16060000118007 | 1 | PA795136 | PM797319 |
| 16060000118015 | L16/dossiers | 16 | 16060000118014 | 16060000118014 | 1 | PA720386 | PM796908 |
| 16060000118034 | L16/dossiers | 16 | 16060000118033 | 16060000118033 | 1 | PA335054 | PM797298 |
| 16060000118035 | L16/dossiers | 16 | 16060000118033 | 16060000118033 | 2 | PA719822 | PM796647 |
| 16060000118045 | L16/dossiers | 16 | 16060000118044 | 16060000118044 | 1 | PA717161 | PM791583 |
| 16060000118046 | L16/dossiers | 16 | 16060000118044 | 16060000118044 | 2 | PA721498 | PM791704 |
| 16060000118053 | L16/dossiers | 16 | 16060000118052 | 16060000118052 | 1 | PA717161 | PM791583 |
| 16060000118054 | L16/dossiers | 16 | 16060000118052 | 16060000118052 | 2 | PA331481 | PM791666 |
| 16060000118061 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 1 | PA775272 | PM775562 |
| 16060000118062 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 2 | PA775180 | PM775466 |
| 16060000118063 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 3 | PA429845 | PM829729 |
| 16060000118064 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 4 | PA775252 | PM775558 |
| 16060000118065 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 5 | PA775214 | PM775498 |
| 16060000118066 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 6 | PA775224 | PM775512 |
| 16060000118067 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 7 | PA736177 | PM829835 |
| 16060000118068 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 8 | PA775262 | PM775548 |
| 16060000118069 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 9 | PA775282 | PM775584 |
| 16060000118070 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 10 | PA785857 | PM785867 |
| 16060000118071 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 11 | PA827946 | PM828614 |
| 16060000118072 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 12 | PA827968 | PM828750 |
| 16060000118073 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 13 | PA827950 | PM828598 |
| 16060000118074 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 14 | PA827978 | PM828730 |
| 16060000118075 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 15 | PA828000 | PM828850 |
| 16060000118076 | L16/dossiers | 16 | 16060000118060 | 16060000118060 | 16 | PA828004 | PM828838 |