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
16060000092330L16/dossiers16160600000923181606000009232912BTAPIONSNR5S339BTA0059
16060000092353L16/dossiers16160600000923411606000009235212BTAPIONSNR5S339BTA0048
16060000092377L16/dossiers16160600000923641606000009237612BTAPIONSNR5S339BTA0056
16060000092431L16/dossiers16160600000923881606000009243012BTAPIONSNR5S339BTA0087
16060000092455L16/dossiers16160600000924421606000009245412BTAPIONSNR5S359BTA0057
16060000092499L16/dossiers16160600000924661606000009249812BTAPIONSNR5S339BTA0089
16060000092524L16/dossiers16160600000925101606000009252312BTAPIONSNR5S339BTA0114
16060000092552L16/dossiers16160600000925351606000009255112BTAPIONSNR5S339BTA0090
16060000092590L16/dossiers16160600000925631606000009258912BTAPIONSNR5S339BTA0094
16060000092616L16/dossiers16160600000926011606000009261512BTAPIONSNR5S339BTA0092
16060000092643L16/dossiers16160600000926271606000009264212BTAPIONSNR5S359BTA0044
16060000092668L16/dossiers16160600000926541606000009266712BTAPIONSNR5S359BTA0006
16060000092692L16/dossiers16160600000926791606000009269112BTAPIONSNR5S359BTA0005
16060000092715L16/dossiers16160600000927031606000009271412BTAPIONSNR5S359BTA0009
16060000092789L16/dossiers16160600000927261606000009278812BTAPIONSNR5S359BTA0029
16060000092812L16/dossiers16160600000928001606000009281112BTAPIONSNR5S359BTA0098
16060000092840L16/dossiers16160600000928231606000009283912BTAPIONSNR5S359BTA0042
16060000092865L16/dossiers16160600000928231606000009286412BTAPIONANR5L15BTA0625
16060000092866L16/dossiers16160600000928231606000009286422TAPPIONANR5L15TAP0625
16060000092875L16/dossiers16160600000928231606000009287412BTAPIONSNR5S379BTA0023
16060000092892L16/dossiers16160600000928801606000009289112BTAPIONSNR5S379BTA0029
16060000092919L16/dossiers16160600000929031606000009291812BTAPIONSNR5S359BTA0043
16060000092947L16/dossiers16160600000929301606000009294612BTAPRJLANR5L15BTA0670
16060000092958L16/dossiers16160600000929301606000009295712BTAPRJLSNR5S399BTA0025
16060000092973L16/dossiers16160600000929611606000009297212BTAPIONSNR5S359BTA0077
16060000092996L16/dossiers16160600000929841606000009299512BTAPIONSNR5S359BTA0078
16060000093021L16/dossiers16160600000930071606000009302012BTAPIONANR5L15BTA0554
16060000093022L16/dossiers16160600000930071606000009302022TAPPIONANR5L15TAP0554
16060000093034L16/dossiers16160600000930071606000009303312BTAPIONSNR5S379BTA0109
16060000093063L16/dossiers16160600000930391606000009306212BTAPIONANR5L15BTA0558
16060000093064L16/dossiers16160600000930391606000009306222TAPPIONANR5L15TAP0558
16060000093075L16/dossiers16160600000930391606000009307412BTAPIONSNR5S359BTA0163
16060000093092L16/dossiers16160600000930391606000009309112BTAPIONANR5L15BTA0688
16060000093093L16/dossiers16160600000930391606000009309122TAPPIONANR5L15TAP0688
16060000093097L16/dossiers16160600000930391606000009309612BTAPIONSNR5S379BTA0037
16060000093115L16/dossiers16160600000931031606000009311412BTAPIONSNR5S359BTA0079
16060000093218L16/dossiers16160600000931261606000009321712BTAPRJLANR5L15BTA0602
16060000093219L16/dossiers16160600000931261606000009321722TAPPRJLANR5L15TAP0602
16060000093233L16/dossiers16160600000931261606000009323212BTAPRJLSNR5S359BTA0130
16060000093250L16/dossiers16160600000931261606000009324912BTAPRJLSNR5S359BTA0140
16060000093254L16/dossiers16160600000931261606000009325312BTAPRJLANR5L15BTA0651
16060000093255L16/dossiers16160600000931261606000009325322TAPPRJLANR5L15TAP0651
16060000093276L16/dossiers16160600000932641606000009327512BTAPIONSNR5S359BTA0096
16060000093300L16/dossiers16160600000932871606000009329912BTAPIONSNR5S359BTA0095
16060000093323L16/dossiers16160600000933111606000009332212BTAPIONSNR5S359BTA0123
16060000093338L16/dossiers16160600000933111606000009333712BTAPIONANR5L15BTA0680
16060000093339L16/dossiers16160600000933111606000009333722TAPPIONANR5L15TAP0680
16060000093349L16/dossiers16160600000933111606000009334812BTAPIONSNR5S399BTA0087
16060000093365L16/dossiers16160600000933521606000009336412BTAPIONSNR5S359BTA0114
16060000093389L16/dossiers16160600000933761606000009338812BTAPIONSNR5S379BTA0051