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 |
|---|---|---|---|---|---|---|---|
| 14060000116678 | L14/dossiers | 14 | 14060000116676 | 14060000116676 | 2 | PA1268 | PM702961 |
| 14060000116708 | L14/dossiers | 14 | 14060000116707 | 14060000116707 | 1 | PA267622 | PM700712 |
| 14060000116741 | L14/dossiers | 14 | 14060000116740 | 14060000116740 | 1 | PA267622 | PM702957 |
| 14060000116745 | L14/dossiers | 14 | 14060000116744 | 14060000116744 | 1 | PA642759 | PM701660 |
| 14060000116752 | L14/dossiers | 14 | 14060000116751 | 14060000116751 | 1 | PA687214 | PM687217 |
| 14060000116759 | L14/dossiers | 14 | 14060000116758 | 14060000116758 | 1 | PA343623 | PM645408 |
| 14060000116766 | L14/dossiers | 14 | 14060000116765 | 14060000116765 | 1 | PA563 | PM645307 |
| 14060000116773 | L14/dossiers | 14 | 14060000116772 | 14060000116772 | 1 | PA429890 | PM543935 |
| 14060000116797 | L14/dossiers | 14 | 14060000116796 | 14060000116796 | 1 | PA1874 | PM645474 |
| 14060000116804 | L14/dossiers | 14 | 14060000116803 | 14060000116803 | 1 | PA267785 | PM645359 |
| 14060000116808 | L14/dossiers | 14 | 14060000116807 | 14060000116807 | 1 | PA267512 | PM645495 |
| 14060000116815 | L14/dossiers | 14 | 14060000116814 | 14060000116814 | 1 | PA429859 | PM430002 |
| 14060000116850 | L14/dossiers | 14 | 14060000116849 | 14060000116849 | 1 | PA267306 | PM645210 |
| 14060000116870 | L14/dossiers | 14 | 14060000116869 | 14060000116869 | 1 | PA2775 | PM645461 |
| 14060000116877 | L14/dossiers | 14 | 14060000116876 | 14060000116876 | 1 | PA606412 | PM645400 |
| 14060000116892 | L14/dossiers | 14 | 14060000116891 | 14060000116891 | 1 | PA267200 | PM645502 |
| 14060000116903 | L14/dossiers | 14 | 14060000116902 | 14060000116902 | 1 | PA267317 | PM645623 |
| 14060000116910 | L14/dossiers | 14 | 14060000116909 | 14060000116909 | 1 | PA607619 | PM645383 |
| 14060000116917 | L14/dossiers | 14 | 14060000116916 | 14060000116916 | 1 | PA267260 | PM645459 |
| 14060000116924 | L14/dossiers | 14 | 14060000116923 | 14060000116923 | 1 | PA2713 | PM645148 |
| 14060000116931 | L14/dossiers | 14 | 14060000116930 | 14060000116930 | 1 | PA267429 | PM645130 |
| 14060000116938 | L14/dossiers | 14 | 14060000116937 | 14060000116937 | 1 | PA346886 | PM695110 |
| 14060000116949 | L14/dossiers | 14 | 14060000116948 | 14060000116948 | 1 | PA429891 | PM430051 |
| 14060000116956 | L14/dossiers | 14 | 14060000116955 | 14060000116955 | 1 | PA314 | PM645292 |
| 14060000116967 | L14/dossiers | 14 | 14060000116966 | 14060000116966 | 1 | PA267622 | PM702957 |
| 14060000116968 | L14/dossiers | 14 | 14060000116966 | 14060000116966 | 2 | PA702992 | PM702994 |
| 14060000116980 | L14/dossiers | 14 | 14060000116979 | 14060000116979 | 1 | PA606098 | PM645171 |
| 14060000116987 | L14/dossiers | 14 | 14060000116986 | 14060000116986 | 1 | PA266788 | PM645294 |
| 14060000116994 | L14/dossiers | 14 | 14060000116993 | 14060000116993 | 1 | PA551 | PM645487 |
| 14060000117001 | L14/dossiers | 14 | 14060000117000 | 14060000117000 | 1 | PA608495 | PM645569 |
| 14060000117008 | L14/dossiers | 14 | 14060000117007 | 14060000117007 | 1 | PA330684 | PM645497 |
| 14060000117015 | L14/dossiers | 14 | 14060000117014 | 14060000117014 | 1 | PA606478 | PM645457 |
| 14060000117022 | L14/dossiers | 14 | 14060000117021 | 14060000117021 | 1 | PA875 | PM303910 |
| 14060000117034 | L14/dossiers | 14 | 14060000117033 | 14060000117033 | 1 | PA328 | PM653228 |
| 14060000117065 | L14/dossiers | 14 | 14060000117064 | 14060000117064 | 1 | PA2089 | PM645037 |
| 14060000117072 | L14/dossiers | 14 | 14060000117071 | 14060000117071 | 1 | PA2876 | PM645355 |
| 14060000117079 | L14/dossiers | 14 | 14060000117078 | 14060000117078 | 1 | PA267785 | PM645359 |
| 14060000117086 | L14/dossiers | 14 | 14060000117085 | 14060000117085 | 1 | PA606478 | PM645457 |
| 14060000117090 | L14/dossiers | 14 | 14060000117089 | 14060000117089 | 1 | PA1574 | PM645430 |
| 14060000117100 | L14/dossiers | 14 | 14060000117099 | 14060000117099 | 1 | PA2345 | PM645548 |
| 14060000117107 | L14/dossiers | 14 | 14060000117106 | 14060000117106 | 1 | PA335159 | PM645554 |
| 14060000117117 | L14/dossiers | 14 | 14060000117116 | 14060000117116 | 1 | PA1748 | PM645566 |
| 14060000117124 | L14/dossiers | 14 | 14060000117123 | 14060000117123 | 1 | PA785 | PM715797 |
| 14060000117125 | L14/dossiers | 14 | 14060000117123 | 14060000117123 | 2 | PA2679 | PM715809 |
| 14060000117132 | L14/dossiers | 14 | 14060000117131 | 14060000117131 | 1 | PA609764 | PM645323 |
| 14060000117139 | L14/dossiers | 14 | 14060000117138 | 14060000117138 | 1 | PA2971 | PM645392 |
| 14060000117146 | L14/dossiers | 14 | 14060000117145 | 14060000117145 | 1 | PA346886 | PM695110 |
| 14060000117153 | L14/dossiers | 14 | 14060000117152 | 14060000117152 | 1 | PA642759 | PM701660 |
| 14060000117160 | L14/dossiers | 14 | 14060000117159 | 14060000117159 | 1 | PA267762 | PM645455 |
| 14060000117167 | L14/dossiers | 14 | 14060000117166 | 14060000117166 | 1 | PA267042 | PM645368 |