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
16090000000228L16/questions_ecrites1616090000000221160900000002213JO_QUESTION2024-05-2120240021
16090000000314L16/questions_ecrites1616090000000309160900000003091JO_QUESTION2024-04-3020240018
16090000000335L16/questions_ecrites1616090000000327160900000003271JO_QUESTION2023-11-0720230045
16090000000336L16/questions_ecrites1616090000000327160900000003272JO_QUESTION2024-02-1320240007
16090000000370L16/questions_ecrites1616090000000363160900000003631JO_QUESTION2024-02-2020240008
16090000000371L16/questions_ecrites1616090000000363160900000003632JO_QUESTION2024-06-0420240023
16090000000377L16/questions_ecrites1616090000000372160900000003721JO_QUESTION2023-12-1220230050
16090000000378L16/questions_ecrites1616090000000372160900000003722JO_QUESTION2024-06-1120240024
16090000000397L16/questions_ecrites1616090000000392160900000003921JO_QUESTION2023-10-2420230043
16090000000398L16/questions_ecrites1616090000000392160900000003922JO_QUESTION2024-03-1220240011
16090000000421L16/questions_ecrites1616090000000416160900000004161JO_QUESTION2023-12-0520230049
16090000000456L16/questions_ecrites1616090000000452160900000004521JO_QUESTION2024-02-2020240008
16090000000457L16/questions_ecrites1616090000000452160900000004522JO_QUESTION2024-06-0420240023
16090000000471L16/questions_ecrites1616090000000466160900000004661JO_QUESTION2024-03-1220240011
16090000000477L16/questions_ecrites1616090000000472160900000004721JO_QUESTION2024-03-1220240011
16090000000487L16/questions_ecrites1616090000000483160900000004831JO_QUESTION2023-11-1420230046
16090000000494L16/questions_ecrites1616090000000488160900000004881JO_QUESTION2023-10-2420230043
16090000000495L16/questions_ecrites1616090000000488160900000004882JO_QUESTION2024-01-3020240005
16090000000496L16/questions_ecrites1616090000000488160900000004883JO_QUESTION2024-05-1420240020
16090000000507L16/questions_ecrites1616090000000503160900000005031JO_QUESTION2023-10-2420230043
16090000000574L16/questions_ecrites1616090000000570160900000005701JO_QUESTION2023-10-2420230043
16090000000584L16/questions_ecrites1616090000000580160900000005801JO_QUESTION2023-10-2420230043
16090000000591L16/questions_ecrites1616090000000585160900000005851JO_QUESTION2023-10-3120230044
16090000000628L16/questions_ecrites1616090000000621160900000006211JO_QUESTION2023-10-3120230044
16090000000629L16/questions_ecrites1616090000000621160900000006212JO_QUESTION2024-02-0620240006
16090000000715L16/questions_ecrites1616090000000710160900000007101JO_QUESTION2023-10-2420230043
16090000000749L16/questions_ecrites1616090000000745160900000007451JO_QUESTION2024-01-2320240004
16090000000819L16/questions_ecrites1616090000000813160900000008131JO_QUESTION2023-10-3120230044
16090000000832L16/questions_ecrites1616090000000826160900000008261JO_QUESTION2023-10-2420230043
16090000000833L16/questions_ecrites1616090000000826160900000008262JO_QUESTION2024-02-2020240008
16090000000868L16/questions_ecrites1616090000000862160900000008621JO_QUESTION2023-10-2420230043
16090000000869L16/questions_ecrites1616090000000862160900000008622JO_QUESTION2024-04-0920240015
16090000000903L16/questions_ecrites1616090000000898160900000008981JO_QUESTION2023-10-3120230044
16090000000904L16/questions_ecrites1616090000000898160900000008982JO_QUESTION2024-02-2020240008
16090000000929L16/questions_ecrites1616090000000923160900000009231JO_QUESTION2023-10-2420230043
16090000000988L16/questions_ecrites1616090000000981160900000009811JO_QUESTION2024-02-1320240007
16090000001018L16/questions_ecrites1616090000001013160900000010131JO_QUESTION2023-11-0720230045
16090000001028L16/questions_ecrites1616090000001024160900000010241JO_QUESTION2023-11-0720230045
16090000001029L16/questions_ecrites1616090000001024160900000010242JO_QUESTION2024-02-2720240009
16090000001071L16/questions_ecrites1616090000001064160900000010641JO_QUESTION2023-10-2420230043
16090000001072L16/questions_ecrites1616090000001064160900000010642JO_QUESTION2024-01-3020240005
16090000001073L16/questions_ecrites1616090000001064160900000010643JO_QUESTION2024-05-0720240019
16090000001084L16/questions_ecrites1616090000001078160900000010781JO_QUESTION2024-04-3020240018
16090000001105L16/questions_ecrites1616090000001100160900000011001JO_QUESTION2024-03-1220240011
16090000001111L16/questions_ecrites1616090000001106160900000011061JO_QUESTION2023-12-2620230052
16090000001176L16/questions_ecrites1616090000001169160900000011691JO_QUESTION2023-10-3120230044
16090000001208L16/questions_ecrites1616090000001200160900000012001JO_QUESTION2024-03-1220240011
16090000001214L16/questions_ecrites1616090000001209160900000012091JO_QUESTION2023-10-2420230043
16090000001222L16/questions_ecrites1616090000001215160900000012151JO_QUESTION2024-06-0420240023
16090000001259L16/questions_ecrites1616090000001255160900000012551JO_QUESTION2023-10-2420230043