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 |
|---|---|---|---|---|---|---|---|
| 14060000114429 | L14/dossiers | 14 | 14060000114428 | 14060000114428 | 1 | PA2907 | PM645289 |
| 14060000114436 | L14/dossiers | 14 | 14060000114435 | 14060000114435 | 1 | PA1874 | PM645474 |
| 14060000114453 | L14/dossiers | 14 | 14060000114452 | 14060000114452 | 1 | PA346886 | PM695110 |
| 14060000114460 | L14/dossiers | 14 | 14060000114459 | 14060000114459 | 1 | PA304071 | PM703676 |
| 14060000114499 | L14/dossiers | 14 | 14060000114498 | 14060000114498 | 1 | PA267492 | PM645465 |
| 14060000114506 | L14/dossiers | 14 | 14060000114505 | 14060000114505 | 1 | PA328 | PM653228 |
| 14060000114507 | L14/dossiers | 14 | 14060000114505 | 14060000114505 | 2 | PA1268 | PM653525 |
| 14060000114541 | L14/dossiers | 14 | 14060000114540 | 14060000114540 | 1 | PA1874 | PM645474 |
| 14060000114548 | L14/dossiers | 14 | 14060000114547 | 14060000114547 | 1 | PA332523 | PM645550 |
| 14060000114565 | L14/dossiers | 14 | 14060000114564 | 14060000114564 | 1 | PA609726 | PM645311 |
| 14060000114572 | L14/dossiers | 14 | 14060000114571 | 14060000114571 | 1 | PA608186 | PM645202 |
| 14060000114593 | L14/dossiers | 14 | 14060000114592 | 14060000114592 | 1 | PA267585 | PM645508 |
| 14060000114600 | L14/dossiers | 14 | 14060000114599 | 14060000114599 | 1 | PA2775 | PM645461 |
| 14060000114607 | L14/dossiers | 14 | 14060000114606 | 14060000114606 | 1 | PA314 | PM645292 |
| 14060000114637 | L14/dossiers | 14 | 14060000114636 | 14060000114636 | 1 | PA610427 | PM645158 |
| 14060000114660 | L14/dossiers | 14 | 14060000114659 | 14060000114659 | 1 | PA592 | PM430044 |
| 14060000114669 | L14/dossiers | 14 | 14060000114668 | 14060000114668 | 1 | PA609016 | PM645074 |
| 14060000114687 | L14/dossiers | 14 | 14060000114686 | 14060000114686 | 1 | PA328 | PM653228 |
| 14060000114715 | L14/dossiers | 14 | 14060000114714 | 14060000114714 | 1 | PA266788 | PM645294 |
| 14060000114722 | L14/dossiers | 14 | 14060000114721 | 14060000114721 | 1 | PA610775 | PM645309 |
| 14060000114733 | L14/dossiers | 14 | 14060000114732 | 14060000114732 | 1 | PA607846 | PM645441 |
| 14060000114743 | L14/dossiers | 14 | 14060000114742 | 14060000114742 | 1 | PA334149 | PM645127 |
| 14060000114750 | L14/dossiers | 14 | 14060000114749 | 14060000114749 | 1 | PA2377 | PM645591 |
| 14060000114757 | L14/dossiers | 14 | 14060000114756 | 14060000114756 | 1 | PA328 | PM653228 |
| 14060000114758 | L14/dossiers | 14 | 14060000114756 | 14060000114756 | 2 | PA2791 | PM653325 |
| 14060000114816 | L14/dossiers | 14 | 14060000114815 | 14060000114815 | 1 | PA230 | PM645553 |
| 14060000114823 | L14/dossiers | 14 | 14060000114822 | 14060000114822 | 1 | PA2971 | PM645392 |
| 14060000114830 | L14/dossiers | 14 | 14060000114829 | 14060000114829 | 1 | PA268019 | PM645116 |
| 14060000114834 | L14/dossiers | 14 | 14060000114833 | 14060000114833 | 1 | PA346886 | PM695110 |
| 14060000114841 | L14/dossiers | 14 | 14060000114840 | 14060000114840 | 1 | PA608416 | PM645586 |
| 14060000114848 | L14/dossiers | 14 | 14060000114847 | 14060000114847 | 1 | PA303999 | PM304124 |
| 14060000114883 | L14/dossiers | 14 | 14060000114882 | 14060000114882 | 1 | PA609726 | PM645311 |
| 14060000114890 | L14/dossiers | 14 | 14060000114889 | 14060000114889 | 1 | PA330240 | PM645425 |
| 14060000114897 | L14/dossiers | 14 | 14060000114896 | 14060000114896 | 1 | PA328 | PM653228 |
| 14060000114898 | L14/dossiers | 14 | 14060000114896 | 14060000114896 | 2 | PA1268 | PM653525 |
| 14060000114911 | L14/dossiers | 14 | 14060000114910 | 14060000114910 | 1 | PA267492 | PM645465 |
| 14060000114918 | L14/dossiers | 14 | 14060000114917 | 14060000114917 | 1 | PA1886 | PM645099 |
| 14060000114925 | L14/dossiers | 14 | 14060000114924 | 14060000114924 | 1 | PA563 | PM645307 |
| 14060000114932 | L14/dossiers | 14 | 14060000114931 | 14060000114931 | 1 | PA785 | PM715797 |
| 14060000114939 | L14/dossiers | 14 | 14060000114938 | 14060000114938 | 1 | PA429873 | PM429945 |
| 14060000114951 | L14/dossiers | 14 | 14060000114950 | 14060000114950 | 1 | PA328 | PM653228 |
| 14060000114952 | L14/dossiers | 14 | 14060000114950 | 14060000114950 | 2 | PA267622 | PM653322 |
| 14060000115041 | L14/dossiers | 14 | 14060000115040 | 14060000115040 | 1 | PA1931 | PM645042 |
| 14060000115049 | L14/dossiers | 14 | 14060000115048 | 14060000115048 | 1 | PA328 | PM653228 |
| 14060000115050 | L14/dossiers | 14 | 14060000115048 | 14060000115048 | 2 | PA1268 | PM653525 |
| 14060000115080 | L14/dossiers | 14 | 14060000115079 | 14060000115079 | 1 | PA331582 | PM645198 |
| 14060000115087 | L14/dossiers | 14 | 14060000115086 | 14060000115086 | 1 | PA267622 | PM702957 |
| 14060000115088 | L14/dossiers | 14 | 14060000115086 | 14060000115086 | 2 | PA702992 | PM702994 |
| 14060000115142 | L14/dossiers | 14 | 14060000115141 | 14060000115141 | 1 | PA304082 | PM430056 |
| 14060000115157 | L14/dossiers | 14 | 14060000115156 | 14060000115156 | 1 | PA607603 | PM645379 |