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 |
|---|---|---|---|---|---|---|---|
| 15060000183028 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 20 | PA429875 | PM736302 |
| 15060000183029 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 21 | PA415454 | PM785875 |
| 15060000183030 | L15/dossiers | 15 | 15060000183008 | 15060000183008 | 22 | PA394676 | PM775769 |
| 15060000183037 | L15/dossiers | 15 | 15060000183036 | 15060000183036 | 1 | PA736229 | PM736389 |
| 15060000183044 | L15/dossiers | 15 | 15060000183043 | 15060000183043 | 1 | PA1206 | PM723354 |
| 15060000183054 | L15/dossiers | 15 | 15060000183053 | 15060000183053 | 1 | PA721486 | PM723290 |
| 15060000183061 | L15/dossiers | 15 | 15060000183060 | 15060000183060 | 1 | PA1874 | PM722598 |
| 15060000183068 | L15/dossiers | 15 | 15060000183067 | 15060000183067 | 1 | PA719952 | PM722814 |
| 15060000183075 | L15/dossiers | 15 | 15060000183074 | 15060000183074 | 1 | PA720754 | PM723066 |
| 15060000183128 | L15/dossiers | 15 | 15060000183127 | 15060000183127 | 1 | PA1206 | PM723354 |
| 15060000183135 | L15/dossiers | 15 | 15060000183134 | 15060000183134 | 1 | PA719558 | PM722696 |
| 15060000183143 | L15/dossiers | 15 | 15060000183142 | 15060000183142 | 1 | PA1838 | PM723068 |
| 15060000183150 | L15/dossiers | 15 | 15060000183149 | 15060000183149 | 1 | PA268019 | PM723092 |
| 15060000183160 | L15/dossiers | 15 | 15060000183159 | 15060000183159 | 1 | PA720278 | PM722916 |
| 15060000183164 | L15/dossiers | 15 | 15060000183163 | 15060000183163 | 1 | PA721632 | PM760305 |
| 15060000183216 | L15/dossiers | 15 | 15060000183215 | 15060000183215 | 1 | PA335999 | PM723480 |
| 15060000183223 | L15/dossiers | 15 | 15060000183222 | 15060000183222 | 1 | PA736229 | PM736389 |
| 15060000183230 | L15/dossiers | 15 | 15060000183229 | 15060000183229 | 1 | PA720846 | PM723094 |
| 15060000183253 | L15/dossiers | 15 | 15060000183252 | 15060000183252 | 1 | PA773441 | PM773491 |
| 15060000183254 | L15/dossiers | 15 | 15060000183252 | 15060000183252 | 2 | PA205600 | PM773445 |
| 15060000183255 | L15/dossiers | 15 | 15060000183252 | 15060000183252 | 3 | PA719914 | PM773439 |
| 15060000183309 | L15/dossiers | 15 | 15060000183308 | 15060000183308 | 1 | PA773441 | PM773491 |
| 15060000183310 | L15/dossiers | 15 | 15060000183308 | 15060000183308 | 2 | PA332 | PM773507 |
| 15060000183344 | L15/dossiers | 15 | 15060000183343 | 15060000183343 | 1 | PA721024 | PM723144 |
| 15060000183349 | L15/dossiers | 15 | 15060000183348 | 15060000183348 | 1 | PA773441 | PM773491 |
| 15060000183350 | L15/dossiers | 15 | 15060000183348 | 15060000183348 | 2 | PA331481 | PM773459 |
| 15060000183351 | L15/dossiers | 15 | 15060000183348 | 15060000183348 | 3 | PA330357 | PM773447 |
| 15060000183426 | L15/dossiers | 15 | 15060000183425 | 15060000183425 | 1 | PA775300 | PM775600 |
| 15060000183433 | L15/dossiers | 15 | 15060000183432 | 15060000183432 | 1 | PA719608 | PM722710 |
| 15060000183437 | L15/dossiers | 15 | 15060000183436 | 15060000183436 | 1 | PA722142 | PM723484 |
| 15060000183441 | L15/dossiers | 15 | 15060000183440 | 15060000183440 | 1 | PA720692 | PM723042 |
| 15060000183447 | L15/dossiers | 15 | 15060000183446 | 15060000183446 | 1 | PA719558 | PM722696 |
| 15060000183522 | L15/dossiers | 15 | 15060000183521 | 15060000183521 | 1 | PA720692 | PM723042 |
| 15060000183531 | L15/dossiers | 15 | 15060000183530 | 15060000183530 | 1 | PA2116 | PM736339 |
| 15060000183538 | L15/dossiers | 15 | 15060000183537 | 15060000183537 | 1 | PA721142 | PM723186 |
| 15060000183545 | L15/dossiers | 15 | 15060000183544 | 15060000183544 | 1 | PA266788 | PM722914 |
| 15060000183552 | L15/dossiers | 15 | 15060000183551 | 15060000183551 | 1 | PA719154 | PM722578 |
| 15060000183559 | L15/dossiers | 15 | 15060000183558 | 15060000183558 | 1 | PA719946 | PM722808 |
| 15060000183566 | L15/dossiers | 15 | 15060000183565 | 15060000183565 | 1 | PA266788 | PM722914 |
| 15060000183573 | L15/dossiers | 15 | 15060000183572 | 15060000183572 | 1 | PA718926 | PM722502 |
| 15060000183580 | L15/dossiers | 15 | 15060000183579 | 15060000183579 | 1 | PA721328 | PM723240 |
| 15060000183587 | L15/dossiers | 15 | 15060000183586 | 15060000183586 | 1 | PA604 | PM774354 |
| 15060000183594 | L15/dossiers | 15 | 15060000183593 | 15060000183593 | 1 | PA266808 | PM723264 |
| 15060000183601 | L15/dossiers | 15 | 15060000183600 | 15060000183600 | 1 | PA609726 | PM723426 |
| 15060000183608 | L15/dossiers | 15 | 15060000183607 | 15060000183607 | 1 | PA718978 | PM722520 |
| 15060000183615 | L15/dossiers | 15 | 15060000183614 | 15060000183614 | 1 | PA721486 | PM723290 |
| 15060000183622 | L15/dossiers | 15 | 15060000183621 | 15060000183621 | 1 | PA719118 | PM722568 |
| 15060000183629 | L15/dossiers | 15 | 15060000183628 | 15060000183628 | 1 | PA721434 | PM723272 |
| 15060000183636 | L15/dossiers | 15 | 15060000183635 | 15060000183635 | 1 | PA330788 | PM722570 |
| 15060000183643 | L15/dossiers | 15 | 15060000183642 | 15060000183642 | 1 | PA2150 | PM722506 |