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
14090000405315L14/questions_ecrites1414090000405309140900004053092JO_QUESTION2015-03-03
14090000405340L14/questions_ecrites1414090000405333140900004053331JO_QUESTION2014-11-18
14090000405341L14/questions_ecrites1414090000405333140900004053332JO_QUESTION2015-02-17
14090000405342L14/questions_ecrites1414090000405333140900004053333JO_QUESTION2015-06-02
14090000405343L14/questions_ecrites1414090000405333140900004053334JO_QUESTION2015-10-13
14090000405344L14/questions_ecrites1414090000405333140900004053335JO_QUESTION2016-05-31
14090000405361L14/questions_ecrites1414090000405353140900004053531JO_QUESTION2015-02-17
14090000405380L14/questions_ecrites1414090000405372140900004053721JO_QUESTION2014-01-28
14090000405381L14/questions_ecrites1414090000405372140900004053722JO_QUESTION2014-09-09
14090000405382L14/questions_ecrites1414090000405372140900004053723JO_QUESTION2015-07-21
14090000405447L14/questions_ecrites1414090000405443140900004054431JO_QUESTION2015-02-03
14090000405448L14/questions_ecrites1414090000405443140900004054432JO_QUESTION2015-06-23
14090000405461L14/questions_ecrites1414090000405453140900004054531JO_QUESTION2015-04-07
14090000405462L14/questions_ecrites1414090000405453140900004054532JO_QUESTION2015-07-21
14090000405463L14/questions_ecrites1414090000405453140900004054533JO_QUESTION2015-10-27
14090000405464L14/questions_ecrites1414090000405453140900004054534JO_QUESTION2016-02-02
14090000405465L14/questions_ecrites1414090000405453140900004054535JO_QUESTION2016-02-02
14090000405466L14/questions_ecrites1414090000405453140900004054536JO_QUESTION2016-05-24
14090000405467L14/questions_ecrites1414090000405453140900004054537JO_QUESTION2016-09-20
14090000405468L14/questions_ecrites1414090000405453140900004054538JO_QUESTION2017-01-31
14090000405485L14/questions_ecrites1414090000405481140900004054811JO_QUESTION2013-07-09
14090000405508L14/questions_ecrites1414090000405503140900004055031JO_QUESTION2014-04-22
14090000405539L14/questions_ecrites1414090000405532140900004055321JO_QUESTION2014-11-11
14090000405540L14/questions_ecrites1414090000405532140900004055322JO_QUESTION2015-03-03
14090000405541L14/questions_ecrites1414090000405532140900004055323JO_QUESTION2015-08-04
14090000405542L14/questions_ecrites1414090000405532140900004055324JO_QUESTION2016-08-02
14090000405543L14/questions_ecrites1414090000405532140900004055325JO_QUESTION2017-05-23
14090000405568L14/questions_ecrites1414090000405561140900004055611JO_QUESTION2014-04-15
14090000405569L14/questions_ecrites1414090000405561140900004055612JO_QUESTION2014-09-30
14090000405570L14/questions_ecrites1414090000405561140900004055613JO_QUESTION2015-03-24
14090000405590L14/questions_ecrites1414090000405583140900004055831JO_QUESTION2012-12-25
14090000405591L14/questions_ecrites1414090000405583140900004055832JO_QUESTION2013-04-02
14090000405592L14/questions_ecrites1414090000405583140900004055833JO_QUESTION2013-07-09
14090000405593L14/questions_ecrites1414090000405583140900004055834JO_QUESTION2013-10-15
14090000405594L14/questions_ecrites1414090000405583140900004055835JO_QUESTION2014-01-21
14090000405595L14/questions_ecrites1414090000405583140900004055836JO_QUESTION2014-04-29
14090000405596L14/questions_ecrites1414090000405583140900004055837JO_QUESTION2014-08-05
14090000405597L14/questions_ecrites1414090000405583140900004055838JO_QUESTION2014-11-11
14090000405598L14/questions_ecrites1414090000405583140900004055839JO_QUESTION2015-02-17
14090000405599L14/questions_ecrites14140900004055831409000040558310JO_QUESTION2015-05-26
14090000405600L14/questions_ecrites14140900004055831409000040558311JO_QUESTION2015-09-01
14090000405601L14/questions_ecrites14140900004055831409000040558312JO_QUESTION2015-12-08
14090000405602L14/questions_ecrites14140900004055831409000040558313JO_QUESTION2016-03-15
14090000405603L14/questions_ecrites14140900004055831409000040558314JO_QUESTION2016-06-21
14090000405631L14/questions_ecrites1414090000405625140900004056251JO_QUESTION2015-01-20
14090000405632L14/questions_ecrites1414090000405625140900004056252JO_QUESTION2015-06-23
14090000405633L14/questions_ecrites1414090000405625140900004056253JO_QUESTION2015-09-29
14090000405634L14/questions_ecrites1414090000405625140900004056254JO_QUESTION2016-01-05
14090000405635L14/questions_ecrites1414090000405625140900004056255JO_QUESTION2016-04-12
14090000405636L14/questions_ecrites1414090000405625140900004056256JO_QUESTION2016-07-12