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 |
|---|---|---|---|---|---|---|---|
| 14060000101978 | L14/dossiers | 14 | 14060000101977 | 14060000101977 | 1 | PA343623 | PM645408 |
| 14060000101985 | L14/dossiers | 14 | 14060000101984 | 14060000101984 | 1 | PA785 | PM715797 |
| 14060000101986 | L14/dossiers | 14 | 14060000101984 | 14060000101984 | 2 | PA328 | PM715800 |
| 14060000101996 | L14/dossiers | 14 | 14060000101995 | 14060000101995 | 1 | PA335159 | PM645554 |
| 14060000102003 | L14/dossiers | 14 | 14060000102002 | 14060000102002 | 1 | PA328 | PM653228 |
| 14060000102004 | L14/dossiers | 14 | 14060000102002 | 14060000102002 | 2 | PA1268 | PM653525 |
| 14060000102014 | L14/dossiers | 14 | 14060000102013 | 14060000102013 | 1 | PA267080 | PM645531 |
| 14060000102021 | L14/dossiers | 14 | 14060000102020 | 14060000102020 | 1 | PA609726 | PM645311 |
| 14060000102034 | L14/dossiers | 14 | 14060000102033 | 14060000102033 | 1 | PA610481 | PM645131 |
| 14060000102041 | L14/dossiers | 14 | 14060000102040 | 14060000102040 | 1 | PA609764 | PM645323 |
| 14060000102048 | L14/dossiers | 14 | 14060000102047 | 14060000102047 | 1 | PA328 | PM653228 |
| 14060000102049 | L14/dossiers | 14 | 14060000102047 | 14060000102047 | 2 | PA2791 | PM653325 |
| 14060000102062 | L14/dossiers | 14 | 14060000102061 | 14060000102061 | 1 | PA334149 | PM645127 |
| 14060000102069 | L14/dossiers | 14 | 14060000102068 | 14060000102068 | 1 | PA330240 | PM645425 |
| 14060000102079 | L14/dossiers | 14 | 14060000102078 | 14060000102078 | 1 | PA267204 | PM645551 |
| 14060000102086 | L14/dossiers | 14 | 14060000102085 | 14060000102085 | 1 | PA2792 | PM645308 |
| 14060000102093 | L14/dossiers | 14 | 14060000102092 | 14060000102092 | 1 | PA2664 | PM645139 |
| 14060000102100 | L14/dossiers | 14 | 14060000102099 | 14060000102099 | 1 | PA2257 | PM645201 |
| 14060000102107 | L14/dossiers | 14 | 14060000102106 | 14060000102106 | 1 | PA709315 | PM709318 |
| 14060000102114 | L14/dossiers | 14 | 14060000102113 | 14060000102113 | 1 | PA267622 | PM702957 |
| 14060000102152 | L14/dossiers | 14 | 14060000102151 | 14060000102151 | 1 | PA2048 | PM693013 |
| 14060000102159 | L14/dossiers | 14 | 14060000102158 | 14060000102158 | 1 | PA610313 | PM645122 |
| 14060000102160 | L14/dossiers | 14 | 14060000102158 | 14060000102158 | 2 | PA2952 | PM645464 |
| 14060000102220 | L14/dossiers | 14 | 14060000102219 | 14060000102219 | 1 | PA1871 | PM645374 |
| 14060000102225 | L14/dossiers | 14 | 14060000102224 | 14060000102224 | 1 | PA2876 | PM645355 |
| 14060000102232 | L14/dossiers | 14 | 14060000102231 | 14060000102231 | 1 | PA607155 | PM645200 |
| 14060000102246 | L14/dossiers | 14 | 14060000102245 | 14060000102245 | 1 | PA267506 | PM645270 |
| 14060000102256 | L14/dossiers | 14 | 14060000102255 | 14060000102255 | 1 | PA689 | PM645113 |
| 14060000102263 | L14/dossiers | 14 | 14060000102262 | 14060000102262 | 1 | PA267042 | PM645368 |
| 14060000102270 | L14/dossiers | 14 | 14060000102269 | 14060000102269 | 1 | PA610291 | PM645119 |
| 14060000102280 | L14/dossiers | 14 | 14060000102279 | 14060000102279 | 1 | PA2277 | PM645135 |
| 14060000102287 | L14/dossiers | 14 | 14060000102286 | 14060000102286 | 1 | PA810 | PM645557 |
| 14060000102297 | L14/dossiers | 14 | 14060000102296 | 14060000102296 | 1 | PA607846 | PM645441 |
| 14060000102310 | L14/dossiers | 14 | 14060000102309 | 14060000102309 | 1 | PA346886 | PM695110 |
| 14060000102320 | L14/dossiers | 14 | 14060000102319 | 14060000102319 | 1 | PA1886 | PM645099 |
| 14060000102331 | L14/dossiers | 14 | 14060000102330 | 14060000102330 | 1 | PA1521 | PM645078 |
| 14060000102338 | L14/dossiers | 14 | 14060000102337 | 14060000102337 | 1 | PA304062 | PM304247 |
| 14060000102350 | L14/dossiers | 14 | 14060000102349 | 14060000102349 | 1 | PA267743 | PM645058 |
| 14060000102357 | L14/dossiers | 14 | 14060000102356 | 14060000102356 | 1 | PA605084 | PM645537 |
| 14060000102377 | L14/dossiers | 14 | 14060000102376 | 14060000102376 | 1 | PA266788 | PM645294 |
| 14060000102384 | L14/dossiers | 14 | 14060000102383 | 14060000102383 | 1 | PA2971 | PM645392 |
| 14060000102398 | L14/dossiers | 14 | 14060000102397 | 14060000102397 | 1 | PA328 | PM653228 |
| 14060000102399 | L14/dossiers | 14 | 14060000102397 | 14060000102397 | 2 | PA1268 | PM653525 |
| 14060000102428 | L14/dossiers | 14 | 14060000102427 | 14060000102427 | 1 | PA346886 | PM695110 |
| 14060000102432 | L14/dossiers | 14 | 14060000102431 | 14060000102431 | 1 | PA335054 | PM645614 |
| 14060000102433 | L14/dossiers | 14 | 14060000102431 | 14060000102431 | 2 | PA1012 | PM645168 |
| 14060000102451 | L14/dossiers | 14 | 14060000102450 | 14060000102450 | 1 | PA268019 | PM645116 |
| 14060000102458 | L14/dossiers | 14 | 14060000102457 | 14060000102457 | 1 | PA267622 | PM702957 |
| 14060000102468 | L14/dossiers | 14 | 14060000102467 | 14060000102467 | 1 | PA268019 | PM645116 |
| 14060000102475 | L14/dossiers | 14 | 14060000102474 | 14060000102474 | 1 | PA343623 | PM645408 |