Aller au contenu
blackout

questions_ecrites.question_renouvellement

Chemin question.renouvellements.renouvellement · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %

85 356 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
14090000435582L14/questions_ecrites1414090000435577140900004355772JO_QUESTION2015-09-01
14090000435583L14/questions_ecrites1414090000435577140900004355773JO_QUESTION2015-12-08
14090000435589L14/questions_ecrites1414090000435584140900004355841JO_QUESTION2014-10-07
14090000435590L14/questions_ecrites1414090000435584140900004355842JO_QUESTION2015-01-13
14090000435617L14/questions_ecrites1414090000435610140900004356101JO_QUESTION2014-06-17
14090000435618L14/questions_ecrites1414090000435610140900004356102JO_QUESTION2014-06-17
14090000435636L14/questions_ecrites1414090000435628140900004356281JO_QUESTION2013-01-08
14090000435637L14/questions_ecrites1414090000435628140900004356282JO_QUESTION2013-04-16
14090000435638L14/questions_ecrites1414090000435628140900004356283JO_QUESTION2013-07-30
14090000435639L14/questions_ecrites1414090000435628140900004356284JO_QUESTION2013-11-05
14090000435640L14/questions_ecrites1414090000435628140900004356285JO_QUESTION2014-02-11
14090000435641L14/questions_ecrites1414090000435628140900004356286JO_QUESTION2014-05-20
14090000435642L14/questions_ecrites1414090000435628140900004356287JO_QUESTION2014-09-09
14090000435643L14/questions_ecrites1414090000435628140900004356288JO_QUESTION2014-12-16
14090000435644L14/questions_ecrites1414090000435628140900004356289JO_QUESTION2015-03-24
14090000435645L14/questions_ecrites14140900004356281409000043562810JO_QUESTION2015-06-30
14090000435646L14/questions_ecrites14140900004356281409000043562811JO_QUESTION2015-10-06
14090000435647L14/questions_ecrites14140900004356281409000043562812JO_QUESTION2016-01-12
14090000435648L14/questions_ecrites14140900004356281409000043562813JO_QUESTION2016-05-03
14090000435649L14/questions_ecrites14140900004356281409000043562814JO_QUESTION2016-05-03
14090000435650L14/questions_ecrites14140900004356281409000043562815JO_QUESTION2016-08-16
14090000435651L14/questions_ecrites14140900004356281409000043562816JO_QUESTION2016-11-22
14090000435652L14/questions_ecrites14140900004356281409000043562817JO_QUESTION2017-02-28
14090000435657L14/questions_ecrites1414090000435653140900004356531JO_QUESTION2013-06-18
14090000435725L14/questions_ecrites1414090000435718140900004357181JO_QUESTION2015-02-03
14090000435726L14/questions_ecrites1414090000435718140900004357182JO_QUESTION2015-06-09
14090000435727L14/questions_ecrites1414090000435718140900004357183JO_QUESTION2015-09-15
14090000435728L14/questions_ecrites1414090000435718140900004357184JO_QUESTION2016-03-29
14090000435729L14/questions_ecrites1414090000435718140900004357185JO_QUESTION2016-07-12
14090000435730L14/questions_ecrites1414090000435718140900004357186JO_QUESTION2016-10-18
14090000435753L14/questions_ecrites1414090000435749140900004357491JO_QUESTION2012-12-25
14090000435754L14/questions_ecrites1414090000435749140900004357492JO_QUESTION2013-04-02
14090000435755L14/questions_ecrites1414090000435749140900004357493JO_QUESTION2013-07-09
14090000435756L14/questions_ecrites1414090000435749140900004357494JO_QUESTION2013-10-15
14090000435786L14/questions_ecrites1414090000435782140900004357821JO_QUESTION2015-02-17
14090000435787L14/questions_ecrites1414090000435782140900004357822JO_QUESTION2015-05-26
14090000435788L14/questions_ecrites1414090000435782140900004357823JO_QUESTION2015-09-08
14090000435830L14/questions_ecrites1414090000435825140900004358251JO_QUESTION2014-08-19
14090000435871L14/questions_ecrites1414090000435863140900004358631JO_QUESTION2013-07-16
14090000435872L14/questions_ecrites1414090000435863140900004358632JO_QUESTION2013-10-22
14090000435873L14/questions_ecrites1414090000435863140900004358633JO_QUESTION2014-02-11
14090000435874L14/questions_ecrites1414090000435863140900004358634JO_QUESTION2014-05-27
14090000435875L14/questions_ecrites1414090000435863140900004358635JO_QUESTION2014-09-02
14090000435876L14/questions_ecrites1414090000435863140900004358636JO_QUESTION2014-12-09
14090000435877L14/questions_ecrites1414090000435863140900004358637JO_QUESTION2015-03-17
14090000435878L14/questions_ecrites1414090000435863140900004358638JO_QUESTION2015-06-23
14090000435879L14/questions_ecrites1414090000435863140900004358639JO_QUESTION2016-04-26
14090000435880L14/questions_ecrites14140900004358631409000043586310JO_QUESTION2017-05-09
14090000435892L14/questions_ecrites1414090000435886140900004358861JO_QUESTION2015-01-13
14090000435906L14/questions_ecrites1414090000435898140900004358981JO_QUESTION2014-05-20