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
17090000010039L17/questions_ecrites1717090000010035170900000100351JO_QUESTION2026-03-3120260013
17090000010100L17/questions_ecrites1717090000010094170900000100941JO_QUESTION2026-06-1620260024
17090000010125L17/questions_ecrites1717090000010121170900000101211JO_QUESTION2026-04-2820260017
17090000010134L17/questions_ecrites1717090000010130170900000101301JO_QUESTION2026-04-2120260016
17090000010177L17/questions_ecrites1717090000010172170900000101721JO_QUESTION2026-03-3120260013
17090000010178L17/questions_ecrites1717090000010172170900000101722JO_QUESTION2026-07-0720260027
17090000010202L17/questions_ecrites1717090000010198170900000101981JO_QUESTION2026-03-3120260013
17090000010214L17/questions_ecrites1717090000010210170900000102101JO_QUESTION2026-03-3120260013
17090000010249L17/questions_ecrites1717090000010244170900000102441JO_QUESTION2025-03-1120250010
17090000010274L17/questions_ecrites1717090000010270170900000102701JO_QUESTION2026-07-2820260030
17090000010340L17/questions_ecrites1717090000010335170900000103351JO_QUESTION2026-05-0520260018
17090000010367L17/questions_ecrites1717090000010364170900000103641JO_QUESTION2026-09-1520260037
17090000010376L17/questions_ecrites1717090000010372170900000103721JO_QUESTION2026-04-0720260014
17090000010481L17/questions_ecrites1717090000010477170900000104771JO_QUESTION2026-04-0720260014
17090000010525L17/questions_ecrites1717090000010520170900000105201JO_QUESTION2026-05-0520260018
17090000010526L17/questions_ecrites1717090000010520170900000105202JO_QUESTION2026-09-0820260036
17090000010567L17/questions_ecrites1717090000010563170900000105631JO_QUESTION2026-05-0520260018
17090000010574L17/questions_ecrites1717090000010568170900000105681JO_QUESTION2026-05-0520260018
17090000010599L17/questions_ecrites1717090000010596170900000105961JO_QUESTION2026-07-2120260029
17090000010635L17/questions_ecrites1717090000010632170900000106321JO_QUESTION2026-05-0520260018
17090000010636L17/questions_ecrites1717090000010632170900000106322JO_QUESTION2026-09-0820260036
17090000010689L17/questions_ecrites1717090000010686170900000106861JO_QUESTION2026-04-0720260014
17090000010690L17/questions_ecrites1717090000010686170900000106862JO_QUESTION2026-07-1420260028
17090000010771L17/questions_ecrites1717090000010767170900000107671JO_QUESTION2026-05-0520260018
17090000010802L17/questions_ecrites1717090000010798170900000107981JO_QUESTION2026-06-1620260024
17090000010807L17/questions_ecrites1717090000010803170900000108031JO_QUESTION2026-09-2220260038
17090000010831L17/questions_ecrites1717090000010828170900000108281JO_QUESTION2026-04-2120260016
17090000010832L17/questions_ecrites1717090000010828170900000108282JO_QUESTION2026-09-2920260039
17090000010871L17/questions_ecrites1717090000010866170900000108661JO_QUESTION2025-01-2820250004
17090000010919L17/questions_ecrites1717090000010914170900000109141JO_QUESTION2025-01-2820250004
17090000010939L17/questions_ecrites1717090000010935170900000109351JO_QUESTION2026-04-2120260016
17090000010969L17/questions_ecrites1717090000010964170900000109641JO_QUESTION2025-03-1120250010
17090000010985L17/questions_ecrites1717090000010981170900000109811JO_QUESTION2026-05-1220260019
17090000010998L17/questions_ecrites1717090000010994170900000109941JO_QUESTION2026-06-0220260022
17090000010999L17/questions_ecrites1717090000010994170900000109942JO_QUESTION2026-09-1520260037
17090000011008L17/questions_ecrites1717090000011004170900000110041JO_QUESTION2026-04-2120260016
17090000011020L17/questions_ecrites1717090000011013170900000110131JO_QUESTION2025-05-2720250021
17090000011066L17/questions_ecrites1717090000011060170900000110601JO_QUESTION2025-08-0520250031
17090000011067L17/questions_ecrites1717090000011060170900000110602JO_QUESTION2025-11-1120250045
17090000011095L17/questions_ecrites1717090000011091170900000110911JO_QUESTION2026-04-2120260016
17090000011239L17/questions_ecrites1717090000011235170900000112351JO_QUESTION2026-05-2620260021
17090000011282L17/questions_ecrites1717090000011278170900000112781JO_QUESTION2026-05-0520260018
17090000011311L17/questions_ecrites1717090000011308170900000113081JO_QUESTION2026-09-2220260038
17090000011315L17/questions_ecrites1717090000011312170900000113121JO_QUESTION2026-04-2120260016
17090000011316L17/questions_ecrites1717090000011312170900000113122JO_QUESTION2026-07-2820260030
17090000011325L17/questions_ecrites1717090000011322170900000113221JO_QUESTION2026-05-0520260018
17090000011326L17/questions_ecrites1717090000011322170900000113222JO_QUESTION2026-09-0120260035
17090000011337L17/questions_ecrites1717090000011334170900000113341JO_QUESTION2026-04-2120260016
17090000011338L17/questions_ecrites1717090000011334170900000113342JO_QUESTION2026-07-2820260030
17090000011401L17/questions_ecrites1717090000011398170900000113981JO_QUESTION2026-05-0520260018