dossiers.document_co_signataire

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

305 151 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 25 %, 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
17060000003253	L17/dossiers	17	17060000003250	17060000003250	2	PA605963	2015-11-25	False
17060000003254	L17/dossiers	17	17060000003250	17060000003250	3	PA605625	2015-11-25	False
17060000003255	L17/dossiers	17	17060000003250	17060000003250	4	PA608186	2015-11-25	False
17060000003256	L17/dossiers	17	17060000003250	17060000003250	5	PA609016	2015-11-25	False
17060000003257	L17/dossiers	17	17060000003250	17060000003250	6	PA606910	2015-11-25	False
17060000003258	L17/dossiers	17	17060000003250	17060000003250	7	PA606258	2015-11-25	False
17060000003259	L17/dossiers	17	17060000003250	17060000003250	8	PA610860	2015-11-25	False
17060000003260	L17/dossiers	17	17060000003250	17060000003250	9	PA588872	2015-11-25	False
17060000003261	L17/dossiers	17	17060000003250	17060000003250	10	PA605518	2015-11-25	False
17060000003262	L17/dossiers	17	17060000003250	17060000003250	11	PA2045	2015-11-25	False
17060000003263	L17/dossiers	17	17060000003250	17060000003250	12	PA609816	2015-11-25	False
17060000003264	L17/dossiers	17	17060000003250	17060000003250	13	PA607619	2015-11-25	False
17060000003265	L17/dossiers	17	17060000003250	17060000003250	14	PA609520	2015-11-25	False
17060000003266	L17/dossiers	17	17060000003250	17060000003250	15	PA606545	2015-11-25	False
17060000003267	L17/dossiers	17	17060000003250	17060000003250	16	PA332747	2015-11-25	False
17060000003268	L17/dossiers	17	17060000003250	17060000003250	17	PA610002	2015-11-25	False
17060000003560	L17/dossiers	17	17060000003558	17060000003558	1	PA720170	2020-12-23	True
17060000003561	L17/dossiers	17	17060000003558	17060000003558	2	PA720622	2020-12-23	False
17060000003562	L17/dossiers	17	17060000003558	17060000003558	3	PA719170	2020-12-23	False
17060000003563	L17/dossiers	17	17060000003558	17060000003558	4	PA642868	2020-12-23	False
17060000003564	L17/dossiers	17	17060000003558	17060000003558	5	PA719756	2020-12-23	False
17060000003565	L17/dossiers	17	17060000003558	17060000003558	6	PA720932	2020-12-23	False
17060000003566	L17/dossiers	17	17060000003558	17060000003558	7	PA721924	2020-12-23	False
17060000003567	L17/dossiers	17	17060000003558	17060000003558	8	PA720652	2020-12-23	False
17060000003568	L17/dossiers	17	17060000003558	17060000003558	9	PA719692	2020-12-23	False
17060000003569	L17/dossiers	17	17060000003558	17060000003558	10	PA719616	2020-12-23	False
17060000003570	L17/dossiers	17	17060000003558	17060000003558	11	PA719570	2020-12-23	False
17060000003571	L17/dossiers	17	17060000003558	17060000003558	12	PA720214	2020-12-23	False
17060000003572	L17/dossiers	17	17060000003558	17060000003558	13	PA720022	2020-12-23	False
17060000003573	L17/dossiers	17	17060000003558	17060000003558	14	PA267780	2020-12-23	False
17060000003574	L17/dossiers	17	17060000003558	17060000003558	15	PA719412	2020-12-23	False
17060000003575	L17/dossiers	17	17060000003558	17060000003558	16	PA334116	2020-12-23	False
17060000003576	L17/dossiers	17	17060000003558	17060000003558	17	PA719154	2020-12-23	False
17060000003577	L17/dossiers	17	17060000003558	17060000003558	18	PA719338	2020-12-23	False
17060000003578	L17/dossiers	17	17060000003558	17060000003558	19	PA719072	2020-12-23	False
17060000003579	L17/dossiers	17	17060000003558	17060000003558	20	PA720738	2020-12-23	False
17060000003580	L17/dossiers	17	17060000003558	17060000003558	21	PA719850	2020-12-23	False
17060000003581	L17/dossiers	17	17060000003558	17060000003558	22	PA721710	2020-12-23	False
17060000003582	L17/dossiers	17	17060000003558	17060000003558	23	PA721888	2020-12-23	False
17060000003583	L17/dossiers	17	17060000003558	17060000003558	24	PA721426	2020-12-23	False
17060000003584	L17/dossiers	17	17060000003558	17060000003558	25	PA720066	2020-12-23	False
17060000003585	L17/dossiers	17	17060000003558	17060000003558	26	PA718810	2020-12-23	False
17060000003586	L17/dossiers	17	17060000003558	17060000003558	27	PA719350	2020-12-23	False
17060000003587	L17/dossiers	17	17060000003558	17060000003558	28	PA718728	2020-12-23	False
17060000003588	L17/dossiers	17	17060000003558	17060000003558	29	PA719512	2020-12-23	False
17060000003589	L17/dossiers	17	17060000003558	17060000003558	30	PA605131	2020-12-23	False
17060000003590	L17/dossiers	17	17060000003558	17060000003558	31	PA719186	2020-12-23	False
17060000003591	L17/dossiers	17	17060000003558	17060000003558	32	PA721418	2020-12-23	False
17060000003592	L17/dossiers	17	17060000003558	17060000003558	33	PA642935	2020-12-23	False
17060000003593	L17/dossiers	17	17060000003558	17060000003558	34	PA719866	2020-12-23	False