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 |
|---|---|---|---|---|---|---|---|
| 15060000175531 | L15/dossiers | 15 | 15060000175530 | 15060000175530 | 1 | PA775250 | PM775552 |
| 15060000175565 | L15/dossiers | 15 | 15060000175564 | 15060000175564 | 1 | PA773441 | PM773491 |
| 15060000175566 | L15/dossiers | 15 | 15060000175564 | 15060000175564 | 2 | PA609520 | PM773503 |
| 15060000175567 | L15/dossiers | 15 | 15060000175564 | 15060000175564 | 3 | PA759830 | PM773473 |
| 15060000175574 | L15/dossiers | 15 | 15060000175573 | 15060000175573 | 1 | PA643089 | PM758076 |
| 15060000175581 | L15/dossiers | 15 | 15060000175580 | 15060000175580 | 1 | PA267429 | PM722818 |
| 15060000175597 | L15/dossiers | 15 | 15060000175596 | 15060000175596 | 1 | PA720614 | PM723016 |
| 15060000175604 | L15/dossiers | 15 | 15060000175603 | 15060000175603 | 1 | PA267260 | PM722476 |
| 15060000175611 | L15/dossiers | 15 | 15060000175610 | 15060000175610 | 1 | PA719020 | PM774184 |
| 15060000175618 | L15/dossiers | 15 | 15060000175617 | 15060000175617 | 1 | PA267780 | PM723504 |
| 15060000175622 | L15/dossiers | 15 | 15060000175621 | 15060000175621 | 1 | PA719946 | PM722808 |
| 15060000175629 | L15/dossiers | 15 | 15060000175628 | 15060000175628 | 1 | PA223837 | PM722458 |
| 15060000175633 | L15/dossiers | 15 | 15060000175632 | 15060000175632 | 1 | PA721118 | PM723176 |
| 15060000175650 | L15/dossiers | 15 | 15060000175649 | 15060000175649 | 1 | PA2116 | PM736339 |
| 15060000175657 | L15/dossiers | 15 | 15060000175656 | 15060000175656 | 1 | PA719272 | PM722612 |
| 15060000175664 | L15/dossiers | 15 | 15060000175663 | 15060000175663 | 1 | PA736241 | PM736300 |
| 15060000175665 | L15/dossiers | 15 | 15060000175663 | 15060000175663 | 2 | PA342564 | PM736388 |
| 15060000175666 | L15/dossiers | 15 | 15060000175663 | 15060000175663 | 3 | PA643211 | PM775749 |
| 15060000175667 | L15/dossiers | 15 | 15060000175663 | 15060000175663 | 4 | PA2074 | PM775677 |
| 15060000175677 | L15/dossiers | 15 | 15060000175676 | 15060000175676 | 1 | PA736214 | PM736290 |
| 15060000175690 | L15/dossiers | 15 | 15060000175689 | 15060000175689 | 1 | PA774956 | PM774979 |
| 15060000175694 | L15/dossiers | 15 | 15060000175693 | 15060000175693 | 1 | PA609726 | PM723426 |
| 15060000175698 | L15/dossiers | 15 | 15060000175697 | 15060000175697 | 1 | PA720614 | PM723016 |
| 15060000175705 | L15/dossiers | 15 | 15060000175704 | 15060000175704 | 1 | PA722268 | PM723522 |
| 15060000175709 | L15/dossiers | 15 | 15060000175708 | 15060000175708 | 1 | PA722142 | PM723484 |
| 15060000175716 | L15/dossiers | 15 | 15060000175715 | 15060000175715 | 1 | PA721474 | PM723286 |
| 15060000175723 | L15/dossiers | 15 | 15060000175722 | 15060000175722 | 1 | PA773441 | PM773491 |
| 15060000175724 | L15/dossiers | 15 | 15060000175722 | 15060000175722 | 2 | PA609520 | PM773503 |
| 15060000175725 | L15/dossiers | 15 | 15060000175722 | 15060000175722 | 3 | PA722236 | PM773501 |
| 15060000175735 | L15/dossiers | 15 | 15060000175734 | 15060000175734 | 1 | PA2116 | PM736339 |
| 15060000175742 | L15/dossiers | 15 | 15060000175741 | 15060000175741 | 1 | PA330684 | PM775859 |
| 15060000175749 | L15/dossiers | 15 | 15060000175748 | 15060000175748 | 1 | PA2796 | PM722510 |
| 15060000175756 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 1 | PA736229 | PM736389 |
| 15060000175757 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 2 | PA736167 | PM736327 |
| 15060000175758 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 3 | PA703538 | PM775715 |
| 15060000175759 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 4 | PA702993 | PM736362 |
| 15060000175760 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 5 | PA642756 | PM775779 |
| 15060000175761 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 6 | PA2074 | PM775677 |
| 15060000175762 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 7 | PA2774 | PM736307 |
| 15060000175763 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 8 | PA775210 | PM775492 |
| 15060000175764 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 9 | PA429835 | PM736397 |
| 15060000175765 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 10 | PA429835 | PM736397 |
| 15060000175766 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 11 | PA736187 | PM736365 |
| 15060000175767 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 12 | PA736241 | PM736300 |
| 15060000175768 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 13 | PA703511 | PM775685 |
| 15060000175769 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 14 | PA342564 | PM736388 |
| 15060000175770 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 15 | PA736214 | PM736290 |
| 15060000175771 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 16 | PA736217 | PM736384 |
| 15060000175772 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 17 | PA415477 | PM775809 |
| 15060000175773 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 18 | PA415477 | PM775809 |