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
17090000000011L17/questions_ecrites1717090000000005170900000000051JO_QUESTION2025-06-2420250025
17090000000017L17/questions_ecrites1717090000000012170900000000121JO_QUESTION2025-02-1120250006
17090000000040L17/questions_ecrites1717090000000033170900000000331JO_QUESTION2026-02-1720260007
17090000000237L17/questions_ecrites1717090000000229170900000002291JO_QUESTION2026-01-1320260002
17090000000260L17/questions_ecrites1717090000000255170900000002551JO_QUESTION2026-01-1320260002
17090000000261L17/questions_ecrites1717090000000255170900000002552JO_QUESTION2026-05-0520260018
17090000000262L17/questions_ecrites1717090000000255170900000002553JO_QUESTION2026-09-0120260035
17090000000293L17/questions_ecrites1717090000000287170900000002871JO_QUESTION2025-02-0420250005
17090000000337L17/questions_ecrites1717090000000330170900000003301JO_QUESTION2026-01-2720260004
17090000000423L17/questions_ecrites1717090000000416170900000004161JO_QUESTION2026-02-1020260006
17090000000483L17/questions_ecrites1717090000000477170900000004771JO_QUESTION2026-01-1320260002
17090000000484L17/questions_ecrites1717090000000477170900000004772JO_QUESTION2026-04-2120260016
17090000000491L17/questions_ecrites1717090000000485170900000004851JO_QUESTION2026-01-1320260002
17090000000539L17/questions_ecrites1717090000000533170900000005331JO_QUESTION2026-09-1520260037
17090000000553L17/questions_ecrites1717090000000546170900000005461JO_QUESTION2026-01-1320260002
17090000000554L17/questions_ecrites1717090000000546170900000005462JO_QUESTION2026-05-0520260018
17090000000555L17/questions_ecrites1717090000000546170900000005463JO_QUESTION2026-09-0120260035
17090000000561L17/questions_ecrites1717090000000556170900000005561JO_QUESTION2026-09-1520260037
17090000000600L17/questions_ecrites1717090000000594170900000005941JO_QUESTION2026-01-1320260002
17090000000607L17/questions_ecrites1717090000000601170900000006011JO_QUESTION2026-01-1320260002
17090000000608L17/questions_ecrites1717090000000601170900000006012JO_QUESTION2026-04-2120260016
17090000000638L17/questions_ecrites1717090000000633170900000006331JO_QUESTION2026-01-1320260002
17090000000639L17/questions_ecrites1717090000000633170900000006332JO_QUESTION2026-05-0520260018
17090000000640L17/questions_ecrites1717090000000633170900000006333JO_QUESTION2026-09-0120260035
17090000000659L17/questions_ecrites1717090000000654170900000006541JO_QUESTION2025-03-1120250010
17090000000710L17/questions_ecrites1717090000000702170900000007021JO_QUESTION2026-02-1020260006
17090000000740L17/questions_ecrites1717090000000733170900000007331JO_QUESTION2026-02-1020260006
17090000000819L17/questions_ecrites1717090000000814170900000008141JO_QUESTION2026-01-1320260002
17090000000820L17/questions_ecrites1717090000000814170900000008142JO_QUESTION2026-05-0520260018
17090000000821L17/questions_ecrites1717090000000814170900000008143JO_QUESTION2026-09-0120260035
17090000000860L17/questions_ecrites1717090000000854170900000008541JO_QUESTION2026-01-1320260002
17090000000875L17/questions_ecrites1717090000000866170900000008661JO_QUESTION2025-06-1020250023
17090000000924L17/questions_ecrites1717090000000919170900000009191JO_QUESTION2026-01-1320260002
17090000000925L17/questions_ecrites1717090000000919170900000009192JO_QUESTION2026-05-0520260018
17090000000926L17/questions_ecrites1717090000000919170900000009193JO_QUESTION2026-09-0120260035
17090000000943L17/questions_ecrites1717090000000937170900000009371JO_QUESTION2025-02-0420250005
17090000000944L17/questions_ecrites1717090000000937170900000009372JO_QUESTION2025-05-2720250021
17090000000945L17/questions_ecrites1717090000000937170900000009373JO_QUESTION2025-09-3020250039
17090000000946L17/questions_ecrites1717090000000937170900000009374JO_QUESTION2026-01-2720260004
17090000000947L17/questions_ecrites1717090000000937170900000009375JO_QUESTION2026-06-0220260022
17090000000948L17/questions_ecrites1717090000000937170900000009376JO_QUESTION2026-09-0820260036
17090000000960L17/questions_ecrites1717090000000954170900000009541JO_QUESTION2026-01-1320260002
17090000000961L17/questions_ecrites1717090000000954170900000009542JO_QUESTION2026-05-0520260018
17090000000992L17/questions_ecrites1717090000000986170900000009861JO_QUESTION2026-02-1020260006
17090000001008L17/questions_ecrites1717090000001003170900000010031JO_QUESTION2026-05-2620260021
17090000001024L17/questions_ecrites1717090000001019170900000010191JO_QUESTION2026-05-2620260021
17090000001035L17/questions_ecrites1717090000001030170900000010301JO_QUESTION2026-01-1320260002
17090000001036L17/questions_ecrites1717090000001030170900000010302JO_QUESTION2026-04-2120260016
17090000001037L17/questions_ecrites1717090000001030170900000010303JO_QUESTION2026-07-2820260030
17090000001043L17/questions_ecrites1717090000001038170900000010381JO_QUESTION2026-07-2120260029