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 |
|---|---|---|---|---|---|---|---|
| 17060000150621 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 9 | PA827950 | PM828598 |
| 17060000150622 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 10 | PA827968 | PM828750 |
| 17060000150623 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 11 | PA775272 | PM775562 |
| 17060000150624 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 12 | PA775282 | PM775584 |
| 17060000150625 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 13 | PA828000 | PM828850 |
| 17060000150626 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 14 | PA828004 | PM828838 |
| 17060000150627 | L17/dossiers | 17 | 17060000150612 | 17060000150612 | 15 | PA785857 | PM785867 |
| 17060000150634 | L17/dossiers | 17 | 17060000150633 | 17060000150633 | 1 | PA795820 | PM843713 |
| 17060000150638 | L17/dossiers | 17 | 17060000150637 | 17060000150637 | 1 | PA827894 | PM828460 |
| 17060000150645 | L17/dossiers | 17 | 17060000150644 | 17060000150644 | 1 | PA736229 | PM829923 |
| 17060000150652 | L17/dossiers | 17 | 17060000150651 | 17060000150651 | 1 | PA313924 | PM775727 |
| 17060000150653 | L17/dossiers | 17 | 17060000150651 | 17060000150651 | 2 | PA736179 | PM829833 |
| 17060000150660 | L17/dossiers | 17 | 17060000150659 | 17060000150659 | 1 | PA775228 | PM775516 |
| 17060000150661 | L17/dossiers | 17 | 17060000150659 | 17060000150659 | 2 | PA703523 | PM775703 |
| 17060000150662 | L17/dossiers | 17 | 17060000150659 | 17060000150659 | 3 | PA827926 | PM828562 |
| 17060000150663 | L17/dossiers | 17 | 17060000150659 | 17060000150659 | 4 | PA303995 | PM775745 |
| 17060000150664 | L17/dossiers | 17 | 17060000150659 | 17060000150659 | 5 | PA709298 | PM775773 |
| 17060000150671 | L17/dossiers | 17 | 17060000150670 | 17060000150670 | 1 | PA827900 | PM828434 |
| 17060000150678 | L17/dossiers | 17 | 17060000150677 | 17060000150677 | 1 | PA795820 | PM843713 |
| 17060000150685 | L17/dossiers | 17 | 17060000150684 | 17060000150684 | 1 | PA793716 | PM842528 |
| 17060000150692 | L17/dossiers | 17 | 17060000150691 | 17060000150691 | 1 | PA841017 | PM842636 |
| 17060000150699 | L17/dossiers | 17 | 17060000150698 | 17060000150698 | 1 | PA793980 | PM842750 |
| 17060000150706 | L17/dossiers | 17 | 17060000150705 | 17060000150705 | 1 | PA719778 | PM842744 |
| 17060000150713 | L17/dossiers | 17 | 17060000150712 | 17060000150712 | 1 | PA642847 | PM843056 |
| 17060000150720 | L17/dossiers | 17 | 17060000150719 | 17060000150719 | 1 | PA720390 | PM881119 |
| 17060000150727 | L17/dossiers | 17 | 17060000150726 | 17060000150726 | 1 | PA267200 | PM843098 |
| 17060000150734 | L17/dossiers | 17 | 17060000150733 | 17060000150733 | 1 | PA795616 | PM840462 |
| 17060000150741 | L17/dossiers | 17 | 17060000150740 | 17060000150740 | 1 | PA719032 | PM842393 |
| 17060000150748 | L17/dossiers | 17 | 17060000150747 | 17060000150747 | 1 | PA642847 | PM843056 |
| 17060000150755 | L17/dossiers | 17 | 17060000150754 | 17060000150754 | 1 | PA842141 | PM863671 |
| 17060000150762 | L17/dossiers | 17 | 17060000150761 | 17060000150761 | 1 | PA718784 | PM842342 |
| 17060000150769 | L17/dossiers | 17 | 17060000150768 | 17060000150768 | 1 | PA841981 | PM843533 |
| 17060000150776 | L17/dossiers | 17 | 17060000150775 | 17060000150775 | 1 | PA795596 | PM840456 |
| 17060000150783 | L17/dossiers | 17 | 17060000150782 | 17060000150782 | 1 | PA840721 | PM842378 |
| 17060000150790 | L17/dossiers | 17 | 17060000150789 | 17060000150789 | 1 | PA793322 | PM840246 |
| 17060000150797 | L17/dossiers | 17 | 17060000150796 | 17060000150796 | 1 | PA842121 | PM874932 |
| 17060000150804 | L17/dossiers | 17 | 17060000150803 | 17060000150803 | 1 | PA794118 | PM842894 |
| 17060000150811 | L17/dossiers | 17 | 17060000150810 | 17060000150810 | 1 | PA842279 | PM843779 |
| 17060000150818 | L17/dossiers | 17 | 17060000150817 | 17060000150817 | 1 | PA721296 | PM843698 |
| 17060000150825 | L17/dossiers | 17 | 17060000150824 | 17060000150824 | 1 | PA720390 | PM881119 |
| 17060000150832 | L17/dossiers | 17 | 17060000150831 | 17060000150831 | 1 | PA796062 | PM843668 |
| 17060000150839 | L17/dossiers | 17 | 17060000150838 | 17060000150838 | 1 | PA841243 | PM842825 |
| 17060000150846 | L17/dossiers | 17 | 17060000150845 | 17060000150845 | 1 | PA793852 | PM842684 |
| 17060000150863 | L17/dossiers | 17 | 17060000150862 | 17060000150862 | 1 | PA841749 | PM843305 |
| 17060000150870 | L17/dossiers | 17 | 17060000150869 | 17060000150869 | 1 | PA840665 | PM842336 |
| 17060000150877 | L17/dossiers | 17 | 17060000150876 | 17060000150876 | 1 | PA795820 | PM843713 |
| 17060000150884 | L17/dossiers | 17 | 17060000150883 | 17060000150883 | 1 | PA841813 | PM843377 |
| 17060000150894 | L17/dossiers | 17 | 17060000150893 | 17060000150893 | 1 | PA794206 | PM842879 |
| 17060000150907 | L17/dossiers | 17 | 17060000150906 | 17060000150906 | 1 | PA643210 | PM873637 |
| 17060000150908 | L17/dossiers | 17 | 17060000150906 | 17060000150906 | 2 | PA842117 | PM873688 |