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
17060000078281	L17/dossiers	17	17060000078266	17060000078266	14	PA429869	2017-10-17	False
17060000078282	L17/dossiers	17	17060000078266	17060000078266	15	PA425322	2017-10-17	False
17060000078283	L17/dossiers	17	17060000078266	17060000078266	16	PA1122	2017-10-17	False
17060000078284	L17/dossiers	17	17060000078266	17060000078266	17	PA1183	2017-10-17	False
17060000078285	L17/dossiers	17	17060000078266	17060000078266	18	PA404656	2017-10-17	False
17060000078286	L17/dossiers	17	17060000078266	17060000078266	19	PA1344	2017-10-17	False
17060000078287	L17/dossiers	17	17060000078266	17060000078266	20	PA304108	2017-10-17	False
17060000078288	L17/dossiers	17	17060000078266	17060000078266	21	PA415486	2017-10-17	False
17060000078289	L17/dossiers	17	17060000078266	17060000078266	22	PA267907	2017-10-17	False
17060000078290	L17/dossiers	17	17060000078266	17060000078266	23	PA703530	2017-10-17	False
17060000078291	L17/dossiers	17	17060000078266	17060000078266	24	PA267081	2017-10-17	False
17060000078292	L17/dossiers	17	17060000078266	17060000078266	25	PA736206	2017-10-17	False
17060000078293	L17/dossiers	17	17060000078266	17060000078266	26	PA736223	2017-10-17	False
17060000078294	L17/dossiers	17	17060000078266	17060000078266	27	PA703515	2017-10-17	False
17060000078295	L17/dossiers	17	17060000078266	17060000078266	28	PA1744	2017-10-17	False
17060000078296	L17/dossiers	17	17060000078266	17060000078266	29	PA303992	2017-10-17	False
17060000078297	L17/dossiers	17	17060000078266	17060000078266	30	PA703488	2017-10-17	False
17060000078298	L17/dossiers	17	17060000078266	17060000078266	31	PA703501	2017-10-17	False
17060000078299	L17/dossiers	17	17060000078266	17060000078266	32	PA394676	2017-10-17	False
17060000078300	L17/dossiers	17	17060000078266	17060000078266	33	PA304000	2017-10-17	False
17060000078301	L17/dossiers	17	17060000078266	17060000078266	34	PA736246	2017-10-17	False
17060000078302	L17/dossiers	17	17060000078266	17060000078266	35	PA415447	2017-10-17	False
17060000078303	L17/dossiers	17	17060000078266	17060000078266	36	PA1993	2017-10-17	False
17060000078304	L17/dossiers	17	17060000078266	17060000078266	37	PA703537	2017-10-17	False
17060000078305	L17/dossiers	17	17060000078266	17060000078266	38	PA703497	2017-10-17	False
17060000078306	L17/dossiers	17	17060000078266	17060000078266	39	PA415446	2017-10-17	False
17060000078307	L17/dossiers	17	17060000078266	17060000078266	40	PA415489	2017-10-17	False
17060000078308	L17/dossiers	17	17060000078266	17060000078266	41	PA703480	2017-10-17	False
17060000078309	L17/dossiers	17	17060000078266	17060000078266	42	PA703517	2017-10-17	False
17060000078310	L17/dossiers	17	17060000078266	17060000078266	43	PA343988	2017-10-17	False
17060000078311	L17/dossiers	17	17060000078266	17060000078266	44	PA415479	2017-10-17	False
17060000078312	L17/dossiers	17	17060000078266	17060000078266	45	PA267328	2017-10-17	False
17060000078313	L17/dossiers	17	17060000078266	17060000078266	46	PA267018	2017-10-17	False
17060000078314	L17/dossiers	17	17060000078266	17060000078266	47	PA711156	2017-10-17	False
17060000078315	L17/dossiers	17	17060000078266	17060000078266	48	PA2543	2017-10-17	False
17060000078316	L17/dossiers	17	17060000078266	17060000078266	49	PA429874	2017-10-17	False
17060000078317	L17/dossiers	17	17060000078266	17060000078266	50	PA301592	2017-10-17	False
17060000078318	L17/dossiers	17	17060000078266	17060000078266	51	PA227098	2017-10-17	False
17060000078319	L17/dossiers	17	17060000078266	17060000078266	52	PA703482	2017-10-17	False
17060000078322	L17/dossiers	17	17060000078320	17060000078320	1	PA235	2018-02-22	True
17060000078323	L17/dossiers	17	17060000078320	17060000078320	2	PA703532	2018-02-22	True
17060000078324	L17/dossiers	17	17060000078320	17060000078320	3	PA716	2018-02-22	False
17060000078325	L17/dossiers	17	17060000078320	17060000078320	4	PA703534	2018-02-22	False
17060000078326	L17/dossiers	17	17060000078320	17060000078320	5	PA415462	2018-02-22	False
17060000078327	L17/dossiers	17	17060000078320	17060000078320	6	PA706108	2018-02-22	False
17060000078328	L17/dossiers	17	17060000078320	17060000078320	7	PA980	2018-02-22	False
17060000078329	L17/dossiers	17	17060000078320	17060000078320	8	PA703539	2018-02-22	False
17060000078330	L17/dossiers	17	17060000078320	17060000078320	9	PA1122	2018-02-22	False
17060000078331	L17/dossiers	17	17060000078320	17060000078320	10	PA703498	2018-02-22	False
17060000078332	L17/dossiers	17	17060000078320	17060000078320	11	PA304108	2018-02-22	False