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
17060000116719L17/dossiers17170600001167011706000011671722TAPPIONANR5L16TAP0205
17060000116731L17/dossiers17170600001167011706000011673012BTAPIONSNR5S419BTA0065
17060000116753L17/dossiers17170600001167011706000011675212BTAPIONSNR5S459BTA0054
17060000116758L17/dossiers17170600001167011706000011675712BTAPIONANR5L17BTA0041
17060000116759L17/dossiers17170600001167011706000011675722TAPPIONANR5L17TAP0041
17060000116775L17/dossiers17170600001167631706000011677412BTAPIONSNR5S399BTA0066
17060000116798L17/dossiers17170600001167861706000011679712BTAPIONSNR5S399BTA0075
17060000116828L17/dossiers17170600001168091706000011682712BTAPIONANR5L16BTA0087
17060000116829L17/dossiers17170600001168091706000011682722TAPPIONANR5L16TAP0087
17060000116841L17/dossiers17170600001168091706000011684012BTAPIONSNR5S419BTA0064
17060000116866L17/dossiers17170600001168521706000011686512BTAPIONSNR5S399BTA0071
17060000116889L17/dossiers17170600001168771706000011688812BTAPIONSNR5S399BTA0091
17060000116915L17/dossiers17170600001169001706000011691412BTAPIONSNR5S399BTA0112
17060000116942L17/dossiers17170600001169261706000011694112BTAPIONANR5L16BTA0103
17060000116943L17/dossiers17170600001169261706000011694122TAPPIONANR5L16TAP0103
17060000116954L17/dossiers17170600001169261706000011695312BTAPIONSNR5S419BTA0141
17060000116978L17/dossiers17170600001169651706000011697712BTAPIONSNR5S419BTA0119
17060000117002L17/dossiers17170600001169891706000011700112BTAPIONSNR5S399BTA0121
17060000117026L17/dossiers17170600001170131706000011702512BTAPIONSNR5S419BTA0057
17060000117049L17/dossiers17170600001170371706000011704812BTAPIONSNR5S419BTA0025
17060000117124L17/dossiers17170600001170601706000011712312BTAPRJLANR5L16BTA0127
17060000117125L17/dossiers17170600001170601706000011712322TAPPRJLANR5L16TAP0127
17060000117136L17/dossiers17170600001170601706000011713512BTAPRJLSNR5S399BTA0148
17060000117152L17/dossiers17170600001170601706000011715112BTAPRJLANR5L16BTA0155
17060000117153L17/dossiers17170600001170601706000011715122TAPPRJLANR5L16TAP0155
17060000117157L17/dossiers17170600001170601706000011715612BTAPRJLSNR5S399BTA0162
17060000117179L17/dossiers17170600001171661706000011717812BTAPIONSNR5S399BTA0128
17060000117201L17/dossiers17170600001171901706000011720012BTAPIONSNR5S419BTA0001
17060000117225L17/dossiers17170600001172121706000011722412BTAPIONSNR5S399BTA0137
17060000117242L17/dossiers17170600001172121706000011724112BTAPIONANR5L17BTA0147
17060000117243L17/dossiers17170600001172121706000011724122TAPPIONANR5L17TAP0147
17060000117258L17/dossiers17170600001172461706000011725712BTAPIONSNR5S399BTA0132
17060000117302L17/dossiers17170600001172461706000011730112BTAPIONANR5L17BTA0153
17060000117313L17/dossiers17170600001172461706000011731212BTAPIONSNR5S459BTA0175
17060000117338L17/dossiers17170600001173191706000011733712BTAPIONANR5L16BTA0231
17060000117339L17/dossiers17170600001173191706000011733722TAPPIONANR5L16TAP0231
17060000117351L17/dossiers17170600001173191706000011735012BTAPIONSNR5S419BTA0131
17060000117367L17/dossiers17170600001173191706000011736612BTAPIONANR5L17BTA0007
17060000117368L17/dossiers17170600001173191706000011736622TAPPIONANR5L17TAP0007
17060000117440L17/dossiers17170600001173761706000011743912BTAPIONSNR5S419BTA0115
17060000117467L17/dossiers17170600001174511706000011746612BTAPIONANR5L16BTA0209
17060000117468L17/dossiers17170600001174511706000011746622TAPPIONANR5L16TAP0209
17060000117480L17/dossiers17170600001174511706000011747912BTAPIONSNR5S419BTA0082
17060000117523L17/dossiers17170600001175011706000011752212BTAPIONSNR5S459BTA0043
17060000117589L17/dossiers17170600001175291706000011758812BTAPIONSNR5S419BTA0055
17060000117613L17/dossiers17170600001176001706000011761212BTAPIONSNR5S419BTA0056
17060000117629L17/dossiers17170600001176001706000011762812BTAPIONANR5L16BTA0296
17060000117630L17/dossiers17170600001176001706000011762822TAPPIONANR5L16TAP0296
17060000117640L17/dossiers17170600001176001706000011763912BTAPIONSNR5S459BTA0015
17060000117680L17/dossiers17170600001176431706000011767912BTAPIONSNR5S419BTA0026