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
16060000016699	L16/dossiers	16	16060000016692	16060000016692	6	PA720230	2023-01-17	False
16060000016700	L16/dossiers	16	16060000016692	16060000016692	7	PA607395	2023-01-17	False
16060000016701	L16/dossiers	16	16060000016692	16060000016692	8	PA719528	2023-01-17	False
16060000016702	L16/dossiers	16	16060000016692	16060000016692	9	PA722102	2023-01-17	False
16060000016703	L16/dossiers	16	16060000016692	16060000016692	10	PA794830	2023-01-17	False
16060000016704	L16/dossiers	16	16060000016692	16060000016692	11	PA794846	2023-01-17	False
16060000016705	L16/dossiers	16	16060000016692	16060000016692	12	PA794838	2023-01-17	False
16060000016706	L16/dossiers	16	16060000016692	16060000016692	13	PA720932	2023-01-17	False
16060000016707	L16/dossiers	16	16060000016692	16060000016692	14	PA795026	2023-01-17	False
16060000016708	L16/dossiers	16	16060000016692	16060000016692	15	PA719382	2023-01-17	False
16060000016709	L16/dossiers	16	16060000016692	16060000016692	16	PA794470	2023-01-17	False
16060000016710	L16/dossiers	16	16060000016692	16060000016692	17	PA719672	2023-01-17	False
16060000016711	L16/dossiers	16	16060000016692	16060000016692	18	PA720222	2023-01-17	False
16060000016712	L16/dossiers	16	16060000016692	16060000016692	19	PA793306	2023-01-17	False
16060000016713	L16/dossiers	16	16060000016692	16060000016692	20	PA722336	2023-01-17	False
16060000016714	L16/dossiers	16	16060000016692	16060000016692	21	PA795350	2023-01-17	False
16060000016718	L16/dossiers	16	16060000016716	16060000016716	1	PA721170	2023-01-17	False
16060000016719	L16/dossiers	16	16060000016716	16060000016716	2	PA794486	2023-01-17	False
16060000016720	L16/dossiers	16	16060000016716	16060000016716	3	PA605963	2023-01-17	False
16060000016721	L16/dossiers	16	16060000016716	16060000016716	4	PA721466	2023-01-17	False
16060000016725	L16/dossiers	16	16060000016723	16060000016723	1	PA796118	2023-01-17	False
16060000016726	L16/dossiers	16	16060000016723	16060000016723	2	PA794562	2023-01-17	False
16060000016727	L16/dossiers	16	16060000016723	16060000016723	3	PA793238	2023-01-17	False
16060000016728	L16/dossiers	16	16060000016723	16060000016723	4	PA793374	2023-01-17	False
16060000016729	L16/dossiers	16	16060000016723	16060000016723	5	PA793158	2023-01-17	False
16060000016730	L16/dossiers	16	16060000016723	16060000016723	6	PA794434	2023-01-17	False
16060000016731	L16/dossiers	16	16060000016723	16060000016723	7	PA794522	2023-01-17	False
16060000016732	L16/dossiers	16	16060000016723	16060000016723	8	PA309643	2023-01-17	False
16060000016733	L16/dossiers	16	16060000016723	16060000016723	9	PA720822	2023-01-17	False
16060000016734	L16/dossiers	16	16060000016723	16060000016723	10	PA794886	2023-01-17	False
16060000016735	L16/dossiers	16	16060000016723	16060000016723	11	PA796042	2023-01-17	False
16060000016736	L16/dossiers	16	16060000016723	16060000016723	12	PA793844	2023-01-17	False
16060000016737	L16/dossiers	16	16060000016723	16060000016723	13	PA795836	2023-01-17	False
16060000016738	L16/dossiers	16	16060000016723	16060000016723	14	PA794638	2023-01-17	False
16060000016739	L16/dossiers	16	16060000016723	16060000016723	15	PA720468	2023-01-17	False
16060000016740	L16/dossiers	16	16060000016723	16060000016723	16	PA794198	2023-01-17	False
16060000016741	L16/dossiers	16	16060000016723	16060000016723	17	PA793548	2023-01-17	False
16060000016742	L16/dossiers	16	16060000016723	16060000016723	18	PA795644	2023-01-17	False
16060000016743	L16/dossiers	16	16060000016723	16060000016723	19	PA1206	2023-01-17	False
16060000016744	L16/dossiers	16	16060000016723	16060000016723	20	PA793964	2023-01-17	False
16060000016745	L16/dossiers	16	16060000016723	16060000016723	21	PA794538	2023-01-17	False
16060000016746	L16/dossiers	16	16060000016723	16060000016723	22	PA793892	2023-01-17	False
16060000016747	L16/dossiers	16	16060000016723	16060000016723	23	PA796034	2023-01-17	False
16060000016748	L16/dossiers	16	16060000016723	16060000016723	24	PA793832	2023-01-17	False
16060000016749	L16/dossiers	16	16060000016723	16060000016723	25	PA793362	2023-01-17	False
16060000016750	L16/dossiers	16	16060000016723	16060000016723	26	PA794734	2023-01-17	False
16060000016751	L16/dossiers	16	16060000016723	16060000016723	27	PA793218	2023-01-17	False
16060000016752	L16/dossiers	16	16060000016723	16060000016723	28	PA795900	2023-01-17	False
16060000016753	L16/dossiers	16	16060000016723	16060000016723	29	PA793632	2023-01-17	False
16060000016754	L16/dossiers	16	16060000016723	16060000016723	30	PA794598	2023-01-17	False