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
17090000002468L17/questions_ecrites1717090000002459170900000024591JO_QUESTION2025-02-0420250005
17090000002489L17/questions_ecrites1717090000002485170900000024851JO_QUESTION2026-09-2220260038
17090000002595L17/questions_ecrites1717090000002591170900000025911JO_QUESTION2026-01-2720260004
17090000002647L17/questions_ecrites1717090000002643170900000026431JO_QUESTION2026-01-2720260004
17090000002727L17/questions_ecrites1717090000002724170900000027241JO_QUESTION2026-03-0320260009
17090000002752L17/questions_ecrites1717090000002748170900000027481JO_QUESTION2026-05-2620260021
17090000002771L17/questions_ecrites1717090000002767170900000027671JO_QUESTION2026-02-1720260007
17090000002839L17/questions_ecrites1717090000002834170900000028341JO_QUESTION2025-01-2120250003
17090000002884L17/questions_ecrites1717090000002879170900000028791JO_QUESTION2025-04-1520250015
17090000002890L17/questions_ecrites1717090000002885170900000028851JO_QUESTION2026-02-0320260005
17090000002914L17/questions_ecrites1717090000002911170900000029111JO_QUESTION2026-05-0520260018
17090000002940L17/questions_ecrites1717090000002936170900000029361JO_QUESTION2026-04-2820260017
17090000002968L17/questions_ecrites1717090000002965170900000029651JO_QUESTION2026-04-2820260017
17090000003085L17/questions_ecrites1717090000003080170900000030801JO_QUESTION2026-05-0520260018
17090000003120L17/questions_ecrites1717090000003116170900000031161JO_QUESTION2026-04-0720260014
17090000003136L17/questions_ecrites1717090000003132170900000031321JO_QUESTION2026-02-0320260005
17090000003137L17/questions_ecrites1717090000003132170900000031322JO_QUESTION2026-05-1220260019
17090000003187L17/questions_ecrites1717090000003183170900000031831JO_QUESTION2026-03-0320260009
17090000003223L17/questions_ecrites1717090000003218170900000032181JO_QUESTION2025-01-2820250004
17090000003250L17/questions_ecrites1717090000003245170900000032451JO_QUESTION2026-02-2420260008
17090000003280L17/questions_ecrites1717090000003275170900000032751JO_QUESTION2026-07-1420260028
17090000003348L17/questions_ecrites1717090000003345170900000033451JO_QUESTION2026-02-0320260005
17090000003349L17/questions_ecrites1717090000003345170900000033452JO_QUESTION2026-05-1220260019
17090000003350L17/questions_ecrites1717090000003345170900000033453JO_QUESTION2026-09-0120260035
17090000003367L17/questions_ecrites1717090000003362170900000033621JO_QUESTION2025-01-2820250004
17090000003368L17/questions_ecrites1717090000003362170900000033622JO_QUESTION2025-05-1320250019
17090000003404L17/questions_ecrites1717090000003399170900000033991JO_QUESTION2026-09-2220260038
17090000003422L17/questions_ecrites1717090000003417170900000034171JO_QUESTION2025-05-2020250020
17090000003456L17/questions_ecrites1717090000003450170900000034501JO_QUESTION2026-06-0920260023
17090000003463L17/questions_ecrites1717090000003460170900000034601JO_QUESTION2026-02-0320260005
17090000003464L17/questions_ecrites1717090000003460170900000034602JO_QUESTION2026-09-1520260037
17090000003473L17/questions_ecrites1717090000003468170900000034681JO_QUESTION2025-02-1120250006
17090000003481L17/questions_ecrites1717090000003477170900000034771JO_QUESTION2026-03-2420260012
17090000003518L17/questions_ecrites1717090000003513170900000035131JO_QUESTION2025-01-2820250004
17090000003519L17/questions_ecrites1717090000003513170900000035132JO_QUESTION2025-05-0620250018
17090000003548L17/questions_ecrites1717090000003543170900000035431JO_QUESTION2026-02-0320260005
17090000003553L17/questions_ecrites1717090000003549170900000035491JO_QUESTION2026-06-0920260023
17090000003558L17/questions_ecrites1717090000003554170900000035541JO_QUESTION2026-03-2420260012
17090000003610L17/questions_ecrites1717090000003605170900000036051JO_QUESTION2026-02-1020260006
17090000003622L17/questions_ecrites1717090000003615170900000036151JO_QUESTION2025-02-0420250005
17090000003642L17/questions_ecrites1717090000003639170900000036391JO_QUESTION2026-02-1720260007
17090000003643L17/questions_ecrites1717090000003639170900000036392JO_QUESTION2026-06-2320260025
17090000003650L17/questions_ecrites1717090000003647170900000036471JO_QUESTION2026-02-1020260006
17090000003651L17/questions_ecrites1717090000003647170900000036472JO_QUESTION2026-05-1220260019
17090000003652L17/questions_ecrites1717090000003647170900000036473JO_QUESTION2026-08-2520260034
17090000003667L17/questions_ecrites1717090000003662170900000036621JO_QUESTION2025-02-1120250006
17090000003673L17/questions_ecrites1717090000003668170900000036681JO_QUESTION2026-05-1220260019
17090000003711L17/questions_ecrites1717090000003705170900000037051JO_QUESTION2026-02-1020260006
17090000003793L17/questions_ecrites1717090000003788170900000037881JO_QUESTION2026-02-1020260006
17090000003798L17/questions_ecrites1717090000003794170900000037941JO_QUESTION2026-06-0220260022