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
17060000112173	L17/dossiers	17	17060000112155	17060000112172	1	2	BTA	PIONANR5L11BTA0505
17060000112185	L17/dossiers	17	17060000112155	17060000112184	1	2	BTA	PIONSNR5S198BTA0021
17060000112229	L17/dossiers	17	17060000112217	17060000112228	1	2	BTA	PIONSNR5S170BTA0092
17060000112277	L17/dossiers	17	17060000112265	17060000112276	1	2	BTA	PIONSNR5S170BTA0103
17060000112325	L17/dossiers	17	17060000112313	17060000112324	1	2	BTA	PIONSNR5S170BTA0104
17060000112373	L17/dossiers	17	17060000112361	17060000112372	1	2	BTA	PIONSNR5S171BTA0061
17060000112427	L17/dossiers	17	17060000112414	17060000112426	1	2	BTA	PIONSNR5S190BTA0054
17060000112471	L17/dossiers	17	17060000112458	17060000112470	1	2	BTA	PIONSNR5S174BTA0118
17060000112515	L17/dossiers	17	17060000112502	17060000112514	1	2	BTA	PIONSNR5S194BTA0010
17060000112554	L17/dossiers	17	17060000112541	17060000112553	1	2	BTA	PIONSNR5S194BTA0079
17060000112593	L17/dossiers	17	17060000112580	17060000112592	1	2	BTA	PIONSNR5S196BTA0022
17060000112634	L17/dossiers	17	17060000112621	17060000112633	1	2	BTA	PIONSNR5S196BTA0093
17060000112676	L17/dossiers	17	17060000112660	17060000112675	1	2	BTA	PIONANR5L13BTA0489
17060000112689	L17/dossiers	17	17060000112660	17060000112688	1	2	BTA	PIONSNR5S197BTA0092
17060000112728	L17/dossiers	17	17060000112715	17060000112727	1	2	BTA	PIONSNR5S197BTA0102
17060000112772	L17/dossiers	17	17060000112754	17060000112771	1	2	BTA	PIONSNR5S197BTA0103
17060000112811	L17/dossiers	17	17060000112798	17060000112810	1	2	BTA	PIONSNR5S198BTA0050
17060000112850	L17/dossiers	17	17060000112837	17060000112849	1	2	BTA	PIONSNR5S199BTA0016
17060000112884	L17/dossiers	17	17060000112871	17060000112883	1	2	BTA	PIONSNR5S199BTA0079
17060000112918	L17/dossiers	17	17060000112905	17060000112917	1	2	BTA	PIONSNR5S199BTA0101
17060000112958	L17/dossiers	17	17060000112944	17060000112957	1	2	BTA	PIONSNR5S199BTA0102
17060000113002	L17/dossiers	17	17060000112989	17060000113001	1	2	BTA	PIONSNR5S199BTA0184
17060000113038	L17/dossiers	17	17060000113023	17060000113037	1	2	BTA	PIONSNR5S219BTA0004
17060000113078	L17/dossiers	17	17060000113065	17060000113077	1	2	BTA	PIONSNR5S219BTA0010
17060000113112	L17/dossiers	17	17060000113099	17060000113111	1	2	BTA	PIONSNR5S219BTA0034
17060000113151	L17/dossiers	17	17060000113133	17060000113150	1	2	BTA	PIONSNR5S219BTA0125
17060000113185	L17/dossiers	17	17060000113172	17060000113184	1	2	BTA	PIONSNR5S219BTA0123
17060000113219	L17/dossiers	17	17060000113206	17060000113218	1	2	BTA	PIONSNR5S219BTA0134
17060000113253	L17/dossiers	17	17060000113240	17060000113252	1	2	BTA	PIONSNR5S219BTA0135
17060000113288	L17/dossiers	17	17060000113274	17060000113287	1	2	BTA	PIONSNR5S219BTA0138
17060000113324	L17/dossiers	17	17060000113309	17060000113323	1	2	BTA	PIONSNR5S239BTA0077
17060000113361	L17/dossiers	17	17060000113345	17060000113360	1	2	BTA	PIONANR5L14BTA0846
17060000113373	L17/dossiers	17	17060000113345	17060000113372	1	2	BTA	PIONSNR5S319BTA0036
17060000113403	L17/dossiers	17	17060000113389	17060000113402	1	2	BTA	PIONSNR5S239BTA0058
17060000113437	L17/dossiers	17	17060000113424	17060000113436	1	2	BTA	PIONSNR5S239BTA0075
17060000113471	L17/dossiers	17	17060000113458	17060000113470	1	2	BTA	PIONSNR5S239BTA0104
17060000113505	L17/dossiers	17	17060000113492	17060000113504	1	2	BTA	PIONSNR5S239BTA0105
17060000113541	L17/dossiers	17	17060000113526	17060000113540	1	2	BTA	PIONANR5L14BTA0658
17060000113554	L17/dossiers	17	17060000113526	17060000113553	1	2	BTA	PIONSNR5S259BTA0145
17060000113588	L17/dossiers	17	17060000113575	17060000113587	1	2	BTA	PIONSNR5S259BTA0064
17060000113622	L17/dossiers	17	17060000113609	17060000113621	1	2	BTA	PIONSNR5S259BTA0079
17060000113656	L17/dossiers	17	17060000113643	17060000113655	1	2	BTA	PIONSNR5S259BTA0082
17060000113690	L17/dossiers	17	17060000113677	17060000113689	1	2	BTA	PIONSNR5S279BTA0007
17060000113724	L17/dossiers	17	17060000113711	17060000113723	1	2	BTA	PIONSNR5S279BTA0031
17060000113758	L17/dossiers	17	17060000113745	17060000113757	1	2	BTA	PIONSNR5S279BTA0072
17060000113792	L17/dossiers	17	17060000113779	17060000113791	1	2	BTA	PIONSNR5S279BTA0100
17060000113835	L17/dossiers	17	17060000113822	17060000113834	1	2	BTA	PIONSNR5S299BTA0055
17060000113873	L17/dossiers	17	17060000113859	17060000113872	1	2	BTA	PIONSNR5S299BTA0008
17060000113902	L17/dossiers	17	17060000113889	17060000113901	1	2	BTA	PIONSNR5S299BTA0007
17060000113931	L17/dossiers	17	17060000113918	17060000113930	1	2	BTA	PIONSNR5S299BTA0009