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
14090000267518L14/questions_ecrites1414090000267510140900002675102JO_QUESTION2015-09-15
14090000267519L14/questions_ecrites1414090000267510140900002675103JO_QUESTION2015-09-15
14090000267520L14/questions_ecrites1414090000267510140900002675104JO_QUESTION2016-01-12
14090000267536L14/questions_ecrites1414090000267527140900002675271JO_QUESTION2014-05-27
14090000267537L14/questions_ecrites1414090000267527140900002675272JO_QUESTION2014-09-23
14090000267609L14/questions_ecrites1414090000267605140900002676051JO_QUESTION2012-11-13
14090000267629L14/questions_ecrites1414090000267625140900002676251JO_QUESTION2015-05-05
14090000267630L14/questions_ecrites1414090000267625140900002676252JO_QUESTION2016-03-01
14090000267636L14/questions_ecrites1414090000267631140900002676311JO_QUESTION2013-03-19
14090000267637L14/questions_ecrites1414090000267631140900002676312JO_QUESTION2013-06-25
14090000267689L14/questions_ecrites1414090000267683140900002676831JO_QUESTION2015-09-15
14090000267690L14/questions_ecrites1414090000267683140900002676832JO_QUESTION2015-09-15
14090000267731L14/questions_ecrites1414090000267723140900002677231JO_QUESTION2014-01-14
14090000267732L14/questions_ecrites1414090000267723140900002677232JO_QUESTION2014-09-09
14090000267740L14/questions_ecrites1414090000267733140900002677331JO_QUESTION2013-04-23
14090000267741L14/questions_ecrites1414090000267733140900002677332JO_QUESTION2013-07-30
14090000267742L14/questions_ecrites1414090000267733140900002677333JO_QUESTION2013-11-26
14090000267743L14/questions_ecrites1414090000267733140900002677334JO_QUESTION2014-03-11
14090000267744L14/questions_ecrites1414090000267733140900002677335JO_QUESTION2014-06-17
14090000267745L14/questions_ecrites1414090000267733140900002677336JO_QUESTION2014-06-17
14090000267801L14/questions_ecrites1414090000267797140900002677971JO_QUESTION2015-03-24
14090000267802L14/questions_ecrites1414090000267797140900002677972JO_QUESTION2015-06-30
14090000267811L14/questions_ecrites1414090000267807140900002678071JO_QUESTION2013-07-09
14090000267820L14/questions_ecrites1414090000267812140900002678121JO_QUESTION2014-04-08
14090000267821L14/questions_ecrites1414090000267812140900002678122JO_QUESTION2014-10-21
14090000267822L14/questions_ecrites1414090000267812140900002678123JO_QUESTION2015-02-24
14090000267823L14/questions_ecrites1414090000267812140900002678124JO_QUESTION2015-06-30
14090000267840L14/questions_ecrites1414090000267836140900002678361JO_QUESTION2014-03-04
14090000267852L14/questions_ecrites1414090000267845140900002678451JO_QUESTION2013-09-10
14090000267853L14/questions_ecrites1414090000267845140900002678452JO_QUESTION2013-12-17
14090000267854L14/questions_ecrites1414090000267845140900002678453JO_QUESTION2014-04-01
14090000267855L14/questions_ecrites1414090000267845140900002678454JO_QUESTION2014-10-14
14090000267856L14/questions_ecrites1414090000267845140900002678455JO_QUESTION2015-01-27
14090000267857L14/questions_ecrites1414090000267845140900002678456JO_QUESTION2015-08-25
14090000267858L14/questions_ecrites1414090000267845140900002678457JO_QUESTION2015-12-15
14090000267859L14/questions_ecrites1414090000267845140900002678458JO_QUESTION2016-03-22
14090000267860L14/questions_ecrites1414090000267845140900002678459JO_QUESTION2016-06-28
14090000267895L14/questions_ecrites1414090000267889140900002678891JO_QUESTION2014-10-07
14090000267910L14/questions_ecrites1414090000267905140900002679051JO_QUESTION2014-10-28
14090000267911L14/questions_ecrites1414090000267905140900002679052JO_QUESTION2015-02-03
14090000267920L14/questions_ecrites1414090000267912140900002679121JO_QUESTION2014-09-16
14090000267921L14/questions_ecrites1414090000267912140900002679122JO_QUESTION2015-03-10
14090000267922L14/questions_ecrites1414090000267912140900002679123JO_QUESTION2015-07-14
14090000267923L14/questions_ecrites1414090000267912140900002679124JO_QUESTION2015-10-20
14090000267924L14/questions_ecrites1414090000267912140900002679125JO_QUESTION2016-03-15
14090000267941L14/questions_ecrites1414090000267933140900002679331JO_QUESTION2014-08-26
14090000267942L14/questions_ecrites1414090000267933140900002679332JO_QUESTION2015-01-20
14090000267943L14/questions_ecrites1414090000267933140900002679333JO_QUESTION2015-05-12
14090000267944L14/questions_ecrites1414090000267933140900002679334JO_QUESTION2015-09-15
14090000267945L14/questions_ecrites1414090000267933140900002679335JO_QUESTION2015-09-15