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
17090000011402L17/questions_ecrites1717090000011398170900000113982JO_QUESTION2026-09-0820260036
17090000011416L17/questions_ecrites1717090000011412170900000114121JO_QUESTION2026-05-0520260018
17090000011429L17/questions_ecrites1717090000011426170900000114261JO_QUESTION2026-05-0520260018
17090000011430L17/questions_ecrites1717090000011426170900000114262JO_QUESTION2026-09-0120260035
17090000011496L17/questions_ecrites1717090000011491170900000114911JO_QUESTION2026-05-1920260020
17090000011497L17/questions_ecrites1717090000011491170900000114912JO_QUESTION2026-09-0820260036
17090000011516L17/questions_ecrites1717090000011512170900000115121JO_QUESTION2026-04-2820260017
17090000011517L17/questions_ecrites1717090000011512170900000115122JO_QUESTION2026-08-0420260031
17090000011552L17/questions_ecrites1717090000011548170900000115481JO_QUESTION2026-05-0520260018
17090000011597L17/questions_ecrites1717090000011594170900000115941JO_QUESTION2026-09-2220260038
17090000011605L17/questions_ecrites1717090000011602170900000116021JO_QUESTION2026-07-2120260029
17090000011631L17/questions_ecrites1717090000011626170900000116261JO_QUESTION2025-03-0420250009
17090000011636L17/questions_ecrites1717090000011632170900000116321JO_QUESTION2026-05-1220260019
17090000011709L17/questions_ecrites1717090000011706170900000117061JO_QUESTION2026-04-2820260017
17090000011710L17/questions_ecrites1717090000011706170900000117062JO_QUESTION2026-08-0420260031
17090000011735L17/questions_ecrites1717090000011730170900000117301JO_QUESTION2025-02-1120250006
17090000011831L17/questions_ecrites1717090000011826170900000118261JO_QUESTION2025-02-0420250005
17090000011835L17/questions_ecrites1717090000011832170900000118321JO_QUESTION2026-05-0520260018
17090000011836L17/questions_ecrites1717090000011832170900000118322JO_QUESTION2026-09-0120260035
17090000011844L17/questions_ecrites1717090000011841170900000118411JO_QUESTION2026-07-2120260029
17090000011848L17/questions_ecrites1717090000011845170900000118451JO_QUESTION2026-09-1520260037
17090000011878L17/questions_ecrites1717090000011873170900000118731JO_QUESTION2025-05-2020250020
17090000012002L17/questions_ecrites1717090000011999170900000119991JO_QUESTION2026-05-0520260018
17090000012003L17/questions_ecrites1717090000011999170900000119992JO_QUESTION2026-08-2520260034
17090000012009L17/questions_ecrites1717090000012004170900000120041JO_QUESTION2026-07-2120260029
17090000012013L17/questions_ecrites1717090000012010170900000120101JO_QUESTION2026-06-0220260022
17090000012017L17/questions_ecrites1717090000012014170900000120141JO_QUESTION2026-06-0220260022
17090000012049L17/questions_ecrites1717090000012045170900000120451JO_QUESTION2026-05-2620260021
17090000012060L17/questions_ecrites1717090000012057170900000120571JO_QUESTION2026-08-1820260033
17090000012097L17/questions_ecrites1717090000012094170900000120941JO_QUESTION2026-05-2620260021
17090000012137L17/questions_ecrites1717090000012133170900000121331JO_QUESTION2026-05-2620260021
17090000012150L17/questions_ecrites1717090000012147170900000121471JO_QUESTION2026-09-2220260038
17090000012180L17/questions_ecrites1717090000012177170900000121771JO_QUESTION2026-06-0220260022
17090000012312L17/questions_ecrites1717090000012304170900000123041JO_QUESTION2025-08-1220250032
17090000012340L17/questions_ecrites1717090000012336170900000123361JO_QUESTION2026-05-0520260018
17090000012376L17/questions_ecrites1717090000012371170900000123711JO_QUESTION2026-07-2120260029
17090000012390L17/questions_ecrites1717090000012386170900000123861JO_QUESTION2026-05-0520260018
17090000012391L17/questions_ecrites1717090000012386170900000123862JO_QUESTION2026-08-2520260034
17090000012437L17/questions_ecrites1717090000012434170900000124341JO_QUESTION2026-06-1620260024
17090000012505L17/questions_ecrites1717090000012500170900000125001JO_QUESTION2025-02-1120250006
17090000012529L17/questions_ecrites1717090000012524170900000125241JO_QUESTION2026-05-1220260019
17090000012530L17/questions_ecrites1717090000012524170900000125242JO_QUESTION2026-08-1820260033
17090000012553L17/questions_ecrites1717090000012548170900000125481JO_QUESTION2026-06-0920260023
17090000012559L17/questions_ecrites1717090000012554170900000125541JO_QUESTION2025-01-2820250004
17090000012560L17/questions_ecrites1717090000012554170900000125542JO_QUESTION2025-05-0620250018
17090000012567L17/questions_ecrites1717090000012564170900000125641JO_QUESTION2026-05-0520260018
17090000012578L17/questions_ecrites1717090000012575170900000125751JO_QUESTION2026-07-2120260029
17090000012682L17/questions_ecrites1717090000012679170900000126791JO_QUESTION2026-05-1220260019
17090000012683L17/questions_ecrites1717090000012679170900000126792JO_QUESTION2026-09-2220260038
17090000012696L17/questions_ecrites1717090000012690170900000126901JO_QUESTION2025-02-0420250005