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
16060000094205L16/dossiers16160600000941851606000009420412BTAPRJLANR5L15BTA0741
16060000094206L16/dossiers16160600000941851606000009420422TAPPRJLANR5L15TAP0741
16060000094218L16/dossiers16160600000941851606000009421712BTAPRJLSNR5S379BTA0090
16060000094232L16/dossiers16160600000941851606000009423112BTAPRJLANR5L15BTA0810
16060000094233L16/dossiers16160600000941851606000009423122TAPPRJLANR5L15TAP0810
16060000094237L16/dossiers16160600000941851606000009423612BTAPRJLSNR5S379BTA0117
16060000094260L16/dossiers16160600000942431606000009425912BTAPIONANR5L15BTA0761
16060000094261L16/dossiers16160600000942431606000009425922TAPPIONANR5L15TAP0761
16060000094272L16/dossiers16160600000942431606000009427112BTAPIONSNR5S399BTA0035
16060000094287L16/dossiers16160600000942751606000009428612BTAPIONSNR5S419BTA0033
16060000094310L16/dossiers16160600000942931606000009430912BTAPIONANR5L15BTA0802
16060000094311L16/dossiers16160600000942931606000009430922TAPPIONANR5L15TAP0802
16060000094322L16/dossiers16160600000942931606000009432112BTAPIONSNR5S379BTA0129
16060000094338L16/dossiers16160600000942931606000009433712BTAPIONSNR5S379BTA0139
16060000094342L16/dossiers16160600000942931606000009434112BTAPIONANR5L16BTA0007
16060000094343L16/dossiers16160600000942931606000009434122TAPPIONANR5L16TAP0007
16060000094367L16/dossiers16160600000943501606000009436612BTAPRJLANR5L15BTA0808
16060000094379L16/dossiers16160600000943501606000009437812BTAPRJLSNR5S379BTA0132
16060000094396L16/dossiers16160600000943821606000009439512BTAPRJLSNR5S379BTA0097
16060000094415L16/dossiers16160600000943821606000009441412BTAPRJLANR5L16BTA0015
16060000094432L16/dossiers16160600000944181606000009443112BTAPRJLSNR5S379BTA0110
16060000094453L16/dossiers16160600000944181606000009445212BTAPRJLANR5L16BTA0008
16060000094454L16/dossiers16160600000944181606000009445222TAPPRJLANR5L16TAP0008
16060000094468L16/dossiers16160600000944181606000009446712BTAPRJLSNR5S379BTA0146
16060000094472L16/dossiers16160600000944181606000009447112BTAPRJLANR5L16BTA0014
16060000094473L16/dossiers16160600000944181606000009447122TAPPRJLANR5L16TAP0014
16060000094490L16/dossiers16160600000944771606000009448912BTAPRJLSNR5S379BTA0130
16060000094514L16/dossiers16160600000945021606000009451312BTAPRJLSNR5S399BTA0011
16060000094528L16/dossiers16160600000945021606000009452712BTAPRJLANR5L16BTA0075
16060000094543L16/dossiers16160600000945311606000009454212BTAPIONSNR5S419BTA0016
16060000094678L16/dossiers16160600000945571606000009467712BTAPIONSNR5S399BTA0003
16060000094697L16/dossiers16160600000946841606000009469612BTAPRJLSNR5S399BTA0041
16060000094712L16/dossiers16160600000946841606000009471112BTAPRJLANR5L16BTA0090
16060000094730L16/dossiers16160600000947151606000009472912BTAPIONSNR5S399BTA0046
16060000094762L16/dossiers16160600000947361606000009476112BTAPIONSNR5S399BTA0089
16060000094780L16/dossiers16160600000947681606000009477912BTAPRJLSNR5S399BTA0010
16060000094794L16/dossiers16160600000947681606000009479312BTAPRJLANR5L16BTA0048
16060000094809L16/dossiers16160600000947971606000009480812BTAPIONSNR5S399BTA0020
16060000094825L16/dossiers16160600000947971606000009482412BTAPIONANR5L16BTA0063
16060000094826L16/dossiers16160600000947971606000009482422TAPPIONANR5L16TAP0063
16060000094841L16/dossiers16160600000948291606000009484012BTAPIONSNR5S399BTA0021
16060000094882L16/dossiers16160600000948551606000009488112BTAPIONSNR5S399BTA0004
16060000094900L16/dossiers16160600000948551606000009489912BTAPIONANR5L16BTA0236
16060000094901L16/dossiers16160600000948551606000009489922TAPPIONANR5L16TAP0236
16060000094911L16/dossiers16160600000948551606000009491012BTAPIONSNR5S419BTA0137
16060000094930L16/dossiers16160600000949171606000009492912BTAPRJLSNR5S419BTA0108
16060000094971L16/dossiers16160600000949551606000009497012BTAPIONSNR5S399BTA0008
16060000095146L16/dossiers16160600000951281606000009514512BTAPRJLANR5L16BTA0068
16060000095157L16/dossiers16160600000951281606000009515612BTAPRJLSNR5S399BTA0079
16060000095239L16/dossiers16160600000952161606000009523812BTAPRJLANR5L16BTA0001