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 |
|---|---|---|---|---|---|---|---|
| 14060000112374 | L14/dossiers | 14 | 14060000112373 | 14060000112373 | 1 | PA785 | PM715797 |
| 14060000112383 | L14/dossiers | 14 | 14060000112382 | 14060000112382 | 1 | PA267622 | PM702957 |
| 14060000112390 | L14/dossiers | 14 | 14060000112389 | 14060000112389 | 1 | PA267794 | PM645442 |
| 14060000112397 | L14/dossiers | 14 | 14060000112396 | 14060000112396 | 1 | PA2690 | PM645458 |
| 14060000112404 | L14/dossiers | 14 | 14060000112403 | 14060000112403 | 1 | PA266788 | PM645294 |
| 14060000112411 | L14/dossiers | 14 | 14060000112410 | 14060000112410 | 1 | PA2664 | PM645139 |
| 14060000112421 | L14/dossiers | 14 | 14060000112420 | 14060000112420 | 1 | PA266788 | PM645294 |
| 14060000112428 | L14/dossiers | 14 | 14060000112427 | 14060000112427 | 1 | PA267622 | PM702957 |
| 14060000112435 | L14/dossiers | 14 | 14060000112434 | 14060000112434 | 1 | PA1310 | PM645047 |
| 14060000112446 | L14/dossiers | 14 | 14060000112445 | 14060000112445 | 1 | PA266788 | PM645294 |
| 14060000112453 | L14/dossiers | 14 | 14060000112452 | 14060000112452 | 1 | PA227024 | PM430029 |
| 14060000112454 | L14/dossiers | 14 | 14060000112452 | 14060000112452 | 2 | PA304082 | PM430056 |
| 14060000112488 | L14/dossiers | 14 | 14060000112487 | 14060000112487 | 1 | PA609520 | PM645233 |
| 14060000112495 | L14/dossiers | 14 | 14060000112494 | 14060000112494 | 1 | PA1874 | PM645474 |
| 14060000112505 | L14/dossiers | 14 | 14060000112504 | 14060000112504 | 1 | PA1695 | PM645157 |
| 14060000112522 | L14/dossiers | 14 | 14060000112521 | 14060000112521 | 1 | PA917 | PM645163 |
| 14060000112529 | L14/dossiers | 14 | 14060000112528 | 14060000112528 | 1 | PA2098 | PM645351 |
| 14060000112536 | L14/dossiers | 14 | 14060000112535 | 14060000112535 | 1 | PA687214 | PM687217 |
| 14060000112553 | L14/dossiers | 14 | 14060000112552 | 14060000112552 | 1 | PA266788 | PM645294 |
| 14060000112560 | L14/dossiers | 14 | 14060000112559 | 14060000112559 | 1 | PA2011 | PM645434 |
| 14060000112567 | L14/dossiers | 14 | 14060000112566 | 14060000112566 | 1 | PA328 | PM653228 |
| 14060000112568 | L14/dossiers | 14 | 14060000112566 | 14060000112566 | 2 | PA2679 | PM653358 |
| 14060000112577 | L14/dossiers | 14 | 14060000112576 | 14060000112576 | 1 | PA346886 | PM695110 |
| 14060000112584 | L14/dossiers | 14 | 14060000112583 | 14060000112583 | 1 | PA332747 | PM645155 |
| 14060000112591 | L14/dossiers | 14 | 14060000112590 | 14060000112590 | 1 | PA609245 | PM645150 |
| 14060000112598 | L14/dossiers | 14 | 14060000112597 | 14060000112597 | 1 | PA689 | PM645113 |
| 14060000112605 | L14/dossiers | 14 | 14060000112604 | 14060000112604 | 1 | PA332747 | PM645155 |
| 14060000112626 | L14/dossiers | 14 | 14060000112625 | 14060000112625 | 1 | PA1435 | PM415548 |
| 14060000112641 | L14/dossiers | 14 | 14060000112640 | 14060000112640 | 1 | PA606225 | PM645336 |
| 14060000112648 | L14/dossiers | 14 | 14060000112647 | 14060000112647 | 1 | PA267622 | PM702957 |
| 14060000112655 | L14/dossiers | 14 | 14060000112654 | 14060000112654 | 1 | PA266788 | PM645294 |
| 14060000112668 | L14/dossiers | 14 | 14060000112667 | 14060000112667 | 1 | PA267622 | PM702957 |
| 14060000112697 | L14/dossiers | 14 | 14060000112696 | 14060000112696 | 1 | PA563 | PM645307 |
| 14060000112704 | L14/dossiers | 14 | 14060000112703 | 14060000112703 | 1 | PA1886 | PM645099 |
| 14060000112711 | L14/dossiers | 14 | 14060000112710 | 14060000112710 | 1 | PA2664 | PM645139 |
| 14060000112718 | L14/dossiers | 14 | 14060000112717 | 14060000112717 | 1 | PA1886 | PM645099 |
| 14060000112761 | L14/dossiers | 14 | 14060000112760 | 14060000112760 | 1 | PA2597 | PM645126 |
| 14060000112768 | L14/dossiers | 14 | 14060000112767 | 14060000112767 | 1 | PA563 | PM645307 |
| 14060000112775 | L14/dossiers | 14 | 14060000112774 | 14060000112774 | 1 | PA1466 | PM645240 |
| 14060000112782 | L14/dossiers | 14 | 14060000112781 | 14060000112781 | 1 | PA2815 | PM645514 |
| 14060000112789 | L14/dossiers | 14 | 14060000112788 | 14060000112788 | 1 | PA785 | PM715797 |
| 14060000112796 | L14/dossiers | 14 | 14060000112795 | 14060000112795 | 1 | PA606495 | PM645463 |
| 14060000112809 | L14/dossiers | 14 | 14060000112808 | 14060000112808 | 1 | PA2597 | PM645126 |
| 14060000112816 | L14/dossiers | 14 | 14060000112815 | 14060000112815 | 1 | PA703490 | PM703631 |
| 14060000112847 | L14/dossiers | 14 | 14060000112846 | 14060000112846 | 1 | PA606212 | PM645330 |
| 14060000112854 | L14/dossiers | 14 | 14060000112853 | 14060000112853 | 1 | PA266788 | PM645294 |
| 14060000112861 | L14/dossiers | 14 | 14060000112860 | 14060000112860 | 1 | PA267492 | PM645465 |
| 14060000112868 | L14/dossiers | 14 | 14060000112867 | 14060000112867 | 1 | PA609764 | PM645323 |
| 14060000112878 | L14/dossiers | 14 | 14060000112877 | 14060000112877 | 1 | PA267622 | PM702957 |
| 14060000112888 | L14/dossiers | 14 | 14060000112887 | 14060000112887 | 1 | PA2876 | PM645355 |