dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 17060000121115 | L17/dossiers | 17 | 17060000121104 | 17060000121104 | 11 | PA429886 | PM829757 |
| 17060000121116 | L17/dossiers | 17 | 17060000121104 | 17060000121104 | 12 | PA736173 | PM829799 |
| 17060000121117 | L17/dossiers | 17 | 17060000121104 | 17060000121104 | 13 | PA775246 | PM775532 |
| 17060000121118 | L17/dossiers | 17 | 17060000121104 | 17060000121104 | 14 | PA828002 | PM828856 |
| 17060000121119 | L17/dossiers | 17 | 17060000121104 | 17060000121104 | 15 | PA736243 | PM829929 |
| 17060000121120 | L17/dossiers | 17 | 17060000121104 | 17060000121104 | 16 | PA736175 | PM829795 |
| 17060000121121 | L17/dossiers | 17 | 17060000121104 | 17060000121104 | 17 | PA775296 | PM775596 |
| 17060000121122 | L17/dossiers | 17 | 17060000121104 | 17060000121104 | 18 | PA828020 | PM828864 |
| 17060000121129 | L17/dossiers | 17 | 17060000121128 | 17060000121128 | 1 | PA794354 | PM842960 |
| 17060000121133 | L17/dossiers | 17 | 17060000121132 | 17060000121132 | 1 | PA720644 | PM843158 |
| 17060000121140 | L17/dossiers | 17 | 17060000121139 | 17060000121139 | 1 | PA775178 | PM775460 |
| 17060000121147 | L17/dossiers | 17 | 17060000121146 | 17060000121146 | 1 | PA817203 | PM842978 |
| 17060000121151 | L17/dossiers | 17 | 17060000121150 | 17060000121150 | 1 | PA606375 | PM775602 |
| 17060000121152 | L17/dossiers | 17 | 17060000121150 | 17060000121150 | 2 | PA827976 | PM828724 |
| 17060000121171 | L17/dossiers | 17 | 17060000121170 | 17060000121170 | 1 | PA703492 | PM775657 |
| 17060000121178 | L17/dossiers | 17 | 17060000121177 | 17060000121177 | 1 | PA708632 | PM775667 |
| 17060000121198 | L17/dossiers | 17 | 17060000121197 | 17060000121197 | 1 | PA736224 | PM829913 |
| 17060000121205 | L17/dossiers | 17 | 17060000121204 | 17060000121204 | 1 | PA794686 | PM843080 |
| 17060000121212 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 1 | PA828004 | PM828838 |
| 17060000121213 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 2 | PA775180 | PM775466 |
| 17060000121214 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 3 | PA827904 | PM828514 |
| 17060000121215 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 4 | PA429845 | PM829729 |
| 17060000121216 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 5 | PA775214 | PM775498 |
| 17060000121217 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 6 | PA775224 | PM775512 |
| 17060000121218 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 7 | PA736177 | PM829835 |
| 17060000121219 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 8 | PA827946 | PM828614 |
| 17060000121220 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 9 | PA827950 | PM828598 |
| 17060000121221 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 10 | PA775252 | PM775558 |
| 17060000121222 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 11 | PA827968 | PM828750 |
| 17060000121223 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 12 | PA827978 | PM828730 |
| 17060000121224 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 13 | PA775272 | PM775562 |
| 17060000121225 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 14 | PA775282 | PM775584 |
| 17060000121226 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 15 | PA828000 | PM828850 |
| 17060000121227 | L17/dossiers | 17 | 17060000121211 | 17060000121211 | 16 | PA785857 | PM785867 |
| 17060000121234 | L17/dossiers | 17 | 17060000121233 | 17060000121233 | 1 | PA793254 | PM842432 |
| 17060000121238 | L17/dossiers | 17 | 17060000121237 | 17060000121237 | 1 | PA774960 | PM840417 |
| 17060000121255 | L17/dossiers | 17 | 17060000121254 | 17060000121254 | 1 | PA794038 | PM842783 |
| 17060000121259 | L17/dossiers | 17 | 17060000121258 | 17060000121258 | 1 | PA721336 | PM843281 |
| 17060000121266 | L17/dossiers | 17 | 17060000121265 | 17060000121265 | 1 | PA720256 | PM843041 |
| 17060000121273 | L17/dossiers | 17 | 17060000121272 | 17060000121272 | 1 | PA720256 | PM843041 |
| 17060000121280 | L17/dossiers | 17 | 17060000121279 | 17060000121279 | 1 | PA569 | PM843512 |
| 17060000121287 | L17/dossiers | 17 | 17060000121286 | 17060000121286 | 1 | PA720256 | PM843041 |
| 17060000121294 | L17/dossiers | 17 | 17060000121293 | 17060000121293 | 1 | PA720256 | PM843041 |
| 17060000121301 | L17/dossiers | 17 | 17060000121300 | 17060000121300 | 1 | PA335999 | PM843494 |
| 17060000121308 | L17/dossiers | 17 | 17060000121307 | 17060000121307 | 1 | PA842187 | PM843704 |
| 17060000121315 | L17/dossiers | 17 | 17060000121314 | 17060000121314 | 1 | PA605694 | PM842609 |
| 17060000121322 | L17/dossiers | 17 | 17060000121321 | 17060000121321 | 1 | PA718850 | PM842411 |
| 17060000121329 | L17/dossiers | 17 | 17060000121328 | 17060000121328 | 1 | PA721336 | PM843281 |
| 17060000121336 | L17/dossiers | 17 | 17060000121335 | 17060000121335 | 1 | PA266797 | PM843071 |
| 17060000121343 | L17/dossiers | 17 | 17060000121342 | 17060000121342 | 1 | PA793708 | PM842525 |