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
17060000077534	L17/dossiers	17	17060000077499	17060000077499	34	PA2371	2014-10-01	False
17060000077580	L17/dossiers	17	17060000077578	17060000077578	1	PA304002	2015-04-01	False
17060000077581	L17/dossiers	17	17060000077578	17060000077578	2	PA429864	2015-04-01	False
17060000077582	L17/dossiers	17	17060000077578	17060000077578	3	PA429897	2015-04-01	False
17060000077583	L17/dossiers	17	17060000077578	17060000077578	4	PA481	2015-04-01	False
17060000077584	L17/dossiers	17	17060000077578	17060000077578	5	PA415475	2015-04-01	False
17060000077585	L17/dossiers	17	17060000077578	17060000077578	6	PA429876	2015-04-01	False
17060000077586	L17/dossiers	17	17060000077578	17060000077578	7	PA215169	2015-04-01	False
17060000077587	L17/dossiers	17	17060000077578	17060000077578	8	PA415459	2015-04-01	False
17060000077588	L17/dossiers	17	17060000077578	17060000077578	9	PA429878	2015-04-01	False
17060000077589	L17/dossiers	17	17060000077578	17060000077578	10	PA944	2015-04-01	False
17060000077590	L17/dossiers	17	17060000077578	17060000077578	11	PA1048	2015-04-01	False
17060000077591	L17/dossiers	17	17060000077578	17060000077578	12	PA429882	2015-04-01	False
17060000077592	L17/dossiers	17	17060000077578	17060000077578	13	PA340419	2015-04-01	False
17060000077593	L17/dossiers	17	17060000077578	17060000077578	14	PA686138	2015-04-01	False
17060000077594	L17/dossiers	17	17060000077578	17060000077578	15	PA227030	2015-04-01	False
17060000077595	L17/dossiers	17	17060000077578	17060000077578	16	PA429850	2015-04-01	False
17060000077596	L17/dossiers	17	17060000077578	17060000077578	17	PA703508	2015-04-01	False
17060000077597	L17/dossiers	17	17060000077578	17060000077578	18	PA703509	2015-04-01	False
17060000077598	L17/dossiers	17	17060000077578	17060000077578	19	PA429865	2015-04-01	False
17060000077599	L17/dossiers	17	17060000077578	17060000077578	20	PA703533	2015-04-01	False
17060000077600	L17/dossiers	17	17060000077578	17060000077578	21	PA304090	2015-04-01	False
17060000077601	L17/dossiers	17	17060000077578	17060000077578	22	PA415453	2015-04-01	False
17060000077602	L17/dossiers	17	17060000077578	17060000077578	23	PA1998	2015-04-01	False
17060000077603	L17/dossiers	17	17060000077578	17060000077578	24	PA2023	2015-04-01	False
17060000077604	L17/dossiers	17	17060000077578	17060000077578	25	PA2056	2015-04-01	False
17060000077605	L17/dossiers	17	17060000077578	17060000077578	26	PA2074	2015-04-01	False
17060000077606	L17/dossiers	17	17060000077578	17060000077578	27	PA2111	2015-04-01	False
17060000077607	L17/dossiers	17	17060000077578	17060000077578	28	PA415484	2015-04-01	False
17060000077608	L17/dossiers	17	17060000077578	17060000077578	29	PA429844	2015-04-01	False
17060000077609	L17/dossiers	17	17060000077578	17060000077578	30	PA429868	2015-04-01	False
17060000077610	L17/dossiers	17	17060000077578	17060000077578	31	PA429840	2015-04-01	False
17060000077611	L17/dossiers	17	17060000077578	17060000077578	32	PA643211	2015-04-01	False
17060000077612	L17/dossiers	17	17060000077578	17060000077578	33	PA2272	2015-04-01	False
17060000077613	L17/dossiers	17	17060000077578	17060000077578	34	PA2371	2015-04-01	False
17060000077614	L17/dossiers	17	17060000077578	17060000077578	35	PA2435	2015-04-01	False
17060000077615	L17/dossiers	17	17060000077578	17060000077578	36	PA2528	2015-04-01	False
17060000077616	L17/dossiers	17	17060000077578	17060000077578	37	PA703495	2015-04-01	False
17060000077617	L17/dossiers	17	17060000077578	17060000077578	38	PA2774	2015-04-01	False
17060000077618	L17/dossiers	17	17060000077578	17060000077578	39	PA2776	2015-04-01	False
17060000077619	L17/dossiers	17	17060000077578	17060000077578	40	PA703481	2015-04-01	False
17060000077620	L17/dossiers	17	17060000077578	17060000077578	41	PA429838	2015-04-01	False
17060000077621	L17/dossiers	17	17060000077578	17060000077578	42	PA429852	2015-04-01	False
17060000077622	L17/dossiers	17	17060000077578	17060000077578	43	PA429861	2015-04-01	False
17060000077623	L17/dossiers	17	17060000077578	17060000077578	44	PA706520	2015-04-01	False
17060000077624	L17/dossiers	17	17060000077578	17060000077578	45	PA304113	2015-04-01	False
17060000077625	L17/dossiers	17	17060000077578	17060000077578	46		2015-04-01	False	PO77710	True
17060000077626	L17/dossiers	17	17060000077578	17060000077578	47	PA1978	2015-04-01	False
17060000077629	L17/dossiers	17	17060000077627	17060000077627	1	PA429854	2015-04-01	True
17060000077630	L17/dossiers	17	17060000077627	17060000077627	2	PA304010	2015-04-01	True