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
14090000428601L14/questions_ecrites1414090000428594140900004285941JO_QUESTION2015-01-20
14090000428602L14/questions_ecrites1414090000428594140900004285942JO_QUESTION2015-06-23
14090000428603L14/questions_ecrites1414090000428594140900004285943JO_QUESTION2015-09-29
14090000428604L14/questions_ecrites1414090000428594140900004285944JO_QUESTION2016-01-05
14090000428605L14/questions_ecrites1414090000428594140900004285945JO_QUESTION2016-04-12
14090000428606L14/questions_ecrites1414090000428594140900004285946JO_QUESTION2016-07-12
14090000428607L14/questions_ecrites1414090000428594140900004285947JO_QUESTION2016-11-22
14090000428608L14/questions_ecrites1414090000428594140900004285948JO_QUESTION2017-02-28
14090000428618L14/questions_ecrites1414090000428614140900004286141JO_QUESTION2013-04-02
14090000428633L14/questions_ecrites1414090000428629140900004286291JO_QUESTION2012-10-23
14090000428653L14/questions_ecrites1414090000428649140900004286491JO_QUESTION2013-09-03
14090000428669L14/questions_ecrites1414090000428664140900004286641JO_QUESTION2014-06-10
14090000428685L14/questions_ecrites1414090000428681140900004286811JO_QUESTION2013-05-28
14090000428686L14/questions_ecrites1414090000428681140900004286812JO_QUESTION2013-10-15
14090000428742L14/questions_ecrites1414090000428738140900004287381JO_QUESTION2013-07-09
14090000428753L14/questions_ecrites1414090000428747140900004287471JO_QUESTION2015-05-19
14090000428754L14/questions_ecrites1414090000428747140900004287472JO_QUESTION2015-09-08
14090000428755L14/questions_ecrites1414090000428747140900004287473JO_QUESTION2016-08-02
14090000428756L14/questions_ecrites1414090000428747140900004287474JO_QUESTION2017-05-23
14090000428766L14/questions_ecrites1414090000428762140900004287621JO_QUESTION2013-09-10
14090000428794L14/questions_ecrites1414090000428790140900004287901JO_QUESTION2015-02-03
14090000428864L14/questions_ecrites1414090000428860140900004288601JO_QUESTION2013-12-03
14090000428871L14/questions_ecrites1414090000428865140900004288651JO_QUESTION2014-04-29
14090000428872L14/questions_ecrites1414090000428865140900004288652JO_QUESTION2014-10-07
14090000428877L14/questions_ecrites1414090000428873140900004288731JO_QUESTION2015-02-03
14090000428900L14/questions_ecrites1414090000428895140900004288951JO_QUESTION2014-10-14
14090000428906L14/questions_ecrites1414090000428901140900004289011JO_QUESTION2013-02-12
14090000428907L14/questions_ecrites1414090000428901140900004289012JO_QUESTION2013-05-28
14090000428908L14/questions_ecrites1414090000428901140900004289013JO_QUESTION2013-09-24
14090000428909L14/questions_ecrites1414090000428901140900004289014JO_QUESTION2014-01-07
14090000428927L14/questions_ecrites1414090000428923140900004289231JO_QUESTION2013-03-26
14090000428951L14/questions_ecrites1414090000428947140900004289471JO_QUESTION2013-01-29
14090000428952L14/questions_ecrites1414090000428947140900004289472JO_QUESTION2013-06-04
14090000428966L14/questions_ecrites1414090000428962140900004289621JO_QUESTION2013-02-12
14090000428986L14/questions_ecrites1414090000428981140900004289811JO_QUESTION2017-03-14
14090000429023L14/questions_ecrites1414090000429013140900004290131JO_QUESTION2013-08-13
14090000429055L14/questions_ecrites1414090000429049140900004290491JO_QUESTION2016-03-29
14090000429056L14/questions_ecrites1414090000429049140900004290492JO_QUESTION2017-01-17
14090000429061L14/questions_ecrites1414090000429057140900004290571JO_QUESTION2015-01-13
14090000429062L14/questions_ecrites1414090000429057140900004290572JO_QUESTION2015-04-21
14090000429116L14/questions_ecrites1414090000429108140900004291081JO_QUESTION2014-10-21
14090000429117L14/questions_ecrites1414090000429108140900004291082JO_QUESTION2015-03-03
14090000429118L14/questions_ecrites1414090000429108140900004291083JO_QUESTION2015-08-04
14090000429119L14/questions_ecrites1414090000429108140900004291084JO_QUESTION2016-08-02
14090000429120L14/questions_ecrites1414090000429108140900004291085JO_QUESTION2017-05-23
14090000429126L14/questions_ecrites1414090000429121140900004291211JO_QUESTION2014-09-30
14090000429127L14/questions_ecrites1414090000429121140900004291212JO_QUESTION2015-03-24
14090000429135L14/questions_ecrites1414090000429128140900004291281JO_QUESTION2014-10-14
14090000429136L14/questions_ecrites1414090000429128140900004291282JO_QUESTION2015-01-20
14090000429137L14/questions_ecrites1414090000429128140900004291283JO_QUESTION2015-06-23