AN · données ouvertes
Explorateur / dossiers

dossiers.document_auteur

Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %

59 594 lignes (estimation)

Colonnes

#ColonneTypeCommentaire
1_idBIGINTidentifiant : code de la source × 10¹⁰ + rang
2_sourceVARCHARsource du catalogue (catalogue.py)
3_legislatureBIGINTcolonne constante de la source
4_racine_idBIGINT_id de la ligne racine
5_parent_idBIGINT_id de la ligne parente
6_ordreBIGINTrang dans le tableau d'origine (1…)
7acteur_acteur_refVARCHARdocument.auteurs.auteur.acteur.acteurRef · présence : L17 71 %, L16 72 %, L15 74 %, L14 86 %
8acteur_qualiteVARCHARdocument.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
9organe_organe_refVARCHARdocument.auteurs.auteur.organe.organeRef · présence : L17 59 %, L16 58 %, L15 56 %, L14 56 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreacteur_acteur_refacteur_qualiteorgane_organe_ref
17060000079844L17/dossiers1717060000079843170600000798431PA415446rapporteur
17060000079845L17/dossiers1717060000079843170600000798432PO211494
17060000079847L17/dossiers1717060000079846170600000798461PA849528rapporteur
17060000079848L17/dossiers1717060000079846170600000798462PO211495
17060000079850L17/dossiers1717060000079849170600000798491PA828008rapporteur
17060000079851L17/dossiers1717060000079849170600000798492PO211495
17060000079853L17/dossiers1717060000079852170600000798521PA775276rapporteur
17060000079854L17/dossiers1717060000079852170600000798522PA415447rapporteur
17060000079855L17/dossiers1717060000079852170600000798523PO868165
17060000079857L17/dossiers1717060000079856170600000798561PA736205rapporteur
17060000079858L17/dossiers1717060000079856170600000798562PO868142
17060000079860L17/dossiers1717060000079859170600000798591PA703515rapporteur
17060000079861L17/dossiers1717060000079859170600000798592PO211493
17060000079863L17/dossiers1717060000079862170600000798621PA775220rapporteur
17060000079864L17/dossiers1717060000079862170600000798622PO211495
17060000079866L17/dossiers1717060000079865170600000798651PA267340rapporteur
17060000079867L17/dossiers1717060000079865170600000798652PO211495
17060000079869L17/dossiers1717060000079868170600000798681PA342564rapporteur
17060000079870L17/dossiers1717060000079868170600000798682PO211493
17060000079872L17/dossiers1717060000079871170600000798711PA1127rapporteur
17060000079873L17/dossiers1717060000079871170600000798712PO516754
17060000079875L17/dossiers1717060000079874170600000798741PA703522rapporteur
17060000079876L17/dossiers1717060000079874170600000798742PO211495
17060000079878L17/dossiers1717060000079877170600000798771PA827986rapporteur
17060000079879L17/dossiers1717060000079877170600000798772PO516754
17060000079881L17/dossiers1717060000079880170600000798801PA866550rapporteur
17060000079882L17/dossiers1717060000079880170600000798802PO211495
17060000079884L17/dossiers1717060000079883170600000798831PA721742rapporteur
17060000079885L17/dossiers1717060000079883170600000798832PO211495
17060000079887L17/dossiers1717060000079886170600000798861PA775170rapporteur
17060000079888L17/dossiers1717060000079886170600000798862PO211495
17060000079890L17/dossiers1717060000079889170600000798891PA849528rapporteur
17060000079891L17/dossiers1717060000079889170600000798892PO869503
17060000079893L17/dossiers1717060000079892170600000798921PA736202rapporteur
17060000079894L17/dossiers1717060000079892170600000798922PO838271
17060000079896L17/dossiers1717060000079895170600000798951PA775268rapporteur
17060000079897L17/dossiers1717060000079895170600000798952PO516753
17060000079899L17/dossiers1717060000079898170600000798981PA827952rapporteur
17060000079900L17/dossiers1717060000079898170600000798982PO211495
17060000079902L17/dossiers1717060000079901170600000799011PA775250rapporteur
17060000079903L17/dossiers1717060000079901170600000799012PA775226rapporteur
17060000079904L17/dossiers1717060000079901170600000799013PO869346
17060000079906L17/dossiers1717060000079905170600000799051PA827988rapporteur
17060000079907L17/dossiers1717060000079905170600000799052PO211495
17060000079909L17/dossiers1717060000079908170600000799081PA775178rapporteur
17060000079910L17/dossiers1717060000079908170600000799082PO211495
17060000079912L17/dossiers1717060000079911170600000799111PA429874rapporteur
17060000079913L17/dossiers1717060000079911170600000799112PO211490
17060000079915L17/dossiers1717060000079914170600000799141PA736207rapporteur
17060000079916L17/dossiers1717060000079914170600000799142PA827996rapporteur