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 |
|---|---|---|---|---|---|---|---|
| 17060000147611 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 9 | PA330684 | PM775859 |
| 17060000147612 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 10 | PA827914 | PM828494 |
| 17060000147613 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 11 | PA775202 | PM775502 |
| 17060000147614 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 12 | PA736197 | PM829863 |
| 17060000147615 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 13 | PA404656 | PM829669 |
| 17060000147616 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 14 | PA775220 | PM775526 |
| 17060000147617 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 15 | PA775228 | PM775516 |
| 17060000147618 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 16 | PA778908 | PM829661 |
| 17060000147619 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 17 | PA267081 | PM775733 |
| 17060000147620 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 18 | PA415495 | PM775635 |
| 17060000147621 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 19 | PA703515 | PM775663 |
| 17060000147622 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 20 | PA827952 | PM828698 |
| 17060000147623 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 21 | PA827954 | PM828704 |
| 17060000147624 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 22 | PA736246 | PM775819 |
| 17060000147625 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 23 | PA736213 | PM775791 |
| 17060000147626 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 24 | PA736185 | PM829813 |
| 17060000147627 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 25 | PA703497 | PM775637 |
| 17060000147628 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 26 | PA866550 | PM866552 |
| 17060000147629 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 27 | PA827964 | PM828652 |
| 17060000147630 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 28 | PA785193 | PM829743 |
| 17060000147631 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 29 | PA708632 | PM775667 |
| 17060000147632 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 30 | PA827974 | PM828744 |
| 17060000147633 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 31 | PA343988 | PM829809 |
| 17060000147634 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 32 | PA703521 | PM775707 |
| 17060000147635 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 33 | PA736200 | PM829845 |
| 17060000147636 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 34 | PA827988 | PM828788 |
| 17060000147637 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 35 | PA736227 | PM829901 |
| 17060000147638 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 36 | PA873412 | PM873414 |
| 17060000147639 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 37 | PA736207 | PM829847 |
| 17060000147640 | L17/dossiers | 17 | 17060000147602 | 17060000147602 | 38 | PA775298 | PM775594 |
| 17060000147647 | L17/dossiers | 17 | 17060000147646 | 17060000147646 | 1 | PA643210 | PM873637 |
| 17060000147712 | L17/dossiers | 17 | 17060000147711 | 17060000147711 | 1 | PA736231 | PM829915 |
| 17060000147713 | L17/dossiers | 17 | 17060000147711 | 17060000147711 | 2 | PA415451 | PM775787 |
| 17060000147714 | L17/dossiers | 17 | 17060000147711 | 17060000147711 | 3 | PA775298 | PM775594 |
| 17060000147715 | L17/dossiers | 17 | 17060000147711 | 17060000147711 | 4 | PA827952 | PM828698 |
| 17060000147716 | L17/dossiers | 17 | 17060000147711 | 17060000147711 | 5 | PA736207 | PM829847 |
| 17060000147735 | L17/dossiers | 17 | 17060000147734 | 17060000147734 | 1 | PA703518 | PM775673 |
| 17060000147758 | L17/dossiers | 17 | 17060000147757 | 17060000147757 | 1 | PA794778 | PM843239 |
| 17060000147775 | L17/dossiers | 17 | 17060000147774 | 17060000147774 | 1 | PA643210 | PM873637 |
| 17060000147847 | L17/dossiers | 17 | 17060000147846 | 17060000147846 | 1 | PA643210 | PM873637 |
| 17060000147896 | L17/dossiers | 17 | 17060000147895 | 17060000147895 | 1 | PA643210 | PM873637 |
| 17060000147903 | L17/dossiers | 17 | 17060000147902 | 17060000147902 | 1 | PA785857 | PM785867 |
| 17060000147904 | L17/dossiers | 17 | 17060000147902 | 17060000147902 | 2 | PA827978 | PM828730 |
| 17060000147914 | L17/dossiers | 17 | 17060000147913 | 17060000147913 | 1 | PA793290 | PM842450 |
| 17060000147921 | L17/dossiers | 17 | 17060000147920 | 17060000147920 | 1 | PA793736 | PM842693 |
| 17060000147928 | L17/dossiers | 17 | 17060000147927 | 17060000147927 | 1 | PA718884 | PM842420 |
| 17060000147935 | L17/dossiers | 17 | 17060000147934 | 17060000147934 | 1 | PA793736 | PM842693 |
| 17060000147942 | L17/dossiers | 17 | 17060000147941 | 17060000147941 | 1 | PA309643 | PM843545 |
| 17060000147949 | L17/dossiers | 17 | 17060000147948 | 17060000147948 | 1 | PA842187 | PM843704 |
| 17060000147956 | L17/dossiers | 17 | 17060000147955 | 17060000147955 | 1 | PA795164 | PM840444 |