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
17060000018126L17/dossiers17170600000181121706000001811213PA7939122025-01-22False
17060000018127L17/dossiers17170600000181121706000001811214PA8421872025-01-22False
17060000018128L17/dossiers17170600000181121706000001811215PA8420372025-01-22False
17060000018129L17/dossiers17170600000181121706000001811216PA7918122025-01-22False
17060000018130L17/dossiers17170600000181121706000001811217PA7937362025-01-22False
17060000018131L17/dossiers17170600000181121706000001811218PA7951362025-01-22False
17060000018132L17/dossiers17170600000181121706000001811219PA7934642025-01-22False
17060000018133L17/dossiers17170600000181121706000001811220PA8421552025-01-22False
17060000018134L17/dossiers17170600000181121706000001811221PA7958442025-01-22False
17060000018135L17/dossiers17170600000181121706000001811222PA7947862025-01-22False
17060000018136L17/dossiers17170600000181121706000001811223PA7948702025-01-22False
17060000018137L17/dossiers17170600000181121706000001811224PA7960702025-01-22False
17060000018138L17/dossiers17170600000181121706000001811225PA7953102025-01-22False
17060000018139L17/dossiers17170600000181121706000001811226PA8419472025-01-22False
17060000018140L17/dossiers17170600000181121706000001811227PA7940822025-01-22False
17060000018141L17/dossiers17170600000181121706000001811228PA7955162025-01-22False
17060000018142L17/dossiers17170600000181121706000001811229PA7951082025-01-22False
17060000018143L17/dossiers17170600000181121706000001811230PA8415152025-01-22False
17060000018144L17/dossiers17170600000181121706000001811231PA7935322025-01-22False
17060000018145L17/dossiers17170600000181121706000001811232PA7954222025-01-22False
17060000018146L17/dossiers17170600000181121706000001811233PA7946862025-01-22False
17060000018147L17/dossiers17170600000181121706000001811234PA8412152025-01-22False
17060000018148L17/dossiers17170600000181121706000001811235PA8411912025-01-22False
17060000018149L17/dossiers17170600000181121706000001811236PA7208922025-01-22False
17060000018150L17/dossiers17170600000181121706000001811237PA8172112025-01-22False
17060000018151L17/dossiers17170600000181121706000001811238PA7195782025-01-22False
17060000018152L17/dossiers17170600000181121706000001811239PA8418452025-01-22False
17060000018153L17/dossiers17170600000181121706000001811240PA7954662025-01-22False
17060000018154L17/dossiers17170600000181121706000001811241PA7209522025-01-22False
17060000018155L17/dossiers17170600000181121706000001811242PA7941662025-01-22False
17060000018156L17/dossiers17170600000181121706000001811243PA7951642025-01-22False
17060000018157L17/dossiers17170600000181121706000001811244PA5888842025-01-22False
17060000018158L17/dossiers17170600000181121706000001811245PA7954542025-01-22False
17060000018159L17/dossiers17170600000181121706000001811246PA8418852025-01-22False
17060000018160L17/dossiers17170600000181121706000001811247PA7940082025-01-22False
17060000018161L17/dossiers17170600000181121706000001811248PA7934522025-01-22False
17060000018162L17/dossiers17170600000181121706000001811249PA8414192025-01-22False
17060000018163L17/dossiers17170600000181121706000001811250PA8420132025-01-22False
17060000018164L17/dossiers17170600000181121706000001811251PA7193382025-01-22False
17060000018165L17/dossiers17170600000181121706000001811252PA8409472025-01-22False
17060000018166L17/dossiers17170600000181121706000001811253PA7940222025-01-22False
17060000018167L17/dossiers17170600000181121706000001811254PA8420452025-01-22False
17060000018168L17/dossiers17170600000181121706000001811255PA7941542025-01-22False
17060000018169L17/dossiers17170600000181121706000001811256PA7950762025-01-22False
17060000018170L17/dossiers17170600000181121706000001811257PA7958082025-01-22False
17060000018171L17/dossiers17170600000181121706000001811258PA7362012025-01-22False
17060000018172L17/dossiers17170600000181121706000001811259PA8417132025-01-22False
17060000018173L17/dossiers17170600000181121706000001811260PA7208382025-01-22False
17060000018174L17/dossiers17170600000181121706000001811261PA7218962025-01-22False
17060000018175L17/dossiers17170600000181121706000001811262PA7960102025-01-22False