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
14090000497484L14/questions_ecrites1414090000497477140900004974771JO_QUESTION2014-10-14
14090000497485L14/questions_ecrites1414090000497477140900004974772JO_QUESTION2015-01-20
14090000497486L14/questions_ecrites1414090000497477140900004974773JO_QUESTION2015-06-23
14090000497487L14/questions_ecrites1414090000497477140900004974774JO_QUESTION2015-09-29
14090000497488L14/questions_ecrites1414090000497477140900004974775JO_QUESTION2016-01-05
14090000497489L14/questions_ecrites1414090000497477140900004974776JO_QUESTION2016-04-12
14090000497490L14/questions_ecrites1414090000497477140900004974777JO_QUESTION2016-07-12
14090000497491L14/questions_ecrites1414090000497477140900004974778JO_QUESTION2016-11-22
14090000497492L14/questions_ecrites1414090000497477140900004974779JO_QUESTION2017-02-28
14090000497506L14/questions_ecrites1414090000497501140900004975011JO_QUESTION2014-10-21
14090000497515L14/questions_ecrites1414090000497507140900004975071JO_QUESTION2014-09-30
14090000497516L14/questions_ecrites1414090000497507140900004975072JO_QUESTION2015-10-06
14090000497517L14/questions_ecrites1414090000497507140900004975073JO_QUESTION2016-11-01
14090000497528L14/questions_ecrites1414090000497524140900004975241JO_QUESTION2017-06-13
14090000497559L14/questions_ecrites1414090000497555140900004975551JO_QUESTION2013-03-12
14090000497565L14/questions_ecrites1414090000497560140900004975601JO_QUESTION2014-02-11
14090000497566L14/questions_ecrites1414090000497560140900004975602JO_QUESTION2014-05-27
14090000497588L14/questions_ecrites1414090000497584140900004975841JO_QUESTION2013-07-09
14090000497589L14/questions_ecrites1414090000497584140900004975842JO_QUESTION2013-10-29
14090000497635L14/questions_ecrites1414090000497627140900004976271JO_QUESTION2015-02-17
14090000497654L14/questions_ecrites1414090000497649140900004976491JO_QUESTION2013-05-14
14090000497659L14/questions_ecrites1414090000497655140900004976551JO_QUESTION2013-02-26
14090000497660L14/questions_ecrites1414090000497655140900004976552JO_QUESTION2013-06-18
14090000497686L14/questions_ecrites1414090000497678140900004976781JO_QUESTION2014-09-09
14090000497709L14/questions_ecrites1414090000497701140900004977011JO_QUESTION2014-09-09
14090000497817L14/questions_ecrites1414090000497812140900004978121JO_QUESTION2013-07-23
14090000497818L14/questions_ecrites1414090000497812140900004978122JO_QUESTION2013-10-29
14090000497819L14/questions_ecrites1414090000497812140900004978123JO_QUESTION2014-02-11
14090000497820L14/questions_ecrites1414090000497812140900004978124JO_QUESTION2014-05-27
14090000497839L14/questions_ecrites1414090000497829140900004978291JO_QUESTION2013-09-24
14090000497840L14/questions_ecrites1414090000497829140900004978292JO_QUESTION2014-01-28
14090000497841L14/questions_ecrites1414090000497829140900004978293JO_QUESTION2014-05-20
14090000497858L14/questions_ecrites1414090000497850140900004978501JO_QUESTION2013-10-08
14090000497859L14/questions_ecrites1414090000497850140900004978502JO_QUESTION2014-02-11
14090000497860L14/questions_ecrites1414090000497850140900004978503JO_QUESTION2014-05-20
14090000497861L14/questions_ecrites1414090000497850140900004978504JO_QUESTION2014-09-23
14090000497862L14/questions_ecrites1414090000497850140900004978505JO_QUESTION2015-02-17
14090000497863L14/questions_ecrites1414090000497850140900004978506JO_QUESTION2015-05-26
14090000497864L14/questions_ecrites1414090000497850140900004978507JO_QUESTION2015-09-08
14090000497865L14/questions_ecrites1414090000497850140900004978508JO_QUESTION2016-02-23
14090000497866L14/questions_ecrites1414090000497850140900004978509JO_QUESTION2016-06-21
14090000497867L14/questions_ecrites14140900004978501409000049785010JO_QUESTION2016-09-27
14090000497868L14/questions_ecrites14140900004978501409000049785011JO_QUESTION2017-01-10
14090000497869L14/questions_ecrites14140900004978501409000049785012JO_QUESTION2017-05-02
14090000497881L14/questions_ecrites1414090000497874140900004978741JO_QUESTION2014-01-14
14090000497882L14/questions_ecrites1414090000497874140900004978742JO_QUESTION2014-09-09
14090000497919L14/questions_ecrites1414090000497914140900004979141JO_QUESTION2014-10-21
14090000497972L14/questions_ecrites1414090000497968140900004979681JO_QUESTION2013-05-28
14090000498023L14/questions_ecrites1414090000498017140900004980171JO_QUESTION2014-01-28
14090000498024L14/questions_ecrites1414090000498017140900004980172JO_QUESTION2014-05-20