AN · données ouvertes
Explorateur / dossiers

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

#ColonneTypeCommentaire
1_idBIGINTidentifiant : code de la source × 10¹⁰ + rang
2_sourceVARCHARsource du catalogue (catalogue.py)
3_legislatureBIGINTcolonne constante de la source
4_racine_idBIGINT_id de la ligne racine
5_parent_idBIGINT_id de la ligne parente
6_ordreBIGINTrang dans le tableau d'origine (1…)
7_parent_recursif_idBIGINT_id de la ligne de même table qui contient celle-ci (structure récursive)
8_niveauBIGINTprofondeur dans la structure récursive (0 = premier niveau)
9type_texteVARCHARdossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie.typeTexte · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 %
10ref_texte_associeVARCHARdossierParlementaire.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_parent_recursif_id_niveautype_texteref_texte_associe
16060000099053L16/dossiers16160600000989241606000009905122TAPPRJLANR5L16TAP0046
16060000099266L16/dossiers16160600000992541606000009926512BTAPIONSNR5S399BTA0074
16060000099393L16/dossiers16160600000993781606000009939212BTAPIONSNR5S399BTA0045
16060000099406L16/dossiers16160600000993781606000009940512BTAPIONANR5L16BTA0133
16060000099407L16/dossiers16160600000993781606000009940522TAPPIONANR5L16TAP0133
16060000099457L16/dossiers16160600000994381606000009945612BTAPIONANR5L16BTA0034
16060000099458L16/dossiers16160600000994381606000009945622TAPPIONANR5L16TAP0034
16060000099469L16/dossiers16160600000994381606000009946812BTAPIONSNR5S399BTA0048
16060000099693L16/dossiers16160600000996801606000009969212BTAPIONSNR5S399BTA0032
16060000099707L16/dossiers16160600000996801606000009970612BTAPIONANR5L16BTA0070
16060000099708L16/dossiers16160600000996801606000009970622TAPPIONANR5L16TAP0070
16060000099724L16/dossiers16160600000997111606000009972312BTAPIONSNR5S399BTA0098
16060000099879L16/dossiers16160600000998611606000009987812BTAPIONANR5L16BTA0044
16060000099880L16/dossiers16160600000998611606000009987822TAPPIONANR5L16TAP0044
16060000099926L16/dossiers16160600000999071606000009992512BTAPIONANR5L16BTA0043
16060000099945L16/dossiers16160600000999271606000009994412BTAPIONANR5L16BTA0041
16060000099946L16/dossiers16160600000999271606000009994422TAPPIONANR5L16TAP0041
16060000099957L16/dossiers16160600000999271606000009995612BTAPIONSNR5S399BTA0049
16060000099978L16/dossiers16160600000999601606000009997712BTAPIONANR5L16BTA0042
16060000100065L16/dossiers16160600001000461606000010006412BTAPIONANR5L16BTA0045
16060000100066L16/dossiers16160600001000461606000010006422TAPPIONANR5L16TAP0045
16060000100077L16/dossiers16160600001000461606000010007612BTAPIONSNR5S399BTA0051
16060000100092L16/dossiers16160600001000461606000010009112BTAPIONANR5L16BTA0101
16060000100093L16/dossiers16160600001000461606000010009122TAPPIONANR5L16TAP0101
16060000100102L16/dossiers16160600001000461606000010010112BTAPIONSNR5S399BTA0134
16060000100124L16/dossiers16160600001001081606000010012312BTAPIONANR5L16BTA0038
16060000100125L16/dossiers16160600001001081606000010012322TAPPIONANR5L16TAP0038
16060000100136L16/dossiers16160600001001081606000010013512BTAPIONSNR5S399BTA0056
16060000100148L16/dossiers16160600001001081606000010014712BTAPIONANR5L16BTA0099
16060000100149L16/dossiers16160600001001081606000010014722TAPPIONANR5L16TAP0099
16060000100159L16/dossiers16160600001001081606000010015812BTAPIONSNR5S399BTA0104
16060000100182L16/dossiers16160600001001621606000010018112BTAPIONANR5L16BTA0065
16060000100183L16/dossiers16160600001001621606000010018122TAPPIONANR5L16TAP0065
16060000100194L16/dossiers16160600001001621606000010019312BTAPIONSNR5S399BTA0057
16060000100208L16/dossiers16160600001001621606000010020712BTAPIONSNR5S399BTA0103
16060000100212L16/dossiers16160600001001621606000010021112BTAPIONANR5L16BTA0112
16060000100213L16/dossiers16160600001001621606000010021122TAPPIONANR5L16TAP0112
16060000100264L16/dossiers16160600001002521606000010026312BTAPIONSNR5S399BTA0070
16060000100497L16/dossiers16160600001004821606000010049612BTAPIONSNR5S399BTA0139
16060000100563L16/dossiers16160600001005501606000010056212BTAPRJLSNR5S399BTA0078
16060000100579L16/dossiers16160600001005501606000010057812BTAPRJLANR5L16BTA0148
16060000100599L16/dossiers16160600001005891606000010059812BTAPRJLSNR5S399BTA0016
16060000100642L16/dossiers16160600001005891606000010064112BTAPRJLANR5L16BTA0052
16060000100643L16/dossiers16160600001005891606000010064122TAPPRJLANR5L16TAP0052
16060000100661L16/dossiers16160600001005891606000010066012BTAPRJLANR5L16BTA0072
16060000100662L16/dossiers16160600001005891606000010066022TAPPRJLANR5L16TAP0072
16060000100665L16/dossiers16160600001005891606000010066412BTAPRJLSNR5S399BTA0053
16060000100935L16/dossiers16160600001009271606000010093412BTARIONANR5L16BTA0037
16060000100950L16/dossiers16160600001009421606000010094912BTARIONANR5L16BTA0039
16060000101040L16/dossiers16160600001010321606000010103912BTARIONANR5L16BTA0040