dossiers.document_co_signataire

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

309 313 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
16060000001573	L16/dossiers	16	16060000001569	16060000001569	3	PA801862	2022-09-26	True
16060000001618	L16/dossiers	16	16060000001616	16060000001616	1	PA331481	2023-09-27	True
16060000001619	L16/dossiers	16	16060000001616	16060000001616	2	PA793940	2023-09-27	True
16060000001630	L16/dossiers	16	16060000001628	16060000001628	1	PA331481	2023-09-27	True
16060000001631	L16/dossiers	16	16060000001628	16060000001628	2	PA793940	2023-09-27	True
16060000001642	L16/dossiers	16	16060000001640	16060000001640	1	PA331481	2023-09-27	True
16060000001643	L16/dossiers	16	16060000001640	16060000001640	2	PA793940	2023-09-27	True
16060000001654	L16/dossiers	16	16060000001652	16060000001652	1	PA331481	2023-09-27	True
16060000001655	L16/dossiers	16	16060000001652	16060000001652	2	PA826635	2023-09-27	True
16060000001656	L16/dossiers	16	16060000001652	16060000001652	3	PA793940	2023-09-27	True
16060000001661	L16/dossiers	16	16060000001659	16060000001659	1	PA331481	2023-09-27	True
16060000001662	L16/dossiers	16	16060000001659	16060000001659	2	PA826635	2023-09-27	True
16060000001663	L16/dossiers	16	16060000001659	16060000001659	3	PA793940	2023-09-27	True
16060000001668	L16/dossiers	16	16060000001666	16060000001666	1	PA331481	2023-09-27	True
16060000001669	L16/dossiers	16	16060000001666	16060000001666	2	PA826635	2023-09-27	True
16060000001670	L16/dossiers	16	16060000001666	16060000001666	3	PA793940	2023-09-27	True
16060000001696	L16/dossiers	16	16060000001694	16060000001694	1	PA305	1999-12-23	False
16060000001697	L16/dossiers	16	16060000001694	16060000001694	2	PA885	1999-12-23	False
16060000001698	L16/dossiers	16	16060000001694	16060000001694	3	PA1616	1999-12-23	False
16060000001699	L16/dossiers	16	16060000001694	16060000001694	4	PA2045	1999-12-23	False
16060000001700	L16/dossiers	16	16060000001694	16060000001694	5	PA2062	1999-12-23	False
16060000001785	L16/dossiers	16	16060000001783	16060000001783	1	PA267469	2010-05-03	True
16060000001786	L16/dossiers	16	16060000001783	16060000001783	2	PA2438	2010-05-03	False
16060000001787	L16/dossiers	16	16060000001783	16060000001783	3	PA331567	2010-05-03	False
16060000001788	L16/dossiers	16	16060000001783	16060000001783	4	PA267087	2010-05-03	False
16060000001789	L16/dossiers	16	16060000001783	16060000001783	5	PA243	2010-05-05	False
16060000001790	L16/dossiers	16	16060000001783	16060000001783	6	PA253	2010-05-05	False
16060000001791	L16/dossiers	16	16060000001783	16060000001783	7	PA265	2010-05-05	False
16060000001792	L16/dossiers	16	16060000001783	16060000001783	8	PA312	2010-05-05	False
16060000001793	L16/dossiers	16	16060000001783	16060000001783	9	PA267140	2010-05-05	False
16060000001794	L16/dossiers	16	16060000001783	16060000001783	10	PA332886	2010-05-05	False
16060000001795	L16/dossiers	16	16060000001783	16060000001783	11	PA267641	2010-05-05	False
16060000001796	L16/dossiers	16	16060000001783	16060000001783	12	PA951	2010-05-05	False
16060000001797	L16/dossiers	16	16060000001783	16060000001783	13	PA267762	2010-05-05	False
16060000001798	L16/dossiers	16	16060000001783	16060000001783	14	PA334149	2010-05-05	False
16060000001799	L16/dossiers	16	16060000001783	16060000001783	15	PA1432	2010-05-05	False
16060000001800	L16/dossiers	16	16060000001783	16060000001783	16	PA1459	2010-05-05	False
16060000001801	L16/dossiers	16	16060000001783	16060000001783	17	PA267907	2010-05-05	False
16060000001802	L16/dossiers	16	16060000001783	16060000001783	18	PA1568	2010-05-05	False
16060000001803	L16/dossiers	16	16060000001783	16060000001783	19	PA1604	2010-05-05	False
16060000001804	L16/dossiers	16	16060000001783	16060000001783	20	PA267355	2010-05-05	False
16060000001805	L16/dossiers	16	16060000001783	16060000001783	21	PA1835	2010-05-05	False
16060000001806	L16/dossiers	16	16060000001783	16060000001783	22	PA266815	2010-05-05	False
16060000001807	L16/dossiers	16	16060000001783	16060000001783	23	PA267031	2010-05-05	False
16060000001808	L16/dossiers	16	16060000001783	16060000001783	24	PA1942	2010-05-05	False
16060000001809	L16/dossiers	16	16060000001783	16060000001783	25	PA1994	2010-05-05	False
16060000001810	L16/dossiers	16	16060000001783	16060000001783	26	PA2098	2010-05-05	False
16060000001811	L16/dossiers	16	16060000001783	16060000001783	27	PA2237	2010-05-05	False
16060000001812	L16/dossiers	16	16060000001783	16060000001783	28	PA267144	2010-05-05	False
16060000001813	L16/dossiers	16	16060000001783	16060000001783	29	PA267598	2010-05-05	False