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
16060000103904L16/dossiers16160600001038241606000010390312BTAPIONSNR5S419BTA0109
16060000104046L16/dossiers16160600001040221606000010404512BTAPIONANR5L16BTA0073
16060000104047L16/dossiers16160600001040221606000010404522TAPPIONANR5L16TAP0073
16060000104058L16/dossiers16160600001040221606000010405712BTAPIONSNR5S399BTA0083
16060000104072L16/dossiers16160600001040221606000010407112BTAPIONANR5L16BTA0105
16060000104073L16/dossiers16160600001040221606000010407122TAPPIONANR5L16TAP0105
16060000104076L16/dossiers16160600001040221606000010407512BTAPIONSNR5S399BTA0094
16060000104222L16/dossiers16160600001042031606000010422112BTAPRJLANR5L16BTA0106
16060000104234L16/dossiers16160600001042031606000010423312BTAPRJLSNR5S399BTA0160
16060000104290L16/dossiers16160600001042711606000010428912BTAPIONSNR5S399BTA0086
16060000104332L16/dossiers16160600001042711606000010433112BTAPIONANR5L16BTA0118
16060000104333L16/dossiers16160600001042711606000010433122TAPPIONANR5L16TAP0118
16060000104354L16/dossiers16160600001042711606000010435312BTAPIONANR5L16BTA0144
16060000104355L16/dossiers16160600001042711606000010435322TAPPIONANR5L16TAP0144
16060000104358L16/dossiers16160600001042711606000010435712BTAPIONSNR5S399BTA0145
16060000104448L16/dossiers16160600001044311606000010444712BTAPIONANR5L16BTA0088
16060000104449L16/dossiers16160600001044311606000010444722TAPPIONANR5L16TAP0088
16060000104460L16/dossiers16160600001044311606000010445912BTAPIONSNR5S399BTA0099
16060000104474L16/dossiers16160600001044311606000010447312BTAPIONANR5L16BTA0135
16060000104475L16/dossiers16160600001044311606000010447322TAPPIONANR5L16TAP0135
16060000104478L16/dossiers16160600001044311606000010447712BTAPIONSNR5S399BTA0147
16060000104519L16/dossiers16160600001045071606000010451812BTAPIONSNR5S399BTA0136
16060000104533L16/dossiers16160600001045071606000010453212BTAPIONANR5L16BTA0244
16060000104534L16/dossiers16160600001045071606000010453222TAPPIONANR5L16TAP0244
16060000104588L16/dossiers16160600001045721606000010458712BTAPIONANR5L16BTA0204
16060000104589L16/dossiers16160600001045721606000010458722TAPPIONANR5L16TAP0204
16060000104631L16/dossiers16160600001046151606000010463012BTAPIONANR5L16BTA0082
16060000104632L16/dossiers16160600001046151606000010463022TAPPIONANR5L16TAP0082
16060000104643L16/dossiers16160600001046151606000010464212BTAPIONSNR5S399BTA0114
16060000104658L16/dossiers16160600001046151606000010465712BTAPIONANR5L16BTA0143
16060000104659L16/dossiers16160600001046151606000010465722TAPPIONANR5L16TAP0143
16060000104662L16/dossiers16160600001046151606000010466112BTAPIONSNR5S399BTA0146
16060000104700L16/dossiers16160600001046821606000010469912BTAPIONANR5L16BTA0083
16060000104701L16/dossiers16160600001046821606000010469922TAPPIONANR5L16TAP0083
16060000104712L16/dossiers16160600001046821606000010471112BTAPIONSNR5S399BTA0155
16060000104726L16/dossiers16160600001046821606000010472512BTAPIONSNR5S399BTA0159
16060000104731L16/dossiers16160600001046821606000010473012BTAPIONANR5L16BTA0154
16060000104732L16/dossiers16160600001046821606000010473022TAPPIONANR5L16TAP0154
16060000104806L16/dossiers16160600001047881606000010480512BTAPIONANR5L16BTA0086
16060000104807L16/dossiers16160600001047881606000010480522TAPPIONANR5L16TAP0086
16060000104832L16/dossiers16160600001048131606000010483112BTAPIONANR5L16BTA0084
16060000104833L16/dossiers16160600001048131606000010483122TAPPIONANR5L16TAP0084
16060000104844L16/dossiers16160600001048131606000010484312BTAPIONSNR5S399BTA0107
16060000104866L16/dossiers16160600001048131606000010486512BTAPIONANR5L16BTA0174
16060000104867L16/dossiers16160600001048131606000010486522TAPPIONANR5L16TAP0174
16060000104878L16/dossiers16160600001048131606000010487712BTAPIONSNR5S419BTA0042
16060000104889L16/dossiers16160600001048131606000010488812BTAPIONANR5L16BTA0239
16060000104890L16/dossiers16160600001048131606000010488822TAPPIONANR5L16TAP0239
16060000104964L16/dossiers16160600001049471606000010496312BTAPIONANR5L16BTA0085
16060000104993L16/dossiers16160600001049791606000010499212BTAPIONSNR5S399BTA0071