AN · données ouvertes
Explorateur / questions_ecrites

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
14090000232026L14/questions_ecrites1414090000232021140900002320211JO_QUESTION2017-02-07
14090000232027L14/questions_ecrites1414090000232021140900002320212JO_QUESTION2017-06-13
14090000232053L14/questions_ecrites1414090000232048140900002320481JO_QUESTION2016-11-08
14090000232077L14/questions_ecrites1414090000232072140900002320721JO_QUESTION2016-10-18
14090000232078L14/questions_ecrites1414090000232072140900002320722JO_QUESTION2017-02-28
14090000232094L14/questions_ecrites1414090000232088140900002320881JO_QUESTION2016-10-11
14090000232103L14/questions_ecrites1414090000232099140900002320991JO_QUESTION2016-09-20
14090000232104L14/questions_ecrites1414090000232099140900002320992JO_QUESTION2017-01-03
14090000232130L14/questions_ecrites1414090000232124140900002321241JO_QUESTION2016-09-20
14090000232131L14/questions_ecrites1414090000232124140900002321242JO_QUESTION2017-01-24
14090000232300L14/questions_ecrites1414090000232294140900002322941JO_QUESTION2016-09-20
14090000232301L14/questions_ecrites1414090000232294140900002322942JO_QUESTION2017-01-24
14090000232302L14/questions_ecrites1414090000232294140900002322943JO_QUESTION2017-05-23
14090000232368L14/questions_ecrites1414090000232363140900002323631JO_QUESTION2016-09-20
14090000232369L14/questions_ecrites1414090000232363140900002323632JO_QUESTION2016-12-27
14090000232370L14/questions_ecrites1414090000232363140900002323633JO_QUESTION2017-04-04
14090000232382L14/questions_ecrites1414090000232376140900002323761JO_QUESTION2016-10-11
14090000232383L14/questions_ecrites1414090000232376140900002323762JO_QUESTION2017-03-07
14090000232416L14/questions_ecrites1414090000232410140900002324101JO_QUESTION2016-12-27
14090000232433L14/questions_ecrites1414090000232428140900002324281JO_QUESTION2016-09-27
14090000232434L14/questions_ecrites1414090000232428140900002324282JO_QUESTION2017-03-21
14090000232442L14/questions_ecrites1414090000232435140900002324351JO_QUESTION2016-09-27
14090000232463L14/questions_ecrites1414090000232458140900002324581JO_QUESTION2016-10-11
14090000232464L14/questions_ecrites1414090000232458140900002324582JO_QUESTION2017-05-23
14090000232553L14/questions_ecrites1414090000232548140900002325481JO_QUESTION2017-04-25
14090000232587L14/questions_ecrites1414090000232581140900002325811JO_QUESTION2016-10-18
14090000232588L14/questions_ecrites1414090000232581140900002325812JO_QUESTION2017-01-24
14090000232594L14/questions_ecrites1414090000232589140900002325891JO_QUESTION2016-11-01
14090000232595L14/questions_ecrites1414090000232589140900002325892JO_QUESTION2017-02-07
14090000232618L14/questions_ecrites1414090000232612140900002326121JO_QUESTION2016-12-20
14090000232661L14/questions_ecrites1414090000232656140900002326561JO_QUESTION2017-04-04
14090000232793L14/questions_ecrites1414090000232788140900002327881JO_QUESTION2017-01-17
14090000232808L14/questions_ecrites1414090000232802140900002328021JO_QUESTION2016-11-22
14090000232809L14/questions_ecrites1414090000232802140900002328022JO_QUESTION2017-02-28
14090000232896L14/questions_ecrites1414090000232891140900002328911JO_QUESTION2016-11-22
14090000232902L14/questions_ecrites1414090000232897140900002328971JO_QUESTION2017-03-21
14090000232908L14/questions_ecrites1414090000232903140900002329031JO_QUESTION2017-02-21
14090000232947L14/questions_ecrites1414090000232940140900002329401JO_QUESTION2017-02-21
14090000232953L14/questions_ecrites1414090000232948140900002329481JO_QUESTION2016-11-01
14090000232954L14/questions_ecrites1414090000232948140900002329482JO_QUESTION2017-02-07
14090000232963L14/questions_ecrites1414090000232955140900002329551JO_QUESTION2017-01-10
14090000232964L14/questions_ecrites1414090000232955140900002329552JO_QUESTION2017-04-18
14090000232970L14/questions_ecrites1414090000232965140900002329651JO_QUESTION2016-11-01
14090000232971L14/questions_ecrites1414090000232965140900002329652JO_QUESTION2017-02-07
14090000232993L14/questions_ecrites1414090000232987140900002329871JO_QUESTION2017-02-21
14090000233067L14/questions_ecrites1414090000233062140900002330621JO_QUESTION2016-10-18
14090000233068L14/questions_ecrites1414090000233062140900002330622JO_QUESTION2017-01-24
14090000233075L14/questions_ecrites1414090000233069140900002330691JO_QUESTION2016-11-08
14090000233076L14/questions_ecrites1414090000233069140900002330692JO_QUESTION2017-02-21
14090000233135L14/questions_ecrites1414090000233130140900002331301JO_QUESTION2017-03-21