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
17090000053140L17/questions_ecrites1717090000053134170900000531341JO_QUESTION2025-05-2720250021
17090000053141L17/questions_ecrites1717090000053134170900000531342JO_QUESTION2025-09-0220250035
17090000053173L17/questions_ecrites1717090000053166170900000531661JO_QUESTION2025-05-2720250021
17090000053184L17/questions_ecrites1717090000053178170900000531781JO_QUESTION2025-07-0120250026
17090000053247L17/questions_ecrites1717090000053243170900000532431JO_QUESTION2025-06-2420250025
17090000053273L17/questions_ecrites1717090000053269170900000532691JO_QUESTION2025-07-0820250027
17090000053290L17/questions_ecrites1717090000053284170900000532841JO_QUESTION2025-07-0120250026
17090000053324L17/questions_ecrites1717090000053318170900000533181JO_QUESTION2025-07-0120250026
17090000053364L17/questions_ecrites1717090000053358170900000533581JO_QUESTION2026-01-1320260002
17090000053371L17/questions_ecrites1717090000053365170900000533651JO_QUESTION2025-06-0320250022
17090000053372L17/questions_ecrites1717090000053365170900000533652JO_QUESTION2025-09-0920250036
17090000053445L17/questions_ecrites1717090000053439170900000534391JO_QUESTION2025-06-2420250025
17090000053446L17/questions_ecrites1717090000053439170900000534392JO_QUESTION2025-11-1120250045
17090000053461L17/questions_ecrites1717090000053454170900000534541JO_QUESTION2025-05-2720250021
17090000053536L17/questions_ecrites1717090000053532170900000535321JO_QUESTION2025-07-0120250026
17090000053610L17/questions_ecrites1717090000053602170900000536021JO_QUESTION2025-07-0820250027
17090000053628L17/questions_ecrites1717090000053621170900000536211JO_QUESTION2025-05-2720250021
17090000053664L17/questions_ecrites1717090000053658170900000536581JO_QUESTION2025-01-2820250004
17090000053665L17/questions_ecrites1717090000053658170900000536582JO_QUESTION2025-05-0620250018
17090000053674L17/questions_ecrites1717090000053670170900000536701JO_QUESTION2025-06-0320250022
17090000053755L17/questions_ecrites1717090000053748170900000537481JO_QUESTION2025-10-2820250043
17090000053756L17/questions_ecrites1717090000053748170900000537482JO_QUESTION2026-02-1020260006
17090000053792L17/questions_ecrites1717090000053788170900000537881JO_QUESTION2025-06-2420250025
17090000053850L17/questions_ecrites1717090000053842170900000538421JO_QUESTION2025-09-3020250039
17090000053876L17/questions_ecrites1717090000053868170900000538681JO_QUESTION2025-07-0120250026
17090000053920L17/questions_ecrites1717090000053915170900000539151JO_QUESTION2025-10-2120250042
17090000053925L17/questions_ecrites1717090000053921170900000539211JO_QUESTION2025-06-0320250022
17090000053939L17/questions_ecrites1717090000053934170900000539341JO_QUESTION2025-01-2820250004
17090000053940L17/questions_ecrites1717090000053934170900000539342JO_QUESTION2025-05-0620250018
17090000053970L17/questions_ecrites1717090000053966170900000539661JO_QUESTION2025-06-2420250025
17090000053979L17/questions_ecrites1717090000053975170900000539751JO_QUESTION2025-05-2720250021
17090000054005L17/questions_ecrites1717090000053999170900000539991JO_QUESTION2025-07-0120250026
17090000054087L17/questions_ecrites1717090000054081170900000540811JO_QUESTION2025-05-2720250021
17090000054088L17/questions_ecrites1717090000054081170900000540812JO_QUESTION2025-09-0920250036
17090000054089L17/questions_ecrites1717090000054081170900000540813JO_QUESTION2025-12-1620250050
17090000054090L17/questions_ecrites1717090000054081170900000540814JO_QUESTION2026-03-2420260012
17090000054110L17/questions_ecrites1717090000054104170900000541041JO_QUESTION2025-05-2720250021
17090000054132L17/questions_ecrites1717090000054127170900000541271JO_QUESTION2025-01-2120250003
17090000054147L17/questions_ecrites1717090000054141170900000541411JO_QUESTION2025-07-0820250027
17090000054164L17/questions_ecrites1717090000054156170900000541561JO_QUESTION2025-05-2720250021
17090000054165L17/questions_ecrites1717090000054156170900000541562JO_QUESTION2025-09-3020250039
17090000054166L17/questions_ecrites1717090000054156170900000541563JO_QUESTION2026-01-2720260004
17090000054180L17/questions_ecrites1717090000054175170900000541751JO_QUESTION2025-05-2720250021
17090000054186L17/questions_ecrites1717090000054181170900000541811JO_QUESTION2025-06-0320250022
17090000054198L17/questions_ecrites1717090000054192170900000541921JO_QUESTION2025-07-0120250026
17090000054244L17/questions_ecrites1717090000054239170900000542391JO_QUESTION2025-06-0320250022
17090000054245L17/questions_ecrites1717090000054239170900000542392JO_QUESTION2025-11-0420250044
17090000054246L17/questions_ecrites1717090000054239170900000542393JO_QUESTION2026-04-2120260016
17090000054247L17/questions_ecrites1717090000054239170900000542394JO_QUESTION2026-08-0420260031
17090000054300L17/questions_ecrites1717090000054295170900000542951JO_QUESTION2025-06-1720250024