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 |
|---|---|---|---|---|---|---|---|
| 14060000094417 | L14/dossiers | 14 | 14060000094416 | 14060000094416 | 1 | PA1874 | PM645474 |
| 14060000094424 | L14/dossiers | 14 | 14060000094423 | 14060000094423 | 1 | PA334149 | PM645127 |
| 14060000094431 | L14/dossiers | 14 | 14060000094430 | 14060000094430 | 1 | PA610873 | PM645215 |
| 14060000094445 | L14/dossiers | 14 | 14060000094444 | 14060000094444 | 1 | PA331146 | PM645306 |
| 14060000094456 | L14/dossiers | 14 | 14060000094455 | 14060000094455 | 1 | PA609764 | PM645323 |
| 14060000094463 | L14/dossiers | 14 | 14060000094462 | 14060000094462 | 1 | PA328 | PM653228 |
| 14060000094464 | L14/dossiers | 14 | 14060000094462 | 14060000094462 | 2 | PA2791 | PM653325 |
| 14060000094486 | L14/dossiers | 14 | 14060000094485 | 14060000094485 | 1 | PA415470 | PM415561 |
| 14060000094539 | L14/dossiers | 14 | 14060000094538 | 14060000094538 | 1 | PA267556 | PM645396 |
| 14060000094549 | L14/dossiers | 14 | 14060000094548 | 14060000094548 | 1 | PA1960 | PM645107 |
| 14060000094556 | L14/dossiers | 14 | 14060000094555 | 14060000094555 | 1 | PA267622 | PM702957 |
| 14060000094557 | L14/dossiers | 14 | 14060000094555 | 14060000094555 | 2 | PA2679 | PM702976 |
| 14060000094680 | L14/dossiers | 14 | 14060000094679 | 14060000094679 | 1 | PA334149 | PM645127 |
| 14060000094690 | L14/dossiers | 14 | 14060000094689 | 14060000094689 | 1 | PA785 | PM715797 |
| 14060000094751 | L14/dossiers | 14 | 14060000094750 | 14060000094750 | 1 | PA1498 | PM645080 |
| 14060000094758 | L14/dossiers | 14 | 14060000094757 | 14060000094757 | 1 | PA268019 | PM645116 |
| 14060000094765 | L14/dossiers | 14 | 14060000094764 | 14060000094764 | 1 | PA551 | PM645487 |
| 14060000094785 | L14/dossiers | 14 | 14060000094784 | 14060000094784 | 1 | PA563 | PM645307 |
| 14060000094792 | L14/dossiers | 14 | 14060000094791 | 14060000094791 | 1 | PA415466 | PM415557 |
| 14060000094831 | L14/dossiers | 14 | 14060000094830 | 14060000094830 | 1 | PA2876 | PM645355 |
| 14060000094838 | L14/dossiers | 14 | 14060000094837 | 14060000094837 | 1 | PA1152 | PM645561 |
| 14060000094845 | L14/dossiers | 14 | 14060000094844 | 14060000094844 | 1 | PA267330 | PM645032 |
| 14060000094852 | L14/dossiers | 14 | 14060000094851 | 14060000094851 | 1 | PA746 | PM645154 |
| 14060000094899 | L14/dossiers | 14 | 14060000094898 | 14060000094898 | 1 | PA267622 | PM702957 |
| 14060000094933 | L14/dossiers | 14 | 14060000094932 | 14060000094932 | 1 | PA331481 | PM645136 |
| 14060000094937 | L14/dossiers | 14 | 14060000094936 | 14060000094936 | 1 | PA267762 | PM645455 |
| 14060000094947 | L14/dossiers | 14 | 14060000094946 | 14060000094946 | 1 | PA2796 | PM645520 |
| 14060000094954 | L14/dossiers | 14 | 14060000094953 | 14060000094953 | 1 | PA267622 | PM700712 |
| 14060000094961 | L14/dossiers | 14 | 14060000094960 | 14060000094960 | 1 | PA1874 | PM645474 |
| 14060000094971 | L14/dossiers | 14 | 14060000094970 | 14060000094970 | 1 | PA332305 | PM645562 |
| 14060000094979 | L14/dossiers | 14 | 14060000094978 | 14060000094978 | 1 | PA429839 | PM429953 |
| 14060000094996 | L14/dossiers | 14 | 14060000094995 | 14060000094995 | 1 | PA610667 | PM645269 |
| 14060000095004 | L14/dossiers | 14 | 14060000095003 | 14060000095003 | 1 | PA267673 | PM645249 |
| 14060000095011 | L14/dossiers | 14 | 14060000095010 | 14060000095010 | 1 | PA328 | PM653228 |
| 14060000095012 | L14/dossiers | 14 | 14060000095010 | 14060000095010 | 2 | PA267278 | PM695770 |
| 14060000095013 | L14/dossiers | 14 | 14060000095010 | 14060000095010 | 3 | PA334160 | PM695773 |
| 14060000095087 | L14/dossiers | 14 | 14060000095086 | 14060000095086 | 1 | PA608851 | PM645559 |
| 14060000095094 | L14/dossiers | 14 | 14060000095093 | 14060000095093 | 1 | PA1695 | PM645157 |
| 14060000095112 | L14/dossiers | 14 | 14060000095111 | 14060000095111 | 1 | PA267762 | PM645455 |
| 14060000095126 | L14/dossiers | 14 | 14060000095125 | 14060000095125 | 1 | PA266776 | PM645590 |
| 14060000095133 | L14/dossiers | 14 | 14060000095132 | 14060000095132 | 1 | PA267762 | PM645455 |
| 14060000095146 | L14/dossiers | 14 | 14060000095145 | 14060000095145 | 1 | PA267775 | PM645585 |
| 14060000095153 | L14/dossiers | 14 | 14060000095152 | 14060000095152 | 1 | PA605782 | PM645291 |
| 14060000095173 | L14/dossiers | 14 | 14060000095172 | 14060000095172 | 1 | PA2713 | PM645148 |
| 14060000095180 | L14/dossiers | 14 | 14060000095179 | 14060000095179 | 1 | PA267622 | PM702957 |
| 14060000095181 | L14/dossiers | 14 | 14060000095179 | 14060000095179 | 2 | PA1268 | PM702961 |
| 14060000095214 | L14/dossiers | 14 | 14060000095213 | 14060000095213 | 1 | PA1874 | PM645474 |
| 14060000095224 | L14/dossiers | 14 | 14060000095223 | 14060000095223 | 1 | PA304002 | PM430045 |
| 14060000095233 | L14/dossiers | 14 | 14060000095232 | 14060000095232 | 1 | PA1886 | PM645099 |
| 14060000095240 | L14/dossiers | 14 | 14060000095239 | 14060000095239 | 1 | PA609816 | PM645334 |