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 |
|---|---|---|---|---|---|---|---|
| 14060000112895 | L14/dossiers | 14 | 14060000112894 | 14060000112894 | 1 | PA1141 | PM645468 |
| 14060000112916 | L14/dossiers | 14 | 14060000112915 | 14060000112915 | 1 | PA267622 | PM702957 |
| 14060000112947 | L14/dossiers | 14 | 14060000112946 | 14060000112946 | 1 | PA1857 | PM645505 |
| 14060000112957 | L14/dossiers | 14 | 14060000112956 | 14060000112956 | 1 | PA230 | PM645553 |
| 14060000112964 | L14/dossiers | 14 | 14060000112963 | 14060000112963 | 1 | PA243 | PM645167 |
| 14060000112974 | L14/dossiers | 14 | 14060000112973 | 14060000112973 | 1 | PA330684 | PM645497 |
| 14060000112984 | L14/dossiers | 14 | 14060000112983 | 14060000112983 | 1 | PA2775 | PM645461 |
| 14060000112991 | L14/dossiers | 14 | 14060000112990 | 14060000112990 | 1 | PA230 | PM645553 |
| 14060000113049 | L14/dossiers | 14 | 14060000113048 | 14060000113048 | 1 | PA1699 | PM645390 |
| 14060000113056 | L14/dossiers | 14 | 14060000113055 | 14060000113055 | 1 | PA267492 | PM645465 |
| 14060000113063 | L14/dossiers | 14 | 14060000113062 | 14060000113062 | 1 | PA608826 | PM645556 |
| 14060000113070 | L14/dossiers | 14 | 14060000113069 | 14060000113069 | 1 | PA1585 | PM645094 |
| 14060000113077 | L14/dossiers | 14 | 14060000113076 | 14060000113076 | 1 | PA267622 | PM702957 |
| 14060000113085 | L14/dossiers | 14 | 14060000113084 | 14060000113084 | 1 | PA605991 | PM645081 |
| 14060000113103 | L14/dossiers | 14 | 14060000113102 | 14060000113102 | 1 | PA346886 | PM695110 |
| 14060000113110 | L14/dossiers | 14 | 14060000113109 | 14060000113109 | 1 | PA2971 | PM645392 |
| 14060000113123 | L14/dossiers | 14 | 14060000113122 | 14060000113122 | 1 | PA1886 | PM645099 |
| 14060000113150 | L14/dossiers | 14 | 14060000113149 | 14060000113149 | 1 | PA267622 | PM702957 |
| 14060000113151 | L14/dossiers | 14 | 14060000113149 | 14060000113149 | 2 | PA2679 | PM702976 |
| 14060000113152 | L14/dossiers | 14 | 14060000113149 | 14060000113149 | 3 | PA2825 | PM702962 |
| 14060000113271 | L14/dossiers | 14 | 14060000113270 | 14060000113270 | 1 | PA2124 | PM645475 |
| 14060000113278 | L14/dossiers | 14 | 14060000113277 | 14060000113277 | 1 | PA605349 | PM645483 |
| 14060000113279 | L14/dossiers | 14 | 14060000113277 | 14060000113277 | 2 | PA543 | PM645064 |
| 14060000113283 | L14/dossiers | 14 | 14060000113282 | 14060000113282 | 1 | PA267260 | PM645459 |
| 14060000113290 | L14/dossiers | 14 | 14060000113289 | 14060000113289 | 1 | PA330684 | PM645497 |
| 14060000113300 | L14/dossiers | 14 | 14060000113299 | 14060000113299 | 1 | PA267622 | PM702957 |
| 14060000113333 | L14/dossiers | 14 | 14060000113332 | 14060000113332 | 1 | PA606478 | PM645457 |
| 14060000113337 | L14/dossiers | 14 | 14060000113336 | 14060000113336 | 1 | PA328 | PM653228 |
| 14060000113338 | L14/dossiers | 14 | 14060000113336 | 14060000113336 | 2 | PA1268 | PM653525 |
| 14060000113349 | L14/dossiers | 14 | 14060000113348 | 14060000113348 | 1 | PA2011 | PM645434 |
| 14060000113356 | L14/dossiers | 14 | 14060000113355 | 14060000113355 | 1 | PA606098 | PM645171 |
| 14060000113363 | L14/dossiers | 14 | 14060000113362 | 14060000113362 | 1 | PA328 | PM653228 |
| 14060000113393 | L14/dossiers | 14 | 14060000113392 | 14060000113392 | 1 | PA267622 | PM702957 |
| 14060000113394 | L14/dossiers | 14 | 14060000113392 | 14060000113392 | 2 | PA2650 | PM711559 |
| 14060000113402 | L14/dossiers | 14 | 14060000113401 | 14060000113401 | 1 | PA1243 | PM645371 |
| 14060000113453 | L14/dossiers | 14 | 14060000113452 | 14060000113452 | 1 | PA328 | PM653228 |
| 14060000113454 | L14/dossiers | 14 | 14060000113452 | 14060000113452 | 2 | PA267622 | PM653322 |
| 14060000113463 | L14/dossiers | 14 | 14060000113462 | 14060000113462 | 1 | PA2774 | PM429910 |
| 14060000113490 | L14/dossiers | 14 | 14060000113489 | 14060000113489 | 1 | PA330240 | PM645425 |
| 14060000113497 | L14/dossiers | 14 | 14060000113496 | 14060000113496 | 1 | PA606478 | PM645457 |
| 14060000113504 | L14/dossiers | 14 | 14060000113503 | 14060000113503 | 1 | PA607603 | PM645379 |
| 14060000113511 | L14/dossiers | 14 | 14060000113510 | 14060000113510 | 1 | PA267204 | PM645551 |
| 14060000113521 | L14/dossiers | 14 | 14060000113520 | 14060000113520 | 1 | PA610905 | PM645225 |
| 14060000113522 | L14/dossiers | 14 | 14060000113520 | 14060000113520 | 2 | PA608380 | PM645578 |
| 14060000113532 | L14/dossiers | 14 | 14060000113531 | 14060000113531 | 1 | PA859 | PM415563 |
| 14060000113553 | L14/dossiers | 14 | 14060000113552 | 14060000113552 | 1 | PA1445 | PM645563 |
| 14060000113560 | L14/dossiers | 14 | 14060000113559 | 14060000113559 | 1 | PA267622 | PM702957 |
| 14060000113561 | L14/dossiers | 14 | 14060000113559 | 14060000113559 | 2 | PA2679 | PM702976 |
| 14060000113562 | L14/dossiers | 14 | 14060000113559 | 14060000113559 | 3 | PA2825 | PM702962 |
| 14060000113676 | L14/dossiers | 14 | 14060000113675 | 14060000113675 | 1 | PA2952 | PM645464 |