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
15090000013080L15/questions_ecrites1515090000013071150900000130714JO_QUESTION22/09/2020
15090000013124L15/questions_ecrites1515090000013117150900000131171JO_QUESTION19/02/2019
15090000013125L15/questions_ecrites1515090000013117150900000131172JO_QUESTION24/09/2019
15090000013126L15/questions_ecrites1515090000013117150900000131173JO_QUESTION06/10/2020
15090000013159L15/questions_ecrites1515090000013154150900000131541JO_QUESTION29/01/2019
15090000013320L15/questions_ecrites1515090000013316150900000133161JO_QUESTION19/02/2019
15090000013321L15/questions_ecrites1515090000013316150900000133162JO_QUESTION30/07/2019
15090000013332L15/questions_ecrites1515090000013326150900000133261JO_QUESTION29/01/2019
15090000013333L15/questions_ecrites1515090000013326150900000133262JO_QUESTION25/06/2019
15090000013334L15/questions_ecrites1515090000013326150900000133263JO_QUESTION29/10/2019
15090000013335L15/questions_ecrites1515090000013326150900000133264JO_QUESTION04/02/2020
15090000013336L15/questions_ecrites1515090000013326150900000133265JO_QUESTION08/09/2020
15090000013337L15/questions_ecrites1515090000013326150900000133266JO_QUESTION13/04/2021
15090000013338L15/questions_ecrites1515090000013326150900000133267JO_QUESTION05/10/2021
15090000013339L15/questions_ecrites1515090000013326150900000133268JO_QUESTION18/01/2022
15090000013340L15/questions_ecrites1515090000013326150900000133269JO_QUESTION26/04/2022
15090000013376L15/questions_ecrites1515090000013370150900000133701JO_QUESTION12/02/2019
15090000013416L15/questions_ecrites1515090000013410150900000134101JO_QUESTION28/05/2019
15090000013417L15/questions_ecrites1515090000013410150900000134102JO_QUESTION22/10/2019
15090000013418L15/questions_ecrites1515090000013410150900000134103JO_QUESTION07/04/2020
15090000013466L15/questions_ecrites1515090000013462150900000134621JO_QUESTION12/02/2019
15090000013485L15/questions_ecrites1515090000013477150900000134771JO_QUESTION29/10/2019
15090000013520L15/questions_ecrites1515090000013514150900000135141JO_QUESTION19/02/2019
15090000013578L15/questions_ecrites1515090000013573150900000135731JO_QUESTION15/01/2019
15090000013628L15/questions_ecrites1515090000013623150900000136231JO_QUESTION12/02/2019
15090000013644L15/questions_ecrites1515090000013639150900000136391JO_QUESTION15/03/2022
15090000013651L15/questions_ecrites1515090000013645150900000136451JO_QUESTION29/01/2019
15090000013652L15/questions_ecrites1515090000013645150900000136452JO_QUESTION25/06/2019
15090000013653L15/questions_ecrites1515090000013645150900000136453JO_QUESTION29/10/2019
15090000013654L15/questions_ecrites1515090000013645150900000136454JO_QUESTION04/02/2020
15090000013655L15/questions_ecrites1515090000013645150900000136455JO_QUESTION08/09/2020
15090000013656L15/questions_ecrites1515090000013645150900000136456JO_QUESTION13/04/2021
15090000013657L15/questions_ecrites1515090000013645150900000136457JO_QUESTION05/10/2021
15090000013658L15/questions_ecrites1515090000013645150900000136458JO_QUESTION18/01/2022
15090000013659L15/questions_ecrites1515090000013645150900000136459JO_QUESTION26/04/2022
15090000013677L15/questions_ecrites1515090000013673150900000136731JO_QUESTION26/02/2019
15090000013678L15/questions_ecrites1515090000013673150900000136732JO_QUESTION09/07/2019
15090000013683L15/questions_ecrites1515090000013679150900000136791JO_QUESTION26/02/2019
15090000013702L15/questions_ecrites1515090000013698150900000136981JO_QUESTION12/02/2019
15090000013751L15/questions_ecrites1515090000013746150900000137461JO_QUESTION26/02/2019
15090000013763L15/questions_ecrites1515090000013756150900000137561JO_QUESTION12/02/2019
15090000013783L15/questions_ecrites1515090000013778150900000137781JO_QUESTION12/02/2019
15090000013824L15/questions_ecrites1515090000013818150900000138181JO_QUESTION12/02/2019
15090000013924L15/questions_ecrites1515090000013919150900000139191JO_QUESTION12/02/2019
15090000014001L15/questions_ecrites1515090000013996150900000139961JO_QUESTION29/01/2019
15090000014055L15/questions_ecrites1515090000014051150900000140511JO_QUESTION26/02/2019
15090000014094L15/questions_ecrites1515090000014089150900000140891JO_QUESTION12/02/2019
15090000014178L15/questions_ecrites1515090000014174150900000141741JO_QUESTION15/01/2019
15090000014179L15/questions_ecrites1515090000014174150900000141742JO_QUESTION23/04/2019
15090000014185L15/questions_ecrites1515090000014180150900000141801JO_QUESTION12/02/2019