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
17060000046917L17/dossiers1717060000046914170600000469142PA7208382025-09-30False
17060000046918L17/dossiers1717060000046914170600000469143PA7947102025-09-30False
17060000046919L17/dossiers1717060000046914170600000469144PA7958682025-09-30False
17060000046920L17/dossiers1717060000046914170600000469145PA7218962025-09-30False
17060000046921L17/dossiers1717060000046914170600000469146PA7749622025-09-30False
17060000046922L17/dossiers1717060000046914170600000469147PA3356122025-09-30False
17060000046923L17/dossiers1717060000046914170600000469148PA7960102025-09-30False
17060000046924L17/dossiers1717060000046914170600000469149PA8422712025-09-30False
17060000046925L17/dossiers17170600000469141706000004691410PA7958202025-09-30False
17060000046926L17/dossiers17170600000469141706000004691411PA7212702025-09-30False
17060000046927L17/dossiers17170600000469141706000004691412PA7952402025-09-30False
17060000046928L17/dossiers17170600000469141706000004691413PA7958762025-09-30False
17060000046929L17/dossiers17170600000469141706000004691414PA6057452025-09-30False
17060000046933L17/dossiers1717060000046931170600000469311PA7948702025-09-30False
17060000046934L17/dossiers1717060000046931170600000469312PA7949062025-09-30False
17060000046935L17/dossiers1717060000046931170600000469313PA7208922025-09-30False
17060000046936L17/dossiers1717060000046931170600000469314PA7952282025-09-30False
17060000046937L17/dossiers1717060000046931170600000469315PA7932622025-09-30False
17060000046938L17/dossiers1717060000046931170600000469316PA7941382025-09-30False
17060000046939L17/dossiers1717060000046931170600000469317PA7955882025-09-30False
17060000046940L17/dossiers1717060000046931170600000469318PA7950842025-09-30False
17060000046941L17/dossiers1717060000046931170600000469319PA8421052025-09-30False
17060000046942L17/dossiers17170600000469311706000004693110PA8416572025-09-30False
17060000046943L17/dossiers17170600000469311706000004693111PA7204302025-09-30False
17060000046944L17/dossiers17170600000469311706000004693112PA7937722025-09-30False
17060000046945L17/dossiers17170600000469311706000004693113PA7956162025-09-30False
17060000046946L17/dossiers17170600000469311706000004693114PA7934442025-09-30False
17060000046947L17/dossiers17170600000469311706000004693115PA7949382025-09-30False
17060000046948L17/dossiers17170600000469311706000004693116PA7953182025-09-30False
17060000046949L17/dossiers17170600000469311706000004693117PA8410232025-09-30False
17060000046950L17/dossiers17170600000469311706000004693118PA7960902025-09-30False
17060000046951L17/dossiers17170600000469311706000004693119PA7939122025-09-30False
17060000046952L17/dossiers17170600000469311706000004693120PA8421872025-09-30False
17060000046953L17/dossiers17170600000469311706000004693121PA8420372025-09-30False
17060000046954L17/dossiers17170600000469311706000004693122PA7918122025-09-30False
17060000046955L17/dossiers17170600000469311706000004693123PA7937362025-09-30False
17060000046956L17/dossiers17170600000469311706000004693124PA7212022025-09-30False
17060000046957L17/dossiers17170600000469311706000004693125PA7951362025-09-30False
17060000046958L17/dossiers17170600000469311706000004693126PA7934642025-09-30False
17060000046959L17/dossiers17170600000469311706000004693127PA8421552025-09-30False
17060000046960L17/dossiers17170600000469311706000004693128PA7952002025-09-30False
17060000046961L17/dossiers17170600000469311706000004693129PA7958442025-09-30False
17060000046962L17/dossiers17170600000469311706000004693130PA8412512025-09-30False
17060000046963L17/dossiers17170600000469311706000004693131PA7947862025-09-30False
17060000046964L17/dossiers17170600000469311706000004693132PA7960702025-09-30False
17060000046965L17/dossiers17170600000469311706000004693133PA7953102025-09-30False
17060000046966L17/dossiers17170600000469311706000004693134PA7944782025-09-30False
17060000046967L17/dossiers17170600000469311706000004693135PA8419472025-09-30False
17060000046968L17/dossiers17170600000469311706000004693136PA7940822025-09-30False
17060000046969L17/dossiers17170600000469311706000004693137PA7941302025-09-30False