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
17060000107524L17/dossiers17170600001075211706000010752220PO420120
17060000107529L17/dossiers17170600001075271706000010752810PA795746rapporteur
17060000107530L17/dossiers17170600001075271706000010752820PO852507
17060000107538L17/dossiers17170600001075361706000010753710PA795876rapporteur
17060000107539L17/dossiers17170600001075361706000010753720PO59051
17060000107544L17/dossiers17170600001075421706000010754310PA721474rapporteur
17060000107545L17/dossiers17170600001075421706000010754320PO420120
17060000107563L17/dossiers17170600001075611706000010756210PA942rapporteur
17060000107564L17/dossiers17170600001075611706000010756220PO59048
17060000107566L17/dossiers17170600001075611706000010756510PA942rapporteur
17060000107567L17/dossiers17170600001075611706000010756520PO59048
17060000107572L17/dossiers17170600001075701706000010757110PA795144rapporteur
17060000107573L17/dossiers17170600001075701706000010757120PO419610
17060000107581L17/dossiers17170600001075791706000010758010PA795240rapporteur
17060000107582L17/dossiers17170600001075791706000010758020PO854138
17060000107584L17/dossiers17170600001075791706000010758310PA795240rapporteur
17060000107585L17/dossiers17170600001075791706000010758320PO854138
17060000107590L17/dossiers17170600001075881706000010758910PA335054rapporteur
17060000107591L17/dossiers17170600001075881706000010758920PA720552rapporteur
17060000107592L17/dossiers17170600001075881706000010758930PO419604
17060000107604L17/dossiers17170600001076021706000010760310PA331582rapporteur
17060000107605L17/dossiers17170600001076021706000010760320PA266797rapporteur
17060000107606L17/dossiers17170600001076021706000010760330PA267780rapporteur
17060000107607L17/dossiers17170600001076021706000010760340PA796078rapporteur
17060000107608L17/dossiers17170600001076021706000010760350PO59051
17060000107622L17/dossiers17170600001076201706000010762110PA841769rapporteur
17060000107623L17/dossiers17170600001076201706000010762120PO59051
17060000107628L17/dossiers17170600001076261706000010762710PA267561rapporteur
17060000107629L17/dossiers17170600001076261706000010762720PO59051
17060000107637L17/dossiers17170600001076351706000010763610PA720022rapporteur
17060000107638L17/dossiers17170600001076351706000010763620PO420120
17060000107643L17/dossiers17170600001076411706000010764210PA608826rapporteur
17060000107644L17/dossiers17170600001076411706000010764220PA793398rapporteur
17060000107645L17/dossiers17170600001076411706000010764230PO419604
17060000107657L17/dossiers17170600001076551706000010765610PA840983rapporteur
17060000107658L17/dossiers17170600001076551706000010765620PO420120
17060000107666L17/dossiers17170600001076641706000010766510PA719404rapporteur
17060000107667L17/dossiers17170600001076641706000010766520PA795430rapporteur
17060000107668L17/dossiers17170600001076641706000010766530PO59051
17060000107674L17/dossiers17170600001076721706000010767310PA722162rapporteur
17060000107675L17/dossiers17170600001076721706000010767320PA721474rapporteur
17060000107676L17/dossiers17170600001076721706000010767330PO420120
17060000107691L17/dossiers17170600001076891706000010769010PA606098rapporteur
17060000107692L17/dossiers17170600001076891706000010769020PO59051
17060000107697L17/dossiers17170600001076951706000010769610PA794486rapporteur
17060000107698L17/dossiers17170600001076951706000010769620PA795596rapporteur
17060000107699L17/dossiers17170600001076951706000010769630PO419604
17060000107701L17/dossiers17170600001076951706000010770010PA794486rapporteur
17060000107702L17/dossiers17170600001076951706000010770020PA795596rapporteur
17060000107703L17/dossiers17170600001076951706000010770030PO419604