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
17090000003810L17/questions_ecrites1717090000003805170900000038051JO_QUESTION2026-08-1120260032
17090000003824L17/questions_ecrites1717090000003820170900000038201JO_QUESTION2026-02-2420260008
17090000003829L17/questions_ecrites1717090000003825170900000038251JO_QUESTION2026-02-2420260008
17090000003855L17/questions_ecrites1717090000003851170900000038511JO_QUESTION2026-02-2420260008
17090000003856L17/questions_ecrites1717090000003851170900000038512JO_QUESTION2026-06-0220260022
17090000003857L17/questions_ecrites1717090000003851170900000038513JO_QUESTION2026-09-1520260037
17090000003876L17/questions_ecrites1717090000003871170900000038711JO_QUESTION2026-03-0320260009
17090000003926L17/questions_ecrites1717090000003917170900000039171JO_QUESTION2025-02-0420250005
17090000003985L17/questions_ecrites1717090000003982170900000039821JO_QUESTION2026-02-1020260006
17090000003986L17/questions_ecrites1717090000003982170900000039822JO_QUESTION2026-05-1920260020
17090000003987L17/questions_ecrites1717090000003982170900000039823JO_QUESTION2026-09-0120260035
17090000004003L17/questions_ecrites1717090000003999170900000039991JO_QUESTION2026-03-1020260010
17090000004008L17/questions_ecrites1717090000004004170900000040041JO_QUESTION2026-02-1020260006
17090000004009L17/questions_ecrites1717090000004004170900000040042JO_QUESTION2026-05-1920260020
17090000004010L17/questions_ecrites1717090000004004170900000040043JO_QUESTION2026-09-0120260035
17090000004043L17/questions_ecrites1717090000004038170900000040381JO_QUESTION2026-07-1420260028
17090000004060L17/questions_ecrites1717090000004055170900000040551JO_QUESTION2026-08-0420260031
17090000004109L17/questions_ecrites1717090000004105170900000041051JO_QUESTION2026-02-1020260006
17090000004122L17/questions_ecrites1717090000004119170900000041191JO_QUESTION2026-02-2420260008
17090000004123L17/questions_ecrites1717090000004119170900000041192JO_QUESTION2026-06-0220260022
17090000004124L17/questions_ecrites1717090000004119170900000041193JO_QUESTION2026-09-1520260037
17090000004137L17/questions_ecrites1717090000004133170900000041331JO_QUESTION2026-02-1020260006
17090000004228L17/questions_ecrites1717090000004225170900000042251JO_QUESTION2026-07-1420260028
17090000004245L17/questions_ecrites1717090000004242170900000042421JO_QUESTION2026-02-1720260007
17090000004246L17/questions_ecrites1717090000004242170900000042422JO_QUESTION2026-06-0220260022
17090000004247L17/questions_ecrites1717090000004242170900000042423JO_QUESTION2026-09-2920260039
17090000004268L17/questions_ecrites1717090000004265170900000042651JO_QUESTION2026-09-0820260036
17090000004282L17/questions_ecrites1717090000004278170900000042781JO_QUESTION2026-02-1020260006
17090000004283L17/questions_ecrites1717090000004278170900000042782JO_QUESTION2026-05-1920260020
17090000004284L17/questions_ecrites1717090000004278170900000042783JO_QUESTION2026-09-0120260035
17090000004296L17/questions_ecrites1717090000004293170900000042931JO_QUESTION2026-02-1020260006
17090000004297L17/questions_ecrites1717090000004293170900000042932JO_QUESTION2026-05-1220260019
17090000004298L17/questions_ecrites1717090000004293170900000042933JO_QUESTION2026-08-2520260034
17090000004438L17/questions_ecrites1717090000004432170900000044321JO_QUESTION2026-02-1720260007
17090000004454L17/questions_ecrites1717090000004449170900000044491JO_QUESTION2025-02-1120250006
17090000004455L17/questions_ecrites1717090000004449170900000044492JO_QUESTION2025-05-2020250020
17090000004553L17/questions_ecrites1717090000004548170900000045481JO_QUESTION2025-05-2720250021
17090000004597L17/questions_ecrites1717090000004593170900000045931JO_QUESTION2025-02-1120250006
17090000004598L17/questions_ecrites1717090000004593170900000045932JO_QUESTION2025-05-2020250020
17090000004621L17/questions_ecrites1717090000004618170900000046181JO_QUESTION2026-03-0320260009
17090000004622L17/questions_ecrites1717090000004618170900000046182JO_QUESTION2026-06-2320260025
17090000004639L17/questions_ecrites1717090000004634170900000046341JO_QUESTION2026-03-0320260009
17090000004649L17/questions_ecrites1717090000004640170900000046401JO_QUESTION2025-01-2820250004
17090000004650L17/questions_ecrites1717090000004640170900000046402JO_QUESTION2025-05-0620250018
17090000004651L17/questions_ecrites1717090000004640170900000046403JO_QUESTION2025-12-1620250050
17090000004652L17/questions_ecrites1717090000004640170900000046404JO_QUESTION2026-03-3120260013
17090000004653L17/questions_ecrites1717090000004640170900000046405JO_QUESTION2026-07-1420260028
17090000004746L17/questions_ecrites1717090000004740170900000047401JO_QUESTION2026-05-0520260018
17090000004753L17/questions_ecrites1717090000004747170900000047471JO_QUESTION2025-01-2820250004
17090000004754L17/questions_ecrites1717090000004747170900000047472JO_QUESTION2025-05-0620250018