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 |
|---|---|---|---|---|---|---|---|
| 15060000157907 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 25 | PA1001 | PM736371 |
| 15060000157908 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 26 | PA266867 | PM703554 |
| 15060000157909 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 27 | PA703506 | PM703680 |
| 15060000157910 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 28 | PA267081 | PM703617 |
| 15060000157911 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 29 | PA736211 | PM736410 |
| 15060000157912 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 30 | PA736230 | PM736377 |
| 15060000157913 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 31 | PA761231 | PM761235 |
| 15060000157914 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 32 | PA703482 | PM703642 |
| 15060000157915 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 33 | PA415479 | PM703586 |
| 15060000157916 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 34 | PA736194 | PM736291 |
| 15060000157917 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 35 | PA703541 | PM703644 |
| 15060000157918 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 36 | PA703527 | PM703580 |
| 15060000157919 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 37 | PA736167 | PM736327 |
| 15060000157920 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 38 | PA736166 | PM736435 |
| 15060000157921 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 39 | PA425322 | PM736282 |
| 15060000157922 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 40 | PA267872 | PM736409 |
| 15060000157923 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 41 | PA703521 | PM703544 |
| 15060000157924 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 42 | PA267795 | PM703667 |
| 15060000157925 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 43 | PA736226 | PM736280 |
| 15060000157926 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 44 | PA205280 | PM736412 |
| 15060000157927 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 45 | PA703531 | PM703701 |
| 15060000157928 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 46 | PA736206 | PM736351 |
| 15060000157929 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 47 | PA736224 | PM736403 |
| 15060000157930 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 48 | PA709750 | PM736295 |
| 15060000157931 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 49 | PA1562 | PM736340 |
| 15060000157932 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 50 | PA703539 | PM703693 |
| 15060000157933 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 51 | PA703494 | PM703602 |
| 15060000157934 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 52 | PA716 | PM736261 |
| 15060000157935 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 53 | PA394676 | PM703550 |
| 15060000157936 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 54 | PA703501 | PM703629 |
| 15060000157937 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 55 | PA415486 | PM703623 |
| 15060000157938 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 56 | PA736213 | PM736431 |
| 15060000157939 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 57 | PA736202 | PM736392 |
| 15060000157940 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 58 | PA703483 | PM703613 |
| 15060000157941 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 59 | PA736240 | PM736279 |
| 15060000157942 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 60 | PA703537 | PM703595 |
| 15060000157943 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 61 | PA708632 | PM708643 |
| 15060000157944 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 62 | PA341381 | PM703618 |
| 15060000157945 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 63 | PA429870 | PM736309 |
| 15060000157946 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 64 | PA304086 | PM736348 |
| 15060000157947 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 65 | PA703503 | PM703582 |
| 15060000157948 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 66 | PA415451 | PM703594 |
| 15060000157949 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 67 | PA703515 | PM703592 |
| 15060000157950 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 68 | PA2447 | PM703679 |
| 15060000157951 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 69 | PA2447 | PM703679 |
| 15060000157952 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 70 | PA736197 | PM736378 |
| 15060000157953 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 71 | PA736176 | PM736434 |
| 15060000157954 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 72 | PA267728 | PM736277 |
| 15060000157955 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 73 | PA736246 | PM736428 |
| 15060000157956 | L15/dossiers | 15 | 15060000157882 | 15060000157882 | 74 | PA703510 | PM703672 |