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 |
|---|---|---|---|---|---|---|---|
| 15060000144691 | L15/dossiers | 15 | 15060000144690 | 15060000144690 | 1 | PA718884 | PM722488 |
| 15060000144698 | L15/dossiers | 15 | 15060000144697 | 15060000144697 | 1 | PA2377 | PM723550 |
| 15060000144705 | L15/dossiers | 15 | 15060000144704 | 15060000144704 | 1 | PA266776 | PM723542 |
| 15060000144712 | L15/dossiers | 15 | 15060000144711 | 15060000144711 | 1 | PA721960 | PM723434 |
| 15060000144719 | L15/dossiers | 15 | 15060000144718 | 15060000144718 | 1 | PA267260 | PM722476 |
| 15060000144726 | L15/dossiers | 15 | 15060000144725 | 15060000144725 | 1 | PA720846 | PM723094 |
| 15060000144733 | L15/dossiers | 15 | 15060000144732 | 15060000144732 | 1 | PA335999 | PM723480 |
| 15060000144740 | L15/dossiers | 15 | 15060000144739 | 15060000144739 | 1 | PA718838 | PM722474 |
| 15060000144744 | L15/dossiers | 15 | 15060000144743 | 15060000144743 | 1 | PA718838 | PM722474 |
| 15060000144751 | L15/dossiers | 15 | 15060000144750 | 15060000144750 | 1 | PA345619 | PM725692 |
| 15060000144752 | L15/dossiers | 15 | 15060000144750 | 15060000144750 | 2 | PA1872 | PM730104 |
| 15060000144790 | L15/dossiers | 15 | 15060000144789 | 15060000144789 | 1 | PA605036 | PM722444 |
| 15060000144797 | L15/dossiers | 15 | 15060000144796 | 15060000144796 | 1 | PA718876 | PM722486 |
| 15060000144804 | L15/dossiers | 15 | 15060000144803 | 15060000144803 | 1 | PA334149 | PM723034 |
| 15060000144811 | L15/dossiers | 15 | 15060000144810 | 15060000144810 | 1 | PA345619 | PM725692 |
| 15060000144978 | L15/dossiers | 15 | 15060000144977 | 15060000144977 | 1 | PA345619 | PM725692 |
| 15060000145009 | L15/dossiers | 15 | 15060000145008 | 15060000145008 | 1 | PA267306 | PM723054 |
| 15060000145019 | L15/dossiers | 15 | 15060000145018 | 15060000145018 | 1 | PA720798 | PM723080 |
| 15060000145026 | L15/dossiers | 15 | 15060000145025 | 15060000145025 | 1 | PA1874 | PM722598 |
| 15060000145036 | L15/dossiers | 15 | 15060000145035 | 15060000145035 | 1 | PA719272 | PM722612 |
| 15060000145043 | L15/dossiers | 15 | 15060000145042 | 15060000145042 | 1 | PA267378 | PM723344 |
| 15060000145050 | L15/dossiers | 15 | 15060000145049 | 15060000145049 | 1 | PA719272 | PM722612 |
| 15060000145057 | L15/dossiers | 15 | 15060000145056 | 15060000145056 | 1 | PA720614 | PM723016 |
| 15060000145064 | L15/dossiers | 15 | 15060000145063 | 15060000145063 | 1 | PA2086 | PM723450 |
| 15060000145074 | L15/dossiers | 15 | 15060000145073 | 15060000145073 | 1 | PA334654 | PM723566 |
| 15060000145081 | L15/dossiers | 15 | 15060000145080 | 15060000145080 | 1 | PA721474 | PM723286 |
| 15060000145088 | L15/dossiers | 15 | 15060000145087 | 15060000145087 | 1 | PA721474 | PM723286 |
| 15060000145095 | L15/dossiers | 15 | 15060000145094 | 15060000145094 | 1 | PA721474 | PM723286 |
| 15060000145102 | L15/dossiers | 15 | 15060000145101 | 15060000145101 | 1 | PA721932 | PM734586 |
| 15060000145109 | L15/dossiers | 15 | 15060000145108 | 15060000145108 | 1 | PA721410 | PM723266 |
| 15060000145116 | L15/dossiers | 15 | 15060000145115 | 15060000145115 | 1 | PA346218 | PM723348 |
| 15060000145123 | L15/dossiers | 15 | 15060000145122 | 15060000145122 | 1 | PA266808 | PM723264 |
| 15060000145130 | L15/dossiers | 15 | 15060000145129 | 15060000145129 | 1 | PA266808 | PM723264 |
| 15060000145137 | L15/dossiers | 15 | 15060000145136 | 15060000145136 | 1 | PA334149 | PM723034 |
| 15060000145144 | L15/dossiers | 15 | 15060000145143 | 15060000145143 | 1 | PA721046 | PM723154 |
| 15060000145151 | L15/dossiers | 15 | 15060000145150 | 15060000145150 | 1 | PA643103 | PM722614 |
| 15060000145155 | L15/dossiers | 15 | 15060000145154 | 15060000145154 | 1 | PA345619 | PM725692 |
| 15060000145156 | L15/dossiers | 15 | 15060000145154 | 15060000145154 | 2 | PA717157 | PM759776 |
| 15060000145239 | L15/dossiers | 15 | 15060000145238 | 15060000145238 | 1 | PA2449 | PM723036 |
| 15060000145240 | L15/dossiers | 15 | 15060000145238 | 15060000145238 | 2 | PA720684 | PM723040 |
| 15060000145250 | L15/dossiers | 15 | 15060000145249 | 15060000145249 | 1 | PA720846 | PM723094 |
| 15060000145257 | L15/dossiers | 15 | 15060000145256 | 15060000145256 | 1 | PA609590 | PM723326 |
| 15060000145264 | L15/dossiers | 15 | 15060000145263 | 15060000145263 | 1 | PA720644 | PM723026 |
| 15060000145271 | L15/dossiers | 15 | 15060000145270 | 15060000145270 | 1 | PA223837 | PM722458 |
| 15060000145278 | L15/dossiers | 15 | 15060000145277 | 15060000145277 | 1 | PA718784 | PM722456 |
| 15060000145285 | L15/dossiers | 15 | 15060000145284 | 15060000145284 | 1 | PA340853 | PM722534 |
| 15060000145292 | L15/dossiers | 15 | 15060000145291 | 15060000145291 | 1 | PA720092 | PM722858 |
| 15060000145317 | L15/dossiers | 15 | 15060000145316 | 15060000145316 | 1 | PA2086 | PM723450 |
| 15060000145324 | L15/dossiers | 15 | 15060000145323 | 15060000145323 | 1 | PA1874 | PM722598 |
| 15060000145331 | L15/dossiers | 15 | 15060000145330 | 15060000145330 | 1 | PA609726 | PM723426 |