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
14090000311165L14/questions_ecrites1414090000311156140900003111561JO_QUESTION2013-12-03
14090000311183L14/questions_ecrites1414090000311178140900003111781JO_QUESTION2013-07-09
14090000311184L14/questions_ecrites1414090000311178140900003111782JO_QUESTION2013-10-15
14090000311204L14/questions_ecrites1414090000311195140900003111951JO_QUESTION2014-04-22
14090000311205L14/questions_ecrites1414090000311195140900003111952JO_QUESTION2014-08-26
14090000311206L14/questions_ecrites1414090000311195140900003111953JO_QUESTION2015-01-20
14090000311207L14/questions_ecrites1414090000311195140900003111954JO_QUESTION2015-05-12
14090000311208L14/questions_ecrites1414090000311195140900003111955JO_QUESTION2015-09-15
14090000311209L14/questions_ecrites1414090000311195140900003111956JO_QUESTION2015-09-15
14090000311210L14/questions_ecrites1414090000311195140900003111957JO_QUESTION2016-01-12
14090000311217L14/questions_ecrites1414090000311211140900003112111JO_QUESTION2015-05-19
14090000311218L14/questions_ecrites1414090000311211140900003112112JO_QUESTION2015-10-06
14090000311219L14/questions_ecrites1414090000311211140900003112113JO_QUESTION2016-09-13
14090000311220L14/questions_ecrites1414090000311211140900003112114JO_QUESTION2017-01-10
14090000311245L14/questions_ecrites1414090000311239140900003112391JO_QUESTION2014-10-28
14090000311298L14/questions_ecrites1414090000311288140900003112881JO_QUESTION2014-02-25
14090000311299L14/questions_ecrites1414090000311288140900003112882JO_QUESTION2014-09-23
14090000311300L14/questions_ecrites1414090000311288140900003112883JO_QUESTION2015-03-03
14090000311309L14/questions_ecrites1414090000311305140900003113051JO_QUESTION2014-02-25
14090000311314L14/questions_ecrites1414090000311310140900003113101JO_QUESTION2014-08-26
14090000311315L14/questions_ecrites1414090000311310140900003113102JO_QUESTION2014-12-02
14090000311316L14/questions_ecrites1414090000311310140900003113103JO_QUESTION2015-06-16
14090000311317L14/questions_ecrites1414090000311310140900003113104JO_QUESTION2015-09-29
14090000311332L14/questions_ecrites1414090000311326140900003113261JO_QUESTION2013-06-25
14090000311369L14/questions_ecrites1414090000311363140900003113631JO_QUESTION2015-10-27
14090000311400L14/questions_ecrites1414090000311396140900003113961JO_QUESTION2013-01-15
14090000311405L14/questions_ecrites1414090000311401140900003114011JO_QUESTION2013-07-30
14090000311451L14/questions_ecrites1414090000311446140900003114461JO_QUESTION2013-02-05
14090000311452L14/questions_ecrites1414090000311446140900003114462JO_QUESTION2013-05-28
14090000311453L14/questions_ecrites1414090000311446140900003114463JO_QUESTION2013-09-10
14090000311508L14/questions_ecrites1414090000311504140900003115041JO_QUESTION2013-10-01
14090000311518L14/questions_ecrites1414090000311513140900003115131JO_QUESTION2014-09-16
14090000311519L14/questions_ecrites1414090000311513140900003115132JO_QUESTION2014-12-23
14090000311520L14/questions_ecrites1414090000311513140900003115133JO_QUESTION2015-04-21
14090000311521L14/questions_ecrites1414090000311513140900003115134JO_QUESTION2015-08-04
14090000311582L14/questions_ecrites1414090000311576140900003115761JO_QUESTION2013-02-26
14090000311583L14/questions_ecrites1414090000311576140900003115762JO_QUESTION2013-06-04
14090000311584L14/questions_ecrites1414090000311576140900003115763JO_QUESTION2013-09-10
14090000311585L14/questions_ecrites1414090000311576140900003115764JO_QUESTION2013-12-17
14090000311586L14/questions_ecrites1414090000311576140900003115765JO_QUESTION2014-03-25
14090000311587L14/questions_ecrites1414090000311576140900003115766JO_QUESTION2014-07-01
14090000311588L14/questions_ecrites1414090000311576140900003115767JO_QUESTION2014-10-07
14090000311611L14/questions_ecrites1414090000311601140900003116011JO_QUESTION2015-02-17
14090000311617L14/questions_ecrites1414090000311612140900003116121JO_QUESTION2013-04-02
14090000311631L14/questions_ecrites1414090000311626140900003116261JO_QUESTION2014-11-11
14090000311650L14/questions_ecrites1414090000311641140900003116411JO_QUESTION2014-09-09
14090000311678L14/questions_ecrites1414090000311673140900003116731JO_QUESTION2014-11-25
14090000311700L14/questions_ecrites1414090000311694140900003116941JO_QUESTION2013-07-30
14090000311701L14/questions_ecrites1414090000311694140900003116942JO_QUESTION2013-11-05
14090000311702L14/questions_ecrites1414090000311694140900003116943JO_QUESTION2014-02-11