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
17090000062033L17/questions_ecrites1717090000062028170900000620281JO_QUESTION2025-01-2820250004
17090000062176L17/questions_ecrites1717090000062167170900000621671JO_QUESTION2025-07-0820250027
17090000062189L17/questions_ecrites1717090000062181170900000621811JO_QUESTION2025-10-2120250042
17090000062274L17/questions_ecrites1717090000062268170900000622681JO_QUESTION2026-01-2720260004
17090000062275L17/questions_ecrites1717090000062268170900000622682JO_QUESTION2026-06-1620260024
17090000062282L17/questions_ecrites1717090000062276170900000622761JO_QUESTION2025-10-2120250042
17090000062375L17/questions_ecrites1717090000062369170900000623691JO_QUESTION2025-11-0420250044
17090000062410L17/questions_ecrites1717090000062404170900000624041JO_QUESTION2026-02-1020260006
17090000062423L17/questions_ecrites1717090000062417170900000624171JO_QUESTION2026-03-0320260009
17090000062430L17/questions_ecrites1717090000062424170900000624241JO_QUESTION2025-07-1520250028
17090000062431L17/questions_ecrites1717090000062424170900000624242JO_QUESTION2025-10-2120250042
17090000062432L17/questions_ecrites1717090000062424170900000624243JO_QUESTION2026-01-2720260004
17090000062433L17/questions_ecrites1717090000062424170900000624244JO_QUESTION2026-05-1220260019
17090000062434L17/questions_ecrites1717090000062424170900000624245JO_QUESTION2026-09-2220260038
17090000062498L17/questions_ecrites1717090000062491170900000624911JO_QUESTION2025-09-3020250039
17090000062542L17/questions_ecrites1717090000062538170900000625381JO_QUESTION2025-07-2220250029
17090000062596L17/questions_ecrites1717090000062589170900000625891JO_QUESTION2025-05-2720250021
17090000062651L17/questions_ecrites1717090000062646170900000626461JO_QUESTION2025-02-1120250006
17090000062681L17/questions_ecrites1717090000062675170900000626751JO_QUESTION2025-10-2120250042
17090000062773L17/questions_ecrites1717090000062769170900000627691JO_QUESTION2025-08-0520250031
17090000062917L17/questions_ecrites1717090000062913170900000629131JO_QUESTION2025-07-1520250028
17090000062946L17/questions_ecrites1717090000062940170900000629401JO_QUESTION2025-11-1120250045
17090000062947L17/questions_ecrites1717090000062940170900000629402JO_QUESTION2026-05-1220260019
17090000062948L17/questions_ecrites1717090000062940170900000629403JO_QUESTION2026-08-1820260033
17090000062955L17/questions_ecrites1717090000062949170900000629491JO_QUESTION2026-02-1020260006
17090000063000L17/questions_ecrites1717090000062995170900000629951JO_QUESTION2025-07-2220250029
17090000063001L17/questions_ecrites1717090000062995170900000629952JO_QUESTION2025-10-2820250043
17090000063002L17/questions_ecrites1717090000062995170900000629953JO_QUESTION2026-02-0320260005
17090000063003L17/questions_ecrites1717090000062995170900000629954JO_QUESTION2026-05-1220260019
17090000063004L17/questions_ecrites1717090000062995170900000629955JO_QUESTION2026-09-0120260035
17090000063011L17/questions_ecrites1717090000063005170900000630051JO_QUESTION2026-06-2320260025
17090000063112L17/questions_ecrites1717090000063106170900000631061JO_QUESTION2025-07-2920250030
17090000063113L17/questions_ecrites1717090000063106170900000631062JO_QUESTION2025-11-2520250047
17090000063114L17/questions_ecrites1717090000063106170900000631063JO_QUESTION2026-03-0320260009
17090000063289L17/questions_ecrites1717090000063283170900000632831JO_QUESTION2025-07-2220250029
17090000063323L17/questions_ecrites1717090000063318170900000633181JO_QUESTION2025-07-2920250030
17090000063324L17/questions_ecrites1717090000063318170900000633182JO_QUESTION2025-11-2520250047
17090000063325L17/questions_ecrites1717090000063318170900000633183JO_QUESTION2026-03-0320260009
17090000063326L17/questions_ecrites1717090000063318170900000633184JO_QUESTION2026-07-2820260030
17090000063404L17/questions_ecrites1717090000063398170900000633981JO_QUESTION2025-02-0420250005
17090000063405L17/questions_ecrites1717090000063398170900000633982JO_QUESTION2025-06-2420250025
17090000063406L17/questions_ecrites1717090000063398170900000633983JO_QUESTION2026-01-1320260002
17090000063407L17/questions_ecrites1717090000063398170900000633984JO_QUESTION2026-06-1620260024
17090000063565L17/questions_ecrites1717090000063561170900000635611JO_QUESTION2025-07-2220250029
17090000063581L17/questions_ecrites1717090000063574170900000635741JO_QUESTION2025-01-2820250004
17090000063582L17/questions_ecrites1717090000063574170900000635742JO_QUESTION2025-05-0620250018
17090000063583L17/questions_ecrites1717090000063574170900000635743JO_QUESTION2025-08-1220250032
17090000063671L17/questions_ecrites1717090000063666170900000636661JO_QUESTION2025-09-0920250036
17090000063701L17/questions_ecrites1717090000063695170900000636951JO_QUESTION2025-01-2820250004
17090000063722L17/questions_ecrites1717090000063718170900000637181JO_QUESTION2025-07-2220250029