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
17060000078209	L17/dossiers	17	17060000078206	17060000078206	2	PA703532	2017-09-13	False
17060000078210	L17/dossiers	17	17060000078206	17060000078206	3	PA528	2017-09-13	False
17060000078211	L17/dossiers	17	17060000078206	17060000078206	4	PA703514	2017-09-13	False
17060000078212	L17/dossiers	17	17060000078206	17060000078206	5	PA266795	2017-09-13	False
17060000078213	L17/dossiers	17	17060000078206	17060000078206	6	PA703492	2017-09-13	False
17060000078214	L17/dossiers	17	17060000078206	17060000078206	7	PA703515	2017-09-13	False
17060000078215	L17/dossiers	17	17060000078206	17060000078206	8	PA703536	2017-09-13	False
17060000078216	L17/dossiers	17	17060000078206	17060000078206	9	PA415451	2017-09-13	False
17060000078217	L17/dossiers	17	17060000078206	17060000078206	10	PA415467	2017-09-13	False
17060000078218	L17/dossiers	17	17060000078206	17060000078206	11	PA703497	2017-09-13	False
17060000078219	L17/dossiers	17	17060000078206	17060000078206	12	PA415446	2017-09-13	False
17060000078220	L17/dossiers	17	17060000078206	17060000078206	13	PA415479	2017-09-13	False
17060000078221	L17/dossiers	17	17060000078206	17060000078206	14	PA703541	2017-09-13	False
17060000078222	L17/dossiers	17	17060000078206	17060000078206	15	PA1452	2017-09-13	False
17060000078223	L17/dossiers	17	17060000078206	17060000078206	16	PA2538	2017-09-13	False
17060000078224	L17/dossiers	17	17060000078206	17060000078206	17	PA2543	2017-09-13	False
17060000078225	L17/dossiers	17	17060000078206	17060000078206	18	PA703500	2017-09-13	False
17060000078226	L17/dossiers	17	17060000078206	17060000078206	19	PA304085	2017-09-13	False
17060000078227	L17/dossiers	17	17060000078206	17060000078206	20	PA703510	2017-09-13	False
17060000078228	L17/dossiers	17	17060000078206	17060000078206	21	PA709750	2017-09-13	False
17060000078229	L17/dossiers	17	17060000078206	17060000078206	22	PA703513	2017-09-13	False
17060000078230	L17/dossiers	17	17060000078206	17060000078206	23	PA429854	2017-09-13	False
17060000078231	L17/dossiers	17	17060000078206	17060000078206	24	PA922	2017-09-13	False
17060000078232	L17/dossiers	17	17060000078206	17060000078206	25	PA425322	2017-09-13	False
17060000078233	L17/dossiers	17	17060000078206	17060000078206	26	PA703539	2017-09-13	False
17060000078234	L17/dossiers	17	17060000078206	17060000078206	27	PA1344	2017-09-13	False
17060000078235	L17/dossiers	17	17060000078206	17060000078206	28	PA304108	2017-09-13	False
17060000078236	L17/dossiers	17	17060000078206	17060000078206	29	PA304000	2017-09-13	False
17060000078237	L17/dossiers	17	17060000078206	17060000078206	30	PA703537	2017-09-13	False
17060000078238	L17/dossiers	17	17060000078206	17060000078206	31	PA708632	2017-09-13	False
17060000078239	L17/dossiers	17	17060000078206	17060000078206	32	PA705750	2017-09-13	False
17060000078240	L17/dossiers	17	17060000078206	17060000078206	33	PA2237	2017-09-13	False
17060000078241	L17/dossiers	17	17060000078206	17060000078206	34	PA703518	2017-09-13	False
17060000078242	L17/dossiers	17	17060000078206	17060000078206	35	PA406065	2017-09-13	False
17060000078243	L17/dossiers	17	17060000078206	17060000078206	36	PA313924	2017-09-13	False
17060000078244	L17/dossiers	17	17060000078206	17060000078206	37	PA711156	2017-09-13	False
17060000078245	L17/dossiers	17	17060000078206	17060000078206	38	PA703527	2017-09-13	False
17060000078268	L17/dossiers	17	17060000078266	17060000078266	1	PA426327	2017-10-17	True
17060000078269	L17/dossiers	17	17060000078266	17060000078266	2	PA736202	2017-10-17	False
17060000078270	L17/dossiers	17	17060000078266	17060000078266	3	PA703532	2017-10-17	False
17060000078271	L17/dossiers	17	17060000078266	17060000078266	4	PA736176	2017-10-17	False
17060000078272	L17/dossiers	17	17060000078266	17060000078266	5	PA703500	2017-10-17	False
17060000078273	L17/dossiers	17	17060000078266	17060000078266	6	PA703510	2017-10-17	False
17060000078274	L17/dossiers	17	17060000078266	17060000078266	7	PA703514	2017-10-17	False
17060000078275	L17/dossiers	17	17060000078266	17060000078266	8	PA429870	2017-10-17	False
17060000078276	L17/dossiers	17	17060000078266	17060000078266	9	PA736245	2017-10-17	False
17060000078277	L17/dossiers	17	17060000078266	17060000078266	10	PA922	2017-10-17	False
17060000078278	L17/dossiers	17	17060000078266	17060000078266	11	PA267743	2017-10-17	False
17060000078279	L17/dossiers	17	17060000078266	17060000078266	12	PA703483	2017-10-17	False
17060000078280	L17/dossiers	17	17060000078266	17060000078266	13	PA1001	2017-10-17	False