dossiers.dossier_parlementaire_acte_legislatif_texte_associe

Chemin dossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 %

5 606 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	`_parent_recursif_id`	BIGINT	_id de la ligne de même table qui contient celle-ci (structure récursive)
8	`_niveau`	BIGINT	profondeur dans la structure récursive (0 = premier niveau)
9	`type_texte`	VARCHAR	dossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie.typeTexte · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 %
10	`ref_texte_associe`	VARCHAR	dossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie.refTexteAssocie · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 %

Aperçu

_id	_source	_legislature	_racine_id	_parent_id	_ordre	_niveau	type_texte	ref_texte_associe
17060000135526	L17/dossiers	17	17060000135498	17060000135525	1	2	BTA	PRJLANR5L17BTA0244
17060000135542	L17/dossiers	17	17060000135529	17060000135541	1	2	BTA	PIONSNR5S479BTA0115
17060000135555	L17/dossiers	17	17060000135529	17060000135554	1	2	BTA	PIONANR5L17BTA0288
17060000135556	L17/dossiers	17	17060000135529	17060000135554	2	2	TAP	PIONANR5L17TAP0288
17060000135615	L17/dossiers	17	17060000135602	17060000135614	1	2	BTA	PIONSNR5S479BTA0056
17060000135799	L17/dossiers	17	17060000135775	17060000135798	1	2	BTA	RIONANR5L17BTA0215
17060000135823	L17/dossiers	17	17060000135800	17060000135822	1	2	BTA	PRJLANR5L17BTA0139
17060000135834	L17/dossiers	17	17060000135800	17060000135833	1	2	BTA	PRJLSNR5S459BTA0157
17060000136022	L17/dossiers	17	17060000136005	17060000136021	1	2	BTA	PIONANR5L17BTA0283
17060000136023	L17/dossiers	17	17060000136005	17060000136021	2	2	TAP	PIONANR5L17TAP0283
17060000136173	L17/dossiers	17	17060000136148	17060000136172	1	2	BTA	PRJLANR5L17BTA0150
17060000136184	L17/dossiers	17	17060000136148	17060000136183	1	2	BTA	PRJLSNR5S479BTA0010
17060000136246	L17/dossiers	17	17060000136204	17060000136245	1	2	BTA	PIONSNR5S479BTA0064
17060000136261	L17/dossiers	17	17060000136204	17060000136260	1	2	BTA	PIONANR5L17BTA0259
17060000136262	L17/dossiers	17	17060000136204	17060000136260	2	2	TAP	PIONANR5L17TAP0259
17060000136277	L17/dossiers	17	17060000136204	17060000136276	1	2	BTA	PIONANR5L17BTA0276
17060000136278	L17/dossiers	17	17060000136204	17060000136276	2	2	TAP	PIONANR5L17TAP0276
17060000136281	L17/dossiers	17	17060000136204	17060000136280	1	2	BTA	PIONSNR5S479BTA0097
17060000136582	L17/dossiers	17	17060000136565	17060000136581	1	2	BTA	RIONANR5L17BTA0206
17060000136803	L17/dossiers	17	17060000136790	17060000136802	1	2	BTA	PRJLSNR5S479BTA0009
17060000136818	L17/dossiers	17	17060000136790	17060000136817	1	2	BTA	PRJLANR5L17BTA0213
17060000136943	L17/dossiers	17	17060000136931	17060000136942	1	2	BTA	PIONSNR5S479BTA0002
17060000137739	L17/dossiers	17	17060000137455	17060000137738	1	2	BTA	PRJLANR5L17BTA0180
17060000137797	L17/dossiers	17	17060000137455	17060000137796	1	2	BTA	PRJLSNR5S479BTA0029
17060000137847	L17/dossiers	17	17060000137455	17060000137846	1	2	BTA	PRJLANR5L17BTA0218
17060000137848	L17/dossiers	17	17060000137455	17060000137846	2	2	TAP	PRJLANR5L17TAP0218
17060000137857	L17/dossiers	17	17060000137455	17060000137856	1	2	BTA	PRJLSNR5S479BTA0048
17060000137874	L17/dossiers	17	17060000137455	17060000137873	1	2	BTA	PRJLANR5L17BTA0227
17060000137875	L17/dossiers	17	17060000137455	17060000137873	2	2	TAP	PRJLANR5L17TAP0227
17060000138196	L17/dossiers	17	17060000138177	17060000138195	1	2	BTA	PRJLANR5L17BTA0201
17060000138208	L17/dossiers	17	17060000138177	17060000138207	1	2	BTA	PRJLSNR5S479BTA0075
17060000138308	L17/dossiers	17	17060000138294	17060000138307	1	2	BTA	PIONSNR5S479BTA0034
17060000138765	L17/dossiers	17	17060000138752	17060000138764	1	2	BTA	PRJLSNR5S479BTA0011
17060000138780	L17/dossiers	17	17060000138752	17060000138779	1	2	BTA	PRJLANR5L17BTA0305
17060000138825	L17/dossiers	17	17060000138812	17060000138824	1	2	BTA	PRJLSNR5S479BTA0026
17060000138846	L17/dossiers	17	17060000138812	17060000138845	1	2	BTA	PRJLANR5L17BTA0245
17060000138872	L17/dossiers	17	17060000138857	17060000138871	1	2	BTA	RIONANR5L17BTA0247
17060000138888	L17/dossiers	17	17060000138873	17060000138887	1	2	BTA	RIONANR5L17BTA0246
17060000138956	L17/dossiers	17	17060000138944	17060000138955	1	2	BTA	PIONSNR5S479BTA0098
17060000139029	L17/dossiers	17	17060000139006	17060000139028	1	2	BTA	RIONANR5L17BTA0233
17060000139030	L17/dossiers	17	17060000139006	17060000139028	2	2	TAP	RIONANR5L17TAP0233
17060000139052	L17/dossiers	17	17060000139038	17060000139051	1	2	BTA	PRJLSNR5S479BTA0007
17060000139071	L17/dossiers	17	17060000139058	17060000139070	1	2	BTA	PIONSNR5S479BTA0004
17060000139094	L17/dossiers	17	17060000139081	17060000139093	1	2	BTA	PRJLSNR5S479BTA0047
17060000139117	L17/dossiers	17	17060000139081	17060000139116	1	2	BTA	PRJLANR5L17BTA0272
17060000139118	L17/dossiers	17	17060000139081	17060000139116	2	2	TAP	PRJLANR5L17TAP0272
17060000139132	L17/dossiers	17	17060000139081	17060000139131	1	2	BTA	PRJLANR5L17BTA0280
17060000139133	L17/dossiers	17	17060000139081	17060000139131	2	2	TAP	PRJLANR5L17TAP0280
17060000139136	L17/dossiers	17	17060000139081	17060000139135	1	2	BTA	PRJLSNR5S479BTA0105
17060000139198	L17/dossiers	17	17060000139179	17060000139197	1	2	BTA	PIONSNR5S479BTA0001