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 |
|---|---|---|---|---|---|---|---|
| 14060000089653 | L14/dossiers | 14 | 14060000089652 | 14060000089652 | 1 | PA267622 | PM702957 |
| 14060000089660 | L14/dossiers | 14 | 14060000089659 | 14060000089659 | 1 | PA1874 | PM645474 |
| 14060000089667 | L14/dossiers | 14 | 14060000089666 | 14060000089666 | 1 | PA1857 | PM645505 |
| 14060000089674 | L14/dossiers | 14 | 14060000089673 | 14060000089673 | 1 | PA267622 | PM702957 |
| 14060000089675 | L14/dossiers | 14 | 14060000089673 | 14060000089673 | 2 | PA1268 | PM702961 |
| 14060000089707 | L14/dossiers | 14 | 14060000089706 | 14060000089706 | 1 | PA304082 | PM430056 |
| 14060000089722 | L14/dossiers | 14 | 14060000089721 | 14060000089721 | 1 | PA695100 | PM695111 |
| 14060000089729 | L14/dossiers | 14 | 14060000089728 | 14060000089728 | 1 | PA2792 | PM645308 |
| 14060000089736 | L14/dossiers | 14 | 14060000089735 | 14060000089735 | 1 | PA346886 | PM695110 |
| 14060000089743 | L14/dossiers | 14 | 14060000089742 | 14060000089742 | 1 | PA2377 | PM645591 |
| 14060000089750 | L14/dossiers | 14 | 14060000089749 | 14060000089749 | 1 | PA267080 | PM645531 |
| 14060000089768 | L14/dossiers | 14 | 14060000089767 | 14060000089767 | 1 | PA785 | PM715797 |
| 14060000089775 | L14/dossiers | 14 | 14060000089774 | 14060000089774 | 1 | PA346886 | PM695110 |
| 14060000089782 | L14/dossiers | 14 | 14060000089781 | 14060000089781 | 1 | PA328 | PM653228 |
| 14060000089783 | L14/dossiers | 14 | 14060000089781 | 14060000089781 | 2 | PA1268 | PM653525 |
| 14060000089821 | L14/dossiers | 14 | 14060000089820 | 14060000089820 | 1 | PA328 | PM653228 |
| 14060000089822 | L14/dossiers | 14 | 14060000089820 | 14060000089820 | 2 | PA2791 | PM653325 |
| 14060000089834 | L14/dossiers | 14 | 14060000089833 | 14060000089833 | 1 | PA334149 | PM645127 |
| 14060000089841 | L14/dossiers | 14 | 14060000089840 | 14060000089840 | 1 | PA1699 | PM645390 |
| 14060000089848 | L14/dossiers | 14 | 14060000089847 | 14060000089847 | 1 | PA2971 | PM645392 |
| 14060000089855 | L14/dossiers | 14 | 14060000089854 | 14060000089854 | 1 | PA267785 | PM645359 |
| 14060000089862 | L14/dossiers | 14 | 14060000089861 | 14060000089861 | 1 | PA2086 | PM645043 |
| 14060000089875 | L14/dossiers | 14 | 14060000089874 | 14060000089874 | 1 | PA267622 | PM702957 |
| 14060000089876 | L14/dossiers | 14 | 14060000089874 | 14060000089874 | 2 | PA588883 | PM706468 |
| 14060000089885 | L14/dossiers | 14 | 14060000089884 | 14060000089884 | 1 | PA267622 | PM702957 |
| 14060000089886 | L14/dossiers | 14 | 14060000089884 | 14060000089884 | 2 | PA328 | PM711554 |
| 14060000089920 | L14/dossiers | 14 | 14060000089919 | 14060000089919 | 1 | PA610427 | PM645158 |
| 14060000089974 | L14/dossiers | 14 | 14060000089973 | 14060000089973 | 1 | PA610830 | PM645039 |
| 14060000089985 | L14/dossiers | 14 | 14060000089984 | 14060000089984 | 1 | PA267622 | PM702957 |
| 14060000089986 | L14/dossiers | 14 | 14060000089984 | 14060000089984 | 2 | PA2679 | PM702976 |
| 14060000089993 | L14/dossiers | 14 | 14060000089992 | 14060000089992 | 1 | PA334654 | PM645596 |
| 14060000090007 | L14/dossiers | 14 | 14060000090006 | 14060000090006 | 1 | PA429866 | PM429954 |
| 14060000090037 | L14/dossiers | 14 | 14060000090036 | 14060000090036 | 1 | PA1152 | PM645561 |
| 14060000090044 | L14/dossiers | 14 | 14060000090043 | 14060000090043 | 1 | PA267306 | PM645210 |
| 14060000090051 | L14/dossiers | 14 | 14060000090050 | 14060000090050 | 1 | PA1886 | PM645099 |
| 14060000090059 | L14/dossiers | 14 | 14060000090058 | 14060000090058 | 1 | PA754 | PM645050 |
| 14060000090067 | L14/dossiers | 14 | 14060000090066 | 14060000090066 | 1 | PA713448 | PM713451 |
| 14060000090078 | L14/dossiers | 14 | 14060000090077 | 14060000090077 | 1 | PA608380 | PM645578 |
| 14060000090085 | L14/dossiers | 14 | 14060000090084 | 14060000090084 | 1 | PA267622 | PM700712 |
| 14060000090086 | L14/dossiers | 14 | 14060000090084 | 14060000090084 | 2 | PA2791 | PM700783 |
| 14060000090093 | L14/dossiers | 14 | 14060000090092 | 14060000090092 | 1 | PA266797 | PM645338 |
| 14060000090100 | L14/dossiers | 14 | 14060000090099 | 14060000090099 | 1 | PA328 | PM653228 |
| 14060000090129 | L14/dossiers | 14 | 14060000090128 | 14060000090128 | 1 | PA328 | PM653228 |
| 14060000090168 | L14/dossiers | 14 | 14060000090167 | 14060000090167 | 1 | PA267622 | PM702957 |
| 14060000090175 | L14/dossiers | 14 | 14060000090174 | 14060000090174 | 1 | PA346886 | PM695110 |
| 14060000090182 | L14/dossiers | 14 | 14060000090181 | 14060000090181 | 1 | PA1886 | PM645099 |
| 14060000090191 | L14/dossiers | 14 | 14060000090190 | 14060000090190 | 1 | PA267622 | PM702957 |
| 14060000090198 | L14/dossiers | 14 | 14060000090197 | 14060000090197 | 1 | PA609520 | PM645233 |
| 14060000090205 | L14/dossiers | 14 | 14060000090204 | 14060000090204 | 1 | PA267532 | PM645558 |
| 14060000090212 | L14/dossiers | 14 | 14060000090211 | 14060000090211 | 1 | PA2086 | PM645043 |