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 |
|---|---|---|---|---|---|---|---|
| 14060000131619 | L14/dossiers | 14 | 14060000131617 | 14060000131617 | 2 | PA2679 | PM653358 |
| 14060000131693 | L14/dossiers | 14 | 14060000131692 | 14060000131692 | 1 | PA606478 | PM645457 |
| 14060000131700 | L14/dossiers | 14 | 14060000131699 | 14060000131699 | 1 | PA606478 | PM645457 |
| 14060000131707 | L14/dossiers | 14 | 14060000131706 | 14060000131706 | 1 | PA563 | PM645307 |
| 14060000131711 | L14/dossiers | 14 | 14060000131710 | 14060000131710 | 1 | PA335054 | PM645614 |
| 14060000131712 | L14/dossiers | 14 | 14060000131710 | 14060000131710 | 2 | PA1012 | PM645168 |
| 14060000131722 | L14/dossiers | 14 | 14060000131721 | 14060000131721 | 1 | PA342935 | PM645244 |
| 14060000131729 | L14/dossiers | 14 | 14060000131728 | 14060000131728 | 1 | PA346886 | PM695110 |
| 14060000131736 | L14/dossiers | 14 | 14060000131735 | 14060000131735 | 1 | PA2952 | PM645464 |
| 14060000131743 | L14/dossiers | 14 | 14060000131742 | 14060000131742 | 1 | PA610634 | PM645262 |
| 14060000131753 | L14/dossiers | 14 | 14060000131752 | 14060000131752 | 1 | PA267622 | PM702957 |
| 14060000131783 | L14/dossiers | 14 | 14060000131782 | 14060000131782 | 1 | PA266797 | PM645338 |
| 14060000131790 | L14/dossiers | 14 | 14060000131789 | 14060000131789 | 1 | PA267622 | PM702957 |
| 14060000131791 | L14/dossiers | 14 | 14060000131789 | 14060000131789 | 2 | PA331594 | PM711625 |
| 14060000131798 | L14/dossiers | 14 | 14060000131797 | 14060000131797 | 1 | PA2971 | PM645392 |
| 14060000131805 | L14/dossiers | 14 | 14060000131804 | 14060000131804 | 1 | PA267622 | PM702957 |
| 14060000131806 | L14/dossiers | 14 | 14060000131804 | 14060000131804 | 2 | PA2825 | PM711565 |
| 14060000131813 | L14/dossiers | 14 | 14060000131812 | 14060000131812 | 1 | PA687214 | PM687217 |
| 14060000131820 | L14/dossiers | 14 | 14060000131819 | 14060000131819 | 1 | PA608120 | PM645159 |
| 14060000131827 | L14/dossiers | 14 | 14060000131826 | 14060000131826 | 1 | PA330684 | PM645497 |
| 14060000131834 | L14/dossiers | 14 | 14060000131833 | 14060000131833 | 1 | PA267695 | PM645213 |
| 14060000131893 | L14/dossiers | 14 | 14060000131892 | 14060000131892 | 1 | PA328 | PM653228 |
| 14060000131894 | L14/dossiers | 14 | 14060000131892 | 14060000131892 | 2 | PA333611 | PM653276 |
| 14060000131950 | L14/dossiers | 14 | 14060000131949 | 14060000131949 | 1 | PA2048 | PM693013 |
| 14060000131960 | L14/dossiers | 14 | 14060000131959 | 14060000131959 | 1 | PA415482 | PM415579 |
| 14060000131967 | L14/dossiers | 14 | 14060000131966 | 14060000131966 | 1 | PA689 | PM645113 |
| 14060000131993 | L14/dossiers | 14 | 14060000131992 | 14060000131992 | 1 | PA563 | PM645307 |
| 14060000132000 | L14/dossiers | 14 | 14060000131999 | 14060000131999 | 1 | PA2713 | PM645148 |
| 14060000132007 | L14/dossiers | 14 | 14060000132006 | 14060000132006 | 1 | PA1155 | PM645285 |
| 14060000132020 | L14/dossiers | 14 | 14060000132019 | 14060000132019 | 1 | PA330684 | PM645497 |
| 14060000132027 | L14/dossiers | 14 | 14060000132026 | 14060000132026 | 1 | PA267433 | PM645316 |
| 14060000132034 | L14/dossiers | 14 | 14060000132033 | 14060000132033 | 1 | PA441 | PM645279 |
| 14060000132062 | L14/dossiers | 14 | 14060000132061 | 14060000132061 | 1 | PA267151 | PM645165 |
| 14060000132076 | L14/dossiers | 14 | 14060000132075 | 14060000132075 | 1 | PA330684 | PM645497 |
| 14060000132086 | L14/dossiers | 14 | 14060000132085 | 14060000132085 | 1 | PA267492 | PM645465 |
| 14060000132093 | L14/dossiers | 14 | 14060000132092 | 14060000132092 | 1 | PA1141 | PM645468 |
| 14060000132100 | L14/dossiers | 14 | 14060000132099 | 14060000132099 | 1 | PA267622 | PM702957 |
| 14060000132101 | L14/dossiers | 14 | 14060000132099 | 14060000132099 | 2 | PA1243 | PM702966 |
| 14060000132211 | L14/dossiers | 14 | 14060000132210 | 14060000132210 | 1 | PA328 | PM653228 |
| 14060000132212 | L14/dossiers | 14 | 14060000132210 | 14060000132210 | 2 | PA2240 | PM653295 |
| 14060000132286 | L14/dossiers | 14 | 14060000132285 | 14060000132285 | 1 | PA1874 | PM645474 |
| 14060000132293 | L14/dossiers | 14 | 14060000132292 | 14060000132292 | 1 | PA415482 | PM415579 |
| 14060000132308 | L14/dossiers | 14 | 14060000132307 | 14060000132307 | 1 | PA906 | PM303911 |
| 14060000132317 | L14/dossiers | 14 | 14060000132316 | 14060000132316 | 1 | PA345619 | PM717221 |
| 14060000132327 | L14/dossiers | 14 | 14060000132326 | 14060000132326 | 1 | PA346886 | PM695110 |
| 14060000132334 | L14/dossiers | 14 | 14060000132333 | 14060000132333 | 1 | PA267622 | PM700712 |
| 14060000132398 | L14/dossiers | 14 | 14060000132397 | 14060000132397 | 1 | PA266788 | PM645294 |
| 14060000132405 | L14/dossiers | 14 | 14060000132404 | 14060000132404 | 1 | PA309643 | PM645326 |
| 14060000132412 | L14/dossiers | 14 | 14060000132411 | 14060000132411 | 1 | PA267204 | PM645551 |
| 14060000132419 | L14/dossiers | 14 | 14060000132418 | 14060000132418 | 1 | PA267042 | PM645368 |