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
16060000123634	L16/dossiers	16	16060000123617	16060000123632	2	2	TAP	PIONANR5L16TAP0306
16060000123673	L16/dossiers	16	16060000123656	16060000123672	1	2	BTA	PIONANR5L16BTA0307
16060000123674	L16/dossiers	16	16060000123656	16060000123672	2	2	TAP	PIONANR5L16TAP0307
16060000124507	L16/dossiers	16	16060000124500	16060000124506	1	2	BTA	RIONANR5L16BTA0304
16060000124746	L16/dossiers	16	16060000124728	16060000124745	1	2	BTA	PRJLANR5L16BTA0302
16060000125384	L16/dossiers	16	16060000125371	16060000125383	1	2	BTA	PIONSNR5S156BTA0070
16060000125428	L16/dossiers	16	16060000125415	16060000125427	1	2	BTA	PIONSNR5S160BTA0059
15060000129495	L15/dossiers	15	15060000129471	15060000129494	1	2	BTA	PRJLSNR5S279BTA0114
15060000129521	L15/dossiers	15	15060000129471	15060000129520	1	2	BTA	PRJLANR5L15BTA0009
15060000129545	L15/dossiers	15	15060000129471	15060000129544	1	2	BTA	PRJLANR5L15BTA0017
15060000129555	L15/dossiers	15	15060000129471	15060000129554	1	2	BTA	PRJLSNR5S279BTA0128
15060000129566	L15/dossiers	15	15060000129471	15060000129565	1	2	BTA	PRJLANR5L15BTA0018
15060000129585	L15/dossiers	15	15060000129572	15060000129584	1	2	BTA	PRJLSNR5S279BTA0111
15060000129600	L15/dossiers	15	15060000129572	15060000129599	1	2	BTA	PRJLANR5L15BTA0001
15060000129666	L15/dossiers	15	15060000129627	15060000129665	1	2	BTA	PRJLANR5L15BTA0002
15060000129686	L15/dossiers	15	15060000129627	15060000129685	1	2	BTA	PRJLSNR5S279BTA0125
15060000129700	L15/dossiers	15	15060000129627	15060000129699	1	2	BTA	PRJLANR5L15BTA0010
15060000129704	L15/dossiers	15	15060000129627	15060000129703	1	2	BTA	PRJLSNR5S279BTA0127
15060000129729	L15/dossiers	15	15060000129711	15060000129728	1	2	BTA	PRJLANR5L15BTA0003
15060000129739	L15/dossiers	15	15060000129711	15060000129738	1	2	BTA	PRJLSNR5S279BTA0123
15060000129761	L15/dossiers	15	15060000129742	15060000129760	1	2	BTA	PRJLANR5L15BTA0011
15060000129773	L15/dossiers	15	15060000129742	15060000129772	1	2	BTA	PRJLSNR5S299BTA0013
15060000129795	L15/dossiers	15	15060000129776	15060000129794	1	2	BTA	PRJLANR5L15BTA0004
15060000129807	L15/dossiers	15	15060000129776	15060000129806	1	2	BTA	PRJLSNR5S299BTA0001
15060000129821	L15/dossiers	15	15060000129776	15060000129820	1	2	BTA	PRJLANR5L15BTA0082
15060000129822	L15/dossiers	15	15060000129776	15060000129820	2	2	TAP	PRJLANR5L15TAP0082
15060000129826	L15/dossiers	15	15060000129776	15060000129825	1	2	BTA	PRJLSNR5S299BTA0065
15060000129851	L15/dossiers	15	15060000129830	15060000129850	1	2	BTA	PRJLANR5L15BTA0058
15060000129863	L15/dossiers	15	15060000129830	15060000129862	1	2	BTA	PRJLSNR5S299BTA0064
15060000129885	L15/dossiers	15	15060000129866	15060000129884	1	2	BTA	PRJLANR5L15BTA0014
15060000129897	L15/dossiers	15	15060000129866	15060000129896	1	2	BTA	PRJLSNR5S299BTA0012
15060000129920	L15/dossiers	15	15060000129900	15060000129919	1	2	BTA	PRJLANR5L15BTA0006
15060000129932	L15/dossiers	15	15060000129900	15060000129931	1	2	BTA	PRJLSNR5S299BTA0003
15060000129953	L15/dossiers	15	15060000129900	15060000129952	1	2	BTA	PRJLANR5L15BTA0060
15060000129954	L15/dossiers	15	15060000129900	15060000129952	2	2	TAP	PRJLANR5L15TAP0060
15060000129964	L15/dossiers	15	15060000129900	15060000129963	1	2	BTA	PRJLSNR5S299BTA0050
15060000129973	L15/dossiers	15	15060000129900	15060000129972	1	2	BTA	PRJLANR5L15BTA0088
15060000129974	L15/dossiers	15	15060000129900	15060000129972	2	2	TAP	PRJLANR5L15TAP0088
15060000129996	L15/dossiers	15	15060000129977	15060000129995	1	2	BTA	PRJLANR5L15BTA0007
15060000130008	L15/dossiers	15	15060000129977	15060000130007	1	2	BTA	PRJLSNR5S299BTA0004
15060000130022	L15/dossiers	15	15060000129977	15060000130021	1	2	BTA	PRJLANR5L15BTA0059
15060000130023	L15/dossiers	15	15060000129977	15060000130021	2	2	TAP	PRJLANR5L15TAP0059
15060000130027	L15/dossiers	15	15060000129977	15060000130026	1	2	BTA	PRJLSNR5S299BTA0040
15060000130051	L15/dossiers	15	15060000130032	15060000130050	1	2	BTA	PRJLANR5L15BTA0005
15060000130063	L15/dossiers	15	15060000130032	15060000130062	1	2	BTA	PRJLSNR5S299BTA0002
15060000130086	L15/dossiers	15	15060000130073	15060000130085	1	2	BTA	PRJLSNR5S299BTA0097
15060000130101	L15/dossiers	15	15060000130073	15060000130100	1	2	BTA	PRJLANR5L15BTA0252
15060000130117	L15/dossiers	15	15060000130104	15060000130116	1	2	BTA	PRJLSNR5S299BTA0036
15060000130132	L15/dossiers	15	15060000130104	15060000130131	1	2	BTA	PRJLANR5L15BTA0380
15060000130485	L15/dossiers	15	15060000130146	15060000130484	1	2	BTA	PRJLANR5L15BTA0033