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
17060000002563L17/dossiers17170600000025291706000000252934PA796034cosignataire
17060000002564L17/dossiers17170600000025291706000000252935PA793832cosignataire
17060000002565L17/dossiers17170600000025291706000000252936PA793102cosignataire
17060000002566L17/dossiers17170600000025291706000000252937PA841605cosignataire
17060000002567L17/dossiers17170600000025291706000000252938PA793362cosignataire
17060000002568L17/dossiers17170600000025291706000000252939PA794418cosignataire
17060000002569L17/dossiers17170600000025291706000000252940PA793592cosignataire
17060000002570L17/dossiers17170600000025291706000000252941PA840757cosignataire
17060000002571L17/dossiers17170600000025291706000000252942PA841451cosignataire
17060000002572L17/dossiers17170600000025291706000000252943PA794734cosignataire
17060000002573L17/dossiers17170600000025291706000000252944PA793218cosignataire
17060000002574L17/dossiers17170600000025291706000000252945PA795900cosignataire
17060000002575L17/dossiers17170600000025291706000000252946PA842085cosignataire
17060000002576L17/dossiers17170600000025291706000000252947PA794598cosignataire
17060000002577L17/dossiers17170600000025291706000000252948PA794030cosignataire
17060000002578L17/dossiers17170600000025291706000000252949PA841075cosignataire
17060000002579L17/dossiers17170600000025291706000000252950PA840869cosignataire
17060000002580L17/dossiers17170600000025291706000000252951PA794354cosignataire
17060000002581L17/dossiers17170600000025291706000000252952PA841837cosignataire
17060000002582L17/dossiers17170600000025291706000000252953PA840857cosignataire
17060000002583L17/dossiers17170600000025291706000000252954PA793290cosignataire
17060000002584L17/dossiers17170600000025291706000000252955PA793608cosignataire
17060000002585L17/dossiers17170600000025291706000000252956PA841873cosignataire
17060000002586L17/dossiers17170600000025291706000000252957PA793672cosignataire
17060000002587L17/dossiers17170600000025291706000000252958PA721932cosignataire
17060000002588L17/dossiers17170600000025291706000000252959PA795974cosignataire
17060000002589L17/dossiers17170600000025291706000000252960PA794590cosignataire
17060000002590L17/dossiers17170600000025291706000000252961PA841587cosignataire
17060000002591L17/dossiers17170600000025291706000000252962PA841563cosignataire
17060000002592L17/dossiers17170600000025291706000000252963PA794530cosignataire
17060000002593L17/dossiers17170600000025291706000000252964PA840837cosignataire
17060000002594L17/dossiers17170600000025291706000000252965PA794770cosignataire
17060000002595L17/dossiers17170600000025291706000000252966PA793616cosignataire
17060000002596L17/dossiers17170600000025291706000000252967PA794322cosignataire
17060000002597L17/dossiers17170600000025291706000000252968PA793852cosignataire
17060000002598L17/dossiers17170600000025291706000000252969PA840915cosignataire
17060000002599L17/dossiers17170600000025291706000000252970PA793696cosignataire
17060000002600L17/dossiers17170600000025291706000000252971PA794670cosignataire
17060000002601L17/dossiers17170600000025291706000000252972PA841199cosignataire
17060000002602L17/dossiers17170600000025291706000000252973PA794582cosignataire
17060000002603L17/dossiers17170600000025291706000000252974PA793656cosignataire
17060000002604L17/dossiers17170600000025291706000000252975PA795966cosignataire
17060000002605L17/dossiers17170600000025291706000000252976PA793254cosignataire
17060000002606L17/dossiers17170600000025291706000000252977PA841955cosignataire
17060000002607L17/dossiers17170600000025291706000000252978PA841981cosignataire
17060000002608L17/dossiers17170600000025291706000000252979PA842227cosignataire
17060000002609L17/dossiers17170600000025291706000000252980PA794442cosignataire
17060000002610L17/dossiers17170600000025291706000000252981PA795410cosignataire
17060000002611L17/dossiers17170600000025291706000000252982PA842097cosignataire
17060000002612L17/dossiers17170600000025291706000000252983PA794570cosignataire