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 |
|---|---|---|---|---|---|---|---|
| 14060000136088 | L14/dossiers | 14 | 14060000136087 | 14060000136087 | 1 | PA2048 | PM693013 |
| 14060000136095 | L14/dossiers | 14 | 14060000136094 | 14060000136094 | 1 | PA1886 | PM645099 |
| 14060000136125 | L14/dossiers | 14 | 14060000136124 | 14060000136124 | 1 | PA267622 | PM702957 |
| 14060000136132 | L14/dossiers | 14 | 14060000136131 | 14060000136131 | 1 | PA346886 | PM695110 |
| 14060000136139 | L14/dossiers | 14 | 14060000136138 | 14060000136138 | 1 | PA785 | PM715797 |
| 14060000136147 | L14/dossiers | 14 | 14060000136146 | 14060000136146 | 1 | PA267762 | PM645455 |
| 14060000136154 | L14/dossiers | 14 | 14060000136153 | 14060000136153 | 1 | PA267762 | PM645455 |
| 14060000136162 | L14/dossiers | 14 | 14060000136161 | 14060000136161 | 1 | PA415474 | PM415568 |
| 14060000136163 | L14/dossiers | 14 | 14060000136161 | 14060000136161 | 2 | PA429854 | PM430047 |
| 14060000136175 | L14/dossiers | 14 | 14060000136174 | 14060000136174 | 1 | PA267743 | PM645058 |
| 14060000136182 | L14/dossiers | 14 | 14060000136181 | 14060000136181 | 1 | PA267622 | PM702957 |
| 14060000136183 | L14/dossiers | 14 | 14060000136181 | 14060000136181 | 2 | PA408 | PM711568 |
| 14060000136271 | L14/dossiers | 14 | 14060000136270 | 14060000136270 | 1 | PA267822 | PM645151 |
| 14060000136278 | L14/dossiers | 14 | 14060000136277 | 14060000136277 | 1 | PA266788 | PM645294 |
| 14060000136285 | L14/dossiers | 14 | 14060000136284 | 14060000136284 | 1 | PA2952 | PM645464 |
| 14060000136292 | L14/dossiers | 14 | 14060000136291 | 14060000136291 | 1 | PA267785 | PM645359 |
| 14060000136299 | L14/dossiers | 14 | 14060000136298 | 14060000136298 | 1 | PA336316 | PM645298 |
| 14060000136306 | L14/dossiers | 14 | 14060000136305 | 14060000136305 | 1 | PA610667 | PM645269 |
| 14060000136313 | L14/dossiers | 14 | 14060000136312 | 14060000136312 | 1 | PA429860 | PM429990 |
| 14060000136323 | L14/dossiers | 14 | 14060000136322 | 14060000136322 | 1 | PA330684 | PM645497 |
| 14060000136330 | L14/dossiers | 14 | 14060000136329 | 14060000136329 | 1 | PA610860 | PM645212 |
| 14060000136340 | L14/dossiers | 14 | 14060000136339 | 14060000136339 | 1 | PA267429 | PM645130 |
| 14060000136347 | L14/dossiers | 14 | 14060000136346 | 14060000136346 | 1 | PA331481 | PM645136 |
| 14060000136354 | L14/dossiers | 14 | 14060000136353 | 14060000136353 | 1 | PA687214 | PM687217 |
| 14060000136361 | L14/dossiers | 14 | 14060000136360 | 14060000136360 | 1 | PA607846 | PM645441 |
| 14060000136368 | L14/dossiers | 14 | 14060000136367 | 14060000136367 | 1 | PA266776 | PM645590 |
| 14060000136375 | L14/dossiers | 14 | 14060000136374 | 14060000136374 | 1 | PA314 | PM645292 |
| 14060000136382 | L14/dossiers | 14 | 14060000136381 | 14060000136381 | 1 | PA2664 | PM645139 |
| 14060000136392 | L14/dossiers | 14 | 14060000136391 | 14060000136391 | 1 | PA785 | PM715797 |
| 14060000136399 | L14/dossiers | 14 | 14060000136398 | 14060000136398 | 1 | PA1886 | PM645099 |
| 14060000136400 | L14/dossiers | 14 | 14060000136398 | 14060000136398 | 2 | PA606202 | PM645327 |
| 14060000136443 | L14/dossiers | 14 | 14060000136442 | 14060000136442 | 1 | PA267622 | PM702957 |
| 14060000136473 | L14/dossiers | 14 | 14060000136472 | 14060000136472 | 1 | PA2801 | PM645576 |
| 14060000136483 | L14/dossiers | 14 | 14060000136482 | 14060000136482 | 1 | PA2893 | PM430068 |
| 14060000136496 | L14/dossiers | 14 | 14060000136495 | 14060000136495 | 1 | PA267492 | PM645465 |
| 14060000136503 | L14/dossiers | 14 | 14060000136502 | 14060000136502 | 1 | PA335054 | PM645614 |
| 14060000136504 | L14/dossiers | 14 | 14060000136502 | 14060000136502 | 2 | PA1012 | PM645168 |
| 14060000136514 | L14/dossiers | 14 | 14060000136513 | 14060000136513 | 1 | PA1960 | PM645107 |
| 14060000136521 | L14/dossiers | 14 | 14060000136520 | 14060000136520 | 1 | PA415453 | PM415533 |
| 14060000136545 | L14/dossiers | 14 | 14060000136544 | 14060000136544 | 1 | PA328 | PM653228 |
| 14060000136546 | L14/dossiers | 14 | 14060000136544 | 14060000136544 | 2 | PA1268 | PM653525 |
| 14060000136579 | L14/dossiers | 14 | 14060000136578 | 14060000136578 | 1 | PA267785 | PM645359 |
| 14060000136586 | L14/dossiers | 14 | 14060000136585 | 14060000136585 | 1 | PA267622 | PM702957 |
| 14060000136593 | L14/dossiers | 14 | 14060000136592 | 14060000136592 | 1 | PA689 | PM645113 |
| 14060000136600 | L14/dossiers | 14 | 14060000136599 | 14060000136599 | 1 | PA266797 | PM645338 |
| 14060000136610 | L14/dossiers | 14 | 14060000136609 | 14060000136609 | 1 | PA2792 | PM645308 |
| 14060000136617 | L14/dossiers | 14 | 14060000136616 | 14060000136616 | 1 | PA785 | PM715797 |
| 14060000136624 | L14/dossiers | 14 | 14060000136623 | 14060000136623 | 1 | PA1886 | PM645099 |
| 14060000136665 | L14/dossiers | 14 | 14060000136664 | 14060000136664 | 1 | PA610775 | PM645309 |
| 14060000136672 | L14/dossiers | 14 | 14060000136671 | 14060000136671 | 1 | PA333421 | PM645375 |