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
17090000087422L17/questions_ecrites1717090000087416170900000874161JO_QUESTION2026-02-0320260005
17090000087423L17/questions_ecrites1717090000087416170900000874162JO_QUESTION2026-06-0920260023
17090000087424L17/questions_ecrites1717090000087416170900000874163JO_QUESTION2026-09-2220260038
17090000087467L17/questions_ecrites1717090000087461170900000874611JO_QUESTION2025-12-1620250050
17090000087499L17/questions_ecrites1717090000087492170900000874921JO_QUESTION2025-12-1620250050
17090000087539L17/questions_ecrites1717090000087533170900000875331JO_QUESTION2025-12-1620250050
17090000087540L17/questions_ecrites1717090000087533170900000875332JO_QUESTION2026-04-0720260014
17090000087566L17/questions_ecrites1717090000087561170900000875611JO_QUESTION2026-01-2020260003
17090000087567L17/questions_ecrites1717090000087561170900000875612JO_QUESTION2026-07-2120260029
17090000087573L17/questions_ecrites1717090000087568170900000875681JO_QUESTION2025-12-1620250050
17090000087574L17/questions_ecrites1717090000087568170900000875682JO_QUESTION2026-03-3120260013
17090000087575L17/questions_ecrites1717090000087568170900000875683JO_QUESTION2026-07-2820260030
17090000087587L17/questions_ecrites1717090000087582170900000875821JO_QUESTION2026-02-0320260005
17090000087641L17/questions_ecrites1717090000087636170900000876361JO_QUESTION2026-05-1920260020
17090000087642L17/questions_ecrites1717090000087636170900000876362JO_QUESTION2026-09-1520260037
17090000087655L17/questions_ecrites1717090000087650170900000876501JO_QUESTION2026-05-1920260020
17090000087656L17/questions_ecrites1717090000087650170900000876502JO_QUESTION2026-09-1520260037
17090000087684L17/questions_ecrites1717090000087677170900000876771JO_QUESTION2025-12-1620250050
17090000087815L17/questions_ecrites1717090000087809170900000878091JO_QUESTION2025-12-2320250051
17090000087816L17/questions_ecrites1717090000087809170900000878092JO_QUESTION2026-03-3120260013
17090000087817L17/questions_ecrites1717090000087809170900000878093JO_QUESTION2026-08-1120260032
17090000087847L17/questions_ecrites1717090000087841170900000878411JO_QUESTION2025-12-1620250050
17090000087848L17/questions_ecrites1717090000087841170900000878412JO_QUESTION2026-04-0720260014
17090000087901L17/questions_ecrites1717090000087895170900000878951JO_QUESTION2026-01-1320260002
17090000087944L17/questions_ecrites1717090000087938170900000879381JO_QUESTION2026-01-2020260003
17090000087945L17/questions_ecrites1717090000087938170900000879382JO_QUESTION2026-05-0520260018
17090000088093L17/questions_ecrites1717090000088087170900000880871JO_QUESTION2025-12-1620250050
17090000088187L17/questions_ecrites1717090000088179170900000881791JO_QUESTION2025-12-2320250051
17090000088288L17/questions_ecrites1717090000088282170900000882821JO_QUESTION2025-02-0420250005
17090000088289L17/questions_ecrites1717090000088282170900000882822JO_QUESTION2025-05-2720250021
17090000088290L17/questions_ecrites1717090000088282170900000882823JO_QUESTION2025-09-3020250039
17090000088291L17/questions_ecrites1717090000088282170900000882824JO_QUESTION2026-01-2720260004
17090000088292L17/questions_ecrites1717090000088282170900000882825JO_QUESTION2026-06-0220260022
17090000088293L17/questions_ecrites1717090000088282170900000882826JO_QUESTION2026-09-0820260036
17090000088321L17/questions_ecrites1717090000088315170900000883151JO_QUESTION2025-12-1620250050
17090000088322L17/questions_ecrites1717090000088315170900000883152JO_QUESTION2026-03-2420260012
17090000088380L17/questions_ecrites1717090000088373170900000883731JO_QUESTION2026-01-2720260004
17090000088381L17/questions_ecrites1717090000088373170900000883732JO_QUESTION2026-09-2220260038
17090000088407L17/questions_ecrites1717090000088401170900000884011JO_QUESTION2026-01-2720260004
17090000088447L17/questions_ecrites1717090000088440170900000884401JO_QUESTION2026-03-1020260010
17090000088455L17/questions_ecrites1717090000088448170900000884481JO_QUESTION2026-01-2720260004
17090000088456L17/questions_ecrites1717090000088448170900000884482JO_QUESTION2026-09-2220260038
17090000088464L17/questions_ecrites1717090000088457170900000884571JO_QUESTION2026-03-1020260010
17090000088528L17/questions_ecrites1717090000088522170900000885221JO_QUESTION2026-01-1320260002
17090000088529L17/questions_ecrites1717090000088522170900000885222JO_QUESTION2026-04-2120260016
17090000088553L17/questions_ecrites1717090000088547170900000885471JO_QUESTION2026-01-2720260004
17090000088559L17/questions_ecrites1717090000088554170900000885541JO_QUESTION2026-01-2720260004
17090000088560L17/questions_ecrites1717090000088554170900000885542JO_QUESTION2026-09-2220260038
17090000088567L17/questions_ecrites1717090000088561170900000885611JO_QUESTION2026-01-2720260004
17090000088615L17/questions_ecrites1717090000088607170900000886071JO_QUESTION2025-12-3020250052