dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 600 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_acteur_ref | VARCHAR | document.auteurs.auteur.acteur.acteurRef · présence : L17 71 %, L16 72 %, L15 74 %, L14 86 % |
| 8 | acteur_qualite | VARCHAR | document.auteurs.auteur.acteur.qualite · présence : L17 71 %, L16 72 %, L15 74 %, L14 86 % · XSD 2016 : Rapporteur, rapporteur pour avis, général, spécial, intervenant. Ne pas mettre auteur et cosignataire. Utilisé également pour la spécialité du rapporteur sur le PLF |
| 9 | organe_organe_ref | VARCHAR | document.auteurs.auteur.organe.organeRef · présence : L17 59 %, L16 58 %, L15 56 %, L14 56 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_acteur_ref | acteur_qualite | organe_organe_ref |
|---|---|---|---|---|---|---|---|---|
| 16060000088007 | L16/dossiers | 16 | 16060000087959 | 16060000087959 | 48 | PA736174 | rapporteur | |
| 16060000088008 | L16/dossiers | 16 | 16060000087959 | 16060000087959 | 49 | PA801838 | rapporteur | |
| 16060000088009 | L16/dossiers | 16 | 16060000087959 | 16060000087959 | 50 | PO211494 | ||
| 16060000088011 | L16/dossiers | 16 | 16060000088010 | 16060000088010 | 1 | PA429875 | rapporteur | |
| 16060000088012 | L16/dossiers | 16 | 16060000088010 | 16060000088010 | 2 | PO211494 | ||
| 16060000088014 | L16/dossiers | 16 | 16060000088013 | 16060000088013 | 1 | PA703498 | rapporteur | |
| 16060000088015 | L16/dossiers | 16 | 16060000088013 | 16060000088013 | 2 | PO805843 | ||
| 16060000088017 | L16/dossiers | 16 | 16060000088016 | 16060000088016 | 1 | PA429875 | rapporteur | |
| 16060000088018 | L16/dossiers | 16 | 16060000088016 | 16060000088016 | 2 | PO806027 | ||
| 16060000088020 | L16/dossiers | 16 | 16060000088019 | 16060000088019 | 1 | PA703498 | rapporteur | |
| 16060000088021 | L16/dossiers | 16 | 16060000088019 | 16060000088019 | 2 | PO211493 | ||
| 16060000088023 | L16/dossiers | 16 | 16060000088022 | 16060000088022 | 1 | PA775288 | rapporteur | |
| 16060000088024 | L16/dossiers | 16 | 16060000088022 | 16060000088022 | 2 | PO516753 | ||
| 16060000088026 | L16/dossiers | 16 | 16060000088025 | 16060000088025 | 1 | PA736205 | rapporteur | |
| 16060000088027 | L16/dossiers | 16 | 16060000088025 | 16060000088025 | 2 | PO211495 | ||
| 16060000088029 | L16/dossiers | 16 | 16060000088028 | 16060000088028 | 1 | PA775248 | rapporteur | |
| 16060000088030 | L16/dossiers | 16 | 16060000088028 | 16060000088028 | 2 | PO211495 | ||
| 16060000088032 | L16/dossiers | 16 | 16060000088031 | 16060000088031 | 1 | PA736165 | rapporteur | |
| 16060000088033 | L16/dossiers | 16 | 16060000088031 | 16060000088031 | 2 | PO211493 | ||
| 16060000088035 | L16/dossiers | 16 | 16060000088034 | 16060000088034 | 1 | PA605888 | rapporteur | |
| 16060000088036 | L16/dossiers | 16 | 16060000088034 | 16060000088034 | 2 | PO211493 | ||
| 16060000088038 | L16/dossiers | 16 | 16060000088037 | 16060000088037 | 1 | PA775288 | rapporteur | |
| 16060000088039 | L16/dossiers | 16 | 16060000088037 | 16060000088037 | 2 | PO516753 | ||
| 16060000088041 | L16/dossiers | 16 | 16060000088040 | 16060000088040 | 1 | PA1001 | rapporteur | |
| 16060000088042 | L16/dossiers | 16 | 16060000088040 | 16060000088040 | 2 | PA703492 | rapporteur | |
| 16060000088043 | L16/dossiers | 16 | 16060000088040 | 16060000088040 | 3 | PO806155 | ||
| 16060000088045 | L16/dossiers | 16 | 16060000088044 | 16060000088044 | 1 | PA703512 | rapporteur | |
| 16060000088046 | L16/dossiers | 16 | 16060000088044 | 16060000088044 | 2 | PO211490 | ||
| 16060000088048 | L16/dossiers | 16 | 16060000088047 | 16060000088047 | 1 | PA429875 | rapporteur | |
| 16060000088049 | L16/dossiers | 16 | 16060000088047 | 16060000088047 | 2 | PO806365 | ||
| 16060000088051 | L16/dossiers | 16 | 16060000088050 | 16060000088050 | 1 | PA267081 | rapporteur | |
| 16060000088052 | L16/dossiers | 16 | 16060000088050 | 16060000088050 | 2 | PO211493 | ||
| 16060000088054 | L16/dossiers | 16 | 16060000088053 | 16060000088053 | 1 | PA429875 | rapporteur | |
| 16060000088055 | L16/dossiers | 16 | 16060000088053 | 16060000088053 | 2 | PO806319 | ||
| 16060000088057 | L16/dossiers | 16 | 16060000088056 | 16060000088056 | 1 | PA429875 | rapporteur | |
| 16060000088058 | L16/dossiers | 16 | 16060000088056 | 16060000088056 | 2 | PO211494 | ||
| 16060000088060 | L16/dossiers | 16 | 16060000088059 | 16060000088059 | 1 | PA703530 | rapporteur | |
| 16060000088061 | L16/dossiers | 16 | 16060000088059 | 16060000088059 | 2 | PO516753 | ||
| 16060000088063 | L16/dossiers | 16 | 16060000088062 | 16060000088062 | 1 | PA703510 | rapporteur | |
| 16060000088064 | L16/dossiers | 16 | 16060000088062 | 16060000088062 | 2 | PO211495 | ||
| 16060000088066 | L16/dossiers | 16 | 16060000088065 | 16060000088065 | 1 | PA736186 | rapporteur | |
| 16060000088067 | L16/dossiers | 16 | 16060000088065 | 16060000088065 | 2 | PO211491 | ||
| 16060000088069 | L16/dossiers | 16 | 16060000088068 | 16060000088068 | 1 | PA736240 | rapporteur | |
| 16060000088070 | L16/dossiers | 16 | 16060000088068 | 16060000088068 | 2 | PO211491 | ||
| 16060000088072 | L16/dossiers | 16 | 16060000088071 | 16060000088071 | 1 | PA775234 | rapporteur | |
| 16060000088073 | L16/dossiers | 16 | 16060000088071 | 16060000088071 | 2 | PO211491 | ||
| 16060000088075 | L16/dossiers | 16 | 16060000088074 | 16060000088074 | 1 | PA703540 | rapporteur | |
| 16060000088076 | L16/dossiers | 16 | 16060000088074 | 16060000088074 | 2 | PO211491 | ||
| 16060000088078 | L16/dossiers | 16 | 16060000088077 | 16060000088077 | 1 | PA429842 | rapporteur | |
| 16060000088079 | L16/dossiers | 16 | 16060000088077 | 16060000088077 | 2 | PA703497 | rapporteur |