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 |
|---|---|---|---|---|---|---|---|
| 14060000124297 | L14/dossiers | 14 | 14060000124296 | 14060000124296 | 1 | PA346 | PM645086 |
| 14060000124304 | L14/dossiers | 14 | 14060000124303 | 14060000124303 | 1 | PA608662 | PM645592 |
| 14060000124311 | L14/dossiers | 14 | 14060000124310 | 14060000124310 | 1 | PA267785 | PM645359 |
| 14060000124321 | L14/dossiers | 14 | 14060000124320 | 14060000124320 | 1 | PA267622 | PM702957 |
| 14060000124322 | L14/dossiers | 14 | 14060000124320 | 14060000124320 | 2 | PA328 | PM711554 |
| 14060000124354 | L14/dossiers | 14 | 14060000124353 | 14060000124353 | 1 | PA605036 | PM645278 |
| 14060000124361 | L14/dossiers | 14 | 14060000124360 | 14060000124360 | 1 | PA330240 | PM645425 |
| 14060000124368 | L14/dossiers | 14 | 14060000124367 | 14060000124367 | 1 | PA605694 | PM645416 |
| 14060000124376 | L14/dossiers | 14 | 14060000124375 | 14060000124375 | 1 | PA328 | PM653228 |
| 14060000124377 | L14/dossiers | 14 | 14060000124375 | 14060000124375 | 2 | PA2240 | PM653295 |
| 14060000124522 | L14/dossiers | 14 | 14060000124521 | 14060000124521 | 1 | PA1931 | PM645042 |
| 14060000124529 | L14/dossiers | 14 | 14060000124528 | 14060000124528 | 1 | PA267622 | PM702957 |
| 14060000124530 | L14/dossiers | 14 | 14060000124528 | 14060000124528 | 2 | PA2791 | PM702981 |
| 14060000124582 | L14/dossiers | 14 | 14060000124581 | 14060000124581 | 1 | PA563 | PM645307 |
| 14060000124592 | L14/dossiers | 14 | 14060000124591 | 14060000124591 | 1 | PA1379 | PM645433 |
| 14060000124599 | L14/dossiers | 14 | 14060000124598 | 14060000124598 | 1 | PA1790 | PM645324 |
| 14060000124606 | L14/dossiers | 14 | 14060000124605 | 14060000124605 | 1 | PA346886 | PM695110 |
| 14060000124613 | L14/dossiers | 14 | 14060000124612 | 14060000124612 | 1 | PA267622 | PM702957 |
| 14060000124643 | L14/dossiers | 14 | 14060000124642 | 14060000124642 | 1 | PA330240 | PM645425 |
| 14060000124650 | L14/dossiers | 14 | 14060000124649 | 14060000124649 | 1 | PA346 | PM645086 |
| 14060000124657 | L14/dossiers | 14 | 14060000124656 | 14060000124656 | 1 | PA1012 | PM645168 |
| 14060000124667 | L14/dossiers | 14 | 14060000124666 | 14060000124666 | 1 | PA2971 | PM645392 |
| 14060000124674 | L14/dossiers | 14 | 14060000124673 | 14060000124673 | 1 | PA333421 | PM645375 |
| 14060000124678 | L14/dossiers | 14 | 14060000124677 | 14060000124677 | 1 | PA266797 | PM645338 |
| 14060000124685 | L14/dossiers | 14 | 14060000124684 | 14060000124684 | 1 | PA266788 | PM645294 |
| 14060000124692 | L14/dossiers | 14 | 14060000124691 | 14060000124691 | 1 | PA2011 | PM645434 |
| 14060000124699 | L14/dossiers | 14 | 14060000124698 | 14060000124698 | 1 | PA267622 | PM700712 |
| 14060000124730 | L14/dossiers | 14 | 14060000124729 | 14060000124729 | 1 | PA267506 | PM645270 |
| 14060000124737 | L14/dossiers | 14 | 14060000124736 | 14060000124736 | 1 | PA328 | PM653228 |
| 14060000124738 | L14/dossiers | 14 | 14060000124736 | 14060000124736 | 2 | PA1268 | PM653525 |
| 14060000124767 | L14/dossiers | 14 | 14060000124766 | 14060000124766 | 1 | PA2377 | PM645591 |
| 14060000124774 | L14/dossiers | 14 | 14060000124773 | 14060000124773 | 1 | PA1585 | PM645094 |
| 14060000124781 | L14/dossiers | 14 | 14060000124780 | 14060000124780 | 1 | PA1886 | PM645099 |
| 14060000124848 | L14/dossiers | 14 | 14060000124847 | 14060000124847 | 1 | PA2277 | PM645135 |
| 14060000124855 | L14/dossiers | 14 | 14060000124854 | 14060000124854 | 1 | PA267622 | PM702957 |
| 14060000124887 | L14/dossiers | 14 | 14060000124886 | 14060000124886 | 1 | PA1122 | PM429903 |
| 14060000124902 | L14/dossiers | 14 | 14060000124901 | 14060000124901 | 1 | PA2971 | PM645392 |
| 14060000124909 | L14/dossiers | 14 | 14060000124908 | 14060000124908 | 1 | PA346886 | PM695110 |
| 14060000124916 | L14/dossiers | 14 | 14060000124915 | 14060000124915 | 1 | PA267622 | PM702957 |
| 14060000124923 | L14/dossiers | 14 | 14060000124922 | 14060000124922 | 1 | PA2377 | PM645591 |
| 14060000124930 | L14/dossiers | 14 | 14060000124929 | 14060000124929 | 1 | PA2236 | PM645149 |
| 14060000124937 | L14/dossiers | 14 | 14060000124936 | 14060000124936 | 1 | PA2952 | PM645464 |
| 14060000124944 | L14/dossiers | 14 | 14060000124943 | 14060000124943 | 1 | PA267622 | PM702957 |
| 14060000124951 | L14/dossiers | 14 | 14060000124950 | 14060000124950 | 1 | PA429891 | PM430051 |
| 14060000124970 | L14/dossiers | 14 | 14060000124969 | 14060000124969 | 1 | PA2048 | PM693013 |
| 14060000124980 | L14/dossiers | 14 | 14060000124979 | 14060000124979 | 1 | PA605036 | PM645278 |
| 14060000124987 | L14/dossiers | 14 | 14060000124986 | 14060000124986 | 1 | PA330684 | PM645497 |
| 14060000124994 | L14/dossiers | 14 | 14060000124993 | 14060000124993 | 1 | PA346886 | PM695110 |
| 14060000124998 | L14/dossiers | 14 | 14060000124997 | 14060000124997 | 1 | PA2971 | PM645392 |
| 14060000125005 | L14/dossiers | 14 | 14060000125004 | 14060000125004 | 1 | PA267622 | PM702957 |