AN · données ouvertes
Explorateur / questions_ecrites

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
14090000237750L14/questions_ecrites1414090000237745140900002377452JO_QUESTION2013-10-22
14090000237775L14/questions_ecrites1414090000237767140900002377671JO_QUESTION2014-05-20
14090000237776L14/questions_ecrites1414090000237767140900002377672JO_QUESTION2015-03-17
14090000237777L14/questions_ecrites1414090000237767140900002377673JO_QUESTION2015-08-11
14090000237795L14/questions_ecrites1414090000237791140900002377911JO_QUESTION2012-12-25
14090000237796L14/questions_ecrites1414090000237791140900002377912JO_QUESTION2013-04-02
14090000237805L14/questions_ecrites1414090000237797140900002377971JO_QUESTION2015-02-17
14090000237845L14/questions_ecrites1414090000237837140900002378371JO_QUESTION2013-03-19
14090000237846L14/questions_ecrites1414090000237837140900002378372JO_QUESTION2013-06-25
14090000237847L14/questions_ecrites1414090000237837140900002378373JO_QUESTION2013-10-01
14090000237848L14/questions_ecrites1414090000237837140900002378374JO_QUESTION2014-01-21
14090000237849L14/questions_ecrites1414090000237837140900002378375JO_QUESTION2014-04-29
14090000237850L14/questions_ecrites1414090000237837140900002378376JO_QUESTION2014-08-05
14090000237851L14/questions_ecrites1414090000237837140900002378377JO_QUESTION2015-01-20
14090000237852L14/questions_ecrites1414090000237837140900002378378JO_QUESTION2015-06-23
14090000237853L14/questions_ecrites1414090000237837140900002378379JO_QUESTION2015-09-29
14090000237854L14/questions_ecrites14140900002378371409000023783710JO_QUESTION2016-01-05
14090000237855L14/questions_ecrites14140900002378371409000023783711JO_QUESTION2016-04-12
14090000237856L14/questions_ecrites14140900002378371409000023783712JO_QUESTION2016-07-12
14090000237857L14/questions_ecrites14140900002378371409000023783713JO_QUESTION2016-11-22
14090000237858L14/questions_ecrites14140900002378371409000023783714JO_QUESTION2017-02-28
14090000237882L14/questions_ecrites1414090000237877140900002378771JO_QUESTION2014-12-09
14090000237914L14/questions_ecrites1414090000237910140900002379101JO_QUESTION2013-02-12
14090000237915L14/questions_ecrites1414090000237910140900002379102JO_QUESTION2013-06-25
14090000237916L14/questions_ecrites1414090000237910140900002379103JO_QUESTION2013-10-08
14090000237924L14/questions_ecrites1414090000237917140900002379171JO_QUESTION2015-09-15
14090000237925L14/questions_ecrites1414090000237917140900002379172JO_QUESTION2015-09-15
14090000237932L14/questions_ecrites1414090000237926140900002379261JO_QUESTION2015-01-20
14090000237933L14/questions_ecrites1414090000237926140900002379262JO_QUESTION2015-06-23
14090000237934L14/questions_ecrites1414090000237926140900002379263JO_QUESTION2015-09-29
14090000237935L14/questions_ecrites1414090000237926140900002379264JO_QUESTION2016-01-05
14090000237936L14/questions_ecrites1414090000237926140900002379265JO_QUESTION2016-04-12
14090000237937L14/questions_ecrites1414090000237926140900002379266JO_QUESTION2016-07-12
14090000237975L14/questions_ecrites1414090000237971140900002379711JO_QUESTION2013-07-16
14090000237976L14/questions_ecrites1414090000237971140900002379712JO_QUESTION2013-10-29
14090000238000L14/questions_ecrites1414090000237996140900002379961JO_QUESTION2013-06-11
14090000238006L14/questions_ecrites1414090000238001140900002380011JO_QUESTION2014-09-09
14090000238021L14/questions_ecrites1414090000238015140900002380151JO_QUESTION2014-10-28
14090000238022L14/questions_ecrites1414090000238015140900002380152JO_QUESTION2015-03-17
14090000238073L14/questions_ecrites1414090000238064140900002380641JO_QUESTION2014-10-14
14090000238074L14/questions_ecrites1414090000238064140900002380642JO_QUESTION2015-01-20
14090000238075L14/questions_ecrites1414090000238064140900002380643JO_QUESTION2015-06-23
14090000238076L14/questions_ecrites1414090000238064140900002380644JO_QUESTION2015-09-29
14090000238077L14/questions_ecrites1414090000238064140900002380645JO_QUESTION2016-01-05
14090000238078L14/questions_ecrites1414090000238064140900002380646JO_QUESTION2016-04-12
14090000238079L14/questions_ecrites1414090000238064140900002380647JO_QUESTION2016-07-12
14090000238080L14/questions_ecrites1414090000238064140900002380648JO_QUESTION2016-11-22
14090000238081L14/questions_ecrites1414090000238064140900002380649JO_QUESTION2017-02-28
14090000238097L14/questions_ecrites1414090000238091140900002380911JO_QUESTION2015-03-03
14090000238098L14/questions_ecrites1414090000238091140900002380912JO_QUESTION2015-06-16