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 |
|---|---|---|---|---|---|---|---|
| 14060000115164 | L14/dossiers | 14 | 14060000115163 | 14060000115163 | 1 | PA330788 | PM645510 |
| 14060000115171 | L14/dossiers | 14 | 14060000115170 | 14060000115170 | 1 | PA2277 | PM645135 |
| 14060000115184 | L14/dossiers | 14 | 14060000115183 | 14060000115183 | 1 | PA609520 | PM645233 |
| 14060000115204 | L14/dossiers | 14 | 14060000115203 | 14060000115203 | 1 | PA346886 | PM695110 |
| 14060000115208 | L14/dossiers | 14 | 14060000115207 | 14060000115207 | 1 | PA328 | PM653228 |
| 14060000115239 | L14/dossiers | 14 | 14060000115238 | 14060000115238 | 1 | PA609764 | PM645323 |
| 14060000115246 | L14/dossiers | 14 | 14060000115245 | 14060000115245 | 1 | PA606098 | PM645171 |
| 14060000115253 | L14/dossiers | 14 | 14060000115252 | 14060000115252 | 1 | PA267622 | PM702957 |
| 14060000115291 | L14/dossiers | 14 | 14060000115290 | 14060000115290 | 1 | PA267246 | PM645340 |
| 14060000115298 | L14/dossiers | 14 | 14060000115297 | 14060000115297 | 1 | PA415482 | PM703556 |
| 14060000115310 | L14/dossiers | 14 | 14060000115309 | 14060000115309 | 1 | PA266788 | PM645294 |
| 14060000115317 | L14/dossiers | 14 | 14060000115316 | 14060000115316 | 1 | PA328 | PM653228 |
| 14060000115353 | L14/dossiers | 14 | 14060000115352 | 14060000115352 | 1 | PA605036 | PM645278 |
| 14060000115363 | L14/dossiers | 14 | 14060000115362 | 14060000115362 | 1 | PA328 | PM653228 |
| 14060000115364 | L14/dossiers | 14 | 14060000115362 | 14060000115362 | 2 | PA1268 | PM653525 |
| 14060000115398 | L14/dossiers | 14 | 14060000115397 | 14060000115397 | 1 | PA328 | PM653228 |
| 14060000115399 | L14/dossiers | 14 | 14060000115397 | 14060000115397 | 2 | PA2825 | PM653254 |
| 14060000115433 | L14/dossiers | 14 | 14060000115432 | 14060000115432 | 1 | PA267762 | PM645455 |
| 14060000115440 | L14/dossiers | 14 | 14060000115439 | 14060000115439 | 1 | PA2952 | PM645464 |
| 14060000115447 | L14/dossiers | 14 | 14060000115446 | 14060000115446 | 1 | PA304086 | PM430059 |
| 14060000115471 | L14/dossiers | 14 | 14060000115470 | 14060000115470 | 1 | PA267622 | PM702957 |
| 14060000115500 | L14/dossiers | 14 | 14060000115499 | 14060000115499 | 1 | PA1874 | PM645474 |
| 14060000115507 | L14/dossiers | 14 | 14060000115506 | 14060000115506 | 1 | PA785 | PM715797 |
| 14060000115515 | L14/dossiers | 14 | 14060000115514 | 14060000115514 | 1 | PA334149 | PM645127 |
| 14060000115529 | L14/dossiers | 14 | 14060000115528 | 14060000115528 | 1 | PA333134 | PM645341 |
| 14060000115536 | L14/dossiers | 14 | 14060000115535 | 14060000115535 | 1 | PA588872 | PM701032 |
| 14060000115546 | L14/dossiers | 14 | 14060000115545 | 14060000115545 | 1 | PA1838 | PM645238 |
| 14060000115553 | L14/dossiers | 14 | 14060000115552 | 14060000115552 | 1 | PA563 | PM645307 |
| 14060000115560 | L14/dossiers | 14 | 14060000115559 | 14060000115559 | 1 | PA2048 | PM693013 |
| 14060000115567 | L14/dossiers | 14 | 14060000115566 | 14060000115566 | 1 | PA2345 | PM645548 |
| 14060000115574 | L14/dossiers | 14 | 14060000115573 | 14060000115573 | 1 | PA334843 | PM645589 |
| 14060000115581 | L14/dossiers | 14 | 14060000115580 | 14060000115580 | 1 | PA266774 | PM645583 |
| 14060000115588 | L14/dossiers | 14 | 14060000115587 | 14060000115587 | 1 | PA606212 | PM645330 |
| 14060000115595 | L14/dossiers | 14 | 14060000115594 | 14060000115594 | 1 | PA328 | PM653228 |
| 14060000115596 | L14/dossiers | 14 | 14060000115594 | 14060000115594 | 2 | PA2912 | PM653346 |
| 14060000115686 | L14/dossiers | 14 | 14060000115685 | 14060000115685 | 1 | PA267151 | PM645165 |
| 14060000115693 | L14/dossiers | 14 | 14060000115692 | 14060000115692 | 1 | PA336316 | PM645298 |
| 14060000115700 | L14/dossiers | 14 | 14060000115699 | 14060000115699 | 1 | PA328 | PM653228 |
| 14060000115732 | L14/dossiers | 14 | 14060000115731 | 14060000115731 | 1 | PA267622 | PM702957 |
| 14060000115761 | L14/dossiers | 14 | 14060000115760 | 14060000115760 | 1 | PA268019 | PM645116 |
| 14060000115768 | L14/dossiers | 14 | 14060000115767 | 14060000115767 | 1 | PA608380 | PM645578 |
| 14060000115790 | L14/dossiers | 14 | 14060000115789 | 14060000115789 | 1 | PA2796 | PM645520 |
| 14060000115798 | L14/dossiers | 14 | 14060000115797 | 14060000115797 | 1 | PA267622 | PM702957 |
| 14060000115799 | L14/dossiers | 14 | 14060000115797 | 14060000115797 | 2 | PA331594 | PM711625 |
| 14060000115832 | L14/dossiers | 14 | 14060000115831 | 14060000115831 | 1 | PA295 | PM645103 |
| 14060000115845 | L14/dossiers | 14 | 14060000115844 | 14060000115844 | 1 | PA785 | PM715797 |
| 14060000115852 | L14/dossiers | 14 | 14060000115851 | 14060000115851 | 1 | PA267492 | PM645465 |
| 14060000115853 | L14/dossiers | 14 | 14060000115851 | 14060000115851 | 2 | PA551 | PM645487 |
| 14060000115860 | L14/dossiers | 14 | 14060000115859 | 14060000115859 | 1 | PA606098 | PM645171 |
| 14060000115867 | L14/dossiers | 14 | 14060000115866 | 14060000115866 | 1 | PA1459 | PM645518 |