dossiers.document_co_signataire

Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %

309 130 lignes (estimation)

Colonnes

#	Colonne	Type	Commentaire
1	`_id`	BIGINT	identifiant : code de la source × 10¹⁰ + rang
2	`_source`	VARCHAR	source du catalogue (catalogue.py)
3	`_legislature`	BIGINT	colonne constante de la source
4	`_racine_id`	BIGINT	_id de la ligne racine
5	`_parent_id`	BIGINT	_id de la ligne parente
6	`_ordre`	BIGINT	rang dans le tableau d'origine (1…)
7	`acteur_acteur_ref`	VARCHAR	document.coSignataires.coSignataire.acteur.acteurRef · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
8	`date_cosignature`	DATE	document.coSignataires.coSignataire.dateCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
9	`date_retrait_cosignature`	DATE	document.coSignataires.coSignataire.dateRetraitCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
10	`edite`	BOOLEAN	document.coSignataires.coSignataire.edite · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
11	`organe_organe_ref`	VARCHAR	document.coSignataires.coSignataire.organe.organeRef · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %
12	`organe_et_apparentes`	BOOLEAN	document.coSignataires.coSignataire.organe.etApparentes · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %

Aperçu

_id	_source	_legislature	_racine_id	_parent_id	_ordre	acteur_acteur_ref	date_cosignature	edite	organe_organe_ref	organe_et_apparentes
17060000077116	L17/dossiers	17	17060000077108	17060000077108	7	PA227099	2004-07-30	False
17060000077136	L17/dossiers	17	17060000077134	17060000077134	1	PA247	2009-10-06	False
17060000077137	L17/dossiers	17	17060000077134	17060000077134	2	PA360	2009-10-06	False
17060000077138	L17/dossiers	17	17060000077134	17060000077134	3	PA408	2009-10-06	False
17060000077139	L17/dossiers	17	17060000077134	17060000077134	4	PA814	2009-10-06	False
17060000077140	L17/dossiers	17	17060000077134	17060000077134	5	PA415491	2009-10-06	False
17060000077141	L17/dossiers	17	17060000077134	17060000077134	6	PA223231	2009-10-06	False
17060000077142	L17/dossiers	17	17060000077134	17060000077134	7	PA415464	2009-10-06	False
17060000077143	L17/dossiers	17	17060000077134	17060000077134	8	PA2091	2009-10-06	False
17060000077144	L17/dossiers	17	17060000077134	17060000077134	9	PA415482	2009-10-06	False
17060000077145	L17/dossiers	17	17060000077134	17060000077134	10	PA415500	2009-10-06	False
17060000077146	L17/dossiers	17	17060000077134	17060000077134	11	PA2426	2009-10-06	False
17060000077147	L17/dossiers	17	17060000077134	17060000077134	12	PA415480	2009-10-06	False
17060000077148	L17/dossiers	17	17060000077134	17060000077134	13	PA313208	2009-10-06	False
17060000077151	L17/dossiers	17	17060000077149	17060000077149	1	PA227026	2009-12-22	True
17060000077166	L17/dossiers	17	17060000077164	17060000077164	1	PA227019	2010-11-10	False
17060000077167	L17/dossiers	17	17060000077164	17060000077164	2	PA304007	2010-11-10	False
17060000077168	L17/dossiers	17	17060000077164	17060000077164	3	PA304003	2010-11-10	False
17060000077169	L17/dossiers	17	17060000077164	17060000077164	4	PA392735	2010-11-10	False
17060000077170	L17/dossiers	17	17060000077164	17060000077164	5	PA2940	2010-11-10	False
17060000077173	L17/dossiers	17	17060000077171	17060000077171	1	PA445	2010-12-14	False
17060000077174	L17/dossiers	17	17060000077171	17060000077171	2	PA990	2010-12-14	False
17060000077175	L17/dossiers	17	17060000077171	17060000077171	3	PA1142	2010-12-14	False
17060000077176	L17/dossiers	17	17060000077171	17060000077171	4	PA1158	2010-12-14	False
17060000077177	L17/dossiers	17	17060000077171	17060000077171	5	PA223231	2010-12-14	False
17060000077178	L17/dossiers	17	17060000077171	17060000077171	6	PA1442	2010-12-14	False
17060000077179	L17/dossiers	17	17060000077171	17060000077171	7	PA1713	2010-12-14	False
17060000077180	L17/dossiers	17	17060000077171	17060000077171	8	PA303992	2010-12-14	False
17060000077181	L17/dossiers	17	17060000077171	17060000077171	9	PA415451	2010-12-14	False
17060000077182	L17/dossiers	17	17060000077171	17060000077171	10	PA415467	2010-12-14	False
17060000077183	L17/dossiers	17	17060000077171	17060000077171	11	PA304074	2010-12-14	False
17060000077184	L17/dossiers	17	17060000077171	17060000077171	12	PA415448	2010-12-14	False
17060000077185	L17/dossiers	17	17060000077171	17060000077171	13	PA2752	2010-12-14	False
17060000077186	L17/dossiers	17	17060000077171	17060000077171	14	PA303996	2010-12-14	False
17060000077189	L17/dossiers	17	17060000077187	17060000077187	1		2011-03-11	True	PO77714	False
17060000077190	L17/dossiers	17	17060000077187	17060000077187	2	PA905	2011-03-11	True
17060000077208	L17/dossiers	17	17060000077206	17060000077206	1	PA235	2012-02-21	False
17060000077209	L17/dossiers	17	17060000077206	17060000077206	2	PA292	2012-02-21	False
17060000077210	L17/dossiers	17	17060000077206	17060000077206	3	PA1203	2012-02-21	False
17060000077211	L17/dossiers	17	17060000077206	17060000077206	4	PA429849	2012-02-21	False
17060000077212	L17/dossiers	17	17060000077206	17060000077206	5	PA404073	2012-02-21	False
17060000077213	L17/dossiers	17	17060000077206	17060000077206	6	PA429851	2012-02-21	False
17060000077214	L17/dossiers	17	17060000077206	17060000077206	7	PA421348	2012-02-21	False
17060000077215	L17/dossiers	17	17060000077206	17060000077206	8		2012-02-21	False	PO309463	False
17060000077218	L17/dossiers	17	17060000077216	17060000077216	1		2012-09-06	True	PO77710	True
17060000077231	L17/dossiers	17	17060000077229	17060000077229	1		2012-10-16	True	PO77714	False
17060000077235	L17/dossiers	17	17060000077232	17060000077232	1	PA227017	2012-11-28	False
17060000077236	L17/dossiers	17	17060000077232	17060000077232	2	PA304018	2012-11-28	False
17060000077237	L17/dossiers	17	17060000077232	17060000077232	3	PA429894	2012-11-28	False
17060000077238	L17/dossiers	17	17060000077232	17060000077232	4	PA429836	2012-11-28	False