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
14090000465059L14/questions_ecrites1414090000465043140900004650439JO_QUESTION2016-07-05
14090000465060L14/questions_ecrites14140900004650431409000046504310JO_QUESTION2016-10-11
14090000465069L14/questions_ecrites1414090000465061140900004650611JO_QUESTION2014-09-09
14090000465138L14/questions_ecrites1414090000465134140900004651341JO_QUESTION2015-02-03
14090000465146L14/questions_ecrites1414090000465139140900004651391JO_QUESTION2014-11-18
14090000465147L14/questions_ecrites1414090000465139140900004651392JO_QUESTION2015-03-10
14090000465148L14/questions_ecrites1414090000465139140900004651393JO_QUESTION2015-06-23
14090000465165L14/questions_ecrites1414090000465159140900004651591JO_QUESTION2013-06-04
14090000465166L14/questions_ecrites1414090000465159140900004651592JO_QUESTION2014-02-18
14090000465195L14/questions_ecrites1414090000465189140900004651891JO_QUESTION2013-09-03
14090000465207L14/questions_ecrites1414090000465200140900004652001JO_QUESTION2014-11-11
14090000465208L14/questions_ecrites1414090000465200140900004652002JO_QUESTION2015-03-03
14090000465209L14/questions_ecrites1414090000465200140900004652003JO_QUESTION2015-08-04
14090000465210L14/questions_ecrites1414090000465200140900004652004JO_QUESTION2016-08-02
14090000465211L14/questions_ecrites1414090000465200140900004652005JO_QUESTION2017-05-23
14090000465223L14/questions_ecrites1414090000465216140900004652161JO_QUESTION2013-06-04
14090000465224L14/questions_ecrites1414090000465216140900004652162JO_QUESTION2013-09-24
14090000465225L14/questions_ecrites1414090000465216140900004652163JO_QUESTION2014-01-14
14090000465226L14/questions_ecrites1414090000465216140900004652164JO_QUESTION2014-04-22
14090000465227L14/questions_ecrites1414090000465216140900004652165JO_QUESTION2014-09-16
14090000465228L14/questions_ecrites1414090000465216140900004652166JO_QUESTION2014-12-23
14090000465229L14/questions_ecrites1414090000465216140900004652167JO_QUESTION2015-04-21
14090000465230L14/questions_ecrites1414090000465216140900004652168JO_QUESTION2015-08-04
14090000465266L14/questions_ecrites1414090000465255140900004652551JO_QUESTION2013-10-29
14090000465267L14/questions_ecrites1414090000465255140900004652552JO_QUESTION2014-03-04
14090000465268L14/questions_ecrites1414090000465255140900004652553JO_QUESTION2014-06-10
14090000465281L14/questions_ecrites1414090000465273140900004652731JO_QUESTION2013-12-31
14090000465282L14/questions_ecrites1414090000465273140900004652732JO_QUESTION2014-05-06
14090000465283L14/questions_ecrites1414090000465273140900004652733JO_QUESTION2014-12-02
14090000465284L14/questions_ecrites1414090000465273140900004652734JO_QUESTION2015-05-19
14090000465295L14/questions_ecrites1414090000465289140900004652891JO_QUESTION2014-06-10
14090000465296L14/questions_ecrites1414090000465289140900004652892JO_QUESTION2014-09-23
14090000465297L14/questions_ecrites1414090000465289140900004652893JO_QUESTION2015-02-17
14090000465298L14/questions_ecrites1414090000465289140900004652894JO_QUESTION2015-05-26
14090000465323L14/questions_ecrites1414090000465318140900004653181JO_QUESTION2013-11-19
14090000465341L14/questions_ecrites1414090000465336140900004653361JO_QUESTION2016-01-26
14090000465351L14/questions_ecrites1414090000465347140900004653471JO_QUESTION2013-02-12
14090000465363L14/questions_ecrites1414090000465357140900004653571JO_QUESTION2014-10-14
14090000465364L14/questions_ecrites1414090000465357140900004653572JO_QUESTION2015-01-20
14090000465430L14/questions_ecrites1414090000465420140900004654201JO_QUESTION2014-05-13
14090000465431L14/questions_ecrites1414090000465420140900004654202JO_QUESTION2014-08-26
14090000465432L14/questions_ecrites1414090000465420140900004654203JO_QUESTION2014-12-02
14090000465433L14/questions_ecrites1414090000465420140900004654204JO_QUESTION2015-03-10
14090000465434L14/questions_ecrites1414090000465420140900004654205JO_QUESTION2015-06-23
14090000465435L14/questions_ecrites1414090000465420140900004654206JO_QUESTION2015-09-29
14090000465436L14/questions_ecrites1414090000465420140900004654207JO_QUESTION2016-01-05
14090000465437L14/questions_ecrites1414090000465420140900004654208JO_QUESTION2016-04-12
14090000465438L14/questions_ecrites1414090000465420140900004654209JO_QUESTION2016-07-19
14090000465439L14/questions_ecrites14140900004654201409000046542010JO_QUESTION2016-10-25
14090000465440L14/questions_ecrites14140900004654201409000046542011JO_QUESTION2017-01-31