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
17090000073523L17/questions_ecrites1717090000073515170900000735153JO_QUESTION2026-04-2120260016
17090000073524L17/questions_ecrites1717090000073515170900000735154JO_QUESTION2026-07-2820260030
17090000073546L17/questions_ecrites1717090000073539170900000735391JO_QUESTION2025-12-0220250048
17090000073563L17/questions_ecrites1717090000073557170900000735571JO_QUESTION2025-10-2120250042
17090000073570L17/questions_ecrites1717090000073564170900000735641JO_QUESTION2025-02-1120250006
17090000073683L17/questions_ecrites1717090000073675170900000736751JO_QUESTION2025-11-0420250044
17090000073684L17/questions_ecrites1717090000073675170900000736752JO_QUESTION2026-04-2120260016
17090000073757L17/questions_ecrites1717090000073750170900000737501JO_QUESTION2026-01-2720260004
17090000073758L17/questions_ecrites1717090000073750170900000737502JO_QUESTION2026-06-1620260024
17090000073798L17/questions_ecrites1717090000073793170900000737931JO_QUESTION2026-03-3120260013
17090000073799L17/questions_ecrites1717090000073793170900000737932JO_QUESTION2026-07-1420260028
17090000073806L17/questions_ecrites1717090000073800170900000738001JO_QUESTION2025-11-0420250044
17090000073831L17/questions_ecrites1717090000073826170900000738261JO_QUESTION2025-10-2120250042
17090000073832L17/questions_ecrites1717090000073826170900000738262JO_QUESTION2026-01-2720260004
17090000073833L17/questions_ecrites1717090000073826170900000738263JO_QUESTION2026-05-0520260018
17090000073834L17/questions_ecrites1717090000073826170900000738264JO_QUESTION2026-09-2920260039
17090000073868L17/questions_ecrites1717090000073862170900000738621JO_QUESTION2025-11-0420250044
17090000074006L17/questions_ecrites1717090000074001170900000740011JO_QUESTION2025-01-2120250003
17090000074007L17/questions_ecrites1717090000074001170900000740012JO_QUESTION2025-04-2920250017
17090000074057L17/questions_ecrites1717090000074051170900000740511JO_QUESTION2025-10-2120250042
17090000074180L17/questions_ecrites1717090000074171170900000741711JO_QUESTION2025-09-2320250038
17090000074192L17/questions_ecrites1717090000074186170900000741861JO_QUESTION2026-02-1020260006
17090000074200L17/questions_ecrites1717090000074193170900000741931JO_QUESTION2026-04-2120260016
17090000074208L17/questions_ecrites1717090000074201170900000742011JO_QUESTION2025-11-1120250045
17090000074244L17/questions_ecrites1717090000074238170900000742381JO_QUESTION2025-09-2320250038
17090000074245L17/questions_ecrites1717090000074238170900000742382JO_QUESTION2025-12-3020250052
17090000074246L17/questions_ecrites1717090000074238170900000742383JO_QUESTION2026-04-0720260014
17090000074266L17/questions_ecrites1717090000074261170900000742611JO_QUESTION2025-10-2820250043
17090000074267L17/questions_ecrites1717090000074261170900000742612JO_QUESTION2026-02-1020260006
17090000074268L17/questions_ecrites1717090000074261170900000742613JO_QUESTION2026-05-1220260019
17090000074269L17/questions_ecrites1717090000074261170900000742614JO_QUESTION2026-08-2520260034
17090000074287L17/questions_ecrites1717090000074281170900000742811JO_QUESTION2026-02-1020260006
17090000074300L17/questions_ecrites1717090000074293170900000742931JO_QUESTION2025-10-2120250042
17090000074334L17/questions_ecrites1717090000074328170900000743281JO_QUESTION2025-10-2120250042
17090000074402L17/questions_ecrites1717090000074396170900000743961JO_QUESTION2025-10-2120250042
17090000074424L17/questions_ecrites1717090000074417170900000744171JO_QUESTION2025-12-0220250048
17090000074441L17/questions_ecrites1717090000074433170900000744331JO_QUESTION2025-09-2320250038
17090000074464L17/questions_ecrites1717090000074459170900000744591JO_QUESTION2025-02-1120250006
17090000074495L17/questions_ecrites1717090000074488170900000744881JO_QUESTION2025-11-0420250044
17090000074496L17/questions_ecrites1717090000074488170900000744882JO_QUESTION2026-04-2120260016
17090000074497L17/questions_ecrites1717090000074488170900000744883JO_QUESTION2026-08-0420260031
17090000074512L17/questions_ecrites1717090000074505170900000745051JO_QUESTION2025-10-2820250043
17090000074513L17/questions_ecrites1717090000074505170900000745052JO_QUESTION2026-02-1020260006
17090000074514L17/questions_ecrites1717090000074505170900000745053JO_QUESTION2026-05-1220260019
17090000074515L17/questions_ecrites1717090000074505170900000745054JO_QUESTION2026-08-2520260034
17090000074562L17/questions_ecrites1717090000074557170900000745571JO_QUESTION2026-02-1020260006
17090000074633L17/questions_ecrites1717090000074627170900000746271JO_QUESTION2025-10-2820250043
17090000074659L17/questions_ecrites1717090000074652170900000746521JO_QUESTION2025-11-1120250045
17090000074723L17/questions_ecrites1717090000074718170900000747181JO_QUESTION2025-02-1120250006
17090000074847L17/questions_ecrites1717090000074841170900000748411JO_QUESTION2025-10-2120250042