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
17090000054318L17/questions_ecrites1717090000054314170900000543141JO_QUESTION2025-05-2720250021
17090000054365L17/questions_ecrites1717090000054360170900000543601JO_QUESTION2025-01-2120250003
17090000054366L17/questions_ecrites1717090000054360170900000543602JO_QUESTION2025-04-2920250017
17090000054383L17/questions_ecrites1717090000054379170900000543791JO_QUESTION2025-07-0820250027
17090000054392L17/questions_ecrites1717090000054388170900000543881JO_QUESTION2025-06-0320250022
17090000054457L17/questions_ecrites1717090000054452170900000544521JO_QUESTION2025-10-2120250042
17090000054469L17/questions_ecrites1717090000054464170900000544641JO_QUESTION2025-01-2820250004
17090000054524L17/questions_ecrites1717090000054516170900000545161JO_QUESTION2026-05-2620260021
17090000054532L17/questions_ecrites1717090000054525170900000545251JO_QUESTION2025-12-0220250048
17090000054698L17/questions_ecrites1717090000054692170900000546921JO_QUESTION2025-06-1720250024
17090000054699L17/questions_ecrites1717090000054692170900000546922JO_QUESTION2025-10-2820250043
17090000054742L17/questions_ecrites1717090000054736170900000547361JO_QUESTION2025-10-2120250042
17090000054763L17/questions_ecrites1717090000054757170900000547571JO_QUESTION2025-09-0920250036
17090000054769L17/questions_ecrites1717090000054764170900000547641JO_QUESTION2025-02-1120250006
17090000054801L17/questions_ecrites1717090000054794170900000547941JO_QUESTION2025-12-1620250050
17090000054802L17/questions_ecrites1717090000054794170900000547942JO_QUESTION2026-05-2620260021
17090000054862L17/questions_ecrites1717090000054856170900000548561JO_QUESTION2025-10-2120250042
17090000054908L17/questions_ecrites1717090000054901170900000549011JO_QUESTION2025-06-0320250022
17090000054909L17/questions_ecrites1717090000054901170900000549012JO_QUESTION2025-11-0420250044
17090000054932L17/questions_ecrites1717090000054926170900000549261JO_QUESTION2025-06-1020250023
17090000054933L17/questions_ecrites1717090000054926170900000549262JO_QUESTION2025-09-3020250039
17090000054956L17/questions_ecrites1717090000054948170900000549481JO_QUESTION2025-01-2120250003
17090000054957L17/questions_ecrites1717090000054948170900000549482JO_QUESTION2025-04-2920250017
17090000054958L17/questions_ecrites1717090000054948170900000549483JO_QUESTION2025-08-0520250031
17090000054976L17/questions_ecrites1717090000054969170900000549691JO_QUESTION2025-10-2120250042
17090000055002L17/questions_ecrites1717090000054997170900000549971JO_QUESTION2025-06-0320250022
17090000055007L17/questions_ecrites1717090000055003170900000550031JO_QUESTION2025-06-0320250022
17090000055062L17/questions_ecrites1717090000055056170900000550561JO_QUESTION2025-06-2420250025
17090000055063L17/questions_ecrites1717090000055056170900000550562JO_QUESTION2025-10-2120250042
17090000055064L17/questions_ecrites1717090000055056170900000550563JO_QUESTION2026-01-2720260004
17090000055065L17/questions_ecrites1717090000055056170900000550564JO_QUESTION2026-05-0520260018
17090000055118L17/questions_ecrites1717090000055111170900000551111JO_QUESTION2025-11-1120250045
17090000055130L17/questions_ecrites1717090000055123170900000551231JO_QUESTION2026-01-0620260001
17090000055143L17/questions_ecrites1717090000055136170900000551361JO_QUESTION2025-01-2120250003
17090000055144L17/questions_ecrites1717090000055136170900000551362JO_QUESTION2025-04-2920250017
17090000055145L17/questions_ecrites1717090000055136170900000551363JO_QUESTION2025-08-0520250031
17090000055146L17/questions_ecrites1717090000055136170900000551364JO_QUESTION2025-11-1120250045
17090000055147L17/questions_ecrites1717090000055136170900000551365JO_QUESTION2026-02-1720260007
17090000055148L17/questions_ecrites1717090000055136170900000551366JO_QUESTION2026-05-2620260021
17090000055149L17/questions_ecrites1717090000055136170900000551367JO_QUESTION2026-09-0120260035
17090000055206L17/questions_ecrites1717090000055200170900000552001JO_QUESTION2025-06-1020250023
17090000055333L17/questions_ecrites1717090000055326170900000553261JO_QUESTION2025-03-1820250011
17090000055334L17/questions_ecrites1717090000055326170900000553262JO_QUESTION2026-05-2620260021
17090000055345L17/questions_ecrites1717090000055339170900000553391JO_QUESTION2025-12-1620250050
17090000055346L17/questions_ecrites1717090000055339170900000553392JO_QUESTION2026-05-2620260021
17090000055492L17/questions_ecrites1717090000055488170900000554881JO_QUESTION2025-06-0320250022
17090000055497L17/questions_ecrites1717090000055493170900000554931JO_QUESTION2025-06-1020250023
17090000055506L17/questions_ecrites1717090000055498170900000554981JO_QUESTION2026-09-2220260038
17090000055526L17/questions_ecrites1717090000055520170900000555201JO_QUESTION2025-06-2420250025
17090000055527L17/questions_ecrites1717090000055520170900000555202JO_QUESTION2026-01-2720260004