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
14090000448082L14/questions_ecrites14140900004480611409000044806114JO_QUESTION2016-11-01
14090000448083L14/questions_ecrites14140900004480611409000044806115JO_QUESTION2017-02-07
14090000448084L14/questions_ecrites14140900004480611409000044806116JO_QUESTION2017-05-16
14090000448109L14/questions_ecrites1414090000448104140900004481041JO_QUESTION2013-07-16
14090000448110L14/questions_ecrites1414090000448104140900004481042JO_QUESTION2013-10-22
14090000448135L14/questions_ecrites1414090000448129140900004481291JO_QUESTION2013-08-27
14090000448136L14/questions_ecrites1414090000448129140900004481292JO_QUESTION2013-12-03
14090000448137L14/questions_ecrites1414090000448129140900004481293JO_QUESTION2014-03-25
14090000448138L14/questions_ecrites1414090000448129140900004481294JO_QUESTION2014-07-01
14090000448139L14/questions_ecrites1414090000448129140900004481295JO_QUESTION2014-10-07
14090000448140L14/questions_ecrites1414090000448129140900004481296JO_QUESTION2015-01-13
14090000448141L14/questions_ecrites1414090000448129140900004481297JO_QUESTION2015-04-21
14090000448189L14/questions_ecrites1414090000448185140900004481851JO_QUESTION2013-01-22
14090000448211L14/questions_ecrites1414090000448206140900004482061JO_QUESTION2014-01-14
14090000448242L14/questions_ecrites1414090000448228140900004482281JO_QUESTION2013-09-10
14090000448243L14/questions_ecrites1414090000448228140900004482282JO_QUESTION2014-01-14
14090000448244L14/questions_ecrites1414090000448228140900004482283JO_QUESTION2014-05-13
14090000448245L14/questions_ecrites1414090000448228140900004482284JO_QUESTION2014-09-30
14090000448246L14/questions_ecrites1414090000448228140900004482285JO_QUESTION2015-03-24
14090000448261L14/questions_ecrites1414090000448253140900004482531JO_QUESTION2014-09-09
14090000448281L14/questions_ecrites1414090000448273140900004482731JO_QUESTION2014-01-14
14090000448282L14/questions_ecrites1414090000448273140900004482732JO_QUESTION2014-09-09
14090000448300L14/questions_ecrites1414090000448296140900004482961JO_QUESTION2013-12-31
14090000448318L14/questions_ecrites1414090000448310140900004483101JO_QUESTION2015-02-17
14090000448336L14/questions_ecrites1414090000448328140900004483281JO_QUESTION2015-02-17
14090000448356L14/questions_ecrites1414090000448346140900004483461JO_QUESTION2014-10-28
14090000448357L14/questions_ecrites1414090000448346140900004483462JO_QUESTION2015-02-17
14090000448372L14/questions_ecrites1414090000448364140900004483641JO_QUESTION2015-09-15
14090000448373L14/questions_ecrites1414090000448364140900004483642JO_QUESTION2015-09-15
14090000448386L14/questions_ecrites1414090000448379140900004483791JO_QUESTION2014-10-28
14090000448387L14/questions_ecrites1414090000448379140900004483792JO_QUESTION2015-02-03
14090000448388L14/questions_ecrites1414090000448379140900004483793JO_QUESTION2015-06-23
14090000448389L14/questions_ecrites1414090000448379140900004483794JO_QUESTION2015-09-29
14090000448390L14/questions_ecrites1414090000448379140900004483795JO_QUESTION2016-01-05
14090000448391L14/questions_ecrites1414090000448379140900004483796JO_QUESTION2016-04-12
14090000448392L14/questions_ecrites1414090000448379140900004483797JO_QUESTION2016-07-12
14090000448393L14/questions_ecrites1414090000448379140900004483798JO_QUESTION2016-11-22
14090000448394L14/questions_ecrites1414090000448379140900004483799JO_QUESTION2017-02-28
14090000448412L14/questions_ecrites1414090000448407140900004484071JO_QUESTION2014-03-11
14090000448434L14/questions_ecrites1414090000448429140900004484291JO_QUESTION2014-05-20
14090000448452L14/questions_ecrites1414090000448445140900004484451JO_QUESTION2015-06-16
14090000448453L14/questions_ecrites1414090000448445140900004484452JO_QUESTION2016-07-26
14090000448567L14/questions_ecrites1414090000448562140900004485621JO_QUESTION2013-03-12
14090000448568L14/questions_ecrites1414090000448562140900004485622JO_QUESTION2013-07-09
14090000448610L14/questions_ecrites1414090000448605140900004486051JO_QUESTION2014-10-14
14090000448629L14/questions_ecrites1414090000448625140900004486251JO_QUESTION2015-03-24
14090000448634L14/questions_ecrites1414090000448630140900004486301JO_QUESTION2015-03-03
14090000448644L14/questions_ecrites1414090000448635140900004486351JO_QUESTION2013-04-09
14090000448684L14/questions_ecrites1414090000448676140900004486761JO_QUESTION2014-02-04
14090000448685L14/questions_ecrites1414090000448676140900004486762JO_QUESTION2014-05-13