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 |
|---|---|---|---|---|---|---|---|
| 15060000172792 | L15/dossiers | 15 | 15060000172787 | 15060000172787 | 5 | PA775224 | PM775512 |
| 15060000172793 | L15/dossiers | 15 | 15060000172787 | 15060000172787 | 6 | PA736177 | PM736318 |
| 15060000172794 | L15/dossiers | 15 | 15060000172787 | 15060000172787 | 7 | PA429866 | PM736287 |
| 15060000172795 | L15/dossiers | 15 | 15060000172787 | 15060000172787 | 8 | PA775252 | PM775558 |
| 15060000172796 | L15/dossiers | 15 | 15060000172787 | 15060000172787 | 9 | PA775262 | PM775548 |
| 15060000172797 | L15/dossiers | 15 | 15060000172787 | 15060000172787 | 10 | PA775282 | PM775584 |
| 15060000172798 | L15/dossiers | 15 | 15060000172787 | 15060000172787 | 11 | PA736201 | PM736347 |
| 15060000172808 | L15/dossiers | 15 | 15060000172807 | 15060000172807 | 1 | PA703510 | PM775681 |
| 15060000172818 | L15/dossiers | 15 | 15060000172817 | 15060000172817 | 1 | PA773441 | PM773491 |
| 15060000172819 | L15/dossiers | 15 | 15060000172817 | 15060000172817 | 2 | PA1872 | PM773455 |
| 15060000172889 | L15/dossiers | 15 | 15060000172888 | 15060000172888 | 1 | PA703513 | PM775671 |
| 15060000172896 | L15/dossiers | 15 | 15060000172895 | 15060000172895 | 1 | PA703513 | PM775671 |
| 15060000172903 | L15/dossiers | 15 | 15060000172902 | 15060000172902 | 1 | PA382672 | PM736263 |
| 15060000172921 | L15/dossiers | 15 | 15060000172920 | 15060000172920 | 1 | PA720310 | PM722926 |
| 15060000172922 | L15/dossiers | 15 | 15060000172920 | 15060000172920 | 2 | PA605131 | PM774339 |
| 15060000172930 | L15/dossiers | 15 | 15060000172929 | 15060000172929 | 1 | PA773441 | PM773491 |
| 15060000172937 | L15/dossiers | 15 | 15060000172936 | 15060000172936 | 1 | PA773441 | PM773491 |
| 15060000172944 | L15/dossiers | 15 | 15060000172943 | 15060000172943 | 1 | PA720846 | PM723094 |
| 15060000172951 | L15/dossiers | 15 | 15060000172950 | 15060000172950 | 1 | PA719608 | PM722710 |
| 15060000172958 | L15/dossiers | 15 | 15060000172957 | 15060000172957 | 1 | PA643134 | PM722824 |
| 15060000172965 | L15/dossiers | 15 | 15060000172964 | 15060000172964 | 1 | PA643134 | PM722824 |
| 15060000172972 | L15/dossiers | 15 | 15060000172971 | 15060000172971 | 1 | PA774960 | PM774985 |
| 15060000172997 | L15/dossiers | 15 | 15060000172996 | 15060000172996 | 1 | PA703520 | PM775705 |
| 15060000173004 | L15/dossiers | 15 | 15060000173003 | 15060000173003 | 1 | PA703537 | PM775721 |
| 15060000173011 | L15/dossiers | 15 | 15060000173010 | 15060000173010 | 1 | PA330684 | PM775859 |
| 15060000173018 | L15/dossiers | 15 | 15060000173017 | 15060000173017 | 1 | PA605069 | PM722424 |
| 15060000173028 | L15/dossiers | 15 | 15060000173027 | 15060000173027 | 1 | PA721474 | PM723286 |
| 15060000173032 | L15/dossiers | 15 | 15060000173031 | 15060000173031 | 1 | PA773441 | PM773491 |
| 15060000173033 | L15/dossiers | 15 | 15060000173031 | 15060000173031 | 2 | PA717161 | PM773483 |
| 15060000173034 | L15/dossiers | 15 | 15060000173031 | 15060000173031 | 3 | PA642788 | PM773495 |
| 15060000173041 | L15/dossiers | 15 | 15060000173040 | 15060000173040 | 1 | PA773441 | PM773491 |
| 15060000173042 | L15/dossiers | 15 | 15060000173040 | 15060000173040 | 2 | PA607846 | PM773469 |
| 15060000173096 | L15/dossiers | 15 | 15060000173095 | 15060000173095 | 1 | PA773441 | PM773491 |
| 15060000173108 | L15/dossiers | 15 | 15060000173107 | 15060000173107 | 1 | PA736192 | PM736353 |
| 15060000173151 | L15/dossiers | 15 | 15060000173150 | 15060000173150 | 1 | PA773441 | PM773491 |
| 15060000173203 | L15/dossiers | 15 | 15060000173202 | 15060000173202 | 1 | PA773441 | PM773491 |
| 15060000173210 | L15/dossiers | 15 | 15060000173209 | 15060000173209 | 1 | PA719980 | PM722822 |
| 15060000173214 | L15/dossiers | 15 | 15060000173213 | 15060000173213 | 1 | PA1809 | PM722556 |
| 15060000173218 | L15/dossiers | 15 | 15060000173217 | 15060000173217 | 1 | PA722268 | PM723522 |
| 15060000173222 | L15/dossiers | 15 | 15060000173221 | 15060000173221 | 1 | PA720480 | PM722976 |
| 15060000173285 | L15/dossiers | 15 | 15060000173284 | 15060000173284 | 1 | PA718902 | PM722496 |
| 15060000173292 | L15/dossiers | 15 | 15060000173291 | 15060000173291 | 1 | PA333285 | PM722906 |
| 15060000173303 | L15/dossiers | 15 | 15060000173302 | 15060000173302 | 1 | PA332614 | PM722812 |
| 15060000173320 | L15/dossiers | 15 | 15060000173319 | 15060000173319 | 1 | PA719930 | PM722804 |
| 15060000173335 | L15/dossiers | 15 | 15060000173334 | 15060000173334 | 1 | PA608695 | PM723564 |
| 15060000173348 | L15/dossiers | 15 | 15060000173347 | 15060000173347 | 1 | PA719946 | PM722808 |
| 15060000173355 | L15/dossiers | 15 | 15060000173354 | 15060000173354 | 1 | PA719946 | PM722808 |
| 15060000173362 | L15/dossiers | 15 | 15060000173361 | 15060000173361 | 1 | PA773441 | PM773491 |
| 15060000173363 | L15/dossiers | 15 | 15060000173361 | 15060000173361 | 2 | PA773443 | PM773510 |
| 15060000173370 | L15/dossiers | 15 | 15060000173369 | 15060000173369 | 1 | PA773441 | PM773491 |