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
17060000107342L17/dossiers17170600001073311706000010733930PA795108rapporteur
17060000107343L17/dossiers17170600001073311706000010733940PA720446rapporteur
17060000107344L17/dossiers17170600001073311706000010733950PA793210rapporteur
17060000107345L17/dossiers17170600001073311706000010733960PO420120
17060000107347L17/dossiers17170600001073311706000010734610PA605694rapporteur
17060000107348L17/dossiers17170600001073311706000010734620PA795430rapporteur
17060000107349L17/dossiers17170600001073311706000010734630PA795108rapporteur
17060000107350L17/dossiers17170600001073311706000010734640PA720446rapporteur
17060000107351L17/dossiers17170600001073311706000010734650PA793210rapporteur
17060000107352L17/dossiers17170600001073311706000010734660PO420120
17060000107361L17/dossiers17170600001073591706000010736010PA721584rapporteur
17060000107362L17/dossiers17170600001073591706000010736020PO868142
17060000107370L17/dossiers17170600001073681706000010736910PA721474rapporteur
17060000107371L17/dossiers17170600001073681706000010736920PO59051
17060000107379L17/dossiers17170600001073771706000010737810PA721486rapporteur
17060000107380L17/dossiers17170600001073771706000010737820PO59051
17060000107385L17/dossiers17170600001073831706000010738410PA719286rapporteur
17060000107386L17/dossiers17170600001073831706000010738420PO420120
17060000107391L17/dossiers17170600001073891706000010739010PA794554rapporteur
17060000107392L17/dossiers17170600001073891706000010739020PO420120
17060000107404L17/dossiers17170600001074021706000010740310PA841017rapporteur
17060000107405L17/dossiers17170600001074021706000010740320PO419610
17060000107422L17/dossiers17170600001074201706000010742110PA712015rapporteur
17060000107423L17/dossiers17170600001074201706000010742120PO419610
17060000107437L17/dossiers17170600001074351706000010743610PA721584rapporteur
17060000107438L17/dossiers17170600001074351706000010743620PO419865
17060000107446L17/dossiers17170600001074441706000010744510PA795950rapporteur
17060000107447L17/dossiers17170600001074441706000010744520PO419610
17060000107452L17/dossiers17170600001074501706000010745110PA345722rapporteur
17060000107453L17/dossiers17170600001074501706000010745120PA722070rapporteur
17060000107454L17/dossiers17170600001074501706000010745130PO869346
17060000107463L17/dossiers17170600001074611706000010746210PA718850rapporteur
17060000107464L17/dossiers17170600001074611706000010746220PO420120
17060000107469L17/dossiers17170600001074671706000010746810PA794802rapporteur
17060000107470L17/dossiers17170600001074671706000010746820PO59046
17060000107481L17/dossiers17170600001074791706000010748010PA795664rapporteur
17060000107482L17/dossiers17170600001074791706000010748020PO59048
17060000107487L17/dossiers17170600001074851706000010748610PA796010rapporteur
17060000107488L17/dossiers17170600001074851706000010748620PO419610
17060000107493L17/dossiers17170600001074911706000010749210PA605745rapporteur
17060000107494L17/dossiers17170600001074911706000010749220PO59048
17060000107499L17/dossiers17170600001074971706000010749810PA796106rapporteur
17060000107500L17/dossiers17170600001074971706000010749820PO420120
17060000107505L17/dossiers17170600001075031706000010750410PA609332rapporteur
17060000107506L17/dossiers17170600001075031706000010750420PO59046
17060000107511L17/dossiers17170600001075091706000010751010PA794466rapporteur
17060000107512L17/dossiers17170600001075091706000010751020PO59051
17060000107517L17/dossiers17170600001075151706000010751610PA793174rapporteur
17060000107518L17/dossiers17170600001075151706000010751620PO59048
17060000107523L17/dossiers17170600001075211706000010752210PA795998rapporteur