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
17090000012710L17/questions_ecrites1717090000012706170900000127061JO_QUESTION2026-05-1220260019
17090000012752L17/questions_ecrites1717090000012748170900000127481JO_QUESTION2026-05-1220260019
17090000012761L17/questions_ecrites1717090000012758170900000127581JO_QUESTION2026-09-2220260038
17090000012770L17/questions_ecrites1717090000012766170900000127661JO_QUESTION2026-05-0520260018
17090000012891L17/questions_ecrites1717090000012888170900000128881JO_QUESTION2026-05-2620260021
17090000012892L17/questions_ecrites1717090000012888170900000128882JO_QUESTION2026-09-2220260038
17090000012912L17/questions_ecrites1717090000012909170900000129091JO_QUESTION2026-07-1420260028
17090000012980L17/questions_ecrites1717090000012975170900000129751JO_QUESTION2025-02-1120250006
17090000013156L17/questions_ecrites1717090000013152170900000131521JO_QUESTION2026-05-1920260020
17090000013200L17/questions_ecrites1717090000013195170900000131951JO_QUESTION2026-05-1220260019
17090000013248L17/questions_ecrites1717090000013245170900000132451JO_QUESTION2026-05-2620260021
17090000013295L17/questions_ecrites1717090000013292170900000132921JO_QUESTION2026-09-2220260038
17090000013300L17/questions_ecrites1717090000013296170900000132961JO_QUESTION2026-09-2220260038
17090000013331L17/questions_ecrites1717090000013325170900000133251JO_QUESTION2026-06-0920260023
17090000013410L17/questions_ecrites1717090000013407170900000134071JO_QUESTION2026-07-2120260029
17090000013511L17/questions_ecrites1717090000013507170900000135071JO_QUESTION2026-05-1920260020
17090000013524L17/questions_ecrites1717090000013520170900000135201JO_QUESTION2026-06-0920260023
17090000013532L17/questions_ecrites1717090000013528170900000135281JO_QUESTION2026-06-0220260022
17090000013533L17/questions_ecrites1717090000013528170900000135282JO_QUESTION2026-09-0820260036
17090000013537L17/questions_ecrites1717090000013534170900000135341JO_QUESTION2026-05-1920260020
17090000013582L17/questions_ecrites1717090000013578170900000135781JO_QUESTION2026-05-1920260020
17090000013616L17/questions_ecrites1717090000013611170900000136111JO_QUESTION2026-09-0820260036
17090000013665L17/questions_ecrites1717090000013661170900000136611JO_QUESTION2026-05-1920260020
17090000013736L17/questions_ecrites1717090000013733170900000137331JO_QUESTION2026-06-0220260022
17090000013737L17/questions_ecrites1717090000013733170900000137332JO_QUESTION2026-09-0820260036
17090000013773L17/questions_ecrites1717090000013770170900000137701JO_QUESTION2026-06-1620260024
17090000013777L17/questions_ecrites1717090000013774170900000137741JO_QUESTION2026-09-0120260035
17090000013791L17/questions_ecrites1717090000013786170900000137861JO_QUESTION2026-06-0920260023
17090000013847L17/questions_ecrites1717090000013844170900000138441JO_QUESTION2026-07-1420260028
17090000013857L17/questions_ecrites1717090000013852170900000138521JO_QUESTION2026-05-1920260020
17090000013945L17/questions_ecrites1717090000013942170900000139421JO_QUESTION2026-08-0420260031
17090000013983L17/questions_ecrites1717090000013978170900000139781JO_QUESTION2026-06-1620260024
17090000014044L17/questions_ecrites1717090000014041170900000140411JO_QUESTION2026-09-1520260037
17090000014048L17/questions_ecrites1717090000014045170900000140451JO_QUESTION2026-09-1520260037
17090000014097L17/questions_ecrites1717090000014093170900000140931JO_QUESTION2026-09-2220260038
17090000014116L17/questions_ecrites1717090000014110170900000141101JO_QUESTION2026-01-1320260002
17090000014151L17/questions_ecrites1717090000014145170900000141451JO_QUESTION2026-05-1920260020
17090000014236L17/questions_ecrites1717090000014232170900000142321JO_QUESTION2026-06-3020260026
17090000014275L17/questions_ecrites1717090000014272170900000142721JO_QUESTION2026-06-1620260024
17090000014283L17/questions_ecrites1717090000014279170900000142791JO_QUESTION2026-05-1920260020
17090000014310L17/questions_ecrites1717090000014307170900000143071JO_QUESTION2026-06-0220260022
17090000014311L17/questions_ecrites1717090000014307170900000143072JO_QUESTION2026-09-0820260036
17090000014322L17/questions_ecrites1717090000014319170900000143191JO_QUESTION2026-09-2220260038
17090000014380L17/questions_ecrites1717090000014375170900000143751JO_QUESTION2026-05-2620260021
17090000014483L17/questions_ecrites1717090000014480170900000144801JO_QUESTION2026-06-0220260022
17090000014484L17/questions_ecrites1717090000014480170900000144802JO_QUESTION2026-09-1520260037
17090000014499L17/questions_ecrites1717090000014496170900000144961JO_QUESTION2026-06-1620260024
17090000014510L17/questions_ecrites1717090000014504170900000145041JO_QUESTION2025-02-1120250006
17090000014511L17/questions_ecrites1717090000014504170900000145042JO_QUESTION2025-05-2720250021
17090000014564L17/questions_ecrites1717090000014555170900000145551JO_QUESTION2025-02-1120250006