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
16060000016619	L16/dossiers	16	16060000016612	16060000016612	6	PA330240	2023-01-17	False
16060000016620	L16/dossiers	16	16060000016612	16060000016612	7	PA722390	2023-01-17	False
16060000016621	L16/dossiers	16	16060000016612	16060000016612	8	PA793322	2023-01-17	False
16060000016622	L16/dossiers	16	16060000016612	16060000016612	9	PA332523	2023-01-17	False
16060000016623	L16/dossiers	16	16060000016612	16060000016612	10	PA330909	2023-01-17	False
16060000016624	L16/dossiers	16	16060000016612	16060000016612	11	PA712015	2023-01-17	False
16060000016625	L16/dossiers	16	16060000016612	16060000016612	12	PA793476	2023-01-17	False
16060000016626	L16/dossiers	16	16060000016612	16060000016612	13	PA1327	2023-01-17	False
16060000016627	L16/dossiers	16	16060000016612	16060000016612	14	PA267324	2023-01-17	False
16060000016628	L16/dossiers	16	16060000016612	16060000016612	15	PA794058	2023-01-17	False
16060000016629	L16/dossiers	16	16060000016612	16060000016612	16	PA783457	2023-01-17	False
16060000016630	L16/dossiers	16	16060000016612	16060000016612	17	PA1630	2023-01-17	False
16060000016631	L16/dossiers	16	16060000016612	16060000016612	18	PA608416	2023-01-17	False
16060000016632	L16/dossiers	16	16060000016612	16060000016612	19	PA346782	2023-01-17	False
16060000016633	L16/dossiers	16	16060000016612	16060000016612	20	PA267901	2023-01-17	False
16060000016634	L16/dossiers	16	16060000016612	16060000016612	21	PA1874	2023-01-17	False
16060000016635	L16/dossiers	16	16060000016612	16060000016612	22	PA608016	2023-01-17	False
16060000016636	L16/dossiers	16	16060000016612	16060000016612	23	PA346054	2023-01-17	False
16060000016637	L16/dossiers	16	16060000016612	16060000016612	24	PA794038	2023-01-17	False
16060000016638	L16/dossiers	16	16060000016612	16060000016612	25	PA718784	2023-01-17	False
16060000016639	L16/dossiers	16	16060000016612	16060000016612	26	PA794994	2023-01-17	False
16060000016640	L16/dossiers	16	16060000016612	16060000016612	27	PA793094	2023-01-17	False
16060000016641	L16/dossiers	16	16060000016612	16060000016612	28	PA266808	2023-01-17	False
16060000016642	L16/dossiers	16	16060000016612	16060000016612	29	PA794410	2023-01-17	False
16060000016643	L16/dossiers	16	16060000016612	16060000016612	30	PA794178	2023-01-17	False
16060000016644	L16/dossiers	16	16060000016612	16060000016612	31	PA643134	2023-01-17	False
16060000016645	L16/dossiers	16	16060000016612	16060000016612	32	PA720586	2023-01-17	False
16060000016646	L16/dossiers	16	16060000016612	16060000016612	33	PA721474	2023-01-17	False
16060000016650	L16/dossiers	16	16060000016648	16060000016648	1	PA719318	2023-01-17	False
16060000016651	L16/dossiers	16	16060000016648	16060000016648	2	PA718884	2023-01-17	False
16060000016652	L16/dossiers	16	16060000016648	16060000016648	3	PA721410	2023-01-17	False
16060000016653	L16/dossiers	16	16060000016648	16060000016648	4	PA330909	2023-01-17	False
16060000016654	L16/dossiers	16	16060000016648	16060000016648	5	PA712015	2023-01-17	False
16060000016655	L16/dossiers	16	16060000016648	16060000016648	6	PA793476	2023-01-17	False
16060000016656	L16/dossiers	16	16060000016648	16060000016648	7	PA608826	2023-01-17	False
16060000016657	L16/dossiers	16	16060000016648	16060000016648	8	PA1327	2023-01-17	False
16060000016658	L16/dossiers	16	16060000016648	16060000016648	9	PA267324	2023-01-17	False
16060000016659	L16/dossiers	16	16060000016648	16060000016648	10	PA605991	2023-01-17	False
16060000016660	L16/dossiers	16	16060000016648	16060000016648	11	PA794038	2023-01-17	False
16060000016661	L16/dossiers	16	16060000016648	16060000016648	12	PA718784	2023-01-17	False
16060000016662	L16/dossiers	16	16060000016648	16060000016648	13	PA794410	2023-01-17	False
16060000016663	L16/dossiers	16	16060000016648	16060000016648	14	PA722308	2023-01-17	False
16060000016664	L16/dossiers	16	16060000016648	16060000016648	15	PA794118	2023-01-17	False
16060000016665	L16/dossiers	16	16060000016648	16060000016648	16	PA607090	2023-01-17	False
16060000016666	L16/dossiers	16	16060000016648	16060000016648	17	PA721474	2023-01-17	False
16060000016694	L16/dossiers	16	16060000016692	16060000016692	1	PA795266	2023-01-17	False
16060000016695	L16/dossiers	16	16060000016692	16060000016692	2	PA793572	2023-01-17	False
16060000016696	L16/dossiers	16	16060000016692	16060000016692	3	PA793194	2023-01-17	False
16060000016697	L16/dossiers	16	16060000016692	16060000016692	4	PA794206	2023-01-17	False
16060000016698	L16/dossiers	16	16060000016692	16060000016692	5	PA721984	2023-01-17	False