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 |
|---|---|---|---|---|---|---|---|
| 14060000109552 | L14/dossiers | 14 | 14060000109551 | 14060000109551 | 1 | PA1874 | PM645474 |
| 14060000109559 | L14/dossiers | 14 | 14060000109558 | 14060000109558 | 1 | PA1699 | PM645390 |
| 14060000109566 | L14/dossiers | 14 | 14060000109565 | 14060000109565 | 1 | PA267492 | PM645465 |
| 14060000109576 | L14/dossiers | 14 | 14060000109575 | 14060000109575 | 1 | PA267306 | PM645210 |
| 14060000109583 | L14/dossiers | 14 | 14060000109582 | 14060000109582 | 1 | PA785 | PM715797 |
| 14060000109590 | L14/dossiers | 14 | 14060000109589 | 14060000109589 | 1 | PA426327 | PM426337 |
| 14060000109615 | L14/dossiers | 14 | 14060000109614 | 14060000109614 | 1 | PA810 | PM645557 |
| 14060000109622 | L14/dossiers | 14 | 14060000109621 | 14060000109621 | 1 | PA563 | PM645307 |
| 14060000109629 | L14/dossiers | 14 | 14060000109628 | 14060000109628 | 1 | PA267457 | PM687216 |
| 14060000109636 | L14/dossiers | 14 | 14060000109635 | 14060000109635 | 1 | PA267785 | PM645359 |
| 14060000109643 | L14/dossiers | 14 | 14060000109642 | 14060000109642 | 1 | PA346886 | PM695110 |
| 14060000109650 | L14/dossiers | 14 | 14060000109649 | 14060000109649 | 1 | PA335054 | PM645614 |
| 14060000109651 | L14/dossiers | 14 | 14060000109649 | 14060000109649 | 2 | PA1445 | PM645563 |
| 14060000109666 | L14/dossiers | 14 | 14060000109665 | 14060000109665 | 1 | PA267622 | PM702957 |
| 14060000109667 | L14/dossiers | 14 | 14060000109665 | 14060000109665 | 2 | PA328 | PM711554 |
| 14060000109699 | L14/dossiers | 14 | 14060000109698 | 14060000109698 | 1 | PA346 | PM645086 |
| 14060000109706 | L14/dossiers | 14 | 14060000109705 | 14060000109705 | 1 | PA346886 | PM695110 |
| 14060000109713 | L14/dossiers | 14 | 14060000109712 | 14060000109712 | 1 | PA328 | PM653228 |
| 14060000109799 | L14/dossiers | 14 | 14060000109798 | 14060000109798 | 1 | PA268019 | PM645116 |
| 14060000109809 | L14/dossiers | 14 | 14060000109808 | 14060000109808 | 1 | PA2971 | PM645392 |
| 14060000109822 | L14/dossiers | 14 | 14060000109821 | 14060000109821 | 1 | PA1886 | PM645099 |
| 14060000109838 | L14/dossiers | 14 | 14060000109837 | 14060000109837 | 1 | PA267506 | PM645270 |
| 14060000109848 | L14/dossiers | 14 | 14060000109847 | 14060000109847 | 1 | PA267785 | PM645359 |
| 14060000109855 | L14/dossiers | 14 | 14060000109854 | 14060000109854 | 1 | PA267785 | PM645359 |
| 14060000109862 | L14/dossiers | 14 | 14060000109861 | 14060000109861 | 1 | PA429890 | PM543935 |
| 14060000109881 | L14/dossiers | 14 | 14060000109880 | 14060000109880 | 1 | PA334149 | PM645127 |
| 14060000109888 | L14/dossiers | 14 | 14060000109887 | 14060000109887 | 1 | PA2048 | PM693013 |
| 14060000109895 | L14/dossiers | 14 | 14060000109894 | 14060000109894 | 1 | PA1263 | PM645432 |
| 14060000109902 | L14/dossiers | 14 | 14060000109901 | 14060000109901 | 1 | PA2775 | PM645461 |
| 14060000109924 | L14/dossiers | 14 | 14060000109923 | 14060000109923 | 1 | PA328 | PM653228 |
| 14060000109957 | L14/dossiers | 14 | 14060000109956 | 14060000109956 | 1 | PA1886 | PM645099 |
| 14060000109986 | L14/dossiers | 14 | 14060000109985 | 14060000109985 | 1 | PA313924 | PM703546 |
| 14060000110010 | L14/dossiers | 14 | 14060000110009 | 14060000110009 | 1 | PA563 | PM645307 |
| 14060000110020 | L14/dossiers | 14 | 14060000110019 | 14060000110019 | 1 | PA267492 | PM645465 |
| 14060000110027 | L14/dossiers | 14 | 14060000110026 | 14060000110026 | 1 | PA2971 | PM645392 |
| 14060000110034 | L14/dossiers | 14 | 14060000110033 | 14060000110033 | 1 | PA328 | PM653228 |
| 14060000110064 | L14/dossiers | 14 | 14060000110063 | 14060000110063 | 1 | PA267327 | PM645031 |
| 14060000110074 | L14/dossiers | 14 | 14060000110073 | 14060000110073 | 1 | PA609726 | PM645311 |
| 14060000110081 | L14/dossiers | 14 | 14060000110080 | 14060000110080 | 1 | PA328 | PM653228 |
| 14060000110082 | L14/dossiers | 14 | 14060000110080 | 14060000110080 | 2 | PA2825 | PM653254 |
| 14060000110205 | L14/dossiers | 14 | 14060000110204 | 14060000110204 | 1 | PA328 | PM653228 |
| 14060000110206 | L14/dossiers | 14 | 14060000110204 | 14060000110204 | 2 | PA2240 | PM653295 |
| 14060000110283 | L14/dossiers | 14 | 14060000110282 | 14060000110282 | 1 | PA328 | PM653228 |
| 14060000110359 | L14/dossiers | 14 | 14060000110358 | 14060000110358 | 1 | PA266788 | PM645294 |
| 14060000110363 | L14/dossiers | 14 | 14060000110362 | 14060000110362 | 1 | PA328 | PM653228 |
| 14060000110364 | L14/dossiers | 14 | 14060000110362 | 14060000110362 | 2 | PA2240 | PM653295 |
| 14060000110477 | L14/dossiers | 14 | 14060000110476 | 14060000110476 | 1 | PA2011 | PM645434 |
| 14060000110484 | L14/dossiers | 14 | 14060000110483 | 14060000110483 | 1 | PA267785 | PM645359 |
| 14060000110491 | L14/dossiers | 14 | 14060000110490 | 14060000110490 | 1 | PA609218 | PM645132 |
| 14060000110501 | L14/dossiers | 14 | 14060000110500 | 14060000110500 | 1 | PA1857 | PM645505 |