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	organe_organe_ref	organe_et_apparentes
17060000003085	L17/dossiers	17	17060000003080	17060000003080	4	PA1362	2014-12-09	True
17060000003086	L17/dossiers	17	17060000003080	17060000003080	5	PA608741	2014-12-09	True
17060000003087	L17/dossiers	17	17060000003080	17060000003080	6	PA2430	2014-12-09	True
17060000003088	L17/dossiers	17	17060000003080	17060000003080	7	PA606745	2014-12-09	True
17060000003089	L17/dossiers	17	17060000003080	17060000003080	8	PA607892	2014-12-09	True
17060000003090	L17/dossiers	17	17060000003080	17060000003080	9	PA607509	2014-12-09	True
17060000003091	L17/dossiers	17	17060000003080	17060000003080	10	PA2693	2014-12-09	True
17060000003092	L17/dossiers	17	17060000003080	17060000003080	11	PA332796	2014-12-09	True
17060000003093	L17/dossiers	17	17060000003080	17060000003080	12	PA609845	2014-12-09	True
17060000003094	L17/dossiers	17	17060000003080	17060000003080	13	PA332614	2014-12-09	True
17060000003095	L17/dossiers	17	17060000003080	17060000003080	14	PA332305	2014-12-09	True
17060000003096	L17/dossiers	17	17060000003080	17060000003080	15	PA1689	2014-12-09	True
17060000003097	L17/dossiers	17	17060000003080	17060000003080	16	PA1991	2014-12-09	True
17060000003098	L17/dossiers	17	17060000003080	17060000003080	17	PA334811	2014-12-09	True
17060000003099	L17/dossiers	17	17060000003080	17060000003080	18	PA334	2014-12-09	True
17060000003100	L17/dossiers	17	17060000003080	17060000003080	19	PA1977	2014-12-09	True
17060000003101	L17/dossiers	17	17060000003080	17060000003080	20	PA2503	2014-12-09	True
17060000003102	L17/dossiers	17	17060000003080	17060000003080	21	PA332384	2014-12-09	True
17060000003103	L17/dossiers	17	17060000003080	17060000003080	22	PA304016	2014-12-09	True
17060000003104	L17/dossiers	17	17060000003080	17060000003080	23	PA560	2014-12-09	True
17060000003105	L17/dossiers	17	17060000003080	17060000003080	24	PA333043	2014-12-09	True
17060000003106	L17/dossiers	17	17060000003080	17060000003080	25	PA2685	2014-12-09	True
17060000003107	L17/dossiers	17	17060000003080	17060000003080	26	PA267695	2014-12-09	True
17060000003108	L17/dossiers	17	17060000003080	17060000003080	27	PA877	2014-12-09	True
17060000003109	L17/dossiers	17	17060000003080	17060000003080	28	PA336421	2014-12-09	True
17060000003110	L17/dossiers	17	17060000003080	17060000003080	29	PA1182	2014-12-09	True
17060000003111	L17/dossiers	17	17060000003080	17060000003080	30	PA605804	2014-12-09	True
17060000003112	L17/dossiers	17	17060000003080	17060000003080	31	PA1710	2014-12-09	True
17060000003113	L17/dossiers	17	17060000003080	17060000003080	32	PA1844	2014-12-09	True
17060000003114	L17/dossiers	17	17060000003080	17060000003080	33	PA1871	2014-12-09	True
17060000003115	L17/dossiers	17	17060000003080	17060000003080	34	PA330546	2014-12-09	True
17060000003116	L17/dossiers	17	17060000003080	17060000003080	35	PA2859	2014-12-09	True
17060000003117	L17/dossiers	17	17060000003080	17060000003080	36	PA336112	2014-12-09	True
17060000003118	L17/dossiers	17	17060000003080	17060000003080	37	PA2895	2014-12-09	True
17060000003119	L17/dossiers	17	17060000003080	17060000003080	38	PA642987	2014-12-11	False
17060000003120	L17/dossiers	17	17060000003080	17060000003080	39		2014-12-09	False	PO656002	True
17060000003121	L17/dossiers	17	17060000003080	17060000003080	40	PA610758	2014-12-09	False
17060000003122	L17/dossiers	17	17060000003080	17060000003080	41	PA267706	2014-12-09	False
17060000003123	L17/dossiers	17	17060000003080	17060000003080	42	PA642764	2014-12-09	False
17060000003124	L17/dossiers	17	17060000003080	17060000003080	43	PA339	2014-12-09	False
17060000003125	L17/dossiers	17	17060000003080	17060000003080	44	PA607369	2014-12-09	False
17060000003126	L17/dossiers	17	17060000003080	17060000003080	45	PA394	2014-12-09	False
17060000003127	L17/dossiers	17	17060000003080	17060000003080	46	PA342415	2014-12-09	False
17060000003128	L17/dossiers	17	17060000003080	17060000003080	47	PA608686	2014-12-09	False
17060000003129	L17/dossiers	17	17060000003080	17060000003080	48	PA608158	2014-12-09	False
17060000003130	L17/dossiers	17	17060000003080	17060000003080	49	PA605143	2014-12-09	False
17060000003131	L17/dossiers	17	17060000003080	17060000003080	50	PA508	2014-12-09	False
17060000003132	L17/dossiers	17	17060000003080	17060000003080	51	PA608363	2014-12-09	False
17060000003133	L17/dossiers	17	17060000003080	17060000003080	52	PA536	2014-12-09	False
17060000003134	L17/dossiers	17	17060000003080	17060000003080	53	PA608641	2014-12-09	False