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
17060000077945	L17/dossiers	17	17060000077861	17060000077861	83	PA2543	2016-11-15	False
17060000077946	L17/dossiers	17	17060000077861	17060000077861	84	PA429851	2016-11-15	False
17060000077947	L17/dossiers	17	17060000077861	17060000077861	85	PA429874	2016-11-15	False
17060000077948	L17/dossiers	17	17060000077861	17060000077861	86	PA429856	2016-11-15	False
17060000077949	L17/dossiers	17	17060000077861	17060000077861	87	PA227097	2016-11-15	False
17060000077950	L17/dossiers	17	17060000077861	17060000077861	88	PA303996	2016-11-15	False
17060000077951	L17/dossiers	17	17060000077861	17060000077861	89	PA703482	2016-11-15	False
17060000077952	L17/dossiers	17	17060000077861	17060000077861	90	PA2879	2016-11-15	False
17060000077953	L17/dossiers	17	17060000077861	17060000077861	91	PA2905	2016-11-15	False
17060000077954	L17/dossiers	17	17060000077861	17060000077861	92	PA703527	2016-11-15	False
17060000077959	L17/dossiers	17	17060000077957	17060000077957	1	PA429858	2017-01-11	True
17060000077960	L17/dossiers	17	17060000077957	17060000077957	2	PA267340	2017-01-11	True
17060000077961	L17/dossiers	17	17060000077957	17060000077957	3	PA227099	2017-01-11	True
17060000077962	L17/dossiers	17	17060000077957	17060000077957	4	PA703532	2017-01-11	False
17060000077963	L17/dossiers	17	17060000077957	17060000077957	5	PA429864	2017-01-11	False
17060000077964	L17/dossiers	17	17060000077957	17060000077957	6	PA227108	2017-01-11	False
17060000077965	L17/dossiers	17	17060000077957	17060000077957	7	PA528	2017-01-11	False
17060000077966	L17/dossiers	17	17060000077957	17060000077957	8	PA703522	2017-01-11	False
17060000077967	L17/dossiers	17	17060000077957	17060000077957	9	PA303997	2017-01-11	False
17060000077968	L17/dossiers	17	17060000077957	17060000077957	10	PA716	2017-01-11	False
17060000077969	L17/dossiers	17	17060000077957	17060000077957	11	PA304085	2017-01-11	False
17060000077970	L17/dossiers	17	17060000077957	17060000077957	12	PA703510	2017-01-11	False
17060000077971	L17/dossiers	17	17060000077957	17060000077957	13	PA725	2017-01-11	False
17060000077972	L17/dossiers	17	17060000077957	17060000077957	14	PA429884	2017-01-11	False
17060000077973	L17/dossiers	17	17060000077957	17060000077957	15	PA429870	2017-01-11	False
17060000077974	L17/dossiers	17	17060000077957	17060000077957	16	PA737	2017-01-11	False
17060000077975	L17/dossiers	17	17060000077957	17060000077957	17	PA429862	2017-01-11	False
17060000077976	L17/dossiers	17	17060000077957	17060000077957	18	PA791	2017-01-11	False
17060000077977	L17/dossiers	17	17060000077957	17060000077957	19	PA709750	2017-01-11	False
17060000077978	L17/dossiers	17	17060000077957	17060000077957	20	PA706108	2017-01-11	False
17060000077979	L17/dossiers	17	17060000077957	17060000077957	21	PA703513	2017-01-11	False
17060000077980	L17/dossiers	17	17060000077957	17060000077957	22	PA429854	2017-01-11	False
17060000077981	L17/dossiers	17	17060000077957	17060000077957	23	PA703534	2017-01-11	False
17060000077982	L17/dossiers	17	17060000077957	17060000077957	24	PA415462	2017-01-11	False
17060000077983	L17/dossiers	17	17060000077957	17060000077957	25	PA715745	2017-01-11	False
17060000077984	L17/dossiers	17	17060000077957	17060000077957	26	PA703483	2017-01-11	False
17060000077985	L17/dossiers	17	17060000077957	17060000077957	27	PA1019	2017-01-11	False
17060000077986	L17/dossiers	17	17060000077957	17060000077957	28	PA429869	2017-01-11	False
17060000077987	L17/dossiers	17	17060000077957	17060000077957	29	PA1046	2017-01-11	False
17060000077988	L17/dossiers	17	17060000077957	17060000077957	30	PA1090	2017-01-11	False
17060000077989	L17/dossiers	17	17060000077957	17060000077957	31	PA425322	2017-01-11	False
17060000077990	L17/dossiers	17	17060000077957	17060000077957	32	PA703539	2017-01-11	False
17060000077991	L17/dossiers	17	17060000077957	17060000077957	33	PA267419	2017-01-11	False
17060000077992	L17/dossiers	17	17060000077957	17060000077957	34	PA267112	2017-01-11	False
17060000077993	L17/dossiers	17	17060000077957	17060000077957	35	PA703494	2017-01-11	False
17060000077994	L17/dossiers	17	17060000077957	17060000077957	36	PA703498	2017-01-11	False
17060000077995	L17/dossiers	17	17060000077957	17060000077957	37	PA1142	2017-01-11	False
17060000077996	L17/dossiers	17	17060000077957	17060000077957	38	PA304062	2017-01-11	False
17060000077997	L17/dossiers	17	17060000077957	17060000077957	39	PA429834	2017-01-11	False
17060000077998	L17/dossiers	17	17060000077957	17060000077957	40	PA703506	2017-01-11	False