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
16060000119975	L16/dossiers	16	16060000119958	16060000119974	1	2	BTA	PIONANR5L16BTA0259
16060000119976	L16/dossiers	16	16060000119958	16060000119974	2	2	TAP	PIONANR5L16TAP0259
16060000120111	L16/dossiers	16	16060000120097	16060000120110	1	2	BTA	PRJLSNR5S419BTA0085
16060000120126	L16/dossiers	16	16060000120097	16060000120125	1	2	BTA	PRJLANR5L16BTA0279
16060000120127	L16/dossiers	16	16060000120097	16060000120125	2	2	TAP	PRJLANR5L16TAP0279
16060000120360	L16/dossiers	16	16060000120344	16060000120359	1	2	BTA	PIONANR5L16BTA0257
16060000120382	L16/dossiers	16	16060000120366	16060000120381	1	2	BTA	PIONANR5L16BTA0258
16060000120383	L16/dossiers	16	16060000120366	16060000120381	2	2	TAP	PIONANR5L16TAP0258
16060000120466	L16/dossiers	16	16060000120453	16060000120465	1	2	BTA	PRJLSNR5S419BTA0102
16060000120485	L16/dossiers	16	16060000120453	16060000120484	1	2	BTA	PRJLANR5L16BTA0298
16060000120486	L16/dossiers	16	16060000120453	16060000120484	2	2	TAP	PRJLANR5L16TAP0298
16060000120501	L16/dossiers	16	16060000120487	16060000120500	1	2	BTA	PRJLSNR5S419BTA0072
16060000120517	L16/dossiers	16	16060000120487	16060000120516	1	2	BTA	PRJLANR5L16BTA0260
16060000120518	L16/dossiers	16	16060000120487	16060000120516	2	2	TAP	PRJLANR5L16TAP0260
16060000120588	L16/dossiers	16	16060000120572	16060000120587	1	2	BTA	PIONSNR5S419BTA0091
16060000120628	L16/dossiers	16	16060000120608	16060000120627	1	2	BTA	PIONANR5L16BTA0269
16060000120629	L16/dossiers	16	16060000120608	16060000120627	2	2	TAP	PIONANR5L16TAP0269
16060000120641	L16/dossiers	16	16060000120608	16060000120640	1	2	BTA	PIONSNR5S419BTA0135
16060000120655	L16/dossiers	16	16060000120608	16060000120654	1	2	BTA	PIONSNR5S419BTA0143
16060000120659	L16/dossiers	16	16060000120608	16060000120658	1	2	BTA	PIONANR5L16BTA0310
16060000120660	L16/dossiers	16	16060000120608	16060000120658	2	2	TAP	PIONANR5L16TAP0310
16060000120706	L16/dossiers	16	16060000120687	16060000120705	1	2	BTA	PRJLANR5L16BTA0288
16060000121057	L16/dossiers	16	16060000121044	16060000121056	1	2	BTA	PIONSNR5S419BTA0110
16060000121108	L16/dossiers	16	16060000121091	16060000121107	1	2	BTA	PIONANR5L16BTA0276
16060000121109	L16/dossiers	16	16060000121091	16060000121107	2	2	TAP	PIONANR5L16TAP0276
16060000121120	L16/dossiers	16	16060000121091	16060000121119	1	2	BTA	PIONSNR5S419BTA0140
16060000121155	L16/dossiers	16	16060000121138	16060000121154	1	2	BTA	PIONANR5L16BTA0277
16060000121156	L16/dossiers	16	16060000121138	16060000121154	2	2	TAP	PIONANR5L16TAP0277
16060000121272	L16/dossiers	16	16060000121258	16060000121271	1	2	BTA	PIONSNR5S419BTA0117
16060000121306	L16/dossiers	16	16060000121293	16060000121305	1	2	BTA	PIONSNR5S419BTA0116
16060000121394	L16/dossiers	16	16060000121387	16060000121393	1	2	BTA	RIONANR5L16BTA0273
16060000121492	L16/dossiers	16	16060000121476	16060000121491	1	2	BTA	RIONANR5L16BTA0301
16060000121961	L16/dossiers	16	16060000121943	16060000121960	1	2	BTA	PIONANR5L16BTA0290
16060000121962	L16/dossiers	16	16060000121943	16060000121960	2	2	TAP	PIONANR5L16TAP0290
16060000121973	L16/dossiers	16	16060000121943	16060000121972	1	2	BTA	PIONSNR5S419BTA0124
16060000121987	L16/dossiers	16	16060000121943	16060000121986	1	2	BTA	PIONSNR5S419BTA0142
16060000121991	L16/dossiers	16	16060000121943	16060000121990	1	2	BTA	PIONANR5L16BTA0308
16060000121992	L16/dossiers	16	16060000121943	16060000121990	2	2	TAP	PIONANR5L16TAP0308
16060000122080	L16/dossiers	16	16060000122066	16060000122079	1	2	BTA	PRJLSNR5S419BTA0133
16060000122105	L16/dossiers	16	16060000122090	16060000122104	1	2	BTA	RIONANR5L16BTA0294
16060000122256	L16/dossiers	16	16060000122243	16060000122255	1	2	BTA	PIONSNR5S419BTA0122
16060000122271	L16/dossiers	16	16060000122243	16060000122270	1	2	BTA	PIONANR5L16BTA0311
16060000122272	L16/dossiers	16	16060000122243	16060000122270	2	2	TAP	PIONANR5L16TAP0311
16060000122489	L16/dossiers	16	16060000122476	16060000122488	1	2	BTA	PIONSNR5S419BTA0138
16060000123009	L16/dossiers	16	16060000122955	16060000123008	1	2	BTA	PRJLANR5L16BTA0300
16060000123010	L16/dossiers	16	16060000122955	16060000123008	2	2	TAP	PRJLANR5L16TAP0300
16060000123075	L16/dossiers	16	16060000123062	16060000123074	1	2	BTA	PIONSNR5S419BTA0139
16060000123124	L16/dossiers	16	16060000123110	16060000123123	1	2	BTA	RIONANR5L16BTA0305
16060000123550	L16/dossiers	16	16060000123543	16060000123549	1	2	BTA	RIONANR5L16BTA0292
16060000123633	L16/dossiers	16	16060000123617	16060000123632	1	2	BTA	PIONANR5L16BTA0306