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 |
|---|---|---|---|---|---|---|---|
| 15060000187646 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 4 | PA304082 | PM736354 |
| 15060000187647 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 5 | PA775172 | PM775474 |
| 15060000187648 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 6 | PA429894 | PM736364 |
| 15060000187649 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 7 | PA756685 | PM775777 |
| 15060000187650 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 8 | PA429836 | PM736345 |
| 15060000187651 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 9 | PA429886 | PM736385 |
| 15060000187652 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 10 | PA736195 | PM736357 |
| 15060000187653 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 11 | PA736173 | PM736369 |
| 15060000187654 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 12 | PA678263 | PM736330 |
| 15060000187655 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 13 | PA1978 | PM736337 |
| 15060000187656 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 14 | PA736243 | PM736413 |
| 15060000187657 | L15/dossiers | 15 | 15060000187642 | 15060000187642 | 15 | PA736175 | PM736344 |
| 15060000187664 | L15/dossiers | 15 | 15060000187663 | 15060000187663 | 1 | PA719980 | PM722822 |
| 15060000187668 | L15/dossiers | 15 | 15060000187667 | 15060000187667 | 1 | PA267785 | PM723310 |
| 15060000187675 | L15/dossiers | 15 | 15060000187674 | 15060000187674 | 1 | PA346054 | PM723510 |
| 15060000187682 | L15/dossiers | 15 | 15060000187681 | 15060000187681 | 1 | PA720546 | PM722996 |
| 15060000187689 | L15/dossiers | 15 | 15060000187688 | 15060000187688 | 1 | PA718720 | PM722436 |
| 15060000187693 | L15/dossiers | 15 | 15060000187692 | 15060000187692 | 1 | PA267762 | PM736366 |
| 15060000187700 | L15/dossiers | 15 | 15060000187699 | 15060000187699 | 1 | PA721474 | PM723286 |
| 15060000187704 | L15/dossiers | 15 | 15060000187703 | 15060000187703 | 1 | PA721474 | PM723286 |
| 15060000187708 | L15/dossiers | 15 | 15060000187707 | 15060000187707 | 1 | PA721474 | PM723286 |
| 15060000187712 | L15/dossiers | 15 | 15060000187711 | 15060000187711 | 1 | PA773441 | PM773491 |
| 15060000187719 | L15/dossiers | 15 | 15060000187718 | 15060000187718 | 1 | PA773441 | PM773491 |
| 15060000187726 | L15/dossiers | 15 | 15060000187725 | 15060000187725 | 1 | PA773441 | PM773491 |
| 15060000187733 | L15/dossiers | 15 | 15060000187732 | 15060000187732 | 1 | PA606098 | PM722642 |
| 15060000187740 | L15/dossiers | 15 | 15060000187739 | 15060000187739 | 1 | PA405480 | PM723118 |
| 15060000187747 | L15/dossiers | 15 | 15060000187746 | 15060000187746 | 1 | PA267328 | PM775729 |
| 15060000187754 | L15/dossiers | 15 | 15060000187753 | 15060000187753 | 1 | PA227029 | PM736306 |
| 15060000187761 | L15/dossiers | 15 | 15060000187760 | 15060000187760 | 1 | PA721474 | PM723286 |
| 15060000187768 | L15/dossiers | 15 | 15060000187767 | 15060000187767 | 1 | PA720772 | PM723072 |
| 15060000187775 | L15/dossiers | 15 | 15060000187774 | 15060000187774 | 1 | PA608416 | PM723540 |
| 15060000187782 | L15/dossiers | 15 | 15060000187781 | 15060000187781 | 1 | PA429895 | PM736262 |
| 15060000187783 | L15/dossiers | 15 | 15060000187781 | 15060000187781 | 2 | PA267840 | PM736423 |
| 15060000187784 | L15/dossiers | 15 | 15060000187781 | 15060000187781 | 3 | PA775182 | PM775464 |
| 15060000187785 | L15/dossiers | 15 | 15060000187781 | 15060000187781 | 4 | PA703528 | PM775693 |
| 15060000187786 | L15/dossiers | 15 | 15060000187781 | 15060000187781 | 5 | PA268007 | PM736325 |
| 15060000187787 | L15/dossiers | 15 | 15060000187781 | 15060000187781 | 6 | PA775226 | PM775510 |
| 15060000187788 | L15/dossiers | 15 | 15060000187781 | 15060000187781 | 7 | PA736228 | PM736380 |
| 15060000187789 | L15/dossiers | 15 | 15060000187781 | 15060000187781 | 8 | PA736168 | PM736301 |
| 15060000187790 | L15/dossiers | 15 | 15060000187781 | 15060000187781 | 9 | PA703495 | PM775653 |
| 15060000187797 | L15/dossiers | 15 | 15060000187796 | 15060000187796 | 1 | PA720802 | PM774333 |
| 15060000187804 | L15/dossiers | 15 | 15060000187803 | 15060000187803 | 1 | PA773891 | PM773895 |
| 15060000187805 | L15/dossiers | 15 | 15060000187803 | 15060000187803 | 2 | PA429854 | PM736335 |
| 15060000187806 | L15/dossiers | 15 | 15060000187803 | 15060000187803 | 3 | PA736235 | PM775795 |
| 15060000187807 | L15/dossiers | 15 | 15060000187803 | 15060000187803 | 4 | PA775176 | PM775462 |
| 15060000187808 | L15/dossiers | 15 | 15060000187803 | 15060000187803 | 5 | PA425322 | PM736282 |
| 15060000187809 | L15/dossiers | 15 | 15060000187803 | 15060000187803 | 6 | PA703534 | PM775695 |
| 15060000187810 | L15/dossiers | 15 | 15060000187803 | 15060000187803 | 7 | PA736246 | PM775819 |
| 15060000187811 | L15/dossiers | 15 | 15060000187803 | 15060000187803 | 8 | PA703522 | PM775701 |
| 15060000187812 | L15/dossiers | 15 | 15060000187803 | 15060000187803 | 9 | PA744079 | PM744082 |