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
17060000078822	L17/dossiers	17	17060000078762	17060000078762	59	PA429835	2018-10-30	False
17060000078823	L17/dossiers	17	17060000078762	17060000078762	60	PA415471	2018-10-30	False
17060000078824	L17/dossiers	17	17060000078762	17060000078762	61	PA1070	2018-10-30	False
17060000078825	L17/dossiers	17	17060000078762	17060000078762	62	PA703538	2018-10-30	False
17060000078826	L17/dossiers	17	17060000078762	17060000078762	63	PA1229	2018-10-30	False
17060000078827	L17/dossiers	17	17060000078762	17060000078762	64	PA1231	2018-10-30	False
17060000078828	L17/dossiers	17	17060000078762	17060000078762	65	PA429867	2018-10-30	False
17060000078829	L17/dossiers	17	17060000078762	17060000078762	66	PA429833	2018-10-30	False
17060000078830	L17/dossiers	17	17060000078762	17060000078762	67	PA736167	2018-10-30	False
17060000078831	L17/dossiers	17	17060000078762	17060000078762	68	PA1617	2018-10-30	False
17060000078832	L17/dossiers	17	17060000078762	17060000078762	69	PA736233	2018-10-30	False
17060000078833	L17/dossiers	17	17060000078762	17060000078762	70	PA703509	2018-10-30	False
17060000078834	L17/dossiers	17	17060000078762	17060000078762	71	PA736181	2018-10-30	False
17060000078835	L17/dossiers	17	17060000078762	17060000078762	72	PA703536	2018-10-30	False
17060000078836	L17/dossiers	17	17060000078762	17060000078762	73	PA1796	2018-10-30	False
17060000078837	L17/dossiers	17	17060000078762	17060000078762	74	PA429860	2018-10-30	False
17060000078838	L17/dossiers	17	17060000078762	17060000078762	75	PA415453	2018-10-30	False
17060000078839	L17/dossiers	17	17060000078762	17060000078762	76	PA342564	2018-10-30	False
17060000078840	L17/dossiers	17	17060000078762	17060000078762	77	PA268048	2018-10-30	False
17060000078841	L17/dossiers	17	17060000078762	17060000078762	78	PA2027	2018-10-30	False
17060000078842	L17/dossiers	17	17060000078762	17060000078762	79	PA2030	2018-10-30	False
17060000078843	L17/dossiers	17	17060000078762	17060000078762	80	PA2112	2018-10-30	False
17060000078844	L17/dossiers	17	17060000078762	17060000078762	81	PA2200	2018-10-30	False
17060000078845	L17/dossiers	17	17060000078762	17060000078762	82	PA703512	2018-10-30	False
17060000078846	L17/dossiers	17	17060000078762	17060000078762	83	PA643211	2018-10-30	False
17060000078847	L17/dossiers	17	17060000078762	17060000078762	84	PA2233	2018-10-30	False
17060000078848	L17/dossiers	17	17060000078762	17060000078762	85	PA2334	2018-10-30	False
17060000078849	L17/dossiers	17	17060000078762	17060000078762	86	PA2360	2018-10-30	False
17060000078850	L17/dossiers	17	17060000078762	17060000078762	87	PA2394	2018-10-30	False
17060000078851	L17/dossiers	17	17060000078762	17060000078762	88	PA736209	2018-10-30	False
17060000078852	L17/dossiers	17	17060000078762	17060000078762	89	PA2476	2018-10-30	False
17060000078853	L17/dossiers	17	17060000078762	17060000078762	90	PA2512	2018-10-30	False
17060000078854	L17/dossiers	17	17060000078762	17060000078762	91	PA429889	2018-10-30	False
17060000078855	L17/dossiers	17	17060000078762	17060000078762	92	PA2687	2018-10-30	False
17060000078856	L17/dossiers	17	17060000078762	17060000078762	93	PA2727	2018-10-30	False
17060000078857	L17/dossiers	17	17060000078762	17060000078762	94	PA2739	2018-10-30	False
17060000078858	L17/dossiers	17	17060000078762	17060000078762	95	PA2776	2018-10-30	False
17060000078859	L17/dossiers	17	17060000078762	17060000078762	96	PA2790	2018-10-30	False
17060000078860	L17/dossiers	17	17060000078762	17060000078762	97	PA703491	2018-10-30	False
17060000078861	L17/dossiers	17	17060000078762	17060000078762	98	PA2904	2018-10-30	False
17060000078864	L17/dossiers	17	17060000078862	17060000078862	1	PA2197	2018-12-18	True
17060000078865	L17/dossiers	17	17060000078862	17060000078862	2	PA2538	2018-12-18	True
17060000078866	L17/dossiers	17	17060000078862	17060000078862	3	PA736247	2018-12-18	False
17060000078867	L17/dossiers	17	17060000078862	17060000078862	4	PA744079	2018-12-18	False
17060000078868	L17/dossiers	17	17060000078862	17060000078862	5	PA736188	2018-12-18	False
17060000078869	L17/dossiers	17	17060000078862	17060000078862	6	PA736202	2018-12-18	False
17060000078870	L17/dossiers	17	17060000078862	17060000078862	7	PA736163	2018-12-18	False
17060000078871	L17/dossiers	17	17060000078862	17060000078862	8	PA703532	2018-12-18	False
17060000078872	L17/dossiers	17	17060000078862	17060000078862	9	PA550	2018-12-18	False
17060000078873	L17/dossiers	17	17060000078862	17060000078862	10	PA736198	2018-12-18	False