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 |
|---|---|---|---|---|---|---|---|
| 14060000122221 | L14/dossiers | 14 | 14060000122220 | 14060000122220 | 1 | PA266797 | PM645338 |
| 14060000122231 | L14/dossiers | 14 | 14060000122230 | 14060000122230 | 1 | PA335999 | PM696536 |
| 14060000122238 | L14/dossiers | 14 | 14060000122237 | 14060000122237 | 1 | PA267246 | PM645340 |
| 14060000122245 | L14/dossiers | 14 | 14060000122244 | 14060000122244 | 1 | PA346886 | PM695110 |
| 14060000122255 | L14/dossiers | 14 | 14060000122254 | 14060000122254 | 1 | PA267330 | PM645032 |
| 14060000122266 | L14/dossiers | 14 | 14060000122265 | 14060000122265 | 1 | PA330240 | PM645425 |
| 14060000122273 | L14/dossiers | 14 | 14060000122272 | 14060000122272 | 1 | PA267622 | PM702957 |
| 14060000122280 | L14/dossiers | 14 | 14060000122279 | 14060000122279 | 1 | PA328 | PM653228 |
| 14060000122319 | L14/dossiers | 14 | 14060000122318 | 14060000122318 | 1 | PA1364 | PM645084 |
| 14060000122326 | L14/dossiers | 14 | 14060000122325 | 14060000122325 | 1 | PA1761 | PM645501 |
| 14060000122340 | L14/dossiers | 14 | 14060000122339 | 14060000122339 | 1 | PA1874 | PM645474 |
| 14060000122347 | L14/dossiers | 14 | 14060000122346 | 14060000122346 | 1 | PA328 | PM653228 |
| 14060000122377 | L14/dossiers | 14 | 14060000122376 | 14060000122376 | 1 | PA267622 | PM702957 |
| 14060000122378 | L14/dossiers | 14 | 14060000122376 | 14060000122376 | 2 | PA2679 | PM714646 |
| 14060000122388 | L14/dossiers | 14 | 14060000122387 | 14060000122387 | 1 | PA1699 | PM645390 |
| 14060000122398 | L14/dossiers | 14 | 14060000122397 | 14060000122397 | 1 | PA2529 | PM645608 |
| 14060000122405 | L14/dossiers | 14 | 14060000122404 | 14060000122404 | 1 | PA346886 | PM695110 |
| 14060000122409 | L14/dossiers | 14 | 14060000122408 | 14060000122408 | 1 | PA330788 | PM645510 |
| 14060000122416 | L14/dossiers | 14 | 14060000122415 | 14060000122415 | 1 | PA328 | PM653228 |
| 14060000122435 | L14/dossiers | 14 | 14060000122434 | 14060000122434 | 1 | PA328 | PM653228 |
| 14060000122436 | L14/dossiers | 14 | 14060000122434 | 14060000122434 | 2 | PA1268 | PM653525 |
| 14060000122469 | L14/dossiers | 14 | 14060000122468 | 14060000122468 | 1 | PA267622 | PM702957 |
| 14060000122470 | L14/dossiers | 14 | 14060000122468 | 14060000122468 | 2 | PA2679 | PM714646 |
| 14060000122471 | L14/dossiers | 14 | 14060000122468 | 14060000122468 | 3 | PA2825 | PM711565 |
| 14060000122472 | L14/dossiers | 14 | 14060000122468 | 14060000122468 | 4 | PA429889 | PM711711 |
| 14060000122587 | L14/dossiers | 14 | 14060000122586 | 14060000122586 | 1 | PA346886 | PM695110 |
| 14060000122594 | L14/dossiers | 14 | 14060000122593 | 14060000122593 | 1 | PA2084 | PM645407 |
| 14060000122601 | L14/dossiers | 14 | 14060000122600 | 14060000122600 | 1 | PA2971 | PM645392 |
| 14060000122608 | L14/dossiers | 14 | 14060000122607 | 14060000122607 | 1 | PA328 | PM653228 |
| 14060000122609 | L14/dossiers | 14 | 14060000122607 | 14060000122607 | 2 | PA335999 | PM653292 |
| 14060000122616 | L14/dossiers | 14 | 14060000122615 | 14060000122615 | 1 | PA267622 | PM702957 |
| 14060000122623 | L14/dossiers | 14 | 14060000122622 | 14060000122622 | 1 | PA610313 | PM645122 |
| 14060000122624 | L14/dossiers | 14 | 14060000122622 | 14060000122622 | 2 | PA2952 | PM645464 |
| 14060000122680 | L14/dossiers | 14 | 14060000122679 | 14060000122679 | 1 | PA2971 | PM645392 |
| 14060000122687 | L14/dossiers | 14 | 14060000122686 | 14060000122686 | 1 | PA309643 | PM645326 |
| 14060000122694 | L14/dossiers | 14 | 14060000122693 | 14060000122693 | 1 | PA328 | PM653228 |
| 14060000122695 | L14/dossiers | 14 | 14060000122693 | 14060000122693 | 2 | PA2791 | PM653325 |
| 14060000122706 | L14/dossiers | 14 | 14060000122705 | 14060000122705 | 1 | PA267735 | PM645237 |
| 14060000122727 | L14/dossiers | 14 | 14060000122726 | 14060000122726 | 1 | PA267605 | PM645189 |
| 14060000122737 | L14/dossiers | 14 | 14060000122736 | 14060000122736 | 1 | PA346886 | PM695110 |
| 14060000122744 | L14/dossiers | 14 | 14060000122743 | 14060000122743 | 1 | PA267327 | PM645031 |
| 14060000122751 | L14/dossiers | 14 | 14060000122750 | 14060000122750 | 1 | PA610521 | PM645190 |
| 14060000122765 | L14/dossiers | 14 | 14060000122764 | 14060000122764 | 1 | PA1379 | PM645433 |
| 14060000122766 | L14/dossiers | 14 | 14060000122764 | 14060000122764 | 2 | PA607489 | PM645366 |
| 14060000122767 | L14/dossiers | 14 | 14060000122764 | 14060000122764 | 3 | PA609442 | PM645214 |
| 14060000122789 | L14/dossiers | 14 | 14060000122788 | 14060000122788 | 1 | PA606478 | PM645457 |
| 14060000122796 | L14/dossiers | 14 | 14060000122795 | 14060000122795 | 1 | PA709315 | PM709318 |
| 14060000122803 | L14/dossiers | 14 | 14060000122802 | 14060000122802 | 1 | PA1874 | PM645474 |
| 14060000122810 | L14/dossiers | 14 | 14060000122809 | 14060000122809 | 1 | PA608416 | PM645586 |
| 14060000122817 | L14/dossiers | 14 | 14060000122816 | 14060000122816 | 1 | PA1993 | PM651975 |