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 |
|---|---|---|---|---|---|---|---|
| 14060000097720 | L14/dossiers | 14 | 14060000097719 | 14060000097719 | 1 | PA328 | PM653228 |
| 14060000097721 | L14/dossiers | 14 | 14060000097719 | 14060000097719 | 2 | PA2240 | PM653295 |
| 14060000097806 | L14/dossiers | 14 | 14060000097805 | 14060000097805 | 1 | PA605557 | PM645507 |
| 14060000097816 | L14/dossiers | 14 | 14060000097815 | 14060000097815 | 1 | PA1874 | PM645474 |
| 14060000097823 | L14/dossiers | 14 | 14060000097822 | 14060000097822 | 1 | PA2073 | PM645207 |
| 14060000097830 | L14/dossiers | 14 | 14060000097829 | 14060000097829 | 1 | PA333421 | PM645375 |
| 14060000097842 | L14/dossiers | 14 | 14060000097841 | 14060000097841 | 1 | PA689 | PM645113 |
| 14060000097849 | L14/dossiers | 14 | 14060000097848 | 14060000097848 | 1 | PA1483 | PM645274 |
| 14060000097856 | L14/dossiers | 14 | 14060000097855 | 14060000097855 | 1 | PA2277 | PM645135 |
| 14060000097863 | L14/dossiers | 14 | 14060000097862 | 14060000097862 | 1 | PA415483 | PM703615 |
| 14060000097887 | L14/dossiers | 14 | 14060000097886 | 14060000097886 | 1 | PA606478 | PM645457 |
| 14060000097894 | L14/dossiers | 14 | 14060000097893 | 14060000097893 | 1 | PA267622 | PM702957 |
| 14060000097907 | L14/dossiers | 14 | 14060000097906 | 14060000097906 | 1 | PA266797 | PM645338 |
| 14060000097914 | L14/dossiers | 14 | 14060000097913 | 14060000097913 | 1 | PA606888 | PM645543 |
| 14060000097921 | L14/dossiers | 14 | 14060000097920 | 14060000097920 | 1 | PA328 | PM653228 |
| 14060000097922 | L14/dossiers | 14 | 14060000097920 | 14060000097920 | 2 | PA2240 | PM653295 |
| 14060000097952 | L14/dossiers | 14 | 14060000097951 | 14060000097951 | 1 | PA610775 | PM645309 |
| 14060000097959 | L14/dossiers | 14 | 14060000097958 | 14060000097958 | 1 | PA1931 | PM645042 |
| 14060000097963 | L14/dossiers | 14 | 14060000097962 | 14060000097962 | 1 | PA267492 | PM645465 |
| 14060000097970 | L14/dossiers | 14 | 14060000097969 | 14060000097969 | 1 | PA1886 | PM645099 |
| 14060000098068 | L14/dossiers | 14 | 14060000098067 | 14060000098067 | 1 | PA267622 | PM702957 |
| 14060000098069 | L14/dossiers | 14 | 14060000098067 | 14060000098067 | 2 | PA328 | PM711554 |
| 14060000098079 | L14/dossiers | 14 | 14060000098078 | 14060000098078 | 1 | PA267785 | PM645359 |
| 14060000098103 | L14/dossiers | 14 | 14060000098102 | 14060000098102 | 1 | PA267622 | PM702957 |
| 14060000098104 | L14/dossiers | 14 | 14060000098102 | 14060000098102 | 2 | PA415496 | PM702987 |
| 14060000098229 | L14/dossiers | 14 | 14060000098228 | 14060000098228 | 1 | PA415459 | PM415545 |
| 14060000098265 | L14/dossiers | 14 | 14060000098264 | 14060000098264 | 1 | PA608826 | PM645556 |
| 14060000098275 | L14/dossiers | 14 | 14060000098274 | 14060000098274 | 1 | PA1874 | PM645474 |
| 14060000098282 | L14/dossiers | 14 | 14060000098281 | 14060000098281 | 1 | PA785 | PM715797 |
| 14060000098289 | L14/dossiers | 14 | 14060000098288 | 14060000098288 | 1 | PA267551 | PM645372 |
| 14060000098296 | L14/dossiers | 14 | 14060000098295 | 14060000098295 | 1 | PA267492 | PM645465 |
| 14060000098300 | L14/dossiers | 14 | 14060000098299 | 14060000098299 | 1 | PA563 | PM645307 |
| 14060000098313 | L14/dossiers | 14 | 14060000098312 | 14060000098312 | 1 | PA344492 | PM645300 |
| 14060000098320 | L14/dossiers | 14 | 14060000098319 | 14060000098319 | 1 | PA713448 | PM713451 |
| 14060000098327 | L14/dossiers | 14 | 14060000098326 | 14060000098326 | 1 | PA267622 | PM702957 |
| 14060000098328 | L14/dossiers | 14 | 14060000098326 | 14060000098326 | 2 | PA1268 | PM702961 |
| 14060000098363 | L14/dossiers | 14 | 14060000098362 | 14060000098362 | 1 | PA335999 | PM696536 |
| 14060000098370 | L14/dossiers | 14 | 14060000098369 | 14060000098369 | 1 | PA334149 | PM645127 |
| 14060000098377 | L14/dossiers | 14 | 14060000098376 | 14060000098376 | 1 | PA689 | PM645113 |
| 14060000098384 | L14/dossiers | 14 | 14060000098383 | 14060000098383 | 1 | PA563 | PM645307 |
| 14060000098391 | L14/dossiers | 14 | 14060000098390 | 14060000098390 | 1 | PA267492 | PM645465 |
| 14060000098398 | L14/dossiers | 14 | 14060000098397 | 14060000098397 | 1 | PA267801 | PM645153 |
| 14060000098405 | L14/dossiers | 14 | 14060000098404 | 14060000098404 | 1 | PA1857 | PM645505 |
| 14060000098415 | L14/dossiers | 14 | 14060000098414 | 14060000098414 | 1 | PA267289 | PM645242 |
| 14060000098422 | L14/dossiers | 14 | 14060000098421 | 14060000098421 | 1 | PA1206 | PM645054 |
| 14060000098432 | L14/dossiers | 14 | 14060000098431 | 14060000098431 | 1 | PA1886 | PM645099 |
| 14060000098483 | L14/dossiers | 14 | 14060000098482 | 14060000098482 | 1 | PA330684 | PM645497 |
| 14060000098500 | L14/dossiers | 14 | 14060000098499 | 14060000098499 | 1 | PA429881 | PM430053 |
| 14060000098507 | L14/dossiers | 14 | 14060000098506 | 14060000098506 | 1 | PA328 | PM653228 |
| 14060000098552 | L14/dossiers | 14 | 14060000098551 | 14060000098551 | 1 | PA381 | PM645125 |