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
15090000028010L15/questions_ecrites1515090000028005150900000280051JO_QUESTION02/04/2019
15090000028011L15/questions_ecrites1515090000028005150900000280052JO_QUESTION17/09/2019
15090000028012L15/questions_ecrites1515090000028005150900000280053JO_QUESTION31/12/2019
15090000028013L15/questions_ecrites1515090000028005150900000280054JO_QUESTION14/04/2020
15090000028014L15/questions_ecrites1515090000028005150900000280055JO_QUESTION28/07/2020
15090000028015L15/questions_ecrites1515090000028005150900000280056JO_QUESTION10/11/2020
15090000028016L15/questions_ecrites1515090000028005150900000280057JO_QUESTION16/02/2021
15090000028017L15/questions_ecrites1515090000028005150900000280058JO_QUESTION18/05/2021
15090000028018L15/questions_ecrites1515090000028005150900000280059JO_QUESTION21/09/2021
15090000028019L15/questions_ecrites15150900000280051509000002800510JO_QUESTION11/01/2022
15090000028020L15/questions_ecrites15150900000280051509000002800511JO_QUESTION03/05/2022
15090000028031L15/questions_ecrites1515090000028027150900000280271JO_QUESTION30/04/2019
15090000028159L15/questions_ecrites1515090000028155150900000281551JO_QUESTION18/06/2019
15090000028172L15/questions_ecrites1515090000028168150900000281681JO_QUESTION18/06/2019
15090000028206L15/questions_ecrites1515090000028202150900000282021JO_QUESTION26/03/2019
15090000028392L15/questions_ecrites1515090000028388150900000283881JO_QUESTION09/04/2019
15090000028518L15/questions_ecrites1515090000028512150900000285121JO_QUESTION04/02/2020
15090000028519L15/questions_ecrites1515090000028512150900000285122JO_QUESTION26/05/2020
15090000028520L15/questions_ecrites1515090000028512150900000285123JO_QUESTION22/09/2020
15090000028598L15/questions_ecrites1515090000028594150900000285941JO_QUESTION28/05/2019
15090000028605L15/questions_ecrites1515090000028599150900000285991JO_QUESTION25/06/2019
15090000028606L15/questions_ecrites1515090000028599150900000285992JO_QUESTION28/01/2020
15090000028607L15/questions_ecrites1515090000028599150900000285993JO_QUESTION23/06/2020
15090000028608L15/questions_ecrites1515090000028599150900000285994JO_QUESTION06/10/2020
15090000028667L15/questions_ecrites1515090000028663150900000286631JO_QUESTION01/10/2019
15090000028673L15/questions_ecrites1515090000028668150900000286681JO_QUESTION02/04/2019
15090000028674L15/questions_ecrites1515090000028668150900000286682JO_QUESTION15/10/2019
15090000028675L15/questions_ecrites1515090000028668150900000286683JO_QUESTION21/01/2020
15090000028676L15/questions_ecrites1515090000028668150900000286684JO_QUESTION05/05/2020
15090000028677L15/questions_ecrites1515090000028668150900000286685JO_QUESTION08/09/2020
15090000028737L15/questions_ecrites1515090000028733150900000287331JO_QUESTION02/04/2019
15090000028777L15/questions_ecrites1515090000028773150900000287731JO_QUESTION21/05/2019
15090000028782L15/questions_ecrites1515090000028778150900000287781JO_QUESTION21/05/2019
15090000028804L15/questions_ecrites1515090000028799150900000287991JO_QUESTION28/05/2019
15090000028840L15/questions_ecrites1515090000028834150900000288341JO_QUESTION25/06/2019
15090000028841L15/questions_ecrites1515090000028834150900000288342JO_QUESTION21/07/2020
15090000028842L15/questions_ecrites1515090000028834150900000288343JO_QUESTION17/11/2020
15090000028847L15/questions_ecrites1515090000028843150900000288431JO_QUESTION23/04/2019
15090000028848L15/questions_ecrites1515090000028843150900000288432JO_QUESTION24/09/2019
15090000028910L15/questions_ecrites1515090000028906150900000289061JO_QUESTION18/06/2019
15090000028915L15/questions_ecrites1515090000028911150900000289111JO_QUESTION02/04/2019
15090000028916L15/questions_ecrites1515090000028911150900000289112JO_QUESTION29/10/2019
15090000028925L15/questions_ecrites1515090000028921150900000289211JO_QUESTION02/04/2019
15090000028940L15/questions_ecrites1515090000028936150900000289361JO_QUESTION25/06/2019
15090000028941L15/questions_ecrites1515090000028936150900000289362JO_QUESTION04/02/2020
15090000028964L15/questions_ecrites1515090000028960150900000289601JO_QUESTION09/04/2019
15090000028998L15/questions_ecrites1515090000028992150900000289921JO_QUESTION16/04/2019
15090000029009L15/questions_ecrites1515090000029004150900000290041JO_QUESTION14/05/2019
15090000029010L15/questions_ecrites1515090000029004150900000290042JO_QUESTION09/06/2020
15090000029011L15/questions_ecrites1515090000029004150900000290043JO_QUESTION25/05/2021