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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000113984 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 22 | 3 | PA775210 | rapporteur | ||
| 16060000113985 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 23 | 3 | PA429833 | rapporteur | ||
| 16060000113986 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 24 | 3 | PA415448 | rapporteur | ||
| 16060000113987 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 25 | 3 | PA343988 | rapporteur | ||
| 16060000113988 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 26 | 3 | PA703493 | rapporteur | ||
| 16060000113989 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 27 | 3 | PA827928 | rapporteur | ||
| 16060000113990 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 28 | 3 | PA775288 | rapporteur | ||
| 16060000113991 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 29 | 3 | PA775214 | rapporteur | ||
| 16060000113992 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 30 | 3 | PA415447 | rapporteur | ||
| 16060000113993 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 31 | 3 | PA736238 | rapporteur | ||
| 16060000113994 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 32 | 3 | PA415499 | rapporteur | ||
| 16060000113995 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 33 | 3 | PA775278 | rapporteur | ||
| 16060000113996 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 34 | 3 | PA703505 | rapporteur | ||
| 16060000113997 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 35 | 3 | PA827904 | rapporteur | ||
| 16060000113998 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 36 | 3 | PA775260 | rapporteur | ||
| 16060000113999 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 37 | 3 | PA711156 | rapporteur | ||
| 16060000114000 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 38 | 3 | PA736158 | rapporteur | ||
| 16060000114001 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 39 | 3 | PA775284 | rapporteur | ||
| 16060000114002 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 40 | 3 | PA775200 | rapporteur | ||
| 16060000114003 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 41 | 3 | PA736175 | rapporteur | ||
| 16060000114004 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 42 | 3 | PA429869 | rapporteur | ||
| 16060000114005 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 43 | 3 | PA775176 | rapporteur | ||
| 16060000114006 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 44 | 3 | PA703527 | rapporteur | ||
| 16060000114007 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 45 | 3 | PA736188 | rapporteur | ||
| 16060000114008 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 46 | 3 | PA429894 | rapporteur | ||
| 16060000114009 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 47 | 3 | PA703509 | rapporteur | ||
| 16060000114010 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 48 | 3 | PA736174 | rapporteur | ||
| 16060000114011 | L16/dossiers | 16 | 16060000113699 | 16060000113962 | 49 | 3 | PA828000 | rapporteur | ||
| 16060000114021 | L16/dossiers | 16 | 16060000113699 | 16060000114020 | 1 | 2 | PA719472 | rapporteur | ||
| 16060000114022 | L16/dossiers | 16 | 16060000113699 | 16060000114020 | 2 | 2 | PA429875 | rapporteur | ||
| 16060000114349 | L16/dossiers | 16 | 16060000114340 | 16060000114348 | 1 | 3 | PA720342 | rapporteur | ||
| 16060000114364 | L16/dossiers | 16 | 16060000114340 | 16060000114363 | 1 | 3 | PA266795 | rapporteur | ||
| 16060000114376 | L16/dossiers | 16 | 16060000114340 | 16060000114375 | 1 | 2 | PA720342 | rapporteur | ||
| 16060000114377 | L16/dossiers | 16 | 16060000114340 | 16060000114375 | 2 | 2 | PA266795 | rapporteur | ||
| 16060000114443 | L16/dossiers | 16 | 16060000114434 | 16060000114442 | 1 | 3 | PA794214 | rapporteur | ||
| 16060000114461 | L16/dossiers | 16 | 16060000114434 | 16060000114460 | 1 | 3 | PA785855 | rapporteur | ||
| 16060000114473 | L16/dossiers | 16 | 16060000114434 | 16060000114472 | 1 | 2 | PA794214 | rapporteur | ||
| 16060000114474 | L16/dossiers | 16 | 16060000114434 | 16060000114472 | 2 | 2 | PA785855 | rapporteur | ||
| 16060000114829 | L16/dossiers | 16 | 16060000114821 | 16060000114828 | 1 | 3 | PA793330 | rapporteur | ||
| 16060000114846 | L16/dossiers | 16 | 16060000114838 | 16060000114845 | 1 | 3 | PA736201 | rapporteur | ||
| 16060000114897 | L16/dossiers | 16 | 16060000114889 | 16060000114896 | 1 | 3 | PA720960 | rapporteur | ||
| 16060000114955 | L16/dossiers | 16 | 16060000114947 | 16060000114954 | 1 | 3 | PA827996 | rapporteur | ||
| 16060000114967 | L16/dossiers | 16 | 16060000114947 | 16060000114966 | 1 | 3 | PA642868 | rapporteur | ||
| 16060000115066 | L16/dossiers | 16 | 16060000115054 | 16060000115065 | 1 | 3 | PA1592 | rapporteur | ||
| 16060000115080 | L16/dossiers | 16 | 16060000115054 | 16060000115079 | 1 | 3 | PA205280 | rapporteur | ||
| 16060000115102 | L16/dossiers | 16 | 16060000115094 | 16060000115101 | 1 | 3 | PA794590 | rapporteur | ||
| 16060000115265 | L16/dossiers | 16 | 16060000115232 | 16060000115264 | 1 | 3 | PA775218 | rapporteur | ||
| 16060000115322 | L16/dossiers | 16 | 16060000115314 | 16060000115321 | 1 | 3 | PA267794 | rapporteur | ||
| 16060000115338 | L16/dossiers | 16 | 16060000115314 | 16060000115337 | 1 | 3 | PA827938 | rapporteur | ||
| 16060000115386 | L16/dossiers | 16 | 16060000115378 | 16060000115385 | 1 | 3 | PA775242 | rapporteur |