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 |
|---|---|---|---|---|---|---|---|
| 14060000120750 | L14/dossiers | 14 | 14060000120749 | 14060000120749 | 1 | PA266788 | PM645294 |
| 14060000120757 | L14/dossiers | 14 | 14060000120756 | 14060000120756 | 1 | PA267591 | PM645573 |
| 14060000120767 | L14/dossiers | 14 | 14060000120766 | 14060000120766 | 1 | PA551 | PM645487 |
| 14060000120774 | L14/dossiers | 14 | 14060000120773 | 14060000120773 | 1 | PA1874 | PM645474 |
| 14060000120796 | L14/dossiers | 14 | 14060000120795 | 14060000120795 | 1 | PA429852 | PM430021 |
| 14060000120827 | L14/dossiers | 14 | 14060000120826 | 14060000120826 | 1 | PA2073 | PM645207 |
| 14060000120837 | L14/dossiers | 14 | 14060000120836 | 14060000120836 | 1 | PA2073 | PM645207 |
| 14060000120848 | L14/dossiers | 14 | 14060000120847 | 14060000120847 | 1 | PA267801 | PM645153 |
| 14060000120855 | L14/dossiers | 14 | 14060000120854 | 14060000120854 | 1 | PA2377 | PM645591 |
| 14060000120862 | L14/dossiers | 14 | 14060000120861 | 14060000120861 | 1 | PA606693 | PM645542 |
| 14060000120869 | L14/dossiers | 14 | 14060000120868 | 14060000120868 | 1 | PA643069 | PM701218 |
| 14060000120876 | L14/dossiers | 14 | 14060000120875 | 14060000120875 | 1 | PA2048 | PM693013 |
| 14060000120883 | L14/dossiers | 14 | 14060000120882 | 14060000120882 | 1 | PA328 | PM653228 |
| 14060000120884 | L14/dossiers | 14 | 14060000120882 | 14060000120882 | 2 | PA1268 | PM653525 |
| 14060000120916 | L14/dossiers | 14 | 14060000120915 | 14060000120915 | 1 | PA267576 | PM645073 |
| 14060000120923 | L14/dossiers | 14 | 14060000120922 | 14060000120922 | 1 | PA2971 | PM645392 |
| 14060000120930 | L14/dossiers | 14 | 14060000120929 | 14060000120929 | 1 | PA605426 | PM645517 |
| 14060000120937 | L14/dossiers | 14 | 14060000120936 | 14060000120936 | 1 | PA2277 | PM645135 |
| 14060000120944 | L14/dossiers | 14 | 14060000120943 | 14060000120943 | 1 | PA346886 | PM695110 |
| 14060000120951 | L14/dossiers | 14 | 14060000120950 | 14060000120950 | 1 | PA2971 | PM645392 |
| 14060000120958 | L14/dossiers | 14 | 14060000120957 | 14060000120957 | 1 | PA713448 | PM713451 |
| 14060000120965 | L14/dossiers | 14 | 14060000120964 | 14060000120964 | 1 | PA295 | PM645103 |
| 14060000120975 | L14/dossiers | 14 | 14060000120974 | 14060000120974 | 1 | PA607310 | PM645297 |
| 14060000120982 | L14/dossiers | 14 | 14060000120981 | 14060000120981 | 1 | PA267042 | PM645368 |
| 14060000120992 | L14/dossiers | 14 | 14060000120991 | 14060000120991 | 1 | PA267306 | PM645210 |
| 14060000121013 | L14/dossiers | 14 | 14060000121012 | 14060000121012 | 1 | PA687214 | PM687217 |
| 14060000121020 | L14/dossiers | 14 | 14060000121019 | 14060000121019 | 1 | PA1699 | PM645390 |
| 14060000121027 | L14/dossiers | 14 | 14060000121026 | 14060000121026 | 1 | PA267622 | PM702957 |
| 14060000121028 | L14/dossiers | 14 | 14060000121026 | 14060000121026 | 2 | PA2679 | PM702976 |
| 14060000121035 | L14/dossiers | 14 | 14060000121034 | 14060000121034 | 1 | PA528 | PM429957 |
| 14060000121067 | L14/dossiers | 14 | 14060000121066 | 14060000121066 | 1 | PA267429 | PM645130 |
| 14060000121077 | L14/dossiers | 14 | 14060000121076 | 14060000121076 | 1 | PA551 | PM645487 |
| 14060000121081 | L14/dossiers | 14 | 14060000121080 | 14060000121080 | 1 | PA1874 | PM645474 |
| 14060000121088 | L14/dossiers | 14 | 14060000121087 | 14060000121087 | 1 | PA609520 | PM645233 |
| 14060000121095 | L14/dossiers | 14 | 14060000121094 | 14060000121094 | 1 | PA266797 | PM645338 |
| 14060000121102 | L14/dossiers | 14 | 14060000121101 | 14060000121101 | 1 | PA785 | PM715797 |
| 14060000121103 | L14/dossiers | 14 | 14060000121101 | 14060000121101 | 2 | PA2650 | PM715803 |
| 14060000121111 | L14/dossiers | 14 | 14060000121110 | 14060000121110 | 1 | PA609709 | PM645302 |
| 14060000121118 | L14/dossiers | 14 | 14060000121117 | 14060000121117 | 1 | PA267532 | PM645558 |
| 14060000121125 | L14/dossiers | 14 | 14060000121124 | 14060000121124 | 1 | PA687214 | PM687217 |
| 14060000121132 | L14/dossiers | 14 | 14060000121131 | 14060000121131 | 1 | PA606212 | PM645330 |
| 14060000121142 | L14/dossiers | 14 | 14060000121141 | 14060000121141 | 1 | PA608495 | PM645569 |
| 14060000121173 | L14/dossiers | 14 | 14060000121172 | 14060000121172 | 1 | PA330684 | PM645497 |
| 14060000121183 | L14/dossiers | 14 | 14060000121182 | 14060000121182 | 1 | PA2048 | PM645036 |
| 14060000121190 | L14/dossiers | 14 | 14060000121189 | 14060000121189 | 1 | PA1459 | PM645518 |
| 14060000121197 | L14/dossiers | 14 | 14060000121196 | 14060000121196 | 1 | PA342935 | PM645244 |
| 14060000121204 | L14/dossiers | 14 | 14060000121203 | 14060000121203 | 1 | PA610002 | PM645053 |
| 14060000121212 | L14/dossiers | 14 | 14060000121211 | 14060000121211 | 1 | PA330008 | PM645164 |
| 14060000121219 | L14/dossiers | 14 | 14060000121218 | 14060000121218 | 1 | PA266797 | PM645338 |
| 14060000121227 | L14/dossiers | 14 | 14060000121226 | 14060000121226 | 1 | PA2011 | PM645434 |