AN · données ouvertes
Explorateur / questions_ecrites

questions_ecrites.question_renouvellement

Chemin question.renouvellements.renouvellement · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %

85 044 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…)
7info_jo_type_joVARCHARquestion.renouvellements.renouvellement.infoJO.typeJO · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %
8info_jo_date_joVARCHARquestion.renouvellements.renouvellement.infoJO.dateJO · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %
9info_jo_page_joVARCHARquestion.renouvellements.renouvellement.infoJO.pageJO · présence : L17 11 %, L16 10 %
10info_jo_num_joBIGINTquestion.renouvellements.renouvellement.infoJO.numJO · présence : L17 11 %, L16 10 %
11info_jo_url_legifranceVARCHARquestion.renouvellements.renouvellement.infoJO.urlLegifrance · présence : L17 11 %, L16 10 %
12info_jo_reference_norVARCHARquestion.renouvellements.renouvellement.infoJO.referenceNOR · présence : L17 11 %, L16 10 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreinfo_jo_type_joinfo_jo_date_joinfo_jo_page_joinfo_jo_num_joinfo_jo_url_legifranceinfo_jo_reference_nor
17090000023833L17/questions_ecrites1717090000023829170900000238291JO_QUESTION2026-08-1120260032
17090000023847L17/questions_ecrites1717090000023841170900000238411JO_QUESTION2025-02-1120250006
17090000023855L17/questions_ecrites1717090000023852170900000238521JO_QUESTION2026-08-1120260032
17090000023859L17/questions_ecrites1717090000023856170900000238561JO_QUESTION2026-09-2920260039
17090000023884L17/questions_ecrites1717090000023881170900000238811JO_QUESTION2026-08-1820260033
17090000023903L17/questions_ecrites1717090000023900170900000239001JO_QUESTION2026-09-0120260035
17090000023907L17/questions_ecrites1717090000023904170900000239041JO_QUESTION2026-08-2520260034
17090000023957L17/questions_ecrites1717090000023954170900000239541JO_QUESTION2026-08-1120260032
17090000023976L17/questions_ecrites1717090000023969170900000239691JO_QUESTION2025-10-2120250042
17090000023992L17/questions_ecrites1717090000023989170900000239891JO_QUESTION2026-09-0120260035
17090000024114L17/questions_ecrites1717090000024105170900000241051JO_QUESTION2026-02-1020260006
17090000024147L17/questions_ecrites1717090000024144170900000241441JO_QUESTION2026-09-2920260039
17090000024171L17/questions_ecrites1717090000024167170900000241671JO_QUESTION2026-09-1520260037
17090000024229L17/questions_ecrites1717090000024226170900000242261JO_QUESTION2026-09-2920260039
17090000024316L17/questions_ecrites1717090000024313170900000243131JO_QUESTION2026-09-1520260037
17090000024364L17/questions_ecrites1717090000024360170900000243601JO_QUESTION2026-09-0820260036
17090000024368L17/questions_ecrites1717090000024365170900000243651JO_QUESTION2026-09-1520260037
17090000024457L17/questions_ecrites1717090000024454170900000244541JO_QUESTION2026-09-0120260035
17090000024473L17/questions_ecrites1717090000024466170900000244661JO_QUESTION2025-10-2120250042
17090000024528L17/questions_ecrites1717090000024523170900000245231JO_QUESTION2026-08-2520260034
17090000024600L17/questions_ecrites1717090000024596170900000245961JO_QUESTION2026-09-1520260037
17090000024615L17/questions_ecrites1717090000024612170900000246121JO_QUESTION2026-09-1520260037
17090000024637L17/questions_ecrites1717090000024634170900000246341JO_QUESTION2026-09-0120260035
17090000024644L17/questions_ecrites1717090000024641170900000246411JO_QUESTION2026-09-1520260037
17090000024707L17/questions_ecrites1717090000024704170900000247041JO_QUESTION2026-09-0120260035
17090000024753L17/questions_ecrites1717090000024750170900000247501JO_QUESTION2026-09-0120260035
17090000024807L17/questions_ecrites1717090000024804170900000248041JO_QUESTION2026-09-2220260038
17090000024852L17/questions_ecrites1717090000024848170900000248481JO_QUESTION2026-09-2220260038
17090000024856L17/questions_ecrites1717090000024853170900000248531JO_QUESTION2026-09-2220260038
17090000024887L17/questions_ecrites1717090000024884170900000248841JO_QUESTION2026-09-0820260036
17090000024917L17/questions_ecrites1717090000024909170900000249091JO_QUESTION2025-05-0620250018
17090000024949L17/questions_ecrites1717090000024945170900000249451JO_QUESTION2026-09-0820260036
17090000024962L17/questions_ecrites1717090000024955170900000249551JO_QUESTION2025-03-2520250012
17090000025009L17/questions_ecrites1717090000025001170900000250011JO_QUESTION2025-08-2620250034
17090000025010L17/questions_ecrites1717090000025001170900000250012JO_QUESTION2026-06-2320260025
17090000025054L17/questions_ecrites1717090000025046170900000250461JO_QUESTION2025-10-2120250042
17090000025101L17/questions_ecrites1717090000025096170900000250961JO_QUESTION2025-03-1820250011
17090000025107L17/questions_ecrites1717090000025102170900000251021JO_QUESTION2025-02-0420250005
17090000025121L17/questions_ecrites1717090000025118170900000251181JO_QUESTION2026-09-0820260036
17090000025128L17/questions_ecrites1717090000025125170900000251251JO_QUESTION2026-09-0820260036
17090000025166L17/questions_ecrites1717090000025162170900000251621JO_QUESTION2026-08-2520260034
17090000025355L17/questions_ecrites1717090000025351170900000253511JO_QUESTION2026-09-0120260035
17090000025365L17/questions_ecrites1717090000025360170900000253601JO_QUESTION2025-02-0420250005
17090000025366L17/questions_ecrites1717090000025360170900000253602JO_QUESTION2025-05-1320250019
17090000025428L17/questions_ecrites1717090000025424170900000254241JO_QUESTION2026-09-2220260038
17090000025438L17/questions_ecrites1717090000025435170900000254351JO_QUESTION2026-08-2520260034
17090000025452L17/questions_ecrites1717090000025445170900000254451JO_QUESTION2025-07-0820250027
17090000025456L17/questions_ecrites1717090000025453170900000254531JO_QUESTION2026-09-2920260039
17090000025460L17/questions_ecrites1717090000025457170900000254571JO_QUESTION2026-09-2220260038
17090000025470L17/questions_ecrites1717090000025467170900000254671JO_QUESTION2026-09-0820260036