Aller au contenu
blackout

questions_ecrites.question_renouvellement

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

85 044 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
14090000288764L14/questions_ecrites1414090000288754140900002887543JO_QUESTION2015-02-17
14090000288765L14/questions_ecrites1414090000288754140900002887544JO_QUESTION2015-05-26
14090000288766L14/questions_ecrites1414090000288754140900002887545JO_QUESTION2015-09-08
14090000288767L14/questions_ecrites1414090000288754140900002887546JO_QUESTION2016-02-23
14090000288768L14/questions_ecrites1414090000288754140900002887547JO_QUESTION2016-06-21
14090000288769L14/questions_ecrites1414090000288754140900002887548JO_QUESTION2016-09-27
14090000288770L14/questions_ecrites1414090000288754140900002887549JO_QUESTION2017-01-10
14090000288771L14/questions_ecrites14140900002887541409000028875410JO_QUESTION2017-05-02
14090000288785L14/questions_ecrites1414090000288778140900002887781JO_QUESTION2014-01-14
14090000288786L14/questions_ecrites1414090000288778140900002887782JO_QUESTION2014-09-09
14090000288799L14/questions_ecrites1414090000288792140900002887921JO_QUESTION2014-09-16
14090000288800L14/questions_ecrites1414090000288792140900002887922JO_QUESTION2014-12-23
14090000288801L14/questions_ecrites1414090000288792140900002887923JO_QUESTION2015-04-21
14090000288802L14/questions_ecrites1414090000288792140900002887924JO_QUESTION2015-08-04
14090000288803L14/questions_ecrites1414090000288792140900002887925JO_QUESTION2016-08-02
14090000288804L14/questions_ecrites1414090000288792140900002887926JO_QUESTION2017-05-23
14090000288837L14/questions_ecrites1414090000288829140900002888291JO_QUESTION2015-07-07
14090000288838L14/questions_ecrites1414090000288829140900002888292JO_QUESTION2016-06-21
14090000288853L14/questions_ecrites1414090000288848140900002888481JO_QUESTION2014-05-13
14090000288887L14/questions_ecrites1414090000288879140900002888791JO_QUESTION2013-01-29
14090000288888L14/questions_ecrites1414090000288879140900002888792JO_QUESTION2013-06-25
14090000288889L14/questions_ecrites1414090000288879140900002888793JO_QUESTION2013-10-01
14090000288890L14/questions_ecrites1414090000288879140900002888794JO_QUESTION2014-01-07
14090000288891L14/questions_ecrites1414090000288879140900002888795JO_QUESTION2014-04-15
14090000288892L14/questions_ecrites1414090000288879140900002888796JO_QUESTION2014-07-22
14090000288893L14/questions_ecrites1414090000288879140900002888797JO_QUESTION2014-10-28
14090000288894L14/questions_ecrites1414090000288879140900002888798JO_QUESTION2015-02-03
14090000288895L14/questions_ecrites1414090000288879140900002888799JO_QUESTION2015-05-12
14090000288896L14/questions_ecrites14140900002888791409000028887910JO_QUESTION2016-04-26
14090000288897L14/questions_ecrites14140900002888791409000028887911JO_QUESTION2017-05-09
14090000288935L14/questions_ecrites1414090000288930140900002889301JO_QUESTION2014-02-25
14090000288941L14/questions_ecrites1414090000288936140900002889361JO_QUESTION2014-07-22
14090000288942L14/questions_ecrites1414090000288936140900002889362JO_QUESTION2014-12-02
14090000288943L14/questions_ecrites1414090000288936140900002889363JO_QUESTION2015-06-16
14090000288944L14/questions_ecrites1414090000288936140900002889364JO_QUESTION2015-09-29
14090000288966L14/questions_ecrites1414090000288958140900002889581JO_QUESTION2014-10-07
14090000288967L14/questions_ecrites1414090000288958140900002889582JO_QUESTION2015-01-20
14090000288968L14/questions_ecrites1414090000288958140900002889583JO_QUESTION2015-05-12
14090000288969L14/questions_ecrites1414090000288958140900002889584JO_QUESTION2015-09-01
14090000288970L14/questions_ecrites1414090000288958140900002889585JO_QUESTION2015-12-08
14090000288971L14/questions_ecrites1414090000288958140900002889586JO_QUESTION2016-03-15
14090000288972L14/questions_ecrites1414090000288958140900002889587JO_QUESTION2016-06-21
14090000288973L14/questions_ecrites1414090000288958140900002889588JO_QUESTION2016-09-27
14090000288986L14/questions_ecrites1414090000288979140900002889791JO_QUESTION2014-12-16
14090000289016L14/questions_ecrites1414090000289009140900002890091JO_QUESTION2014-10-28
14090000289017L14/questions_ecrites1414090000289009140900002890092JO_QUESTION2015-02-03
14090000289018L14/questions_ecrites1414090000289009140900002890093JO_QUESTION2015-05-12
14090000289019L14/questions_ecrites1414090000289009140900002890094JO_QUESTION2016-04-26
14090000289063L14/questions_ecrites1414090000289055140900002890551JO_QUESTION2014-01-28
14090000289064L14/questions_ecrites1414090000289055140900002890552JO_QUESTION2014-06-17