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
16060000016489	L16/dossiers	16	16060000016487	16060000016487	1	PA712015	2023-01-17	True
16060000016490	L16/dossiers	16	16060000016487	16060000016487	2	PA719318	2023-01-17	False
16060000016491	L16/dossiers	16	16060000016487	16060000016487	3	PA718884	2023-01-17	False
16060000016492	L16/dossiers	16	16060000016487	16060000016487	4	PA721410	2023-01-17	False
16060000016493	L16/dossiers	16	16060000016487	16060000016487	5	PA793508	2023-01-17	False
16060000016494	L16/dossiers	16	16060000016487	16060000016487	6	PA718838	2023-01-17	False
16060000016495	L16/dossiers	16	16060000016487	16060000016487	7	PA332523	2023-01-17	False
16060000016496	L16/dossiers	16	16060000016487	16060000016487	8	PA330909	2023-01-17	False
16060000016497	L16/dossiers	16	16060000016487	16060000016487	9	PA793476	2023-01-17	False
16060000016498	L16/dossiers	16	16060000016487	16060000016487	10	PA608826	2023-01-17	False
16060000016499	L16/dossiers	16	16060000016487	16060000016487	11	PA1327	2023-01-17	False
16060000016500	L16/dossiers	16	16060000016487	16060000016487	12	PA1630	2023-01-17	False
16060000016501	L16/dossiers	16	16060000016487	16060000016487	13	PA608016	2023-01-17	False
16060000016502	L16/dossiers	16	16060000016487	16060000016487	14	PA720630	2023-01-17	False
16060000016503	L16/dossiers	16	16060000016487	16060000016487	15	PA718784	2023-01-17	False
16060000016504	L16/dossiers	16	16060000016487	16060000016487	16	PA795406	2023-01-17	False
16060000016505	L16/dossiers	16	16060000016487	16060000016487	17	PA721442	2023-01-17	False
16060000016506	L16/dossiers	16	16060000016487	16060000016487	18	PA793094	2023-01-17	False
16060000016507	L16/dossiers	16	16060000016487	16060000016487	19	PA721314	2023-01-17	False
16060000016508	L16/dossiers	16	16060000016487	16060000016487	20	PA794410	2023-01-17	False
16060000016509	L16/dossiers	16	16060000016487	16060000016487	21	PA794178	2023-01-17	False
16060000016510	L16/dossiers	16	16060000016487	16060000016487	22	PA643134	2023-01-17	False
16060000016511	L16/dossiers	16	16060000016487	16060000016487	23	PA720586	2023-01-17	False
16060000016512	L16/dossiers	16	16060000016487	16060000016487	24	PA794118	2023-01-17	False
16060000016513	L16/dossiers	16	16060000016487	16060000016487	25	PA607090	2023-01-17	False
16060000016517	L16/dossiers	16	16060000016515	16060000016515	1	PA794802	2023-01-17	False
16060000016518	L16/dossiers	16	16060000016515	16060000016515	2	PA794798	2023-01-17	False
16060000016519	L16/dossiers	16	16060000016515	16060000016515	3	PA722284	2023-01-17	False
16060000016520	L16/dossiers	16	16060000016515	16060000016515	4	PA794846	2023-01-17	False
16060000016521	L16/dossiers	16	16060000016515	16060000016515	5	PA643184	2023-01-17	False
16060000016522	L16/dossiers	16	16060000016515	16060000016515	6	PA794818	2023-01-17	False
16060000016523	L16/dossiers	16	16060000016515	16060000016515	7	PA794838	2023-01-17	False
16060000016524	L16/dossiers	16	16060000016515	16060000016515	8	PA720754	2023-01-17	False
16060000016525	L16/dossiers	16	16060000016515	16060000016515	9	PA722336	2023-01-17	False
16060000016538	L16/dossiers	16	16060000016536	16060000016536	1	PA794008	2023-01-17	True
16060000016539	L16/dossiers	16	16060000016536	16060000016536	2	PA793780	2023-01-17	False
16060000016540	L16/dossiers	16	16060000016536	16060000016536	3	PA795058	2023-01-17	False
16060000016541	L16/dossiers	16	16060000016536	16060000016536	4	PA795362	2023-01-17	False
16060000016542	L16/dossiers	16	16060000016536	16060000016536	5	PA793980	2023-01-17	False
16060000016543	L16/dossiers	16	16060000016536	16060000016536	6	PA795010	2023-01-17	False
16060000016544	L16/dossiers	16	16060000016536	16060000016536	7	PA722344	2023-01-17	False
16060000016545	L16/dossiers	16	16060000016536	16060000016536	8	PA795794	2023-01-17	False
16060000016546	L16/dossiers	16	16060000016536	16060000016536	9	PA793708	2023-01-17	False
16060000016547	L16/dossiers	16	16060000016536	16060000016536	10	PA793664	2023-01-17	False
16060000016548	L16/dossiers	16	16060000016536	16060000016536	11	PA794154	2023-01-17	False
16060000016549	L16/dossiers	16	16060000016536	16060000016536	12	PA794778	2023-01-17	False
16060000016550	L16/dossiers	16	16060000016536	16060000016536	13	PA795076	2023-01-17	False
16060000016551	L16/dossiers	16	16060000016536	16060000016536	14	PA610002	2023-01-17	False
16060000016552	L16/dossiers	16	16060000016536	16060000016536	15	PA795808	2023-01-17	False
16060000016553	L16/dossiers	16	16060000016536	16060000016536	16	PA720952	2023-01-17	False