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 151 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
17060000010644L17/dossiers171706000001052917060000010529114PA7960502025-03-07False
17060000010645L17/dossiers171706000001052917060000010529115PA8417772024-10-152025-03-07False
17060000010646L17/dossiers171706000001052917060000010529116PA8422552025-03-07False
17060000010647L17/dossiers171706000001052917060000010529117PA7933822025-03-07False
17060000010648L17/dossiers171706000001052917060000010529118PA7945022025-03-07False
17060000010649L17/dossiers171706000001052917060000010529119PA8407372025-03-07False
17060000010650L17/dossiers171706000001052917060000010529120PA8415532025-03-07False
17060000010651L17/dossiers171706000001052917060000010529121PA7932982025-03-07False
17060000010652L17/dossiers171706000001052917060000010529122PA8407812025-03-07False
17060000010653L17/dossiers171706000001052917060000010529123PA7949462025-03-07False
17060000010654L17/dossiers171706000001052917060000010529124PA8415752025-03-07False
17060000010655L17/dossiers171706000001052917060000010529125PA8414792025-03-07False
17060000010662L17/dossiers1717060000010660170600000106601PA6428472024-10-15False
17060000010663L17/dossiers1717060000010660170600000106602PA7199682024-10-15False
17060000010664L17/dossiers1717060000010660170600000106603PA7214102024-10-15False
17060000010665L17/dossiers1717060000010660170600000106604PA3422402024-10-15False
17060000010666L17/dossiers1717060000010660170600000106605PA7935082024-10-15False
17060000010667L17/dossiers1717060000010660170600000106606PA8410472024-10-15False
17060000010668L17/dossiers1717060000010660170600000106607PA7223902024-10-15False
17060000010669L17/dossiers1717060000010660170600000106608PA3309092024-10-15False
17060000010670L17/dossiers1717060000010660170600000106609PA6088262024-10-15False
17060000010671L17/dossiers17170600000106601706000001066010PA6059912024-10-15False
17060000010672L17/dossiers17170600000106601706000001066011PA16302024-10-15False
17060000010673L17/dossiers17170600000106601706000001066012PA7949942024-10-15False
17060000010674L17/dossiers17170600000106601706000001066013PA7941782024-10-15False
17060000010681L17/dossiers1717060000010679170600000106791PA7206442025-02-17False
17060000010682L17/dossiers1717060000010679170600000106792PA7933422025-02-17False
17060000010683L17/dossiers1717060000010679170600000106793PA7935082025-02-17False
17060000010684L17/dossiers1717060000010679170600000106794PA7188382025-02-17False
17060000010685L17/dossiers1717060000010679170600000106795PA6080162025-02-17False
17060000010686L17/dossiers1717060000010679170600000106796PA7120152025-02-17False
17060000010687L17/dossiers1717060000010679170600000106797PA7199682025-02-17False
17060000010688L17/dossiers1717060000010679170600000106798PA7941182025-02-17False
17060000010689L17/dossiers1717060000010679170600000106799PA6070902025-02-17False
17060000010690L17/dossiers17170600000106791706000001067910PA3325232024-10-152025-02-17False
17060000010691L17/dossiers17170600000106791706000001067911PA3309092025-02-17False
17060000010692L17/dossiers17170600000106791706000001067912PA2668082025-02-17False
17060000010693L17/dossiers17170600000106791706000001067913PA7218162025-02-17False
17060000010694L17/dossiers17170600000106791706000001067914PA7930942025-02-17False
17060000010695L17/dossiers17170600000106791706000001067915PA7941782025-02-17False
17060000010696L17/dossiers17170600000106791706000001067916PA3422402025-02-17False
17060000010697L17/dossiers17170600000106791706000001067917PA7949942025-02-17False
17060000010698L17/dossiers17170600000106791706000001067918PA7940582025-02-17False
17060000010699L17/dossiers17170600000106791706000001067919PA6428472025-02-17False
17060000010700L17/dossiers17170600000106791706000001067920PA7214102025-02-17False
17060000010701L17/dossiers17170600000106791706000001067921PA3467822025-02-17False
17060000010702L17/dossiers17170600000106791706000001067922PA2667972025-02-17False
17060000010703L17/dossiers17170600000106791706000001067923PA7187842025-02-17False
17060000010704L17/dossiers17170600000106791706000001067924PA16302025-02-17False
17060000010705L17/dossiers17170600000106791706000001067925PA6088262025-02-17False