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 |
|---|---|---|---|---|---|---|---|
| 14060000135395 | L14/dossiers | 14 | 14060000135394 | 14060000135394 | 1 | PA328 | PM653228 |
| 14060000135396 | L14/dossiers | 14 | 14060000135394 | 14060000135394 | 2 | PA1268 | PM653525 |
| 14060000135428 | L14/dossiers | 14 | 14060000135427 | 14060000135427 | 1 | PA337568 | PM645287 |
| 14060000135436 | L14/dossiers | 14 | 14060000135435 | 14060000135435 | 1 | PA610860 | PM645212 |
| 14060000135443 | L14/dossiers | 14 | 14060000135442 | 14060000135442 | 1 | PA266788 | PM645294 |
| 14060000135450 | L14/dossiers | 14 | 14060000135449 | 14060000135449 | 1 | PA608826 | PM645556 |
| 14060000135457 | L14/dossiers | 14 | 14060000135456 | 14060000135456 | 1 | PA2792 | PM645308 |
| 14060000135474 | L14/dossiers | 14 | 14060000135473 | 14060000135473 | 1 | PA2377 | PM645591 |
| 14060000135481 | L14/dossiers | 14 | 14060000135480 | 14060000135480 | 1 | PA1699 | PM645390 |
| 14060000135488 | L14/dossiers | 14 | 14060000135487 | 14060000135487 | 1 | PA267622 | PM702957 |
| 14060000135529 | L14/dossiers | 14 | 14060000135528 | 14060000135528 | 1 | PA2056 | PM415567 |
| 14060000135530 | L14/dossiers | 14 | 14060000135528 | 14060000135528 | 2 | PA270 | PM429986 |
| 14060000135555 | L14/dossiers | 14 | 14060000135554 | 14060000135554 | 1 | PA267306 | PM645210 |
| 14060000135565 | L14/dossiers | 14 | 14060000135564 | 14060000135564 | 1 | PA267743 | PM645058 |
| 14060000135572 | L14/dossiers | 14 | 14060000135571 | 14060000135571 | 1 | PA2774 | PM429910 |
| 14060000135604 | L14/dossiers | 14 | 14060000135603 | 14060000135603 | 1 | PA2713 | PM645148 |
| 14060000135617 | L14/dossiers | 14 | 14060000135616 | 14060000135616 | 1 | PA335054 | PM645614 |
| 14060000135627 | L14/dossiers | 14 | 14060000135626 | 14060000135626 | 1 | PA267622 | PM702957 |
| 14060000135628 | L14/dossiers | 14 | 14060000135626 | 14060000135626 | 2 | PA2791 | PM702981 |
| 14060000135635 | L14/dossiers | 14 | 14060000135634 | 14060000135634 | 1 | PA610002 | PM645053 |
| 14060000135665 | L14/dossiers | 14 | 14060000135664 | 14060000135664 | 1 | PA1886 | PM645099 |
| 14060000135675 | L14/dossiers | 14 | 14060000135674 | 14060000135674 | 1 | PA429858 | PM429958 |
| 14060000135697 | L14/dossiers | 14 | 14060000135696 | 14060000135696 | 1 | PA1654 | PM703255 |
| 14060000135698 | L14/dossiers | 14 | 14060000135696 | 14060000135696 | 2 | PA2791 | PM653325 |
| 14060000135714 | L14/dossiers | 14 | 14060000135713 | 14060000135713 | 1 | PA266788 | PM645294 |
| 14060000135721 | L14/dossiers | 14 | 14060000135720 | 14060000135720 | 1 | PA346886 | PM695110 |
| 14060000135728 | L14/dossiers | 14 | 14060000135727 | 14060000135727 | 1 | PA2250 | PM645539 |
| 14060000135735 | L14/dossiers | 14 | 14060000135734 | 14060000135734 | 1 | PA1020 | PM645057 |
| 14060000135742 | L14/dossiers | 14 | 14060000135741 | 14060000135741 | 1 | PA1152 | PM645561 |
| 14060000135749 | L14/dossiers | 14 | 14060000135748 | 14060000135748 | 1 | PA267797 | PM645350 |
| 14060000135759 | L14/dossiers | 14 | 14060000135758 | 14060000135758 | 1 | PA429864 | PM429937 |
| 14060000135801 | L14/dossiers | 14 | 14060000135800 | 14060000135800 | 1 | PA267743 | PM645058 |
| 14060000135811 | L14/dossiers | 14 | 14060000135810 | 14060000135810 | 1 | PA304079 | PM429925 |
| 14060000135821 | L14/dossiers | 14 | 14060000135820 | 14060000135820 | 1 | PA609332 | PM645147 |
| 14060000135828 | L14/dossiers | 14 | 14060000135827 | 14060000135827 | 1 | PA304086 | PM430059 |
| 14060000135852 | L14/dossiers | 14 | 14060000135851 | 14060000135851 | 1 | PA267622 | PM700712 |
| 14060000135885 | L14/dossiers | 14 | 14060000135884 | 14060000135884 | 1 | PA267178 | PM645473 |
| 14060000135892 | L14/dossiers | 14 | 14060000135891 | 14060000135891 | 1 | PA267785 | PM645359 |
| 14060000135896 | L14/dossiers | 14 | 14060000135895 | 14060000135895 | 1 | PA267450 | PM645452 |
| 14060000135903 | L14/dossiers | 14 | 14060000135902 | 14060000135902 | 1 | PA1886 | PM645099 |
| 14060000135963 | L14/dossiers | 14 | 14060000135962 | 14060000135962 | 1 | PA267260 | PM645459 |
| 14060000135970 | L14/dossiers | 14 | 14060000135969 | 14060000135969 | 1 | PA267151 | PM645165 |
| 14060000135977 | L14/dossiers | 14 | 14060000135976 | 14060000135976 | 1 | PA267492 | PM645465 |
| 14060000135987 | L14/dossiers | 14 | 14060000135986 | 14060000135986 | 1 | PA2229 | PM645205 |
| 14060000135994 | L14/dossiers | 14 | 14060000135993 | 14060000135993 | 1 | PA328 | PM653228 |
| 14060000135995 | L14/dossiers | 14 | 14060000135993 | 14060000135993 | 2 | PA2679 | PM653358 |
| 14060000136054 | L14/dossiers | 14 | 14060000136053 | 14060000136053 | 1 | PA606712 | PM645549 |
| 14060000136061 | L14/dossiers | 14 | 14060000136060 | 14060000136060 | 1 | PA606478 | PM645457 |
| 14060000136068 | L14/dossiers | 14 | 14060000136067 | 14060000136067 | 1 | PA1874 | PM645474 |
| 14060000136075 | L14/dossiers | 14 | 14060000136074 | 14060000136074 | 1 | PA267178 | PM645473 |