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
14090000326635L14/questions_ecrites1414090000326621140900003266217JO_QUESTION2015-05-26
14090000326636L14/questions_ecrites1414090000326621140900003266218JO_QUESTION2015-09-08
14090000326637L14/questions_ecrites1414090000326621140900003266219JO_QUESTION2016-02-23
14090000326638L14/questions_ecrites14140900003266211409000032662110JO_QUESTION2016-06-21
14090000326639L14/questions_ecrites14140900003266211409000032662111JO_QUESTION2016-09-27
14090000326640L14/questions_ecrites14140900003266211409000032662112JO_QUESTION2017-01-10
14090000326680L14/questions_ecrites1414090000326674140900003266741JO_QUESTION2016-05-17
14090000326701L14/questions_ecrites1414090000326693140900003266931JO_QUESTION2015-02-17
14090000326717L14/questions_ecrites1414090000326710140900003267101JO_QUESTION2013-05-07
14090000326729L14/questions_ecrites1414090000326722140900003267221JO_QUESTION2014-10-14
14090000326730L14/questions_ecrites1414090000326722140900003267222JO_QUESTION2015-01-20
14090000326731L14/questions_ecrites1414090000326722140900003267223JO_QUESTION2015-06-23
14090000326732L14/questions_ecrites1414090000326722140900003267224JO_QUESTION2015-09-29
14090000326733L14/questions_ecrites1414090000326722140900003267225JO_QUESTION2016-01-05
14090000326734L14/questions_ecrites1414090000326722140900003267226JO_QUESTION2016-04-12
14090000326735L14/questions_ecrites1414090000326722140900003267227JO_QUESTION2016-07-12
14090000326736L14/questions_ecrites1414090000326722140900003267228JO_QUESTION2016-11-22
14090000326737L14/questions_ecrites1414090000326722140900003267229JO_QUESTION2017-02-28
14090000326748L14/questions_ecrites1414090000326742140900003267421JO_QUESTION2014-07-01
14090000326749L14/questions_ecrites1414090000326742140900003267422JO_QUESTION2014-10-07
14090000326750L14/questions_ecrites1414090000326742140900003267423JO_QUESTION2015-03-03
14090000326767L14/questions_ecrites1414090000326759140900003267591JO_QUESTION2013-11-12
14090000326768L14/questions_ecrites1414090000326759140900003267592JO_QUESTION2014-02-18
14090000326769L14/questions_ecrites1414090000326759140900003267593JO_QUESTION2014-09-16
14090000326770L14/questions_ecrites1414090000326759140900003267594JO_QUESTION2015-01-20
14090000326771L14/questions_ecrites1414090000326759140900003267595JO_QUESTION2015-06-16
14090000326810L14/questions_ecrites1414090000326806140900003268061JO_QUESTION2015-07-07
14090000326822L14/questions_ecrites1414090000326818140900003268181JO_QUESTION2013-10-15
14090000326853L14/questions_ecrites1414090000326847140900003268471JO_QUESTION2014-03-04
14090000326854L14/questions_ecrites1414090000326847140900003268472JO_QUESTION2014-09-23
14090000326867L14/questions_ecrites1414090000326863140900003268631JO_QUESTION2013-04-16
14090000326875L14/questions_ecrites1414090000326868140900003268681JO_QUESTION2016-05-10
14090000326882L14/questions_ecrites1414090000326876140900003268761JO_QUESTION2014-09-23
14090000326883L14/questions_ecrites1414090000326876140900003268762JO_QUESTION2015-01-20
14090000326896L14/questions_ecrites1414090000326889140900003268891JO_QUESTION2014-10-28
14090000326897L14/questions_ecrites1414090000326889140900003268892JO_QUESTION2015-02-03
14090000326898L14/questions_ecrites1414090000326889140900003268893JO_QUESTION2015-06-23
14090000326899L14/questions_ecrites1414090000326889140900003268894JO_QUESTION2015-09-29
14090000326900L14/questions_ecrites1414090000326889140900003268895JO_QUESTION2016-01-05
14090000326901L14/questions_ecrites1414090000326889140900003268896JO_QUESTION2016-04-12
14090000326902L14/questions_ecrites1414090000326889140900003268897JO_QUESTION2016-07-12
14090000326903L14/questions_ecrites1414090000326889140900003268898JO_QUESTION2016-11-22
14090000326904L14/questions_ecrites1414090000326889140900003268899JO_QUESTION2017-02-28
14090000326913L14/questions_ecrites1414090000326905140900003269051JO_QUESTION2014-06-03
14090000326914L14/questions_ecrites1414090000326905140900003269052JO_QUESTION2014-09-09
14090000326946L14/questions_ecrites1414090000326941140900003269411JO_QUESTION2014-10-14
14090000326975L14/questions_ecrites1414090000326968140900003269681JO_QUESTION2014-12-23
14090000326976L14/questions_ecrites1414090000326968140900003269682JO_QUESTION2015-04-21
14090000326977L14/questions_ecrites1414090000326968140900003269683JO_QUESTION2015-08-04
14090000326978L14/questions_ecrites1414090000326968140900003269684JO_QUESTION2016-08-02