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
17060000007983	L17/dossiers	17	17060000007968	17060000007968	14	PA346782	2024-10-16	False
17060000007984	L17/dossiers	17	17060000007968	17060000007968	15	PA841693	2024-10-16	False
17060000007985	L17/dossiers	17	17060000007968	17060000007968	16	PA794702	2024-10-16	False
17060000007986	L17/dossiers	17	17060000007968	17060000007968	17	PA720230	2024-10-16	False
17060000007987	L17/dossiers	17	17060000007968	17060000007968	18	PA720976	2024-10-16	False
17060000007988	L17/dossiers	17	17060000007968	17060000007968	19	PA841931	2024-10-16	False
17060000007989	L17/dossiers	17	17060000007968	17060000007968	20	PA719640	2024-10-16	False
17060000007990	L17/dossiers	17	17060000007968	17060000007968	21	PA794810	2024-10-16	False
17060000007991	L17/dossiers	17	17060000007968	17060000007968	22	PA721486	2024-10-16	False
17060000007992	L17/dossiers	17	17060000007968	17060000007968	23	PA794830	2024-10-16	False
17060000007993	L17/dossiers	17	17060000007968	17060000007968	24	PA841359	2024-10-16	False
17060000007994	L17/dossiers	17	17060000007968	17060000007968	25	PA721234	2024-10-16	False
17060000007995	L17/dossiers	17	17060000007968	17060000007968	26	PA721844	2024-10-16	False
17060000007996	L17/dossiers	17	17060000007968	17060000007968	27	PA720092	2024-10-16	False
17060000007997	L17/dossiers	17	17060000007968	17060000007968	28	PA793094	2024-10-16	False
17060000007998	L17/dossiers	17	17060000007968	17060000007968	29	PA342196	2024-10-16	False
17060000007999	L17/dossiers	17	17060000007968	17060000007968	30	PA722142	2024-10-16	False
17060000008000	L17/dossiers	17	17060000007968	17060000007968	31	PA794486	2024-10-16	False
17060000008001	L17/dossiers	17	17060000007968	17060000007968	32	PA793796	2024-10-16	False
17060000008002	L17/dossiers	17	17060000007968	17060000007968	33	PA841713	2024-10-16	False
17060000008003	L17/dossiers	17	17060000007968	17060000007968	34	PA722336	2024-10-16	False
17060000008004	L17/dossiers	17	17060000007968	17060000007968	35	PA721270	2024-10-16	False
17060000008005	L17/dossiers	17	17060000007968	17060000007968	36	PA608172	2024-10-16	False
17060000008009	L17/dossiers	17	17060000008007	17060000008007	1	PA330008	2024-11-19	False
17060000008013	L17/dossiers	17	17060000008011	17060000008011	1	PA774954	2024-09-20	False
17060000008014	L17/dossiers	17	17060000008011	17060000008011	2	PA841047	2024-09-20	False
17060000008015	L17/dossiers	17	17060000008011	17060000008011	3	PA608826	2024-09-20	False
17060000008016	L17/dossiers	17	17060000008011	17060000008011	4	PA1327	2024-09-20	False
17060000008017	L17/dossiers	17	17060000008011	17060000008011	5	PA606098	2024-09-20	False
17060000008018	L17/dossiers	17	17060000008011	17060000008011	6	PA793342	2024-09-20	False
17060000008019	L17/dossiers	17	17060000008011	17060000008011	7	PA794038	2024-09-20	False
17060000008020	L17/dossiers	17	17060000008011	17060000008011	8	PA721442	2024-09-20	False
17060000008021	L17/dossiers	17	17060000008011	17060000008011	9	PA266808	2024-09-20	False
17060000008022	L17/dossiers	17	17060000008011	17060000008011	10	PA607090	2024-09-20	False
17060000008023	L17/dossiers	17	17060000008011	17060000008011	11	PA330909	2024-09-20	False
17060000008024	L17/dossiers	17	17060000008011	17060000008011	12	PA794058	2024-09-20	False
17060000008025	L17/dossiers	17	17060000008011	17060000008011	13	PA793094	2024-09-20	False
17060000008032	L17/dossiers	17	17060000008030	17060000008030	1	PA793508	2024-09-17	False
17060000008033	L17/dossiers	17	17060000008030	17060000008030	2	PA841047	2024-09-17	False
17060000008034	L17/dossiers	17	17060000008030	17060000008030	3	PA346782	2024-09-17	False
17060000008035	L17/dossiers	17	17060000008030	17060000008030	4	PA719272	2024-09-17	False
17060000008039	L17/dossiers	17	17060000008037	17060000008037	1	PA793508	2024-09-17	False
17060000008040	L17/dossiers	17	17060000008037	17060000008037	2	PA841047	2024-09-17	False
17060000008041	L17/dossiers	17	17060000008037	17060000008037	3	PA720386	2024-09-17	False
17060000008042	L17/dossiers	17	17060000008037	17060000008037	4	PA719272	2024-09-17	False
17060000008046	L17/dossiers	17	17060000008044	17060000008044	1	PA793508	2024-09-17	False
17060000008047	L17/dossiers	17	17060000008044	17060000008044	2	PA841047	2024-09-17	False
17060000008048	L17/dossiers	17	17060000008044	17060000008044	3	PA720386	2024-09-17	False
17060000008049	L17/dossiers	17	17060000008044	17060000008044	4	PA1327	2024-09-17	False
17060000008050	L17/dossiers	17	17060000008044	17060000008044	5	PA719272	2024-09-17	False