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
17060000003594	L17/dossiers	17	17060000003558	17060000003558	35	PA722038	2020-12-23	False
17060000003595	L17/dossiers	17	17060000003558	17060000003558	36	PA721036	2020-12-23	False
17060000003596	L17/dossiers	17	17060000003558	17060000003558	37	PA718954	2020-12-23	False
17060000003597	L17/dossiers	17	17060000003558	17060000003558	38	PA605963	2020-12-23	False
17060000003598	L17/dossiers	17	17060000003558	17060000003558	39	PA724827	2020-12-23	False
17060000003599	L17/dossiers	17	17060000003558	17060000003558	40	PA720124	2020-12-23	False
17060000003600	L17/dossiers	17	17060000003558	17060000003558	41	PA721278	2020-12-23	False
17060000003601	L17/dossiers	17	17060000003558	17060000003558	42	PA721158	2020-12-23	False
17060000003602	L17/dossiers	17	17060000003558	17060000003558	43	PA719100	2020-12-23	False
17060000003603	L17/dossiers	17	17060000003558	17060000003558	44	PA720310	2020-12-23	False
17060000003604	L17/dossiers	17	17060000003558	17060000003558	45	PA721674	2020-12-23	False
17060000003605	L17/dossiers	17	17060000003558	17060000003558	46	PA721624	2020-12-23	False
17060000003606	L17/dossiers	17	17060000003558	17060000003558	47	PA719770	2020-12-23	False
17060000003607	L17/dossiers	17	17060000003558	17060000003558	48	PA721776	2020-12-23	False
17060000003608	L17/dossiers	17	17060000003558	17060000003558	49	PA722082	2020-12-23	False
17060000003609	L17/dossiers	17	17060000003558	17060000003558	50	PA642724	2020-12-23	False
17060000003610	L17/dossiers	17	17060000003558	17060000003558	51	PA721522	2020-12-23	False
17060000003611	L17/dossiers	17	17060000003558	17060000003558	52	PA722170	2020-12-23	False
17060000003612	L17/dossiers	17	17060000003558	17060000003558	53	PA720362	2020-12-23	False
17060000003613	L17/dossiers	17	17060000003558	17060000003558	54	PA722046	2020-12-23	False
17060000003614	L17/dossiers	17	17060000003558	17060000003558	55	PA719218	2020-12-23	False
17060000003615	L17/dossiers	17	17060000003558	17060000003558	56	PA718876	2020-12-23	False
17060000003616	L17/dossiers	17	17060000003558	17060000003558	57	PA722312	2020-12-23	False
17060000003617	L17/dossiers	17	17060000003558	17060000003558	58	PA718990	2020-12-23	False
17060000003618	L17/dossiers	17	17060000003558	17060000003558	59	PA608641	2020-12-23	False
17060000003619	L17/dossiers	17	17060000003558	17060000003558	60	PA720576	2020-12-23	False
17060000003620	L17/dossiers	17	17060000003558	17060000003558	61	PA721344	2020-12-23	False
17060000003621	L17/dossiers	17	17060000003558	17060000003558	62	PA718756	2020-12-23	False
17060000003622	L17/dossiers	17	17060000003558	17060000003558	63	PA719980	2020-12-23	False
17060000003623	L17/dossiers	17	17060000003558	17060000003558	64	PA642695	2020-12-23	False
17060000003624	L17/dossiers	17	17060000003558	17060000003558	65	PA267337	2020-12-23	False
17060000003625	L17/dossiers	17	17060000003558	17060000003558	66	PA606507	2020-12-23	False
17060000003626	L17/dossiers	17	17060000003558	17060000003558	67	PA719032	2020-12-23	False
17060000003627	L17/dossiers	17	17060000003558	17060000003558	68	PA718710	2020-12-23	False
17060000003628	L17/dossiers	17	17060000003558	17060000003558	69	PA721908	2020-12-23	False
17060000003629	L17/dossiers	17	17060000003558	17060000003558	70	PA672	2020-12-23	False
17060000003630	L17/dossiers	17	17060000003558	17060000003558	71	PA721328	2020-12-23	False
17060000003631	L17/dossiers	17	17060000003558	17060000003558	72	PA719890	2020-12-23	False
17060000003632	L17/dossiers	17	17060000003558	17060000003558	73	PA720116	2020-12-23	False
17060000003633	L17/dossiers	17	17060000003558	17060000003558	74	PA722000	2020-12-23	False
17060000003634	L17/dossiers	17	17060000003558	17060000003558	75	PA719496	2020-12-23	False
17060000003635	L17/dossiers	17	17060000003558	17060000003558	76	PA721750	2020-12-23	False
17060000003636	L17/dossiers	17	17060000003558	17060000003558	77	PA720520	2020-12-23	False
17060000003637	L17/dossiers	17	17060000003558	17060000003558	78	PA719922	2020-12-23	False
17060000003638	L17/dossiers	17	17060000003558	17060000003558	79	PA721352	2020-12-23	False
17060000003639	L17/dossiers	17	17060000003558	17060000003558	80	PA721166	2020-12-23	False
17060000003640	L17/dossiers	17	17060000003558	17060000003558	81	PA719472	2020-12-23	False
17060000003641	L17/dossiers	17	17060000003558	17060000003558	82	PA720814	2020-12-23	False
17060000003642	L17/dossiers	17	17060000003558	17060000003558	83	PA719440	2020-12-23	False
17060000003643	L17/dossiers	17	17060000003558	17060000003558	84	PA719748	2020-12-23	False