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
14090000566052L14/questions_ecrites1414090000566037140900005660377JO_QUESTION2015-02-17
14090000566053L14/questions_ecrites1414090000566037140900005660378JO_QUESTION2015-05-26
14090000566054L14/questions_ecrites1414090000566037140900005660379JO_QUESTION2015-09-08
14090000566055L14/questions_ecrites14140900005660371409000056603710JO_QUESTION2016-02-23
14090000566056L14/questions_ecrites14140900005660371409000056603711JO_QUESTION2016-06-21
14090000566057L14/questions_ecrites14140900005660371409000056603712JO_QUESTION2016-09-27
14090000566058L14/questions_ecrites14140900005660371409000056603713JO_QUESTION2017-01-10
14090000566059L14/questions_ecrites14140900005660371409000056603714JO_QUESTION2017-05-02
14090000566095L14/questions_ecrites1414090000566090140900005660901JO_QUESTION2014-04-01
14090000566096L14/questions_ecrites1414090000566090140900005660902JO_QUESTION2014-07-15
14090000566110L14/questions_ecrites1414090000566106140900005661061JO_QUESTION2012-10-09
14090000566115L14/questions_ecrites1414090000566111140900005661111JO_QUESTION2015-03-03
14090000566116L14/questions_ecrites1414090000566111140900005661112JO_QUESTION2015-06-09
14090000566123L14/questions_ecrites1414090000566117140900005661171JO_QUESTION2014-09-16
14090000566139L14/questions_ecrites1414090000566134140900005661341JO_QUESTION2015-01-27
14090000566140L14/questions_ecrites1414090000566134140900005661342JO_QUESTION2015-05-12
14090000566160L14/questions_ecrites1414090000566155140900005661551JO_QUESTION2013-01-15
14090000566168L14/questions_ecrites1414090000566161140900005661611JO_QUESTION2014-10-28
14090000566169L14/questions_ecrites1414090000566161140900005661612JO_QUESTION2015-02-03
14090000566170L14/questions_ecrites1414090000566161140900005661613JO_QUESTION2015-06-23
14090000566171L14/questions_ecrites1414090000566161140900005661614JO_QUESTION2015-09-29
14090000566172L14/questions_ecrites1414090000566161140900005661615JO_QUESTION2016-01-05
14090000566173L14/questions_ecrites1414090000566161140900005661616JO_QUESTION2016-04-12
14090000566174L14/questions_ecrites1414090000566161140900005661617JO_QUESTION2016-07-12
14090000566175L14/questions_ecrites1414090000566161140900005661618JO_QUESTION2016-11-22
14090000566176L14/questions_ecrites1414090000566161140900005661619JO_QUESTION2017-02-28
14090000566199L14/questions_ecrites1414090000566194140900005661941JO_QUESTION2014-09-30
14090000566228L14/questions_ecrites1414090000566223140900005662231JO_QUESTION2015-03-24
14090000566229L14/questions_ecrites1414090000566223140900005662232JO_QUESTION2015-09-08
14090000566230L14/questions_ecrites1414090000566223140900005662233JO_QUESTION2015-12-22
14090000566231L14/questions_ecrites1414090000566223140900005662234JO_QUESTION2016-04-19
14090000566232L14/questions_ecrites1414090000566223140900005662235JO_QUESTION2016-07-26
14090000566266L14/questions_ecrites1414090000566260140900005662601JO_QUESTION2015-02-24
14090000566267L14/questions_ecrites1414090000566260140900005662602JO_QUESTION2015-06-30
14090000566295L14/questions_ecrites1414090000566289140900005662891JO_QUESTION2013-06-04
14090000566296L14/questions_ecrites1414090000566289140900005662892JO_QUESTION2014-02-11
14090000566321L14/questions_ecrites1414090000566317140900005663171JO_QUESTION2015-02-17
14090000566322L14/questions_ecrites1414090000566317140900005663172JO_QUESTION2015-05-26
14090000566323L14/questions_ecrites1414090000566317140900005663173JO_QUESTION2015-09-08
14090000566364L14/questions_ecrites1414090000566360140900005663601JO_QUESTION2013-07-30
14090000566365L14/questions_ecrites1414090000566360140900005663602JO_QUESTION2013-12-03
14090000566382L14/questions_ecrites1414090000566377140900005663771JO_QUESTION2014-11-11
14090000566383L14/questions_ecrites1414090000566377140900005663772JO_QUESTION2015-03-03
14090000566384L14/questions_ecrites1414090000566377140900005663773JO_QUESTION2015-08-04
14090000566408L14/questions_ecrites1414090000566403140900005664031JO_QUESTION2014-09-16
14090000566409L14/questions_ecrites1414090000566403140900005664032JO_QUESTION2015-01-20
14090000566410L14/questions_ecrites1414090000566403140900005664033JO_QUESTION2015-06-23
14090000566426L14/questions_ecrites1414090000566420140900005664201JO_QUESTION2015-02-17
14090000566427L14/questions_ecrites1414090000566420140900005664202JO_QUESTION2015-06-16
14090000566428L14/questions_ecrites1414090000566420140900005664203JO_QUESTION2016-01-19