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
16060000007996	L16/dossiers	16	16060000007987	16060000007987	8	PA719664	2022-10-11	False
16060000007997	L16/dossiers	16	16060000007987	16060000007987	9	PA721486	2022-10-11	False
16060000007998	L16/dossiers	16	16060000007987	16060000007987	10	PA719266	2023-01-27	False
16060000007999	L16/dossiers	16	16060000007987	16060000007987	11	PA793792	2023-01-27	False
16060000008000	L16/dossiers	16	16060000007987	16060000007987	12	PA794830	2023-05-11	False
16060000008004	L16/dossiers	16	16060000008002	16060000008002	1	PA720386	2022-10-11	False
16060000008005	L16/dossiers	16	16060000008002	16060000008002	2	PA267429	2022-10-11	False
16060000008006	L16/dossiers	16	16060000008002	16060000008002	3	PA1630	2022-10-11	False
16060000008007	L16/dossiers	16	16060000008002	16060000008002	4	PA1874	2022-10-11	False
16060000008008	L16/dossiers	16	16060000008002	16060000008002	5	PA718838	2022-10-11	False
16060000008009	L16/dossiers	16	16060000008002	16060000008002	6	PA719318	2022-10-11	False
16060000008010	L16/dossiers	16	16060000008002	16060000008002	7	PA266793	2022-10-11	False
16060000008011	L16/dossiers	16	16060000008002	16060000008002	8	PA718884	2022-10-11	False
16060000008012	L16/dossiers	16	16060000008002	16060000008002	9	PA721410	2022-10-11	False
16060000008013	L16/dossiers	16	16060000008002	16060000008002	10	PA643134	2022-10-11	False
16060000008014	L16/dossiers	16	16060000008002	16060000008002	11	PA793508	2022-10-11	False
16060000008015	L16/dossiers	16	16060000008002	16060000008002	12	PA722390	2022-10-11	False
16060000008016	L16/dossiers	16	16060000008002	16060000008002	13	PA722308	2022-10-11	False
16060000008017	L16/dossiers	16	16060000008002	16060000008002	14	PA794994	2022-10-11	False
16060000008018	L16/dossiers	16	16060000008002	16060000008002	15	PA794038	2022-10-11	False
16060000008019	L16/dossiers	16	16060000008002	16060000008002	16	PA720586	2022-10-11	False
16060000008020	L16/dossiers	16	16060000008002	16060000008002	17	PA721816	2022-10-11	False
16060000008021	L16/dossiers	16	16060000008002	16060000008002	18	PA718784	2022-10-11	False
16060000008022	L16/dossiers	16	16060000008002	16060000008002	19	PA793476	2022-10-11	False
16060000008023	L16/dossiers	16	16060000008002	16060000008002	20	PA330008	2022-10-11	False
16060000008024	L16/dossiers	16	16060000008002	16060000008002	21	PA721474	2022-10-11	False
16060000008025	L16/dossiers	16	16060000008002	16060000008002	22	PA267794	2022-10-11	False
16060000008026	L16/dossiers	16	16060000008002	16060000008002	23	PA1327	2022-10-11	False
16060000008027	L16/dossiers	16	16060000008002	16060000008002	24	PA642847	2022-10-11	False
16060000008028	L16/dossiers	16	16060000008002	16060000008002	25	PA330909	2022-10-11	False
16060000008029	L16/dossiers	16	16060000008002	16060000008002	26	PA330240	2022-11-18	False
16060000008030	L16/dossiers	16	16060000008002	16060000008002	27	PA793322	2022-11-18	False
16060000008037	L16/dossiers	16	16060000008035	16060000008035	1	PA794130	2022-10-11	False
16060000008038	L16/dossiers	16	16060000008035	16060000008035	2	PA793262	2022-10-11	False
16060000008039	L16/dossiers	16	16060000008035	16060000008035	3	PA794106	2022-10-11	False
16060000008040	L16/dossiers	16	16060000008035	16060000008035	4	PA795136	2022-10-11	False
16060000008041	L16/dossiers	16	16060000008035	16060000008035	5	PA795318	2022-10-11	False
16060000008042	L16/dossiers	16	16060000008035	16060000008035	6	PA720422	2022-10-11	False
16060000008043	L16/dossiers	16	16060000008035	16060000008035	7	PA796070	2022-10-11	False
16060000008044	L16/dossiers	16	16060000008035	16060000008035	8	PA795108	2022-10-11	False
16060000008045	L16/dossiers	16	16060000008035	16060000008035	9	PA795672	2022-10-11	False
16060000008046	L16/dossiers	16	16060000008035	16060000008035	10	PA588884	2022-10-11	False
16060000008047	L16/dossiers	16	16060000008035	16060000008035	11	PA793736	2022-10-11	False
16060000008048	L16/dossiers	16	16060000008035	16060000008035	12	PA795466	2022-10-11	False
16060000008049	L16/dossiers	16	16060000008035	16060000008035	13	PA795982	2022-10-11	False
16060000008050	L16/dossiers	16	16060000008035	16060000008035	14	PA794082	2022-10-11	False
16060000008051	L16/dossiers	16	16060000008035	16060000008035	15	PA794166	2022-10-11	False
16060000008052	L16/dossiers	16	16060000008035	16060000008035	16	PA720286	2022-10-11	False
16060000008053	L16/dossiers	16	16060000008035	16060000008035	17	PA793444	2022-10-11	False
16060000008054	L16/dossiers	16	16060000008035	16060000008035	18	PA791824	2022-10-11	False