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 |
|---|---|---|---|---|---|---|---|
| 15060000157773 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 4 | PA304082 | PM736354 |
| 15060000157774 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 5 | PA429891 | PM736329 |
| 15060000157775 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 6 | PA756685 | PM756689 |
| 15060000157776 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 7 | PA429836 | PM736345 |
| 15060000157777 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 8 | PA429886 | PM736385 |
| 15060000157778 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 9 | PA304071 | PM703676 |
| 15060000157779 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 10 | PA736195 | PM736357 |
| 15060000157780 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 11 | PA736177 | PM736318 |
| 15060000157781 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 12 | PA736173 | PM736369 |
| 15060000157782 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 13 | PA1978 | PM736337 |
| 15060000157783 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 14 | PA678263 | PM736330 |
| 15060000157784 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 15 | PA736243 | PM736413 |
| 15060000157785 | L15/dossiers | 15 | 15060000157769 | 15060000157769 | 16 | PA703499 | PM703641 |
| 15060000157792 | L15/dossiers | 15 | 15060000157791 | 15060000157791 | 1 | PA720634 | PM736312 |
| 15060000157799 | L15/dossiers | 15 | 15060000157798 | 15060000157798 | 1 | PA304021 | PM736299 |
| 15060000157806 | L15/dossiers | 15 | 15060000157805 | 15060000157805 | 1 | PA703523 | PM703578 |
| 15060000157813 | L15/dossiers | 15 | 15060000157812 | 15060000157812 | 1 | PA703521 | PM703544 |
| 15060000157820 | L15/dossiers | 15 | 15060000157819 | 15060000157819 | 1 | PA944 | PM703562 |
| 15060000157827 | L15/dossiers | 15 | 15060000157826 | 15060000157826 | 1 | PA2116 | PM736339 |
| 15060000157834 | L15/dossiers | 15 | 15060000157833 | 15060000157833 | 1 | PA343775 | PM736367 |
| 15060000157841 | L15/dossiers | 15 | 15060000157840 | 15060000157840 | 1 | PA205280 | PM736412 |
| 15060000157848 | L15/dossiers | 15 | 15060000157847 | 15060000157847 | 1 | PA736200 | PM736285 |
| 15060000157849 | L15/dossiers | 15 | 15060000157847 | 15060000157847 | 2 | PA425322 | PM736282 |
| 15060000157856 | L15/dossiers | 15 | 15060000157855 | 15060000157855 | 1 | PA736163 | PM736253 |
| 15060000157869 | L15/dossiers | 15 | 15060000157868 | 15060000157868 | 1 | PA736192 | PM736353 |
| 15060000157876 | L15/dossiers | 15 | 15060000157875 | 15060000157875 | 1 | PA429854 | PM736335 |
| 15060000157883 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 1 | PA736244 | PM736333 |
| 15060000157884 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 2 | PA429874 | PM736314 |
| 15060000157885 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 3 | PA2538 | PM703570 |
| 15060000157886 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 4 | PA303996 | PM703614 |
| 15060000157887 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 5 | PA429858 | PM736268 |
| 15060000157888 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 6 | PA313924 | PM703546 |
| 15060000157889 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 7 | PA429842 | PM736373 |
| 15060000157890 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 8 | PA528 | PM736270 |
| 15060000157891 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 9 | PA304010 | PM736332 |
| 15060000157892 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 10 | PA703522 | PM703702 |
| 15060000157893 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 11 | PA736239 | PM736317 |
| 15060000157894 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 12 | PA703517 | PM703625 |
| 15060000157895 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 13 | PA736216 | PM736273 |
| 15060000157896 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 14 | PA703488 | PM703632 |
| 15060000157897 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 15 | PA736200 | PM736285 |
| 15060000157898 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 16 | PA758431 | PM758701 |
| 15060000157899 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 17 | PA736169 | PM736293 |
| 15060000157900 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 18 | PA736163 | PM736253 |
| 15060000157901 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 19 | PA429887 | PM736274 |
| 15060000157902 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 20 | PA429875 | PM736302 |
| 15060000157903 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 21 | PA711156 | PM736319 |
| 15060000157904 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 22 | PA703518 | PM703704 |
| 15060000157905 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 23 | PA736192 | PM736353 |
| 15060000157906 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 24 | PA267762 | PM736366 |