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 |
|---|---|---|---|---|---|---|---|
| 16060000102656 | L16/dossiers | 16 | 16060000102655 | 16060000102655 | 1 | PA266788 | PM796788 |
| 16060000102663 | L16/dossiers | 16 | 16060000102662 | 16060000102662 | 1 | PA266788 | PM796788 |
| 16060000102667 | L16/dossiers | 16 | 16060000102666 | 16060000102666 | 1 | PA266788 | PM796788 |
| 16060000102671 | L16/dossiers | 16 | 16060000102670 | 16060000102670 | 1 | PA266788 | PM796788 |
| 16060000102678 | L16/dossiers | 16 | 16060000102677 | 16060000102677 | 1 | PA720846 | PM797328 |
| 16060000102685 | L16/dossiers | 16 | 16060000102684 | 16060000102684 | 1 | PA717161 | PM791583 |
| 16060000102691 | L16/dossiers | 16 | 16060000102690 | 16060000102690 | 1 | PA267081 | PM775733 |
| 16060000102698 | L16/dossiers | 16 | 16060000102697 | 16060000102697 | 1 | PA267762 | PM736366 |
| 16060000102711 | L16/dossiers | 16 | 16060000102710 | 16060000102710 | 1 | PA266797 | PM796812 |
| 16060000102715 | L16/dossiers | 16 | 16060000102714 | 16060000102714 | 1 | PA744079 | PM744082 |
| 16060000102722 | L16/dossiers | 16 | 16060000102721 | 16060000102721 | 1 | PA796018 | PM797805 |
| 16060000102740 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 1 | PA757676 | PM757692 |
| 16060000102741 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 2 | PA429836 | PM736345 |
| 16060000102742 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 3 | PA304082 | PM736354 |
| 16060000102743 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 4 | PA775172 | PM775474 |
| 16060000102744 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 5 | PA429894 | PM736364 |
| 16060000102745 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 6 | PA756685 | PM775777 |
| 16060000102746 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 7 | PA429886 | PM736385 |
| 16060000102747 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 8 | PA736195 | PM736357 |
| 16060000102748 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 9 | PA736173 | PM736369 |
| 16060000102749 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 10 | PA775246 | PM775532 |
| 16060000102750 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 11 | PA678263 | PM736330 |
| 16060000102751 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 12 | PA1978 | PM736337 |
| 16060000102752 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 13 | PA736243 | PM736413 |
| 16060000102753 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 14 | PA736175 | PM736344 |
| 16060000102754 | L16/dossiers | 16 | 16060000102739 | 16060000102739 | 15 | PA775296 | PM775596 |
| 16060000102761 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 1 | PA736195 | PM736357 |
| 16060000102762 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 2 | PA775172 | PM775474 |
| 16060000102763 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 3 | PA757676 | PM757692 |
| 16060000102764 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 4 | PA304082 | PM736354 |
| 16060000102765 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 5 | PA429894 | PM736364 |
| 16060000102766 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 6 | PA756685 | PM775777 |
| 16060000102767 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 7 | PA429836 | PM736345 |
| 16060000102768 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 8 | PA429886 | PM736385 |
| 16060000102769 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 9 | PA736173 | PM736369 |
| 16060000102770 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 10 | PA775246 | PM775532 |
| 16060000102771 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 11 | PA678263 | PM736330 |
| 16060000102772 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 12 | PA1978 | PM736337 |
| 16060000102773 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 13 | PA736243 | PM736413 |
| 16060000102774 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 14 | PA736175 | PM736344 |
| 16060000102775 | L16/dossiers | 16 | 16060000102760 | 16060000102760 | 15 | PA775296 | PM775596 |
| 16060000102782 | L16/dossiers | 16 | 16060000102781 | 16060000102781 | 1 | PA775226 | PM775510 |
| 16060000102806 | L16/dossiers | 16 | 16060000102805 | 16060000102805 | 1 | PA345722 | PM797718 |
| 16060000102807 | L16/dossiers | 16 | 16060000102805 | 16060000102805 | 2 | PA793354 | PM796281 |
| 16060000102824 | L16/dossiers | 16 | 16060000102823 | 16060000102823 | 1 | PA717161 | PM791583 |
| 16060000102825 | L16/dossiers | 16 | 16060000102823 | 16060000102823 | 2 | PA312976 | PM791676 |
| 16060000102862 | L16/dossiers | 16 | 16060000102861 | 16060000102861 | 1 | PA717161 | PM791583 |
| 16060000102869 | L16/dossiers | 16 | 16060000102868 | 16060000102868 | 1 | PA703485 | PM775811 |
| 16060000102876 | L16/dossiers | 16 | 16060000102875 | 16060000102875 | 1 | PA773891 | PM773895 |
| 16060000102890 | L16/dossiers | 16 | 16060000102889 | 16060000102889 | 1 | PA717161 | PM791583 |