AN · données ouvertes
Explorateur / dossiers

dossiers.document_co_signataire

Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %

305 264 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.coSignataires.coSignataire.acteur.acteurRef · présence : L17 25 %, L16 26 %, L15 28 %, L14 29 %
8date_cosignatureDATEdocument.coSignataires.coSignataire.dateCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
9date_retrait_cosignatureDATEdocument.coSignataires.coSignataire.dateRetraitCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
10editeBOOLEANdocument.coSignataires.coSignataire.edite · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
11organe_organe_refVARCHARdocument.coSignataires.coSignataire.organe.organeRef · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %
12organe_et_apparentesBOOLEANdocument.coSignataires.coSignataire.organe.etApparentes · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreacteur_acteur_refdate_cosignaturedate_retrait_cosignatureediteorgane_organe_reforgane_et_apparentes
17060000036854L17/dossiers17170600000367751706000003677578PA8407812025-05-13False
17060000036855L17/dossiers17170600000367751706000003677579PA7949462025-05-13False
17060000036856L17/dossiers17170600000367751706000003677580PA8414792025-05-13False
17060000036860L17/dossiers1717060000036858170600000368581PA7949942025-05-13False
17060000036861L17/dossiers1717060000036858170600000368582PA6428472025-05-13False
17060000036862L17/dossiers1717060000036858170600000368583PA7188842025-05-13False
17060000036863L17/dossiers1717060000036858170600000368584PA7188382025-05-13False
17060000036864L17/dossiers1717060000036858170600000368585PA7188502025-05-13False
17060000036865L17/dossiers1717060000036858170600000368586PA7223902025-05-13False
17060000036866L17/dossiers1717060000036858170600000368587PA3325232025-05-13False
17060000036867L17/dossiers1717060000036858170600000368588PA3309092025-05-13False
17060000036868L17/dossiers1717060000036858170600000368589PA6088262025-05-13False
17060000036869L17/dossiers17170600000368581706000003685810PA13272025-05-13False
17060000036870L17/dossiers17170600000368581706000003685811PA6084162025-05-13False
17060000036871L17/dossiers17170600000368581706000003685812PA7933422025-05-13False
17060000036872L17/dossiers17170600000368581706000003685813PA7187842025-05-13False
17060000036873L17/dossiers17170600000368581706000003685814PA7214422025-05-13False
17060000036874L17/dossiers17170600000368581706000003685815PA7941182025-05-13False
17060000036875L17/dossiers17170600000368581706000003685816PA8421172025-05-13False
17060000036876L17/dossiers17170600000368581706000003685817PA4085782025-05-13False
17060000036877L17/dossiers17170600000368581706000003685818PA8409792025-05-13False
17060000036878L17/dossiers17170600000368581706000003685819PA3422402025-05-13False
17060000036879L17/dossiers17170600000368581706000003685820PA6427252025-05-13False
17060000036880L17/dossiers17170600000368581706000003685821PA7214102025-05-13False
17060000036881L17/dossiers17170600000368581706000003685822PA16302025-05-13False
17060000036882L17/dossiers17170600000368581706000003685823PA7206442025-05-13False
17060000036883L17/dossiers17170600000368581706000003685824PA2667972025-05-13False
17060000036884L17/dossiers17170600000368581706000003685825PA7203862025-05-13False
17060000036888L17/dossiers1717060000036886170600000368861PA6428472025-05-13False
17060000036889L17/dossiers1717060000036886170600000368862PA7188842025-05-13False
17060000036890L17/dossiers1717060000036886170600000368863PA4085782025-05-13False
17060000036891L17/dossiers1717060000036886170600000368864PA7199682025-05-13False
17060000036892L17/dossiers1717060000036886170600000368865PA7214102025-05-13False
17060000036893L17/dossiers1717060000036886170600000368866PA7218162025-05-13False
17060000036894L17/dossiers1717060000036886170600000368867PA3422402025-05-13False
17060000036895L17/dossiers1717060000036886170600000368868PA7188502025-05-13False
17060000036896L17/dossiers1717060000036886170600000368869PA7223902025-05-13False
17060000036897L17/dossiers17170600000368861706000003688610PA3325232025-05-13False
17060000036898L17/dossiers17170600000368861706000003688611PA3309092025-05-13False
17060000036899L17/dossiers17170600000368861706000003688612PA7940422025-05-13False
17060000036900L17/dossiers17170600000368861706000003688613PA7203862025-05-13False
17060000036901L17/dossiers17170600000368861706000003688614PA6088262025-05-13False
17060000036902L17/dossiers17170600000368861706000003688615PA13272025-05-13False
17060000036903L17/dossiers17170600000368861706000003688616PA6084162025-05-13False
17060000036904L17/dossiers17170600000368861706000003688617PA8421172025-05-13False
17060000036905L17/dossiers17170600000368861706000003688618PA8409792025-05-13False
17060000036906L17/dossiers17170600000368861706000003688619PA6955122025-05-13False
17060000036907L17/dossiers17170600000368861706000003688620PA6427252025-05-13False
17060000036908L17/dossiers17170600000368861706000003688621PA7933422025-05-13False
17060000036909L17/dossiers17170600000368861706000003688622PA7206442025-05-13False