dossiers.document_co_signataire

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

309 756 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
16060000016271	L16/dossiers	16	16060000016259	16060000016259	11	PA333285	2023-01-17	False
16060000016272	L16/dossiers	16	16060000016259	16060000016259	12	PA1567	2023-01-17	False
16060000016273	L16/dossiers	16	16060000016259	16060000016259	13	PA795828	2023-01-17	False
16060000016274	L16/dossiers	16	16060000016259	16060000016259	14	PA643192	2023-01-17	False
16060000016275	L16/dossiers	16	16060000016259	16060000016259	15	PA335054	2023-01-17	False
16060000016276	L16/dossiers	16	16060000016259	16060000016259	16	PA795156	2023-01-17	False
16060000016277	L16/dossiers	16	16060000016259	16060000016259	17	PA774958	2023-01-17	False
16060000016278	L16/dossiers	16	16060000016259	16060000016259	18	PA643157	2023-01-17	False
16060000016279	L16/dossiers	16	16060000016259	16060000016259	19	PA794270	2023-01-17	False
16060000016280	L16/dossiers	16	16060000016259	16060000016259	20	PA608172	2023-01-17	False
16060000016281	L16/dossiers	16	16060000016259	16060000016259	21	PA607553	2023-01-17	False
16060000016282	L16/dossiers	16	16060000016259	16060000016259	22	PA609590	2023-01-17	False
16060000016283	L16/dossiers	16	16060000016259	16060000016259	23	PA342196	2023-01-17	False
16060000016284	L16/dossiers	16	16060000016259	16060000016259	24	PA774960	2023-01-17	False
16060000016285	L16/dossiers	16	16060000016259	16060000016259	25	PA340343	2023-01-17	False
16060000016286	L16/dossiers	16	16060000016259	16060000016259	26	PA793816	2023-01-17	False
16060000016287	L16/dossiers	16	16060000016259	16060000016259	27	PA608695	2023-01-17	False
16060000016288	L16/dossiers	16	16060000016259	16060000016259	28	PA719930	2023-01-17	False
16060000016289	L16/dossiers	16	16060000016259	16060000016259	29	PA794494	2023-01-17	False
16060000016293	L16/dossiers	16	16060000016291	16060000016291	1	PA642847	2023-01-17	False
16060000016294	L16/dossiers	16	16060000016291	16060000016291	2	PA718884	2023-01-17	False
16060000016295	L16/dossiers	16	16060000016291	16060000016291	3	PA774954	2023-01-17	False
16060000016296	L16/dossiers	16	16060000016291	16060000016291	4	PA266793	2023-01-17	False
16060000016297	L16/dossiers	16	16060000016291	16060000016291	5	PA721816	2023-01-17	False
16060000016298	L16/dossiers	16	16060000016291	16060000016291	6	PA342240	2023-01-17	False
16060000016299	L16/dossiers	16	16060000016291	16060000016291	7	PA722390	2023-01-17	False
16060000016300	L16/dossiers	16	16060000016291	16060000016291	8	PA793476	2023-01-17	False
16060000016301	L16/dossiers	16	16060000016291	16060000016291	9	PA267324	2023-01-17	False
16060000016302	L16/dossiers	16	16060000016291	16060000016291	10	PA266797	2023-01-17	False
16060000016303	L16/dossiers	16	16060000016291	16060000016291	11	PA783457	2023-01-17	False
16060000016304	L16/dossiers	16	16060000016291	16060000016291	12	PA1630	2023-01-17	False
16060000016305	L16/dossiers	16	16060000016291	16060000016291	13	PA608416	2023-01-17	False
16060000016306	L16/dossiers	16	16060000016291	16060000016291	14	PA346782	2023-01-17	False
16060000016307	L16/dossiers	16	16060000016291	16060000016291	15	PA608016	2023-01-17	False
16060000016308	L16/dossiers	16	16060000016291	16060000016291	16	PA346054	2023-01-17	False
16060000016309	L16/dossiers	16	16060000016291	16060000016291	17	PA793342	2023-01-17	False
16060000016310	L16/dossiers	16	16060000016291	16060000016291	18	PA719272	2023-01-17	False
16060000016311	L16/dossiers	16	16060000016291	16060000016291	19	PA794038	2023-01-17	False
16060000016312	L16/dossiers	16	16060000016291	16060000016291	20	PA795406	2023-01-17	False
16060000016313	L16/dossiers	16	16060000016291	16060000016291	21	PA721442	2023-01-17	False
16060000016314	L16/dossiers	16	16060000016291	16060000016291	22	PA794994	2023-01-17	False
16060000016315	L16/dossiers	16	16060000016291	16060000016291	23	PA793094	2023-01-17	False
16060000016316	L16/dossiers	16	16060000016291	16060000016291	24	PA794410	2023-01-17	False
16060000016317	L16/dossiers	16	16060000016291	16060000016291	25	PA794178	2023-01-17	False
16060000016318	L16/dossiers	16	16060000016291	16060000016291	26	PA643134	2023-01-17	False
16060000016322	L16/dossiers	16	16060000016320	16060000016320	1	PA722038	2023-03-03	False
16060000016323	L16/dossiers	16	16060000016320	16060000016320	2	PA721522	2023-03-03	False
16060000016327	L16/dossiers	16	16060000016325	16060000016325	1	PA795552	2023-01-17	False
16060000016328	L16/dossiers	16	16060000016325	16060000016325	2	PA796118	2023-01-17	False
16060000016329	L16/dossiers	16	16060000016325	16060000016325	3	PA794562	2023-01-17	False