dossiers.dossier_parlementaire_acte_legislatif_acteur
Chemin dossierParlementaire.actesLegislatifs.acteLegislatif.initiateur.acteurs.acteur · présence : L17 2 %, L16 3 %, L15 3 %, L14 5 %
460 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 | _parent_recursif_id | BIGINT | _id de la ligne de même table qui contient celle-ci (structure récursive) |
| 8 | _niveau | BIGINT | profondeur dans la structure récursive (0 = premier niveau) |
| 9 | acteur_ref | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.initiateur.acteurs.acteur.acteurRef · présence : L17 2 %, L16 3 %, L15 3 %, L14 5 % |
| 10 | mandat_ref | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.initiateur.acteurs.acteur.mandatRef · présence : L17 2 %, L16 3 %, L15 3 %, L14 5 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | _parent_recursif_id | _niveau | acteur_ref | mandat_ref |
|---|---|---|---|---|---|---|---|---|---|
| 16060000104464 | L16/dossiers | 16 | 16060000104431 | 16060000104463 | 1 | 1 | PA717161 | PM791583 | |
| 16060000104647 | L16/dossiers | 16 | 16060000104615 | 16060000104646 | 1 | 1 | PA717161 | PM791583 | |
| 16060000104716 | L16/dossiers | 16 | 16060000104682 | 16060000104715 | 1 | 1 | PA717161 | PM791583 | |
| 16060000104847 | L16/dossiers | 16 | 16060000104813 | 16060000104846 | 1 | 1 | PA717161 | PM791583 | |
| 16060000105115 | L16/dossiers | 16 | 16060000105038 | 16060000105114 | 1 | 1 | PA717161 | PM791583 | |
| 16060000105269 | L16/dossiers | 16 | 16060000105233 | 16060000105268 | 1 | 1 | PA717161 | PM791583 | |
| 16060000105578 | L16/dossiers | 16 | 16060000105523 | 16060000105577 | 1 | 1 | PA717161 | PM791583 | |
| 16060000108006 | L16/dossiers | 16 | 16060000107926 | 16060000108005 | 1 | 1 | PA717161 | PM791583 | |
| 16060000108566 | L16/dossiers | 16 | 16060000108522 | 16060000108565 | 1 | 1 | PA717161 | PM791583 | |
| 16060000109045 | L16/dossiers | 16 | 16060000109014 | 16060000109044 | 1 | 1 | PA717161 | PM791583 | |
| 16060000109098 | L16/dossiers | 16 | 16060000109063 | 16060000109097 | 1 | 1 | PA717161 | PM791583 | |
| 16060000109310 | L16/dossiers | 16 | 16060000109276 | 16060000109309 | 1 | 1 | PA722190 | PM833697 | |
| 16060000109431 | L16/dossiers | 16 | 16060000109398 | 16060000109430 | 1 | 1 | PA717161 | PM791583 | |
| 16060000109748 | L16/dossiers | 16 | 16060000109711 | 16060000109747 | 1 | 1 | PA717161 | PM791583 | |
| 16060000109806 | L16/dossiers | 16 | 16060000109766 | 16060000109805 | 1 | 1 | PA717161 | PM791583 | |
| 16060000109860 | L16/dossiers | 16 | 16060000109824 | 16060000109859 | 1 | 1 | PA722190 | PM833697 | |
| 16060000109927 | L16/dossiers | 16 | 16060000109866 | 16060000109926 | 1 | 1 | PA717161 | PM791583 | |
| 16060000110090 | L16/dossiers | 16 | 16060000110025 | 16060000110089 | 1 | 1 | PA717161 | PM791583 | |
| 16060000110170 | L16/dossiers | 16 | 16060000110113 | 16060000110169 | 1 | 1 | PA717161 | PM791583 | |
| 16060000110723 | L16/dossiers | 16 | 16060000110666 | 16060000110722 | 1 | 1 | PA717161 | PM791583 | |
| 16060000110868 | L16/dossiers | 16 | 16060000110815 | 16060000110867 | 1 | 1 | PA717161 | PM791583 | |
| 16060000111034 | L16/dossiers | 16 | 16060000111002 | 16060000111033 | 1 | 1 | PA717161 | PM791583 | |
| 16060000111167 | L16/dossiers | 16 | 16060000111117 | 16060000111166 | 1 | 1 | PA717161 | PM791583 | |
| 16060000111324 | L16/dossiers | 16 | 16060000111283 | 16060000111323 | 1 | 1 | PA722190 | PM833697 | |
| 16060000111927 | L16/dossiers | 16 | 16060000111869 | 16060000111926 | 1 | 1 | PA717161 | PM791583 | |
| 16060000112758 | L16/dossiers | 16 | 16060000112726 | 16060000112757 | 1 | 1 | PA722190 | PM833697 | |
| 16060000114018 | L16/dossiers | 16 | 16060000113699 | 16060000114017 | 1 | 1 | PA717161 | PM791583 | |
| 16060000114373 | L16/dossiers | 16 | 16060000114340 | 16060000114372 | 1 | 1 | PA722190 | PM833697 | |
| 16060000114470 | L16/dossiers | 16 | 16060000114434 | 16060000114469 | 1 | 1 | PA722190 | PM833697 | |
| 16060000115784 | L16/dossiers | 16 | 16060000115746 | 16060000115783 | 1 | 1 | PA717161 | PM791583 | |
| 16060000115881 | L16/dossiers | 16 | 16060000115806 | 16060000115880 | 1 | 1 | PA717161 | PM791583 | |
| 16060000116032 | L16/dossiers | 16 | 16060000115998 | 16060000116031 | 1 | 1 | PA717161 | PM791583 | |
| 16060000117100 | L16/dossiers | 16 | 16060000117067 | 16060000117099 | 1 | 1 | PA717161 | PM791583 | |
| 16060000117493 | L16/dossiers | 16 | 16060000117440 | 16060000117492 | 1 | 1 | PA722190 | PM833697 | |
| 16060000117549 | L16/dossiers | 16 | 16060000117514 | 16060000117548 | 1 | 1 | PA722190 | PM833697 | |
| 16060000118401 | L16/dossiers | 16 | 16060000118368 | 16060000118400 | 1 | 1 | PA722190 | PM833697 | |
| 16060000118496 | L16/dossiers | 16 | 16060000118463 | 16060000118495 | 1 | 1 | PA722190 | PM833697 | |
| 16060000118820 | L16/dossiers | 16 | 16060000118778 | 16060000118819 | 1 | 1 | PA722190 | PM833697 | |
| 16060000118945 | L16/dossiers | 16 | 16060000118912 | 16060000118944 | 1 | 1 | PA722190 | PM833697 | |
| 16060000119063 | L16/dossiers | 16 | 16060000119023 | 16060000119062 | 1 | 1 | PA722190 | PM833697 | |
| 16060000119135 | L16/dossiers | 16 | 16060000119086 | 16060000119134 | 1 | 1 | PA722190 | PM833697 | |
| 16060000120645 | L16/dossiers | 16 | 16060000120608 | 16060000120644 | 1 | 1 | PA722190 | PM833697 | |
| 16060000121977 | L16/dossiers | 16 | 16060000121943 | 16060000121976 | 1 | 1 | PA722190 | PM833697 | |
| 15060000129525 | L15/dossiers | 15 | 15060000129471 | 15060000129524 | 1 | 1 | PA345619 | PM725692 | |
| 15060000129690 | L15/dossiers | 15 | 15060000129627 | 15060000129689 | 1 | 1 | PA345619 | PM725692 | |
| 15060000129811 | L15/dossiers | 15 | 15060000129776 | 15060000129810 | 1 | 1 | PA345619 | PM725692 | |
| 15060000129935 | L15/dossiers | 15 | 15060000129900 | 15060000129934 | 1 | 1 | PA345619 | PM725692 | |
| 15060000130012 | L15/dossiers | 15 | 15060000129977 | 15060000130011 | 1 | 1 | PA345619 | PM725692 | |
| 15060000130514 | L15/dossiers | 15 | 15060000130146 | 15060000130513 | 1 | 1 | PA345619 | PM725692 | |
| 15060000130953 | L15/dossiers | 15 | 15060000130897 | 15060000130952 | 1 | 1 | PA345619 | PM725692 |