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 |
|---|---|---|---|---|---|---|---|
| 15060000185655 | L15/dossiers | 15 | 15060000185654 | 15060000185654 | 1 | PA718756 | PM722446 |
| 15060000185656 | L15/dossiers | 15 | 15060000185654 | 15060000185654 | 2 | PA345722 | PM723428 |
| 15060000185672 | L15/dossiers | 15 | 15060000185671 | 15060000185671 | 1 | PA721486 | PM723290 |
| 15060000185679 | L15/dossiers | 15 | 15060000185678 | 15060000185678 | 1 | PA721486 | PM723290 |
| 15060000185686 | L15/dossiers | 15 | 15060000185685 | 15060000185685 | 1 | PA718784 | PM722456 |
| 15060000185693 | L15/dossiers | 15 | 15060000185692 | 15060000185692 | 1 | PA266788 | PM722914 |
| 15060000185697 | L15/dossiers | 15 | 15060000185696 | 15060000185696 | 1 | PA266788 | PM722914 |
| 15060000185704 | L15/dossiers | 15 | 15060000185703 | 15060000185703 | 1 | PA703485 | PM775811 |
| 15060000185714 | L15/dossiers | 15 | 15060000185713 | 15060000185713 | 1 | PA718926 | PM722502 |
| 15060000185724 | L15/dossiers | 15 | 15060000185723 | 15060000185723 | 1 | PA718926 | PM722502 |
| 15060000185731 | L15/dossiers | 15 | 15060000185730 | 15060000185730 | 1 | PA719108 | PM722564 |
| 15060000185738 | L15/dossiers | 15 | 15060000185737 | 15060000185737 | 1 | PA607395 | PM760313 |
| 15060000185745 | L15/dossiers | 15 | 15060000185744 | 15060000185744 | 1 | PA267766 | PM722970 |
| 15060000185752 | L15/dossiers | 15 | 15060000185751 | 15060000185751 | 1 | PA720822 | PM723086 |
| 15060000185759 | L15/dossiers | 15 | 15060000185758 | 15060000185758 | 1 | PA720334 | PM722932 |
| 15060000185766 | L15/dossiers | 15 | 15060000185765 | 15060000185765 | 1 | PA429858 | PM736268 |
| 15060000185767 | L15/dossiers | 15 | 15060000185765 | 15060000185765 | 2 | PA778908 | PM778928 |
| 15060000185768 | L15/dossiers | 15 | 15060000185765 | 15060000185765 | 3 | PA775184 | PM775486 |
| 15060000185769 | L15/dossiers | 15 | 15060000185765 | 15060000185765 | 4 | PA711156 | PM736319 |
| 15060000185776 | L15/dossiers | 15 | 15060000185775 | 15060000185775 | 1 | PA736231 | PM736381 |
| 15060000185777 | L15/dossiers | 15 | 15060000185775 | 15060000185775 | 2 | PA415451 | PM775787 |
| 15060000185778 | L15/dossiers | 15 | 15060000185775 | 15060000185775 | 3 | PA775298 | PM775594 |
| 15060000185785 | L15/dossiers | 15 | 15060000185784 | 15060000185784 | 1 | PA2116 | PM736339 |
| 15060000185792 | L15/dossiers | 15 | 15060000185791 | 15060000185791 | 1 | PA719980 | PM722822 |
| 15060000185796 | L15/dossiers | 15 | 15060000185795 | 15060000185795 | 1 | PA718944 | PM722508 |
| 15060000185803 | L15/dossiers | 15 | 15060000185802 | 15060000185802 | 1 | PA266788 | PM722914 |
| 15060000185810 | L15/dossiers | 15 | 15060000185809 | 15060000185809 | 1 | PA773441 | PM773491 |
| 15060000185817 | L15/dossiers | 15 | 15060000185816 | 15060000185816 | 1 | PA720014 | PM722834 |
| 15060000185821 | L15/dossiers | 15 | 15060000185820 | 15060000185820 | 1 | PA719608 | PM722710 |
| 15060000185828 | L15/dossiers | 15 | 15060000185827 | 15060000185827 | 1 | PA1206 | PM723354 |
| 15060000185835 | L15/dossiers | 15 | 15060000185834 | 15060000185834 | 1 | PA267075 | PM775610 |
| 15060000185842 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 1 | PA343775 | PM736367 |
| 15060000185843 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 2 | PA736198 | PM736406 |
| 15060000185844 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 3 | PA569 | PM775717 |
| 15060000185845 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 4 | PA775170 | PM775468 |
| 15060000185846 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 5 | PA415454 | PM785875 |
| 15060000185847 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 6 | PA415495 | PM775635 |
| 15060000185848 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 7 | PA429854 | PM736335 |
| 15060000185849 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 8 | PA415486 | PM775813 |
| 15060000185850 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 9 | PA775228 | PM775516 |
| 15060000185851 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 10 | PA703500 | PM775643 |
| 15060000185852 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 11 | PA736204 | PM736338 |
| 15060000185853 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 12 | PA267081 | PM775733 |
| 15060000185854 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 13 | PA775202 | PM775502 |
| 15060000185855 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 14 | PA720634 | PM736312 |
| 15060000185856 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 15 | PA736237 | PM736417 |
| 15060000185857 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 16 | PA415451 | PM775787 |
| 15060000185858 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 17 | PA758716 | PM775771 |
| 15060000185859 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 18 | PA758716 | PM775771 |
| 15060000185860 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 19 | PA715322 | PM775713 |