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
16090000082499L16/questions_ecrites1616090000082493160900000824932JO_QUESTION2024-01-3020240005
16090000082515L16/questions_ecrites1616090000082509160900000825091JO_QUESTION2023-10-1020230041
16090000082533L16/questions_ecrites1616090000082529160900000825291JO_QUESTION2023-10-2420230043
16090000082546L16/questions_ecrites1616090000082538160900000825381JO_QUESTION2023-10-1020230041
16090000082547L16/questions_ecrites1616090000082538160900000825382JO_QUESTION2024-01-3020240005
16090000082548L16/questions_ecrites1616090000082538160900000825383JO_QUESTION2024-06-0420240023
16090000082586L16/questions_ecrites1616090000082580160900000825801JO_QUESTION2024-04-0220240014
16090000082602L16/questions_ecrites1616090000082593160900000825931JO_QUESTION2024-04-0920240015
16090000082632L16/questions_ecrites1616090000082627160900000826271JO_QUESTION2023-10-2420230043
16090000082697L16/questions_ecrites1616090000082691160900000826911JO_QUESTION2023-10-2420230043
16090000082698L16/questions_ecrites1616090000082691160900000826912JO_QUESTION2024-01-3020240005
16090000082708L16/questions_ecrites1616090000082704160900000827041JO_QUESTION2023-10-1020230041
16090000082709L16/questions_ecrites1616090000082704160900000827042JO_QUESTION2024-01-3020240005
16090000082710L16/questions_ecrites1616090000082704160900000827043JO_QUESTION2024-06-1120240024
16090000082724L16/questions_ecrites1616090000082719160900000827191JO_QUESTION2023-10-2420230043
16090000082725L16/questions_ecrites1616090000082719160900000827192JO_QUESTION2024-01-3020240005
16090000082726L16/questions_ecrites1616090000082719160900000827193JO_QUESTION2024-05-1420240020
16090000082748L16/questions_ecrites1616090000082743160900000827431JO_QUESTION2024-03-1220240011
16090000082788L16/questions_ecrites1616090000082784160900000827841JO_QUESTION2023-10-1020230041
16090000082884L16/questions_ecrites1616090000082879160900000828791JO_QUESTION2023-10-1020230041
16090000083080L16/questions_ecrites1616090000083076160900000830761JO_QUESTION2023-10-1020230041
16090000083081L16/questions_ecrites1616090000083076160900000830762JO_QUESTION2024-01-3020240005
16090000083102L16/questions_ecrites1616090000083097160900000830971JO_QUESTION2023-10-1020230041
16090000083135L16/questions_ecrites1616090000083131160900000831311JO_QUESTION2023-10-1020230041
16090000083149L16/questions_ecrites1616090000083144160900000831441JO_QUESTION2023-10-1020230041
16090000083215L16/questions_ecrites1616090000083211160900000832111JO_QUESTION2023-12-2620230052
16090000083231L16/questions_ecrites1616090000083227160900000832271JO_QUESTION2023-10-2420230043
16090000083242L16/questions_ecrites1616090000083236160900000832361JO_QUESTION2023-10-2420230043
16090000083243L16/questions_ecrites1616090000083236160900000832362JO_QUESTION2024-01-3020240005
16090000083260L16/questions_ecrites1616090000083254160900000832541JO_QUESTION2023-10-2420230043
16090000083261L16/questions_ecrites1616090000083254160900000832542JO_QUESTION2024-01-3020240005
16090000083331L16/questions_ecrites1616090000083323160900000833231JO_QUESTION2024-06-0420240023
16090000083367L16/questions_ecrites1616090000083363160900000833631JO_QUESTION2024-03-1220240011
16090000083403L16/questions_ecrites1616090000083398160900000833981JO_QUESTION2023-12-1220230050
16090000083408L16/questions_ecrites1616090000083404160900000834041JO_QUESTION2022-12-2020220050
16090000083415L16/questions_ecrites1616090000083409160900000834091JO_QUESTION2023-10-1020230041
16090000083456L16/questions_ecrites1616090000083449160900000834491JO_QUESTION2023-10-2420230043
16090000083457L16/questions_ecrites1616090000083449160900000834492JO_QUESTION2024-01-3020240005
16090000083511L16/questions_ecrites1616090000083504160900000835041JO_QUESTION2024-05-2120240021
16090000083592L16/questions_ecrites1616090000083588160900000835881JO_QUESTION2022-12-0620220048
16090000083617L16/questions_ecrites1616090000083610160900000836101JO_QUESTION2023-12-1220230050
16090000083622L16/questions_ecrites1616090000083618160900000836181JO_QUESTION2023-12-1220230050
16090000083623L16/questions_ecrites1616090000083618160900000836182JO_QUESTION2024-06-1120240024
16090000083633L16/questions_ecrites1616090000083629160900000836291JO_QUESTION2023-10-1020230041
16090000083634L16/questions_ecrites1616090000083629160900000836292JO_QUESTION2024-01-3020240005
16090000083635L16/questions_ecrites1616090000083629160900000836293JO_QUESTION2024-06-0420240023
16090000083652L16/questions_ecrites1616090000083648160900000836481JO_QUESTION2022-12-2020220050
16090000083672L16/questions_ecrites1616090000083665160900000836651JO_QUESTION2024-02-2720240009
16090000083685L16/questions_ecrites1616090000083680160900000836801JO_QUESTION2023-10-2420230043
16090000083757L16/questions_ecrites1616090000083752160900000837521JO_QUESTION2023-10-1020230041