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
17060000077999	L17/dossiers	17	17060000077957	17060000077957	41	PA703520	2017-01-11	False
17060000078000	L17/dossiers	17	17060000077957	17060000077957	42	PA1344	2017-01-11	False
17060000078001	L17/dossiers	17	17060000077957	17060000077957	43	PA415492	2017-01-11	False
17060000078002	L17/dossiers	17	17060000077957	17060000077957	44	PA703487	2017-01-11	False
17060000078003	L17/dossiers	17	17060000077957	17060000077957	45	PA266795	2017-01-11	False
17060000078004	L17/dossiers	17	17060000077957	17060000077957	46	PA1435	2017-01-11	False
17060000078005	L17/dossiers	17	17060000077957	17060000077957	47	PA703507	2017-01-11	False
17060000078006	L17/dossiers	17	17060000077957	17060000077957	48	PA415473	2017-01-11	False
17060000078007	L17/dossiers	17	17060000077957	17060000077957	49	PA227076	2017-01-11	False
17060000078008	L17/dossiers	17	17060000077957	17060000077957	50	PA1527	2017-01-11	False
17060000078009	L17/dossiers	17	17060000077957	17060000077957	51	PA267907	2017-01-11	False
17060000078010	L17/dossiers	17	17060000077957	17060000077957	52	PA1562	2017-01-11	False
17060000078011	L17/dossiers	17	17060000077957	17060000077957	53	PA331381	2017-01-11	False
17060000078012	L17/dossiers	17	17060000077957	17060000077957	54	PA227078	2017-01-11	False
17060000078013	L17/dossiers	17	17060000077957	17060000077957	55	PA429887	2017-01-11	False
17060000078014	L17/dossiers	17	17060000077957	17060000077957	56	PA703492	2017-01-11	False
17060000078015	L17/dossiers	17	17060000077957	17060000077957	57	PA415495	2017-01-11	False
17060000078016	L17/dossiers	17	17060000077957	17060000077957	58	PA304737	2017-01-11	False
17060000078017	L17/dossiers	17	17060000077957	17060000077957	59	PA415476	2017-01-11	False
17060000078018	L17/dossiers	17	17060000077957	17060000077957	60	PA429879	2017-01-11	False
17060000078019	L17/dossiers	17	17060000077957	17060000077957	61	PA1744	2017-01-11	False
17060000078020	L17/dossiers	17	17060000077957	17060000077957	62	PA205280	2017-01-11	False
17060000078021	L17/dossiers	17	17060000077957	17060000077957	63	PA303992	2017-01-11	False
17060000078022	L17/dossiers	17	17060000077957	17060000077957	64	PA703488	2017-01-11	False
17060000078023	L17/dossiers	17	17060000077957	17060000077957	65	PA394676	2017-01-11	False
17060000078024	L17/dossiers	17	17060000077957	17060000077957	66	PA304000	2017-01-11	False
17060000078025	L17/dossiers	17	17060000077957	17060000077957	67	PA922	2017-01-11	False
17060000078026	L17/dossiers	17	17060000077957	17060000077957	68	PA716367	2017-01-11	False
17060000078027	L17/dossiers	17	17060000077957	17060000077957	69	PA703530	2017-01-11	False
17060000078028	L17/dossiers	17	17060000077957	17060000077957	70	PA267081	2017-01-11	False
17060000078029	L17/dossiers	17	17060000077957	17060000077957	71	PA429875	2017-01-11	False
17060000078030	L17/dossiers	17	17060000077957	17060000077957	72	PA415451	2017-01-11	False
17060000078031	L17/dossiers	17	17060000077957	17060000077957	73	PA415447	2017-01-11	False
17060000078032	L17/dossiers	17	17060000077957	17060000077957	74	PA1919	2017-01-11	False
17060000078033	L17/dossiers	17	17060000077957	17060000077957	75	PA415467	2017-01-11	False
17060000078034	L17/dossiers	17	17060000077957	17060000077957	76	PA267795	2017-01-11	False
17060000078035	L17/dossiers	17	17060000077957	17060000077957	77	PA703535	2017-01-11	False
17060000078036	L17/dossiers	17	17060000077957	17060000077957	78	PA1942	2017-01-11	False
17060000078037	L17/dossiers	17	17060000077957	17060000077957	79	PA703523	2017-01-11	False
17060000078038	L17/dossiers	17	17060000077957	17060000077957	80	PA341381	2017-01-11	False
17060000078039	L17/dossiers	17	17060000077957	17060000077957	81	PA1993	2017-01-11	False
17060000078040	L17/dossiers	17	17060000077957	17060000077957	82	PA703537	2017-01-11	False
17060000078041	L17/dossiers	17	17060000077957	17060000077957	83	PA703516	2017-01-11	False
17060000078042	L17/dossiers	17	17060000077957	17060000077957	84	PA415455	2017-01-11	False
17060000078043	L17/dossiers	17	17060000077957	17060000077957	85	PA703497	2017-01-11	False
17060000078044	L17/dossiers	17	17060000077957	17060000077957	86	PA267512	2017-01-11	False
17060000078045	L17/dossiers	17	17060000077957	17060000077957	87	PA429832	2017-01-11	False
17060000078046	L17/dossiers	17	17060000077957	17060000077957	88	PA707346	2017-01-11	False
17060000078047	L17/dossiers	17	17060000077957	17060000077957	89	PA415489	2017-01-11	False
17060000078048	L17/dossiers	17	17060000077957	17060000077957	90	PA703480	2017-01-11	False