Aller au contenu
blackout

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
14090000308745L14/questions_ecrites1414090000308730140900003087309JO_QUESTION2017-02-28
14090000308752L14/questions_ecrites1414090000308746140900003087461JO_QUESTION2014-09-23
14090000308760L14/questions_ecrites1414090000308753140900003087531JO_QUESTION2015-01-20
14090000308761L14/questions_ecrites1414090000308753140900003087532JO_QUESTION2015-05-12
14090000308762L14/questions_ecrites1414090000308753140900003087533JO_QUESTION2015-09-15
14090000308763L14/questions_ecrites1414090000308753140900003087534JO_QUESTION2015-12-22
14090000308764L14/questions_ecrites1414090000308753140900003087535JO_QUESTION2016-03-29
14090000308765L14/questions_ecrites1414090000308753140900003087536JO_QUESTION2016-07-05
14090000308766L14/questions_ecrites1414090000308753140900003087537JO_QUESTION2016-10-11
14090000308767L14/questions_ecrites1414090000308753140900003087538JO_QUESTION2017-01-17
14090000308768L14/questions_ecrites1414090000308753140900003087539JO_QUESTION2017-06-13
14090000308839L14/questions_ecrites1414090000308835140900003088351JO_QUESTION2012-11-27
14090000308840L14/questions_ecrites1414090000308835140900003088352JO_QUESTION2013-03-12
14090000308841L14/questions_ecrites1414090000308835140900003088353JO_QUESTION2013-07-30
14090000308852L14/questions_ecrites1414090000308846140900003088461JO_QUESTION2014-05-13
14090000308853L14/questions_ecrites1414090000308846140900003088462JO_QUESTION2014-09-23
14090000308871L14/questions_ecrites1414090000308863140900003088631JO_QUESTION2013-07-02
14090000308872L14/questions_ecrites1414090000308863140900003088632JO_QUESTION2014-02-11
14090000308898L14/questions_ecrites1414090000308893140900003088931JO_QUESTION2014-04-01
14090000308917L14/questions_ecrites1414090000308913140900003089131JO_QUESTION2013-06-18
14090000308990L14/questions_ecrites1414090000308984140900003089841JO_QUESTION2013-02-05
14090000308991L14/questions_ecrites1414090000308984140900003089842JO_QUESTION2013-05-21
14090000308992L14/questions_ecrites1414090000308984140900003089843JO_QUESTION2013-09-24
14090000309004L14/questions_ecrites1414090000309000140900003090001JO_QUESTION2012-12-18
14090000309014L14/questions_ecrites1414090000309010140900003090101JO_QUESTION2012-11-06
14090000309043L14/questions_ecrites1414090000309039140900003090391JO_QUESTION2015-03-17
14090000309091L14/questions_ecrites1414090000309083140900003090831JO_QUESTION2013-09-17
14090000309092L14/questions_ecrites1414090000309083140900003090832JO_QUESTION2014-05-27
14090000309093L14/questions_ecrites1414090000309083140900003090833JO_QUESTION2014-09-23
14090000309098L14/questions_ecrites1414090000309094140900003090941JO_QUESTION2013-06-25
14090000309107L14/questions_ecrites1414090000309103140900003091031JO_QUESTION2013-04-23
14090000309138L14/questions_ecrites1414090000309132140900003091321JO_QUESTION2015-06-02
14090000309139L14/questions_ecrites1414090000309132140900003091322JO_QUESTION2016-04-26
14090000309179L14/questions_ecrites1414090000309174140900003091741JO_QUESTION2013-07-16
14090000309180L14/questions_ecrites1414090000309174140900003091742JO_QUESTION2013-12-17
14090000309193L14/questions_ecrites1414090000309185140900003091851JO_QUESTION2015-02-17
14090000309232L14/questions_ecrites1414090000309226140900003092261JO_QUESTION2014-09-09
14090000309265L14/questions_ecrites1414090000309259140900003092591JO_QUESTION2014-06-10
14090000309266L14/questions_ecrites1414090000309259140900003092592JO_QUESTION2014-09-23
14090000309280L14/questions_ecrites1414090000309275140900003092751JO_QUESTION2013-11-05
14090000309287L14/questions_ecrites1414090000309281140900003092811JO_QUESTION2014-09-16
14090000309292L14/questions_ecrites1414090000309288140900003092881JO_QUESTION2013-02-12
14090000309293L14/questions_ecrites1414090000309288140900003092882JO_QUESTION2013-06-25
14090000309294L14/questions_ecrites1414090000309288140900003092883JO_QUESTION2013-10-08
14090000309304L14/questions_ecrites1414090000309299140900003092991JO_QUESTION2013-06-18
14090000309322L14/questions_ecrites1414090000309317140900003093171JO_QUESTION2014-05-20
14090000309367L14/questions_ecrites1414090000309360140900003093601JO_QUESTION2014-10-14
14090000309368L14/questions_ecrites1414090000309360140900003093602JO_QUESTION2015-01-20
14090000309369L14/questions_ecrites1414090000309360140900003093603JO_QUESTION2015-06-23
14090000309370L14/questions_ecrites1414090000309360140900003093604JO_QUESTION2015-09-29