AN · données ouvertes
Explorateur / dossiers

dossiers.document_division_auteur

Chemin document.divisions.division.auteurs.auteur · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 %

7 614 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…)
7_parent_recursif_idBIGINT_id de la ligne de même table qui contient celle-ci (structure récursive)
8_niveauBIGINTprofondeur dans la structure récursive (0 = premier niveau)
9acteur_acteur_refVARCHARdocument.divisions.division.auteurs.auteur.acteur.acteurRef · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 %
10acteur_qualiteVARCHARdocument.divisions.division.auteurs.auteur.acteur.qualite · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 % · 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
11organe_organe_refVARCHARdocument.divisions.division.auteurs.auteur.organe.organeRef · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordre_parent_recursif_id_niveauacteur_acteur_refacteur_qualiteorgane_organe_ref
16060000084794L16/dossiers16160600000847921606000008479310PA721372rapporteur
16060000084795L16/dossiers16160600000847921606000008479320PO419865
16060000084810L16/dossiers16160600000848081606000008480910PA774954rapporteur
16060000084811L16/dossiers16160600000848081606000008480920PO419604
16060000084824L16/dossiers16160600000848221606000008482310PA719448rapporteur
16060000084825L16/dossiers16160600000848221606000008482320PO420120
16060000084836L16/dossiers16160600000848341606000008483510PA720862rapporteur
16060000084837L16/dossiers16160600000848341606000008483520PO419610
16060000084845L16/dossiers16160600000848431606000008484410PA340357rapporteur
16060000084846L16/dossiers16160600000848431606000008484420PO419604
16060000084857L16/dossiers16160600000848551606000008485610PA718756rapporteur
16060000084858L16/dossiers16160600000848551606000008485620PO59051
16060000084875L16/dossiers16160600000848731606000008487410PA719866rapporteur
16060000084876L16/dossiers16160600000848731606000008487420PO59051
16060000084881L16/dossiers16160600000848791606000008488010PA719472rapporteur
16060000084882L16/dossiers16160600000848791606000008488020PO59048
16060000084884L16/dossiers16160600000848791606000008488310PA719472rapporteur
16060000084885L16/dossiers16160600000848791606000008488320PO59048
16060000084887L16/dossiers16160600000848791606000008488610PA719472rapporteur
16060000084888L16/dossiers16160600000848791606000008488620PO59048
16060000084893L16/dossiers16160600000848911606000008489210PA720480rapporteur
16060000084894L16/dossiers16160600000848911606000008489220PO420120
16060000084899L16/dossiers16160600000848971606000008489810PA719472rapporteur
16060000084900L16/dossiers16160600000848971606000008489820PO59048
16060000084908L16/dossiers16160600000849061606000008490710PA721262rapporteur
16060000084909L16/dossiers16160600000849061606000008490720PO59051
16060000084920L16/dossiers16160600000849181606000008491910PA719472rapporteur
16060000084921L16/dossiers16160600000849181606000008491920PO802358
16060000084954L16/dossiers16160600000849521606000008495310PA795884rapporteur
16060000084955L16/dossiers16160600000849521606000008495320PO420120
16060000084960L16/dossiers16160600000849581606000008495910PA721530rapporteur
16060000084961L16/dossiers16160600000849581606000008495920PO59048
16060000084966L16/dossiers16160600000849641606000008496510PA722284rapporteur
16060000084967L16/dossiers16160600000849641606000008496520PO420120
16060000084972L16/dossiers16160600000849701606000008497110PA720092rapporteur
16060000084973L16/dossiers16160600000849701606000008497120PO419865
16060000084978L16/dossiers16160600000849761606000008497710PA720334rapporteur
16060000084979L16/dossiers16160600000849761606000008497720PO419865
16060000084990L16/dossiers16160600000849881606000008498910PA719472rapporteur général
16060000084991L16/dossiers16160600000849881606000008498920PO59048
16060000084993L16/dossiers16160600000849881606000008499210PA719472rapporteur général
16060000084994L16/dossiers16160600000849881606000008499220PO59048
16060000084996L16/dossiers16160600000849881606000008499510PA719472rapporteur général
16060000084997L16/dossiers16160600000849881606000008499520PO59048
16060000085000L16/dossiers16160600000849881606000008499911PA795454rapporteur spécial
16060000085001L16/dossiers16160600000849881606000008499921PO59048
16060000085003L16/dossiers16160600000849881606000008500211PA721410rapporteur spécial
16060000085004L16/dossiers16160600000849881606000008500221PO59048
16060000085006L16/dossiers16160600000849881606000008500511PA942rapporteur spécial
16060000085007L16/dossiers16160600000849881606000008500521PO59048