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
16060000110185L16/dossiers16160600001101131606000011018412BTAPRJLSNR5S419BTA0004
16060000110205L16/dossiers16160600001101921606000011020412BTAPIONSNR5S399BTA0138
16060000110221L16/dossiers16160600001101921606000011022012BTAPIONANR5L16BTA0185
16060000110222L16/dossiers16160600001101921606000011022022TAPPIONANR5L16TAP0185
16060000110311L16/dossiers16160600001102941606000011031012BTAPIONANR5L16BTA0232
16060000110312L16/dossiers16160600001102941606000011031022TAPPIONANR5L16TAP0232
16060000110515L16/dossiers16160600001104961606000011051412BTAPRJLANR5L16BTA0167
16060000110526L16/dossiers16160600001104961606000011052512BTAPRJLSNR5S419BTA0086
16060000110660L16/dossiers16160600001105961606000011065912BTAPIONSNR5S419BTA0115
16060000110680L16/dossiers16160600001106661606000011067912BTAPRJLSNR5S399BTA0156
16060000110718L16/dossiers16160600001106661606000011071712BTAPRJLANR5L16BTA0175
16060000110719L16/dossiers16160600001106661606000011071722TAPPRJLANR5L16TAP0175
16060000110738L16/dossiers16160600001106661606000011073712BTAPRJLSNR5S419BTA0103
16060000110742L16/dossiers16160600001106661606000011074112BTAPRJLANR5L16BTA0286
16060000110743L16/dossiers16160600001106661606000011074122TAPPRJLANR5L16TAP0286
16060000110807L16/dossiers16160600001108001606000011080612BTARIONANR5L16BTA0128
16060000110828L16/dossiers16160600001108151606000011082712BTAPRJLSNR5S399BTA0144
16060000110863L16/dossiers16160600001108151606000011086212BTAPRJLANR5L16BTA0164
16060000110864L16/dossiers16160600001108151606000011086222TAPPRJLANR5L16TAP0164
16060000110882L16/dossiers16160600001108151606000011088112BTAPRJLANR5L16BTA0173
16060000110883L16/dossiers16160600001108151606000011088122TAPPRJLANR5L16TAP0173
16060000110886L16/dossiers16160600001108151606000011088512BTAPRJLSNR5S419BTA0005
16060000110959L16/dossiers16160600001109521606000011095812BTAPNREANR5L16BTA0129
16060000111019L16/dossiers16160600001110021606000011101812BTAPIONANR5L16BTA0123
16060000111031L16/dossiers16160600001110021606000011103012BTAPIONSNR5S399BTA0126
16060000111051L16/dossiers16160600001110021606000011105012BTAPIONANR5L16BTA0139
16060000111052L16/dossiers16160600001110021606000011105022TAPPIONANR5L16TAP0139
16060000111061L16/dossiers16160600001110021606000011106012BTAPIONSNR5S399BTA0143
16060000111071L16/dossiers16160600001110021606000011107012BTAPIONANR5L16BTA0145
16060000111072L16/dossiers16160600001110021606000011107022TAPPIONANR5L16TAP0145
16060000111105L16/dossiers16160600001110811606000011110412BTAPRJLANR5L16BTA0126
16060000111116L16/dossiers16160600001110811606000011111512BTAPRJLSNR5S399BTA0154
16060000111151L16/dossiers16160600001111171606000011115012BTAPRJLANR5L16BTA0149
16060000111152L16/dossiers16160600001111171606000011115022TAPPRJLANR5L16TAP0149
16060000111163L16/dossiers16160600001111171606000011116212BTAPRJLSNR5S419BTA0007
16060000111176L16/dossiers16160600001111171606000011117512BTAPRJLSNR5S419BTA0020
16060000111181L16/dossiers16160600001111171606000011118012BTAPRJLANR5L16BTA0187
16060000111182L16/dossiers16160600001111171606000011118022TAPPRJLANR5L16TAP0187
16060000111302L16/dossiers16160600001112831606000011130112BTAPIONSNR5S419BTA0002
16060000111319L16/dossiers16160600001112831606000011131812BTAPIONANR5L16BTA0240
16060000111320L16/dossiers16160600001112831606000011131822TAPPIONANR5L16TAP0240
16060000111334L16/dossiers16160600001112831606000011133312BTAPIONANR5L16BTA0255
16060000111335L16/dossiers16160600001112831606000011133322TAPPIONANR5L16TAP0255
16060000111339L16/dossiers16160600001112831606000011133812BTAPIONSNR5S419BTA0084
16060000111390L16/dossiers16160600001113711606000011138912BTAPRJLANR5L16BTA0218
16060000111391L16/dossiers16160600001113711606000011138922TAPPRJLANR5L16TAP0218
16060000111403L16/dossiers16160600001113711606000011140212BTAPRJLSNR5S419BTA0107
16060000111835L16/dossiers16160600001118261606000011183412BTAPNREANR5L16BTA0210
16060000111883L16/dossiers16160600001118691606000011188212BTAPRJLSNR5S399BTA0158
16060000111922L16/dossiers16160600001118691606000011192112BTAPRJLANR5L16BTA0170