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
14090000376515L14/questions_ecrites1414090000376503140900003765036JO_QUESTION2015-02-17
14090000376516L14/questions_ecrites1414090000376503140900003765037JO_QUESTION2015-05-26
14090000376531L14/questions_ecrites1414090000376527140900003765271JO_QUESTION2013-04-02
14090000376543L14/questions_ecrites1414090000376538140900003765381JO_QUESTION2015-02-03
14090000376544L14/questions_ecrites1414090000376538140900003765382JO_QUESTION2015-06-09
14090000376545L14/questions_ecrites1414090000376538140900003765383JO_QUESTION2015-09-15
14090000376550L14/questions_ecrites1414090000376546140900003765461JO_QUESTION2013-07-02
14090000376613L14/questions_ecrites1414090000376609140900003766091JO_QUESTION2013-01-08
14090000376647L14/questions_ecrites1414090000376641140900003766411JO_QUESTION2014-09-23
14090000376662L14/questions_ecrites1414090000376656140900003766561JO_QUESTION2014-01-14
14090000376663L14/questions_ecrites1414090000376656140900003766562JO_QUESTION2014-04-29
14090000376689L14/questions_ecrites1414090000376685140900003766851JO_QUESTION2013-03-26
14090000376690L14/questions_ecrites1414090000376685140900003766852JO_QUESTION2013-07-09
14090000376727L14/questions_ecrites1414090000376723140900003767231JO_QUESTION2013-04-16
14090000376739L14/questions_ecrites1414090000376732140900003767321JO_QUESTION2014-11-18
14090000376740L14/questions_ecrites1414090000376732140900003767322JO_QUESTION2015-02-24
14090000376741L14/questions_ecrites1414090000376732140900003767323JO_QUESTION2015-06-02
14090000376742L14/questions_ecrites1414090000376732140900003767324JO_QUESTION2016-04-26
14090000376747L14/questions_ecrites1414090000376743140900003767431JO_QUESTION2014-01-28
14090000376797L14/questions_ecrites1414090000376792140900003767921JO_QUESTION2014-03-11
14090000376798L14/questions_ecrites1414090000376792140900003767922JO_QUESTION2014-11-04
14090000376799L14/questions_ecrites1414090000376792140900003767923JO_QUESTION2015-04-28
14090000376815L14/questions_ecrites1414090000376811140900003768111JO_QUESTION2012-12-04
14090000376826L14/questions_ecrites1414090000376816140900003768161JO_QUESTION2014-01-14
14090000376827L14/questions_ecrites1414090000376816140900003768162JO_QUESTION2014-09-09
14090000376833L14/questions_ecrites1414090000376828140900003768281JO_QUESTION2014-10-28
14090000376834L14/questions_ecrites1414090000376828140900003768282JO_QUESTION2015-02-03
14090000376835L14/questions_ecrites1414090000376828140900003768283JO_QUESTION2015-06-23
14090000376836L14/questions_ecrites1414090000376828140900003768284JO_QUESTION2015-09-29
14090000376870L14/questions_ecrites1414090000376864140900003768641JO_QUESTION2013-10-01
14090000376871L14/questions_ecrites1414090000376864140900003768642JO_QUESTION2014-01-07
14090000376872L14/questions_ecrites1414090000376864140900003768643JO_QUESTION2014-04-15
14090000376873L14/questions_ecrites1414090000376864140900003768644JO_QUESTION2014-07-22
14090000376874L14/questions_ecrites1414090000376864140900003768645JO_QUESTION2014-10-28
14090000376882L14/questions_ecrites1414090000376875140900003768751JO_QUESTION2014-05-27
14090000376883L14/questions_ecrites1414090000376875140900003768752JO_QUESTION2014-09-16
14090000376884L14/questions_ecrites1414090000376875140900003768753JO_QUESTION2014-12-23
14090000376885L14/questions_ecrites1414090000376875140900003768754JO_QUESTION2015-04-21
14090000376886L14/questions_ecrites1414090000376875140900003768755JO_QUESTION2015-08-04
14090000376887L14/questions_ecrites1414090000376875140900003768756JO_QUESTION2016-05-10
14090000376888L14/questions_ecrites1414090000376875140900003768757JO_QUESTION2016-08-30
14090000376902L14/questions_ecrites1414090000376898140900003768981JO_QUESTION2013-01-22
14090000376912L14/questions_ecrites1414090000376908140900003769081JO_QUESTION2013-03-26
14090000376913L14/questions_ecrites1414090000376908140900003769082JO_QUESTION2013-07-09
14090000376914L14/questions_ecrites1414090000376908140900003769083JO_QUESTION2013-10-22
14090000376915L14/questions_ecrites1414090000376908140900003769084JO_QUESTION2014-02-04
14090000376937L14/questions_ecrites1414090000376933140900003769331JO_QUESTION2013-05-07
14090000376948L14/questions_ecrites1414090000376942140900003769421JO_QUESTION2015-01-20
14090000376949L14/questions_ecrites1414090000376942140900003769422JO_QUESTION2015-05-12
14090000376950L14/questions_ecrites1414090000376942140900003769423JO_QUESTION2015-09-15