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
16060000017088	L16/dossiers	16	16060000017076	16060000017076	11	PA1874	2023-01-17	False
16060000017089	L16/dossiers	16	16060000017076	16060000017076	12	PA608016	2023-01-17	False
16060000017090	L16/dossiers	16	16060000017076	16060000017076	13	PA721442	2023-01-17	False
16060000017091	L16/dossiers	16	16060000017076	16060000017076	14	PA794994	2023-01-17	False
16060000017092	L16/dossiers	16	16060000017076	16060000017076	15	PA794178	2023-01-17	False
16060000017093	L16/dossiers	16	16060000017076	16060000017076	16	PA720586	2023-01-17	False
16060000017094	L16/dossiers	16	16060000017076	16060000017076	17	PA795406	2023-01-17	False
16060000017098	L16/dossiers	16	16060000017096	16060000017096	1	PA719318	2023-01-17	True
16060000017099	L16/dossiers	16	16060000017096	16060000017096	2	PA642847	2023-01-17	True
16060000017100	L16/dossiers	16	16060000017096	16060000017096	3	PA718884	2023-01-17	False
16060000017101	L16/dossiers	16	16060000017096	16060000017096	4	PA721816	2023-01-17	False
16060000017102	L16/dossiers	16	16060000017096	16060000017096	5	PA342240	2023-01-17	False
16060000017103	L16/dossiers	16	16060000017096	16060000017096	6	PA722390	2023-01-17	False
16060000017104	L16/dossiers	16	16060000017096	16060000017096	7	PA332523	2023-01-17	False
16060000017105	L16/dossiers	16	16060000017096	16060000017096	8	PA793476	2023-01-17	False
16060000017106	L16/dossiers	16	16060000017096	16060000017096	9	PA1327	2023-01-17	False
16060000017107	L16/dossiers	16	16060000017096	16060000017096	10	PA794058	2023-01-17	False
16060000017108	L16/dossiers	16	16060000017096	16060000017096	11	PA1630	2023-01-17	False
16060000017109	L16/dossiers	16	16060000017096	16060000017096	12	PA608416	2023-01-17	False
16060000017110	L16/dossiers	16	16060000017096	16060000017096	13	PA793342	2023-01-17	False
16060000017111	L16/dossiers	16	16060000017096	16060000017096	14	PA718784	2023-01-17	False
16060000017112	L16/dossiers	16	16060000017096	16060000017096	15	PA794994	2023-01-17	False
16060000017113	L16/dossiers	16	16060000017096	16060000017096	16	PA721314	2023-01-17	False
16060000017114	L16/dossiers	16	16060000017096	16060000017096	17	PA794410	2023-01-17	False
16060000017115	L16/dossiers	16	16060000017096	16060000017096	18	PA722308	2023-01-17	False
16060000017116	L16/dossiers	16	16060000017096	16060000017096	19	PA794178	2023-01-17	False
16060000017117	L16/dossiers	16	16060000017096	16060000017096	20	PA643134	2023-01-17	False
16060000017118	L16/dossiers	16	16060000017096	16060000017096	21	PA794118	2023-01-17	False
16060000017119	L16/dossiers	16	16060000017096	16060000017096	22	PA607090	2023-01-17	False
16060000017123	L16/dossiers	16	16060000017121	16060000017121	1	PA717379	2023-01-17	True
16060000017124	L16/dossiers	16	16060000017121	16060000017121	2	PA605036	2023-01-17	False
16060000017125	L16/dossiers	16	16060000017121	16060000017121	3	PA719866	2023-01-17	False
16060000017126	L16/dossiers	16	16060000017121	16060000017121	4	PA722038	2023-01-17	False
16060000017127	L16/dossiers	16	16060000017121	16060000017121	5	PA605963	2023-01-17	False
16060000017128	L16/dossiers	16	16060000017121	16060000017121	6	PA795950	2023-01-17	False
16060000017129	L16/dossiers	16	16060000017121	16060000017121	7	PA721158	2023-01-17	False
16060000017130	L16/dossiers	16	16060000017121	16060000017121	8	PA719100	2023-01-17	False
16060000017131	L16/dossiers	16	16060000017121	16060000017121	9	PA795144	2023-01-17	False
16060000017132	L16/dossiers	16	16060000017121	16060000017121	10	PA794214	2023-01-17	False
16060000017133	L16/dossiers	16	16060000017121	16060000017121	11	PA720362	2023-01-17	False
16060000017134	L16/dossiers	16	16060000017121	16060000017121	12	PA719910	2023-01-17	False
16060000017135	L16/dossiers	16	16060000017121	16060000017121	13	PA721828	2023-01-17	False
16060000017136	L16/dossiers	16	16060000017121	16060000017121	14	PA793500	2023-01-17	False
16060000017137	L16/dossiers	16	16060000017121	16060000017121	15	PA642695	2023-01-17	False
16060000017138	L16/dossiers	16	16060000017121	16060000017121	16	PA606507	2023-01-17	False
16060000017139	L16/dossiers	16	16060000017121	16060000017121	17	PA793528	2023-01-17	False
16060000017140	L16/dossiers	16	16060000017121	16060000017121	18	PA719032	2023-01-17	False
16060000017141	L16/dossiers	16	16060000017121	16060000017121	19	PA718710	2023-01-17	False
16060000017142	L16/dossiers	16	16060000017121	16060000017121	20	PA721908	2023-01-17	False
16060000017143	L16/dossiers	16	16060000017121	16060000017121	21	PA795990	2023-01-17	False