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
17060000002361L17/dossiers17170600000023101706000000231051PA794354cosignataire
17060000002362L17/dossiers17170600000023101706000000231052PA841837cosignataire
17060000002363L17/dossiers17170600000023101706000000231053PA840857cosignataire
17060000002364L17/dossiers17170600000023101706000000231054PA793290cosignataire
17060000002365L17/dossiers17170600000023101706000000231055PA793608cosignataire
17060000002366L17/dossiers17170600000023101706000000231056PA841873cosignataire
17060000002367L17/dossiers17170600000023101706000000231057PA793672cosignataire
17060000002368L17/dossiers17170600000023101706000000231058PA721932cosignataire
17060000002369L17/dossiers17170600000023101706000000231059PA795974cosignataire
17060000002370L17/dossiers17170600000023101706000000231060PA794590cosignataire
17060000002371L17/dossiers17170600000023101706000000231061PA841587cosignataire
17060000002372L17/dossiers17170600000023101706000000231062PA841563cosignataire
17060000002373L17/dossiers17170600000023101706000000231063PA840837cosignataire
17060000002374L17/dossiers17170600000023101706000000231064PA794770cosignataire
17060000002375L17/dossiers17170600000023101706000000231065PA793616cosignataire
17060000002376L17/dossiers17170600000023101706000000231066PA794322cosignataire
17060000002377L17/dossiers17170600000023101706000000231067PA793852cosignataire
17060000002378L17/dossiers17170600000023101706000000231068PA840915cosignataire
17060000002379L17/dossiers17170600000023101706000000231069PA793696cosignataire
17060000002380L17/dossiers17170600000023101706000000231070PA794670cosignataire
17060000002381L17/dossiers17170600000023101706000000231071PA841199cosignataire
17060000002382L17/dossiers17170600000023101706000000231072PA794582cosignataire
17060000002383L17/dossiers17170600000023101706000000231073PA793656cosignataire
17060000002384L17/dossiers17170600000023101706000000231074PA795966cosignataire
17060000002385L17/dossiers17170600000023101706000000231075PA793254cosignataire
17060000002386L17/dossiers17170600000023101706000000231076PA841955cosignataire
17060000002387L17/dossiers17170600000023101706000000231077PA841981cosignataire
17060000002388L17/dossiers17170600000023101706000000231078PA842227cosignataire
17060000002389L17/dossiers17170600000023101706000000231079PA794442cosignataire
17060000002390L17/dossiers17170600000023101706000000231080PA795410cosignataire
17060000002391L17/dossiers17170600000023101706000000231081PA842097cosignataire
17060000002392L17/dossiers17170600000023101706000000231082PA794570cosignataire
17060000002393L17/dossiers17170600000023101706000000231083PA794954cosignataire
17060000002394L17/dossiers17170600000023101706000000231084PA842255cosignataire
17060000002395L17/dossiers17170600000023101706000000231085PA793382cosignataire
17060000002396L17/dossiers17170600000023101706000000231086PA795778cosignataire
17060000002397L17/dossiers17170600000023101706000000231087PA794502cosignataire
17060000002398L17/dossiers17170600000023101706000000231088PA841553cosignataire
17060000002399L17/dossiers17170600000023101706000000231089PA793298cosignataire
17060000002400L17/dossiers17170600000023101706000000231090PA840781cosignataire
17060000002401L17/dossiers17170600000023101706000000231091PA841575cosignataire
17060000002402L17/dossiers17170600000023101706000000231092PA841479cosignataire
17060000002403L17/dossiers17170600000023101706000000231093PA840889cosignataire
17060000002404L17/dossiers17170600000023101706000000231094PA841973cosignataire
17060000002405L17/dossiers17170600000023101706000000231095PA840701cosignataire
17060000002406L17/dossiers17170600000023101706000000231096PA840721cosignataire
17060000002407L17/dossiers17170600000023101706000000231097PA793322cosignataire
17060000002408L17/dossiers17170600000023101706000000231098PA840773cosignataire
17060000002409L17/dossiers17170600000023101706000000231099PA840983cosignataire
17060000002410L17/dossiers171706000000231017060000002310100PA841183cosignataire