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
14090000406627L14/questions_ecrites1414090000406622140900004066222JO_QUESTION2013-05-07
14090000406633L14/questions_ecrites1414090000406628140900004066281JO_QUESTION2013-07-16
14090000406634L14/questions_ecrites1414090000406628140900004066282JO_QUESTION2013-12-17
14090000406641L14/questions_ecrites1414090000406635140900004066351JO_QUESTION2014-01-07
14090000406642L14/questions_ecrites1414090000406635140900004066352JO_QUESTION2014-04-15
14090000406643L14/questions_ecrites1414090000406635140900004066353JO_QUESTION2014-07-22
14090000406644L14/questions_ecrites1414090000406635140900004066354JO_QUESTION2014-10-28
14090000406658L14/questions_ecrites1414090000406651140900004066511JO_QUESTION2014-05-13
14090000406659L14/questions_ecrites1414090000406651140900004066512JO_QUESTION2014-08-26
14090000406703L14/questions_ecrites1414090000406697140900004066971JO_QUESTION2014-12-09
14090000406704L14/questions_ecrites1414090000406697140900004066972JO_QUESTION2015-03-17
14090000406748L14/questions_ecrites1414090000406740140900004067401JO_QUESTION2013-06-25
14090000406749L14/questions_ecrites1414090000406740140900004067402JO_QUESTION2013-10-08
14090000406750L14/questions_ecrites1414090000406740140900004067403JO_QUESTION2014-02-11
14090000406751L14/questions_ecrites1414090000406740140900004067404JO_QUESTION2014-05-20
14090000406752L14/questions_ecrites1414090000406740140900004067405JO_QUESTION2014-09-23
14090000406753L14/questions_ecrites1414090000406740140900004067406JO_QUESTION2015-02-17
14090000406754L14/questions_ecrites1414090000406740140900004067407JO_QUESTION2015-05-26
14090000406755L14/questions_ecrites1414090000406740140900004067408JO_QUESTION2015-09-08
14090000406756L14/questions_ecrites1414090000406740140900004067409JO_QUESTION2016-02-23
14090000406757L14/questions_ecrites14140900004067401409000040674010JO_QUESTION2016-06-21
14090000406758L14/questions_ecrites14140900004067401409000040674011JO_QUESTION2016-09-27
14090000406759L14/questions_ecrites14140900004067401409000040674012JO_QUESTION2017-01-10
14090000406760L14/questions_ecrites14140900004067401409000040674013JO_QUESTION2017-05-02
14090000406765L14/questions_ecrites1414090000406761140900004067611JO_QUESTION2013-06-25
14090000406766L14/questions_ecrites1414090000406761140900004067612JO_QUESTION2013-12-31
14090000406771L14/questions_ecrites1414090000406767140900004067671JO_QUESTION2012-10-23
14090000406778L14/questions_ecrites1414090000406772140900004067721JO_QUESTION2014-06-10
14090000406779L14/questions_ecrites1414090000406772140900004067722JO_QUESTION2014-09-23
14090000406789L14/questions_ecrites1414090000406784140900004067841JO_QUESTION2014-10-21
14090000406790L14/questions_ecrites1414090000406784140900004067842JO_QUESTION2015-02-03
14090000406811L14/questions_ecrites1414090000406807140900004068071JO_QUESTION2013-02-19
14090000406820L14/questions_ecrites1414090000406812140900004068121JO_QUESTION2014-05-20
14090000406821L14/questions_ecrites1414090000406812140900004068122JO_QUESTION2014-09-09
14090000406841L14/questions_ecrites1414090000406836140900004068361JO_QUESTION2012-12-25
14090000406842L14/questions_ecrites1414090000406836140900004068362JO_QUESTION2013-04-02
14090000406843L14/questions_ecrites1414090000406836140900004068363JO_QUESTION2013-07-09
14090000406844L14/questions_ecrites1414090000406836140900004068364JO_QUESTION2013-10-29
14090000406845L14/questions_ecrites1414090000406836140900004068365JO_QUESTION2014-02-11
14090000406846L14/questions_ecrites1414090000406836140900004068366JO_QUESTION2014-05-27
14090000406858L14/questions_ecrites1414090000406851140900004068511JO_QUESTION2014-09-30
14090000406859L14/questions_ecrites1414090000406851140900004068512JO_QUESTION2015-01-20
14090000406860L14/questions_ecrites1414090000406851140900004068513JO_QUESTION2015-05-12
14090000406861L14/questions_ecrites1414090000406851140900004068514JO_QUESTION2015-09-15
14090000406862L14/questions_ecrites1414090000406851140900004068515JO_QUESTION2015-09-15
14090000406863L14/questions_ecrites1414090000406851140900004068516JO_QUESTION2016-01-12
14090000406864L14/questions_ecrites1414090000406851140900004068517JO_QUESTION2016-05-24
14090000406865L14/questions_ecrites1414090000406851140900004068518JO_QUESTION2016-09-27
14090000406866L14/questions_ecrites1414090000406851140900004068519JO_QUESTION2017-03-21
14090000406876L14/questions_ecrites1414090000406871140900004068711JO_QUESTION2015-02-24