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 |
|---|---|---|---|---|---|---|---|
| 14060000136676 | L14/dossiers | 14 | 14060000136675 | 14060000136675 | 1 | PA551 | PM645487 |
| 14060000136683 | L14/dossiers | 14 | 14060000136682 | 14060000136682 | 1 | PA335054 | PM645614 |
| 14060000136696 | L14/dossiers | 14 | 14060000136695 | 14060000136695 | 1 | PA689 | PM645113 |
| 14060000136703 | L14/dossiers | 14 | 14060000136702 | 14060000136702 | 1 | PA267306 | PM645210 |
| 14060000136710 | L14/dossiers | 14 | 14060000136709 | 14060000136709 | 1 | PA609726 | PM645311 |
| 14060000136717 | L14/dossiers | 14 | 14060000136716 | 14060000136716 | 1 | PA267622 | PM702957 |
| 14060000136718 | L14/dossiers | 14 | 14060000136716 | 14060000136716 | 2 | PA2650 | PM711559 |
| 14060000136726 | L14/dossiers | 14 | 14060000136725 | 14060000136725 | 1 | PA266788 | PM645294 |
| 14060000136730 | L14/dossiers | 14 | 14060000136729 | 14060000136729 | 1 | PA267785 | PM645359 |
| 14060000136731 | L14/dossiers | 14 | 14060000136729 | 14060000136729 | 2 | PA1445 | PM645563 |
| 14060000136738 | L14/dossiers | 14 | 14060000136737 | 14060000136737 | 1 | PA607489 | PM645366 |
| 14060000136748 | L14/dossiers | 14 | 14060000136747 | 14060000136747 | 1 | PA267622 | PM702957 |
| 14060000136780 | L14/dossiers | 14 | 14060000136779 | 14060000136779 | 1 | PA2011 | PM645434 |
| 14060000136787 | L14/dossiers | 14 | 14060000136786 | 14060000136786 | 1 | PA429881 | PM430053 |
| 14060000136804 | L14/dossiers | 14 | 14060000136803 | 14060000136803 | 1 | PA267622 | PM702957 |
| 14060000136805 | L14/dossiers | 14 | 14060000136803 | 14060000136803 | 2 | PA328 | PM711554 |
| 14060000136837 | L14/dossiers | 14 | 14060000136836 | 14060000136836 | 1 | PA2664 | PM645139 |
| 14060000136847 | L14/dossiers | 14 | 14060000136846 | 14060000136846 | 1 | PA267785 | PM645359 |
| 14060000136854 | L14/dossiers | 14 | 14060000136853 | 14060000136853 | 1 | PA267492 | PM645465 |
| 14060000136861 | L14/dossiers | 14 | 14060000136860 | 14060000136860 | 1 | PA2952 | PM645464 |
| 14060000136868 | L14/dossiers | 14 | 14060000136867 | 14060000136867 | 1 | PA608416 | PM645586 |
| 14060000136875 | L14/dossiers | 14 | 14060000136874 | 14060000136874 | 1 | PA267260 | PM645459 |
| 14060000136882 | L14/dossiers | 14 | 14060000136881 | 14060000136881 | 1 | PA563 | PM645307 |
| 14060000136889 | L14/dossiers | 14 | 14060000136888 | 14060000136888 | 1 | PA267622 | PM702957 |
| 14060000136890 | L14/dossiers | 14 | 14060000136888 | 14060000136888 | 2 | PA331594 | PM711625 |
| 14060000136897 | L14/dossiers | 14 | 14060000136896 | 14060000136896 | 1 | PA328 | PM653228 |
| 14060000136935 | L14/dossiers | 14 | 14060000136934 | 14060000136934 | 1 | PA2538 | PM703570 |
| 14060000136968 | L14/dossiers | 14 | 14060000136967 | 14060000136967 | 1 | PA606478 | PM645457 |
| 14060000136975 | L14/dossiers | 14 | 14060000136974 | 14060000136974 | 1 | PA1695 | PM645157 |
| 14060000136993 | L14/dossiers | 14 | 14060000136992 | 14060000136992 | 1 | PA267622 | PM702957 |
| 14060000136994 | L14/dossiers | 14 | 14060000136992 | 14060000136992 | 2 | PA328 | PM711554 |
| 14060000137025 | L14/dossiers | 14 | 14060000137024 | 14060000137024 | 1 | PA429867 | PM429921 |
| 14060000137081 | L14/dossiers | 14 | 14060000137080 | 14060000137080 | 1 | PA346886 | PM695110 |
| 14060000137088 | L14/dossiers | 14 | 14060000137087 | 14060000137087 | 1 | PA330008 | PM645164 |
| 14060000137095 | L14/dossiers | 14 | 14060000137094 | 14060000137094 | 1 | PA336316 | PM645298 |
| 14060000137108 | L14/dossiers | 14 | 14060000137107 | 14060000137107 | 1 | PA605694 | PM645416 |
| 14060000137128 | L14/dossiers | 14 | 14060000137127 | 14060000137127 | 1 | PA609016 | PM645074 |
| 14060000137132 | L14/dossiers | 14 | 14060000137131 | 14060000137131 | 1 | PA267551 | PM645372 |
| 14060000137143 | L14/dossiers | 14 | 14060000137142 | 14060000137142 | 1 | PA267492 | PM645465 |
| 14060000137150 | L14/dossiers | 14 | 14060000137149 | 14060000137149 | 1 | PA267622 | PM702957 |
| 14060000137160 | L14/dossiers | 14 | 14060000137159 | 14060000137159 | 1 | PA605991 | PM645081 |
| 14060000137167 | L14/dossiers | 14 | 14060000137166 | 14060000137166 | 1 | PA328 | PM653228 |
| 14060000137168 | L14/dossiers | 14 | 14060000137166 | 14060000137166 | 2 | PA2240 | PM653295 |
| 14060000137175 | L14/dossiers | 14 | 14060000137174 | 14060000137174 | 1 | PA709315 | PM709318 |
| 14060000137182 | L14/dossiers | 14 | 14060000137181 | 14060000137181 | 1 | PA328 | PM653228 |
| 14060000137183 | L14/dossiers | 14 | 14060000137181 | 14060000137181 | 2 | PA1268 | PM653525 |
| 14060000137212 | L14/dossiers | 14 | 14060000137211 | 14060000137211 | 1 | PA2815 | PM645514 |
| 14060000137219 | L14/dossiers | 14 | 14060000137218 | 14060000137218 | 1 | PA267285 | PM645140 |
| 14060000137232 | L14/dossiers | 14 | 14060000137231 | 14060000137231 | 1 | PA346886 | PM695110 |