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 |
|---|---|---|---|---|---|---|---|
| 14060000117174 | L14/dossiers | 14 | 14060000117173 | 14060000117173 | 1 | PA328 | PM653228 |
| 14060000117175 | L14/dossiers | 14 | 14060000117173 | 14060000117173 | 2 | PA268048 | PM653328 |
| 14060000117182 | L14/dossiers | 14 | 14060000117181 | 14060000117181 | 1 | PA267622 | PM702957 |
| 14060000117183 | L14/dossiers | 14 | 14060000117181 | 14060000117181 | 2 | PA1872 | PM702970 |
| 14060000117190 | L14/dossiers | 14 | 14060000117189 | 14060000117189 | 1 | PA330240 | PM645425 |
| 14060000117197 | L14/dossiers | 14 | 14060000117196 | 14060000117196 | 1 | PA330684 | PM645497 |
| 14060000117204 | L14/dossiers | 14 | 14060000117203 | 14060000117203 | 1 | PA415482 | PM415579 |
| 14060000117228 | L14/dossiers | 14 | 14060000117227 | 14060000117227 | 1 | PA856 | PM645353 |
| 14060000117246 | L14/dossiers | 14 | 14060000117245 | 14060000117245 | 1 | PA267622 | PM702957 |
| 14060000117247 | L14/dossiers | 14 | 14060000117245 | 14060000117245 | 2 | PA2791 | PM702981 |
| 14060000117255 | L14/dossiers | 14 | 14060000117254 | 14060000117254 | 1 | PA608186 | PM645202 |
| 14060000117265 | L14/dossiers | 14 | 14060000117264 | 14060000117264 | 1 | PA267622 | PM700712 |
| 14060000117266 | L14/dossiers | 14 | 14060000117264 | 14060000117264 | 2 | PA1268 | PM700715 |
| 14060000117300 | L14/dossiers | 14 | 14060000117299 | 14060000117299 | 1 | PA429836 | PM430049 |
| 14060000117312 | L14/dossiers | 14 | 14060000117311 | 14060000117311 | 1 | PA267622 | PM702957 |
| 14060000117313 | L14/dossiers | 14 | 14060000117311 | 14060000117311 | 2 | PA415496 | PM702987 |
| 14060000117323 | L14/dossiers | 14 | 14060000117322 | 14060000117322 | 1 | PA346886 | PM695110 |
| 14060000117333 | L14/dossiers | 14 | 14060000117332 | 14060000117332 | 1 | PA1364 | PM645084 |
| 14060000117340 | L14/dossiers | 14 | 14060000117339 | 14060000117339 | 1 | PA346886 | PM695110 |
| 14060000117344 | L14/dossiers | 14 | 14060000117343 | 14060000117343 | 1 | PA2690 | PM645458 |
| 14060000117397 | L14/dossiers | 14 | 14060000117396 | 14060000117396 | 1 | PA2086 | PM645043 |
| 14060000117404 | L14/dossiers | 14 | 14060000117403 | 14060000117403 | 1 | PA785 | PM715797 |
| 14060000117412 | L14/dossiers | 14 | 14060000117411 | 14060000117411 | 1 | PA227076 | PM429906 |
| 14060000117413 | L14/dossiers | 14 | 14060000117411 | 14060000117411 | 2 | PA2774 | PM429910 |
| 14060000117490 | L14/dossiers | 14 | 14060000117489 | 14060000117489 | 1 | PA267743 | PM645058 |
| 14060000117497 | L14/dossiers | 14 | 14060000117496 | 14060000117496 | 1 | PA267042 | PM645368 |
| 14060000117504 | L14/dossiers | 14 | 14060000117503 | 14060000117503 | 1 | PA267622 | PM702957 |
| 14060000117518 | L14/dossiers | 14 | 14060000117517 | 14060000117517 | 1 | PA610521 | PM645190 |
| 14060000117525 | L14/dossiers | 14 | 14060000117524 | 14060000117524 | 1 | PA230 | PM645553 |
| 14060000117536 | L14/dossiers | 14 | 14060000117535 | 14060000117535 | 1 | PA267622 | PM702957 |
| 14060000117537 | L14/dossiers | 14 | 14060000117535 | 14060000117535 | 2 | PA331594 | PM711625 |
| 14060000117545 | L14/dossiers | 14 | 14060000117544 | 14060000117544 | 1 | PA2277 | PM645135 |
| 14060000117552 | L14/dossiers | 14 | 14060000117551 | 14060000117551 | 1 | PA328 | PM653228 |
| 14060000117553 | L14/dossiers | 14 | 14060000117551 | 14060000117551 | 2 | PA1268 | PM653525 |
| 14060000117582 | L14/dossiers | 14 | 14060000117581 | 14060000117581 | 1 | PA606212 | PM645330 |
| 14060000117589 | L14/dossiers | 14 | 14060000117588 | 14060000117588 | 1 | PA266788 | PM645294 |
| 14060000117596 | L14/dossiers | 14 | 14060000117595 | 14060000117595 | 1 | PA346886 | PM695110 |
| 14060000117603 | L14/dossiers | 14 | 14060000117602 | 14060000117602 | 1 | PA998 | PM645034 |
| 14060000117610 | L14/dossiers | 14 | 14060000117609 | 14060000117609 | 1 | PA2011 | PM645434 |
| 14060000117617 | L14/dossiers | 14 | 14060000117616 | 14060000117616 | 1 | PA2952 | PM645464 |
| 14060000117624 | L14/dossiers | 14 | 14060000117623 | 14060000117623 | 1 | PA332747 | PM645155 |
| 14060000117634 | L14/dossiers | 14 | 14060000117633 | 14060000117633 | 1 | PA267622 | PM702957 |
| 14060000117635 | L14/dossiers | 14 | 14060000117633 | 14060000117633 | 2 | PA605606 | PM708671 |
| 14060000117642 | L14/dossiers | 14 | 14060000117641 | 14060000117641 | 1 | PA267204 | PM645551 |
| 14060000117649 | L14/dossiers | 14 | 14060000117648 | 14060000117648 | 1 | PA2876 | PM645355 |
| 14060000117656 | L14/dossiers | 14 | 14060000117655 | 14060000117655 | 1 | PA346886 | PM695110 |
| 14060000117663 | L14/dossiers | 14 | 14060000117662 | 14060000117662 | 1 | PA267200 | PM645502 |
| 14060000117670 | L14/dossiers | 14 | 14060000117669 | 14060000117669 | 1 | PA328 | PM653228 |
| 14060000117671 | L14/dossiers | 14 | 14060000117669 | 14060000117669 | 2 | PA2791 | PM653325 |
| 14060000117760 | L14/dossiers | 14 | 14060000117759 | 14060000117759 | 1 | PA2876 | PM645355 |