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 |
|---|---|---|---|---|---|---|---|
| 15060000157957 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 75 | PA736227 | PM736308 |
| 15060000157958 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 76 | PA720634 | PM736312 |
| 15060000157959 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 77 | PA715745 | PM736297 |
| 15060000157960 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 78 | PA736193 | PM736394 |
| 15060000157961 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 79 | PA415462 | PM703628 |
| 15060000157962 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 80 | PA1883 | PM736286 |
| 15060000157963 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 81 | PA1183 | PM706347 |
| 15060000157964 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 82 | PA1183 | PM706347 |
| 15060000157965 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 83 | PA227094 | PM736386 |
| 15060000157966 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 84 | PA703507 | PM703567 |
| 15060000157967 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 85 | PA415447 | PM703616 |
| 15060000157968 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 86 | PA304021 | PM736299 |
| 15060000157969 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 87 | PA736220 | PM736267 |
| 15060000157970 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 88 | PA267340 | PM703713 |
| 15060000157971 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 89 | PA343775 | PM736367 |
| 15060000157972 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 90 | PA267989 | PM703655 |
| 15060000157973 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 91 | PA736160 | PM736359 |
| 15060000157974 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 92 | PA736231 | PM736381 |
| 15060000157975 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 93 | PA736245 | PM736427 |
| 15060000157976 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 94 | PA267907 | PM703591 |
| 15060000157977 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 95 | PA415495 | PM703579 |
| 15060000157978 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 96 | PA736222 | PM736436 |
| 15060000157979 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 97 | PA703497 | PM703569 |
| 15060000157980 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 98 | PA736198 | PM736406 |
| 15060000157981 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 99 | PA736207 | PM736391 |
| 15060000157982 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 100 | PA304108 | PM736399 |
| 15060000157989 | L15/dossiers | 15 | 15060000157988 | 15060000157988 | 1 | PA415462 | PM703628 |
| 15060000157996 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 1 | PA267762 | PM736366 |
| 15060000157997 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 2 | PA415483 | PM703615 |
| 15060000157998 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 3 | PA736167 | PM736327 |
| 15060000157999 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 4 | PA736166 | PM736435 |
| 15060000158000 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 5 | PA703534 | PM703549 |
| 15060000158001 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 6 | PA2042 | PM703682 |
| 15060000158002 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 7 | PA304021 | PM736299 |
| 15060000158003 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 8 | PA267512 | PM703703 |
| 15060000158004 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 9 | PA429887 | PM736274 |
| 15060000158005 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 10 | PA736220 | PM736267 |
| 15060000158006 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 11 | PA266867 | PM703554 |
| 15060000158007 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 12 | PA1842 | PM703543 |
| 15060000158008 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 13 | PA736196 | PM736370 |
| 15060000158009 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 14 | PA569 | PM703710 |
| 15060000158010 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 15 | PA758431 | PM758701 |
| 15060000158011 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 16 | PA415495 | PM703579 |
| 15060000158012 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 17 | PA1001 | PM736371 |
| 15060000158013 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 18 | PA736206 | PM736351 |
| 15060000158014 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 19 | PA341406 | PM703619 |
| 15060000158015 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 20 | PA703522 | PM703702 |
| 15060000158016 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 21 | PA415477 | PM736418 |
| 15060000158017 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 22 | PA415477 | PM736418 |
| 15060000158018 | L15/dossiers | 15 | 15060000157995 | 15060000157995 | 23 | PA304086 | PM736348 |