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
14090000353218L14/questions_ecrites1414090000353203140900003532037JO_QUESTION2016-06-21
14090000353219L14/questions_ecrites1414090000353203140900003532038JO_QUESTION2016-09-27
14090000353220L14/questions_ecrites1414090000353203140900003532039JO_QUESTION2017-01-10
14090000353221L14/questions_ecrites14140900003532031409000035320310JO_QUESTION2017-05-02
14090000353256L14/questions_ecrites1414090000353247140900003532471JO_QUESTION2014-09-16
14090000353257L14/questions_ecrites1414090000353247140900003532472JO_QUESTION2015-01-20
14090000353258L14/questions_ecrites1414090000353247140900003532473JO_QUESTION2015-06-16
14090000353292L14/questions_ecrites1414090000353284140900003532841JO_QUESTION2015-02-17
14090000353322L14/questions_ecrites1414090000353315140900003533151JO_QUESTION2014-01-14
14090000353323L14/questions_ecrites1414090000353315140900003533152JO_QUESTION2014-09-09
14090000353342L14/questions_ecrites1414090000353336140900003533361JO_QUESTION2015-01-20
14090000353364L14/questions_ecrites1414090000353356140900003533561JO_QUESTION2015-02-17
14090000353365L14/questions_ecrites1414090000353356140900003533562JO_QUESTION2015-05-26
14090000353366L14/questions_ecrites1414090000353356140900003533563JO_QUESTION2015-09-08
14090000353367L14/questions_ecrites1414090000353356140900003533564JO_QUESTION2016-02-23
14090000353368L14/questions_ecrites1414090000353356140900003533565JO_QUESTION2016-06-21
14090000353369L14/questions_ecrites1414090000353356140900003533566JO_QUESTION2016-09-27
14090000353370L14/questions_ecrites1414090000353356140900003533567JO_QUESTION2017-01-10
14090000353371L14/questions_ecrites1414090000353356140900003533568JO_QUESTION2017-05-02
14090000353380L14/questions_ecrites1414090000353372140900003533721JO_QUESTION2014-01-14
14090000353381L14/questions_ecrites1414090000353372140900003533722JO_QUESTION2014-09-09
14090000353409L14/questions_ecrites1414090000353401140900003534011JO_QUESTION2013-03-12
14090000353410L14/questions_ecrites1414090000353401140900003534012JO_QUESTION2013-07-30
14090000353447L14/questions_ecrites1414090000353443140900003534431JO_QUESTION2013-01-29
14090000353482L14/questions_ecrites1414090000353474140900003534741JO_QUESTION2014-09-09
14090000353551L14/questions_ecrites1414090000353547140900003535471JO_QUESTION2013-10-29
14090000353563L14/questions_ecrites1414090000353556140900003535561JO_QUESTION2013-11-12
14090000353564L14/questions_ecrites1414090000353556140900003535562JO_QUESTION2014-02-18
14090000353565L14/questions_ecrites1414090000353556140900003535563JO_QUESTION2014-05-27
14090000353566L14/questions_ecrites1414090000353556140900003535564JO_QUESTION2014-09-09
14090000353573L14/questions_ecrites1414090000353567140900003535671JO_QUESTION2014-04-01
14090000353574L14/questions_ecrites1414090000353567140900003535672JO_QUESTION2014-10-14
14090000353597L14/questions_ecrites1414090000353590140900003535901JO_QUESTION2015-02-17
14090000353628L14/questions_ecrites1414090000353621140900003536211JO_QUESTION2013-02-12
14090000353634L14/questions_ecrites1414090000353629140900003536291JO_QUESTION2014-04-29
14090000353662L14/questions_ecrites1414090000353656140900003536561JO_QUESTION2015-02-10
14090000353668L14/questions_ecrites1414090000353663140900003536631JO_QUESTION2013-06-04
14090000353669L14/questions_ecrites1414090000353663140900003536632JO_QUESTION2013-09-24
14090000353670L14/questions_ecrites1414090000353663140900003536633JO_QUESTION2014-01-14
14090000353671L14/questions_ecrites1414090000353663140900003536634JO_QUESTION2014-11-04
14090000353672L14/questions_ecrites1414090000353663140900003536635JO_QUESTION2015-04-28
14090000353677L14/questions_ecrites1414090000353673140900003536731JO_QUESTION2013-02-26
14090000353715L14/questions_ecrites1414090000353710140900003537101JO_QUESTION2013-02-05
14090000353716L14/questions_ecrites1414090000353710140900003537102JO_QUESTION2013-05-28
14090000353717L14/questions_ecrites1414090000353710140900003537103JO_QUESTION2013-09-10
14090000353735L14/questions_ecrites1414090000353728140900003537281JO_QUESTION2013-07-30
14090000353736L14/questions_ecrites1414090000353728140900003537282JO_QUESTION2013-11-26
14090000353737L14/questions_ecrites1414090000353728140900003537283JO_QUESTION2014-03-11
14090000353738L14/questions_ecrites1414090000353728140900003537284JO_QUESTION2014-06-17
14090000353739L14/questions_ecrites1414090000353728140900003537285JO_QUESTION2014-06-17