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
14090000437826L14/questions_ecrites1414090000437813140900004378137JO_QUESTION2016-11-22
14090000437827L14/questions_ecrites1414090000437813140900004378138JO_QUESTION2017-02-28
14090000437832L14/questions_ecrites1414090000437828140900004378281JO_QUESTION2012-12-18
14090000437837L14/questions_ecrites1414090000437833140900004378331JO_QUESTION2013-09-17
14090000437871L14/questions_ecrites1414090000437865140900004378651JO_QUESTION2012-12-25
14090000437872L14/questions_ecrites1414090000437865140900004378652JO_QUESTION2013-04-02
14090000437873L14/questions_ecrites1414090000437865140900004378653JO_QUESTION2013-07-09
14090000437874L14/questions_ecrites1414090000437865140900004378654JO_QUESTION2013-10-15
14090000437875L14/questions_ecrites1414090000437865140900004378655JO_QUESTION2014-01-21
14090000437876L14/questions_ecrites1414090000437865140900004378656JO_QUESTION2014-04-29
14090000437885L14/questions_ecrites1414090000437877140900004378771JO_QUESTION2015-02-17
14090000437900L14/questions_ecrites1414090000437894140900004378941JO_QUESTION2013-06-11
14090000437901L14/questions_ecrites1414090000437894140900004378942JO_QUESTION2013-09-24
14090000437902L14/questions_ecrites1414090000437894140900004378943JO_QUESTION2014-01-28
14090000437903L14/questions_ecrites1414090000437894140900004378944JO_QUESTION2014-05-20
14090000437912L14/questions_ecrites1414090000437908140900004379081JO_QUESTION2017-03-21
14090000437917L14/questions_ecrites1414090000437913140900004379131JO_QUESTION2013-03-12
14090000437918L14/questions_ecrites1414090000437913140900004379132JO_QUESTION2013-07-09
14090000437927L14/questions_ecrites1414090000437923140900004379231JO_QUESTION2013-06-25
14090000437928L14/questions_ecrites1414090000437923140900004379232JO_QUESTION2013-10-08
14090000437937L14/questions_ecrites1414090000437933140900004379331JO_QUESTION2013-02-26
14090000437938L14/questions_ecrites1414090000437933140900004379332JO_QUESTION2013-06-04
14090000437949L14/questions_ecrites1414090000437943140900004379431JO_QUESTION2015-07-14
14090000437950L14/questions_ecrites1414090000437943140900004379432JO_QUESTION2015-12-01
14090000437959L14/questions_ecrites1414090000437951140900004379511JO_QUESTION2013-10-29
14090000437973L14/questions_ecrites1414090000437964140900004379641JO_QUESTION2014-04-15
14090000437974L14/questions_ecrites1414090000437964140900004379642JO_QUESTION2014-09-30
14090000437975L14/questions_ecrites1414090000437964140900004379643JO_QUESTION2015-03-24
14090000438009L14/questions_ecrites1414090000438001140900004380011JO_QUESTION2015-01-13
14090000438014L14/questions_ecrites1414090000438010140900004380101JO_QUESTION2013-06-04
14090000438015L14/questions_ecrites1414090000438010140900004380102JO_QUESTION2013-09-24
14090000438039L14/questions_ecrites1414090000438033140900004380331JO_QUESTION2015-06-23
14090000438040L14/questions_ecrites1414090000438033140900004380332JO_QUESTION2016-02-23
14090000438041L14/questions_ecrites1414090000438033140900004380333JO_QUESTION2016-06-21
14090000438042L14/questions_ecrites1414090000438033140900004380334JO_QUESTION2016-09-27
14090000438043L14/questions_ecrites1414090000438033140900004380335JO_QUESTION2017-01-10
14090000438044L14/questions_ecrites1414090000438033140900004380336JO_QUESTION2017-05-02
14090000438049L14/questions_ecrites1414090000438045140900004380451JO_QUESTION2015-05-19
14090000438076L14/questions_ecrites1414090000438071140900004380711JO_QUESTION2015-06-02
14090000438077L14/questions_ecrites1414090000438071140900004380712JO_QUESTION2015-10-20
14090000438078L14/questions_ecrites1414090000438071140900004380713JO_QUESTION2016-02-09
14090000438079L14/questions_ecrites1414090000438071140900004380714JO_QUESTION2016-05-17
14090000438080L14/questions_ecrites1414090000438071140900004380715JO_QUESTION2016-09-13
14090000438113L14/questions_ecrites1414090000438107140900004381071JO_QUESTION2015-02-17
14090000438153L14/questions_ecrites1414090000438147140900004381471JO_QUESTION2015-09-15
14090000438154L14/questions_ecrites1414090000438147140900004381472JO_QUESTION2015-09-15
14090000438175L14/questions_ecrites1414090000438170140900004381701JO_QUESTION2015-06-30
14090000438189L14/questions_ecrites1414090000438184140900004381841JO_QUESTION2014-10-07
14090000438190L14/questions_ecrites1414090000438184140900004381842JO_QUESTION2015-03-03
14090000438208L14/questions_ecrites1414090000438204140900004382041JO_QUESTION2017-05-09