dossiers.document_co_signataire

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

309 756 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
16060000016433	L16/dossiers	16	16060000016391	16060000016391	41	PA720892	2023-01-17	False
16060000016434	L16/dossiers	16	16060000016391	16060000016391	42	PA795794	2023-01-17	False
16060000016435	L16/dossiers	16	16060000016391	16060000016391	43	PA793756	2023-01-17	False
16060000016436	L16/dossiers	16	16060000016391	16060000016391	44	PA793664	2023-01-17	False
16060000016437	L16/dossiers	16	16060000016391	16060000016391	45	PA796062	2023-01-17	False
16060000016438	L16/dossiers	16	16060000016391	16060000016391	46	PA721062	2023-01-17	False
16060000016439	L16/dossiers	16	16060000016391	16060000016391	47	PA795076	2023-01-17	False
16060000016440	L16/dossiers	16	16060000016391	16060000016391	48	PA795982	2023-01-17	False
16060000016441	L16/dossiers	16	16060000016391	16060000016391	49	PA793724	2023-01-17	False
16060000016442	L16/dossiers	16	16060000016391	16060000016391	50	PA610002	2023-01-17	False
16060000016443	L16/dossiers	16	16060000016391	16060000016391	51	PA795808	2023-01-17	False
16060000016444	L16/dossiers	16	16060000016391	16060000016391	52	PA720952	2023-01-17	False
16060000016445	L16/dossiers	16	16060000016391	16060000016391	53	PA718860	2023-01-17	False
16060000016446	L16/dossiers	16	16060000016391	16060000016391	54	PA794106	2023-01-17	False
16060000016447	L16/dossiers	16	16060000016391	16060000016391	55	PA794166	2023-01-17	False
16060000016448	L16/dossiers	16	16060000016391	16060000016391	56	PA795164	2023-01-17	False
16060000016449	L16/dossiers	16	16060000016391	16060000016391	57	PA795596	2023-01-17	False
16060000016450	L16/dossiers	16	16060000016391	16060000016391	58	PA793110	2023-01-17	False
16060000016454	L16/dossiers	16	16060000016452	16060000016452	1	PA719318	2023-01-17	False
16060000016455	L16/dossiers	16	16060000016452	16060000016452	2	PA718884	2023-01-17	False
16060000016456	L16/dossiers	16	16060000016452	16060000016452	3	PA721410	2023-01-17	False
16060000016457	L16/dossiers	16	16060000016452	16060000016452	4	PA266793	2023-01-17	False
16060000016458	L16/dossiers	16	16060000016452	16060000016452	5	PA721816	2023-01-17	False
16060000016459	L16/dossiers	16	16060000016452	16060000016452	6	PA342240	2023-01-17	False
16060000016460	L16/dossiers	16	16060000016452	16060000016452	7	PA330008	2023-01-17	False
16060000016461	L16/dossiers	16	16060000016452	16060000016452	8	PA793508	2023-01-17	False
16060000016462	L16/dossiers	16	16060000016452	16060000016452	9	PA718838	2023-01-17	False
16060000016463	L16/dossiers	16	16060000016452	16060000016452	10	PA722390	2023-01-17	False
16060000016464	L16/dossiers	16	16060000016452	16060000016452	11	PA332523	2023-01-17	False
16060000016465	L16/dossiers	16	16060000016452	16060000016452	12	PA1327	2023-01-17	False
16060000016466	L16/dossiers	16	16060000016452	16060000016452	13	PA267324	2023-01-17	False
16060000016467	L16/dossiers	16	16060000016452	16060000016452	14	PA608416	2023-01-17	False
16060000016468	L16/dossiers	16	16060000016452	16060000016452	15	PA1874	2023-01-17	False
16060000016469	L16/dossiers	16	16060000016452	16060000016452	16	PA608016	2023-01-17	False
16060000016470	L16/dossiers	16	16060000016452	16060000016452	17	PA793342	2023-01-17	False
16060000016471	L16/dossiers	16	16060000016452	16060000016452	18	PA719272	2023-01-17	False
16060000016472	L16/dossiers	16	16060000016452	16060000016452	19	PA720630	2023-01-17	False
16060000016473	L16/dossiers	16	16060000016452	16060000016452	20	PA794038	2023-01-17	False
16060000016474	L16/dossiers	16	16060000016452	16060000016452	21	PA718784	2023-01-17	False
16060000016475	L16/dossiers	16	16060000016452	16060000016452	22	PA795406	2023-01-17	False
16060000016476	L16/dossiers	16	16060000016452	16060000016452	23	PA721442	2023-01-17	False
16060000016477	L16/dossiers	16	16060000016452	16060000016452	24	PA794994	2023-01-17	False
16060000016478	L16/dossiers	16	16060000016452	16060000016452	25	PA793094	2023-01-17	False
16060000016479	L16/dossiers	16	16060000016452	16060000016452	26	PA266808	2023-01-17	False
16060000016480	L16/dossiers	16	16060000016452	16060000016452	27	PA794410	2023-01-17	False
16060000016481	L16/dossiers	16	16060000016452	16060000016452	28	PA722308	2023-01-17	False
16060000016482	L16/dossiers	16	16060000016452	16060000016452	29	PA643134	2023-01-17	False
16060000016483	L16/dossiers	16	16060000016452	16060000016452	30	PA720586	2023-01-17	False
16060000016484	L16/dossiers	16	16060000016452	16060000016452	31	PA721474	2023-01-17	False
16060000016485	L16/dossiers	16	16060000016452	16060000016452	32	PA793322	2023-02-27	False