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 |
|---|---|---|---|---|---|---|---|
| 14060000129766 | L14/dossiers | 14 | 14060000129765 | 14060000129765 | 1 | PA346886 | PM695110 |
| 14060000129773 | L14/dossiers | 14 | 14060000129772 | 14060000129772 | 1 | PA267622 | PM702957 |
| 14060000129774 | L14/dossiers | 14 | 14060000129772 | 14060000129772 | 2 | PA336175 | PM702983 |
| 14060000129781 | L14/dossiers | 14 | 14060000129780 | 14060000129780 | 1 | PA2257 | PM645201 |
| 14060000129788 | L14/dossiers | 14 | 14060000129787 | 14060000129787 | 1 | PA328 | PM653228 |
| 14060000129818 | L14/dossiers | 14 | 14060000129817 | 14060000129817 | 1 | PA609726 | PM645311 |
| 14060000129825 | L14/dossiers | 14 | 14060000129824 | 14060000129824 | 1 | PA266788 | PM645294 |
| 14060000129832 | L14/dossiers | 14 | 14060000129831 | 14060000129831 | 1 | PA2098 | PM645351 |
| 14060000129839 | L14/dossiers | 14 | 14060000129838 | 14060000129838 | 1 | PA2796 | PM645520 |
| 14060000129846 | L14/dossiers | 14 | 14060000129845 | 14060000129845 | 1 | PA606478 | PM645457 |
| 14060000129853 | L14/dossiers | 14 | 14060000129852 | 14060000129852 | 1 | PA267429 | PM645130 |
| 14060000129860 | L14/dossiers | 14 | 14060000129859 | 14060000129859 | 1 | PA1874 | PM645474 |
| 14060000129867 | L14/dossiers | 14 | 14060000129866 | 14060000129866 | 1 | PA267622 | PM702957 |
| 14060000129868 | L14/dossiers | 14 | 14060000129866 | 14060000129866 | 2 | PA1268 | PM702961 |
| 14060000129898 | L14/dossiers | 14 | 14060000129897 | 14060000129897 | 1 | PA346886 | PM695110 |
| 14060000129908 | L14/dossiers | 14 | 14060000129907 | 14060000129907 | 1 | PA346886 | PM695110 |
| 14060000129915 | L14/dossiers | 14 | 14060000129914 | 14060000129914 | 1 | PA785 | PM715797 |
| 14060000129922 | L14/dossiers | 14 | 14060000129921 | 14060000129921 | 1 | PA2690 | PM645458 |
| 14060000129929 | L14/dossiers | 14 | 14060000129928 | 14060000129928 | 1 | PA267042 | PM645368 |
| 14060000129936 | L14/dossiers | 14 | 14060000129935 | 14060000129935 | 1 | PA643069 | PM701218 |
| 14060000129940 | L14/dossiers | 14 | 14060000129939 | 14060000129939 | 1 | PA267622 | PM700712 |
| 14060000129941 | L14/dossiers | 14 | 14060000129939 | 14060000129939 | 2 | PA1268 | PM700715 |
| 14060000129972 | L14/dossiers | 14 | 14060000129971 | 14060000129971 | 1 | PA267622 | PM702957 |
| 14060000129982 | L14/dossiers | 14 | 14060000129981 | 14060000129981 | 1 | PA1206 | PM645054 |
| 14060000129989 | L14/dossiers | 14 | 14060000129988 | 14060000129988 | 1 | PA330788 | PM645510 |
| 14060000129996 | L14/dossiers | 14 | 14060000129995 | 14060000129995 | 1 | PA267622 | PM700712 |
| 14060000129997 | L14/dossiers | 14 | 14060000129995 | 14060000129995 | 2 | PA1268 | PM700715 |
| 14060000130031 | L14/dossiers | 14 | 14060000130030 | 14060000130030 | 1 | PA267622 | PM702957 |
| 14060000130032 | L14/dossiers | 14 | 14060000130030 | 14060000130030 | 2 | PA711558 | PM711571 |
| 14060000130066 | L14/dossiers | 14 | 14060000130065 | 14060000130065 | 1 | PA422119 | PM645183 |
| 14060000130073 | L14/dossiers | 14 | 14060000130072 | 14060000130072 | 1 | PA2971 | PM645392 |
| 14060000130080 | L14/dossiers | 14 | 14060000130079 | 14060000130079 | 1 | PA2502 | PM703555 |
| 14060000130081 | L14/dossiers | 14 | 14060000130079 | 14060000130079 | 2 | PA429858 | PM429958 |
| 14060000130118 | L14/dossiers | 14 | 14060000130117 | 14060000130117 | 1 | PA267165 | PM645360 |
| 14060000130136 | L14/dossiers | 14 | 14060000130135 | 14060000130135 | 1 | PA227076 | PM429906 |
| 14060000130160 | L14/dossiers | 14 | 14060000130159 | 14060000130159 | 1 | PA1585 | PM645094 |
| 14060000130167 | L14/dossiers | 14 | 14060000130166 | 14060000130166 | 1 | PA608662 | PM645592 |
| 14060000130177 | L14/dossiers | 14 | 14060000130176 | 14060000130176 | 1 | PA267622 | PM702957 |
| 14060000130178 | L14/dossiers | 14 | 14060000130176 | 14060000130176 | 2 | PA328 | PM711554 |
| 14060000130211 | L14/dossiers | 14 | 14060000130210 | 14060000130210 | 1 | PA2952 | PM645464 |
| 14060000130218 | L14/dossiers | 14 | 14060000130217 | 14060000130217 | 1 | PA429881 | PM430053 |
| 14060000130236 | L14/dossiers | 14 | 14060000130235 | 14060000130235 | 1 | PA267266 | PM645489 |
| 14060000130243 | L14/dossiers | 14 | 14060000130242 | 14060000130242 | 1 | PA328 | PM653228 |
| 14060000130244 | L14/dossiers | 14 | 14060000130242 | 14060000130242 | 2 | PA335999 | PM653292 |
| 14060000130251 | L14/dossiers | 14 | 14060000130250 | 14060000130250 | 1 | PA998 | PM645034 |
| 14060000130258 | L14/dossiers | 14 | 14060000130257 | 14060000130257 | 1 | PA332747 | PM645155 |
| 14060000130265 | L14/dossiers | 14 | 14060000130264 | 14060000130264 | 1 | PA267622 | PM700712 |
| 14060000130266 | L14/dossiers | 14 | 14060000130264 | 14060000130264 | 2 | PA2679 | PM700726 |
| 14060000130337 | L14/dossiers | 14 | 14060000130336 | 14060000130336 | 1 | PA267246 | PM645340 |
| 14060000130344 | L14/dossiers | 14 | 14060000130343 | 14060000130343 | 1 | PA429836 | PM430049 |