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
17060000054009L17/dossiers17170600000539731706000005397335PA7930942026-01-27False
17060000054010L17/dossiers17170600000539731706000005397336PA8422552026-01-27False
17060000054011L17/dossiers17170600000539731706000005397337PA8407812026-01-27False
17060000054012L17/dossiers17170600000539731706000005397338PA8408092026-01-27False
17060000054013L17/dossiers17170600000539731706000005397339PA7949462026-01-27False
17060000054017L17/dossiers1717060000054015170600000540151PA7212102026-01-02False
17060000054018L17/dossiers1717060000054015170600000540152PA7939802026-01-02False
17060000054019L17/dossiers1717060000054015170600000540153PA7953622026-01-02False
17060000054020L17/dossiers1717060000054015170600000540154PA7950762026-01-02False
17060000054021L17/dossiers1717060000054015170600000540155PA8418852026-01-02False
17060000054022L17/dossiers1717060000054015170600000540156PA8415072026-01-02False
17060000054023L17/dossiers1717060000054015170600000540157PA6100022026-01-02False
17060000054024L17/dossiers1717060000054015170600000540158PA29402026-01-02False
17060000054025L17/dossiers1717060000054015170600000540159PA8420452026-01-02False
17060000054029L17/dossiers1717060000054027170600000540271PA6109682026-04-28False
17060000054030L17/dossiers1717060000054027170600000540272PA5888842026-04-28False
17060000054031L17/dossiers1717060000054027170600000540273PA8418852026-04-28False
17060000054032L17/dossiers1717060000054027170600000540274PA8415072026-04-28False
17060000054033L17/dossiers1717060000054027170600000540275PA7940082026-04-28False
17060000054034L17/dossiers1717060000054027170600000540276PA7212102026-04-28False
17060000054035L17/dossiers1717060000054027170600000540277PA8413512026-04-28False
17060000054036L17/dossiers1717060000054027170600000540278PA7950102026-04-28False
17060000054037L17/dossiers1717060000054027170600000540279PA7956362026-04-28False
17060000054038L17/dossiers17170600000540271706000005402710PA8420452026-04-28False
17060000054039L17/dossiers17170600000540271706000005402711PA7937082026-04-28False
17060000054040L17/dossiers17170600000540271706000005402712PA7936642026-04-28False
17060000054041L17/dossiers17170600000540271706000005402713PA7941542026-04-28False
17060000054042L17/dossiers17170600000540271706000005402714PA7947782026-04-28False
17060000054043L17/dossiers17170600000540271706000005402715PA6065452026-04-28False
17060000054044L17/dossiers17170600000540271706000005402716PA7950762026-04-28False
17060000054045L17/dossiers17170600000540271706000005402717PA6100022026-04-28False
17060000054046L17/dossiers17170600000540271706000005402718PA7958082026-04-28False
17060000054047L17/dossiers17170600000540271706000005402719PA8417132026-04-28False
17060000054048L17/dossiers17170600000540271706000005402720PA8416652026-04-28False
17060000054049L17/dossiers17170600000540271706000005402721PA7952402026-04-28False
17060000054050L17/dossiers17170600000540271706000005402722PA8416812026-04-28False
17060000054051L17/dossiers17170600000540271706000005402723PA6081722026-04-28False
17060000054055L17/dossiers1717060000054053170600000540531PA8410672025-12-23False
17060000054056L17/dossiers1717060000054053170600000540532PA8408892025-12-23False
17060000054057L17/dossiers1717060000054053170600000540533PA7933222025-12-23False
17060000054058L17/dossiers1717060000054053170600000540534PA8413952025-12-23False
17060000054059L17/dossiers1717060000054053170600000540535PA8407212025-12-23False
17060000054063L17/dossiers1717060000054061170600000540611PA7945622025-12-23False
17060000054064L17/dossiers1717060000054061170600000540612PA7945982025-12-23False
17060000054065L17/dossiers1717060000054061170600000540613PA7961182025-12-23False
17060000054066L17/dossiers1717060000054061170600000540614PA7932382025-12-23False
17060000054067L17/dossiers1717060000054061170600000540615PA8416452025-12-23False
17060000054068L17/dossiers1717060000054061170600000540616PA8420012025-12-23False
17060000054069L17/dossiers1717060000054061170600000540617PA7208222025-12-23False
17060000054070L17/dossiers1717060000054061170600000540618PA7948862025-12-23False