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 |
|---|---|---|---|---|---|---|---|
| 16060000096839 | L16/dossiers | 16 | 16060000096815 | 16060000096815 | 24 | PA415454 | PM785875 |
| 16060000096840 | L16/dossiers | 16 | 16060000096815 | 16060000096815 | 25 | PA758716 | PM775771 |
| 16060000096841 | L16/dossiers | 16 | 16060000096815 | 16060000096815 | 26 | PA758716 | PM775771 |
| 16060000096842 | L16/dossiers | 16 | 16060000096815 | 16060000096815 | 27 | PA425322 | PM736282 |
| 16060000096843 | L16/dossiers | 16 | 16060000096815 | 16060000096815 | 28 | PA775212 | PM775500 |
| 16060000096844 | L16/dossiers | 16 | 16060000096815 | 16060000096815 | 29 | PA205280 | PM736412 |
| 16060000096845 | L16/dossiers | 16 | 16060000096815 | 16060000096815 | 30 | PA736197 | PM736378 |
| 16060000096846 | L16/dossiers | 16 | 16060000096815 | 16060000096815 | 31 | PA736169 | PM736293 |
| 16060000096856 | L16/dossiers | 16 | 16060000096855 | 16060000096855 | 1 | PA720138 | PM796800 |
| 16060000096863 | L16/dossiers | 16 | 16060000096862 | 16060000096862 | 1 | PA736241 | PM736300 |
| 16060000096882 | L16/dossiers | 16 | 16060000096881 | 16060000096881 | 1 | PA719608 | PM796593 |
| 16060000096886 | L16/dossiers | 16 | 16060000096885 | 16060000096885 | 1 | PA774960 | PM797490 |
| 16060000096893 | L16/dossiers | 16 | 16060000096892 | 16060000096892 | 1 | PA266788 | PM796788 |
| 16060000096900 | L16/dossiers | 16 | 16060000096899 | 16060000096899 | 1 | PA720684 | PM797082 |
| 16060000096907 | L16/dossiers | 16 | 16060000096906 | 16060000096906 | 1 | PA736186 | PM736396 |
| 16060000096926 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 1 | PA775302 | PM775598 |
| 16060000096927 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 2 | PA736238 | PM736352 |
| 16060000096928 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 3 | PA758716 | PM775771 |
| 16060000096929 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 4 | PA758716 | PM775771 |
| 16060000096930 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 5 | PA775202 | PM775502 |
| 16060000096931 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 6 | PA345785 | PM736294 |
| 16060000096932 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 7 | PA703518 | PM775673 |
| 16060000096933 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 8 | PA775220 | PM775526 |
| 16060000096934 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 9 | PA775288 | PM775578 |
| 16060000096935 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 10 | PA775240 | PM775530 |
| 16060000096936 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 11 | PA415454 | PM785875 |
| 16060000096937 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 12 | PA720634 | PM736312 |
| 16060000096938 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 13 | PA736200 | PM736285 |
| 16060000096939 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 14 | PA775284 | PM775590 |
| 16060000096940 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 15 | PA721130 | PM775608 |
| 16060000096941 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 16 | PA736239 | PM736317 |
| 16060000096942 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 17 | PA775184 | PM775486 |
| 16060000096943 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 18 | PA343988 | PM736310 |
| 16060000096944 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 19 | PA776985 | PM777700 |
| 16060000096945 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 20 | PA775222 | PM775524 |
| 16060000096946 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 21 | PA775192 | PM775478 |
| 16060000096947 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 22 | PA775228 | PM775516 |
| 16060000096948 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 23 | PA703537 | PM775721 |
| 16060000096949 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 24 | PA267340 | PM775731 |
| 16060000096950 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 25 | PA703503 | PM775639 |
| 16060000096951 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 26 | PA703497 | PM775637 |
| 16060000096952 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 27 | PA304108 | PM736399 |
| 16060000096953 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 28 | PA703522 | PM775701 |
| 16060000096954 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 29 | PA429874 | PM736314 |
| 16060000096955 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 30 | PA763158 | PM775683 |
| 16060000096956 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 31 | PA736216 | PM736273 |
| 16060000096957 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 32 | PA703520 | PM775705 |
| 16060000096958 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 33 | PA313924 | PM775727 |
| 16060000096959 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 34 | PA715322 | PM775713 |
| 16060000096960 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 35 | PA415447 | PM775785 |