Aller au contenu
blackout

questions_ecrites.question_renouvellement

Chemin question.renouvellements.renouvellement · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %

85 297 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
14090000334311L14/questions_ecrites1414090000334302140900003343022JO_QUESTION2014-05-20
14090000334428L14/questions_ecrites1414090000334423140900003344231JO_QUESTION2014-10-14
14090000334493L14/questions_ecrites1414090000334487140900003344871JO_QUESTION2014-12-09
14090000334507L14/questions_ecrites1414090000334503140900003345031JO_QUESTION2013-03-19
14090000334526L14/questions_ecrites1414090000334521140900003345211JO_QUESTION2015-10-27
14090000334633L14/questions_ecrites1414090000334624140900003346241JO_QUESTION2014-03-04
14090000334657L14/questions_ecrites1414090000334644140900003346441JO_QUESTION2014-05-27
14090000334658L14/questions_ecrites1414090000334644140900003346442JO_QUESTION2014-09-23
14090000334665L14/questions_ecrites1414090000334659140900003346591JO_QUESTION2013-12-03
14090000334698L14/questions_ecrites1414090000334691140900003346911JO_QUESTION2014-08-26
14090000334699L14/questions_ecrites1414090000334691140900003346912JO_QUESTION2014-12-02
14090000334700L14/questions_ecrites1414090000334691140900003346913JO_QUESTION2015-03-10
14090000334747L14/questions_ecrites1414090000334741140900003347411JO_QUESTION2015-09-15
14090000334748L14/questions_ecrites1414090000334741140900003347412JO_QUESTION2015-09-15
14090000334761L14/questions_ecrites1414090000334753140900003347531JO_QUESTION2014-10-21
14090000334762L14/questions_ecrites1414090000334753140900003347532JO_QUESTION2015-03-03
14090000334763L14/questions_ecrites1414090000334753140900003347533JO_QUESTION2015-08-04
14090000334779L14/questions_ecrites1414090000334775140900003347751JO_QUESTION2014-08-19
14090000334780L14/questions_ecrites1414090000334775140900003347752JO_QUESTION2014-12-09
14090000334781L14/questions_ecrites1414090000334775140900003347753JO_QUESTION2015-05-19
14090000334792L14/questions_ecrites1414090000334786140900003347861JO_QUESTION2014-12-16
14090000334810L14/questions_ecrites1414090000334806140900003348061JO_QUESTION2013-07-30
14090000334811L14/questions_ecrites1414090000334806140900003348062JO_QUESTION2013-11-26
14090000334821L14/questions_ecrites1414090000334816140900003348161JO_QUESTION2012-10-23
14090000334826L14/questions_ecrites1414090000334822140900003348221JO_QUESTION2012-12-25
14090000334832L14/questions_ecrites1414090000334827140900003348271JO_QUESTION2014-09-02
14090000334833L14/questions_ecrites1414090000334827140900003348272JO_QUESTION2015-02-17
14090000334834L14/questions_ecrites1414090000334827140900003348273JO_QUESTION2015-09-22
14090000334857L14/questions_ecrites1414090000334853140900003348531JO_QUESTION2013-04-02
14090000334864L14/questions_ecrites1414090000334858140900003348581JO_QUESTION2013-12-03
14090000334919L14/questions_ecrites1414090000334913140900003349131JO_QUESTION2013-04-30
14090000334971L14/questions_ecrites1414090000334963140900003349631JO_QUESTION2015-02-17
14090000334980L14/questions_ecrites1414090000334976140900003349761JO_QUESTION2013-06-25
14090000334981L14/questions_ecrites1414090000334976140900003349762JO_QUESTION2013-10-08
14090000334982L14/questions_ecrites1414090000334976140900003349763JO_QUESTION2014-02-11
14090000334983L14/questions_ecrites1414090000334976140900003349764JO_QUESTION2014-05-20
14090000335038L14/questions_ecrites1414090000335031140900003350311JO_QUESTION2015-04-28
14090000335039L14/questions_ecrites1414090000335031140900003350312JO_QUESTION2016-04-12
14090000335057L14/questions_ecrites1414090000335051140900003350511JO_QUESTION2015-10-20
14090000335058L14/questions_ecrites1414090000335051140900003350512JO_QUESTION2016-11-01
14090000335088L14/questions_ecrites1414090000335080140900003350801JO_QUESTION2014-12-16
14090000335110L14/questions_ecrites1414090000335106140900003351061JO_QUESTION2013-07-30
14090000335133L14/questions_ecrites1414090000335128140900003351281JO_QUESTION2014-03-11
14090000335134L14/questions_ecrites1414090000335128140900003351282JO_QUESTION2014-03-11
14090000335135L14/questions_ecrites1414090000335128140900003351283JO_QUESTION2014-06-17
14090000335136L14/questions_ecrites1414090000335128140900003351284JO_QUESTION2014-06-17
14090000335173L14/questions_ecrites1414090000335165140900003351651JO_QUESTION2013-01-01
14090000335174L14/questions_ecrites1414090000335165140900003351652JO_QUESTION2013-04-16
14090000335175L14/questions_ecrites1414090000335165140900003351653JO_QUESTION2013-07-30
14090000335176L14/questions_ecrites1414090000335165140900003351654JO_QUESTION2013-11-05