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
16060000105111	L16/dossiers	16	16060000105038	16060000105110	1	2	BTA	PRJLSNR5S399BTA0068
16060000105125	L16/dossiers	16	16060000105038	16060000105124	1	2	BTA	PRJLSNR5S399BTA0073
16060000105132	L16/dossiers	16	16060000105038	16060000105131	1	2	BTA	PRJLANR5L16BTA0091
16060000105133	L16/dossiers	16	16060000105038	16060000105131	2	2	TAP	PRJLANR5L16TAP0091
16060000105204	L16/dossiers	16	16060000105188	16060000105203	1	2	BTA	PIONANR5L16BTA0095
16060000105205	L16/dossiers	16	16060000105188	16060000105203	2	2	TAP	PIONANR5L16TAP0095
16060000105216	L16/dossiers	16	16060000105188	16060000105215	1	2	BTA	PIONSNR5S399BTA0108
16060000105229	L16/dossiers	16	16060000105188	16060000105228	1	2	BTA	PIONANR5L16BTA0131
16060000105230	L16/dossiers	16	16060000105188	16060000105228	2	2	TAP	PIONANR5L16TAP0131
16060000105253	L16/dossiers	16	16060000105233	16060000105252	1	2	BTA	PIONANR5L16BTA0100
16060000105254	L16/dossiers	16	16060000105233	16060000105252	2	2	TAP	PIONANR5L16TAP0100
16060000105265	L16/dossiers	16	16060000105233	16060000105264	1	2	BTA	PIONSNR5S399BTA0105
16060000105280	L16/dossiers	16	16060000105233	16060000105279	1	2	BTA	PIONANR5L16BTA0122
16060000105281	L16/dossiers	16	16060000105233	16060000105279	2	2	TAP	PIONANR5L16TAP0122
16060000105284	L16/dossiers	16	16060000105233	16060000105283	1	2	BTA	PIONSNR5S399BTA0123
16060000105359	L16/dossiers	16	16060000105352	16060000105358	1	2	BTA	RIONANR5L16BTA0097
16060000105386	L16/dossiers	16	16060000105367	16060000105385	1	2	BTA	PIONANR5L16BTA0098
16060000105387	L16/dossiers	16	16060000105367	16060000105385	2	2	TAP	PIONANR5L16TAP0098
16060000105398	L16/dossiers	16	16060000105367	16060000105397	1	2	BTA	PIONSNR5S399BTA0142
16060000105409	L16/dossiers	16	16060000105367	16060000105408	1	2	BTA	PIONANR5L16BTA0162
16060000105410	L16/dossiers	16	16060000105367	16060000105408	2	2	TAP	PIONANR5L16TAP0162
16060000105538	L16/dossiers	16	16060000105523	16060000105537	1	2	BTA	PRJLSNR5S419BTA0019
16060000105574	L16/dossiers	16	16060000105523	16060000105573	1	2	BTA	PRJLANR5L16BTA0213
16060000105589	L16/dossiers	16	16060000105523	16060000105588	1	2	BTA	PRJLSNR5S419BTA0043
16060000105593	L16/dossiers	16	16060000105523	16060000105592	1	2	BTA	PRJLANR5L16BTA0220
16060000105594	L16/dossiers	16	16060000105523	16060000105592	2	2	TAP	PRJLANR5L16TAP0220
16060000105798	L16/dossiers	16	16060000105786	16060000105797	1	2	BTA	PIONSNR5S399BTA0091
16060000106056	L16/dossiers	16	16060000106038	16060000106055	1	2	BTA	PRJLANR5L16BTA0107
16060000106067	L16/dossiers	16	16060000106038	16060000106066	1	2	BTA	PRJLSNR5S399BTA0118
16060000106085	L16/dossiers	16	16060000106070	16060000106084	1	2	BTA	PIONSNR5S399BTA0112
16060000106151	L16/dossiers	16	16060000106135	16060000106150	1	2	BTA	PIONANR5L16BTA0103
16060000106152	L16/dossiers	16	16060000106135	16060000106150	2	2	TAP	PIONANR5L16TAP0103
16060000106163	L16/dossiers	16	16060000106135	16060000106162	1	2	BTA	PIONSNR5S419BTA0141
16060000106185	L16/dossiers	16	16060000106169	16060000106184	1	2	BTA	PIONANR5L16BTA0102
16060000106272	L16/dossiers	16	16060000106259	16060000106271	1	2	BTA	PIONSNR5S419BTA0119
16060000106404	L16/dossiers	16	16060000106390	16060000106403	1	2	BTA	PIONSNR5S399BTA0109
16060000106419	L16/dossiers	16	16060000106390	16060000106418	1	2	BTA	PIONANR5L16BTA0207
16060000106420	L16/dossiers	16	16060000106390	16060000106418	2	2	TAP	PIONANR5L16TAP0207
16060000106456	L16/dossiers	16	16060000106437	16060000106455	1	2	BTA	PRJLANR5L16BTA0147
16060000106467	L16/dossiers	16	16060000106437	16060000106466	1	2	BTA	PRJLSNR5S419BTA0012
16060000106503	L16/dossiers	16	16060000106490	16060000106502	1	2	BTA	PRJLSNR5S399BTA0115
16060000106517	L16/dossiers	16	16060000106490	16060000106516	1	2	BTA	PRJLANR5L16BTA0161
16060000106566	L16/dossiers	16	16060000106559	16060000106565	1	2	BTA	RIONANR5L16BTA0116
16060000106744	L16/dossiers	16	16060000106731	16060000106743	1	2	BTA	PIONSNR5S399BTA0121
16060000107121	L16/dossiers	16	16060000107105	16060000107120	1	2	BTA	PIONANR5L16BTA0109
16060000107122	L16/dossiers	16	16060000107105	16060000107120	2	2	TAP	PIONANR5L16TAP0109
16060000107512	L16/dossiers	16	16060000107499	16060000107511	1	2	BTA	PRJLSNR5S419BTA0011
16060000107526	L16/dossiers	16	16060000107499	16060000107525	1	2	BTA	PRJLANR5L16BTA0222
16060000107560	L16/dossiers	16	16060000107543	16060000107559	1	2	BTA	PIONANR5L16BTA0114
16060000107561	L16/dossiers	16	16060000107543	16060000107559	2	2	TAP	PIONANR5L16TAP0114