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
14090000462916L14/questions_ecrites1414090000462904140900004629045JO_QUESTION2015-12-08
14090000462917L14/questions_ecrites1414090000462904140900004629046JO_QUESTION2016-03-15
14090000462918L14/questions_ecrites1414090000462904140900004629047JO_QUESTION2016-06-21
14090000462919L14/questions_ecrites1414090000462904140900004629048JO_QUESTION2016-09-27
14090000462920L14/questions_ecrites1414090000462904140900004629049JO_QUESTION2017-01-03
14090000462921L14/questions_ecrites14140900004629041409000046290410JO_QUESTION2017-04-11
14090000462968L14/questions_ecrites1414090000462960140900004629601JO_QUESTION2015-02-17
14090000462975L14/questions_ecrites1414090000462969140900004629691JO_QUESTION2014-09-23
14090000462980L14/questions_ecrites1414090000462976140900004629761JO_QUESTION2016-08-02
14090000462991L14/questions_ecrites1414090000462985140900004629851JO_QUESTION2013-05-28
14090000462992L14/questions_ecrites1414090000462985140900004629852JO_QUESTION2013-09-03
14090000462993L14/questions_ecrites1414090000462985140900004629853JO_QUESTION2013-12-17
14090000462994L14/questions_ecrites1414090000462985140900004629854JO_QUESTION2014-03-25
14090000463003L14/questions_ecrites1414090000462999140900004629991JO_QUESTION2013-03-19
14090000463023L14/questions_ecrites1414090000463016140900004630161JO_QUESTION2014-01-14
14090000463165L14/questions_ecrites1414090000463159140900004631591JO_QUESTION2015-06-30
14090000463179L14/questions_ecrites1414090000463175140900004631751JO_QUESTION2013-01-15
14090000463180L14/questions_ecrites1414090000463175140900004631752JO_QUESTION2013-04-23
14090000463202L14/questions_ecrites1414090000463197140900004631971JO_QUESTION2013-10-01
14090000463203L14/questions_ecrites1414090000463197140900004631972JO_QUESTION2014-02-04
14090000463204L14/questions_ecrites1414090000463197140900004631973JO_QUESTION2014-06-17
14090000463205L14/questions_ecrites1414090000463197140900004631974JO_QUESTION2014-06-17
14090000463228L14/questions_ecrites1414090000463223140900004632231JO_QUESTION2013-07-09
14090000463233L14/questions_ecrites1414090000463229140900004632291JO_QUESTION2015-03-03
14090000463240L14/questions_ecrites1414090000463234140900004632341JO_QUESTION2014-05-20
14090000463241L14/questions_ecrites1414090000463234140900004632342JO_QUESTION2014-08-26
14090000463280L14/questions_ecrites1414090000463272140900004632721JO_QUESTION2013-07-23
14090000463281L14/questions_ecrites1414090000463272140900004632722JO_QUESTION2013-10-29
14090000463282L14/questions_ecrites1414090000463272140900004632723JO_QUESTION2014-02-18
14090000463283L14/questions_ecrites1414090000463272140900004632724JO_QUESTION2014-05-27
14090000463284L14/questions_ecrites1414090000463272140900004632725JO_QUESTION2014-09-02
14090000463285L14/questions_ecrites1414090000463272140900004632726JO_QUESTION2015-01-20
14090000463286L14/questions_ecrites1414090000463272140900004632727JO_QUESTION2015-06-09
14090000463287L14/questions_ecrites1414090000463272140900004632728JO_QUESTION2015-09-15
14090000463288L14/questions_ecrites1414090000463272140900004632729JO_QUESTION2015-09-15
14090000463289L14/questions_ecrites14140900004632721409000046327210JO_QUESTION2015-12-22
14090000463290L14/questions_ecrites14140900004632721409000046327211JO_QUESTION2016-03-29
14090000463291L14/questions_ecrites14140900004632721409000046327212JO_QUESTION2016-07-12
14090000463322L14/questions_ecrites1414090000463318140900004633181JO_QUESTION2013-03-19
14090000463323L14/questions_ecrites1414090000463318140900004633182JO_QUESTION2013-06-25
14090000463324L14/questions_ecrites1414090000463318140900004633183JO_QUESTION2013-10-01
14090000463349L14/questions_ecrites1414090000463344140900004633441JO_QUESTION2014-08-19
14090000463350L14/questions_ecrites1414090000463344140900004633442JO_QUESTION2014-12-09
14090000463378L14/questions_ecrites1414090000463373140900004633731JO_QUESTION2014-09-09
14090000463384L14/questions_ecrites1414090000463379140900004633791JO_QUESTION2015-09-08
14090000463395L14/questions_ecrites1414090000463389140900004633891JO_QUESTION2014-01-14
14090000463396L14/questions_ecrites1414090000463389140900004633892JO_QUESTION2014-09-09
14090000463513L14/questions_ecrites1414090000463509140900004635091JO_QUESTION2012-11-13
14090000463514L14/questions_ecrites1414090000463509140900004635092JO_QUESTION2013-02-19
14090000463515L14/questions_ecrites1414090000463509140900004635093JO_QUESTION2013-05-28