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
14090000305151L14/questions_ecrites1414090000305144140900003051441JO_QUESTION2014-10-07
14090000305152L14/questions_ecrites1414090000305144140900003051442JO_QUESTION2015-03-03
14090000305153L14/questions_ecrites1414090000305144140900003051443JO_QUESTION2015-08-04
14090000305154L14/questions_ecrites1414090000305144140900003051444JO_QUESTION2016-08-02
14090000305155L14/questions_ecrites1414090000305144140900003051445JO_QUESTION2017-05-23
14090000305194L14/questions_ecrites1414090000305187140900003051871JO_QUESTION2015-09-15
14090000305195L14/questions_ecrites1414090000305187140900003051872JO_QUESTION2015-09-15
14090000305200L14/questions_ecrites1414090000305196140900003051961JO_QUESTION2013-09-17
14090000305218L14/questions_ecrites1414090000305214140900003052141JO_QUESTION2013-02-26
14090000305223L14/questions_ecrites1414090000305219140900003052191JO_QUESTION2013-06-04
14090000305224L14/questions_ecrites1414090000305219140900003052192JO_QUESTION2013-09-24
14090000305230L14/questions_ecrites1414090000305225140900003052251JO_QUESTION2017-05-23
14090000305307L14/questions_ecrites1414090000305301140900003053011JO_QUESTION2015-06-09
14090000305308L14/questions_ecrites1414090000305301140900003053012JO_QUESTION2015-09-29
14090000305309L14/questions_ecrites1414090000305301140900003053013JO_QUESTION2016-06-14
14090000305310L14/questions_ecrites1414090000305301140900003053014JO_QUESTION2016-10-18
14090000305311L14/questions_ecrites1414090000305301140900003053015JO_QUESTION2017-02-28
14090000305355L14/questions_ecrites1414090000305349140900003053491JO_QUESTION2013-05-28
14090000305356L14/questions_ecrites1414090000305349140900003053492JO_QUESTION2014-02-04
14090000305357L14/questions_ecrites1414090000305349140900003053493JO_QUESTION2014-06-17
14090000305358L14/questions_ecrites1414090000305349140900003053494JO_QUESTION2014-06-17
14090000305359L14/questions_ecrites1414090000305349140900003053495JO_QUESTION2014-10-07
14090000305360L14/questions_ecrites1414090000305349140900003053496JO_QUESTION2015-01-27
14090000305361L14/questions_ecrites1414090000305349140900003053497JO_QUESTION2015-09-01
14090000305362L14/questions_ecrites1414090000305349140900003053498JO_QUESTION2015-12-22
14090000305363L14/questions_ecrites1414090000305349140900003053499JO_QUESTION2016-04-05
14090000305364L14/questions_ecrites14140900003053491409000030534910JO_QUESTION2016-08-02
14090000305407L14/questions_ecrites1414090000305400140900003054001JO_QUESTION2014-10-28
14090000305408L14/questions_ecrites1414090000305400140900003054002JO_QUESTION2015-02-03
14090000305409L14/questions_ecrites1414090000305400140900003054003JO_QUESTION2015-06-23
14090000305410L14/questions_ecrites1414090000305400140900003054004JO_QUESTION2015-09-29
14090000305411L14/questions_ecrites1414090000305400140900003054005JO_QUESTION2016-01-05
14090000305412L14/questions_ecrites1414090000305400140900003054006JO_QUESTION2016-04-12
14090000305413L14/questions_ecrites1414090000305400140900003054007JO_QUESTION2016-07-12
14090000305414L14/questions_ecrites1414090000305400140900003054008JO_QUESTION2016-11-22
14090000305415L14/questions_ecrites1414090000305400140900003054009JO_QUESTION2017-02-28
14090000305449L14/questions_ecrites1414090000305442140900003054421JO_QUESTION2014-05-27
14090000305450L14/questions_ecrites1414090000305442140900003054422JO_QUESTION2014-09-23
14090000305456L14/questions_ecrites1414090000305451140900003054511JO_QUESTION2013-12-03
14090000305465L14/questions_ecrites1414090000305457140900003054571JO_QUESTION2013-10-08
14090000305466L14/questions_ecrites1414090000305457140900003054572JO_QUESTION2014-02-11
14090000305467L14/questions_ecrites1414090000305457140900003054573JO_QUESTION2014-06-17
14090000305468L14/questions_ecrites1414090000305457140900003054574JO_QUESTION2014-06-17
14090000305469L14/questions_ecrites1414090000305457140900003054575JO_QUESTION2014-11-18
14090000305470L14/questions_ecrites1414090000305457140900003054576JO_QUESTION2015-03-03
14090000305471L14/questions_ecrites1414090000305457140900003054577JO_QUESTION2015-06-16
14090000305477L14/questions_ecrites1414090000305472140900003054721JO_QUESTION2013-04-02
14090000305478L14/questions_ecrites1414090000305472140900003054722JO_QUESTION2013-07-09
14090000305494L14/questions_ecrites1414090000305488140900003054881JO_QUESTION2014-01-21
14090000305495L14/questions_ecrites1414090000305488140900003054882JO_QUESTION2014-05-06