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 |
|---|---|---|---|---|---|---|---|---|---|
| 14060000121941 | L14/dossiers | 14 | 14060000121873 | 14060000121940 | 1 | 1 | PA328 | PM653228 | |
| 14060000122538 | L14/dossiers | 14 | 14060000122468 | 14060000122537 | 1 | 1 | PA267622 | PM702957 | |
| 14060000122657 | L14/dossiers | 14 | 14060000122622 | 14060000122656 | 1 | 1 | PA267622 | PM702957 | |
| 14060000123222 | L14/dossiers | 14 | 14060000123181 | 14060000123221 | 1 | 1 | PA328 | PM653228 | |
| 14060000123415 | L14/dossiers | 14 | 14060000123368 | 14060000123414 | 1 | 1 | PA328 | PM653228 | |
| 14060000123506 | L14/dossiers | 14 | 14060000123467 | 14060000123505 | 1 | 1 | PA267622 | PM702957 | |
| 14060000123732 | L14/dossiers | 14 | 14060000123681 | 14060000123731 | 1 | 1 | PA267622 | PM700712 | |
| 14060000123995 | L14/dossiers | 14 | 14060000123945 | 14060000123994 | 1 | 1 | PA267622 | PM702957 | |
| 14060000124224 | L14/dossiers | 14 | 14060000124184 | 14060000124223 | 1 | 1 | PA785 | PM715797 | |
| 14060000124495 | L14/dossiers | 14 | 14060000124375 | 14060000124494 | 1 | 1 | PA328 | PM653228 | |
| 14060000124563 | L14/dossiers | 14 | 14060000124528 | 14060000124562 | 1 | 1 | PA267622 | PM702957 | |
| 14060000124827 | L14/dossiers | 14 | 14060000124780 | 14060000124826 | 1 | 1 | PA267622 | PM702957 | |
| 14060000125114 | L14/dossiers | 14 | 14060000125065 | 14060000125113 | 1 | 1 | PA328 | PM653228 | |
| 14060000125429 | L14/dossiers | 14 | 14060000125384 | 14060000125428 | 1 | 1 | PA328 | PM653228 | |
| 14060000125517 | L14/dossiers | 14 | 14060000125457 | 14060000125516 | 1 | 1 | PA267622 | PM702957 | |
| 14060000125721 | L14/dossiers | 14 | 14060000125626 | 14060000125720 | 1 | 1 | PA267622 | PM702957 | |
| 14060000125842 | L14/dossiers | 14 | 14060000125749 | 14060000125841 | 1 | 1 | PA267622 | PM702957 | |
| 14060000126093 | L14/dossiers | 14 | 14060000126052 | 14060000126092 | 1 | 1 | PA267622 | PM702957 | |
| 14060000126295 | L14/dossiers | 14 | 14060000126250 | 14060000126294 | 1 | 1 | PA328 | PM653228 | |
| 14060000126437 | L14/dossiers | 14 | 14060000126344 | 14060000126436 | 1 | 1 | PA267622 | PM700712 | |
| 14060000126644 | L14/dossiers | 14 | 14060000126581 | 14060000126643 | 1 | 1 | PA267622 | PM702957 | |
| 14060000127626 | L14/dossiers | 14 | 14060000127543 | 14060000127625 | 1 | 1 | PA785 | PM715797 | |
| 14060000127771 | L14/dossiers | 14 | 14060000127727 | 14060000127770 | 1 | 1 | PA267622 | PM702957 | |
| 14060000128010 | L14/dossiers | 14 | 14060000127968 | 14060000128009 | 1 | 1 | PA328 | PM653228 | |
| 14060000128510 | L14/dossiers | 14 | 14060000128406 | 14060000128509 | 1 | 1 | PA267622 | PM702957 | |
| 14060000128659 | L14/dossiers | 14 | 14060000128587 | 14060000128658 | 1 | 1 | PA267622 | PM702957 | |
| 14060000128741 | L14/dossiers | 14 | 14060000128700 | 14060000128740 | 1 | 1 | PA328 | PM653228 | |
| 14060000128850 | L14/dossiers | 14 | 14060000128815 | 14060000128849 | 1 | 1 | PA328 | PM653228 | |
| 14060000128988 | L14/dossiers | 14 | 14060000128941 | 14060000128987 | 1 | 1 | PA267622 | PM702957 | |
| 14060000129064 | L14/dossiers | 14 | 14060000129006 | 14060000129063 | 1 | 1 | PA267622 | PM700712 | |
| 14060000129348 | L14/dossiers | 14 | 14060000129292 | 14060000129347 | 1 | 1 | PA345619 | PM725692 | |
| 14060000129531 | L14/dossiers | 14 | 14060000129463 | 14060000129530 | 1 | 1 | PA328 | PM653228 | |
| 14060000129747 | L14/dossiers | 14 | 14060000129711 | 14060000129746 | 1 | 1 | PA328 | PM653228 | |
| 14060000130295 | L14/dossiers | 14 | 14060000130264 | 14060000130294 | 1 | 1 | PA267622 | PM700712 | |
| 14060000130563 | L14/dossiers | 14 | 14060000130527 | 14060000130562 | 1 | 1 | PA328 | PM653228 | |
| 14060000131477 | L14/dossiers | 14 | 14060000131446 | 14060000131476 | 1 | 1 | PA267622 | PM702957 | |
| 14060000131670 | L14/dossiers | 14 | 14060000131617 | 14060000131669 | 1 | 1 | PA328 | PM653228 | |
| 14060000131871 | L14/dossiers | 14 | 14060000131833 | 14060000131870 | 1 | 1 | PA267622 | PM702957 | |
| 14060000131931 | L14/dossiers | 14 | 14060000131892 | 14060000131930 | 1 | 1 | PA328 | PM653228 | |
| 14060000132160 | L14/dossiers | 14 | 14060000132099 | 14060000132159 | 1 | 1 | PA267622 | PM702957 | |
| 14060000132267 | L14/dossiers | 14 | 14060000132210 | 14060000132266 | 1 | 1 | PA328 | PM653228 | |
| 14060000132379 | L14/dossiers | 14 | 14060000132333 | 14060000132378 | 1 | 1 | PA267622 | PM700712 | |
| 14060000133043 | L14/dossiers | 14 | 14060000133007 | 14060000133042 | 1 | 1 | PA267622 | PM700712 | |
| 14060000133096 | L14/dossiers | 14 | 14060000133061 | 14060000133095 | 1 | 1 | PA785 | PM715797 | |
| 14060000133635 | L14/dossiers | 14 | 14060000133582 | 14060000133634 | 1 | 1 | PA267622 | PM700712 | |
| 14060000133725 | L14/dossiers | 14 | 14060000133690 | 14060000133724 | 1 | 1 | PA785 | PM715797 | |
| 14060000133825 | L14/dossiers | 14 | 14060000133784 | 14060000133824 | 1 | 1 | PA267622 | PM702957 | |
| 14060000133900 | L14/dossiers | 14 | 14060000133865 | 14060000133899 | 1 | 1 | PA267622 | PM702957 | |
| 14060000134057 | L14/dossiers | 14 | 14060000134024 | 14060000134056 | 1 | 1 | PA267622 | PM702957 | |
| 14060000134305 | L14/dossiers | 14 | 14060000134239 | 14060000134304 | 1 | 1 | PA267622 | PM702957 |