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
17060000020865L17/dossiers17170600000208141706000002081450PA7938162025-03-24False
17060000020866L17/dossiers17170600000208141706000002081451PA13272025-03-24False
17060000020867L17/dossiers17170600000208141706000002081452PA7954222025-03-24False
17060000020868L17/dossiers17170600000208141706000002081453PA7220702025-03-24False
17060000020869L17/dossiers17170600000208141706000002081454PA29402025-03-24False
17060000020870L17/dossiers17170600000208141706000002081455PA6426952025-03-24False
17060000020871L17/dossiers17170600000208141706000002081456PA7954302025-03-24False
17060000020872L17/dossiers17170600000208141706000002081457PA3322282025-03-24False
17060000020873L17/dossiers17170600000208141706000002081458PA7201002025-03-24False
17060000020874L17/dossiers17170600000208141706000002081459PA7951082025-03-24False
17060000020875L17/dossiers17170600000208141706000002081460PA7935202025-03-24False
17060000020876L17/dossiers17170600000208141706000002081461PA7936642025-03-24False
17060000020877L17/dossiers17170600000208141706000002081462PA8226172025-03-24False
17060000020878L17/dossiers17170600000208141706000002081463PA7218962025-03-24False
17060000020879L17/dossiers17170600000208141706000002081464PA7199682025-03-24False
17060000020880L17/dossiers17170600000208141706000002081465PA7935322025-03-24False
17060000020881L17/dossiers17170600000208141706000002081466PA7195582025-03-24False
17060000020882L17/dossiers17170600000208141706000002081467PA7214862025-03-24False
17060000020883L17/dossiers17170600000208141706000002081468PA7208382025-03-24False
17060000020884L17/dossiers17170600000208141706000002081469PA7203622025-03-24False
17060000020885L17/dossiers17170600000208141706000002081470PA7948542025-03-24False
17060000020886L17/dossiers17170600000208141706000002081471PA8413512025-03-24False
17060000020887L17/dossiers17170600000208141706000002081472PA7202562025-03-24False
17060000020888L17/dossiers17170600000208141706000002081473PA2677632025-03-24False
17060000020889L17/dossiers17170600000208141706000002081474PA7958682025-03-24False
17060000020890L17/dossiers17170600000208141706000002081475PA7943302025-03-24False
17060000020891L17/dossiers17170600000208141706000002081476PA3422402025-03-24False
17060000020892L17/dossiers17170600000208141706000002081477PA8418932025-03-24False
17060000020893L17/dossiers17170600000208141706000002081478PA7952002025-03-24False
17060000020894L17/dossiers17170600000208141706000002081479PA6109682025-03-24False
17060000020895L17/dossiers17170600000208141706000002081480PA7190242025-03-24False
17060000020896L17/dossiers17170600000208141706000002081481PA15922025-03-24False
17060000020897L17/dossiers17170600000208141706000002081482PA7749622025-03-24False
17060000020898L17/dossiers17170600000208141706000002081483PA7199222025-03-24False
17060000020899L17/dossiers17170600000208141706000002081484PA7935082025-03-24False
17060000020900L17/dossiers17170600000208141706000002081485PA7937802025-03-24False
17060000020901L17/dossiers17170600000208141706000002081486PA8418452025-03-24False
17060000020902L17/dossiers17170600000208141706000002081487PA7931222025-03-24False
17060000020903L17/dossiers17170600000208141706000002081488PA8410172025-03-24False
17060000020904L17/dossiers17170600000208141706000002081489PA3356122025-03-24False
17060000020905L17/dossiers17170600000208141706000002081490PA8418012025-03-24False
17060000020906L17/dossiers17170600000208141706000002081491PA7188382025-03-24False
17060000020907L17/dossiers17170600000208141706000002081492PA7199302025-03-24False
17060000020908L17/dossiers17170600000208141706000002081493PA7932622025-03-24False
17060000020909L17/dossiers17170600000208141706000002081494PA5888842025-03-24False
17060000020910L17/dossiers17170600000208141706000002081495PA6056942025-03-24False
17060000020911L17/dossiers17170600000208141706000002081496PA8419312025-03-24False
17060000020912L17/dossiers17170600000208141706000002081497PA7960102025-03-24False
17060000020913L17/dossiers17170600000208141706000002081498PA7949822025-03-24False
17060000020914L17/dossiers17170600000208141706000002081499PA8410472025-03-24False