dossiers.dossier_parlementaire_acte_legislatif_rapporteur
Chemin dossierParlementaire.actesLegislatifs.acteLegislatif.rapporteurs.rapporteur · présence : L17 23 %, L16 19 %, L15 16 %, L14 23 %
8 818 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.rapporteurs.rapporteur.acteurRef · présence : L17 23 %, L16 19 %, L15 16 %, L14 23 % |
| 10 | type_rapporteur | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.rapporteurs.rapporteur.typeRapporteur · présence : L17 23 %, L16 19 %, L15 16 %, L14 23 % |
| 11 | etude_plf_ref | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.rapporteurs.rapporteur.etudePLFRef · présence : L17 0 %, L16 0 %, L15 0 %, L14 0 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | _parent_recursif_id | _niveau | acteur_ref | type_rapporteur | etude_plf_ref |
|---|---|---|---|---|---|---|---|---|---|---|
| 17060000139815 | L17/dossiers | 17 | 17060000139790 | 17060000139814 | 1 | 3 | PA703493 | rapporteur | ||
| 17060000139826 | L17/dossiers | 17 | 17060000139790 | 17060000139825 | 1 | 2 | PA795864 | rapporteur | ||
| 17060000139827 | L17/dossiers | 17 | 17060000139790 | 17060000139825 | 2 | 2 | PA703493 | rapporteur | ||
| 17060000139867 | L17/dossiers | 17 | 17060000139859 | 17060000139866 | 1 | 3 | PA608264 | rapporteur | ||
| 17060000139892 | L17/dossiers | 17 | 17060000139884 | 17060000139891 | 1 | 3 | PA719472 | rapporteur | ||
| 17060000140030 | L17/dossiers | 17 | 17060000140021 | 17060000140029 | 1 | 3 | PA720976 | rapporteur | ||
| 17060000140108 | L17/dossiers | 17 | 17060000140100 | 17060000140107 | 1 | 3 | PA794678 | rapporteur | ||
| 17060000140122 | L17/dossiers | 17 | 17060000140114 | 17060000140121 | 1 | 3 | PA840159 | rapporteur | ||
| 17060000140156 | L17/dossiers | 17 | 17060000140148 | 17060000140155 | 1 | 3 | PA842263 | rapporteur | ||
| 17060000140172 | L17/dossiers | 17 | 17060000140148 | 17060000140171 | 1 | 3 | PA736196 | rapporteur | ||
| 17060000140238 | L17/dossiers | 17 | 17060000140230 | 17060000140237 | 1 | 3 | PA794354 | rapporteur | ||
| 17060000140341 | L17/dossiers | 17 | 17060000140333 | 17060000140340 | 1 | 3 | PA841955 | rapporteur | ||
| 17060000140355 | L17/dossiers | 17 | 17060000140347 | 17060000140354 | 1 | 3 | PA841075 | rapporteur | ||
| 17060000140379 | L17/dossiers | 17 | 17060000140371 | 17060000140378 | 1 | 3 | PA736201 | rapporteur | ||
| 17060000140444 | L17/dossiers | 17 | 17060000140436 | 17060000140443 | 1 | 3 | PA720552 | rapporteur | ||
| 17060000140454 | L17/dossiers | 17 | 17060000140446 | 17060000140453 | 1 | 3 | PA345722 | rapporteur | ||
| 17060000140461 | L17/dossiers | 17 | 17060000140446 | 17060000140460 | 1 | 3 | PA345722 | rapporteur | ||
| 17060000140531 | L17/dossiers | 17 | 17060000140523 | 17060000140530 | 1 | 3 | PA841207 | rapporteur | ||
| 17060000140542 | L17/dossiers | 17 | 17060000140533 | 17060000140541 | 1 | 3 | PA770871 | rapporteur | ||
| 17060000140735 | L17/dossiers | 17 | 17060000140730 | 17060000140734 | 1 | 2 | PA794982 | rapporteur | ||
| 17060000140736 | L17/dossiers | 17 | 17060000140730 | 17060000140734 | 2 | 2 | PA795010 | rapporteur | ||
| 17060000140748 | L17/dossiers | 17 | 17060000140740 | 17060000140747 | 1 | 3 | PA720552 | rapporteur | ||
| 17060000140864 | L17/dossiers | 17 | 17060000140855 | 17060000140863 | 1 | 3 | PA827990 | rapporteur | ||
| 17060000140876 | L17/dossiers | 17 | 17060000140855 | 17060000140875 | 1 | 3 | PA721984 | rapporteur | ||
| 17060000140901 | L17/dossiers | 17 | 17060000140896 | 17060000140900 | 1 | 2 | PA841885 | rapporteur | ||
| 17060000140902 | L17/dossiers | 17 | 17060000140896 | 17060000140900 | 2 | 2 | PA793342 | rapporteur | ||
| 17060000140903 | L17/dossiers | 17 | 17060000140896 | 17060000140900 | 3 | 2 | PA720560 | rapporteur | ||
| 17060000140909 | L17/dossiers | 17 | 17060000140904 | 17060000140908 | 1 | 2 | PA719968 | rapporteur | ||
| 17060000140950 | L17/dossiers | 17 | 17060000140938 | 17060000140949 | 1 | 3 | PA642847 | rapporteur | ||
| 17060000140951 | L17/dossiers | 17 | 17060000140938 | 17060000140949 | 2 | 3 | PA793736 | rapporteur | ||
| 17060000140952 | L17/dossiers | 17 | 17060000140938 | 17060000140949 | 3 | 3 | PA805166 | rapporteur | ||
| 17060000140953 | L17/dossiers | 17 | 17060000140938 | 17060000140949 | 4 | 3 | PA841717 | rapporteur | ||
| 17060000140954 | L17/dossiers | 17 | 17060000140938 | 17060000140949 | 5 | 3 | PA842073 | rapporteur | ||
| 17060000140972 | L17/dossiers | 17 | 17060000140938 | 17060000140971 | 1 | 3 | PA408578 | rapporteur pour avis | ||
| 17060000140999 | L17/dossiers | 17 | 17060000140938 | 17060000140998 | 1 | 3 | PA703498 | rapporteur | ||
| 17060000141000 | L17/dossiers | 17 | 17060000140938 | 17060000140998 | 2 | 3 | PA703515 | rapporteur | ||
| 17060000141001 | L17/dossiers | 17 | 17060000140938 | 17060000140998 | 3 | 3 | PA267081 | rapporteur | ||
| 17060000141002 | L17/dossiers | 17 | 17060000140938 | 17060000140998 | 4 | 3 | PA736223 | rapporteur | ||
| 17060000141003 | L17/dossiers | 17 | 17060000140938 | 17060000140998 | 5 | 3 | PA763158 | rapporteur | ||
| 17060000141004 | L17/dossiers | 17 | 17060000140938 | 17060000140998 | 6 | 3 | PA267112 | rapporteur | ||
| 17060000141015 | L17/dossiers | 17 | 17060000140938 | 17060000141014 | 1 | 2 | PA642847 | rapporteur | ||
| 17060000141016 | L17/dossiers | 17 | 17060000140938 | 17060000141014 | 2 | 2 | PA703498 | rapporteur | ||
| 17060000141084 | L17/dossiers | 17 | 17060000141076 | 17060000141083 | 1 | 3 | PA341981 | rapporteur | ||
| 17060000141340 | L17/dossiers | 17 | 17060000141331 | 17060000141339 | 1 | 3 | PA722102 | rapporteur | ||
| 17060000141404 | L17/dossiers | 17 | 17060000141396 | 17060000141403 | 1 | 3 | PA794686 | rapporteur | ||
| 17060000141437 | L17/dossiers | 17 | 17060000141429 | 17060000141436 | 1 | 3 | PA791812 | rapporteur | ||
| 17060000141458 | L17/dossiers | 17 | 17060000141450 | 17060000141457 | 1 | 3 | PA841023 | rapporteur | ||
| 17060000141470 | L17/dossiers | 17 | 17060000141462 | 17060000141469 | 1 | 3 | PA719578 | rapporteur | ||
| 17060000141497 | L17/dossiers | 17 | 17060000141489 | 17060000141496 | 1 | 3 | PA796070 | rapporteur | ||
| 17060000141519 | L17/dossiers | 17 | 17060000141511 | 17060000141518 | 1 | 3 | PA795164 | rapporteur |