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 |
|---|---|---|---|---|---|---|---|
| 15060000160804 | L15/dossiers | 15 | 15060000160803 | 15060000160803 | 1 | PA267306 | PM723054 |
| 15060000160811 | L15/dossiers | 15 | 15060000160810 | 15060000160810 | 1 | PA689 | PM723090 |
| 15060000160832 | L15/dossiers | 15 | 15060000160831 | 15060000160831 | 1 | PA736163 | PM736253 |
| 15060000160839 | L15/dossiers | 15 | 15060000160838 | 15060000160838 | 1 | PA303994 | PM766154 |
| 15060000160846 | L15/dossiers | 15 | 15060000160845 | 15060000160845 | 1 | PA429858 | PM736268 |
| 15060000160847 | L15/dossiers | 15 | 15060000160845 | 15060000160845 | 2 | PA2538 | PM703570 |
| 15060000160848 | L15/dossiers | 15 | 15060000160845 | 15060000160845 | 3 | PA429832 | PM736408 |
| 15060000160884 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 1 | PA205280 | PM736412 |
| 15060000160885 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 2 | PA744079 | PM744082 |
| 15060000160886 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 3 | PA341381 | PM703618 |
| 15060000160887 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 4 | PA705750 | PM705821 |
| 15060000160888 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 5 | PA736192 | PM736353 |
| 15060000160889 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 6 | PA736222 | PM736436 |
| 15060000160890 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 7 | PA736230 | PM736377 |
| 15060000160891 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 8 | PA425322 | PM736282 |
| 15060000160892 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 9 | PA415447 | PM703616 |
| 15060000160893 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 10 | PA716 | PM736261 |
| 15060000160894 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 11 | PA429875 | PM736302 |
| 15060000160895 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 12 | PA736172 | PM736415 |
| 15060000160896 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 13 | PA382672 | PM736263 |
| 15060000160897 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 14 | PA703497 | PM703569 |
| 15060000160898 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 15 | PA404656 | PM736328 |
| 15060000160899 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 16 | PA703506 | PM703680 |
| 15060000160900 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 17 | PA528 | PM736270 |
| 15060000160901 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 18 | PA736186 | PM736396 |
| 15060000160902 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 19 | PA736188 | PM736289 |
| 15060000160903 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 20 | PA343988 | PM736310 |
| 15060000160904 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 21 | PA703521 | PM703544 |
| 15060000160905 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 22 | PA303994 | PM766154 |
| 15060000160906 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 23 | PA429851 | PM736305 |
| 15060000160907 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 24 | PA267762 | PM736366 |
| 15060000160908 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 25 | PA703532 | PM703568 |
| 15060000160909 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 26 | PA2237 | PM703705 |
| 15060000160910 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 27 | PA736239 | PM736317 |
| 15060000160911 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 28 | PA736224 | PM736403 |
| 15060000160912 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 29 | PA736207 | PM736391 |
| 15060000160913 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 30 | PA736202 | PM736392 |
| 15060000160914 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 31 | PA736216 | PM736273 |
| 15060000160915 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 32 | PA1993 | PM736402 |
| 15060000160916 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 33 | PA415486 | PM703623 |
| 15060000160917 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 34 | PA703494 | PM703602 |
| 15060000160918 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 35 | PA703513 | PM703621 |
| 15060000160919 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 36 | PA301592 | PM736375 |
| 15060000160920 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 37 | PA429874 | PM736314 |
| 15060000160921 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 38 | PA736246 | PM736428 |
| 15060000160922 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 39 | PA267081 | PM703617 |
| 15060000160923 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 40 | PA736197 | PM736378 |
| 15060000160924 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 41 | PA343775 | PM736367 |
| 15060000160925 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 42 | PA703527 | PM703580 |
| 15060000160926 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 43 | PA703492 | PM703645 |