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
14090000277832L14/questions_ecrites1414090000277825140900002778251JO_QUESTION2014-10-21
14090000277833L14/questions_ecrites1414090000277825140900002778252JO_QUESTION2015-02-24
14090000277834L14/questions_ecrites1414090000277825140900002778253JO_QUESTION2015-06-30
14090000277847L14/questions_ecrites1414090000277839140900002778391JO_QUESTION2014-10-14
14090000277852L14/questions_ecrites1414090000277848140900002778481JO_QUESTION2015-03-10
14090000277857L14/questions_ecrites1414090000277853140900002778531JO_QUESTION2013-03-05
14090000277865L14/questions_ecrites1414090000277858140900002778581JO_QUESTION2015-02-17
14090000277913L14/questions_ecrites1414090000277906140900002779061JO_QUESTION2015-01-20
14090000277922L14/questions_ecrites1414090000277914140900002779141JO_QUESTION2015-02-17
14090000277932L14/questions_ecrites1414090000277923140900002779231JO_QUESTION2016-07-26
14090000277938L14/questions_ecrites1414090000277933140900002779331JO_QUESTION2014-10-14
14090000277948L14/questions_ecrites1414090000277943140900002779431JO_QUESTION2013-03-19
14090000277949L14/questions_ecrites1414090000277943140900002779432JO_QUESTION2013-06-25
14090000277950L14/questions_ecrites1414090000277943140900002779433JO_QUESTION2013-10-01
14090000277951L14/questions_ecrites1414090000277943140900002779434JO_QUESTION2014-01-21
14090000277968L14/questions_ecrites1414090000277961140900002779611JO_QUESTION2014-10-07
14090000277969L14/questions_ecrites1414090000277961140900002779612JO_QUESTION2015-02-10
14090000277974L14/questions_ecrites1414090000277970140900002779701JO_QUESTION2013-04-16
14090000277996L14/questions_ecrites1414090000277988140900002779881JO_QUESTION2013-05-21
14090000277997L14/questions_ecrites1414090000277988140900002779882JO_QUESTION2013-09-10
14090000277998L14/questions_ecrites1414090000277988140900002779883JO_QUESTION2013-12-17
14090000277999L14/questions_ecrites1414090000277988140900002779884JO_QUESTION2014-04-08
14090000278000L14/questions_ecrites1414090000277988140900002779885JO_QUESTION2014-07-29
14090000278001L14/questions_ecrites1414090000277988140900002779886JO_QUESTION2014-11-11
14090000278002L14/questions_ecrites1414090000277988140900002779887JO_QUESTION2015-02-17
14090000278003L14/questions_ecrites1414090000277988140900002779888JO_QUESTION2015-06-09
14090000278004L14/questions_ecrites1414090000277988140900002779889JO_QUESTION2015-09-15
14090000278005L14/questions_ecrites14140900002779881409000027798810JO_QUESTION2015-09-15
14090000278006L14/questions_ecrites14140900002779881409000027798811JO_QUESTION2015-12-22
14090000278007L14/questions_ecrites14140900002779881409000027798812JO_QUESTION2016-03-29
14090000278008L14/questions_ecrites14140900002779881409000027798813JO_QUESTION2016-07-12
14090000278009L14/questions_ecrites14140900002779881409000027798814JO_QUESTION2016-10-18
14090000278010L14/questions_ecrites14140900002779881409000027798815JO_QUESTION2017-01-24
14090000278011L14/questions_ecrites14140900002779881409000027798816JO_QUESTION2017-05-02
14090000278026L14/questions_ecrites1414090000278022140900002780221JO_QUESTION2014-07-22
14090000278037L14/questions_ecrites1414090000278032140900002780321JO_QUESTION2013-01-29
14090000278038L14/questions_ecrites1414090000278032140900002780322JO_QUESTION2013-05-28
14090000278043L14/questions_ecrites1414090000278039140900002780391JO_QUESTION2013-02-12
14090000278044L14/questions_ecrites1414090000278039140900002780392JO_QUESTION2013-06-25
14090000278056L14/questions_ecrites1414090000278052140900002780521JO_QUESTION2013-04-16
14090000278057L14/questions_ecrites1414090000278052140900002780522JO_QUESTION2013-07-30
14090000278075L14/questions_ecrites1414090000278070140900002780701JO_QUESTION2014-10-07
14090000278076L14/questions_ecrites1414090000278070140900002780702JO_QUESTION2015-01-13
14090000278087L14/questions_ecrites1414090000278081140900002780811JO_QUESTION2015-01-20
14090000278088L14/questions_ecrites1414090000278081140900002780812JO_QUESTION2015-05-05
14090000278089L14/questions_ecrites1414090000278081140900002780813JO_QUESTION2015-08-25
14090000278090L14/questions_ecrites1414090000278081140900002780814JO_QUESTION2016-01-12
14090000278091L14/questions_ecrites1414090000278081140900002780815JO_QUESTION2016-04-19
14090000278092L14/questions_ecrites1414090000278081140900002780816JO_QUESTION2016-09-20
14090000278093L14/questions_ecrites1414090000278081140900002780817JO_QUESTION2017-01-17