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 |
|---|---|---|---|---|---|---|---|
| 16060000114752 | L16/dossiers | 16 | 16060000114750 | 16060000114750 | 2 | PA775180 | PM775466 |
| 16060000114753 | L16/dossiers | 16 | 16060000114750 | 16060000114750 | 3 | PA801838 | PM801842 |
| 16060000114754 | L16/dossiers | 16 | 16060000114750 | 16060000114750 | 4 | PA429845 | PM736278 |
| 16060000114755 | L16/dossiers | 16 | 16060000114750 | 16060000114750 | 5 | PA775214 | PM775498 |
| 16060000114756 | L16/dossiers | 16 | 16060000114750 | 16060000114750 | 6 | PA736177 | PM736318 |
| 16060000114757 | L16/dossiers | 16 | 16060000114750 | 16060000114750 | 7 | PA429866 | PM736287 |
| 16060000114758 | L16/dossiers | 16 | 16060000114750 | 16060000114750 | 8 | PA775252 | PM775558 |
| 16060000114759 | L16/dossiers | 16 | 16060000114750 | 16060000114750 | 9 | PA775262 | PM775548 |
| 16060000114760 | L16/dossiers | 16 | 16060000114750 | 16060000114750 | 10 | PA775272 | PM775562 |
| 16060000114761 | L16/dossiers | 16 | 16060000114750 | 16060000114750 | 11 | PA775282 | PM775584 |
| 16060000114762 | L16/dossiers | 16 | 16060000114750 | 16060000114750 | 12 | PA785857 | PM785867 |
| 16060000114769 | L16/dossiers | 16 | 16060000114768 | 16060000114768 | 1 | PA775284 | PM775590 |
| 16060000114776 | L16/dossiers | 16 | 16060000114775 | 16060000114775 | 1 | PA720560 | PM797016 |
| 16060000114783 | L16/dossiers | 16 | 16060000114782 | 16060000114782 | 1 | PA775182 | PM775464 |
| 16060000114790 | L16/dossiers | 16 | 16060000114789 | 16060000114789 | 1 | PA793342 | PM796269 |
| 16060000114797 | L16/dossiers | 16 | 16060000114796 | 16060000114796 | 1 | PA721530 | PM797433 |
| 16060000114804 | L16/dossiers | 16 | 16060000114803 | 16060000114803 | 1 | PA717161 | PM791583 |
| 16060000114811 | L16/dossiers | 16 | 16060000114810 | 16060000114810 | 1 | PA643134 | PM796758 |
| 16060000114815 | L16/dossiers | 16 | 16060000114814 | 16060000114814 | 1 | PA330684 | PM775859 |
| 16060000114822 | L16/dossiers | 16 | 16060000114821 | 16060000114821 | 1 | PA793330 | PM796263 |
| 16060000114839 | L16/dossiers | 16 | 16060000114838 | 16060000114838 | 1 | PA736201 | PM797523 |
| 16060000114851 | L16/dossiers | 16 | 16060000114850 | 16060000114850 | 1 | PA607553 | PM796875 |
| 16060000114858 | L16/dossiers | 16 | 16060000114857 | 16060000114857 | 1 | PA718930 | PM796287 |
| 16060000114865 | L16/dossiers | 16 | 16060000114864 | 16060000114864 | 1 | PA712015 | PM796176 |
| 16060000114872 | L16/dossiers | 16 | 16060000114871 | 16060000114871 | 1 | PA721262 | PM797550 |
| 16060000114879 | L16/dossiers | 16 | 16060000114878 | 16060000114878 | 1 | PA795604 | PM797583 |
| 16060000114886 | L16/dossiers | 16 | 16060000114885 | 16060000114885 | 1 | PA722374 | PM797196 |
| 16060000114890 | L16/dossiers | 16 | 16060000114889 | 16060000114889 | 1 | PA720960 | PM797643 |
| 16060000114913 | L16/dossiers | 16 | 16060000114912 | 16060000114912 | 1 | PA720468 | PM796983 |
| 16060000114920 | L16/dossiers | 16 | 16060000114919 | 16060000114919 | 1 | PA796042 | PM797820 |
| 16060000114927 | L16/dossiers | 16 | 16060000114926 | 16060000114926 | 1 | PA722344 | PM797244 |
| 16060000114934 | L16/dossiers | 16 | 16060000114933 | 16060000114933 | 1 | PA793342 | PM796269 |
| 16060000114941 | L16/dossiers | 16 | 16060000114940 | 16060000114940 | 1 | PA720386 | PM796908 |
| 16060000114948 | L16/dossiers | 16 | 16060000114947 | 16060000114947 | 1 | PA736206 | PM736351 |
| 16060000114984 | L16/dossiers | 16 | 16060000114983 | 16060000114983 | 1 | PA736181 | PM736416 |
| 16060000114991 | L16/dossiers | 16 | 16060000114990 | 16060000114990 | 1 | PA608416 | PM797133 |
| 16060000114995 | L16/dossiers | 16 | 16060000114994 | 16060000114994 | 1 | PA719890 | PM796680 |
| 16060000115002 | L16/dossiers | 16 | 16060000115001 | 16060000115001 | 1 | PA721932 | PM797361 |
| 16060000115006 | L16/dossiers | 16 | 16060000115005 | 16060000115005 | 1 | PA794486 | PM796953 |
| 16060000115013 | L16/dossiers | 16 | 16060000115012 | 16060000115012 | 1 | PA775302 | PM775598 |
| 16060000115020 | L16/dossiers | 16 | 16060000115019 | 16060000115019 | 1 | PA775248 | PM775554 |
| 16060000115027 | L16/dossiers | 16 | 16060000115026 | 16060000115026 | 1 | PA703528 | PM775693 |
| 16060000115034 | L16/dossiers | 16 | 16060000115033 | 16060000115033 | 1 | PA703528 | PM775693 |
| 16060000115041 | L16/dossiers | 16 | 16060000115040 | 16060000115040 | 1 | PA608016 | PM797100 |
| 16060000115048 | L16/dossiers | 16 | 16060000115047 | 16060000115047 | 1 | PA793342 | PM796269 |
| 16060000115055 | L16/dossiers | 16 | 16060000115054 | 16060000115054 | 1 | PA717161 | PM791583 |
| 16060000115056 | L16/dossiers | 16 | 16060000115054 | 16060000115054 | 2 | PA312976 | PM791676 |
| 16060000115088 | L16/dossiers | 16 | 16060000115087 | 16060000115087 | 1 | PA775170 | PM775468 |
| 16060000115095 | L16/dossiers | 16 | 16060000115094 | 16060000115094 | 1 | PA794590 | PM797007 |
| 16060000115111 | L16/dossiers | 16 | 16060000115110 | 16060000115110 | 1 | PA793254 | PM796230 |