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
17090000025500L17/questions_ecrites1717090000025496170900000254961JO_QUESTION2026-09-2220260038
17090000025576L17/questions_ecrites1717090000025573170900000255731JO_QUESTION2026-09-2220260038
17090000025582L17/questions_ecrites1717090000025577170900000255771JO_QUESTION2025-03-1120250010
17090000025641L17/questions_ecrites1717090000025638170900000256381JO_QUESTION2026-09-2920260039
17090000025645L17/questions_ecrites1717090000025642170900000256421JO_QUESTION2026-09-1520260037
17090000025695L17/questions_ecrites1717090000025691170900000256911JO_QUESTION2026-09-0120260035
17090000025909L17/questions_ecrites1717090000025906170900000259061JO_QUESTION2026-09-0820260036
17090000025955L17/questions_ecrites1717090000025952170900000259521JO_QUESTION2026-09-1520260037
17090000025980L17/questions_ecrites1717090000025973170900000259731JO_QUESTION2025-05-2720250021
17090000026016L17/questions_ecrites1717090000026013170900000260131JO_QUESTION2026-09-0120260035
17090000026030L17/questions_ecrites1717090000026027170900000260271JO_QUESTION2026-09-0120260035
17090000026068L17/questions_ecrites1717090000026062170900000260621JO_QUESTION2025-02-1120250006
17090000026116L17/questions_ecrites1717090000026113170900000261131JO_QUESTION2026-09-0120260035
17090000026171L17/questions_ecrites1717090000026168170900000261681JO_QUESTION2026-09-0820260036
17090000026175L17/questions_ecrites1717090000026172170900000261721JO_QUESTION2026-09-0820260036
17090000026222L17/questions_ecrites1717090000026219170900000262191JO_QUESTION2026-09-1520260037
17090000026275L17/questions_ecrites1717090000026270170900000262701JO_QUESTION2025-02-0420250005
17090000026292L17/questions_ecrites1717090000026289170900000262891JO_QUESTION2026-09-0820260036
17090000026327L17/questions_ecrites1717090000026324170900000263241JO_QUESTION2026-09-0820260036
17090000026377L17/questions_ecrites1717090000026374170900000263741JO_QUESTION2026-09-2220260038
17090000026409L17/questions_ecrites1717090000026402170900000264021JO_QUESTION2025-02-2520250008
17090000026452L17/questions_ecrites1717090000026444170900000264441JO_QUESTION2025-02-0420250005
17090000026453L17/questions_ecrites1717090000026444170900000264442JO_QUESTION2025-09-3020250039
17090000026457L17/questions_ecrites1717090000026454170900000264541JO_QUESTION2026-09-2920260039
17090000026541L17/questions_ecrites1717090000026538170900000265381JO_QUESTION2026-09-0820260036
17090000026551L17/questions_ecrites1717090000026548170900000265481JO_QUESTION2026-09-1520260037
17090000026630L17/questions_ecrites1717090000026622170900000266221JO_QUESTION2025-03-2520250012
17090000026631L17/questions_ecrites1717090000026622170900000266222JO_QUESTION2025-11-1120250045
17090000026677L17/questions_ecrites1717090000026669170900000266691JO_QUESTION2025-07-0820250027
17090000026724L17/questions_ecrites1717090000026721170900000267211JO_QUESTION2026-09-0820260036
17090000026753L17/questions_ecrites1717090000026750170900000267501JO_QUESTION2026-09-2920260039
17090000026809L17/questions_ecrites1717090000026803170900000268031JO_QUESTION2025-12-0220250048
17090000026823L17/questions_ecrites1717090000026820170900000268201JO_QUESTION2026-09-2220260038
17090000026835L17/questions_ecrites1717090000026832170900000268321JO_QUESTION2026-09-1520260037
17090000026842L17/questions_ecrites1717090000026839170900000268391JO_QUESTION2026-09-0820260036
17090000026853L17/questions_ecrites1717090000026846170900000268461JO_QUESTION2025-03-1820250011
17090000026854L17/questions_ecrites1717090000026846170900000268462JO_QUESTION2025-12-1620250050
17090000026855L17/questions_ecrites1717090000026846170900000268463JO_QUESTION2026-05-2620260021
17090000026862L17/questions_ecrites1717090000026856170900000268561JO_QUESTION2025-05-2020250020
17090000026863L17/questions_ecrites1717090000026856170900000268562JO_QUESTION2025-09-2320250038
17090000026864L17/questions_ecrites1717090000026856170900000268563JO_QUESTION2026-05-1920260020
17090000026865L17/questions_ecrites1717090000026856170900000268564JO_QUESTION2026-09-1520260037
17090000026889L17/questions_ecrites1717090000026886170900000268861JO_QUESTION2026-09-2220260038
17090000026964L17/questions_ecrites1717090000026961170900000269611JO_QUESTION2026-09-2220260038
17090000027099L17/questions_ecrites1717090000027095170900000270951JO_QUESTION2026-09-2920260039
17090000027150L17/questions_ecrites1717090000027146170900000271461JO_QUESTION2026-09-1520260037
17090000027154L17/questions_ecrites1717090000027151170900000271511JO_QUESTION2026-09-1520260037
17090000027179L17/questions_ecrites1717090000027175170900000271751JO_QUESTION2026-09-0820260036
17090000027190L17/questions_ecrites1717090000027187170900000271871JO_QUESTION2026-09-0820260036
17090000027325L17/questions_ecrites1717090000027321170900000273211JO_QUESTION2026-09-1520260037