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
17060000001604L17/dossiers17170600000015391706000000153965PA342384cosignataire
17060000001605L17/dossiers17170600000015391706000000153966PA795422cosignataire
17060000001606L17/dossiers17170600000015391706000000153967PA794686cosignataire
17060000001607L17/dossiers17170600000015391706000000153968PA841215cosignataire
17060000001608L17/dossiers17170600000015391706000000153969PA795482cosignataire
17060000001609L17/dossiers17170600000015391706000000153970PA610654cosignataire
17060000001610L17/dossiers17170600000015391706000000153971PA841191cosignataire
17060000001611L17/dossiers17170600000015391706000000153972PA721960cosignataire
17060000001612L17/dossiers17170600000015391706000000153973PA793872cosignataire
17060000001613L17/dossiers17170600000015391706000000153974PA817211cosignataire
17060000001614L17/dossiers17170600000015391706000000153975PA793756cosignataire
17060000001615L17/dossiers17170600000015391706000000153976PA796062cosignataire
17060000001616L17/dossiers17170600000015391706000000153977PA719578cosignataire
17060000001617L17/dossiers17170600000015391706000000153978PA721062cosignataire
17060000001618L17/dossiers17170600000015391706000000153979PA795876cosignataire
17060000001619L17/dossiers17170600000015391706000000153980PA795076cosignataire
17060000001620L17/dossiers17170600000015391706000000153981PA841845cosignataire
17060000001621L17/dossiers17170600000015391706000000153982PA795982cosignataire
17060000001622L17/dossiers17170600000015391706000000153983PA605745cosignataire
17060000001623L17/dossiers17170600000015391706000000153984PA795808cosignataire
17060000001624L17/dossiers17170600000015391706000000153985PA796018cosignataire
17060000001625L17/dossiers17170600000015391706000000153986PA795466cosignataire
17060000001626L17/dossiers17170600000015391706000000153987PA793744cosignataire
17060000001627L17/dossiers17170600000015391706000000153988PA720952cosignataire
17060000001628L17/dossiers17170600000015391706000000153989PA794106cosignataire
17060000001629L17/dossiers17170600000015391706000000153990PA794166cosignataire
17060000001630L17/dossiers17170600000015391706000000153991PA795164cosignataire
17060000001631L17/dossiers17170600000015391706000000153992PA795596cosignataire
17060000001633L17/dossiers1717060000001632170600000016321PA720892auteur
17060000001634L17/dossiers1717060000001632170600000016322PA795228cosignataire
17060000001635L17/dossiers1717060000001632170600000016323PA793262cosignataire
17060000001636L17/dossiers1717060000001632170600000016324PA794906cosignataire
17060000001637L17/dossiers1717060000001632170600000016325PA794138cosignataire
17060000001638L17/dossiers1717060000001632170600000016326PA795588cosignataire
17060000001639L17/dossiers1717060000001632170600000016327PA795084cosignataire
17060000001640L17/dossiers1717060000001632170600000016328PA842105cosignataire
17060000001641L17/dossiers1717060000001632170600000016329PA841657cosignataire
17060000001642L17/dossiers17170600000016321706000000163210PA720430cosignataire
17060000001643L17/dossiers17170600000016321706000000163211PA793772cosignataire
17060000001644L17/dossiers17170600000016321706000000163212PA795616cosignataire
17060000001645L17/dossiers17170600000016321706000000163213PA793444cosignataire
17060000001646L17/dossiers17170600000016321706000000163214PA794938cosignataire
17060000001647L17/dossiers17170600000016321706000000163215PA795318cosignataire
17060000001648L17/dossiers17170600000016321706000000163216PA841023cosignataire
17060000001649L17/dossiers17170600000016321706000000163217PA796090cosignataire
17060000001650L17/dossiers17170600000016321706000000163218PA793912cosignataire
17060000001651L17/dossiers17170600000016321706000000163219PA842187cosignataire
17060000001652L17/dossiers17170600000016321706000000163220PA842037cosignataire
17060000001653L17/dossiers17170600000016321706000000163221PA791812cosignataire
17060000001654L17/dossiers17170600000016321706000000163222PA793736cosignataire