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 |
|---|---|---|---|---|---|---|---|
| 16060000115974 | L16/dossiers | 16 | 16060000115973 | 16060000115973 | 1 | PA736244 | PM736333 |
| 16060000115981 | L16/dossiers | 16 | 16060000115980 | 16060000115980 | 1 | PA304108 | PM736399 |
| 16060000115988 | L16/dossiers | 16 | 16060000115987 | 16060000115987 | 1 | PA775170 | PM775468 |
| 16060000115995 | L16/dossiers | 16 | 16060000115994 | 16060000115994 | 1 | PA795912 | PM797751 |
| 16060000115999 | L16/dossiers | 16 | 16060000115998 | 16060000115998 | 1 | PA429884 | PM736358 |
| 16060000116054 | L16/dossiers | 16 | 16060000116053 | 16060000116053 | 1 | PA775258 | PM775544 |
| 16060000116055 | L16/dossiers | 16 | 16060000116053 | 16060000116053 | 2 | PA415495 | PM775635 |
| 16060000116066 | L16/dossiers | 16 | 16060000116065 | 16060000116065 | 1 | PA793548 | PM796398 |
| 16060000116070 | L16/dossiers | 16 | 16060000116069 | 16060000116069 | 1 | PA736196 | PM829865 |
| 16060000116098 | L16/dossiers | 16 | 16060000116097 | 16060000116097 | 1 | PA703485 | PM775811 |
| 16060000116105 | L16/dossiers | 16 | 16060000116104 | 16060000116104 | 1 | PA794894 | PM797181 |
| 16060000116112 | L16/dossiers | 16 | 16060000116111 | 16060000116111 | 1 | PA720892 | PM797520 |
| 16060000116120 | L16/dossiers | 16 | 16060000116119 | 16060000116119 | 1 | PA720892 | PM797520 |
| 16060000116128 | L16/dossiers | 16 | 16060000116127 | 16060000116127 | 1 | PA775252 | PM775558 |
| 16060000116138 | L16/dossiers | 16 | 16060000116137 | 16060000116137 | 1 | PA775236 | PM775542 |
| 16060000116145 | L16/dossiers | 16 | 16060000116144 | 16060000116144 | 1 | PA793548 | PM796398 |
| 16060000116152 | L16/dossiers | 16 | 16060000116151 | 16060000116151 | 1 | PA330240 | PM796155 |
| 16060000116156 | L16/dossiers | 16 | 16060000116155 | 16060000116155 | 1 | PA793872 | PM796581 |
| 16060000116161 | L16/dossiers | 16 | 16060000116160 | 16060000116160 | 1 | PA415446 | PM775783 |
| 16060000116168 | L16/dossiers | 16 | 16060000116167 | 16060000116167 | 1 | PA415446 | PM775783 |
| 16060000116175 | L16/dossiers | 16 | 16060000116174 | 16060000116174 | 1 | PA610654 | PM797724 |
| 16060000116193 | L16/dossiers | 16 | 16060000116192 | 16060000116192 | 1 | PA717161 | PM791583 |
| 16060000116194 | L16/dossiers | 16 | 16060000116192 | 16060000116192 | 2 | PA429846 | PM801952 |
| 16060000116201 | L16/dossiers | 16 | 16060000116200 | 16060000116200 | 1 | PA717161 | PM791583 |
| 16060000116202 | L16/dossiers | 16 | 16060000116200 | 16060000116200 | 2 | PA429846 | PM801952 |
| 16060000116209 | L16/dossiers | 16 | 16060000116208 | 16060000116208 | 1 | PA717161 | PM791583 |
| 16060000116210 | L16/dossiers | 16 | 16060000116208 | 16060000116208 | 2 | PA331481 | PM791666 |
| 16060000116226 | L16/dossiers | 16 | 16060000116225 | 16060000116225 | 1 | PA703521 | PM775707 |
| 16060000116248 | L16/dossiers | 16 | 16060000116247 | 16060000116247 | 1 | PA775248 | PM775554 |
| 16060000116273 | L16/dossiers | 16 | 16060000116272 | 16060000116272 | 1 | PA736196 | PM829865 |
| 16060000116280 | L16/dossiers | 16 | 16060000116279 | 16060000116279 | 1 | PA758716 | PM775771 |
| 16060000116281 | L16/dossiers | 16 | 16060000116279 | 16060000116279 | 2 | PA758716 | PM775771 |
| 16060000116282 | L16/dossiers | 16 | 16060000116279 | 16060000116279 | 3 | PA703541 | PM775725 |
| 16060000116289 | L16/dossiers | 16 | 16060000116288 | 16060000116288 | 1 | PA793872 | PM796581 |
| 16060000116294 | L16/dossiers | 16 | 16060000116293 | 16060000116293 | 1 | PA795310 | PM797415 |
| 16060000116301 | L16/dossiers | 16 | 16060000116300 | 16060000116300 | 1 | PA718884 | PM796218 |
| 16060000116308 | L16/dossiers | 16 | 16060000116307 | 16060000116307 | 1 | PA718884 | PM796218 |
| 16060000116315 | L16/dossiers | 16 | 16060000116314 | 16060000116314 | 1 | PA718884 | PM796218 |
| 16060000116322 | L16/dossiers | 16 | 16060000116321 | 16060000116321 | 1 | PA721328 | PM797250 |
| 16060000116360 | L16/dossiers | 16 | 16060000116359 | 16060000116359 | 1 | PA712014 | PM802637 |
| 16060000116367 | L16/dossiers | 16 | 16060000116366 | 16060000116366 | 1 | PA722284 | PM797238 |
| 16060000116374 | L16/dossiers | 16 | 16060000116373 | 16060000116373 | 1 | PA793342 | PM796269 |
| 16060000116381 | L16/dossiers | 16 | 16060000116380 | 16060000116380 | 1 | PA795266 | PM803280 |
| 16060000116391 | L16/dossiers | 16 | 16060000116390 | 16060000116390 | 1 | PA330008 | PM796158 |
| 16060000116398 | L16/dossiers | 16 | 16060000116397 | 16060000116397 | 1 | PA608416 | PM797133 |
| 16060000116405 | L16/dossiers | 16 | 16060000116404 | 16060000116404 | 1 | PA342415 | PM796659 |
| 16060000116426 | L16/dossiers | 16 | 16060000116425 | 16060000116425 | 1 | PA795778 | PM797682 |
| 16060000116433 | L16/dossiers | 16 | 16060000116432 | 16060000116432 | 1 | PA794118 | PM796725 |
| 16060000116440 | L16/dossiers | 16 | 16060000116439 | 16060000116439 | 1 | PA718784 | PM796266 |
| 16060000116447 | L16/dossiers | 16 | 16060000116446 | 16060000116446 | 1 | PA795516 | PM797529 |