dossiers.document_co_signataire

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

305 151 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 25 %, 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
17060000003744	L17/dossiers	17	17060000003558	17060000003558	185	PA721946	2020-12-23	False
17060000003745	L17/dossiers	17	17060000003558	17060000003558	186	PA719080	2020-12-23	False
17060000003746	L17/dossiers	17	17060000003558	17060000003558	187	PA720146	2020-12-23	False
17060000003747	L17/dossiers	17	17060000003558	17060000003558	188	PA721800	2020-12-23	False
17060000003748	L17/dossiers	17	17060000003558	17060000003558	189	PA721726	2020-12-23	False
17060000003749	L17/dossiers	17	17060000003558	17060000003558	190	PA677483	2020-12-23	False
17060000003750	L17/dossiers	17	17060000003558	17060000003558	191	PA720870	2020-12-23	False
17060000003751	L17/dossiers	17	17060000003558	17060000003558	192	PA720370	2020-12-23	False
17060000003752	L17/dossiers	17	17060000003558	17060000003558	193	PA719882	2020-12-23	False
17060000003753	L17/dossiers	17	17060000003558	17060000003558	194	PA719130	2020-12-23	False
17060000003754	L17/dossiers	17	17060000003558	17060000003558	195	PA719668	2020-12-23	False
17060000003755	L17/dossiers	17	17060000003558	17060000003558	196	PA719952	2020-12-23	False
17060000003756	L17/dossiers	17	17060000003558	17060000003558	197	PA719456	2020-12-23	False
17060000003757	L17/dossiers	17	17060000003558	17060000003558	198	PA719242	2020-12-23	False
17060000003758	L17/dossiers	17	17060000003558	17060000003558	199	PA720908	2020-12-23	False
17060000003759	L17/dossiers	17	17060000003558	17060000003558	200	PA721656	2020-12-23	False
17060000003760	L17/dossiers	17	17060000003558	17060000003558	201	PA719520	2020-12-23	False
17060000003761	L17/dossiers	17	17060000003558	17060000003558	202	PA719364	2020-12-23	False
17060000003762	L17/dossiers	17	17060000003558	17060000003558	203	PA720108	2020-12-23	False
17060000003763	L17/dossiers	17	17060000003558	17060000003558	204	PA720492	2020-12-23	False
17060000003764	L17/dossiers	17	17060000003558	17060000003558	205	PA720402	2020-12-23	False
17060000003765	L17/dossiers	17	17060000003558	17060000003558	206	PA719632	2020-12-23	False
17060000003766	L17/dossiers	17	17060000003558	17060000003558	207	PA719202	2020-12-23	False
17060000003767	L17/dossiers	17	17060000003558	17060000003558	208	PA720944	2020-12-23	False
17060000003768	L17/dossiers	17	17060000003558	17060000003558	209	PA607595	2020-12-23	False
17060000003769	L17/dossiers	17	17060000003558	17060000003558	210	PA718802	2020-12-23	False
17060000003770	L17/dossiers	17	17060000003558	17060000003558	211	PA720414	2020-12-23	False
17060000003771	L17/dossiers	17	17060000003558	17060000003558	212	PA721568	2020-12-23	False
17060000003772	L17/dossiers	17	17060000003558	17060000003558	213	PA718930	2020-12-23	False
17060000003773	L17/dossiers	17	17060000003558	17060000003558	214	PA722090	2020-12-23	False
17060000003774	L17/dossiers	17	17060000003558	17060000003558	215	PA718736	2020-12-23	False
17060000003775	L17/dossiers	17	17060000003558	17060000003558	216	PA721372	2020-12-23	False
17060000003776	L17/dossiers	17	17060000003558	17060000003558	217	PA721844	2020-12-23	False
17060000003777	L17/dossiers	17	17060000003558	17060000003558	218	PA718910	2020-12-23	False
17060000003778	L17/dossiers	17	17060000003558	17060000003558	219	PA721872	2020-12-23	False
17060000003779	L17/dossiers	17	17060000003558	17060000003558	220	PA2449	2020-12-23	False
17060000003780	L17/dossiers	17	17060000003558	17060000003558	221	PA719528	2020-12-23	False
17060000003781	L17/dossiers	17	17060000003558	17060000003558	222	PA719600	2020-12-23	False
17060000003782	L17/dossiers	17	17060000003558	17060000003558	223	PA721916	2020-12-23	False
17060000003783	L17/dossiers	17	17060000003558	17060000003558	224	PA722194	2020-12-23	False
17060000003784	L17/dossiers	17	17060000003558	17060000003558	225	PA643127	2020-12-23	False
17060000003785	L17/dossiers	17	17060000003558	17060000003558	226	PA718944	2020-12-23	False
17060000003786	L17/dossiers	17	17060000003558	17060000003558	227	PA720552	2020-12-23	False
17060000003787	L17/dossiers	17	17060000003558	17060000003558	228	PA722398	2020-12-23	False
17060000003788	L17/dossiers	17	17060000003558	17060000003558	229	PA721824	2020-12-23	False
17060000003789	L17/dossiers	17	17060000003558	17060000003558	230	PA720900	2020-12-23	False
17060000003790	L17/dossiers	17	17060000003558	17060000003558	231	PA722252	2020-12-23	False
17060000003791	L17/dossiers	17	17060000003558	17060000003558	232	PA722022	2020-12-23	False
17060000003792	L17/dossiers	17	17060000003558	17060000003558	233	PA721538	2020-12-23	False
17060000003793	L17/dossiers	17	17060000003558	17060000003558	234	PA721458	2020-12-23	False