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 |
|---|---|---|---|---|---|---|---|
| 15060000176769 | L15/dossiers | 15 | 15060000176768 | 15060000176768 | 1 | PA2377 | PM723550 |
| 15060000176776 | L15/dossiers | 15 | 15060000176775 | 15060000176775 | 1 | PA721968 | PM723436 |
| 15060000176783 | L15/dossiers | 15 | 15060000176782 | 15060000176782 | 1 | PA736226 | PM736280 |
| 15060000176802 | L15/dossiers | 15 | 15060000176801 | 15060000176801 | 1 | PA703539 | PM703693 |
| 15060000176809 | L15/dossiers | 15 | 15060000176808 | 15060000176808 | 1 | PA2116 | PM736339 |
| 15060000176816 | L15/dossiers | 15 | 15060000176815 | 15060000176815 | 1 | PA720210 | PM722892 |
| 15060000176826 | L15/dossiers | 15 | 15060000176825 | 15060000176825 | 1 | PA712014 | PM722984 |
| 15060000176833 | L15/dossiers | 15 | 15060000176832 | 15060000176832 | 1 | PA773441 | PM773491 |
| 15060000176834 | L15/dossiers | 15 | 15060000176832 | 15060000176832 | 2 | PA331481 | PM773459 |
| 15060000176835 | L15/dossiers | 15 | 15060000176832 | 15060000176832 | 3 | PA330357 | PM773447 |
| 15060000177006 | L15/dossiers | 15 | 15060000177005 | 15060000177005 | 1 | PA773441 | PM773491 |
| 15060000177007 | L15/dossiers | 15 | 15060000177005 | 15060000177005 | 2 | PA773443 | PM773510 |
| 15060000177080 | L15/dossiers | 15 | 15060000177079 | 15060000177079 | 1 | PA773441 | PM773491 |
| 15060000177081 | L15/dossiers | 15 | 15060000177079 | 15060000177079 | 2 | PA773443 | PM773510 |
| 15060000177154 | L15/dossiers | 15 | 15060000177153 | 15060000177153 | 1 | PA773441 | PM773491 |
| 15060000177211 | L15/dossiers | 15 | 15060000177210 | 15060000177210 | 1 | PA775212 | PM775500 |
| 15060000177218 | L15/dossiers | 15 | 15060000177217 | 15060000177217 | 1 | PA775272 | PM775562 |
| 15060000177219 | L15/dossiers | 15 | 15060000177217 | 15060000177217 | 2 | PA736201 | PM736347 |
| 15060000177220 | L15/dossiers | 15 | 15060000177217 | 15060000177217 | 3 | PA429891 | PM736329 |
| 15060000177221 | L15/dossiers | 15 | 15060000177217 | 15060000177217 | 4 | PA775180 | PM775466 |
| 15060000177222 | L15/dossiers | 15 | 15060000177217 | 15060000177217 | 5 | PA429845 | PM736278 |
| 15060000177223 | L15/dossiers | 15 | 15060000177217 | 15060000177217 | 6 | PA775252 | PM775558 |
| 15060000177224 | L15/dossiers | 15 | 15060000177217 | 15060000177217 | 7 | PA775214 | PM775498 |
| 15060000177225 | L15/dossiers | 15 | 15060000177217 | 15060000177217 | 8 | PA775224 | PM775512 |
| 15060000177226 | L15/dossiers | 15 | 15060000177217 | 15060000177217 | 9 | PA736177 | PM736318 |
| 15060000177227 | L15/dossiers | 15 | 15060000177217 | 15060000177217 | 10 | PA429866 | PM736287 |
| 15060000177228 | L15/dossiers | 15 | 15060000177217 | 15060000177217 | 11 | PA775262 | PM775548 |
| 15060000177229 | L15/dossiers | 15 | 15060000177217 | 15060000177217 | 12 | PA775282 | PM775584 |
| 15060000177239 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 1 | PA429891 | PM736329 |
| 15060000177240 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 2 | PA429866 | PM736287 |
| 15060000177241 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 3 | PA775282 | PM775584 |
| 15060000177242 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 4 | PA775180 | PM775466 |
| 15060000177243 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 5 | PA429835 | PM736397 |
| 15060000177244 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 6 | PA429845 | PM736278 |
| 15060000177245 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 7 | PA732419 | PM775647 |
| 15060000177246 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 8 | PA736170 | PM736266 |
| 15060000177247 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 9 | PA775214 | PM775498 |
| 15060000177248 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 10 | PA775224 | PM775512 |
| 15060000177249 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 11 | PA304108 | PM736399 |
| 15060000177250 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 12 | PA429887 | PM736274 |
| 15060000177251 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 13 | PA736177 | PM736318 |
| 15060000177252 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 14 | PA775232 | PM775538 |
| 15060000177253 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 15 | PA736248 | PM736269 |
| 15060000177254 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 16 | PA605888 | PM775604 |
| 15060000177255 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 17 | PA736225 | PM736334 |
| 15060000177256 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 18 | PA703536 | PM775719 |
| 15060000177257 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 19 | PA775252 | PM775558 |
| 15060000177258 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 20 | PA429844 | PM736276 |
| 15060000177259 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 21 | PA775262 | PM775548 |
| 15060000177260 | L15/dossiers | 15 | 15060000177238 | 15060000177238 | 22 | PA747422 | PM775753 |