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 |
|---|---|---|---|---|---|---|---|
| 15060000177974 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 3 | PA702993 | PM736362 |
| 15060000177975 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 4 | PA429855 | PM736425 |
| 15060000177976 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 5 | PA736219 | PM736387 |
| 15060000177977 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 6 | PA736199 | PM736284 |
| 15060000177978 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 7 | PA775186 | PM775484 |
| 15060000177979 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 8 | PA775196 | PM775482 |
| 15060000177980 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 9 | PA775206 | PM775506 |
| 15060000177981 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 10 | PA429835 | PM736397 |
| 15060000177982 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 11 | PA732419 | PM775647 |
| 15060000177983 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 12 | PA703538 | PM775715 |
| 15060000177984 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 13 | PA736191 | PM736336 |
| 15060000177985 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 14 | PA708633 | PM775669 |
| 15060000177986 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 15 | PA415477 | PM775809 |
| 15060000177987 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 16 | PA766947 | PM775799 |
| 15060000177988 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 17 | PA642756 | PM775779 |
| 15060000177989 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 18 | PA703509 | PM775687 |
| 15060000177990 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 19 | PA736229 | PM736389 |
| 15060000177991 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 20 | PA429860 | PM736398 |
| 15060000177992 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 21 | PA415449 | PM775793 |
| 15060000177993 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 22 | PA429888 | PM736379 |
| 15060000177994 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 23 | PA2074 | PM775677 |
| 15060000177995 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 24 | PA703512 | PM775665 |
| 15060000177996 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 25 | PA643211 | PM775749 |
| 15060000177997 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 26 | PA736209 | PM736400 |
| 15060000177998 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 27 | PA703505 | PM775679 |
| 15060000177999 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 28 | PA775274 | PM775560 |
| 15060000178000 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 29 | PA429883 | PM736355 |
| 15060000178001 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 30 | PA736214 | PM736290 |
| 15060000178002 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 31 | PA736217 | PM736384 |
| 15060000178003 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 32 | PA227096 | PM736342 |
| 15060000178004 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 33 | PA2870 | PM736316 |
| 15060000178005 | L15/dossiers | 15 | 15060000177971 | 15060000177971 | 34 | PA736162 | PM736320 |
| 15060000178012 | L15/dossiers | 15 | 15060000178011 | 15060000178011 | 1 | PA718850 | PM722478 |
| 15060000178019 | L15/dossiers | 15 | 15060000178018 | 15060000178018 | 1 | PA773441 | PM773491 |
| 15060000178020 | L15/dossiers | 15 | 15060000178018 | 15060000178018 | 2 | PA609520 | PM773503 |
| 15060000178027 | L15/dossiers | 15 | 15060000178026 | 15060000178026 | 1 | PA736193 | PM736394 |
| 15060000178034 | L15/dossiers | 15 | 15060000178033 | 15060000178033 | 1 | PA736201 | PM736347 |
| 15060000178035 | L15/dossiers | 15 | 15060000178033 | 15060000178033 | 2 | PA429891 | PM736329 |
| 15060000178036 | L15/dossiers | 15 | 15060000178033 | 15060000178033 | 3 | PA775180 | PM775466 |
| 15060000178037 | L15/dossiers | 15 | 15060000178033 | 15060000178033 | 4 | PA429845 | PM736278 |
| 15060000178038 | L15/dossiers | 15 | 15060000178033 | 15060000178033 | 5 | PA775214 | PM775498 |
| 15060000178039 | L15/dossiers | 15 | 15060000178033 | 15060000178033 | 6 | PA775224 | PM775512 |
| 15060000178040 | L15/dossiers | 15 | 15060000178033 | 15060000178033 | 7 | PA736177 | PM736318 |
| 15060000178041 | L15/dossiers | 15 | 15060000178033 | 15060000178033 | 8 | PA429866 | PM736287 |
| 15060000178042 | L15/dossiers | 15 | 15060000178033 | 15060000178033 | 9 | PA775252 | PM775558 |
| 15060000178043 | L15/dossiers | 15 | 15060000178033 | 15060000178033 | 10 | PA775262 | PM775548 |
| 15060000178044 | L15/dossiers | 15 | 15060000178033 | 15060000178033 | 11 | PA775272 | PM775562 |
| 15060000178045 | L15/dossiers | 15 | 15060000178033 | 15060000178033 | 12 | PA775282 | PM775584 |
| 15060000178052 | L15/dossiers | 15 | 15060000178051 | 15060000178051 | 1 | PA773441 | PM773491 |
| 15060000178074 | L15/dossiers | 15 | 15060000178073 | 15060000178073 | 1 | PA744079 | PM744082 |