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 |
|---|---|---|---|---|---|---|---|
| 15060000180642 | L15/dossiers | 15 | 15060000180641 | 15060000180641 | 1 | PA773441 | PM773491 |
| 15060000180706 | L15/dossiers | 15 | 15060000180705 | 15060000180705 | 1 | PA773441 | PM773491 |
| 15060000180707 | L15/dossiers | 15 | 15060000180705 | 15060000180705 | 2 | PA773443 | PM773510 |
| 15060000180708 | L15/dossiers | 15 | 15060000180705 | 15060000180705 | 3 | PA607846 | PM773469 |
| 15060000180777 | L15/dossiers | 15 | 15060000180776 | 15060000180776 | 1 | PA773441 | PM773491 |
| 15060000180778 | L15/dossiers | 15 | 15060000180776 | 15060000180776 | 2 | PA609520 | PM773503 |
| 15060000180779 | L15/dossiers | 15 | 15060000180776 | 15060000180776 | 3 | PA721670 | PM773499 |
| 15060000180786 | L15/dossiers | 15 | 15060000180785 | 15060000180785 | 1 | PA267785 | PM723310 |
| 15060000180820 | L15/dossiers | 15 | 15060000180819 | 15060000180819 | 1 | PA605518 | PM722518 |
| 15060000180824 | L15/dossiers | 15 | 15060000180823 | 15060000180823 | 1 | PA719692 | PM722732 |
| 15060000180831 | L15/dossiers | 15 | 15060000180830 | 15060000180830 | 1 | PA642847 | PM722954 |
| 15060000180838 | L15/dossiers | 15 | 15060000180837 | 15060000180837 | 1 | PA721486 | PM723290 |
| 15060000180845 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 1 | PA429886 | PM736385 |
| 15060000180846 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 2 | PA304082 | PM736354 |
| 15060000180847 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 3 | PA757676 | PM757692 |
| 15060000180848 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 4 | PA775172 | PM775474 |
| 15060000180849 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 5 | PA429894 | PM736364 |
| 15060000180850 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 6 | PA756685 | PM775777 |
| 15060000180851 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 7 | PA429836 | PM736345 |
| 15060000180852 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 8 | PA736195 | PM736357 |
| 15060000180853 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 9 | PA736173 | PM736369 |
| 15060000180854 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 10 | PA775246 | PM775532 |
| 15060000180855 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 11 | PA1978 | PM736337 |
| 15060000180856 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 12 | PA736243 | PM736413 |
| 15060000180857 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 13 | PA736175 | PM736344 |
| 15060000180858 | L15/dossiers | 15 | 15060000180844 | 15060000180844 | 14 | PA775296 | PM775596 |
| 15060000180865 | L15/dossiers | 15 | 15060000180864 | 15060000180864 | 1 | PA711156 | PM736319 |
| 15060000180872 | L15/dossiers | 15 | 15060000180871 | 15060000180871 | 1 | PA1630 | PM723232 |
| 15060000180879 | L15/dossiers | 15 | 15060000180878 | 15060000180878 | 1 | PA774952 | PM774983 |
| 15060000180886 | L15/dossiers | 15 | 15060000180885 | 15060000180885 | 1 | PA774952 | PM774983 |
| 15060000180893 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 1 | PA2774 | PM736307 |
| 15060000180894 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 2 | PA702993 | PM736362 |
| 15060000180895 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 3 | PA736219 | PM736387 |
| 15060000180896 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 4 | PA736199 | PM736284 |
| 15060000180897 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 5 | PA415488 | PM775641 |
| 15060000180898 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 6 | PA775196 | PM775482 |
| 15060000180899 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 7 | PA775200 | PM775504 |
| 15060000180900 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 8 | PA775206 | PM775506 |
| 15060000180901 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 9 | PA590034 | PM775606 |
| 15060000180902 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 10 | PA429835 | PM736397 |
| 15060000180903 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 11 | PA429835 | PM736397 |
| 15060000180904 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 12 | PA736215 | PM736324 |
| 15060000180905 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 13 | PA732419 | PM775647 |
| 15060000180906 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 14 | PA732419 | PM775647 |
| 15060000180907 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 15 | PA736191 | PM736336 |
| 15060000180908 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 16 | PA708633 | PM775669 |
| 15060000180909 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 17 | PA415477 | PM775809 |
| 15060000180910 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 18 | PA415477 | PM775809 |
| 15060000180911 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 19 | PA736187 | PM736365 |
| 15060000180912 | L15/dossiers | 15 | 15060000180892 | 15060000180892 | 20 | PA766947 | PM775799 |