dossiers.document_co_signataire

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

309 130 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	organe_organe_ref	organe_et_apparentes
17060000078537	L17/dossiers	17	17060000078438	17060000078438	98	PA736193	2018-04-30	False
17060000078538	L17/dossiers	17	17060000078438	17060000078438	99	PA2543	2018-04-30	False
17060000078539	L17/dossiers	17	17060000078438	17060000078438	100	PA736227	2018-04-30	False
17060000078540	L17/dossiers	17	17060000078438	17060000078438	101	PA429851	2018-04-30	False
17060000078541	L17/dossiers	17	17060000078438	17060000078438	102	PA429874	2018-04-30	False
17060000078542	L17/dossiers	17	17060000078438	17060000078438	103	PA301592	2018-04-30	False
17060000078543	L17/dossiers	17	17060000078438	17060000078438	104	PA227094	2018-04-30	False
17060000078544	L17/dossiers	17	17060000078438	17060000078438	105	PA736207	2018-04-30	False
17060000078545	L17/dossiers	17	17060000078438	17060000078438	106	PA303996	2018-04-30	False
17060000078546	L17/dossiers	17	17060000078438	17060000078438	107	PA2905	2018-04-30	False
17060000078547	L17/dossiers	17	17060000078438	17060000078438	108	PA703527	2018-04-30	False
17060000078552	L17/dossiers	17	17060000078550	17060000078550	1	PA703486	2018-09-26	False
17060000078553	L17/dossiers	17	17060000078550	17060000078550	2	PA267840	2018-09-26	False
17060000078554	L17/dossiers	17	17060000078550	17060000078550	3	PA429890	2018-09-26	False
17060000078555	L17/dossiers	17	17060000078550	17060000078550	4	PA736190	2018-09-26	False
17060000078556	L17/dossiers	17	17060000078550	17060000078550	5	PA703531	2018-09-26	False
17060000078557	L17/dossiers	17	17060000078550	17060000078550	6	PA905	2018-09-26	False
17060000078558	L17/dossiers	17	17060000078550	17060000078550	7	PA268007	2018-09-26	False
17060000078559	L17/dossiers	17	17060000078550	17060000078550	8	PA732420	2018-09-26	False
17060000078560	L17/dossiers	17	17060000078550	17060000078550	9	PA429845	2018-09-26	False
17060000078561	L17/dossiers	17	17060000078550	17060000078550	10	PA736235	2018-09-26	False
17060000078562	L17/dossiers	17	17060000078550	17060000078550	11	PA703487	2018-09-26	False
17060000078563	L17/dossiers	17	17060000078550	17060000078550	12	PA1573	2018-09-26	False
17060000078564	L17/dossiers	17	17060000078550	17060000078550	13	PA415452	2018-09-26	False
17060000078565	L17/dossiers	17	17060000078550	17060000078550	14	PA736168	2018-09-26	False
17060000078566	L17/dossiers	17	17060000078550	17060000078550	15	PA703529	2018-09-26	False
17060000078567	L17/dossiers	17	17060000078550	17060000078550	16	PA429866	2018-09-26	False
17060000078568	L17/dossiers	17	17060000078550	17060000078550	17	PA415464	2018-09-26	False
17060000078569	L17/dossiers	17	17060000078550	17060000078550	18	PA736224	2018-09-26	False
17060000078570	L17/dossiers	17	17060000078550	17060000078550	19	PA429895	2018-09-26	False
17060000078571	L17/dossiers	17	17060000078550	17060000078550	20	PA703495	2018-09-26	False
17060000078572	L17/dossiers	17	17060000078550	17060000078550	21	PA415480	2018-09-26	False
17060000078696	L17/dossiers	17	17060000078694	17060000078694	1		2018-10-09	False	PO732421	False
17060000078701	L17/dossiers	17	17060000078699	17060000078699	1	PA703522	2018-10-17	False
17060000078702	L17/dossiers	17	17060000078699	17060000078699	2	PA736216	2018-10-17	False
17060000078703	L17/dossiers	17	17060000078699	17060000078699	3	PA303997	2018-10-17	False
17060000078704	L17/dossiers	17	17060000078699	17060000078699	4	PA1037	2018-10-17	False
17060000078705	L17/dossiers	17	17060000078699	17060000078699	5	PA736160	2018-10-17	False
17060000078706	L17/dossiers	17	17060000078699	17060000078699	6	PA703539	2018-10-17	False
17060000078707	L17/dossiers	17	17060000078699	17060000078699	7	PA404656	2018-10-17	False
17060000078708	L17/dossiers	17	17060000078699	17060000078699	8	PA304108	2018-10-17	False
17060000078709	L17/dossiers	17	17060000078699	17060000078699	9	PA267081	2018-10-17	False
17060000078710	L17/dossiers	17	17060000078699	17060000078699	10	PA415447	2018-10-17	False
17060000078711	L17/dossiers	17	17060000078699	17060000078699	11	PA736186	2018-10-17	False
17060000078712	L17/dossiers	17	17060000078699	17060000078699	12	PA343775	2018-10-17	False
17060000078713	L17/dossiers	17	17060000078699	17060000078699	13	PA1993	2018-10-17	False
17060000078714	L17/dossiers	17	17060000078699	17060000078699	14	PA703497	2018-10-17	False
17060000078715	L17/dossiers	17	17060000078699	17060000078699	15	PA703541	2018-10-17	False
17060000078716	L17/dossiers	17	17060000078699	17060000078699	16	PA758431	2018-10-17	False
17060000078717	L17/dossiers	17	17060000078699	17060000078699	17	PA2543	2018-10-17	False