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
17090000027384L17/questions_ecrites1717090000027377170900000273771JO_QUESTION2025-04-0120250013
17090000027388L17/questions_ecrites1717090000027385170900000273851JO_QUESTION2026-09-2220260038
17090000027405L17/questions_ecrites1717090000027402170900000274021JO_QUESTION2026-09-1520260037
17090000027412L17/questions_ecrites1717090000027409170900000274091JO_QUESTION2026-09-1520260037
17090000027436L17/questions_ecrites1717090000027433170900000274331JO_QUESTION2026-09-2220260038
17090000027441L17/questions_ecrites1717090000027437170900000274371JO_QUESTION2026-09-1520260037
17090000027478L17/questions_ecrites1717090000027475170900000274751JO_QUESTION2026-09-2220260038
17090000027508L17/questions_ecrites1717090000027504170900000275041JO_QUESTION2026-09-2220260038
17090000027529L17/questions_ecrites1717090000027526170900000275261JO_QUESTION2026-09-2220260038
17090000027554L17/questions_ecrites1717090000027549170900000275491JO_QUESTION2026-09-1520260037
17090000027578L17/questions_ecrites1717090000027574170900000275741JO_QUESTION2026-09-1520260037
17090000027600L17/questions_ecrites1717090000027597170900000275971JO_QUESTION2026-09-2220260038
17090000027606L17/questions_ecrites1717090000027601170900000276011JO_QUESTION2025-02-0420250005
17090000027651L17/questions_ecrites1717090000027646170900000276461JO_QUESTION2025-02-1820250007
17090000027690L17/questions_ecrites1717090000027685170900000276851JO_QUESTION2025-02-2520250008
17090000027758L17/questions_ecrites1717090000027755170900000277551JO_QUESTION2026-09-2220260038
17090000027784L17/questions_ecrites1717090000027781170900000277811JO_QUESTION2026-09-1520260037
17090000027833L17/questions_ecrites1717090000027829170900000278291JO_QUESTION2026-09-2220260038
17090000027899L17/questions_ecrites1717090000027896170900000278961JO_QUESTION2026-09-1520260037
17090000027938L17/questions_ecrites1717090000027935170900000279351JO_QUESTION2026-09-2220260038
17090000028015L17/questions_ecrites1717090000028012170900000280121JO_QUESTION2026-09-2220260038
17090000028023L17/questions_ecrites1717090000028016170900000280161JO_QUESTION2026-03-0320260009
17090000028024L17/questions_ecrites1717090000028016170900000280162JO_QUESTION2026-07-2120260029
17090000028031L17/questions_ecrites1717090000028028170900000280281JO_QUESTION2026-09-1520260037
17090000028051L17/questions_ecrites1717090000028048170900000280481JO_QUESTION2026-09-1520260037
17090000028190L17/questions_ecrites1717090000028186170900000281861JO_QUESTION2026-09-2220260038
17090000028317L17/questions_ecrites1717090000028312170900000283121JO_QUESTION2025-03-0420250009
17090000028348L17/questions_ecrites1717090000028345170900000283451JO_QUESTION2026-09-2220260038
17090000028481L17/questions_ecrites1717090000028476170900000284761JO_QUESTION2025-03-0420250009
17090000028495L17/questions_ecrites1717090000028492170900000284921JO_QUESTION2026-09-2220260038
17090000028506L17/questions_ecrites1717090000028503170900000285031JO_QUESTION2026-09-2220260038
17090000028521L17/questions_ecrites1717090000028516170900000285161JO_QUESTION2025-02-1120250006
17090000028530L17/questions_ecrites1717090000028527170900000285271JO_QUESTION2026-09-2220260038
17090000028575L17/questions_ecrites1717090000028570170900000285701JO_QUESTION2025-02-1120250006
17090000028599L17/questions_ecrites1717090000028596170900000285961JO_QUESTION2026-09-2920260039
17090000028625L17/questions_ecrites1717090000028618170900000286181JO_QUESTION2025-06-0320250022
17090000028626L17/questions_ecrites1717090000028618170900000286182JO_QUESTION2026-06-2320260025
17090000028719L17/questions_ecrites1717090000028715170900000287151JO_QUESTION2026-09-2220260038
17090000028740L17/questions_ecrites1717090000028737170900000287371JO_QUESTION2026-09-2220260038
17090000028774L17/questions_ecrites1717090000028770170900000287701JO_QUESTION2026-09-2220260038
17090000028847L17/questions_ecrites1717090000028844170900000288441JO_QUESTION2026-09-2920260039
17090000028858L17/questions_ecrites1717090000028855170900000288551JO_QUESTION2026-09-2220260038
17090000028862L17/questions_ecrites1717090000028859170900000288591JO_QUESTION2026-09-2220260038
17090000028912L17/questions_ecrites1717090000028909170900000289091JO_QUESTION2026-09-2220260038
17090000029033L17/questions_ecrites1717090000029030170900000290301JO_QUESTION2026-09-2220260038
17090000029303L17/questions_ecrites1717090000029299170900000292991JO_QUESTION2026-09-2920260039
17090000029331L17/questions_ecrites1717090000029328170900000293281JO_QUESTION2026-09-2920260039
17090000029439L17/questions_ecrites1717090000029430170900000294301JO_QUESTION2025-01-2820250004
17090000029440L17/questions_ecrites1717090000029430170900000294302JO_QUESTION2025-05-0620250018
17090000029441L17/questions_ecrites1717090000029430170900000294303JO_QUESTION2025-08-1220250032