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 |
|---|---|---|---|---|---|---|---|
| 14060000101141 | L14/dossiers | 14 | 14060000101140 | 14060000101140 | 1 | PA267622 | PM702957 |
| 14060000101175 | L14/dossiers | 14 | 14060000101174 | 14060000101174 | 1 | PA785 | PM715797 |
| 14060000101185 | L14/dossiers | 14 | 14060000101184 | 14060000101184 | 1 | PA415482 | PM415579 |
| 14060000101200 | L14/dossiers | 14 | 14060000101199 | 14060000101199 | 1 | PA785 | PM715797 |
| 14060000101208 | L14/dossiers | 14 | 14060000101207 | 14060000101207 | 1 | PA608186 | PM645202 |
| 14060000101227 | L14/dossiers | 14 | 14060000101226 | 14060000101226 | 1 | PA332523 | PM645550 |
| 14060000101234 | L14/dossiers | 14 | 14060000101233 | 14060000101233 | 1 | PA1790 | PM645324 |
| 14060000101241 | L14/dossiers | 14 | 14060000101240 | 14060000101240 | 1 | PA609726 | PM645311 |
| 14060000101248 | L14/dossiers | 14 | 14060000101247 | 14060000101247 | 1 | PA563 | PM645307 |
| 14060000101258 | L14/dossiers | 14 | 14060000101257 | 14060000101257 | 1 | PA608186 | PM645202 |
| 14060000101268 | L14/dossiers | 14 | 14060000101267 | 14060000101267 | 1 | PA1886 | PM645099 |
| 14060000101360 | L14/dossiers | 14 | 14060000101359 | 14060000101359 | 1 | PA267622 | PM702957 |
| 14060000101361 | L14/dossiers | 14 | 14060000101359 | 14060000101359 | 2 | PA328 | PM711554 |
| 14060000101396 | L14/dossiers | 14 | 14060000101395 | 14060000101395 | 1 | PA2952 | PM645464 |
| 14060000101403 | L14/dossiers | 14 | 14060000101402 | 14060000101402 | 1 | PA267622 | PM700712 |
| 14060000101404 | L14/dossiers | 14 | 14060000101402 | 14060000101402 | 2 | PA1268 | PM700715 |
| 14060000101436 | L14/dossiers | 14 | 14060000101435 | 14060000101435 | 1 | PA1263 | PM645432 |
| 14060000101443 | L14/dossiers | 14 | 14060000101442 | 14060000101442 | 1 | PA609332 | PM645147 |
| 14060000101496 | L14/dossiers | 14 | 14060000101495 | 14060000101495 | 1 | PA328 | PM653228 |
| 14060000101497 | L14/dossiers | 14 | 14060000101495 | 14060000101495 | 2 | PA2679 | PM653358 |
| 14060000101573 | L14/dossiers | 14 | 14060000101572 | 14060000101572 | 1 | PA609345 | PM645173 |
| 14060000101580 | L14/dossiers | 14 | 14060000101579 | 14060000101579 | 1 | PA785 | PM715797 |
| 14060000101590 | L14/dossiers | 14 | 14060000101589 | 14060000101589 | 1 | PA609726 | PM645311 |
| 14060000101597 | L14/dossiers | 14 | 14060000101596 | 14060000101596 | 1 | PA267801 | PM645153 |
| 14060000101611 | L14/dossiers | 14 | 14060000101610 | 14060000101610 | 1 | PA309643 | PM645326 |
| 14060000101618 | L14/dossiers | 14 | 14060000101617 | 14060000101617 | 1 | PA230 | PM645553 |
| 14060000101625 | L14/dossiers | 14 | 14060000101624 | 14060000101624 | 1 | PA1886 | PM645099 |
| 14060000101675 | L14/dossiers | 14 | 14060000101674 | 14060000101674 | 1 | PA335054 | PM645614 |
| 14060000101676 | L14/dossiers | 14 | 14060000101674 | 14060000101674 | 2 | PA2667 | PM645429 |
| 14060000101690 | L14/dossiers | 14 | 14060000101689 | 14060000101689 | 1 | PA332228 | PM645546 |
| 14060000101697 | L14/dossiers | 14 | 14060000101696 | 14060000101696 | 1 | PA335054 | PM645614 |
| 14060000101698 | L14/dossiers | 14 | 14060000101696 | 14060000101696 | 2 | PA1012 | PM645168 |
| 14060000101716 | L14/dossiers | 14 | 14060000101715 | 14060000101715 | 1 | PA304082 | PM430056 |
| 14060000101728 | L14/dossiers | 14 | 14060000101727 | 14060000101727 | 1 | PA2971 | PM645392 |
| 14060000101735 | L14/dossiers | 14 | 14060000101734 | 14060000101734 | 1 | PA1886 | PM645099 |
| 14060000101760 | L14/dossiers | 14 | 14060000101759 | 14060000101759 | 1 | PA785 | PM715797 |
| 14060000101768 | L14/dossiers | 14 | 14060000101767 | 14060000101767 | 1 | PA230 | PM645553 |
| 14060000101779 | L14/dossiers | 14 | 14060000101778 | 14060000101778 | 1 | PA785 | PM715797 |
| 14060000101824 | L14/dossiers | 14 | 14060000101823 | 14060000101823 | 1 | PA330240 | PM645425 |
| 14060000101831 | L14/dossiers | 14 | 14060000101830 | 14060000101830 | 1 | PA346886 | PM695110 |
| 14060000101838 | L14/dossiers | 14 | 14060000101837 | 14060000101837 | 1 | PA334843 | PM645589 |
| 14060000101845 | L14/dossiers | 14 | 14060000101844 | 14060000101844 | 1 | PA2257 | PM645201 |
| 14060000101852 | L14/dossiers | 14 | 14060000101851 | 14060000101851 | 1 | PA328 | PM653228 |
| 14060000101853 | L14/dossiers | 14 | 14060000101851 | 14060000101851 | 2 | PA1268 | PM653525 |
| 14060000101882 | L14/dossiers | 14 | 14060000101881 | 14060000101881 | 1 | PA605349 | PM645483 |
| 14060000101889 | L14/dossiers | 14 | 14060000101888 | 14060000101888 | 1 | PA2257 | PM645201 |
| 14060000101896 | L14/dossiers | 14 | 14060000101895 | 14060000101895 | 1 | PA1874 | PM645474 |
| 14060000101906 | L14/dossiers | 14 | 14060000101905 | 14060000101905 | 1 | PA607846 | PM645441 |
| 14060000101913 | L14/dossiers | 14 | 14060000101912 | 14060000101912 | 1 | PA1886 | PM645099 |
| 14060000101971 | L14/dossiers | 14 | 14060000101970 | 14060000101970 | 1 | PA1886 | PM645099 |