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
17090000090157L17/questions_ecrites1717090000090150170900000901502JO_QUESTION2026-04-2120260016
17090000090158L17/questions_ecrites1717090000090150170900000901503JO_QUESTION2026-07-2820260030
17090000090196L17/questions_ecrites1717090000090191170900000901911JO_QUESTION2026-01-1320260002
17090000090203L17/questions_ecrites1717090000090197170900000901971JO_QUESTION2026-02-1720260007
17090000090256L17/questions_ecrites1717090000090250170900000902501JO_QUESTION2026-01-0620260001
17090000090257L17/questions_ecrites1717090000090250170900000902502JO_QUESTION2026-04-1420260015
17090000090279L17/questions_ecrites1717090000090270170900000902701JO_QUESTION2026-01-2720260004
17090000090286L17/questions_ecrites1717090000090280170900000902801JO_QUESTION2026-01-2720260004
17090000090292L17/questions_ecrites1717090000090287170900000902871JO_QUESTION2026-01-2720260004
17090000090293L17/questions_ecrites1717090000090287170900000902872JO_QUESTION2026-06-0220260022
17090000090294L17/questions_ecrites1717090000090287170900000902873JO_QUESTION2026-09-0820260036
17090000090318L17/questions_ecrites1717090000090312170900000903121JO_QUESTION2026-01-2720260004
17090000090377L17/questions_ecrites1717090000090368170900000903681JO_QUESTION2026-03-0320260009
17090000090400L17/questions_ecrites1717090000090394170900000903941JO_QUESTION2026-01-0620260001
17090000090401L17/questions_ecrites1717090000090394170900000903942JO_QUESTION2026-04-1420260015
17090000090402L17/questions_ecrites1717090000090394170900000903943JO_QUESTION2026-07-2120260029
17090000090409L17/questions_ecrites1717090000090403170900000904031JO_QUESTION2026-02-1720260007
17090000090420L17/questions_ecrites1717090000090415170900000904151JO_QUESTION2026-01-1320260002
17090000090421L17/questions_ecrites1717090000090415170900000904152JO_QUESTION2026-04-2120260016
17090000090422L17/questions_ecrites1717090000090415170900000904153JO_QUESTION2026-09-2920260039
17090000090440L17/questions_ecrites1717090000090434170900000904341JO_QUESTION2025-02-0420250005
17090000090441L17/questions_ecrites1717090000090434170900000904342JO_QUESTION2025-05-2720250021
17090000090442L17/questions_ecrites1717090000090434170900000904343JO_QUESTION2025-09-3020250039
17090000090443L17/questions_ecrites1717090000090434170900000904344JO_QUESTION2026-01-2720260004
17090000090444L17/questions_ecrites1717090000090434170900000904345JO_QUESTION2026-06-0220260022
17090000090445L17/questions_ecrites1717090000090434170900000904346JO_QUESTION2026-09-0820260036
17090000090470L17/questions_ecrites1717090000090464170900000904641JO_QUESTION2026-01-2720260004
17090000090507L17/questions_ecrites1717090000090502170900000905021JO_QUESTION2026-01-1320260002
17090000090508L17/questions_ecrites1717090000090502170900000905022JO_QUESTION2026-04-2120260016
17090000090509L17/questions_ecrites1717090000090502170900000905023JO_QUESTION2026-07-2820260030
17090000090523L17/questions_ecrites1717090000090516170900000905161JO_QUESTION2026-01-2720260004
17090000090568L17/questions_ecrites1717090000090561170900000905611JO_QUESTION2026-02-1720260007
17090000090576L17/questions_ecrites1717090000090569170900000905691JO_QUESTION2026-04-1420260015
17090000090596L17/questions_ecrites1717090000090589170900000905891JO_QUESTION2026-01-1320260002
17090000090609L17/questions_ecrites1717090000090602170900000906021JO_QUESTION2026-01-2720260004
17090000090622L17/questions_ecrites1717090000090616170900000906161JO_QUESTION2026-04-1420260015
17090000090623L17/questions_ecrites1717090000090616170900000906162JO_QUESTION2026-09-2920260039
16090000000013L16/questions_ecrites1616090000000009160900000000091JO_QUESTION2022-10-2520220042
16090000000030L16/questions_ecrites1616090000000023160900000000231JO_QUESTION2023-10-1720230042
16090000000031L16/questions_ecrites1616090000000023160900000000232JO_QUESTION2024-01-2320240004
16090000000032L16/questions_ecrites1616090000000023160900000000233JO_QUESTION2024-06-0420240023
16090000000055L16/questions_ecrites1616090000000049160900000000491JO_QUESTION2024-03-1220240011
16090000000063L16/questions_ecrites1616090000000056160900000000561JO_QUESTION2024-04-1620240016
16090000000116L16/questions_ecrites1616090000000109160900000001091JO_QUESTION2023-10-2420230043
16090000000157L16/questions_ecrites1616090000000151160900000001511JO_QUESTION2023-12-2620230052
16090000000164L16/questions_ecrites1616090000000158160900000001581JO_QUESTION2024-02-2720240009
16090000000181L16/questions_ecrites1616090000000176160900000001761JO_QUESTION2024-02-2720240009
16090000000182L16/questions_ecrites1616090000000176160900000001762JO_QUESTION2024-06-1120240024
16090000000226L16/questions_ecrites1616090000000221160900000002211JO_QUESTION2023-10-2420230043
16090000000227L16/questions_ecrites1616090000000221160900000002212JO_QUESTION2024-02-0620240006