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 |
|---|---|---|---|---|---|---|---|
| 14060000108829 | L14/dossiers | 14 | 14060000108828 | 14060000108828 | 1 | PA267794 | PM645442 |
| 14060000108836 | L14/dossiers | 14 | 14060000108835 | 14060000108835 | 1 | PA328 | PM653228 |
| 14060000108837 | L14/dossiers | 14 | 14060000108835 | 14060000108835 | 2 | PA333611 | PM653276 |
| 14060000108893 | L14/dossiers | 14 | 14060000108892 | 14060000108892 | 1 | PA735 | PM645089 |
| 14060000108903 | L14/dossiers | 14 | 14060000108902 | 14060000108902 | 1 | PA1713 | PM415520 |
| 14060000108918 | L14/dossiers | 14 | 14060000108917 | 14060000108917 | 1 | PA2011 | PM645434 |
| 14060000108925 | L14/dossiers | 14 | 14060000108924 | 14060000108924 | 1 | PA267306 | PM645210 |
| 14060000108932 | L14/dossiers | 14 | 14060000108931 | 14060000108931 | 1 | PA330684 | PM645497 |
| 14060000108939 | L14/dossiers | 14 | 14060000108938 | 14060000108938 | 1 | PA608662 | PM645592 |
| 14060000108943 | L14/dossiers | 14 | 14060000108942 | 14060000108942 | 1 | PA267622 | PM702957 |
| 14060000108944 | L14/dossiers | 14 | 14060000108942 | 14060000108942 | 2 | PA1268 | PM702961 |
| 14060000108972 | L14/dossiers | 14 | 14060000108971 | 14060000108971 | 1 | PA330788 | PM645510 |
| 14060000108979 | L14/dossiers | 14 | 14060000108978 | 14060000108978 | 1 | PA1886 | PM645099 |
| 14060000108986 | L14/dossiers | 14 | 14060000108985 | 14060000108985 | 1 | PA268019 | PM645116 |
| 14060000108993 | L14/dossiers | 14 | 14060000108992 | 14060000108992 | 1 | PA267622 | PM702957 |
| 14060000109013 | L14/dossiers | 14 | 14060000109012 | 14060000109012 | 1 | PA605922 | PM645493 |
| 14060000109055 | L14/dossiers | 14 | 14060000109054 | 14060000109054 | 1 | PA267260 | PM645459 |
| 14060000109062 | L14/dossiers | 14 | 14060000109061 | 14060000109061 | 1 | PA267260 | PM645459 |
| 14060000109069 | L14/dossiers | 14 | 14060000109068 | 14060000109068 | 1 | PA606478 | PM645457 |
| 14060000109076 | L14/dossiers | 14 | 14060000109075 | 14060000109075 | 1 | PA344492 | PM645300 |
| 14060000109083 | L14/dossiers | 14 | 14060000109082 | 14060000109082 | 1 | PA1699 | PM645390 |
| 14060000109090 | L14/dossiers | 14 | 14060000109089 | 14060000109089 | 1 | PA1886 | PM645099 |
| 14060000109097 | L14/dossiers | 14 | 14060000109096 | 14060000109096 | 1 | PA267622 | PM702957 |
| 14060000109128 | L14/dossiers | 14 | 14060000109127 | 14060000109127 | 1 | PA267260 | PM645459 |
| 14060000109135 | L14/dossiers | 14 | 14060000109134 | 14060000109134 | 1 | PA1886 | PM645099 |
| 14060000109228 | L14/dossiers | 14 | 14060000109227 | 14060000109227 | 1 | PA346886 | PM695110 |
| 14060000109235 | L14/dossiers | 14 | 14060000109234 | 14060000109234 | 1 | PA267673 | PM645249 |
| 14060000109242 | L14/dossiers | 14 | 14060000109241 | 14060000109241 | 1 | PA609726 | PM645311 |
| 14060000109249 | L14/dossiers | 14 | 14060000109248 | 14060000109248 | 1 | PA330008 | PM645164 |
| 14060000109259 | L14/dossiers | 14 | 14060000109258 | 14060000109258 | 1 | PA2952 | PM645464 |
| 14060000109266 | L14/dossiers | 14 | 14060000109265 | 14060000109265 | 1 | PA267042 | PM645368 |
| 14060000109273 | L14/dossiers | 14 | 14060000109272 | 14060000109272 | 1 | PA1695 | PM645157 |
| 14060000109324 | L14/dossiers | 14 | 14060000109323 | 14060000109323 | 1 | PA266788 | PM645294 |
| 14060000109331 | L14/dossiers | 14 | 14060000109330 | 14060000109330 | 1 | PA415473 | PM415566 |
| 14060000109376 | L14/dossiers | 14 | 14060000109375 | 14060000109375 | 1 | PA328 | PM653228 |
| 14060000109377 | L14/dossiers | 14 | 14060000109375 | 14060000109375 | 2 | PA1268 | PM653525 |
| 14060000109413 | L14/dossiers | 14 | 14060000109412 | 14060000109412 | 1 | PA267622 | PM702957 |
| 14060000109417 | L14/dossiers | 14 | 14060000109416 | 14060000109416 | 1 | PA267306 | PM645210 |
| 14060000109424 | L14/dossiers | 14 | 14060000109423 | 14060000109423 | 1 | PA267622 | PM702957 |
| 14060000109425 | L14/dossiers | 14 | 14060000109423 | 14060000109423 | 2 | PA1268 | PM702961 |
| 14060000109437 | L14/dossiers | 14 | 14060000109436 | 14060000109436 | 1 | PA267605 | PM645189 |
| 14060000109444 | L14/dossiers | 14 | 14060000109443 | 14060000109443 | 1 | PA1155 | PM645285 |
| 14060000109451 | L14/dossiers | 14 | 14060000109450 | 14060000109450 | 1 | PA230 | PM645553 |
| 14060000109458 | L14/dossiers | 14 | 14060000109457 | 14060000109457 | 1 | PA328 | PM653228 |
| 14060000109459 | L14/dossiers | 14 | 14060000109457 | 14060000109457 | 2 | PA1268 | PM653525 |
| 14060000109489 | L14/dossiers | 14 | 14060000109488 | 14060000109488 | 1 | PA266776 | PM645590 |
| 14060000109496 | L14/dossiers | 14 | 14060000109495 | 14060000109495 | 1 | PA429871 | PM430050 |
| 14060000109508 | L14/dossiers | 14 | 14060000109507 | 14060000109507 | 1 | PA1206 | PM645054 |
| 14060000109515 | L14/dossiers | 14 | 14060000109514 | 14060000109514 | 1 | PA266788 | PM645294 |
| 14060000109522 | L14/dossiers | 14 | 14060000109521 | 14060000109521 | 1 | PA267622 | PM702957 |