dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 17060000152892 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 12 | PA304085 | PM829871 |
| 17060000152893 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 13 | PA827922 | PM856930 |
| 17060000152894 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 14 | PA827922 | PM856930 |
| 17060000152895 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 15 | PA1001 | PM829905 |
| 17060000152896 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 16 | PA736197 | PM829863 |
| 17060000152897 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 17 | PA415467 | PM775803 |
| 17060000152898 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 18 | PA703503 | PM775639 |
| 17060000152899 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 19 | PA703494 | PM775651 |
| 17060000152900 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 20 | PA775216 | PM775522 |
| 17060000152901 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 21 | PA775220 | PM775526 |
| 17060000152902 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 22 | PA736169 | PM829791 |
| 17060000152903 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 23 | PA827938 | PM828646 |
| 17060000152904 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 24 | PA776985 | PM859248 |
| 17060000152905 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 25 | PA776985 | PM859248 |
| 17060000152906 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 26 | PA267081 | PM775733 |
| 17060000152907 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 27 | PA721130 | PM775608 |
| 17060000152908 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 28 | PA827952 | PM828698 |
| 17060000152909 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 29 | PA775240 | PM775530 |
| 17060000152910 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 30 | PA205280 | PM829891 |
| 17060000152911 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 31 | PA827954 | PM828704 |
| 17060000152912 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 32 | PA775242 | PM775528 |
| 17060000152913 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 33 | PA415451 | PM775787 |
| 17060000152914 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 34 | PA736186 | PM829807 |
| 17060000152915 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 35 | PA415447 | PM775785 |
| 17060000152916 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 36 | PA703537 | PM775721 |
| 17060000152917 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 37 | PA736185 | PM829813 |
| 17060000152918 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 38 | PA866550 | PM866552 |
| 17060000152919 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 39 | PA736224 | PM829913 |
| 17060000152920 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 40 | PA708632 | PM775667 |
| 17060000152921 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 41 | PA827970 | PM828758 |
| 17060000152922 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 42 | PA703517 | PM775675 |
| 17060000152923 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 43 | PA827974 | PM828744 |
| 17060000152924 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 44 | PA827976 | PM828724 |
| 17060000152925 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 45 | PA342523 | PM828470 |
| 17060000152926 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 46 | PA736200 | PM829845 |
| 17060000152927 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 47 | PA775270 | PM775572 |
| 17060000152928 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 48 | PA313924 | PM775727 |
| 17060000152929 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 49 | PA736239 | PM829893 |
| 17060000152930 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 50 | PA827988 | PM828788 |
| 17060000152931 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 51 | PA736227 | PM829901 |
| 17060000152932 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 52 | PA873412 | PM873414 |
| 17060000152933 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 53 | PA227094 | PM829735 |
| 17060000152934 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 54 | PA736207 | PM829847 |
| 17060000152935 | L17/dossiers | 17 | 17060000152880 | 17060000152880 | 55 | PA828012 | PM828812 |
| 17060000152948 | L17/dossiers | 17 | 17060000152947 | 17060000152947 | 1 | PA775252 | PM775558 |
| 17060000152970 | L17/dossiers | 17 | 17060000152969 | 17060000152969 | 1 | PA2162 | PM82321 |
| 16060000089894 | L16/dossiers | 16 | 16060000089893 | 16060000089893 | 1 | PA2924 | PM86283 |
| 16060000089932 | L16/dossiers | 16 | 16060000089931 | 16060000089931 | 1 | PA294 | PM58570 |
| 16060000089983 | L16/dossiers | 16 | 16060000089982 | 16060000089982 | 1 | PA2607 | PM87228 |
| 16060000090026 | L16/dossiers | 16 | 16060000090025 | 16060000090025 | 1 | PA2227 | PM89545 |