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 |
|---|---|---|---|---|---|---|---|
| 16060000097535 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 73 | PA775274 | PM775560 |
| 16060000097536 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 74 | PA703511 | PM775685 |
| 16060000097537 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 75 | PA775282 | PM775584 |
| 16060000097538 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 76 | PA736175 | PM736344 |
| 16060000097539 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 77 | PA775290 | PM775576 |
| 16060000097540 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 78 | PA736214 | PM736290 |
| 16060000097541 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 79 | PA736217 | PM736384 |
| 16060000097542 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 80 | PA775294 | PM775580 |
| 16060000097543 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 81 | PA775296 | PM775596 |
| 16060000097544 | L16/dossiers | 16 | 16060000097462 | 16060000097462 | 82 | PA785857 | PM785867 |
| 16060000097578 | L16/dossiers | 16 | 16060000097577 | 16060000097577 | 1 | PA707706 | PM775741 |
| 16060000097585 | L16/dossiers | 16 | 16060000097584 | 16060000097584 | 1 | PA429842 | PM736373 |
| 16060000097586 | L16/dossiers | 16 | 16060000097584 | 16060000097584 | 2 | PA341381 | PM775747 |
| 16060000097587 | L16/dossiers | 16 | 16060000097584 | 16060000097584 | 3 | PA303997 | PM775743 |
| 16060000097588 | L16/dossiers | 16 | 16060000097584 | 16060000097584 | 4 | PA703505 | PM775679 |
| 16060000097589 | L16/dossiers | 16 | 16060000097584 | 16060000097584 | 5 | PA429875 | PM736302 |
| 16060000097596 | L16/dossiers | 16 | 16060000097595 | 16060000097595 | 1 | PA719436 | PM796560 |
| 16060000097600 | L16/dossiers | 16 | 16060000097599 | 16060000097599 | 1 | PA721760 | PM797295 |
| 16060000097604 | L16/dossiers | 16 | 16060000097603 | 16060000097603 | 1 | PA775192 | PM775478 |
| 16060000097611 | L16/dossiers | 16 | 16060000097610 | 16060000097610 | 1 | PA736229 | PM736389 |
| 16060000097621 | L16/dossiers | 16 | 16060000097620 | 16060000097620 | 1 | PA605991 | PM796428 |
| 16060000097628 | L16/dossiers | 16 | 16060000097627 | 16060000097627 | 1 | PA720560 | PM797016 |
| 16060000097635 | L16/dossiers | 16 | 16060000097634 | 16060000097634 | 1 | PA721530 | PM797433 |
| 16060000097656 | L16/dossiers | 16 | 16060000097655 | 16060000097655 | 1 | PA720728 | PM797157 |
| 16060000097663 | L16/dossiers | 16 | 16060000097662 | 16060000097662 | 1 | PA722284 | PM797238 |
| 16060000097695 | L16/dossiers | 16 | 16060000097694 | 16060000097694 | 1 | PA721234 | PM797451 |
| 16060000097705 | L16/dossiers | 16 | 16060000097704 | 16060000097704 | 1 | PA720560 | PM797016 |
| 16060000097712 | L16/dossiers | 16 | 16060000097711 | 16060000097711 | 1 | PA266788 | PM796788 |
| 16060000097719 | L16/dossiers | 16 | 16060000097718 | 16060000097718 | 1 | PA722374 | PM797196 |
| 16060000097726 | L16/dossiers | 16 | 16060000097725 | 16060000097725 | 1 | PA717161 | PM791583 |
| 16060000097727 | L16/dossiers | 16 | 16060000097725 | 16060000097725 | 2 | PA312976 | PM791676 |
| 16060000097728 | L16/dossiers | 16 | 16060000097725 | 16060000097725 | 3 | PA773443 | PM791682 |
| 16060000097760 | L16/dossiers | 16 | 16060000097759 | 16060000097759 | 1 | PA717161 | PM791583 |
| 16060000097761 | L16/dossiers | 16 | 16060000097759 | 16060000097759 | 2 | PA773443 | PM791682 |
| 16060000097762 | L16/dossiers | 16 | 16060000097759 | 16060000097759 | 3 | PA312976 | PM791676 |
| 16060000097793 | L16/dossiers | 16 | 16060000097792 | 16060000097792 | 1 | PA795552 | PM797547 |
| 16060000097800 | L16/dossiers | 16 | 16060000097799 | 16060000097799 | 1 | PA721158 | PM797460 |
| 16060000097805 | L16/dossiers | 16 | 16060000097804 | 16060000097804 | 1 | PA794198 | PM796776 |
| 16060000097812 | L16/dossiers | 16 | 16060000097811 | 16060000097811 | 1 | PA721486 | PM797517 |
| 16060000097819 | L16/dossiers | 16 | 16060000097818 | 16060000097818 | 1 | PA721486 | PM797517 |
| 16060000097826 | L16/dossiers | 16 | 16060000097825 | 16060000097825 | 1 | PA721486 | PM797517 |
| 16060000097833 | L16/dossiers | 16 | 16060000097832 | 16060000097832 | 1 | PA721486 | PM797517 |
| 16060000097840 | L16/dossiers | 16 | 16060000097839 | 16060000097839 | 1 | PA721486 | PM797517 |
| 16060000097847 | L16/dossiers | 16 | 16060000097846 | 16060000097846 | 1 | PA330008 | PM796158 |
| 16060000097854 | L16/dossiers | 16 | 16060000097853 | 16060000097853 | 1 | PA736233 | PM736411 |
| 16060000097864 | L16/dossiers | 16 | 16060000097863 | 16060000097863 | 1 | PA721486 | PM797517 |
| 16060000097871 | L16/dossiers | 16 | 16060000097870 | 16060000097870 | 1 | PA266788 | PM796788 |
| 16060000097878 | L16/dossiers | 16 | 16060000097877 | 16060000097877 | 1 | PA795596 | PM797580 |
| 16060000097885 | L16/dossiers | 16 | 16060000097884 | 16060000097884 | 1 | PA793322 | PM796260 |
| 16060000097892 | L16/dossiers | 16 | 16060000097891 | 16060000097891 | 1 | PA775260 | PM775550 |