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
17060000002260L17/dossiers17170600000021981706000000219862PA719578cosignataire
17060000002261L17/dossiers17170600000021981706000000219863PA721062cosignataire
17060000002262L17/dossiers17170600000021981706000000219864PA841845cosignataire
17060000002263L17/dossiers17170600000021981706000000219865PA795982cosignataire
17060000002264L17/dossiers17170600000021981706000000219866PA795466cosignataire
17060000002265L17/dossiers17170600000021981706000000219867PA793744cosignataire
17060000002266L17/dossiers17170600000021981706000000219868PA720952cosignataire
17060000002267L17/dossiers17170600000021981706000000219869PA794106cosignataire
17060000002268L17/dossiers17170600000021981706000000219870PA794166cosignataire
17060000002269L17/dossiers17170600000021981706000000219871PA795164cosignataire
17060000002270L17/dossiers17170600000021981706000000219872PA795596cosignataire
17060000002271L17/dossiers17170600000021981706000000219873PA796090cosignataire
17060000002272L17/dossiers17170600000021981706000000219874PA610968cosignataire
17060000002273L17/dossiers17170600000021981706000000219875PA793780cosignataire
17060000002274L17/dossiers17170600000021981706000000219876PA588884cosignataire
17060000002275L17/dossiers17170600000021981706000000219877PA841701cosignataire
17060000002276L17/dossiers17170600000021981706000000219878PA795362cosignataire
17060000002277L17/dossiers17170600000021981706000000219879PA795454cosignataire
17060000002278L17/dossiers17170600000021981706000000219880PA840997cosignataire
17060000002279L17/dossiers17170600000021981706000000219881PA841885cosignataire
17060000002280L17/dossiers17170600000021981706000000219882PA721210cosignataire
17060000002281L17/dossiers17170600000021981706000000219883PA793452cosignataire
17060000002282L17/dossiers17170600000021981706000000219884PA793980cosignataire
17060000002283L17/dossiers17170600000021981706000000219885PA841419cosignataire
17060000002284L17/dossiers17170600000021981706000000219886PA794146cosignataire
17060000002285L17/dossiers17170600000021981706000000219887PA795636cosignataire
17060000002286L17/dossiers17170600000021981706000000219888PA842045cosignataire
17060000002287L17/dossiers17170600000021981706000000219889PA793708cosignataire
17060000002288L17/dossiers17170600000021981706000000219890PA794154cosignataire
17060000002289L17/dossiers17170600000021981706000000219891PA794778cosignataire
17060000002290L17/dossiers17170600000021981706000000219892PA795076cosignataire
17060000002291L17/dossiers17170600000021981706000000219893PA722142cosignataire
17060000002292L17/dossiers17170600000021981706000000219894PA795808cosignataire
17060000002293L17/dossiers17170600000021981706000000219895PA796018cosignataire
17060000002294L17/dossiers17170600000021981706000000219896PA736201cosignataire
17060000002295L17/dossiers17170600000021981706000000219897PA841713cosignataire
17060000002296L17/dossiers17170600000021981706000000219898PA793948cosignataire
17060000002297L17/dossiers17170600000021981706000000219899PA796106cosignataire
17060000002298L17/dossiers171706000000219817060000002198100PA720838cosignataire
17060000002299L17/dossiers171706000000219817060000002198101PA794710cosignataire
17060000002300L17/dossiers171706000000219817060000002198102PA795868cosignataire
17060000002301L17/dossiers171706000000219817060000002198103PA721896cosignataire
17060000002302L17/dossiers171706000000219817060000002198104PA795998cosignataire
17060000002303L17/dossiers171706000000219817060000002198105PA774962cosignataire
17060000002304L17/dossiers171706000000219817060000002198106PA335612cosignataire
17060000002305L17/dossiers171706000000219817060000002198107PA796010cosignataire
17060000002306L17/dossiers171706000000219817060000002198108PA795820cosignataire
17060000002307L17/dossiers171706000000219817060000002198109PA795876cosignataire
17060000002308L17/dossiers171706000000219817060000002198110PA605745cosignataire
17060000002309L17/dossiers171706000000219817060000002198111PA842299cosignataire